This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
5871 | 5871 | 1900-08-18 | 2 | e | Gang Yi took power, collaborating with the Boxers. | China | http://trove.nla.gov.au/newspaper/page/24102912 | 24102912 | |
5872 | 5872 | 1900-08-18 | 2 | e | Liu Kunyi and other local governors request that the imperial examination be suspended for one year. | China | http://trove.nla.gov.au/newspaper/page/24102912 | 24102912 | |
5873 | 5873 | 1900-08-18 | 2 | e | Zhang Zhidong recalls all students in Japanese army school to come back and help the Chinese government. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24102912 | 24102912 | |
5874 | 5874 | 1900-08-18 | 2 | e | Chinese government offers reward to Boxers. | China | http://trove.nla.gov.au/newspaper/page/24102912 | 24102912 | |
5875 | 5875 | 1900-08-18 | 2 | e | Empress Dowager ordered to wipe out Boxers from Beijing. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24102912 | 24102912 | |
5876 | 5876 | 1900-08-18 | 2 | e | Liu Kunyi, Governor of Jiangsu and Zhejiang, was respected for his protection of foreigners. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24102912 | 24102912 | |
5877 | 5877 | 1900-08-18 | 2 | e | American government asks China to protect foreign diplomats in Beijing. | Australia | http://trove.nla.gov.au/newspaper/page/24102912 | 24102912 |
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]);