This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33429 | 33429 | 1918-07-13 | 2 | d-e | The Chinese cabinet under Duan Qirui is unstable. | China | http://trove.nla.gov.au/newspaper/page/24097354 | 24097354 | |
33442 | 33442 | 1918-07-13 | 8 | d-e | Guangdong news/ Fang Shengtao asks for forgiveness on behalf of Zhang Kairu. Troops from the north now in south Jiangxi province. Sun Yatsen seeks to grab some money from the government. Bandits in Taishan county. An military government to be organised in Guangzhou. Long Jiguang's army are defeated in the Guangzhou Bay. Provincial authority exempts all unpaid land tax. | China | http://trove.nla.gov.au/newspaper/page/24097359 | 24097359 |
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]);