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 |
---|---|---|---|---|---|---|---|---|---|
9452 | 9452 | 1902-01-01 | 2 | f | Britain has the biggest ship in the world. | Australia | http://trove.nla.gov.au/newspaper/page/24100283 | 24100283 | |
9453 | 9453 | 1902-01-01 | 2 | f | Nine of fourteen tourists drowned in a river near Brisbane, Queensland. | Australia | http://trove.nla.gov.au/newspaper/page/24100283 | 24100283 | |
9455 | 9455 | 1902-01-01 | 3 | a | A German cargo ship was penalised in Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100282 | 24100282 | |
9456 | 9456 | 1902-01-01 | 3 | a | Orchards in Parramatta, Sydney, caught fire. | Australia | http://trove.nla.gov.au/newspaper/page/24100282 | 24100282 | |
9457 | 9457 | 1902-01-01 | 3 | a | A Chinese gardener in Sydney was so sick that he collapsed on the way home. | Australia | http://trove.nla.gov.au/newspaper/page/24100282 | 24100282 | |
9458 | 9458 | 1902-01-01 | 3 | a | A Sydney died but the cause of her death is not apparent. | Australia | http://trove.nla.gov.au/newspaper/page/24100282 | 24100282 | |
9462 | 9462 | 1902-01-01 | 3 | e | Five children in Sydney died in a house fire. | Australia | http://trove.nla.gov.au/newspaper/page/24100282 | 24100282 |
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]);