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 |
|---|---|---|---|---|---|---|---|---|---|
| 3875 | 3875 | 1899-10-21 | 2 | f | The deputy manager of a Melbourne bank was arrested for embezzlement. | http://trove.nla.gov.au/newspaper/page/24102574 | 24102574 | ||
| 3876 | 3876 | 1899-10-21 | 2 | f | Parliament in Melbourne once again discusses proposals to ban entry of Chinese. | http://trove.nla.gov.au/newspaper/page/24102574 | 24102574 | ||
| 3877 | 3877 | 1899-10-21 | 2 | f | Chinese Liu Wen finishes his lawsuit against a White man in Melbourne. | http://trove.nla.gov.au/newspaper/page/24102574 | 24102574 | ||
| 3878 | 3878 | 1899-10-21 | 2 | f | The Chinese Anti-Opium Association in Christchurch, New Zealand, holds another meeting. Liu Si replaces Lin Leji as chairman. | http://trove.nla.gov.au/newspaper/page/24102574 | 24102574 | ||
| 3879 | 3879 | 1899-10-21 | 2 | f | Royal family of Britain compensates French fisherman. | http://trove.nla.gov.au/newspaper/page/24102574 | 24102574 | ||
| 3880 | 3880 | 1899-10-21 | 2 | f | Samoa requests compensation from Germany, Britain and the USA. | http://trove.nla.gov.au/newspaper/page/24102574 | 24102574 | ||
| 3896 | 3896 | 1899-10-21 | 3 | f | Cremation in Denmark. | http://trove.nla.gov.au/newspaper/page/24102573 | 24102573 | ||
| 3897 | 3897 | 1899-10-21 | 3 | f | Man claims to make oil from water. | http://trove.nla.gov.au/newspaper/page/24102573 | 24102573 | ||
| 3898 | 3898 | 1899-10-21 | 3 | f | Gold price in Hong Kong. | http://trove.nla.gov.au/newspaper/page/24102573 | 24102573 |
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]);