This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
17672 | 17672 | 1907-06-29 | 2 | a-b | Editorial/ Brief history of Russian parliament. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801380 | 26801380 | |
17676 | 17676 | 1907-06-29 | 3 | a-b | Guangdong news. Qin Chunxuan might replace Duan Fang as governor of Jiangsu province, and Duan Fang to replace Zhou Fu. A theatre in Xinhui county is burned to ashes. Compensation and relief to the victims of arsenal explosion in Guangzhou. Guangzhou authority to clean the streets. Hu Guolian (Zichun) has an investigation on mining resources in Panyu county and Hainan island. A letter from chief engineer of the Guangzhou-Hankou railway to the chief supervisor. Correspondence between governor Zhou Fu and the ministry of communications in Beijing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801379 | 26801379 | |
17703 | 17703 | 1907-06-29 | 8 | a-b | Political disturbance. Zhao Qilin impeaches Duan Zhigui and other government officials. Imperial edicts that remove some officials. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801386 | 26801386 |
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]);