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 |
|---|---|---|---|---|---|---|---|---|---|
| 3618 | 3618 | 1899-09-20 | 2 | e | A man in Morang, NSW, died in a hunting accident. | http://trove.nla.gov.au/newspaper/page/24102538 | 24102538 | ||
| 3619 | 3619 | 1899-09-20 | 2 | e | A female criminal and her lawyer were both sentenced in Auckland, New Zealand. | http://trove.nla.gov.au/newspaper/page/24102538 | 24102538 | ||
| 3621 | 3621 | 1899-09-20 | 2 | e | Changes in the New South Wales Parliament. | http://trove.nla.gov.au/newspaper/page/24102538 | 24102538 | ||
| 3622 | 3622 | 1899-09-20 | 2 | e | Chinese immigrants in Brisbane are allowed to gamble. | http://trove.nla.gov.au/newspaper/page/24102538 | 24102538 | ||
| 3633 | 3633 | 1899-09-20 | 3 | e | People in Warren, NSW, get clear water from underground. | http://trove.nla.gov.au/newspaper/page/24102537 | 24102537 | ||
| 3634 | 3634 | 1899-09-20 | 3 | e | A man in Bomera hunts more than 200 rabbits a day. | http://trove.nla.gov.au/newspaper/page/24102537 | 24102537 | ||
| 3635 | 3635 | 1899-09-20 | 3 | e | Earthquake in New Zealand. | http://trove.nla.gov.au/newspaper/page/24102537 | 24102537 | ||
| 3636 | 3636 | 1899-09-20 | 3 | e | Two men in Victoria die from poisonous gas. | http://trove.nla.gov.au/newspaper/page/24102537 | 24102537 | ||
| 3637 | 3637 | 1899-09-20 | 3 | e | Japan signs agreement with other countries to open China's ports. | http://trove.nla.gov.au/newspaper/page/24102537 | 24102537 | ||
| 3638 | 3638 | 1899-09-20 | 3 | e | Value and quantity of gold produced in Western Australia. | http://trove.nla.gov.au/newspaper/page/24102537 | 24102537 | ||
| 3639 | 3639 | 1899-09-20 | 3 | e | A Chinese in Sydney was penalised for horse abuse. | http://trove.nla.gov.au/newspaper/page/24102537 | 24102537 | ||
| 3640 | 3640 | 1899-09-20 | 3 | e | A boy in Sydney was shot dead by accident. | http://trove.nla.gov.au/newspaper/page/24102537 | 24102537 |
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]);