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 |
---|---|---|---|---|---|---|---|---|---|
50713 | 50713 | 1931-09-19 | 2 | c | Japanese in Manchuria. Hankou turns into hell. Deng Yinda is arrested in Shanghai. Japan requests to implement the Twenty-one Demands. British ambassador donates to the relief work in China. Song Ziwen to raise funds overseas. Deng Yinda is on trial. Nanjing government continues to raise funds. Atrocities of Japanese in Qingdao. Japanese seek to occupy Qingdao. Luxurious banquet in Hankou in the disasters relief. Japanese still want to occupy Manchuria. Floods in Sichuan and Hubei. Leather factory in Harbin on fire. Jin Yunpeng becomes a monk. | China | http://trove.nla.gov.au/newspaper/page/24090527 | 24090527 | |
50714 | 50714 | 1931-09-19 | 3 | a | A branch of the Comintern is crushed in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24090526 | 24090526 | |
50716 | 50716 | 1931-09-19 | 3 | a | Song Ziwen spends a lot for his mother's funeral. | China | http://trove.nla.gov.au/newspaper/page/24090526 | 24090526 | |
50717 | 50717 | 1931-09-19 | 3 | b | Jiang Jieshi and Zhang Xueliang discuss solutions to the current crisis. Atrocities of Japanese in Qingdao. More than 40 counties are flooded in Henan province. Missiles manufactured in the munitions factory in Liaoning. Ambition of the Soviet Union for communist propaganda in China. The Grand Canal in Jiangsu province and the floods. | China | http://trove.nla.gov.au/newspaper/page/24090526 | 24090526 | |
50721 | 50721 | 1931-09-19 | 6-7 | a-d | Guangdong news/ Provincial government to issue condemn on the Nanjing authority. Military officers in Guangdong on peace. Chen Jitang refuses to accept the resignation of Lin Yungai. Wu Boliang seeks to resign. Debts of the Zhenguang Group Company. Guangdong and Guangxi prepare for the northern expedition. Guangzhou lifts the ban on dancing parties. Report on the peace effort of Guangdong. More weapons arrive Guangzhou. Workers in the Guangzhou munitions factory are injured. Petition from Yingde county to be exempt from sales of military bonds. Fortress in Zhongshan and Shunde county. People in Gaoyao county jointly request to stop date change of market. A gambling den collapses in Zhaoqing and injuries. Underground mint raided in Taishan. Spring bathroom to be built in Taishan. Bandits in Taishan. People in Taishan request to stop sale of military bonds. Leather industry on strike in Shantou. Building of iron bridge in Zhujiang River. | China | http://trove.nla.gov.au/newspaper/page/24090531 | 24090531 | |
50724 | 50724 | 1931-09-19 | 8 | b | Russia exports petrol to China. | China | http://trove.nla.gov.au/newspaper/page/24090533 | 24090533 | |
50726 | 50726 | 1931-09-19 | 8 | b | Guangdong troops occupy Hengyang in Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24090533 | 24090533 |
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]);