This data as json, CSV (advanced)
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 | |
41406 | 41406 | 1924-04-12 | 6 | a-c | Sun Yatsen's trusted followers are against the Communists (Liu Chengyu, Xiao Fucheng and others). | China | http://trove.nla.gov.au/newspaper/page/24100684 | 24100684 |
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]);