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 |
|---|---|---|---|---|---|---|---|---|---|
| 54446 | 54446 | 1934-08-25 | 2 | a | Science is the backbone of cultural development, comments by Tung Wah Times editorial. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096134 | 24096134 | |
| 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 | |
| 54451 | 54451 | 1934-08-25 | 3 | a | Britain, America and Japan and their disarmament plans. | Britain | http://trove.nla.gov.au/newspaper/page/24096133 | 24096133 | |
| 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 | |
| 54454 | 54454 | 1934-08-25 | 3 | c | Russia may join the League of Nations in September. | Other... | http://trove.nla.gov.au/newspaper/page/24096133 | 24096133 | |
| 54455 | 54455 | 1934-08-25 | 3 | c | Chinese ambassador in Washington Shi Zhaoji criticises American policy in the Far East. | America | http://trove.nla.gov.au/newspaper/page/24096133 | 24096133 | |
| 54456 | 54456 | 1934-08-25 | 3 | e | American new plan for the naval growth. | America | 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 | |
| 54460 | 54460 | 1934-08-25 | 6 | a | Bandits in Canada and a case of kidnap. | Canada | http://trove.nla.gov.au/newspaper/page/24096138 | 24096138 | |
| 54461 | 54461 | 1934-08-25 | 6 | a | Gold in the Himalayan mountains. | Other... | http://trove.nla.gov.au/newspaper/page/24096138 | 24096138 | |
| 54462 | 54462 | 1934-08-25 | 6 | c | British businessmen purchase and shipping silver to America. | Britain | http://trove.nla.gov.au/newspaper/page/24096138 | 24096138 | |
| 54463 | 54463 | 1934-08-25 | 6 | d | Floods in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24096138 | 24096138 | |
| 54464 | 54464 | 1934-08-25 | 6 | e | Australia news/ Floods in NSW. Beautiful girls are thieves in Sydney. A robbery in Sydney. Chinese Chamber of Commerce in Sydney donate to the charity institutions. A girl dies in Anthony Hordan Department Store in Sydney. | Tung Wah | 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]);