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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
54437 | 54437 | 1934-08-18 | 6 | a | Drought in America. | America | 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 | |
54439 | 54439 | 1934-08-18 | 6 | b | Farmers in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24096128 | 24096128 | |
54440 | 54440 | 1934-08-18 | 6 | c | Peace back to the south Xinjiang. | China | 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 | |
54442 | 54442 | 1934-08-18 | 6 | c | British industrial delegation visits Japan. | Japan | 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 | |
54444 | 54444 | 1934-08-18 | 6 | c | Russian newspaper condemns Japan. | Britain | http://trove.nla.gov.au/newspaper/page/24096128 | 24096128 | |
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]);