This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
5867 | 5867 | 1900-08-18 | 2 | c | Boxers and Chinese soldiers attacked Russian barracks; clashes between Chinese and Britain troops; Li Hongzhang has been empowered to negotiate with foreign countries; a German commander for the international troops; foreign troops and artillery in China; Li Bingheng led his army to Tianjin; Boxers attacked foreign missions in Beijing again. | Other... | http://trove.nla.gov.au/newspaper/page/24102912 | 24102912 | |
5879 | 5879 | 1900-08-18 | 2 | f | Rong Lu is more powerful now; clashes between Italian and Chinese soldiers; some Japanese soldiers are on their way to Beijing; Korean government has agreed Japanese troops set up military camps on their land. | Other... | http://trove.nla.gov.au/newspaper/page/24102912 | 24102912 | |
5886 | 5886 | 1900-08-18 | 3 | a-b | International troops on their way to Beijing from Tianjin; British government provides loans to Hubei province; foreign diplomats in Beijing; Li Hongzhang's effort to negotiate. | Other... | http://trove.nla.gov.au/newspaper/page/24102911 | 24102911 |
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]);