This data as json, CSV (advanced)
Link | rowid | date | page | column ▼ | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
47690 | 47690 | 1928-12-22 | 5 | d-e | Second part of the 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/24099059 | 24099059 | |
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 | |
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 | |
4408 | 4408 | 1900-01-10 | 2 | f | The gold production of New Zealand | New Zealand | http://trove.nla.gov.au/newspaper/page/24102667 | 24102667 | |
4409 | 4409 | 1900-01-10 | 2 | f | A man in New Zealand charged with forging stamps. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102667 | 24102667 | |
4503 | 4503 | 1900-01-24 | 2 | f | A woman in Auckland, New Zealand, poisoned her baby after eating too much cheese. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102683 | 24102683 | |
5296 | 5296 | 1900-05-23 | 2 | f | Two Maoris in New Zealand died on their friend's wedding. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102812 | 24102812 | |
52226 | 52226 | 1932-11-19 | 8 | f | Chinese communities in New Zealand condemn the proposal to prohibit Chinese from employing white women employees. | New Zealand | http://trove.nla.gov.au/newspaper/page/24091030 | 24091030 | |
52812 | 52812 | 1933-04-29 | 5 | f | Chinese communities in Palmerston, New Zealand, and their patriotism. | New Zealand | http://trove.nla.gov.au/newspaper/page/24091206 | 24091206 | |
53463 | 53463 | 1933-10-28 | 5 | f | Chinese communities in Wellington celebrate the National Day. | New Zealand | http://trove.nla.gov.au/newspaper/page/24091415 | 24091415 | |
53494 | 53494 | 1933-11-04 | 5 | f | Chinese communities in Wellington, New Zealand, celebrate the National Day. | New Zealand | http://trove.nla.gov.au/newspaper/page/24091423 | 24091423 | |
55205 | 55205 | 1935-06-15 | 5 | f | A gathering of the Zengcheng fellows in Wellington, New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096466 | 24096466 | |
55608 | 55608 | 1935-11-23 | 5 | f | The Chinese Association in New Zealand acts as guarantee for Chinese students who are studying in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096653 | 24096653 | |
55624 | 55624 | 1935-11-30 | 5 | f | The Chinese Association in New Zealand acts as guarantee for Chinese students who are studying in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096661 | 24096661 | |
55758 | 55758 | 1936-01-25 | 8 | f | The Chinese School in Wellington, New Zealand, is on holiday and its meeting. | New Zealand | http://trove.nla.gov.au/newspaper/page/24096725 | 24096725 | |
51690 | 51690 | 1932-07-09 | 5 | g | Chinese communities in Wellington, New Zealand, donate to the war of resistance to Japanese invasion in China, and names listed. | New Zealand | http://trove.nla.gov.au/newspaper/page/24090866 | 24090866 |
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]);