This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29259 | 29259 | 1914-09-26 | 2 | b-c | Fourth part of the new civil service system in China. | China | http://trove.nla.gov.au/newspaper/page/24093262 | 24093262 | |
29263 | 29263 | 1914-09-26 | 3 | b-c | Miscellaneous report on the World War I (Russian troops retreat, war in Jiaozhou peninsula of China, German ambassador accuse Chinese government, Turkey observes neutrality, Italy is involved in the war, British and German troops fight in Africa, American troops retreat from Mexico). | Other... | http://trove.nla.gov.au/newspaper/page/24093261 | 24093261 | |
29267 | 29267 | 1914-09-26 | 6 | b-c | China and Britain to jointly start silver mining in Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24093266 | 24093266 |
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]);