This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31160 | 31160 | 1916-04-22 | 6 | a-b | Miscellaneous report from China. | China | http://trove.nla.gov.au/newspaper/page/24095240 | 24095240 | |
31163 | 31163 | 1916-04-22 | 7 | a-b | Australia news/ A Chinese garden in Sydney is burglarised and the case. A Chinese man who married a Western girl is sentenced and his life in the Sydney prison. A white woman is arrested in New South Wales for wearing military uniform. About 20 woman workers in Melbourne are poisoned by fish and chips. Gold production in New South Wales and the statistics. | Australia | http://trove.nla.gov.au/newspaper/page/24095239 | 24095239 | |
31167 | 31167 | 1916-04-22 | 8 | a-b | Beijing news/ Saving the Nation Army (hu guo jun) are on the way to Guangxi. Government troops are defeated in southern Sichuan province. Feng Yuxiang stays in Nanjing. Financial situation in Hunan province. Chongqing declares independence. Long Jiguang and his troops are in Yunnan. | China | http://trove.nla.gov.au/newspaper/page/24095242 | 24095242 |
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]);