This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28331 | 28331 | 1913-12-27 | 3 | c | Chinese government appoints Lu Bingtian new consul-general to Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092936 | 24092936 | |
28340 | 28340 | 1913-12-27 | 7 | a-b | Australia news/ Examination in the Chinese School and the result. Smallpox in Sydney. Acting Chinese consul-general in Melbourne Mai Xixiang (William Ah Ket) reports that Chinese passenger Peng Yusheng disappears on the way from Hong Kong to Sydney by Japanese liner. A Chinese market garden in Sydney is robbed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092940 | 24092940 | |
28341 | 28341 | 1913-12-27 | 7 | b | A visit to Noumea, the biggest town in New Caledonia, and Chinese and Vietnamese immigrants there. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092940 | 24092940 | |
28345 | 28345 | 1913-12-27 | 8 | b | Construction of a railway in the Far East of Russia and the report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092943 | 24092943 |
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]);