This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
4431 | 4431 | 1900-01-13 | 2 | e | Boer war, South Africa. Reports on the war between Britain and Transvaal. | Other... | http://trove.nla.gov.au/newspaper/page/24102671 | 24102671 | |
4435 | 4435 | 1900-01-13 | 2 | f | Big earthquake rocks Caucasus region, Russia. | Other... | http://trove.nla.gov.au/newspaper/page/24102671 | 24102671 | |
4439 | 4439 | 1900-01-13 | 3 | b | A Chinese in Thailand was eaten by a crocodile while others ignored his plea for help. | Other... | http://trove.nla.gov.au/newspaper/page/24102670 | 24102670 | |
4441 | 4441 | 1900-01-13 | 3 | b | Casualties from famine in India. | Other... | http://trove.nla.gov.au/newspaper/page/24102670 | 24102670 | |
4443 | 4443 | 1900-01-13 | 3 | b-c | Employers in Germany can not sack sick employees but have to send them to hospitals; methods of debt payment of deceased people in France; Thailand people hate even numbers; joss sticks burning for more than one thousand years in an Indian temple; King of Germany has special dress for meeting foreign envoys; King's stable in Germany. | Other... | http://trove.nla.gov.au/newspaper/page/24102670 | 24102670 | |
4444 | 4444 | 1900-01-13 | 3 | c | Boer war, South Africa. Reports about the war between Britain and Transvaal. | Other... | http://trove.nla.gov.au/newspaper/page/24102670 | 24102670 |
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]);