This data as json, CSV (advanced)
Suggested facets: date, page, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
4404 | 4404 | 1900-01-10 | 2 | e | A man in Dunedin, New Zealand, was charged with murdering his wife. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102667 | 24102667 | |
5465 | 5465 | 1900-06-13 | 2 | e | All old people in New Zealand are entitled to receive pensions from the government except for Chinese. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102838 | 24102838 | |
6213 | 6213 | 1900-10-03 | 2 | e | New Zealand wants to govern other British island colonies in the Pacific. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102969 | 24102969 | |
8865 | 8865 | 1901-10-19 | 2 | e | New Zealand considers boycotting imports from Australia. | New Zealand | http://trove.nla.gov.au/newspaper/page/24100201 | 24100201 | |
44629 | 44629 | 1926-04-17 | 7 | e | Poor sale of flour in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24101529 | 24101529 | |
52217 | 52217 | 1932-11-19 | 5 | e | Notice issued by the Chinese consulate in New Zealand on the ban for Chinese from employing white women employees, responses of the Chinese communities on the ban, and negotiations between Chinese representatives and New Zealand authorities. | New Zealand | http://trove.nla.gov.au/newspaper/page/24091026 | 24091026 | |
52757 | 52757 | 1933-04-15 | 5 | e | Chinese community in Wellington, New Zealand, welcomes new Chinese consul. | New Zealand | http://trove.nla.gov.au/newspaper/page/24091189 | 24091189 | |
53202 | 53202 | 1933-08-19 | 5 | e | Chinese in Wellington, New Zealand, organise an association and the report. | New Zealand | http://trove.nla.gov.au/newspaper/page/24091335 | 24091335 | |
53944 | 53944 | 1934-03-10 | 5 | e | Chinese communities in Wellington, New Zealand, to set up a Chinese school. | New Zealand | http://trove.nla.gov.au/newspaper/page/24091558 | 24091558 | |
54159 | 54159 | 1934-05-19 | 5 | e | Chinese communities in Wellington, New Zealand, donate to the Zhongshan University in Guangzhou and names listed. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096019 | 24096019 | |
54167 | 54167 | 1934-05-19 | 6 | e | Chinese and Indian immigrants are fighting in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096022 | 24096022 | |
54376 | 54376 | 1934-07-28 | 5 | e | Dozens of Chinese in Waipawa, central New Zealand, organise an association. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096101 | 24096101 | |
55229 | 55229 | 1935-06-29 | 8 | e | Chinese man detained in New Zealand for opium smuggling. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096487 | 24096487 | |
55638 | 55638 | 1935-12-07 | 5 | e | Chinese associations in New Zealand donates to the floods victims in China and names listed. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096669 | 24096669 |
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]);