This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
5823 | 5823 | 1900-08-11 | 2 | d | Local governors and commissioners jointly request to save China. They are, Zhang Zhidong of Hunan and Hubei, Li Hongzhang of Guangdong and Guangxi, Liu Kunyi of Jiangsu and Zhejiang, Wang Zhicun of Anhui, Lu Chuanlin of Jiangsu, Yu Yinlin of Hubei, Yu Liansan of Hunan, etc. | China | http://trove.nla.gov.au/newspaper/page/24102904 | 24102904 | |
5824 | 5824 | 1900-08-11 | 2 | d | Eight proposals to save China after foreign troops take over Beijing. | China | http://trove.nla.gov.au/newspaper/page/24102904 | 24102904 | |
5825 | 5825 | 1900-08-11 | 2 | d | Three new ministers were appointed to manage zongli yamen, Pu Xing, Qi Xiu, and Na Yantu. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102904 | 24102904 |
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]);