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 |
---|---|---|---|---|---|---|---|---|---|
6449 | 6449 | 1900-11-17 | 2 | e | China and Russia signed an agreement under which whole Manchuria would be under protection of Russia; a Chinese military officer on his way from Xi'an to Chengdu in Sichuan province; Russia has transferred the railway from Dagu to Beijing to international troops; Li Hongzhang wrote to foreign missions in Beijing on the Baoding issue; Russia demands part of Tianjin. | Other... | http://trove.nla.gov.au/newspaper/page/24103017 | 24103017 | |
6450 | 6450 | 1900-11-17 | 2 | e | A crocodile and a tiger fought each other in Hong Kong and both died. | Other... | http://trove.nla.gov.au/newspaper/page/24103017 | 24103017 | |
6451 | 6451 | 1900-11-17 | 2 | e | A talented boy comments on the international fair in Paris. | Other... | http://trove.nla.gov.au/newspaper/page/24103017 | 24103017 | |
6452 | 6452 | 1900-11-17 | 2 | f | Humans are often more fragile than other animals. | Other... | http://trove.nla.gov.au/newspaper/page/24103017 | 24103017 | |
6457 | 6457 | 1900-11-17 | 3 | a | Dong Fuxiang punished; Yu Xian was removed from his position as Governor of Shanxi; foreign troops in Baoding killed more Chinese officials; French ambassador to Beijing revealed his witness for Chinese government's collusion with Boxers; Belgium demanded a piece of land near Tianjin; German troops in China. | Other... | http://trove.nla.gov.au/newspaper/page/24103016 | 24103016 |
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]);