This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
37111 | 37111 | 1921-06-18 | 2 | d | Chaos in Beijing over the cut of educational budget. | China | http://trove.nla.gov.au/newspaper/page/24093581 | 24093581 | |
37112 | 37112 | 1921-06-18 | 3 | a | Chinese President Xu Shichang in Beijing appoints new cabinet which comprises Jin Yunpeng, Yan Huiqing, Qi Yaosan, Li Shiwei, Cai Chengxun, Li Dingxin, Dong Kang, Fan Yuanlian, and Zhang Zhitan. | China | http://trove.nla.gov.au/newspaper/page/24093580 | 24093580 | |
37113 | 37113 | 1921-06-18 | 3 | a-b | Henan provincial authority suppresses rebellion army led by Cheng Shenye in Zhangde. | China | http://trove.nla.gov.au/newspaper/page/24093580 | 24093580 | |
37114 | 37114 | 1921-06-18 | 3 | b | President Sun Yatsen in Guangzhou appoints his cabinet which comprises Wu Tingfang, Chen Jiongming, Tang Shaoyi, Tang Tingguang, Li Liejun, Xu Qian, Xu Shaozheng, Ma Junwu, Wu Chaoshu, Liao Zhongkai, Cheng Qian, and others. | China | http://trove.nla.gov.au/newspaper/page/24093580 | 24093580 | |
37115 | 37115 | 1921-06-18 | 3 | b | Chen Shufan in Shaanxi issues circular telegram against Sun Yatsen and his government in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24093580 | 24093580 | |
37116 | 37116 | 1921-06-18 | 3 | b-c | Beijing government denies the treaty that Sun Yatsen in Guangzhou signed with a foreign government about mines in Guangdong province. | China | http://trove.nla.gov.au/newspaper/page/24093580 | 24093580 | |
37122 | 37122 | 1921-06-18 | 6 | a | A circular telegram issued by Cao Kun, Zhang Zuolin, Wang Zhanyuan, Lu Rongting, Tan Haoming and dozens of other local governors against Sun Yatsen. | China | http://trove.nla.gov.au/newspaper/page/24093585 | 24093585 | |
37134 | 37134 | 1921-06-18 | 7 | b | Deng Benyin and Wu Zhaolin call to wipe out President Sun Yatsen and his followers. | China | http://trove.nla.gov.au/newspaper/page/24093584 | 24093584 |
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]);