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 |
---|---|---|---|---|---|---|---|---|---|
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 |
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]);