This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22053 | 22053 | 1909-12-04 | 2 | c-d | Beijing news/ All eunuchs will be dismissed. Russian in the Far East are in difficult situation. Yin Chang might be promoted. The Beijing-Hankou railway to have a branch road. Zhan Tianyou is appointed chief-supervisor of the Sichuan-Hubei railway project. Imperial title for the late Zhang Zhidong. Prince Regent studies military science as the general commander. Russian demand the rights of Hunchun railway. Wu Tingfang and Qian xun are returning. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802416 | 26802416 | |
22082 | 22082 | 1909-12-04 | 8 | c-d | Flood in Guangdong province (Enping, Xinning, Foshan, Zhaoqing, Huizhou and other counties). | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802422 | 26802422 |
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]);