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 |
---|---|---|---|---|---|---|---|---|---|
54352 | 54352 | 1934-07-21 | 6 | e | Australia news/ Investigation of the robbery in Sydney. Opium stolen from the customs office in Cairns, Queensland. China is a natural market for Australia. Italian shop in Sydney is robbed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096096 | 24096096 | |
54348 | 54348 | 1934-07-21 | 6 | b | Britain requests Japan to open the bridge on the Yalu River. | Japan | http://trove.nla.gov.au/newspaper/page/24096096 | 24096096 | |
54334 | 54334 | 1934-07-21 | 2 | f | Chinese student murdered in Japan. | China | http://trove.nla.gov.au/newspaper/page/24096092 | 24096092 | |
54347 | 54347 | 1934-07-21 | 6 | b | Drought and floods in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24096096 | 24096096 | |
54350 | 54350 | 1934-07-21 | 6 | c | Drought in China. | China | http://trove.nla.gov.au/newspaper/page/24096096 | 24096096 | |
54351 | 54351 | 1934-07-21 | 6 | d | Earthquake in Afghanistan. | Other... | http://trove.nla.gov.au/newspaper/page/24096096 | 24096096 | |
54340 | 54340 | 1934-07-21 | 3 | e | Economic development in Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24096091 | 24096091 | |
54336 | 54336 | 1934-07-21 | 3 | a | Fujian may follow Manchuria and the crisis in Fujian. | China | http://trove.nla.gov.au/newspaper/page/24096091 | 24096091 | |
54343 | 54343 | 1934-07-21 | 7-8 | a-f | Guangdong news/ Envoys of the Central Government come to Guangdong. Bai Chongxi on the national defence. Discussion on the possibility of cooperation between Guangzhou and Nanjing. Guangdong on the airforce development. British businessmen help tea production in Guangdong. Business between Hong Kong and Nanyang when the rubber prices going up. Effort to sell Chinese silk products to American market. Tax exempted for peanut export in Shandong province. Bandit chieftain Chen Damao is arrested. Dongguan authority suppresses bandits. Heavy rain in Zengcheng. | China | http://trove.nla.gov.au/newspaper/page/24096095 | 24096095 | |
54344 | 54344 | 1934-07-21 | 6 | a | Japan forces foreign countries to recognise the Manchurian state government. | China | http://trove.nla.gov.au/newspaper/page/24096096 | 24096096 | |
54339 | 54339 | 1934-07-21 | 3 | d | Japanese authority deports Chinese immigrants. | China | http://trove.nla.gov.au/newspaper/page/24096091 | 24096091 | |
54333 | 54333 | 1934-07-21 | 2 | f | Japanese businessmen in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24096092 | 24096092 | |
54335 | 54335 | 1934-07-21 | 2 | f | Japanese encourages opium growing in north China. | China | http://trove.nla.gov.au/newspaper/page/24096092 | 24096092 | |
54330 | 54330 | 1934-07-21 | 2 | e | Japanese immigration to Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096092 | 24096092 | |
54328 | 54328 | 1934-07-21 | 2 | a | Japanese wants to occupy Fuzhou and Xiamen in Fujian province and comments by the Tung Wah Times. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096092 | 24096092 | |
54341 | 54341 | 1934-07-21 | 3 | f | Jiang Jieshi discusses in Nanjing with other politicians on the economic development, Sino-Japanese relations and the Manchurian issues. | China | http://trove.nla.gov.au/newspaper/page/24096091 | 24096091 | |
54342 | 54342 | 1934-07-21 | 5 | c | Memorial on the birthday of Wu Xun, a beggar and education advocate in Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24096093 | 24096093 | |
54337 | 54337 | 1934-07-21 | 3 | b | Political chaos in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24096091 | 24096091 | |
54346 | 54346 | 1934-07-21 | 6 | a | Revision of the Chinese constitution. | China | http://trove.nla.gov.au/newspaper/page/24096096 | 24096096 | |
54332 | 54332 | 1934-07-21 | 2 | f | Russia has finished its preparation for the war with Japan. | China | http://trove.nla.gov.au/newspaper/page/24096092 | 24096092 | |
54349 | 54349 | 1934-07-21 | 6 | c | Strike in San Francisco. | America | http://trove.nla.gov.au/newspaper/page/24096096 | 24096096 | |
54345 | 54345 | 1934-07-21 | 6 | a | The Nationalist government in Nanjing resigns. | China | http://trove.nla.gov.au/newspaper/page/24096096 | 24096096 | |
54329 | 54329 | 1934-07-21 | 2 | d | The Nationalist government in Nanjing stops to increase land tax. | China | http://trove.nla.gov.au/newspaper/page/24096092 | 24096092 | |
54338 | 54338 | 1934-07-21 | 3 | d | War clouds over Japan and Russia. | China | http://trove.nla.gov.au/newspaper/page/24096091 | 24096091 | |
54331 | 54331 | 1934-07-21 | 2 | e | Yan Huiqing predicts the second world war. | China | http://trove.nla.gov.au/newspaper/page/24096092 | 24096092 |
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]);