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 |
---|---|---|---|---|---|---|---|---|---|
55809 | 55809 | 1936-02-22 | 2 | b | Editorial on the last opportunity to save China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096752 | 24096752 | |
55810 | 55810 | 1936-02-22 | 2 | d | Jiang Jieshi to set Sichuan and Shaanxi as the basis to save China. | China | http://trove.nla.gov.au/newspaper/page/24096752 | 24096752 | |
55811 | 55811 | 1936-02-22 | 2 | d | Yan Xishan prefers to stay in Taiyuan, Shanxi province. | China | http://trove.nla.gov.au/newspaper/page/24096752 | 24096752 | |
55812 | 55812 | 1936-02-22 | 2 | d | Sun Dianying arrives Beijing to see doctor. Traitor Zhao Lei and others and their collaboration with Japanese invaders to taking over Tianjin. Economic Commission plans to dredge the Huaihe River to the sea. Ma Zhanshan puts forward his proposals to Jiang Jieshi. | China | http://trove.nla.gov.au/newspaper/page/24096752 | 24096752 | |
55813 | 55813 | 1936-02-22 | 2 | e | The Sun Company opens new department store in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24096752 | 24096752 | |
55814 | 55814 | 1936-02-22 | 2 | f | Japanese military officers in north China request to send more troops to China. | China | http://trove.nla.gov.au/newspaper/page/24096752 | 24096752 | |
55815 | 55815 | 1936-02-22 | 3 | a | Hu Hanmin arrives in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24096751 | 24096751 | |
55816 | 55816 | 1936-02-22 | 3 | c | Fang Zhenwu arrives New York. | America | http://trove.nla.gov.au/newspaper/page/24096751 | 24096751 | |
55817 | 55817 | 1936-02-22 | 3 | d | British government to expand its military forces. | Britain | http://trove.nla.gov.au/newspaper/page/24096751 | 24096751 | |
55818 | 55818 | 1936-02-22 | 3 | d | Japanese exploit natural resources in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096751 | 24096751 | |
55819 | 55819 | 1936-02-22 | 3 | d | Military agreement between France and Britain and the response of Germany. | Britain | http://trove.nla.gov.au/newspaper/page/24096751 | 24096751 | |
55820 | 55820 | 1936-02-22 | 3 | d | Japanese army commander in China returns to Changchun, Jilin province. | China | http://trove.nla.gov.au/newspaper/page/24096751 | 24096751 | |
55821 | 55821 | 1936-02-22 | 5 | a | A case of incest in Fujian province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096753 | 24096753 | |
55822 | 55822 | 1936-02-22 | 2 | b | Du Zhongyuan in the prison. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096752 | 24096752 | |
55823 | 55823 | 1936-02-22 | 6-7 | a-d | Guangdong news/ Hu Hanmin arrives Hong Kong. More unemployed Chinese are returning from Dutch colonies. Chinese airforce troops send trainees to Germany. Guangzhou students organise volunteer armies to save China. Japanese counsel is satisfied with punishment of the students. Decline of sale of Chinese tea in Java. Two villages are in fighting between Dongguan and Zengcheng. Police in Taishan seize drugs. Xinhui county authority raid gambling dens. Dongguan county government to reform local administration. Two fruit ships sink in Shunde after a collision. | China | http://trove.nla.gov.au/newspaper/page/24096756 | 24096756 | |
55824 | 55824 | 1936-02-22 | 8 | a | Japanese ambition to control north China. | China | http://trove.nla.gov.au/newspaper/page/24096758 | 24096758 | |
55825 | 55825 | 1936-02-22 | 8 | f | Australia news/ State election in Western Australia. Heavy rains in north Queensland. British naval fleet in the Suez Canal. Sydney tests its cannons for defence. Twenty-one people share first prize of the lottery. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096758 | 24096758 |
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]);