This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29454 | 29454 | 1914-12-12 | 2 | a-b | Editorial by the Tung Wah Times claims that China should start moral education. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093354 | 24093354 | |
29463 | 29463 | 1914-12-12 | 6 | a-b | Miscellaneous report on the Chinese politics and officialdom. | China | http://trove.nla.gov.au/newspaper/page/24093358 | 24093358 | |
29465 | 29465 | 1914-12-12 | 7 | a-b | Australia news/ Population increases in New South Wales. White opium addict dies in Sydney. Three Chinese gardeners are robbed in Sydney. Chinese fellows in Australia are advised to remain neutral (to the World War I). Chinese returned from Noumea, New Caledonia, on their life there. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093357 | 24093357 | |
29468 | 29468 | 1914-12-12 | 8 | a-b | Report: A trip to the hell (a revolutionary rebel in Kaiping county are executed by his partners). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093360 | 24093360 |
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]);