This data as json, CSV (advanced)
Suggested facets: page, column, description, source, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 50712 | 50712 | 1931-09-19 | 2 | b | First part of editorial on China's negotiations with Japan. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090527 | 24090527 | |
| 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 | |
| 50715 | 50715 | 1931-09-19 | 3 | a | Jiang Jieshi transfers his money to New York. | America | 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 | |
| 50718 | 50718 | 1931-09-19 | 5 | a | Hong Kong news/ Explosion of the arsenal in Macao. Jian Huanzhang is charged after his death. Fish shops in Hong Kong and the exorbitant taxes. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24090528 | 24090528 | |
| 50719 | 50719 | 1931-09-19 | 5 | c | Hunting a girl in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090528 | 24090528 | |
| 50720 | 50720 | 1931-09-19 | 5 | e | Notice issued by the Chinese Consulate-General in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090528 | 24090528 | |
| 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 | |
| 50722 | 50722 | 1931-09-19 | 8 | b | Australia to build a wool factory in China. | Britain | http://trove.nla.gov.au/newspaper/page/24090533 | 24090533 | |
| 50723 | 50723 | 1931-09-19 | 8 | b | The Hong Kong - Shanghai Banking Corporation finds counterfeit bank notes. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24090533 | 24090533 | |
| 50724 | 50724 | 1931-09-19 | 8 | b | Russia exports petrol to China. | China | http://trove.nla.gov.au/newspaper/page/24090533 | 24090533 | |
| 50725 | 50725 | 1931-09-19 | 8 | b | Train bombed in Hungary. | Britain | 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 | |
| 50727 | 50727 | 1931-09-19 | 8 | b | Gandhi arrives London and his speech. | Britain | http://trove.nla.gov.au/newspaper/page/24090533 | 24090533 | |
| 50728 | 50728 | 1931-09-19 | 8 | c | Australia news/ An old man in Sydney dies with grievance because of his savings in the Savings Bank of New South Wales. Profit of lottery in New South Wales. Dozens of people arrested in Sydney for communist propaganda. The Overseas Chinese Famine Relief Committee in Shanghai acknowledges receipt of the donations from the Chinese communities in Australia. Girl is raped in Sydney. Police arrest in a Sydney dancing club. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090533 | 24090533 | |
| 50729 | 50729 | 1931-09-19 | 8 | d | Notice issued by the Chinese Consulate-General in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090533 | 24090533 | |
| 50730 | 50730 | 1931-09-19 | 8 | e | Chinese Chamber of Commerce in Sydney calls for donations to the flooding areas in China and names listed for all donations. | Tung Wah | 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]);