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 |
---|---|---|---|---|---|---|---|---|---|
44799 | 44799 | 1926-06-05 | 2 | d-e | Wu Peifu's strategy on the current situation. | China | http://trove.nla.gov.au/newspaper/page/24101582 | 24101582 | |
44800 | 44800 | 1926-06-05 | 2 | f | Zhang Zuolin claims that he would not interfere with politics. | China | http://trove.nla.gov.au/newspaper/page/24101582 | 24101582 | |
44801 | 44801 | 1926-06-05 | 2 | f | Hu Yukun, Rong Zhen and Su Xilin issue circular telegram to promote ethical codes and condemn Feng Yuxiang. | China | http://trove.nla.gov.au/newspaper/page/24101582 | 24101582 | |
44802 | 44802 | 1926-06-05 | 3 | a | The Nationalist troops encourage and help bandits in Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24101581 | 24101581 | |
44803 | 44803 | 1926-06-05 | 3 | b-e | Lu Zhonglin in Beijing removes Duan Qirui and releases Cao Kun, report part II. | China | http://trove.nla.gov.au/newspaper/page/24101581 | 24101581 | |
44804 | 44804 | 1926-06-05 | 3 | e | A meeting in Nanjing and the celebration on the birthday of Sun Chuanfang. | China | http://trove.nla.gov.au/newspaper/page/24101581 | 24101581 | |
44805 | 44805 | 1926-06-05 | 3 | f | Shao Zhenqing (Piaoping), a journalist in Beijing, is arrested and executed. | China | http://trove.nla.gov.au/newspaper/page/24101581 | 24101581 | |
44806 | 44806 | 1926-06-05 | 5 | a | Feng Yuxiang escapes an assassination in Russia. | China | http://trove.nla.gov.au/newspaper/page/24101583 | 24101583 | |
44807 | 44807 | 1926-06-05 | 5 | b | American consul in Beijing on the way to Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24101583 | 24101583 | |
44808 | 44808 | 1926-06-05 | 5 | b | Anniversary of the May 30th Massacre in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24101583 | 24101583 | |
44810 | 44810 | 1926-06-05 | 5 | d | Sun Chuanfang issues a circular telegram to save China. | China | http://trove.nla.gov.au/newspaper/page/24101583 | 24101583 | |
44813 | 44813 | 1926-06-05 | 6 | c | A Russian communist delegation to visit China. | China | http://trove.nla.gov.au/newspaper/page/24101586 | 24101586 | |
44818 | 44818 | 1926-06-05 | 7 | e | Indian sailor shoots and injures a Chinese coolie in Nanjing and the chaos followed. | China | http://trove.nla.gov.au/newspaper/page/24101585 | 24101585 | |
44819 | 44819 | 1926-06-05 | 8 | a-d | Guangdong news/ The Northern Expedition from Guangzhou and the intention of Wu Peifu and Sun Chuanfang to take over Guangdong. Hu Hanmin returns to Guangdong and the report. Anti-communist sentiment in Guangzhou and the riots. Clan feud and fighting in Xinhui county. Magistrate of Xiangshan county resigns. | China | http://trove.nla.gov.au/newspaper/page/24101588 | 24101588 |
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]);