This data as json, CSV (advanced)
Suggested facets: page, description, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
4640 | 4640 | 1900-02-28 | 2 | d | A man in New Zealand commits suicide after losing in gambling. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102714 | 24102714 | |
4721 | 4721 | 1900-03-10 | 2 | d | A Chinese was beaten to death in New Zealand and the murderer has not been found. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102727 | 24102727 | |
4906 | 4906 | 1900-04-07 | 2 | d | A girl in New Zealand drowned trying to save her brother. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102759 | 24102759 | |
5844 | 5844 | 1900-08-15 | 2 | d | Eighteen people in Wellington, New Zealand, drowned while touring a river. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102908 | 24102908 | |
32590 | 32590 | 1917-10-13 | 7 | d | The war expenses by the New Zealand government. | New Zealand | http://trove.nla.gov.au/newspaper/page/24095871 | 24095871 | |
40240 | 40240 | 1923-08-11 | 7 | d | New Zealand justice minister suggests to revise regulations for the employment and payment of Chinese labourers in Samoa islands. | New Zealand | http://trove.nla.gov.au/newspaper/page/24094507 | 24094507 | |
44226 | 44226 | 1925-12-05 | 7 | d | Earthquake in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24101376 | 24101376 | |
44653 | 44653 | 1926-04-24 | 7 | d | Labour Party in New Zealand refuses to recognise the Communist Party. | New Zealand | http://trove.nla.gov.au/newspaper/page/24101537 | 24101537 | |
44793 | 44793 | 1926-05-29 | 7 | d | Heavy rain in New Zealand and the floods. | New Zealand | http://trove.nla.gov.au/newspaper/page/24101577 | 24101577 | |
44838 | 44838 | 1926-06-12 | 7 | d | A man in New Zealand is sentenced to eight years' imprisonment for the rape of an underage girl. Returned servicemen support the White New Zealand policy. | New Zealand | http://trove.nla.gov.au/newspaper/page/24101593 | 24101593 | |
44865 | 44865 | 1926-06-19 | 7 | d | Flu in New Zealand and the casualties. | New Zealand | http://trove.nla.gov.au/newspaper/page/24101603 | 24101603 | |
47476 | 47476 | 1928-10-06 | 8 | d | A public notice issued by Yu Enhe, acting Chinese Consul-General in New Zealand, on the immigration restrictions upon Chinese and other matters. | New Zealand | http://trove.nla.gov.au/newspaper/page/24098976 | 24098976 | |
47816 | 47816 | 1929-02-16 | 2 | d | Chinese Consulate-General in New Zealand in shortage of money. | New Zealand | |||
53528 | 53528 | 1933-11-11 | 6 | d | Earthquake in Wellington, New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24091434 | 24091434 | |
53589 | 53589 | 1933-11-25 | 6 | d | Aboriginal people in Samoa on riots. | New Zealand | http://trove.nla.gov.au/newspaper/page/24091450 | 24091450 | |
53978 | 53978 | 1934-03-17 | 6 | d | Earthquake in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24091569 | 24091569 | |
54384 | 54384 | 1934-07-28 | 6 | d | Maori people in New Zealand and their religion. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096104 | 24096104 | |
54588 | 54588 | 1934-10-06 | 6 | d | Hurricane in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096186 | 24096186 | |
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 | |
56379 | 56379 | 1936-10-31 | 8 | d | White woman in New Zealand injures Chinese man. | New Zealand | http://trove.nla.gov.au/newspaper/page/24097050 | 24097050 |
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]);