This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
5967 | 5967 | 1900-09-01 | 2 | d | Zhang Zhidong, governor of Hubei and Hunan province, protects foreigners. | China | http://trove.nla.gov.au/newspaper/page/24102931 | 24102931 | |
5968 | 5968 | 1900-09-01 | 2 | d | People in Shanghai welcome the arrival of foreign troops. | China | http://trove.nla.gov.au/newspaper/page/24102931 | 24102931 | |
5972 | 5972 | 1900-09-01 | 2 | e | Russia wants compensation from Chinese government for their casualties during the Boxer rebellions; provisions to the international troops in Tianjin are enough for one month; Russia, France and Britain will compete each other for their interest in China; Germany employs 12 Chinese in Shanghai and Hankou for intelligence service; Russian newspaper praises Li Hongzhang's efforts for peace negotiation; 1,000 Japanese, Russian and German soldiers are chasing the Emperor and the Empress. | China | http://trove.nla.gov.au/newspaper/page/24102931 | 24102931 | |
5974 | 5974 | 1900-09-01 | 2 | e | Newspapers in Shanghai were ordered not to publish any imperial edicts. | China | http://trove.nla.gov.au/newspaper/page/24102931 | 24102931 | |
5975 | 5975 | 1900-09-01 | 2 | e | Huang Wansheng, director of a Tianjin school, hid in foreign concession during the chaos and could not find any of his family members. | China | http://trove.nla.gov.au/newspaper/page/24102931 | 24102931 | |
5976 | 5976 | 1900-09-01 | 2 | e | Russian soldiers shot any Chinese they saw on the streets in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24102931 | 24102931 | |
5977 | 5977 | 1900-09-01 | 2 | f | Contents of the Boxers' poster found in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24102931 | 24102931 | |
5980 | 5980 | 1900-09-01 | 2 | f | Rong Lu and Dong Fuxiang masterminded the besiege of foreign missions in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24102931 | 24102931 | |
5983 | 5983 | 1900-09-01 | 3 | b | Tianjin is quiet now. | China | http://trove.nla.gov.au/newspaper/page/24102930 | 24102930 | |
5984 | 5984 | 1900-09-01 | 3 | b | Liu Kunyi, governor of Jiangsu and Zhejiang, tries to keep the region peaceful. | China | http://trove.nla.gov.au/newspaper/page/24102930 | 24102930 | |
5986 | 5986 | 1900-09-01 | 3 | b | Gentry charged very high price for sedan service from Tianjin to Tanggu. | China | http://trove.nla.gov.au/newspaper/page/24102930 | 24102930 |
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]);