This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31352 | 31352 | 1916-06-24 | 8 | c-d | Guangdong news/ Current situation in Guangdong and the mediation. Training of civil corps in Guangdong. Liang Qichao leaves Guangzhou. Civil corps in Zengcheng occupy many towns. Civil corps in Dongguan county and their lootings. | China | http://trove.nla.gov.au/newspaper/page/24095313 | 24095313 |
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]);