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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
54442 | 54442 | 1934-08-18 | 6 | c | British industrial delegation visits Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24096128 | 24096128 | |
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 | |
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 | |
54437 | 54437 | 1934-08-18 | 6 | a | Drought in America. | America | 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 | |
54439 | 54439 | 1934-08-18 | 6 | b | Farmers in 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 | |
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 | |
54438 | 54438 | 1934-08-18 | 6 | a | Funeral for the German president. | Germany | http://trove.nla.gov.au/newspaper/page/24096128 | 24096128 | |
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 | |
54427 | 54427 | 1934-08-18 | 3 | a | Huang Yin's attitude is unclear. | China | http://trove.nla.gov.au/newspaper/page/24096123 | 24096123 | |
54440 | 54440 | 1934-08-18 | 6 | c | Peace back to the south Xinjiang. | China | http://trove.nla.gov.au/newspaper/page/24096128 | 24096128 | |
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 | |
54443 | 54443 | 1934-08-18 | 6 | c | Rickshaw men on strike in Shanghai. | China | 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 | |
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 |
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]);