This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31296 | 31296 | 1916-06-03 | 8 | b-d | Guangdong news/ Long Jiguang is removed from his office. Newspaper reports is released from prison in Guangzhou. Truce in Shiqi, of Xiangshan county. Dongguan county town is closed for three days due to banditry. Bandits in Zengcheng, Gaoyao and Gaoming counties. | China | http://trove.nla.gov.au/newspaper/page/24095290 | 24095290 |
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]);