This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45389 | 45389 | 1926-12-25 | 7 | a-b | Australia news/ Sydney Chinese School and the Chamber of Commerce farewell Luo Fuquan, teacher of the school, on his return to China. Two Chinese are punished in Sydney for opium smoking. Baby girl found abandoned in Sydney. Weather forecast for the Christmas holiday. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24101827 | 24101827 | |
45390 | 45390 | 1926-12-25 | 7 | c-d | Miscellaneous report on the crisis in China. | China | http://trove.nla.gov.au/newspaper/page/24101827 | 24101827 |
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]);