This data as json, CSV (advanced)
Suggested facets: page, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 26593 | 26593 | 1912-08-17 | 6 | b-c | More than 300 names listed from New Zealand for their donations to save Chinese nation. | New Zealand | http://trove.nla.gov.au/newspaper/page/24092348 | 24092348 | |
| 27806 | 27806 | 1913-08-30 | 7 | b-c | New Zealand news/ An old couple, more than 70 years old, divorce in Wellington. Smallpox in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24092804 | 24092804 | |
| 28975 | 28975 | 1914-06-20 | 7 | b-c | First part of the new immigration regulations issued by the New Zealand governor, translated by Chinese consul-general there Gui Zhi. | New Zealand | http://trove.nla.gov.au/newspaper/page/24093151 | 24093151 | |
| 31265 | 31265 | 1916-05-27 | 7 | b-c | A serviceman dies of small pox in Wellington, New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24095279 | 24095279 | |
| 31463 | 31463 | 1916-08-05 | 7 | b-c | A Maori man in New Zealand claims himself a prophet and is brought to trial. | New Zealand | http://trove.nla.gov.au/newspaper/page/24095358 | 24095358 | |
| 35122 | 35122 | 1919-12-06 | 7 | b-c | Two notices issued by the Chinese Consulate-General in New Zealand on the recent Chinese immigration. | New Zealand | http://trove.nla.gov.au/newspaper/page/24097963 | 24097963 | |
| 36325 | 36325 | 1920-11-20 | 7 | b-c | A Chinese in New Zealand pretends to be Japanese. | New Zealand | http://trove.nla.gov.au/newspaper/page/24098390 | 24098390 | |
| 37881 | 37881 | 1921-11-19 | 6 | b-c | Statistics on China's export to New Zealand in 1920. | New Zealand | http://trove.nla.gov.au/newspaper/page/24093763 | 24093763 | |
| 37911 | 37911 | 1921-11-26 | 6 | b-c | China's export to New Zealand in 1920. | New Zealand | http://trove.nla.gov.au/newspaper/page/24093771 | 24093771 | |
| 39215 | 39215 | 1922-12-30 | 7 | b-c | Earthquake in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24094239 | 24094239 | |
| 39800 | 39800 | 1923-04-28 | 7 | b-c | Chinese community in Wellington, New Zealand, donates to the flood victims in Zhejiang province. Names listed. | New Zealand | http://trove.nla.gov.au/newspaper/page/24094387 | 24094387 | |
| 43241 | 43241 | 1925-05-23 | 7 | b-c | Heavy rain in Auckland, New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24101145 | 24101145 | |
| 47679 | 47679 | 1928-12-15 | 8 | b-c | First part of a report on the celebrations organised by the Chinese communities in Auckland, New Zealand, on the National Day of October 10. | New Zealand | http://trove.nla.gov.au/newspaper/page/24099056 | 24099056 |
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]);