This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id
Link | rowid | date | page | column ▼ | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
54353 | 54353 | 1934-07-28 | 2 | a | Editorial by Tung Wah Times on the Japanese in China and their opium trade. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096100 | 24096100 | |
54360 | 54360 | 1934-07-28 | 3 | a | Competition between Russia and Japan in the Far East. | China | http://trove.nla.gov.au/newspaper/page/24096099 | 24096099 | |
54361 | 54361 | 1934-07-28 | 3 | a | Mexico recognises the Manchurian state and the comments by Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24096099 | 24096099 | |
54375 | 54375 | 1934-07-28 | 5 | a | Nanjing authority dispatches more troops to Fujian. | China | http://trove.nla.gov.au/newspaper/page/24096101 | 24096101 | |
54378 | 54378 | 1934-07-28 | 6 | a | Drought and floods in China. | China | http://trove.nla.gov.au/newspaper/page/24096104 | 24096104 | |
54379 | 54379 | 1934-07-28 | 6 | a | The communist troops siege Funing county in Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24096104 | 24096104 | |
54377 | 54377 | 1934-07-28 | 7-8 | a-f | Guangdong news/ Jiang Jieshi regains his control of the Chinese airforce troops. Jiang Jieshi seeks to recruit all deserted soldiers of the 19th Route Army. Jiang Jieshi still keen to punish rebellions in Fujian province. Joint defence conference of Guangdong, Fujian and Guangxi. Heavy rain and floods in Shantou. Carpet industry in China. Report of the Kowloon customs on the tariff revenue. Heavy rains in Nanhai. Agriculture in Dongguan. Bandits in Zengcheng. Taishan is flooded. Villagers in Zhaoqing refuse to pay land tax. | China | http://trove.nla.gov.au/newspaper/page/24096103 | 24096103 | |
54354 | 54354 | 1934-07-28 | 2 | b | More Japanese troops arrive north China. | China | http://trove.nla.gov.au/newspaper/page/24096100 | 24096100 | |
54355 | 54355 | 1934-07-28 | 2 | b | Silver dollar with Soviet seal found in Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24096100 | 24096100 | |
54362 | 54362 | 1934-07-28 | 3 | b | Students in Beijing smash the Republic News (minguo ribao) office. | China | http://trove.nla.gov.au/newspaper/page/24096099 | 24096099 | |
54363 | 54363 | 1934-07-28 | 3 | b | America to build airforce base in Alaska as a preparation for the war with Japan. | China | http://trove.nla.gov.au/newspaper/page/24096099 | 24096099 | |
54380 | 54380 | 1934-07-28 | 6 | b | Failed strike in San Francisco and a further report. | America | http://trove.nla.gov.au/newspaper/page/24096104 | 24096104 | |
54381 | 54381 | 1934-07-28 | 6 | b | Floods in Poland. | Other... | http://trove.nla.gov.au/newspaper/page/24096104 | 24096104 | |
54356 | 54356 | 1934-07-28 | 2 | c | Railway project to connect Beijing and Shenyang. | China | http://trove.nla.gov.au/newspaper/page/24096100 | 24096100 | |
54364 | 54364 | 1934-07-28 | 3 | c | Sufferings of Chinese labourers under Japanese control. | China | http://trove.nla.gov.au/newspaper/page/24096099 | 24096099 | |
54365 | 54365 | 1934-07-28 | 3 | c | Russian troops on exercise. | China | http://trove.nla.gov.au/newspaper/page/24096099 | 24096099 | |
54357 | 54357 | 1934-07-28 | 2 | d | Japanese in Shanghai beat British police officer. | China | http://trove.nla.gov.au/newspaper/page/24096100 | 24096100 | |
54366 | 54366 | 1934-07-28 | 3 | d | Britain expands its airforce troops. | Britain | http://trove.nla.gov.au/newspaper/page/24096099 | 24096099 | |
54367 | 54367 | 1934-07-28 | 3 | d | Japanese governor in Taiwan convenes a conference for the possible changes. | China | http://trove.nla.gov.au/newspaper/page/24096099 | 24096099 | |
54368 | 54368 | 1934-07-28 | 3 | d | American fleet to return to its Pacific base. | America | http://trove.nla.gov.au/newspaper/page/24096099 | 24096099 | |
54382 | 54382 | 1934-07-28 | 6 | d | Air defence in London. | Britain | http://trove.nla.gov.au/newspaper/page/24096104 | 24096104 | |
54383 | 54383 | 1934-07-28 | 6 | d | Earthquake in Solomon islands. | Other... | http://trove.nla.gov.au/newspaper/page/24096104 | 24096104 | |
54384 | 54384 | 1934-07-28 | 6 | d | Maori people in New Zealand and their religion. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096104 | 24096104 | |
54358 | 54358 | 1934-07-28 | 2 | e | Resistance of Chinese troops to Japanese invasion in Manchuria. | France | http://trove.nla.gov.au/newspaper/page/24096100 | 24096100 | |
54369 | 54369 | 1934-07-28 | 3 | e | Floods in Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24096099 | 24096099 | |
54370 | 54370 | 1934-07-28 | 3 | e | Train derails between Nanjing and Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24096099 | 24096099 | |
54371 | 54371 | 1934-07-28 | 3 | e | Chinese navy builds new warship. | China | http://trove.nla.gov.au/newspaper/page/24096099 | 24096099 | |
54372 | 54372 | 1934-07-28 | 3 | e | Gandhi is bombed in India. | Other... | http://trove.nla.gov.au/newspaper/page/24096099 | 24096099 | |
54376 | 54376 | 1934-07-28 | 5 | e | Dozens of Chinese in Waipawa, central New Zealand, organise an association. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096101 | 24096101 | |
54385 | 54385 | 1934-07-28 | 6 | e | British troops in north China and their exercise. | China | http://trove.nla.gov.au/newspaper/page/24096104 | 24096104 | |
54359 | 54359 | 1934-07-28 | 2 | f | Anti-Chinese movement ceases in Mexico. | China | http://trove.nla.gov.au/newspaper/page/24096100 | 24096100 | |
54373 | 54373 | 1934-07-28 | 3 | f | American weapon export to China and Japan. | America | http://trove.nla.gov.au/newspaper/page/24096099 | 24096099 | |
54374 | 54374 | 1934-07-28 | 3 | f | Road construction in the northwest of China. | China | http://trove.nla.gov.au/newspaper/page/24096099 | 24096099 | |
54386 | 54386 | 1934-07-28 | 6 | f | Australia news/ Epidemic disease in northwest Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096104 | 24096104 |
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]);