This data as json, CSV (advanced)
Suggested facets: column, title, description, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 4654 | 4654 | 1900-02-28 | 3 | b | Three sailors in New Zealand were punished for tax evasion. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102713 | 24102713 | |
| 4935 | 4935 | 1900-04-11 | 3 | a | Gold production in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102762 | 24102762 | |
| 5031 | 5031 | 1900-04-21 | 3 | b | Wellington authority in New Zealand undertakes regularly checks the hygiene standards of Chinese community and businesses there. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102774 | 24102774 | |
| 5128 | 5128 | 1900-05-02 | 3 | a | New Zealand government decided in 1898 to provide pensions to all old people except for Asians. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102786 | 24102786 | |
| 26160 | 26160 | 1912-05-18 | 3 | b | Wine consumption in New Zealand | Statistics of wine consumption in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24092239 | 24092239 |
| 26547 | 26547 | 1912-08-10 | 3 | b | Exile Arabic prince in New Zealand urged to return. | New Zealand | http://trove.nla.gov.au/newspaper/page/24092335 | 24092335 | |
| 27032 | 27032 | 1913-02-22 | 3 | a-b | British South Pole explorer dies of snowslide. | New Zealand | http://trove.nla.gov.au/newspaper/page/24092584 | 24092584 | |
| 32148 | 32148 | 1917-03-17 | 3 | a-b | Second and final part of a commercial report prepared by Yu Ronghe, acting Chinese Consul-General in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24095624 | 24095624 | |
| 37585 | 37585 | 1921-09-17 | 3 | c | Earthquake in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24093686 | 24093686 | |
| 44355 | 44355 | 1926-01-23 | 3 | d-f | Fellows of Zengcheng county in New Zealand organise a society and names listed for donations. | New Zealand | http://trove.nla.gov.au/newspaper/page/24101430 | 24101430 | |
| 44374 | 44374 | 1926-01-30 | 3 | d-f | Fellows of Zengcheng county in New Zealand organise a society and names listed for donations. | New Zealand | http://trove.nla.gov.au/newspaper/page/24101438 | 24101438 | |
| 44594 | 44594 | 1926-04-10 | 3 | d-f | Names listed for donations to the Zengcheng fellows association in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24101517 | 24101517 | |
| 55572 | 55572 | 1935-11-09 | 3 | d | Chinese communities in Wellington, New Zealand, celebrate the National Day. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096635 | 24096635 |
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]);