This data as json, CSV (advanced)
Suggested facets: column, trove_id, 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 | |
5827 | 5827 | 1900-08-11 | 2 | e | Li Hongzhang stops communicating with foreign countries; different opinions in the court on recent riots; clashes between Russian and Chinese soldiers; Liu Kunyi cooperates with British commanders; Japanese refused assistance offered by Britain; foreign gunboats in Shanghai; American government comments recent development in China. | China | http://trove.nla.gov.au/newspaper/page/24102904 | 24102904 | |
5828 | 5828 | 1900-08-11 | 2 | e | Chinese followers killed; Russian and Japanese troops in Tianjin; Indian troops on their way to Beijing under British command; Li Bingheng is now commanding Chinese troops in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24102904 | 24102904 | |
5830 | 5830 | 1900-08-11 | 2 | f | Flooded areas of Fujian province and the border with Guangdong need help. | China | http://trove.nla.gov.au/newspaper/page/24102904 | 24102904 | |
5832 | 5832 | 1900-08-11 | 3 | a | Fuzhou, capital of Fujian province, is now flooding. | China | http://trove.nla.gov.au/newspaper/page/24102903 | 24102903 | |
5833 | 5833 | 1900-08-11 | 3 | a | Conservative officials in Beijing and their attitude towards Kang Youwei. | China | http://trove.nla.gov.au/newspaper/page/24102903 | 24102903 | |
5834 | 5834 | 1900-08-11 | 3 | a-b | Grain transportation for foreign troops in Beijing was blocked; Li Hongzhang's intervention; Li Hongzhang tries to impeach Li Bingheng before the Empress; a foreign missionary was killed in Wenzhou, Zhejiang province. | China | http://trove.nla.gov.au/newspaper/page/24102903 | 24102903 | |
5835 | 5835 | 1900-08-11 | 3 | b | More foreign troops are going to Beijing; | China | http://trove.nla.gov.au/newspaper/page/24102903 | 24102903 |
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]);