This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27238 | 27238 | 1913-04-05 | 7 | a | Shanghai China Bank's letter about receipt of Australian donations to saving China. | Other... | http://trove.nla.gov.au/newspaper/page/24092636 | 24092636 | |
27239 | 27239 | 1913-04-05 | 7 | a | Chinese consul general's note to Sydney Branch for Donations to Saving China about its last collection of donations. | Other... | http://trove.nla.gov.au/newspaper/page/24092636 | 24092636 | |
27240 | 27240 | 1913-04-05 | 7 | a-b | Australian news/ Number of work force in Sydney. Tram accident in Sydney. Chinese with mental problem arrested for destroying public property. Sydney Chinese gamblers caught and fined. Chinese using false money case dismissed. | Other... | http://trove.nla.gov.au/newspaper/page/24092636 | 24092636 |
JSON shape: default, array, newline-delimited
CREATE TABLE [article_index] ( [date] TEXT, [page] TEXT, [column] TEXT, [title] TEXT, [description] TEXT, [source] TEXT, [page_url] TEXT, [trove_id] TEXT ); CREATE INDEX [idx_article_index_date] ON [article_index] ([date]);