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 |
---|---|---|---|---|---|---|---|---|---|
51146 | 51146 | 1932-02-06 | 2 | d | Japanese consul in Shenyang and his diplomatic strategies. Determination of Sun Ke to fight Japanese invader. Declaration issued by Wu Zhihui. Wuhan authority fights the Communist Party. A photograph of unscrupulous merchant Ouyang He in Shanghai on street parade for collaboration with Japanese businessmen. Liu Wenhui urges Wu Peifu to come to Nanjing. Shen Junru protects the youth. An association to deal with national crisis (guo nan jiu ji hui) urges constitutional reform. New Japanese cabinet publicises expenditure for invasion of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090686 | 24090686 | |
51149 | 51149 | 1932-02-06 | 3 | a | Truce agreement between Tibet and Xikang province in China. | China | http://trove.nla.gov.au/newspaper/page/24090685 | 24090685 | |
51150 | 51150 | 1932-02-06 | 3 | b | Many Chinese are returning from Mexico. | China | http://trove.nla.gov.au/newspaper/page/24090685 | 24090685 | |
51152 | 51152 | 1932-02-06 | 3 | d | A survey on the coal mines in Henan province. | China | http://trove.nla.gov.au/newspaper/page/24090685 | 24090685 | |
51154 | 51154 | 1932-02-06 | 3 | e | Hubei provincial authority bars refugees from leaving. | China | http://trove.nla.gov.au/newspaper/page/24090685 | 24090685 | |
51157 | 51157 | 1932-02-06 | 5 | a | Associations in Shanghai request American government to uphold justice. | China | http://trove.nla.gov.au/newspaper/page/24090689 | 24090689 | |
51168 | 51168 | 1932-02-06 | 6 | c | Guangdong news/ Fan Qiwu and the financial reform in Guangdong. Preparation for the collection of business tax in 1932. The Central Bank to clear its debts. Artillery unit organised in Humen. Ships detained for stealing marine products from the Dongsha islands. Peasants from the northwest suburbs of Guangzhou present their petition to the provincial government. Heavy snow in Huizhou. Petitions in Heyuan county to abolish the levy on raft. Riots in Taishan county over the limestone. Police in Zhongshan county shut the door of the Nationalist Party branch. Silk production in Nanhai and Shunde county. Financial chaos in Foshan. Snowing in Renhua county. | China | http://trove.nla.gov.au/newspaper/page/24090692 | 24090692 | |
51169 | 51169 | 1932-02-06 | 7 | a | The fall of Heilongjiang province under Japanese invasion and the resistance of Chinese people. | China | http://trove.nla.gov.au/newspaper/page/24090691 | 24090691 | |
51171 | 51171 | 1932-02-06 | 8 | a | Japanese troops invade Shanghai and their fierce battles with the 19th Route Army in the north suburbs. Chinese government to declare war with Japan. Atrocities of Japanese army in Shanghai. Japanese warship fire Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24090694 | 24090694 | |
51173 | 51173 | 1932-02-06 | 8 | e | Jiang Jieshi, Feng Yuxiang and Yan Xishan to jointly fight Japanese invader. | China | http://trove.nla.gov.au/newspaper/page/24090694 | 24090694 |
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]);