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 |
|---|---|---|---|---|---|---|---|---|---|
| 51723 | 51723 | 1932-07-23 | 2 | a | Editorial by Tung Wah Times on the circular telegram issued by the Chinese Council of Administration in Nanjing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090880 | 24090880 | |
| 51724 | 51724 | 1932-07-23 | 2 | b | Bombs found in Chen Mingshu's residence. Leaders of five provinces gather in Lushan Mountain, Jiangxi province. Resolutions of the Lushan Conference on the foreign affairs, finance, military and other affairs. | China | http://trove.nla.gov.au/newspaper/page/24090880 | 24090880 | |
| 51725 | 51725 | 1932-07-23 | 2 | c | Declaration issued by the Chinese foreign ministry. | China | http://trove.nla.gov.au/newspaper/page/24090880 | 24090880 | |
| 51726 | 51726 | 1932-07-23 | 2 | e | Li Liejun sends telegram to Wang Jingwei. Ma Zhanshan leads his troops retreat to the south of Manchuria. Children in Hangzhou donate their savings to build patriotic warships. First part of a report prepared by Gu Weijun on the disasters of war in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090880 | 24090880 | |
| 51727 | 51727 | 1932-07-23 | 3 | a | Second part of key news from Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24090879 | 24090879 | |
| 51728 | 51728 | 1932-07-23 | 3 | b | A recent talks by Song Ziwen. | China | http://trove.nla.gov.au/newspaper/page/24090879 | 24090879 | |
| 51729 | 51729 | 1932-07-23 | 3 | d | Cheng Zhiyuan in Harbin, Heilongjiang province, and his crimes. | China | http://trove.nla.gov.au/newspaper/page/24090879 | 24090879 | |
| 51730 | 51730 | 1932-07-23 | 3 | e | Japanese totally control the puppet government in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24090879 | 24090879 | |
| 51731 | 51731 | 1932-07-23 | 5 | a | Official newspaper of the Soviet Union government comments on the military power of Japan and America. | Russia | http://trove.nla.gov.au/newspaper/page/24090881 | 24090881 | |
| 51732 | 51732 | 1932-07-23 | 5 | c | Fiction/ The girl Xue Lizheng and her story, Part V. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090881 | 24090881 | |
| 51733 | 51733 | 1932-07-23 | 5 | e | Chinese communities in Melbourne and Wellington, New Zealand, donate to the war of resistance to Japanese invasion and names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090881 | 24090881 | |
| 51734 | 51734 | 1932-07-23 | 6-7 | a-f | Guangdong news/ The war in Tangjiawan, of Zhongshan county. Guangdong troops attack Changding, of Fujian province. People in Guangzhou welcome Cai Tingkai. Naval forces may leave Hainan island. Epidemic disease in Guangzhou. Floods in local Guangdong. Jiang Guanglai visit his hometown and comments on the local administration. Bandits in Gaoyao, Xinhui, Zengcheng, Xiangshan, Panyu and other counties. Appeasement Committee in local Guangdong promote agricultural production. | China | http://trove.nla.gov.au/newspaper/page/24090884 | 24090884 | |
| 51735 | 51735 | 1932-07-23 | 8 | a | Delegation of the League of Nations leaves Japan for China. | Japan | http://trove.nla.gov.au/newspaper/page/24090886 | 24090886 | |
| 51736 | 51736 | 1932-07-23 | 8 | a | Russian troops on exercise in Siberia. | China | http://trove.nla.gov.au/newspaper/page/24090886 | 24090886 | |
| 51737 | 51737 | 1932-07-23 | 8 | a | Retired servicemen on demonstration in America. | America | http://trove.nla.gov.au/newspaper/page/24090886 | 24090886 | |
| 51738 | 51738 | 1932-07-23 | 8 | a | German government bans demonstration of any political parties. | Germany | http://trove.nla.gov.au/newspaper/page/24090886 | 24090886 | |
| 51739 | 51739 | 1932-07-23 | 8 | b | Homicide of Japanese soldiers in Harbin, Heilongjiang province. | China | http://trove.nla.gov.au/newspaper/page/24090886 | 24090886 | |
| 51740 | 51740 | 1932-07-23 | 8 | b | The League of Nations to have another meeting. | Britain | http://trove.nla.gov.au/newspaper/page/24090886 | 24090886 | |
| 51741 | 51741 | 1932-07-23 | 8 | b | British tax commissioner in Harbin, Heilongjiang province, is removed. | China | http://trove.nla.gov.au/newspaper/page/24090886 | 24090886 | |
| 51742 | 51742 | 1932-07-23 | 8 | b | Japanese army invade Rehe province. | China | http://trove.nla.gov.au/newspaper/page/24090886 | 24090886 | |
| 51743 | 51743 | 1932-07-23 | 8 | b | Chinese government tries to meet expenses of its overseas missions. | China | http://trove.nla.gov.au/newspaper/page/24090886 | 24090886 | |
| 51744 | 51744 | 1932-07-23 | 8 | c | Australia news/ Fake currency in Sydney. Tobacco growers harvest nothing. Smuggled opium seized in Perth. Australian government sends representatives to the meeting of League of Nations. News on the lottery in Sydney. Chinese man in Sydney kills bandit. Unemployed workers in Brisbane. Awards meeting of the Chinese School in Sydney. A family tragedy in Sydney. More Australians are going to tour the East. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090886 | 24090886 |
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]);