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 |
---|---|---|---|---|---|---|---|---|---|
54545 | 54545 | 1934-09-29 | 2 | c | China news/ Liaison between Chinese troops in Manchuria. Battles in Tanggu near Tianjin. Manoeuvre of foreign troops in north China. Japanese and Korean people are selling drugs in the war zones in north China. Japanese goods in the war zones of China. Japanese fleet near Tanggu. | China | http://trove.nla.gov.au/newspaper/page/24096174 | 24096174 | |
54547 | 54547 | 1934-09-29 | 2 | d | Liu Xiang resigns suddenly. | China | http://trove.nla.gov.au/newspaper/page/24096174 | 24096174 | |
54548 | 54548 | 1934-09-29 | 2 | e | Hails after serious drought in Hubei province, China. | China | http://trove.nla.gov.au/newspaper/page/24096174 | 24096174 | |
54549 | 54549 | 1934-09-29 | 2 | e | Possible famine in Zhejiang province. | China | http://trove.nla.gov.au/newspaper/page/24096174 | 24096174 | |
54550 | 54550 | 1934-09-29 | 2 | f | Both Japan and Russia are preparing for war. | China | http://trove.nla.gov.au/newspaper/page/24096174 | 24096174 | |
54555 | 54555 | 1934-09-29 | 3 | d | Japanese warships on the way to Dalian in Liaoning province. | China | http://trove.nla.gov.au/newspaper/page/24096173 | 24096173 | |
54556 | 54556 | 1934-09-29 | 3 | d | Elegiac writings by decedents of Confucius. | China | http://trove.nla.gov.au/newspaper/page/24096173 | 24096173 | |
54557 | 54557 | 1934-09-29 | 3 | d | Chen Duxiu in the Suzhou prison, Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/24096173 | 24096173 | |
54559 | 54559 | 1934-09-29 | 7-8 | a-f | Guangdong news/ Wang Jingwei writes to Hu Hanmin for the cooperation between Guangzhou and Nanjing. The Chinese communists gather their forces to attack Fuzhou. The Guangdong airforce after two accidents. Provincial Legislature Assembly organised in Guangzhou and candidates for the speakers. Hooligans in Guangzhou and their fighting. Chen Yuanying on the sale of local products on the Guangzhou market. Floods in local Guangdong. Rural economy declines in Zhongshan county. Gold mine in Enping. | China | http://trove.nla.gov.au/newspaper/page/24096177 | 24096177 | |
54561 | 54561 | 1934-09-29 | 6 | a | Manchurian state government seeks recognition of Australian government. | China | http://trove.nla.gov.au/newspaper/page/24096178 | 24096178 | |
54563 | 54563 | 1934-09-29 | 6 | b | Chinese pirates in the South China Sea. | China | http://trove.nla.gov.au/newspaper/page/24096178 | 24096178 |
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]);