This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
5491 | 5491 | 1900-06-16 | 3 | a | Zongli yamen provides ammunition to the Boxers; more British, French and German soldiers arrived in Beijing; American missionary left his church in Tongzhou and escaped; foreign armies in Lushun and Tianjin; China's negotiations with Belgium, France and other countries. | China | http://trove.nla.gov.au/newspaper/page/24102841 | 24102841 | |
5492 | 5492 | 1900-06-16 | 3 | a | The war between Britain and Transvaal in South Africa. | Other... | http://trove.nla.gov.au/newspaper/page/24102841 | 24102841 | |
5493 | 5493 | 1900-06-16 | 3 | a | An old man in Ballarat died, leaving money and gold under his house. | Australia | http://trove.nla.gov.au/newspaper/page/24102841 | 24102841 | |
5494 | 5494 | 1900-06-16 | 3 | b | Heat waves in London claim casualties. | Britain | http://trove.nla.gov.au/newspaper/page/24102841 | 24102841 | |
5495 | 5495 | 1900-06-16 | 3 | b | Riots in Africa; response of British government. | Britain | http://trove.nla.gov.au/newspaper/page/24102841 | 24102841 | |
5496 | 5496 | 1900-06-16 | 3 | b | The New South Wales parliament resumed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102841 | 24102841 | |
5497 | 5497 | 1900-06-16 | 3 | b | The Empress is soon to return power to the Emperor. | China | http://trove.nla.gov.au/newspaper/page/24102841 | 24102841 | |
5498 | 5498 | 1900-06-16 | 3 | b | Two Chinese shop owners in Thailand fought each other. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24102841 | 24102841 | |
5499 | 5499 | 1900-06-16 | 3 | b | Riots in Hunan and Hubei provinces. Foreign missionaries and churches were the target. | China | http://trove.nla.gov.au/newspaper/page/24102841 | 24102841 | |
5500 | 5500 | 1900-06-16 | 3 | b | Bandits in Wenzhou, Zhejiang province, organised themselves. | China | http://trove.nla.gov.au/newspaper/page/24102841 | 24102841 | |
5501 | 5501 | 1900-06-16 | 3 | c | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102841 | 24102841 |
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]);