This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28323 | 28323 | 1913-12-27 | 3 | b | Prince of Germany might be forced to divorce. | Germany | http://trove.nla.gov.au/newspaper/page/24092936 | 24092936 | |
28324 | 28324 | 1913-12-27 | 3 | b | Revolutionary army in Mexico kill foreigners. | Other... | http://trove.nla.gov.au/newspaper/page/24092936 | 24092936 | |
28325 | 28325 | 1913-12-27 | 3 | b | Britain has built new warships. | Britain | http://trove.nla.gov.au/newspaper/page/24092936 | 24092936 | |
28326 | 28326 | 1913-12-27 | 3 | b | Japan disagrees to withdraw their troops from Beijing and Tianjin. | Britain | http://trove.nla.gov.au/newspaper/page/24092936 | 24092936 | |
28327 | 28327 | 1913-12-27 | 3 | b | French government in heavy debt. | Britain | http://trove.nla.gov.au/newspaper/page/24092936 | 24092936 | |
28328 | 28328 | 1913-12-27 | 3 | b | American warship has an accident. | Britain | http://trove.nla.gov.au/newspaper/page/24092936 | 24092936 | |
28338 | 28338 | 1913-12-27 | 6 | b | Government redundancy in Beijing and the result. | China | http://trove.nla.gov.au/newspaper/page/24092941 | 24092941 | |
28339 | 28339 | 1913-12-27 | 6 | b | Crisis in Tibet (joint meeting of Britain, China and Tibet is postponed, Dalai Lama sends envoy to London, British people start construction of the road between Tibet and India). | China | http://trove.nla.gov.au/newspaper/page/24092941 | 24092941 | |
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]);