This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
45038 | 45038 | 1926-08-07 | 8 | a-d | Guangdong news/ Name list of the county magistrates in Guangdong. The attempt to assassinate Jiang Jieshi. Conflict between the Nationalist and the Communist members. Civil corps in Sanshui county. More clan fighting in Nanhai county. | China | http://trove.nla.gov.au/newspaper/page/24101662 | 24101662 |
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]);