This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
48183 | 48183 | 1929-06-08 | 2 | f | Hunan troops enter Guangxi. Hubei provincial authority audits government accounts. Zhang Zongchang leaves for Japan with his concubines while some others defeated military officers are also leaving China. Chinese foreign ministry to abolish the consular jurisdiction from next year. He Long and his communist troops trample in Hunan. | China | http://trove.nla.gov.au/newspaper/page/24099240 | 24099240 |
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]);