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 |
---|---|---|---|---|---|---|---|---|---|
50901 | 50901 | 1931-11-28 | 2 | d | People in Manchuria request to abolish the Party administration and support from other areas. People in Shanghai to present their petition. Student representatives in Shanghai meet Wang Jingwei and their request. Peace talks between Guangzhou and Nanjing authorities fails to achieve success. | China | http://trove.nla.gov.au/newspaper/page/24090613 | 24090613 | |
50902 | 50902 | 1931-11-28 | 3 | a-c | Japanese troops in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090612 | 24090612 | |
50903 | 50903 | 1931-11-28 | 3 | c | Puyi, dethroned emperor of the Qing dynasty, says he would not be used by Japanese. | China | http://trove.nla.gov.au/newspaper/page/24090612 | 24090612 | |
50906 | 50906 | 1931-11-28 | 3 | e | Chinese people in Dalian, Liaoning province, are not free. Japanese troops bomb Jinzhou, Liaoning province. Japanese collect taxes in Liaoning and Jilin province. | China | http://trove.nla.gov.au/newspaper/page/24090612 | 24090612 | |
50907 | 50907 | 1931-11-28 | 5 | a | Second part of a letter from Chen Jiongming to Cai Yuanpei and Zhang Xueliang. | China | http://trove.nla.gov.au/newspaper/page/24090614 | 24090614 | |
50908 | 50908 | 1931-11-28 | 5 | b | An open letter issued by Li Liejun, Xu Qian, Cheng Qian, Zhang Zhiben, Chen Jiayou and others. | China | http://trove.nla.gov.au/newspaper/page/24090614 | 24090614 | |
50911 | 50911 | 1931-11-28 | 6 | a | Guangdong news/ Gu Yingfen dies. Bandits in Guangzhou sends human's head for ransom. Zhang Fakui returns the weapons he detained. The First Group Army in financial shortage. A survey on the shops in Guangzhou that closed down last year. Guangdong owes army provisions and the amount. Arsenal explodes in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24090617 | 24090617 | |
50913 | 50913 | 1931-11-28 | 8 | a | Japanese troops occupy Qiqihar in Heilongjiang province. Other report on Japanese invasion of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090619 | 24090619 | |
50916 | 50916 | 1931-11-28 | 8 | b | Jiang Jieshi may go to Manchuria personally. Students in Shanghai raise funds to support China's resistance. | China | http://trove.nla.gov.au/newspaper/page/24090619 | 24090619 |
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]);