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 |
|---|---|---|---|---|---|---|---|---|---|
| 48387 | 48387 | 1929-08-24 | 2 | b | Editorial by Tung Wah Times on China's declaration of war with Soviet Russia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099331 | 24099331 | |
| 48388 | 48388 | 1929-08-24 | 2 | c | Soviet Russia breaks off diplomatic relations with China and the declaration. | China | http://trove.nla.gov.au/newspaper/page/24099331 | 24099331 | |
| 48389 | 48389 | 1929-08-24 | 2 | c | War clouds over the border between China and the Soviet Russia. Miscellaneous report on the coming war between China and Russia. The Nanjing government has finalised its Soviet Russia policy. | China | http://trove.nla.gov.au/newspaper/page/24099331 | 24099331 | |
| 48390 | 48390 | 1929-08-24 | 2 | e | America and France mediate the conflict between China and Russia. | China | http://trove.nla.gov.au/newspaper/page/24099331 | 24099331 | |
| 48391 | 48391 | 1929-08-24 | 2 | e | Soviet Russian consul is leaving Beiping. | China | http://trove.nla.gov.au/newspaper/page/24099331 | 24099331 | |
| 48392 | 48392 | 1929-08-24 | 2 | e | Zhang Xueliang reports the current situation on the border with Russia. | China | http://trove.nla.gov.au/newspaper/page/24099331 | 24099331 | |
| 48393 | 48393 | 1929-08-24 | 2 | f | Japan's attitude on the railways in Manchuria. | Japan | http://trove.nla.gov.au/newspaper/page/24099331 | 24099331 | |
| 48394 | 48394 | 1929-08-24 | 2 | f | Changes in Soviet Russia and their China policy. | Canada | http://trove.nla.gov.au/newspaper/page/24099331 | 24099331 | |
| 48395 | 48395 | 1929-08-24 | 2 | f | America may invest in the Manchurian railways. | Canada | http://trove.nla.gov.au/newspaper/page/24099331 | 24099331 | |
| 48396 | 48396 | 1929-08-24 | 3 | a | The public declaration issued by the Chinese government against Soviet Russia. | China | http://trove.nla.gov.au/newspaper/page/24099330 | 24099330 | |
| 48397 | 48397 | 1929-08-24 | 3 | b | Foreign minister Wang Zhengting on the railway lines in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24099330 | 24099330 | |
| 48398 | 48398 | 1929-08-24 | 3 | c | Relations between China and Soviet Russia worsening. | China | http://trove.nla.gov.au/newspaper/page/24099330 | 24099330 | |
| 48399 | 48399 | 1929-08-24 | 3 | e | Chinese delegation at the international commercial conference in Holland. | China | http://trove.nla.gov.au/newspaper/page/24099330 | 24099330 | |
| 48400 | 48400 | 1929-08-24 | 3 | e | Partial restructure prepared for the Nanjing government. | China | http://trove.nla.gov.au/newspaper/page/24099330 | 24099330 | |
| 48401 | 48401 | 1929-08-24 | 5 | a | The Sun Company Ltd, a universal provider in Hong Kong, has new building and the report. Photograph of the new building of The Sun Company Ltd, Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099332 | 24099332 | |
| 48402 | 48402 | 1929-08-24 | 6-7 | a-d | Guangdong news/ Guangdong military officers urge the Nationalist government in Nanjing to declare war with Soviet Russia. Anti-Russian movement in Guangzhou and the report. The Communist disasters in the west of Fujian province are worsening than Haifeng and Lufeng county. Guangdong, Fujian, Hunan and Jiangxi provinces to jointly suppress the communist forces led by Zhu De and Mao Zedong. Deng Yanhua is escorted to Longmen. Bandits in Zengcheng county. Yuan Xiajiu retreats to Longmen. Bandits in Dongguan. Xinhui county to collect special levy for road construction. Two girls are poisoned to death in Zhongshan county. Prospect for a good harvest in Dongguan. | China | http://trove.nla.gov.au/newspaper/page/24099337 | 24099337 | |
| 48403 | 48403 | 1929-08-24 | 8 | b | Soviet troops kill Chinese people on the border. Clash between Chinese and Russian troops on the border. Zhang Xueliang dispatches more troops to the border to fight Russian troops. Miscellaneous report on the military clash between Russia and China. Chinese government purchases more weapons to fight Russian. Russian army besiege Manzhouli. Soviet Russian force Chinese to do hard labour. Weapons used by the Chinese and Russian troops during their clashes. | China | http://trove.nla.gov.au/newspaper/page/24099339 | 24099339 | |
| 48404 | 48404 | 1929-08-24 | 8 | f | Australia news/ Old man is robbed in Sydney. Police and the timber workers in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099339 | 24099339 |
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]);