This data as json, CSV (advanced)
Suggested facets: date, page, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 6796 | 6796 | 1901-01-05 | 2 | f | Immigration regulations. American government has banned the entry of Chinese. However many Canadians have helped Chinese cross the border into America. They have made a large profit from the scheme. | Canada | http://trove.nla.gov.au/newspaper/page/24099906 | 24099906 | |
| 8986 | 8986 | 1901-11-02 | 2 | f | Some Canadians protest the use of English as the official language used by the Prince of England rather than French. | Canada | http://trove.nla.gov.au/newspaper/page/24100217 | 24100217 | |
| 10564 | 10564 | 1902-05-10 | 2 | f | Protest against the humiliating quarantine examination performed on immigrants by customs in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24100420 | 24100420 | |
| 33895 | 33895 | 1918-12-14 | 3 | f | Earthquake in Chile, South America. | Canada | http://trove.nla.gov.au/newspaper/page/24097533 | 24097533 | |
| 33939 | 33939 | 1918-12-28 | 3 | f | Portuguese President is assassinated. | Canada | http://trove.nla.gov.au/newspaper/page/24097549 | 24097549 | |
| 34244 | 34244 | 1919-03-08 | 3 | f | The secret treaty between China and Japan. | Canada | http://trove.nla.gov.au/newspaper/page/24097637 | 24097637 | |
| 34279 | 34279 | 1919-03-15 | 3 | f | The East Asian problems will be settled by the League of Nations. | Canada | http://trove.nla.gov.au/newspaper/page/24097645 | 24097645 | |
| 34540 | 34540 | 1919-05-31 | 3 | f | Canadian government imposes severe restriction on Chinese immigration. | Canada | http://trove.nla.gov.au/newspaper/page/24097733 | 24097733 | |
| 34648 | 34648 | 1919-07-05 | 3 | f | China will not sign the Treaty of Versailles. | Canada | http://trove.nla.gov.au/newspaper/page/24097775 | 24097775 | |
| 34754 | 34754 | 1919-08-02 | 3 | f | Many American servicemen marry foreign women. | Canada | http://trove.nla.gov.au/newspaper/page/24097809 | 24097809 | |
| 34798 | 34798 | 1919-08-16 | 3 | f | Chinese communities around the world protest against Japan's intention to occupy Shandong. | Canada | http://trove.nla.gov.au/newspaper/page/24097827 | 24097827 | |
| 37845 | 37845 | 1921-11-12 | 3 | f | Why Japanese Prime Minister Hara Takashi is assassinated. | Canada | http://trove.nla.gov.au/newspaper/page/24093750 | 24093750 | |
| 38779 | 38779 | 1922-05-27 | 3 | f | Comments on Zhang Zuolin's independence declaration. | Canada | http://trove.nla.gov.au/newspaper/page/24093985 | 24093985 | |
| 38856 | 38856 | 1922-06-10 | 3 | f | Sun Yatsen starts the north expedition. | Canada | http://trove.nla.gov.au/newspaper/page/24094001 | 24094001 | |
| 38925 | 38925 | 1922-06-24 | 3 | f | Canadian government is planning to impose strict restriction upon Chinese immigrants. | Canada | http://trove.nla.gov.au/newspaper/page/24094017 | 24094017 | |
| 39025 | 39025 | 1922-11-18 | 3 | f | Earthquake in Chile. | Canada | http://trove.nla.gov.au/newspaper/page/24094187 | 24094187 | |
| 39397 | 39397 | 1923-02-10 | 3 | f | Canadian authority issues new restriction to the Chinese immigration. | Canada | http://trove.nla.gov.au/newspaper/page/24094285 | 24094285 | |
| 41722 | 41722 | 1924-06-21 | 3 | f | Chinese community in Canada and the new restriction upon Chinese immigrant. | Canada | http://trove.nla.gov.au/newspaper/page/24100760 | 24100760 | |
| 41779 | 41779 | 1924-07-05 | 3 | f | Typhoon and storm in Iowa, United States. | Canada | http://trove.nla.gov.au/newspaper/page/24100776 | 24100776 | |
| 42527 | 42527 | 1925-01-03 | 3 | f | A Christmas party in Canada is swept by fire. | Canada | http://trove.nla.gov.au/newspaper/page/24100986 | 24100986 | |
| 42951 | 42951 | 1925-04-04 | 3 | f | Fire in North and South Dakota, United States of America. | Canada | http://trove.nla.gov.au/newspaper/page/24101085 | 24101085 | |
| 45736 | 45736 | 1927-05-21 | 3 | f | Circular telegram issued by Lu Xingban to support the Nationalist Party and Jiang Jieshi. | Canada | http://trove.nla.gov.au/newspaper/page/24101991 | 24101991 | |
| 48394 | 48394 | 1929-08-24 | 2 | f | Changes in Soviet Russia and their China policy. | Canada | http://trove.nla.gov.au/newspaper/page/24099331 | 24099331 | |
| 48395 | 48395 | 1929-08-24 | 2 | f | America may invest in the Manchurian railways. | Canada | http://trove.nla.gov.au/newspaper/page/24099331 | 24099331 | |
| 53813 | 53813 | 1934-01-27 | 6 | f | Three Chinese in Vancouver, Canada, die from beriberi. | Canada | http://trove.nla.gov.au/newspaper/page/24091515 | 24091515 |
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]);