This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
52630 | 52630 | 1933-03-11 | 2 | c | Zhang Ji proposes to develop the northwest of China as soon as possible. | China | http://trove.nla.gov.au/newspaper/page/24091148 | 24091148 | |
52631 | 52631 | 1933-03-11 | 2 | d | Jiang Jieshi treats Duan Qirui with due respect. | China | http://trove.nla.gov.au/newspaper/page/24091148 | 24091148 | |
52632 | 52632 | 1933-03-11 | 2 | d | Emperor of Japan on the proposal to quit the League of Nations. | China | http://trove.nla.gov.au/newspaper/page/24091148 | 24091148 | |
52633 | 52633 | 1933-03-11 | 2 | e | Zhang Zhiben talks on the administration of law. | China | http://trove.nla.gov.au/newspaper/page/24091148 | 24091148 | |
52634 | 52634 | 1933-03-11 | 2 | e | Wu Chaoshu on the international affairs. | China | http://trove.nla.gov.au/newspaper/page/24091148 | 24091148 | |
52635 | 52635 | 1933-03-11 | 2 | e | Aviation to save China, a call in Shanghai and Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24091148 | 24091148 | |
52636 | 52636 | 1933-03-11 | 2 | f | The railway project from Guangzhou to Hankou to be completed in four years. Yan Xishan's ten-year industrial development plan. | China | http://trove.nla.gov.au/newspaper/page/24091148 | 24091148 | |
52637 | 52637 | 1933-03-11 | 2 | f | Chinese communities in the Philippines donate war planes to the 19th Route Army. | China | http://trove.nla.gov.au/newspaper/page/24091148 | 24091148 | |
52638 | 52638 | 1933-03-11 | 2 | f | The road project from Shanghai to Nanjing and the riots. | China | http://trove.nla.gov.au/newspaper/page/24091148 | 24091148 | |
52639 | 52639 | 1933-03-11 | 3 | a | American government refuses to recognise Japanese existence in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091147 | 24091147 | |
52640 | 52640 | 1933-03-11 | 3 | b | The puppet Manchurian government and the imperial restoration movement. | China | http://trove.nla.gov.au/newspaper/page/24091147 | 24091147 | |
52641 | 52641 | 1933-03-11 | 3 | c | Japanese troops suppress rebellions of the Chinese people in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24091147 | 24091147 | |
52642 | 52642 | 1933-03-11 | 3 | d | Ma Hongkui issues an open letter to the people of Ningxia province. | China | http://trove.nla.gov.au/newspaper/page/24091147 | 24091147 | |
52644 | 52644 | 1933-03-11 | 3 | f | Chinese cargo ship is hijacked outside of Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091147 | 24091147 | |
52645 | 52645 | 1933-03-11 | 5 | a | He Ying (Gongzhuo), police chief in Guangzhou, is learning to dance. | China | http://trove.nla.gov.au/newspaper/page/24091149 | 24091149 | |
52648 | 52648 | 1933-03-11 | 7-8 | a-e | Guangdong news/ Battles with the Chinese communist forces on the border of Guangdong. Army commander of Guangdong Li Yangjing may go overseas again. Volunteer armies organised in Guangdong for the resistance to Japanese invasion. Airforce troops in Guangzhou to build an aircraft factory. Guizhou people in Guangdong mediate the internal fighting in their home province. Li Hanhun, appeasement Commissioner in the northwest of Guangdong, tries to assimilate the Yao minority people in Lianxian and Yangshan county. A tragedy in Taishan county. Educational authority in Shantou prohibits girl students from wearing bizarre clothes. Agricultural production in Nanhai and Shunde villages. Taishan county to develop a new site. Bandits in Nanhai county kidnap a boy. Joint security plan in Nanhai county. Commercial chambers in Jiangmen to build a new market. A robbery in Zijin county. Business in Jiujiang last winter. A man in Huiyang hounds his younger brother to death. A rich businessman in Zhaoqing is robbed. | China | http://trove.nla.gov.au/newspaper/page/24091151 | 24091151 | |
52654 | 52654 | 1933-03-11 | 6 | b | News from radio in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24091152 | 24091152 | |
52655 | 52655 | 1933-03-11 | 6 | c | The war between China and Japan. | China | http://trove.nla.gov.au/newspaper/page/24091152 | 24091152 |
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]);