This data as json, CSV (advanced)
Suggested facets: page, description, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 52251 | 52251 | 1932-11-26 | 5 | d-f | A newspaper in Wellington, New Zealand, publishes a reader's letter that suggests to deport all Chinese immigrants and the response of the Chinese communities. | New Zealand | http://trove.nla.gov.au/newspaper/page/24091033 | 24091033 |
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]);