This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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]);