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 |
---|---|---|---|---|---|---|---|---|---|
47715 | 47715 | 1929-01-05 | 2 | c-f | Troops in Shanghai harbour opium smuggling and the investigation. | China | http://trove.nla.gov.au/newspaper/page/24099074 | 24099074 | |
47716 | 47716 | 1929-01-05 | 2 | f | Bai Chongxi refuses to go to Xinjiang, north-west of China. | China | http://trove.nla.gov.au/newspaper/page/24099074 | 24099074 | |
47717 | 47717 | 1929-01-05 | 3 | b | Prominent figures in Sichuan province suggest to set up the Tibet province and their appeal. | China | http://trove.nla.gov.au/newspaper/page/24099073 | 24099073 | |
47718 | 47718 | 1929-01-05 | 3 | d | Ancient graves found in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24099073 | 24099073 | |
47719 | 47719 | 1929-01-05 | 3 | d | Fu Zuoyi in Tianjin resigns due to his empty pockets. | China | http://trove.nla.gov.au/newspaper/page/24099073 | 24099073 | |
47720 | 47720 | 1929-01-05 | 3 | e | Internal disputes in Manchuria. Zhang Xueliang's attitude is still unstable. Zhou Xicheng from Guizhou province sends telegram to his representative in Nanjing. Soviet Russia seeks to control Xinjiang province. Japanese conspiracy in Dalian, Fengtian province. Bandits in Harbin, Heilongjiang province. | China | http://trove.nla.gov.au/newspaper/page/24099073 | 24099073 | |
47723 | 47723 | 1929-01-05 | 6-7 | a-d | Guangdong news/ Guangxi provincial authority tries to civilise the Miao and Yao minority people and the strategies. Candidates for the chairman of the provincial government. Leftists are very active in Guangzhou. Proposal to punish Chen Gongbo, Wang Zhaoming, Yan Mengyu and Gan Naiguang. Fruit shops in Guangzhou suffer from the strike. Communist offices are smashed in Gaoyao county. Special levy for road construction in Taishan claims five lives and the report. Troops in Xinhui county have clash with bandits. House demolished in Dongguan for the road projects. Bandits in Zhongshan and Shunde county. Drought and floods in Puning county. | China | http://trove.nla.gov.au/newspaper/page/24099078 | 24099078 | |
47724 | 47724 | 1929-01-05 | 8 | a | China may move its national capital to Xi'an, of Shaanxi province. | China | http://trove.nla.gov.au/newspaper/page/24099080 | 24099080 | |
47726 | 47726 | 1929-01-05 | 8 | a | Zhang Xueliang in Manchuria turns to support the Nationalist government in Nanjing. Twelve countries have signed treaties with China including America, Germany, France, Italy, Britain, Holland and Switzerland. Famine in Beiping and the victims. | China | http://trove.nla.gov.au/newspaper/page/24099080 | 24099080 |
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]);