This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29234 | 29234 | 1914-09-12 | 6 | a-c | Miscellaneous report on the Chinese politics and officialdom. | China | http://trove.nla.gov.au/newspaper/page/24093248 | 24093248 | |
29236 | 29236 | 1914-09-12 | 7 | a-c | Miscellaneous report on the World War I (comments in American newspapers, rumours in Paris and London, Paris closes its gate, China may attack Japan, Japanese students arrested in Germany, Japan's war budget, the biggest war in human history, Russian change the name of capital, Austrian troops are defeated, Turkey joins the war, defence of Paris, battles between Allies and German troops, and other news). | Other... | http://trove.nla.gov.au/newspaper/page/24093247 | 24093247 |
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]);