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 |
---|---|---|---|---|---|---|---|---|---|
54447 | 54447 | 1934-08-25 | 2 | b | China news/ Drought in north China. Shi Yousan seeks to stage a comeback. Gu Weijun on the international affairs. Russia and Japan may have confrontation. Japanese conspiracy in north China. Authority on the railway from Beijing to Shenyang. Ancient graves found in the east of Xuzhou, north Jiangsu province. | China | http://trove.nla.gov.au/newspaper/page/24096134 | 24096134 | |
54448 | 54448 | 1934-08-25 | 2 | f | Communist leader Chen Duxiu is sentenced. | China | http://trove.nla.gov.au/newspaper/page/24096134 | 24096134 | |
54449 | 54449 | 1934-08-25 | 2 | f | The Nanjing government orders to celebrate the birthday of Confucius. | China | http://trove.nla.gov.au/newspaper/page/24096134 | 24096134 | |
54450 | 54450 | 1934-08-25 | 2 | f | Chinese troops in Jilin and Heilongjiang and their resistance to Japanese invasion. | China | http://trove.nla.gov.au/newspaper/page/24096134 | 24096134 | |
54452 | 54452 | 1934-08-25 | 3 | a | Chinese government bans a British magazine for its pro-Manchurian publications. | China | http://trove.nla.gov.au/newspaper/page/24096133 | 24096133 | |
54453 | 54453 | 1934-08-25 | 3 | b | New Japanese foreign minister and his foreign policy. | China | http://trove.nla.gov.au/newspaper/page/24096133 | 24096133 | |
54457 | 54457 | 1934-08-25 | 3 | e | Couplets written by Deng Tiemei in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24096133 | 24096133 | |
54458 | 54458 | 1934-08-25 | 3 | f | Japanese preparation for the war with Russia. | China | http://trove.nla.gov.au/newspaper/page/24096133 | 24096133 | |
54459 | 54459 | 1934-08-25 | 7-8 | a-f | Guangdong news/ Jiang Jieshi may raise the issue of national president at the coming plenary meeting in Nanjing. Xiao Focheng is not satisfied with the draft constitution. Preparation for another plenary session in Nanjing. Cai Tingkai is welcomed in Holland. Guangdong proposes to elect the provincial governor. Road project on the border of Fujian, Guangdong and Jiangxi. Business in Hong Kong and Nanyang. Commercial chambers in Guangzhou and the economic recovery. Floods in Zhongshan. Poor harvest of lichee in Zengcheng. Bandits in Dongguan. Fireworks factory in Nanhai explodes. | China | http://trove.nla.gov.au/newspaper/page/24096137 | 24096137 | |
54463 | 54463 | 1934-08-25 | 6 | d | Floods in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096138 | 24096138 |
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]);