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 |
|---|---|---|---|---|---|---|---|---|---|
| 48370 | 48370 | 1929-08-17 | 2 | b | Photograph of the Chinese deputy-consul in San Francisco and his wife who is detained by American customs for opium smuggling. A detailed report on the arrest. | Australia | http://trove.nla.gov.au/newspaper/page/24099323 | 24099323 | |
| 48371 | 48371 | 1929-08-17 | 2 | d | Kong Xiangxi talks on his return to Beiping. Business in Manchuria. Another internal fighting in Sichuan. Reorganisation of the Northwest army. Zhang Xueliang and Yan Xishan are leaving Beiping after a talk with Jiang Jieshi. Han Fuqu sends telegram to Jiang Jieshi and resigns. Effort of Chinese government to take back the provisional court and the consular jurisdiction in Shanghai. Negotiation over the Manchurian railways. Jiang Jieshi reaches agreement with Zhang Xueliang, Yan Xishan and Feng Yuxiang on the current situations during their talks in Beiping. | China | http://trove.nla.gov.au/newspaper/page/24099323 | 24099323 | |
| 48372 | 48372 | 1929-08-17 | 3 | a | Mongolia to be the battlefield of Soviet Russian and Japanese. | China | http://trove.nla.gov.au/newspaper/page/24099322 | 24099322 | |
| 48373 | 48373 | 1929-08-17 | 3 | b | Internal fighting within the Nationalist Party in Hunan province. | China | http://trove.nla.gov.au/newspaper/page/24099322 | 24099322 | |
| 48374 | 48374 | 1929-08-17 | 3 | c | Financial department of the Fujian provincial government avoids to pay their debts. | China | http://trove.nla.gov.au/newspaper/page/24099322 | 24099322 | |
| 48375 | 48375 | 1929-08-17 | 3 | d | Famine in Gansu province. | China | http://trove.nla.gov.au/newspaper/page/24099322 | 24099322 | |
| 48376 | 48376 | 1929-08-17 | 3 | e | Miscellaneous report on the railway in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24099322 | 24099322 | |
| 48377 | 48377 | 1929-08-17 | 3 | e | Nanjing government to set up a supervisory committee. | China | http://trove.nla.gov.au/newspaper/page/24099322 | 24099322 | |
| 48378 | 48378 | 1929-08-17 | 5 | a | Hong Kong news/ Bai Chongxi purchases properties in Hong Kong. Guangxi military officers are leaving Hong Kong. Opposition to the concubine system in Hong Kong. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099324 | 24099324 | |
| 48379 | 48379 | 1929-08-17 | 5 | b | Men in shortage in France. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099324 | 24099324 | |
| 48380 | 48380 | 1929-08-17 | 6-7 | a-d | Guangdong news/ Students of the Meixian Teachers' School in Meixian county and their demonstration. Circulation of silver dollars in Guangzhou. Deng Zeru refuses to be back to politics. Shareholders of the Guangzhou tap water and their request. Bai Chongxi may have returned to Longzhou secretly. Grenades seized from an opium den in Guangzhou. Gaoming county magistrate tries to stop clan fighting. Yuan Xiajiu seeks to attack Dongguan. Suicidal in Guangzhou and an investigation. Bandits in Xinhui. Shaoguan authority prohibits prostitutes from living together. Communist bandits in Hainan island. Two coal mines in Heping county. Road construction in Zhongshan. Water levels higher in many rivers. Mao Zedong and Zhu De lead their troops to attack Dapu county. Rice harvest in Heshan county. | China | http://trove.nla.gov.au/newspaper/page/24099327 | 24099327 | |
| 48381 | 48381 | 1929-08-17 | 8 | c | Why Song Ziwen resigns. Negotiation between China and Russia fails. Yellow River flooding. News on the Manchuria railways. | China | http://trove.nla.gov.au/newspaper/page/24099329 | 24099329 | |
| 48382 | 48382 | 1929-08-17 | 8 | d | Floods in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24099329 | 24099329 | |
| 48383 | 48383 | 1929-08-17 | 8 | d | Foreign missions refuse to give up their consular jurisdiction in China. | China | http://trove.nla.gov.au/newspaper/page/24099329 | 24099329 | |
| 48384 | 48384 | 1929-08-17 | 8 | e | Chinese in America have a traffic accident. | America | http://trove.nla.gov.au/newspaper/page/24099329 | 24099329 | |
| 48385 | 48385 | 1929-08-17 | 8 | e | Military conflicts between China and Russian troops on the border. | China | http://trove.nla.gov.au/newspaper/page/24099329 | 24099329 | |
| 48386 | 48386 | 1929-08-17 | 8 | e | Australia news/ Three robberies in a night in Sydney. Import of German toys. Police fight strikers in Wellington, New Zealand. A public notice jointly issued by the Chinese Chamber of Commerce in Sydney and the Overseas Chinese Commission in Nanjing on the punishment of opium addicts. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099329 | 24099329 |
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]);