This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31155 | 31155 | 1916-04-22 | 3 | b-c | Wang Tieshan's admonition to the police force in Yunnan province. | China | http://trove.nla.gov.au/newspaper/page/24095235 | 24095235 | |
31164 | 31164 | 1916-04-22 | b-c | American government dispatches troops to suppress rebellions in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24095233 | 24095233 | ||
31168 | 31168 | 1916-04-22 | 8 | b-c | Guangdong news/ Long Jiguang and his troops in Guangzhou. Spy sentenced in Guangzhou. Revolutionaries in Qingyuan county and their plot. Bandits in Qingyuan county. Post offices in Yunnan and Guizhou province are not looking after parcels properly. | China | http://trove.nla.gov.au/newspaper/page/24095242 | 24095242 |
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]);