This data as json, CSV (advanced)
Suggested facets: column, description, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
42046 | 42046 | 1924-09-06 | 5 | a-b | Chinese community in Auckland welcomes the Chinese football team and the detailed report. | New Zealand | http://trove.nla.gov.au/newspaper/page/24100850 | 24100850 | |
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 | |
47707 | 47707 | 1928-12-29 | 5 | a | Third and final 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/24099067 | 24099067 | |
47832 | 47832 | 1929-02-16 | 5 | a | Public notice issued by Yu Enhe, acting Chinese Consul-General in New Zealand, on the entry of Chinese students into New Zealand and his correspondence with the authorities. | New Zealand | |||
51386 | 51386 | 1932-04-09 | 5 | b | Soviet Russia guards against capitalist invasion. | New Zealand | http://trove.nla.gov.au/newspaper/page/24090761 | 24090761 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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]);