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 |
|---|---|---|---|---|---|---|---|---|---|
| 3624 | 3624 | 1899-09-20 | 2 | f | Brisbane is crowded as missionaries gather. | http://trove.nla.gov.au/newspaper/page/24102538 | 24102538 | ||
| 3625 | 3625 | 1899-09-20 | 2 | f | A doorkeeper of a graveyard in Britain was penalised for negligence. | http://trove.nla.gov.au/newspaper/page/24102538 | 24102538 | ||
| 3626 | 3626 | 1899-09-20 | 2 | f | Fire in a Sydney theatre. | http://trove.nla.gov.au/newspaper/page/24102538 | 24102538 | ||
| 3627 | 3627 | 1899-09-20 | 2 | f | Queensland holds a federation referendum; majority support the federation proposal. | http://trove.nla.gov.au/newspaper/page/24102538 | 24102538 | ||
| 3628 | 3628 | 1899-09-20 | 2 | f | Telegram offices in China charge half price for sending news to newspapers. | http://trove.nla.gov.au/newspaper/page/24102538 | 24102538 | ||
| 3641 | 3641 | 1899-09-20 | 3 | f | Bandits are very active in the rivers of Xiangshan; the bandits' leader is the nephew of a former local official; an escaped criminal is caught. | http://trove.nla.gov.au/newspaper/page/24102537 | 24102537 | ||
| 3642 | 3642 | 1899-09-20 | 3 | f | The bodies of two maidservants were found floating in a pond in Zengcheng. | 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]);