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 |
|---|---|---|---|---|---|---|---|---|---|
| 51243 | 51243 | 1932-03-05 | 2 | a | Journalist in Shanghai Qian Cangshuo fight for freedom of speech and his open letter. | China | http://trove.nla.gov.au/newspaper/page/24090720 | 24090720 | |
| 51244 | 51244 | 1932-03-05 | 2 | b | Declaration issued by the Chinese foreign ministry on the Japanese invasion of Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24090720 | 24090720 | |
| 51245 | 51245 | 1932-03-05 | 2 | c | Japanese to rebuild the Lushun port in Liaoning province. | China | http://trove.nla.gov.au/newspaper/page/24090720 | 24090720 | |
| 51246 | 51246 | 1932-03-05 | 2 | d | Han Fuqu takes over tax administration in Qingdao, Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24090720 | 24090720 | |
| 51247 | 51247 | 1932-03-05 | 2 | d | Japanese organise new state government in Manchuria and the report. Japanese bomb Nanjing. He Chengrui arranges defence in Wuhan. Circular telegram jointly issued by Cai Yuanpei, Liu Jinghua, Zou Lu, Jiang Menglin, Wang Shiyan and Mei Yiqi on the atrocities of Japanese troops. Japanese troops occupy university campus in Shanghai. Professors of the Zhongshan University demand salary payment. | China | http://trove.nla.gov.au/newspaper/page/24090720 | 24090720 | |
| 51248 | 51248 | 1932-03-05 | 3 | a | Japanese and railway development plan in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090719 | 24090719 | |
| 51249 | 51249 | 1932-03-05 | 3 | a | Recent talks by Duan Qirui. | China | http://trove.nla.gov.au/newspaper/page/24090719 | 24090719 | |
| 51250 | 51250 | 1932-03-05 | 3 | b | Girl Song Meiqi is arrested by Japanese when she trying to join the troops of Ma Zhanshan. | China | http://trove.nla.gov.au/newspaper/page/24090719 | 24090719 | |
| 51251 | 51251 | 1932-03-05 | 3 | b | Bandits in the south of Henan province. | China | http://trove.nla.gov.au/newspaper/page/24090719 | 24090719 | |
| 51252 | 51252 | 1932-03-05 | 3 | c | Luo Wengan on the reform of judicial system. | China | http://trove.nla.gov.au/newspaper/page/24090719 | 24090719 | |
| 51253 | 51253 | 1932-03-05 | 3 | e | Soviet Union publishes the new five-year plan. | Britain | http://trove.nla.gov.au/newspaper/page/24090719 | 24090719 | |
| 51254 | 51254 | 1932-03-05 | 5 | a | Chinese consul-general is leaving the South Africa. | Other... | http://trove.nla.gov.au/newspaper/page/24090721 | 24090721 | |
| 51255 | 51255 | 1932-03-05 | 5 | a | Two reports on Japanese invasion of eastern China. | China | http://trove.nla.gov.au/newspaper/page/24090721 | 24090721 | |
| 51256 | 51256 | 1932-03-05 | 5 | a | China and Soviet Russia resume diplomatic relations. | China | http://trove.nla.gov.au/newspaper/page/24090721 | 24090721 | |
| 51257 | 51257 | 1932-03-05 | 5 | b | Manchuria declares independence. | China | http://trove.nla.gov.au/newspaper/page/24090721 | 24090721 | |
| 51258 | 51258 | 1932-03-05 | 5 | b | Hope for peace talks between China and Japan. | China | http://trove.nla.gov.au/newspaper/page/24090721 | 24090721 | |
| 51259 | 51259 | 1932-03-05 | 5 | c | Australia news/ Jiang Jieshi replies to the Sydney Chinese Association of Saving China. The 20th meeting of the Sydney Chinese Association of Saving China. Fund-raising committee of the Chinese in Sydney for the resistance to Japanese invasion. Chinese students in Sydney Zhu Huimin, 11, donates to the military funds for resistance to Japanese invasion. A reply from the Nationalist government in Nanjing to the Chinese Society (zhong hua gong hui) in Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090721 | 24090721 | |
| 51260 | 51260 | 1932-03-05 | 5 | e | Chinese communities in Sydney donate to the resistance to Japanese invasion and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090721 | 24090721 | |
| 51261 | 51261 | 1932-03-05 | 6 | b | Guangdong news/ Statistics of losses suffered by Guangdong from the past revolutions. Defence arrangements in Humen. Preparation for port building in Haikou, of Hainan island. Japanese troops land in Shantou and the negotiations. Industrial development plan in Guangxi province. Circular telegram by the military officers of Guangdong and Guangxi on eradication of communism and the fighting with Japanese invaders. | China | http://trove.nla.gov.au/newspaper/page/24090724 | 24090724 | |
| 51262 | 51262 | 1932-03-05 | 7 | a | Students of the Zhongshan University urge Hu Hanmin to go north. | China | http://trove.nla.gov.au/newspaper/page/24090723 | 24090723 | |
| 51263 | 51263 | 1932-03-05 | 7 | b | Recent manoeuvre of various troops in Guangxi. Guangxi army to have air force troops. | China | http://trove.nla.gov.au/newspaper/page/24090723 | 24090723 | |
| 51264 | 51264 | 1932-03-05 | 7 | b | Japanese ship capsized down and passengers drowned in Shantou. Public security in si yi area. Villagers request to remove the local administrator. Special levy in Chaoyang county on girls who are marrying. Communist troops in Hainan island. Exorbitant taxes in Zhongshan and Shunde county. | China | http://trove.nla.gov.au/newspaper/page/24090723 | 24090723 | |
| 51265 | 51265 | 1932-03-05 | 8 | a | Overseas Chinese communities donate to the war of resistance to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24090726 | 24090726 | |
| 51266 | 51266 | 1932-03-05 | 8 | a | America and Canada to organise an air force troops to aid China. | Canada | http://trove.nla.gov.au/newspaper/page/24090726 | 24090726 | |
| 51267 | 51267 | 1932-03-05 | 8 | a | Feng Yuxiang on the way to Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24090726 | 24090726 | |
| 51268 | 51268 | 1932-03-05 | 8 | a | Wu Tiecheng warns foreign missions in China. | China | http://trove.nla.gov.au/newspaper/page/24090726 | 24090726 | |
| 51269 | 51269 | 1932-03-05 | 8 | a | Refugees in Shanghai following the Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24090726 | 24090726 | |
| 51270 | 51270 | 1932-03-05 | 8 | b | Japan's relations with Britain and Germany. | Britain | http://trove.nla.gov.au/newspaper/page/24090726 | 24090726 | |
| 51271 | 51271 | 1932-03-05 | 8 | b | The Manchuria State (man zhou guo) set up by Japanese. | China | http://trove.nla.gov.au/newspaper/page/24090726 | 24090726 | |
| 51272 | 51272 | 1932-03-05 | 8 | b | Battles between Chinese and Japanese troops near Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24090726 | 24090726 |
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]);