This data as json, CSV (advanced)
Suggested facets: page, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
4714 | 4714 | 1900-03-10 | 2 | c | A big shop in Auckland, New Zealand, was destroyed in a fire. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102727 | 24102727 | |
28372 | 28372 | 1914-01-03 | 7 | c | First part of a report written by Chinese Consul-General in New Zealand Gui Zhi on the strike in Auckland and influence upon the Chinese communities there. | New Zealand | http://trove.nla.gov.au/newspaper/page/24092948 | 24092948 | |
29317 | 29317 | 1914-10-17 | 6 | c | Earthquake in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24093292 | 24093292 | |
31727 | 31727 | 1916-11-11 | 6 | c | Poems by by Zeng Sugang farewell Gui Zhi, Chinese Consul-General in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24095474 | 24095474 | |
32140 | 32140 | 1917-03-10 | 7 | c | First 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/24095620 | 24095620 | |
32630 | 32630 | 1917-10-27 | 7 | c | New Zealand news/ Casualty statistics of the New Zealand army. New Zealand authority bars foreign migrants from joining the army. Authorities confiscate properties from the people who refuse to enlist for military service. | New Zealand | http://trove.nla.gov.au/newspaper/page/24095887 | 24095887 | |
32693 | 32693 | 1917-11-17 | 7 | c | Honoury Chinese consul-general in New Zealand Yu Enhe and his negotiation with authorities on the return certificate issued to departing Chinese. | New Zealand | http://trove.nla.gov.au/newspaper/page/24095911 | 24095911 | |
33151 | 33151 | 1918-03-30 | 7 | c | Fire and flood in north island of New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24097235 | 24097235 | |
37307 | 37307 | 1921-07-09 | 6 | c | Chinese communities in New Zealand donate to famine victims in China. Names listed. | New Zealand | http://trove.nla.gov.au/newspaper/page/24093609 | 24093609 | |
37585 | 37585 | 1921-09-17 | 3 | c | Earthquake in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24093686 | 24093686 | |
39309 | 39309 | 1923-01-20 | 7 | c | Chinese community in New Zealand donates to the typhoon victims in Shantou, reported by the Chinese Association there. | New Zealand | http://trove.nla.gov.au/newspaper/page/24094263 | 24094263 | |
39995 | 39995 | 1923-06-16 | 7 | c | Flood in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24094443 | 24094443 | |
40641 | 40641 | 1923-11-03 | 7 | c | A wool factory in New Zealand on fire. | New Zealand | http://trove.nla.gov.au/newspaper/page/24094603 | 24094603 | |
41348 | 41348 | 1924-03-29 | 7 | c | Chinese football team to visit New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24100667 | 24100667 | |
41415 | 41415 | 1924-04-12 | 7 | c | Flood in Auckland. | New Zealand | http://trove.nla.gov.au/newspaper/page/24100683 | 24100683 | |
41480 | 41480 | 1924-04-26 | 7 | c | Railway workers are on strike in Auckland. | New Zealand | http://trove.nla.gov.au/newspaper/page/24100699 | 24100699 | |
41546 | 41546 | 1924-05-10 | 7 | c | Rangers in New Zealand call for killing of some deer. | New Zealand | http://trove.nla.gov.au/newspaper/page/24100716 | 24100716 | |
42410 | 42410 | 1924-12-06 | 7 | c | Earthquake in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24100958 | 24100958 | |
42505 | 42505 | 1924-12-27 | 7 | c | Communist leader is imprisoned in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24100982 | 24100982 | |
42506 | 42506 | 1924-12-27 | 7 | c | Flood in Wellington, New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24100982 | 24100982 | |
43006 | 43006 | 1925-04-11 | 7 | c | A 14 year-old boy hangs himself in Auckland, New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24101098 | 24101098 | |
43280 | 43280 | 1925-05-30 | 7 | c | Heavy rain in Auckland. | New Zealand | http://trove.nla.gov.au/newspaper/page/24101153 | 24101153 | |
43904 | 43904 | 1925-09-26 | 7 | c | An Indian leopard runs away from Auckland zoo in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24101293 | 24101293 | |
44038 | 44038 | 1925-10-24 | 7 | c | A young man in Christchurch, New Zealand, shoots himself dead for failing to get recruited by the navy. | New Zealand | http://trove.nla.gov.au/newspaper/page/24101325 | 24101325 | |
44283 | 44283 | 1925-12-19 | 7 | c | Earthquake in New Zealand and the damages. | New Zealand | http://trove.nla.gov.au/newspaper/page/24101394 | 24101394 | |
44345 | 44345 | 1926-01-16 | 7 | c | The trial of Chinese gamblers in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24101426 | 24101426 | |
44817 | 44817 | 1926-06-05 | 7 | c | Flu in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24101585 | 24101585 | |
44835 | 44835 | 1926-06-12 | 6 | c | First part of a report on the opening ceremony of the Zengcheng Society in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24101594 | 24101594 | |
52028 | 52028 | 1932-10-15 | 5 | c | A newspaper in Wellington, New Zealand, reports the deportation of Chinese immigrants. A letter from the Chinese consulate in Auckland to the New Zealand Prime Minister. | New Zealand | http://trove.nla.gov.au/newspaper/page/24090985 | 24090985 | |
52279 | 52279 | 1932-12-03 | 5 | c | Chinese communities in New Zealand condemn racial discrimination and the proposal to deport Chinese immigrants. | New Zealand | http://trove.nla.gov.au/newspaper/page/24091041 | 24091041 | |
52377 | 52377 | 1932-12-24 | 8 | c | New Zealand government bans import of Australian fruits. | New Zealand | http://trove.nla.gov.au/newspaper/page/24091071 | 24091071 | |
52646 | 52646 | 1933-03-11 | 5 | c | Acting Chinese consul in New Zealand Yu Enhe condemns the anti-Chinese movement in Dunedin. | New Zealand | http://trove.nla.gov.au/newspaper/page/24091149 | 24091149 | |
53276 | 53276 | 1933-09-09 | 6 | c | Australian and New Zealand navies have a joint exercise. | New Zealand | http://trove.nla.gov.au/newspaper/page/24091362 | 24091362 | |
53588 | 53588 | 1933-11-25 | 6 | c | Chinese passenger is detained in Wellington, New Zealand, for illegally carrying gold. | New Zealand | http://trove.nla.gov.au/newspaper/page/24091450 | 24091450 | |
54325 | 54325 | 1934-07-14 | 6 | c | Heavy snow in the South Island of New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096088 | 24096088 | |
54745 | 54745 | 1934-12-15 | 6 | c | Chinese army general Qiu Zhaoshen visits Wellington, New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096267 | 24096267 | |
54884 | 54884 | 1935-02-16 | 5 | c | Chinese associations in Wellington, New Zealand, farewell Chinese consul-general Bao Gao. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096328 | 24096328 | |
55654 | 55654 | 1935-12-14 | 5 | c | Chinese communities in New Zealand donate to the floods victims in China and names listed. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096677 | 24096677 | |
55670 | 55670 | 1935-12-21 | 5 | c | Chinese communities in New Zealand donate to the floods victims in China. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096689 | 24096689 |
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]);