This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32659 | 32659 | 1917-11-10 | 2 | d-e | New policy adopted by the Chinese central government to deal with military authorities in the southwestern provinces. Situation changes in Sichuan and Yunnan provinces. New defence plan of the Hubei provincial authority. | China | http://trove.nla.gov.au/newspaper/page/24095900 | 24095900 |
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]);