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 |
---|---|---|---|---|---|---|---|---|---|
6303 | 6303 | 1900-10-17 | 2 | e | Russia and Germany occupy important positions in China; Russia and Germany sign an agreement about the railway from Tanggu to Beijing; American ambassador confirms the number of Boxers who attacked foreign missions; foreign troops in Beijing need more provisions; Chinese and foreign troops clashed in Baoding, Zhili province; American envoy reported that more riots in south China may be possible if peace negotiation delayed further; some people in Foshan attacked churches. | Other... | http://trove.nla.gov.au/newspaper/page/24102987 | 24102987 | |
6305 | 6305 | 1900-10-17 | 3 | a | French and American government on peace negotiation with China; Britain transfer Indian soldiers to Hong Kong; Li Hongzhang wrote to German government for peace negotiation; governor of Shanxi province has been removed; the Empress Dowager is ill in Shanxi; a foreign missionary and his family were murdered by Boxers; British government appoint new ambassador to China; New South Wales soldiers in China; Italian soldiers questioned Boxers they captured and their dialogue. | Other... | http://trove.nla.gov.au/newspaper/page/24102986 | 24102986 | |
6309 | 6309 | 1900-10-17 | 3 | c | France in South Africa. | Other... | http://trove.nla.gov.au/newspaper/page/24102986 | 24102986 |
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]);