This data as json, CSV (advanced)
Suggested facets: page, title, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
19005 | 19005 | 1908-03-07 | 8 | a-b | First part of the foreword to the Chinese newspaper xin bao, official paper of the Chinese Empire Reform Association in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/26801660 | 26801660 | |
19045 | 19045 | 1908-03-14 | 8 | a-b | Second and final part of the foreword to the Chinese newspaper xin bao, official organ of the Chinese Empire Reform Association in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/26801668 | 26801668 | |
21473 | 21473 | 1909-08-14 | 3 | a-b | Correspondence from Canada/ Copy of the regulation issued by Canadian authority to ban opium. | Canada | http://trove.nla.gov.au/newspaper/page/26802287 | 26802287 | |
22582 | 22582 | 1910-03-26 | 8 | a-b | An open letter from Chinese Empire Reform Association in Canada regarding Zhenhua company and the murder of Liu Shiji. | Canada | http://trove.nla.gov.au/newspaper/page/26802575 | 26802575 | |
24190 | 24190 | 1911-01-21 | 3 | a-b | The high cost to build protection in the Panama River | The American government plans to raise money to build a barbette to protect the Panama River. | Canada | http://trove.nla.gov.au/newspaper/page/24091604 | 24091604 |
25385 | 25385 | 1911-12-09 | 3 | a-b | Canadian government welcomes migrants | Number of British migrants has increased in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24092026 | 24092026 |
28266 | 28266 | 1913-12-13 | 3 | a-b | Japanese population in Canada increases. | Canada | http://trove.nla.gov.au/newspaper/page/24092920 | 24092920 | |
33943 | 33943 | 1918-12-28 | 6 | a-b | The end of the Chinese Nationalist Party (Guomindang) in Canada following the deportation of its leader. | Canada | http://trove.nla.gov.au/newspaper/page/24097554 | 24097554 | |
34335 | 34335 | 1919-03-29 | 6 | a-b | Canadian authority bans the Chinese Nationalist Party (Guomindang) and the Chinese Labour Party, and the public notice. | Canada | http://trove.nla.gov.au/newspaper/page/24097666 | 24097666 |
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]);