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 |
|---|---|---|---|---|---|---|---|---|---|
| 50414 | 50414 | 1931-06-20 | 2 | b | Editorial by Tung Wah Times on the freedom of speech. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090421 | 24090421 | |
| 50415 | 50415 | 1931-06-20 | 2 | c | Liu Jiwen is removed from his position. Many refugees are going to Heilongjiang. Nanjing government purchases planes. News on the talks between China and Russia. Li Shizeng is ill in Shanghai. Wang Jinyu arrives Tianjin from Beijing. Martial law enforced in Fuzhou. Chen Mingshu takes rest in Japan. Zhang Xueliang delivers a speech at the Jinling University in Nanjing. Jiang Jieshi to solve the Guangdong problem by force. Communist Party purchases weapons from Germany. Sichuan authority purchases weapons. Jiang Baoguo is arrested for attempting to assassinate Jiang Jieshi last year. Railway negotiations between China and Japan. A plea from the people of Gansu province. Finance after the abolition of likin. Zhang Xueliang to mediate the military conflicts. Jiang Jieshi's strategy to solve the Guangdong problem. Jiang Jieshi's troops to enter Hunan and Guangxi. He Jian refuses to accept troops under Tang Shengzhi. Military standout in north Henan province. Circular telegram issued by the military commanders in north China. | China | http://trove.nla.gov.au/newspaper/page/24090421 | 24090421 | |
| 50416 | 50416 | 1931-06-20 | 3 | a | Chaos in the north of Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24090420 | 24090420 | |
| 50417 | 50417 | 1931-06-20 | 3 | a | Split of the Comintern (Third International). | Other... | http://trove.nla.gov.au/newspaper/page/24090420 | 24090420 | |
| 50418 | 50418 | 1931-06-20 | 3 | b | Suffering of the Chinese businessmen in Outer Mongolia under the Communist administration. | China | http://trove.nla.gov.au/newspaper/page/24090420 | 24090420 | |
| 50419 | 50419 | 1931-06-20 | 3 | e | Zou Lu talks on the Party and military affairs. | China | http://trove.nla.gov.au/newspaper/page/24090420 | 24090420 | |
| 50420 | 50420 | 1931-06-20 | 5 | a | Hong Kong news/ Bai Chongxi and Zhang Fakui arrive Hong Kong. A robbery in the Queen's Hotel in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24090422 | 24090422 | |
| 50421 | 50421 | 1931-06-20 | 5 | d | Women thieves in Guangzhou. Seals on a school girl's trousers in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090422 | 24090422 | |
| 50422 | 50422 | 1931-06-20 | 5 | e | Notices issued by the Chinese Consulate-General in Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090422 | 24090422 | |
| 50423 | 50423 | 1931-06-20 | 6-7 | a-d | Guangdong news/ Jiang Jieshi is determined to control Guangdong. Naval, army and air forces jointly attack the security troops in Huangpu. Chen Ce resigns and leaves Guangdong. The military organisations against Jiang Jieshi. Guangzhou government raise funds for military clashes. The military government in Guangxi. Deng Zeru is leaving Guangdong unexpectedly. Munitions factory in Guangzhou busy day and night. Lin Yizhong is appointed to head the bureau of civil affairs. Xu Chongzhi on the way south. Villagers in Gaoyao county voluntarily contribute to the school education. Clan fighting in Zengcheng. Bandits in Zengcheng. Long distance telephone service now available in Taishan county. School girls in Taishan cut their hair. Crisis of sugar industry in Chaozhou and Meixian. A plan of joint defence in Nanhai, Panyu, Zhongshan and Shunde counties. Bandits in Dongguan. Military news from Shilong. Zhongshan county to build more roads. Bandits in Dongjiang area. Villagers in Xinhui plea for exemption of some taxes. | China | http://trove.nla.gov.au/newspaper/page/24090425 | 24090425 | |
| 50424 | 50424 | 1931-06-20 | 8 | b | Banks closed in America. | America | http://trove.nla.gov.au/newspaper/page/24090427 | 24090427 | |
| 50425 | 50425 | 1931-06-20 | 8 | b | Russian troops shoot at famine refugees. | Britain | http://trove.nla.gov.au/newspaper/page/24090427 | 24090427 | |
| 50426 | 50426 | 1931-06-20 | 8 | b | British government contributes funds to aviation industry. | Britain | http://trove.nla.gov.au/newspaper/page/24090427 | 24090427 | |
| 50427 | 50427 | 1931-06-20 | 8 | b | A report from Japan claims that Zhang Xueliang is assassinated. | Japan | http://trove.nla.gov.au/newspaper/page/24090427 | 24090427 | |
| 50428 | 50428 | 1931-06-20 | 8 | b | Wu Chaoshu resigns as Chinese ambassador to America. | Africa | http://trove.nla.gov.au/newspaper/page/24090427 | 24090427 | |
| 50429 | 50429 | 1931-06-20 | 8 | b | Disarmament movement in Spain. | Britain | http://trove.nla.gov.au/newspaper/page/24090427 | 24090427 | |
| 50430 | 50430 | 1931-06-20 | 8 | b | Police in France stop the Communist demonstration. | France | http://trove.nla.gov.au/newspaper/page/24090427 | 24090427 | |
| 50431 | 50431 | 1931-06-20 | 8 | c | Proposals by the members of American House of Representatives to solve the economic crisis. | America | http://trove.nla.gov.au/newspaper/page/24090427 | 24090427 | |
| 50432 | 50432 | 1931-06-20 | 8 | c | Storm in Europe and the damages. | Britain | http://trove.nla.gov.au/newspaper/page/24090427 | 24090427 | |
| 50433 | 50433 | 1931-06-20 | 8 | c | Zhang Xueliang dispatches more troops across the Shanhaiguan. | China | http://trove.nla.gov.au/newspaper/page/24090427 | 24090427 | |
| 50434 | 50434 | 1931-06-20 | 8 | c | Talks between China and Britain over the consular jurisdiction. | China | http://trove.nla.gov.au/newspaper/page/24090427 | 24090427 | |
| 50435 | 50435 | 1931-06-20 | 8 | d | British ship finds new island. | Canada | http://trove.nla.gov.au/newspaper/page/24090427 | 24090427 | |
| 50436 | 50436 | 1931-06-20 | 8 | d | Three more banks are closed down in America. | America | http://trove.nla.gov.au/newspaper/page/24090427 | 24090427 | |
| 50437 | 50437 | 1931-06-20 | 8 | d | Australia news/ Australian government repays debts to Britain. Disputes between grocery businessmen and their employees in Sydney. Charity institutions to help the unemployed people. More food provided to the unemployed people. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090427 | 24090427 | |
| 50438 | 50438 | 1931-06-20 | 8 | e | Notice issued by the Chinese Consulate-General in Melbourne. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24090427 | 24090427 |
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]);