This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 50692 | 50692 | 1931-09-12 | 2 | b | Second and final part of editorial on the negotiation between China and Japan over the atrocity of Japanese police in Jilin province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090519 | 24090519 | |
| 50693 | 50693 | 1931-09-12 | 2 | d | The anti-Chinese movement in Mexico and the tragedy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090519 | 24090519 | |
| 50694 | 50694 | 1931-09-12 | 2 | d | He Jian in Hunan resigns. Yan Xishan returns to Shanxi secretly. The Shanxi army that fight Jiang Jieshi. Shang Zhen resigns. Shi Yousan steps down. Talks between China and Japan over the Jilin incident and Japan's attitude. The Yangtze River is flooding again. Japan to promote its export to China by force. Chen Youren has left Japan. Sichuan situation is not optimistic. Japanese in Manchuria and Mongolia. The Dongling Cemetery will be turned into a forest. Nanjing government appoints directors of munitions factories. | China | http://trove.nla.gov.au/newspaper/page/24090519 | 24090519 | |
| 50695 | 50695 | 1931-09-12 | 3 | a | Anti-Japanese public gathering in Qingdao also support their countrymen in Korea. | China | http://trove.nla.gov.au/newspaper/page/24090518 | 24090518 | |
| 50696 | 50696 | 1931-09-12 | 3 | b | Survey on the floods in China this year. | China | http://trove.nla.gov.au/newspaper/page/24090518 | 24090518 | |
| 50697 | 50697 | 1931-09-12 | 3 | e | Army commander He Zhenfan is murdered by his followers in Hankou. Shanxi province in the war clouds. | China | http://trove.nla.gov.au/newspaper/page/24090518 | 24090518 | |
| 50698 | 50698 | 1931-09-12 | 5 | a | Hong Kong news/ Police chief from Zhongshan county is attacked in Macao. The Tung Wah Hospital in Hong Kong donates to relief work in the flooding areas of Guangdong. Sun Yatsen's first wife comes to meet Sun Ke in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24090520 | 24090520 | |
| 50699 | 50699 | 1931-09-12 | 5 | d | Story of Scholar He. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090520 | 24090520 | |
| 50700 | 50700 | 1931-09-12 | 5 | e | Notices issued by the Chinese Consulate-General in Australia | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090520 | 24090520 | |
| 50701 | 50701 | 1931-09-12 | 6-7 | a-d | Guangdong news/ Different bonds issued by the Guangdong government in the past years. More weapons arrive Guangzhou for the fighting with Jiang Jieshi. Guangdong government mobilise to fight Jiang Jieshi. Lin Yungai resigns again as financial director of the Guangdong government. Air force troops in Shaoguan. Swedish businessmen are manufacturing matches in China. The First Group Army needs provisions desperately. Wang Jingwei is urged to return to Guangzhou. Budget report of the new Nationalist government. Pressgang and the sales of soldiers. Defence line in Shaoguan to be strengthened. Storm in the Xijiang area and the damages. Floods in the Beijiang area, Gaoyao and other regions. Zhongshan county authority will be back to Shiqi. New plan for the road project in Xinning. Jiangmen sees more opium dens. Local security meeting in Zengcheng. Complaints over the exorbitant taxes in Zhongshan. Two children fight bandits in Xinhui. Atrocities of the Communist bandits in Haifeng. | China | http://trove.nla.gov.au/newspaper/page/24090523 | 24090523 | |
| 50702 | 50702 | 1931-09-12 | 8 | b | Japanese ship transport rice to the flooding area in north China. | Japan | http://trove.nla.gov.au/newspaper/page/24090525 | 24090525 | |
| 50703 | 50703 | 1931-09-12 | 8 | b | Water retreat a bit in the Yangtze River. | China | http://trove.nla.gov.au/newspaper/page/24090525 | 24090525 | |
| 50704 | 50704 | 1931-09-12 | 8 | b | A plan book of the Soviet Union for communist propaganda in China. | China | http://trove.nla.gov.au/newspaper/page/24090525 | 24090525 | |
| 50705 | 50705 | 1931-09-12 | 8 | b | Mexico deports Chinese. | Canada | http://trove.nla.gov.au/newspaper/page/24090525 | 24090525 | |
| 50706 | 50706 | 1931-09-12 | 8 | b | The Chinese Nationalist government purchases wheat from America for disasters relief. | America | http://trove.nla.gov.au/newspaper/page/24090525 | 24090525 | |
| 50707 | 50707 | 1931-09-12 | 8 | c | An official report on the flooding disasters in China. | China | http://trove.nla.gov.au/newspaper/page/24090525 | 24090525 | |
| 50708 | 50708 | 1931-09-12 | 8 | c | Mutiny of the Chile navy. | Other... | http://trove.nla.gov.au/newspaper/page/24090525 | 24090525 | |
| 50709 | 50709 | 1931-09-12 | 8 | c | Alarm of floods of the north part of the Grand Canal in China. | China | http://trove.nla.gov.au/newspaper/page/24090525 | 24090525 | |
| 50710 | 50710 | 1931-09-12 | 8 | c | Australia news/ Chinese Consul-General in Australia Gui Zhi talks to his French counterpart on the execution of Chinese in French colony. Chinese opium addicts arrested in Sydney. Police arrest the Communist members in Sydney. A bank in Brisbane is suddenly closed down. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090525 | 24090525 | |
| 50711 | 50711 | 1931-09-12 | 8 | d | 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/24090525 | 24090525 |
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]);