This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
29311 | 29311 | 1914-10-17 | 3 | a | Belligerent countries of the World War I and their trade. | Other... | http://trove.nla.gov.au/newspaper/page/24093287 | 24093287 | |
29312 | 29312 | 1914-10-17 | 3 | a-c | War proclamation by the Emperor of Germany, and his speech to the parliament. Other miscellaneous report on the World War I. | Other... | http://trove.nla.gov.au/newspaper/page/24093287 | 24093287 | |
29313 | 29313 | 1914-10-17 | 3 | d | Beijing news/ Preparation for the issue of internal government bonds. Shi Zhaoji is appointed Chinese ambassador to London. Liang Qichao is involved in financial management. Second part of the Constitution of the China Revolution Party (zhong hua ge ming dang). | China | http://trove.nla.gov.au/newspaper/page/24093287 | 24093287 |
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]);