This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28822 | 28822 | 1914-05-16 | 2 | a-b | China should develop its industry in order to consolidate the democracy, editorial by the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24093110 | 24093110 | |
28838 | 28838 | 1914-05-16 | 6 | a-b | First part of a report on the high alert in Beijing and the revolutionary rebels. | China | http://trove.nla.gov.au/newspaper/page/24093114 | 24093114 | |
28842 | 28842 | 1914-05-16 | 8 | a-b | Second and final part of the report that Chinese Ministry of Internal Affairs changes names of some counties in order to avoid repetition, for example, in Guangdong province, Xinning changed to Taishan, Zhenping to Jiaoling, etc. | China | http://trove.nla.gov.au/newspaper/page/24093116 | 24093116 |
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]);