This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28819 | 28819 | 1914-05-09 | 8 | a | First part of the report that Chinese Ministry of Internal Affairs changes names of some counties in order to avoid repetition, for example, in Guangdong province, Xinning changed to Taishan, Zhenping to Jiaoling, etc. | China | http://trove.nla.gov.au/newspaper/page/24093108 | 24093108 | |
28820 | 28820 | 1914-05-09 | 8 | b | Beijing news/ Zhang Qihuang is going to Guangdong on new mission. Lawyer association in Beijing offer free service to some selected clients. Relations between revolutionary rebels like Chen Qimei and bandits. Zhao Er'tuan goes to the court on behalf of his brother. | China | http://trove.nla.gov.au/newspaper/page/24093108 | 24093108 | |
28821 | 28821 | 1914-05-09 | 8 | b-c | Guangdong news/ New governor might be appointed to replace Li Kaishen. Li Yaohan in Zhaoqing and Wu Xiangda in Chaozhou are promoted. Bank notes issued in Guangdong. Bandits in Shunde and Nanhai county. A woman is sentenced for arms smuggling. Troops harass local residents in Lecong and the report on three cases. | China | http://trove.nla.gov.au/newspaper/page/24093108 | 24093108 |
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]);