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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
55817 | 55817 | 1936-02-22 | 3 | d | British government to expand its military forces. | Britain | http://trove.nla.gov.au/newspaper/page/24096751 | 24096751 | |
55822 | 55822 | 1936-02-22 | 2 | b | Du Zhongyuan in the prison. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096752 | 24096752 | |
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 | |
55816 | 55816 | 1936-02-22 | 3 | c | Fang Zhenwu arrives New York. | America | http://trove.nla.gov.au/newspaper/page/24096751 | 24096751 | |
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 | |
55815 | 55815 | 1936-02-22 | 3 | a | Hu Hanmin arrives in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24096751 | 24096751 | |
55824 | 55824 | 1936-02-22 | 8 | a | Japanese ambition to control north China. | China | http://trove.nla.gov.au/newspaper/page/24096758 | 24096758 | |
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 | |
55818 | 55818 | 1936-02-22 | 3 | d | Japanese exploit natural resources in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096751 | 24096751 | |
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 | |
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 | |
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 | |
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 | |
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 |
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]);