This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25163 | 25163 | 1911-10-21 | 2 | c-d | Japanese Asian Association | Japanese Asia Association aims to expand invasions of Japan in Asia. | Russia | http://trove.nla.gov.au/newspaper/page/24091967 | 24091967 |
25169 | 25169 | 1911-10-21 | 3 | c-d | Guangdong news | Portugal ships still stay on sea close to Guangdong. More foreign debts of Guangdong. Names of Guangdong students selected to study in America. Governor of Guangdong advises central government not to change its policy on nationalisation of railways. Governor of Guangdong may be changed. Serious flooding in Jiajing, Guangdong. Rescue relief is called for flooding in Xiangpu, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24091966 | 24091966 |
25180 | 25180 | 1911-10-21 | 8 | c-d | Notice of Company of Guang-Han Railway | Income balance of Company of Guang-Han Railway and name list of initiators of the Company. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091973 | 24091973 |
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]);