This data as json, CSV (advanced)
Suggested facets: page, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 5572 | 5572 | 1900-06-30 | 2 | b-c | The Chinese Empire Reform Association in Canada; meetings; list of executives. | Canada | http://trove.nla.gov.au/newspaper/page/24102858 | 24102858 | |
| 18016 | 18016 | 1907-08-31 | 2 | b-c | An article selected from the East Times in Shanghai comments on assassination of imperial commissioner of Anhui province En Ming by Xu Xilin. | Canada | http://trove.nla.gov.au/newspaper/page/26801452 | 26801452 | |
| 21377 | 21377 | 1909-07-24 | 6 | b-c | Canadian authority revises its restrictions upon Chinese immigrants; a Chinese translation on the new immigration regulations. | Canada | http://trove.nla.gov.au/newspaper/page/26802268 | 26802268 | |
| 23991 | 23991 | 1910-12-17 | 3 | b-c | American parliament sits. | Canada | http://trove.nla.gov.au/newspaper/page/26802873 | 26802873 | |
| 27747 | 27747 | 1913-08-16 | 3 | b-c | Local authorities in Canada prohibits Chinese businessmen from employing white women and the protest from Chinese consul-general Lu Bingtian. | Canada | http://trove.nla.gov.au/newspaper/page/24092784 | 24092784 | |
| 30463 | 30463 | 1915-09-11 | 7 | b-c | Chinese government is to keep republican system and not to restore the imperial system. | Canada | http://trove.nla.gov.au/newspaper/page/24094982 | 24094982 | |
| 33570 | 33570 | 1918-08-31 | 3 | b-c | Canadian government relaxes its restriction on the entry of Chinese students. | Canada | http://trove.nla.gov.au/newspaper/page/24097411 | 24097411 | |
| 34458 | 34458 | 1919-05-03 | 7 | b-c | Journalist and branch leader of the Nationalist Party (Guomindang) is arrested in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24097705 | 24097705 | |
| 37091 | 37091 | 1921-06-11 | 3 | b-c | A fierce clash between black and white people in American claims some death and injuries. | Canada | http://trove.nla.gov.au/newspaper/page/24093572 | 24093572 | |
| 37261 | 37261 | 1921-07-02 | 6 | b-c | Chinese ambassador to Washington comments on the Britain-Japan alliance. | Canada | http://trove.nla.gov.au/newspaper/page/24093601 | 24093601 | |
| 40610 | 40610 | 1923-10-27 | 7 | b-c | Chinese community in Canada and the new immigration regulation issued by the Canadian authority. Chinese residents in Canada are required to register. | Canada | http://trove.nla.gov.au/newspaper/page/24094595 | 24094595 |
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]);