This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28025 | 28025 | 1913-10-18 | 8 | b-c | Guangdong news/ Liuzhou, of Guangxi province, declares independence. Civil corps (min tuan) in Heshan, Kaiping and Enping counties. Flood in Zhaoqing and the damages. Properties belonging to Hu Hanmin and Chen Jiongming to be sealed up. | China | http://trove.nla.gov.au/newspaper/page/24092863 | 24092863 |
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]);