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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
54383 | 54383 | 1934-07-28 | 6 | d | Earthquake in Solomon islands. | Other... | http://trove.nla.gov.au/newspaper/page/24096104 | 24096104 | |
54382 | 54382 | 1934-07-28 | 6 | d | Air defence in London. | Britain | 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 | |
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 | |
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 | |
54378 | 54378 | 1934-07-28 | 6 | a | Drought and floods in China. | 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 | |
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 | |
54375 | 54375 | 1934-07-28 | 5 | a | Nanjing authority dispatches more troops to Fujian. | China | http://trove.nla.gov.au/newspaper/page/24096101 | 24096101 | |
54374 | 54374 | 1934-07-28 | 3 | f | Road construction in the northwest of China. | China | http://trove.nla.gov.au/newspaper/page/24096099 | 24096099 | |
54373 | 54373 | 1934-07-28 | 3 | f | American weapon export to China and Japan. | America | 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 | |
54371 | 54371 | 1934-07-28 | 3 | e | Chinese navy builds new warship. | 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 | |
54369 | 54369 | 1934-07-28 | 3 | e | Floods in Hunan province. | 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 | |
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 | |
54366 | 54366 | 1934-07-28 | 3 | d | Britain expands its airforce troops. | Britain | 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 | |
54364 | 54364 | 1934-07-28 | 3 | c | Sufferings of Chinese labourers under Japanese control. | 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 | |
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 | |
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 | |
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 | |
54359 | 54359 | 1934-07-28 | 2 | f | Anti-Chinese movement ceases in Mexico. | China | http://trove.nla.gov.au/newspaper/page/24096100 | 24096100 | |
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 | |
54357 | 54357 | 1934-07-28 | 2 | d | Japanese in Shanghai beat British police officer. | China | http://trove.nla.gov.au/newspaper/page/24096100 | 24096100 | |
54356 | 54356 | 1934-07-28 | 2 | c | Railway project to connect Beijing and Shenyang. | 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 | |
54354 | 54354 | 1934-07-28 | 2 | b | More Japanese troops arrive north China. | China | http://trove.nla.gov.au/newspaper/page/24096100 | 24096100 | |
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 |
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]);