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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
54330 | 54330 | 1934-07-21 | 2 | e | Japanese immigration to Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096092 | 24096092 | |
54331 | 54331 | 1934-07-21 | 2 | e | Yan Huiqing predicts the second world war. | China | http://trove.nla.gov.au/newspaper/page/24096092 | 24096092 | |
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 | |
54333 | 54333 | 1934-07-21 | 2 | f | Japanese businessmen in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24096092 | 24096092 | |
54334 | 54334 | 1934-07-21 | 2 | f | Chinese student murdered in Japan. | 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 | |
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 | |
54337 | 54337 | 1934-07-21 | 3 | b | Political chaos in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24096091 | 24096091 | |
54338 | 54338 | 1934-07-21 | 3 | d | War clouds over Japan and Russia. | China | http://trove.nla.gov.au/newspaper/page/24096091 | 24096091 | |
54339 | 54339 | 1934-07-21 | 3 | d | Japanese authority deports Chinese immigrants. | China | http://trove.nla.gov.au/newspaper/page/24096091 | 24096091 | |
54340 | 54340 | 1934-07-21 | 3 | e | Economic development in Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24096091 | 24096091 | |
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 | |
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 | |
54345 | 54345 | 1934-07-21 | 6 | a | The Nationalist government in Nanjing resigns. | China | http://trove.nla.gov.au/newspaper/page/24096096 | 24096096 | |
54346 | 54346 | 1934-07-21 | 6 | a | Revision of the Chinese constitution. | China | http://trove.nla.gov.au/newspaper/page/24096096 | 24096096 | |
54347 | 54347 | 1934-07-21 | 6 | b | Drought and floods in Japan. | Japan | 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 | |
54349 | 54349 | 1934-07-21 | 6 | c | Strike in San Francisco. | America | 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 | |
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 |
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]);