This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
6250 | 6250 | 1900-10-10 | 2 | d | An army from Hubei was dispersed on their way to save the Emperor in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24102979 | 24102979 | |
6251 | 6251 | 1900-10-10 | 2 | d | A letter from Beijing on the current situation. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102979 | 24102979 | |
6252 | 6252 | 1900-10-10 | 2 | d | The Emperor was very reluctant to leave Beijing and go west. | China | http://trove.nla.gov.au/newspaper/page/24102979 | 24102979 | |
6253 | 6253 | 1900-10-10 | 2 | d | A scholar was appointed magistrate of Chong'an county in Fujian province but can not take his officer due to chaos. | China | http://trove.nla.gov.au/newspaper/page/24102979 | 24102979 | |
6254 | 6254 | 1900-10-10 | 2 | d | Germany suggests Western countries jointly appoint a man to manage China affairs. | Other... | http://trove.nla.gov.au/newspaper/page/24102979 | 24102979 | |
6255 | 6255 | 1900-10-10 | 2 | d | Newly appointed imperial commissioner to Guizhou province, Deng Xiaochi, was robbed by Boxers in Beijing; Chen Xuefen and other officials were attacked by Boxers; No Boxers found in north Shandong province. | China | http://trove.nla.gov.au/newspaper/page/24102979 | 24102979 |
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]);