This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
5063 | 5063 | 1900-04-25 | 2 | f | Queen of Britain visits hospitals in ai li shi (ppp). | Other... | http://trove.nla.gov.au/newspaper/page/24102779 | 24102779 | |
5064 | 5064 | 1900-04-25 | 2 | f | USA wants to help refugees of Transvaal, displaced as a result of the Boer war. | America | http://trove.nla.gov.au/newspaper/page/24102779 | 24102779 | |
5065 | 5065 | 1900-04-25 | 2 | f | Riots in western Africa have now ceased. | Other... | http://trove.nla.gov.au/newspaper/page/24102779 | 24102779 | |
5066 | 5066 | 1900-04-25 | 2 | f | King of Persia visits Europe. | Other... | http://trove.nla.gov.au/newspaper/page/24102779 | 24102779 | |
5067 | 5067 | 1900-04-25 | 2 | f | The Empress Dowager to wipe out all reformers with Russia's help; Jing Liansan escapes assassination attempt; Chinese official comments on war between Britain and Transvaal; Britain's role in China has been taken over by Russia; Japan wants to fight Russia when they have enough weaponry; Russia in Korea. | Australia | http://trove.nla.gov.au/newspaper/page/24102779 | 24102779 | |
5068 | 5068 | 1900-04-25 | 2 | f | Boy lost in Goulburn, NSW. | Australia | http://trove.nla.gov.au/newspaper/page/24102779 | 24102779 | |
5069 | 5069 | 1900-04-25 | 2 | f | A gentle man robbed in Wool Wool, Victoria. | Australia | http://trove.nla.gov.au/newspaper/page/24102779 | 24102779 | |
5070 | 5070 | 1900-04-25 | 2 | f | Posters appeared again in Hankou, Hubei province, urging people to support the Emperor. | China | http://trove.nla.gov.au/newspaper/page/24102779 | 24102779 |
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]);