This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
53892 | 53892 | 1934-02-24 | 7-8 | a-f | Guangdong news/ Politicians in Guangdong urge Nanjing and Fujian to stop the fighting. Tan Qixiu and Chen Qixuan defect to the Nationalist army. Conference held in Guangxi for the peace in Guizhou province. Drugs in Taishan. | China | http://trove.nla.gov.au/newspaper/page/24091544 | 24091544 |
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]);