This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28322 | 28322 | 1913-12-27 | 3 | a-b | American warships intervene with the chaos in Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24092936 | 24092936 | |
28337 | 28337 | 1913-12-27 | 6 | a-b | Zhang Qian (Jizhi) and his plan for industrial development in China. | China | http://trove.nla.gov.au/newspaper/page/24092941 | 24092941 | |
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 | |
28344 | 28344 | 1913-12-27 | 8 | a-b | Chinese President Yuan Shikai appoints Chen Qi chief supervisor for the Panama Exhibition. | China | 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]);