This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
6552 | 6552 | 1900-12-01 | 2 | e | Tsar of Russia is recovering from his recent illness. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24103033 | 24103033 | |
6553 | 6553 | 1900-12-01 | 2 | e | A newspaper in Britain was ordered to compensate a company for incorrect reporting. | Britain | http://trove.nla.gov.au/newspaper/page/24103033 | 24103033 | |
6554 | 6554 | 1900-12-01 | 2 | e | Refugees from Guishan county say there were fierce clashes between bandits and government forces there; government troops are passing Shenzhen on their way to suppress bandits. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24103033 | 24103033 | |
6555 | 6555 | 1900-12-01 | 2 | e | Different groups of the Boxers; French troops in Baoding; Russian troops have taken over most of Heilongjiang province; Russian troops killed many local residents in Jilin province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24103033 | 24103033 |
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]);