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 |
|---|---|---|---|---|---|---|---|---|---|
| 48330 | 48330 | 1929-08-03 | 2 | a | A historical review on the Russian invasion into China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099308 | 24099308 | |
| 48331 | 48331 | 1929-08-03 | 2 | c | Famine victims in Gansu province. Foreign minister Wang Zhengting says Chinese government is studying the Russian issues. Chinese government to close the office for Sino-Foreign Negotiations. Zhang Xueliang on the current situations. Farewell words by Feng Yuxiang before his leaving China. Yan Xishan is also planning for an overseas tour. | China | http://trove.nla.gov.au/newspaper/page/24099308 | 24099308 | |
| 48332 | 48332 | 1929-08-03 | 2 | d | Japanese government sets up a colony department. | Japan | http://trove.nla.gov.au/newspaper/page/24099308 | 24099308 | |
| 48333 | 48333 | 1929-08-03 | 2 | f | Li Pinxian is going to Zhengzhou. Ministry of Internal Affairs promotes local self-government at county level. Feng Yuxiang steps down and the aftermath. Yu Youren is very pessimistic. Relation between Sun Chuanfang and Zhang Xueliang. Japanese demolish railway near Shenyang, Liaoning province. Zhang Jinghui arrives Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24099308 | 24099308 | |
| 48334 | 48334 | 1929-08-03 | 3 | a | Zheng Chenggong's grave is dug and the report. | China | http://trove.nla.gov.au/newspaper/page/24099307 | 24099307 | |
| 48335 | 48335 | 1929-08-03 | 3 | b | The Soviet Russia is going to collapse. | Russia | http://trove.nla.gov.au/newspaper/page/24099307 | 24099307 | |
| 48336 | 48336 | 1929-08-03 | 3 | c | Another war in Jiangjin, Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24099307 | 24099307 | |
| 48337 | 48337 | 1929-08-03 | 3 | d | Soviet Russia is trying to implement Communist policy in Mongolia. | China | http://trove.nla.gov.au/newspaper/page/24099307 | 24099307 | |
| 48338 | 48338 | 1929-08-03 | 3 | e | Communist offices are smashed in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24099307 | 24099307 | |
| 48339 | 48339 | 1929-08-03 | 3 | e | The Nanjing government tries to retain Cai Yuanpei. | China | http://trove.nla.gov.au/newspaper/page/24099307 | 24099307 | |
| 48340 | 48340 | 1929-08-03 | 5 | c | Students of the Jinling (Nanjing) Women's University prefer to be single. | China | http://trove.nla.gov.au/newspaper/page/24099309 | 24099309 | |
| 48341 | 48341 | 1929-08-03 | 5 | c | A public notice issued by the Chinese Consulate-General in Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099309 | 24099309 | |
| 48342 | 48342 | 1929-08-03 | 6-7 | a-d | Guangdong news/ Li Yun besieged on the border of Fujian and Jiangxi province. The Communist troops take over Longyan, Fujian province, before the arrival of Guangdong army. Nationalist army take over Xunzhou and the process. Song Ziwen on the budget cut. Businessmen fight for the rights to choose and employ their own workers. Two different reports on the ferry hijack in Zhongshan county. Ningyang railway workers on strike. Matchmaker in Taishan county to defraud. Registration of public properties in Zhongshan county. Matches factories closed one after another in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24099312 | 24099312 | |
| 48343 | 48343 | 1929-08-03 | 8 | a | Japanese police in Shanghai have clash with the Communist members. | China | http://trove.nla.gov.au/newspaper/page/24099314 | 24099314 | |
| 48344 | 48344 | 1929-08-03 | 8 | b | Chinese consuls are leaving Soviet Russia. | China | http://trove.nla.gov.au/newspaper/page/24099314 | 24099314 | |
| 48345 | 48345 | 1929-08-03 | 8 | b | British and French authorities guard against the Communist Party. | Britain | http://trove.nla.gov.au/newspaper/page/24099314 | 24099314 | |
| 48346 | 48346 | 1929-08-03 | 8 | c | The conspiracy of Soviet Russia in China. | China | http://trove.nla.gov.au/newspaper/page/24099314 | 24099314 | |
| 48347 | 48347 | 1929-08-03 | 8 | c | Famine in Gansu. Only 20km distance between Russian and Chinese troops. White Russian prepare to attack the Soviet Russian. | China | http://trove.nla.gov.au/newspaper/page/24099314 | 24099314 | |
| 48348 | 48348 | 1929-08-03 | 8 | d | Australia news/ Bank robbery in Sydney. Advertisement for D. & J. McCalluin of Edingburgh. Advertisement for the Commercial Banking Company of Sydney Ltd. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099314 | 24099314 |
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]);