This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 |
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]);