This data as json, CSV (advanced)
Suggested facets: date, page, description, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 4408 | 4408 | 1900-01-10 | 2 | f | The gold production of New Zealand | New Zealand | http://trove.nla.gov.au/newspaper/page/24102667 | 24102667 | |
| 4409 | 4409 | 1900-01-10 | 2 | f | A man in New Zealand charged with forging stamps. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102667 | 24102667 | |
| 4503 | 4503 | 1900-01-24 | 2 | f | A woman in Auckland, New Zealand, poisoned her baby after eating too much cheese. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102683 | 24102683 | |
| 5296 | 5296 | 1900-05-23 | 2 | f | Two Maoris in New Zealand died on their friend's wedding. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102812 | 24102812 | |
| 52226 | 52226 | 1932-11-19 | 8 | f | Chinese communities in New Zealand condemn the proposal to prohibit Chinese from employing white women employees. | New Zealand | http://trove.nla.gov.au/newspaper/page/24091030 | 24091030 | |
| 52812 | 52812 | 1933-04-29 | 5 | f | Chinese communities in Palmerston, New Zealand, and their patriotism. | New Zealand | http://trove.nla.gov.au/newspaper/page/24091206 | 24091206 | |
| 53463 | 53463 | 1933-10-28 | 5 | f | Chinese communities in Wellington celebrate the National Day. | New Zealand | http://trove.nla.gov.au/newspaper/page/24091415 | 24091415 | |
| 53494 | 53494 | 1933-11-04 | 5 | f | Chinese communities in Wellington, New Zealand, celebrate the National Day. | New Zealand | http://trove.nla.gov.au/newspaper/page/24091423 | 24091423 | |
| 55205 | 55205 | 1935-06-15 | 5 | f | A gathering of the Zengcheng fellows in Wellington, New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096466 | 24096466 | |
| 55608 | 55608 | 1935-11-23 | 5 | f | The Chinese Association in New Zealand acts as guarantee for Chinese students who are studying in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096653 | 24096653 | |
| 55624 | 55624 | 1935-11-30 | 5 | f | The Chinese Association in New Zealand acts as guarantee for Chinese students who are studying in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096661 | 24096661 | |
| 55758 | 55758 | 1936-01-25 | 8 | f | The Chinese School in Wellington, New Zealand, is on holiday and its meeting. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096725 | 24096725 |
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]);