This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
41391 | 41391 | 1924-04-12 | 2 | a-c | Second and final part of the 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/24100680 | 24100680 | |
41392 | 41392 | 1924-04-12 | 2 | c | Election of Chinese deputy president will be postponed. | China | http://trove.nla.gov.au/newspaper/page/24100680 | 24100680 | |
41393 | 41393 | 1924-04-12 | 2 | c | Chinese national parliament rises and the response of various public associations. | China | http://trove.nla.gov.au/newspaper/page/24100680 | 24100680 | |
41394 | 41394 | 1924-04-12 | 2 | c-d | Process of the negotiation between Russia and China. | China | http://trove.nla.gov.au/newspaper/page/24100680 | 24100680 | |
41395 | 41395 | 1924-04-12 | 2 | e | Chinese national parliamentarians in Shanghai discuss the revision of the Constitution. | China | http://trove.nla.gov.au/newspaper/page/24100680 | 24100680 | |
41396 | 41396 | 1924-04-12 | 2 | e-f | Dong Kang comments on the improvement of Chinese legal system. | China | http://trove.nla.gov.au/newspaper/page/24100680 | 24100680 |
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]);