This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 3703 | 3703 | 1899-09-30 | 2 | e | The men who allegedly killed a Chinese in New Zealand were released free of charge. | http://trove.nla.gov.au/newspaper/page/24102550 | 24102550 | ||
| 3704 | 3704 | 1899-09-30 | 2 | e | A girl in Parramatta, Sydney, attempted suicide but was saved. | http://trove.nla.gov.au/newspaper/page/24102550 | 24102550 | ||
| 3705 | 3705 | 1899-09-30 | 2 | e | Two boys in New South Wales drowned. | http://trove.nla.gov.au/newspaper/page/24102550 | 24102550 | ||
| 3719 | 3719 | 1899-09-30 | 3 | e | A girl in Melbourne was compensated for being bitten by a dog. | http://trove.nla.gov.au/newspaper/page/24102549 | 24102549 | ||
| 3720 | 3720 | 1899-09-30 | 3 | e | The numbers printed on coins indicate whether or not they are counterfeit. | http://trove.nla.gov.au/newspaper/page/24102549 | 24102549 | ||
| 3721 | 3721 | 1899-09-30 | 3 | e | Queensland cares for orphans. | http://trove.nla.gov.au/newspaper/page/24102549 | 24102549 | ||
| 3722 | 3722 | 1899-09-30 | 3 | e | Man charged with rape; Chinese man in Shepparton faces court charge with rape. | http://trove.nla.gov.au/newspaper/page/24102549 | 24102549 | ||
| 3723 | 3723 | 1899-09-30 | 3 | e | A father in Melbourne was sentenced to seven years' imprisonment for committing incest. | http://trove.nla.gov.au/newspaper/page/24102549 | 24102549 |
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]);