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 |
---|---|---|---|---|---|---|---|---|---|
55299 | 55299 | 1935-07-27 | 8 | c | Another earthquake in Taiwan. | Britain | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
55300 | 55300 | 1935-07-27 | 8 | d | Egypt abrogates trade agreement with Japan. | Britain | http://trove.nla.gov.au/newspaper/page/24096519 | 24096519 | |
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 | |
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 | |
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 | |
55291 | 55291 | 1935-07-27 | 3 | d | Japan protests against Britain and America. | Japan | http://trove.nla.gov.au/newspaper/page/24096512 | 24096512 | |
55297 | 55297 | 1935-07-27 | 8 | b | Japanese authority arrests communist activists. | Japan | 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 | |
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 | |
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 | |
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 | |
55302 | 55302 | 1935-07-27 | 8 | e | Trade disputes between Japan and Canada. | America | http://trove.nla.gov.au/newspaper/page/24096519 | 24096519 | |
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 | |
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 |
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]);