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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
54356 | 54356 | 1934-07-28 | 2 | c | Railway project to connect Beijing and Shenyang. | China | 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 | |
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 | |
54359 | 54359 | 1934-07-28 | 2 | f | Anti-Chinese movement ceases in Mexico. | China | 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
54375 | 54375 | 1934-07-28 | 5 | a | Nanjing authority dispatches more troops to Fujian. | China | http://trove.nla.gov.au/newspaper/page/24096101 | 24096101 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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]);