This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24788 | 24788 | 1911-08-05 | 2 | c-d | Notice of New Zealand Counsel | Xia Tingxian notifies overseas Chinese in New Zealand that they should watch their hygiene rather than complain the local government's discriminating policies to Chinese. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091867 | 24091867 |
24803 | 24803 | 1911-08-05 | 3 | c-d | Guangdong news | Police department in Guangdong bans the People Newspaper. New government building is to be constructed. Opposition to Portugal's conspiracy to invade Chinese sea right. Two imperial ministers investigate Guangzhou riots. Feng Ru is testing his plane. Fu Shang in Guangdong is flooding. Soldiers of Qing imperial army raped a woman in village. New chief takes office of National (Da Qing) Bank in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24091866 | 24091866 |
24813 | 24813 | 1911-08-05 | 8 | c-d | New provisions on opium ban in New Zealand | Some new provisions have been added to the opium ban regulations in New Zealand. | New Zealand | http://trove.nla.gov.au/newspaper/page/24091873 | 24091873 |
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]);