This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id
date (date) 1 ✖
| 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]);