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 |
---|---|---|---|---|---|---|---|---|---|
54437 | 54437 | 1934-08-18 | 6 | a | Drought in America. | America | http://trove.nla.gov.au/newspaper/page/24096128 | 24096128 | |
54444 | 54444 | 1934-08-18 | 6 | c | Russian newspaper condemns Japan. | Britain | http://trove.nla.gov.au/newspaper/page/24096128 | 24096128 | |
54426 | 54426 | 1934-08-18 | 2 | b | China news/ Drought and floods in China. A visit to Shenyang under Japanese control. Japan prepares for war with Russia. Japanese policemen on the railway from Beijing to Shenyang. The bridge on the Qiantang River in Zhejiang province. Korean villages under attack in Jilin province. Resistance of Chinese armies in Manchuria to Japanese invasion. Japanese consuls from south China meet in Taiwan. | China | http://trove.nla.gov.au/newspaper/page/24096124 | 24096124 | |
54427 | 54427 | 1934-08-18 | 3 | a | Huang Yin's attitude is unclear. | China | http://trove.nla.gov.au/newspaper/page/24096123 | 24096123 | |
54428 | 54428 | 1934-08-18 | 3 | a | Plain clothes spies in Shenyang and bomb explosion. Agricultural production in north China. Japanese military officer tries to steal classified documents from Russian consulate. Chinese volunteer armies in Manchuria and their resistance to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24096123 | 24096123 | |
54431 | 54431 | 1934-08-18 | 3 | b | Cai Tingkai now in Belgium. | China | http://trove.nla.gov.au/newspaper/page/24096123 | 24096123 | |
54432 | 54432 | 1934-08-18 | 3 | c | Cao Rulin and Wang Jitang may surrender themselves. | China | http://trove.nla.gov.au/newspaper/page/24096123 | 24096123 | |
54436 | 54436 | 1934-08-18 | 7-8 | a-f | Guangdong news/ Blocks to the cooperation between Guangzhou and Nanjing. British government and the aviation development in Hong Kong. The Nanjing government tries to unify financial administration nation-wide. Wang Chonghui arrives Guangzhou. Macao government and its disputes with the Nanhai county over an infrastructure project. Japanese seek for the contract of water project in Macao. Reduction of tariff rate on some imported goods. Floods in Zhongshan. Shopkeepers in Dongguan on strike. A case of murder in Nanhai. Bandits in Zengcheng. Clan fighting in Taishan. | China | http://trove.nla.gov.au/newspaper/page/24096127 | 24096127 | |
54440 | 54440 | 1934-08-18 | 6 | c | Peace back to the south Xinjiang. | China | http://trove.nla.gov.au/newspaper/page/24096128 | 24096128 | |
54443 | 54443 | 1934-08-18 | 6 | c | Rickshaw men on strike in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24096128 | 24096128 | |
54438 | 54438 | 1934-08-18 | 6 | a | Funeral for the German president. | Germany | http://trove.nla.gov.au/newspaper/page/24096128 | 24096128 | |
54429 | 54429 | 1934-08-18 | 3 | c | Floods in Japan and riots of the refugees. | Japan | http://trove.nla.gov.au/newspaper/page/24096123 | 24096123 | |
54430 | 54430 | 1934-08-18 | 3 | c | American navy and their exercise in the Pacific. | Japan | http://trove.nla.gov.au/newspaper/page/24096123 | 24096123 | |
54439 | 54439 | 1934-08-18 | 6 | b | Farmers in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24096128 | 24096128 | |
54442 | 54442 | 1934-08-18 | 6 | c | British industrial delegation visits Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24096128 | 24096128 | |
54441 | 54441 | 1934-08-18 | 6 | c | Fire in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24096128 | 24096128 | |
54425 | 54425 | 1934-08-18 | 2 | a | Editorial by Tung Wah Times claims that only the government officials to be blamed for the current national crisis in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096124 | 24096124 | |
54433 | 54433 | 1934-08-18 | 5 | a | Story of the Luoyang Bridge in Fujian province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096125 | 24096125 | |
54434 | 54434 | 1934-08-18 | 5 | c | A request to ban dating of boys and girls. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096125 | 24096125 | |
54435 | 54435 | 1934-08-18 | 5 | f | A farewell party at the Melbourne Chinese School and the detailed report. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096125 | 24096125 | |
54445 | 54445 | 1934-08-18 | 6 | e | Australia news/ Federal defence minister on the national defence. Bandits in Sydney rob post office. Chinese boxing coach comes to visit Australia. A man is sentenced in Darwin for opium smuggling. Strange disease found in north Queensland. Ferry sinks in Cairns, Queensland. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096128 | 24096128 |
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]);