This data as json, CSV (advanced)
Suggested facets: source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41357 | 41357 | 1924-04-05 | 2 | a-b | First part of an editorial on the fast replacement of politicians one after another in China (Yuan Shikai, Duan Qirui, Feng Guozhang, Xu Shichang, Li Yuanhong, Sun Yatsen, Chen Jiongming, Tang Jiyao, Lu Yongxiang and many others). | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100672 | 24100672 | |
41358 | 41358 | 1924-04-05 | 2 | b-c | Tianjin people oppose to the recognition of Soviet Russia. | China | http://trove.nla.gov.au/newspaper/page/24100672 | 24100672 | |
41359 | 41359 | 1924-04-05 | 2 | c | Beijing cabinet meets and discusses the Guangdong problem. | China | http://trove.nla.gov.au/newspaper/page/24100672 | 24100672 | |
41360 | 41360 | 1924-04-05 | 2 | c-d | China may see a significant political change in the near future. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100672 | 24100672 | |
41361 | 41361 | 1924-04-05 | 2 | e | Current political situation in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24100672 | 24100672 | |
41362 | 41362 | 1924-04-05 | 2 | e-f | Governor of Zhejiang province sends a secret report to the Beijing authority. | China | http://trove.nla.gov.au/newspaper/page/24100672 | 24100672 |
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]);