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 |
---|---|---|---|---|---|---|---|---|---|
55284 | 55284 | 1935-07-27 | 2 | b | Yu Xuezhong is removed while Huang Fu becomes governor of Hebei province. | China | http://trove.nla.gov.au/newspaper/page/24096513 | 24096513 | |
55285 | 55285 | 1935-07-27 | 2 | b | The central government in Nanjing and its attitudes towards north China crisis. | China | http://trove.nla.gov.au/newspaper/page/24096513 | 24096513 | |
55286 | 55286 | 1935-07-27 | 2 | c | The national crisis in China and the suppression of the communist troops in the southwest. | China | http://trove.nla.gov.au/newspaper/page/24096513 | 24096513 | |
55287 | 55287 | 1935-07-27 | 2 | f | Transportation in Guizhou province. Qin Dechun returns to Chaha'er. Exhibition of air defence equipment in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24096513 | 24096513 | |
55288 | 55288 | 1935-07-27 | 3 | a | European views on Japanese invasion of north China. | Britain | http://trove.nla.gov.au/newspaper/page/24096512 | 24096512 | |
55289 | 55289 | 1935-07-27 | 3 | c | Russian government denies any military agreement with Mongolia. Russian government expands its naval forces. | Russia | http://trove.nla.gov.au/newspaper/page/24096512 | 24096512 | |
55290 | 55290 | 1935-07-27 | 3 | c | British newspaper condemns Japanese invasion of north China. | Britain | http://trove.nla.gov.au/newspaper/page/24096512 | 24096512 | |
55291 | 55291 | 1935-07-27 | 3 | d | Japan protests against Britain and America. | Japan | http://trove.nla.gov.au/newspaper/page/24096512 | 24096512 | |
55292 | 55292 | 1935-07-27 | 5 | a | Song Zheyuan is removed once again and the comments. | China | http://trove.nla.gov.au/newspaper/page/24096514 | 24096514 | |
55293 | 55293 | 1935-07-27 | 5 | c | Comments written by Gu Dezhong on the Republic of China in the past 24 years. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096514 | 24096514 | |
55294 | 55294 | 1935-07-27 | 5 | e | Chinese communities in Sydney donate to the establishment of Hanchi Hospital and its nurse school. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096514 | 24096514 | |
55295 | 55295 | 1935-07-27 | 6-7 | a-f | Guangdong news/ Protest of civilians in the southwest against Japanese invasion of north China. Zou Lu issues a circular telegram against Japanese invasion of north China. Lin Yungai proposes to study women traffic. Guangdong Overseas Chinese Commission is set up. Declaration issued by students' association of Zhongshan University. Shanghai's foreign trade in the past five months. Chaste woman in Taishan seeks another marriage. Security troops in Dongguan shoot passers-by. Security troops in Zhongshan county reshuffled. | China | http://trove.nla.gov.au/newspaper/page/24096517 | 24096517 | |
55296 | 55296 | 1935-07-27 | 8 | a | Britain repays debts to America and the report. | Britain | http://trove.nla.gov.au/newspaper/page/24096519 | 24096519 | |
55297 | 55297 | 1935-07-27 | 8 | b | Japanese authority arrests communist activists. | Japan | http://trove.nla.gov.au/newspaper/page/24096519 | 24096519 | |
55298 | 55298 | 1935-07-27 | 8 | c | Australian Prime Minister Lyon visits Canada and an accident. | Canada | http://trove.nla.gov.au/newspaper/page/24096519 | 24096519 | |
55299 | 55299 | 1935-07-27 | 8 | c | Another earthquake in Taiwan. | Britain | http://trove.nla.gov.au/newspaper/page/24096519 | 24096519 | |
55300 | 55300 | 1935-07-27 | 8 | d | Egypt abrogates trade agreement with Japan. | Britain | http://trove.nla.gov.au/newspaper/page/24096519 | 24096519 | |
55301 | 55301 | 1935-07-27 | 8 | d | Floods in Shandong and Hubei province in China. | China | http://trove.nla.gov.au/newspaper/page/24096519 | 24096519 | |
55302 | 55302 | 1935-07-27 | 8 | e | Trade disputes between Japan and Canada. | America | http://trove.nla.gov.au/newspaper/page/24096519 | 24096519 | |
55303 | 55303 | 1935-07-27 | 8 | e | Japanese envoy comes to visit Australia. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24096519 | 24096519 | |
55304 | 55304 | 1935-07-27 | 8 | f | Australia news/ Celebrations in Sydney for the 150th anniversary of the city. Queensland may restrict banana growing. Japanese man is on trial in Sydney for drug smuggling. Bandits in Sydney rob jewellery shop. Sand storm in South Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096519 | 24096519 |
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]);