This data as json, CSV (advanced)
Suggested facets: source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
29466 | 29466 | 1914-12-12 | 7 | b | Military conflict in Mexico between revolutionary army and government troops. | Other... | http://trove.nla.gov.au/newspaper/page/24093357 | 24093357 | |
29467 | 29467 | 1914-12-12 | 7 | c | Chinese Association (zhong hua hui guan) in New Zealand donates to the flood victims in Guangdong and their names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093357 | 24093357 |
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]);