This data as json, CSV (advanced)
Suggested facets: page, trove_id, date (date)
page_url 2 ✖
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
3764 | 3764 | 1899-10-07 | 2 | e | A boy in Newland, Victoria, found a decaying body. | http://trove.nla.gov.au/newspaper/page/24102558 | 24102558 | ||
3765 | 3765 | 1899-10-07 | 2 | e | A woman commits suicide in Yarra River. | http://trove.nla.gov.au/newspaper/page/24102558 | 24102558 | ||
3781 | 3781 | 1899-10-07 | 3 | e | A baby girl in Lismore drowns. | http://trove.nla.gov.au/newspaper/page/24102557 | 24102557 | ||
3782 | 3782 | 1899-10-07 | 3 | e | France advises Transvaal to strike first in order to gain advantage; New Zealand is keen to provide assistance. | http://trove.nla.gov.au/newspaper/page/24102557 | 24102557 | ||
3783 | 3783 | 1899-10-07 | 3 | e | An old man's body, wrapped in a straw mat, was found on Manila street. | http://trove.nla.gov.au/newspaper/page/24102557 | 24102557 | ||
3784 | 3784 | 1899-10-07 | 3 | e | A strange disease has been found in Perth. | http://trove.nla.gov.au/newspaper/page/24102557 | 24102557 | ||
3785 | 3785 | 1899-10-07 | 3 | e | Quality rice from South America. | http://trove.nla.gov.au/newspaper/page/24102557 | 24102557 |
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]);