This data as json, CSV (advanced)
Suggested facets: page, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 7426 | 7426 | 1901-04-10 | 2 | d | Canada imposes stricter regulations to the entry of Chinese and Japanese, including higher tax and English knowledge. | Canada | http://trove.nla.gov.au/newspaper/page/24100000 | 24100000 | |
| 10693 | 10693 | 1902-05-24 | 2 | d | Canada is to levy higher entry tax for Chinese immigrants. | Canada | http://trove.nla.gov.au/newspaper/page/24100436 | 24100436 | |
| 19986 | 19986 | 1908-09-19 | 3 | d | Canada to ban opium trade and opium smoking. | Canada | http://trove.nla.gov.au/newspaper/page/26801882 | 26801882 | |
| 21565 | 21565 | 1909-08-28 | 3 | d | Japanese navy has manufactured speedboat. | Canada | http://trove.nla.gov.au/newspaper/page/26802303 | 26802303 | |
| 28733 | 28733 | 1914-04-18 | 7 | d | Investigation on the murder of a white woman by Chinese house servant has found a Chinese revolutionary organisation in Vancouver. | Canada | http://trove.nla.gov.au/newspaper/page/24093081 | 24093081 | |
| 32422 | 32422 | 1917-06-30 | 3 | d | The crisis of China. Chaos in China may be solved peacefully. | Canada | http://trove.nla.gov.au/newspaper/page/24095744 | 24095744 | |
| 34556 | 34556 | 1919-06-07 | 3 | d | Canadian government bars Chinese labourers from entry. | Canada | http://trove.nla.gov.au/newspaper/page/24097741 | 24097741 | |
| 34862 | 34862 | 1919-09-06 | 3 | d | American President Wilson opposes to any revision of the treaty prepared by the Paris Peace Conference. | Canada | http://trove.nla.gov.au/newspaper/page/24097851 | 24097851 | |
| 34887 | 34887 | 1919-09-13 | 3 | d | An attempt to assassinate Japanese administrator in Korea. | Canada | http://trove.nla.gov.au/newspaper/page/24097859 | 24097859 | |
| 34907 | 34907 | 1919-09-20 | 3 | d | Japanese parliament closely watches American response to the Shandong problem. | Canada | http://trove.nla.gov.au/newspaper/page/24097867 | 24097867 | |
| 34950 | 34950 | 1919-10-04 | 3 | d | American senator requests to ban entry of Japanese immigrant. | Canada | http://trove.nla.gov.au/newspaper/page/24097883 | 24097883 | |
| 34968 | 34968 | 1919-10-11 | 3 | d | Recent diplomatic relations between America, Russia and Japan. | Canada | http://trove.nla.gov.au/newspaper/page/24097891 | 24097891 | |
| 34969 | 34969 | 1919-10-11 | 3 | d | Kong Xiangke, Shandong representative to the Paris Peace Conference, talks on the Shandong issues. | Canada | http://trove.nla.gov.au/newspaper/page/24097891 | 24097891 | |
| 35026 | 35026 | 1919-11-01 | 3 | d | Chinese government plans to organise a flying team. | Canada | http://trove.nla.gov.au/newspaper/page/24097915 | 24097915 | |
| 35561 | 35561 | 1920-04-03 | 3 | d | The Panama Canal is blocked. | Canada | http://trove.nla.gov.au/newspaper/page/24098108 | 24098108 | |
| 35605 | 35605 | 1920-04-17 | 3 | d | Prince of Wales, Edward, visits Hawaii. | Canada | http://trove.nla.gov.au/newspaper/page/24098124 | 24098124 | |
| 35645 | 35645 | 1920-05-01 | 3 | d | American government dispatches warships to Mexico to protect its nationals. | Canada | http://trove.nla.gov.au/newspaper/page/24098140 | 24098140 | |
| 35669 | 35669 | 1920-05-08 | 3 | d | German official on the Shandong issues. | Canada | http://trove.nla.gov.au/newspaper/page/24098150 | 24098150 | |
| 36314 | 36314 | 1920-11-20 | 3 | d | Independence movement in Korea. | Canada | http://trove.nla.gov.au/newspaper/page/24098386 | 24098386 | |
| 36315 | 36315 | 1920-11-20 | 3 | d | Japanese government monopolise the sale of oil. | Canada | http://trove.nla.gov.au/newspaper/page/24098386 | 24098386 | |
| 36382 | 36382 | 1920-12-11 | 3 | d | Japanese are detained in Hawaii for opium smuggling. | Canada | http://trove.nla.gov.au/newspaper/page/24098410 | 24098410 | |
| 36432 | 36432 | 1920-12-25 | 3 | d | Earthquake in America. | Canada | http://trove.nla.gov.au/newspaper/page/24098428 | 24098428 | |
| 37095 | 37095 | 1921-06-11 | 3 | d | Flood in Colorado, United States. | Canada | http://trove.nla.gov.au/newspaper/page/24093572 | 24093572 | |
| 37120 | 37120 | 1921-06-18 | 3 | d | Riots in Turkey and the support from Russia. | Canada | http://trove.nla.gov.au/newspaper/page/24093580 | 24093580 | |
| 37417 | 37417 | 1921-08-06 | 3 | d | The war between Greece and Turkey. | Canada | http://trove.nla.gov.au/newspaper/page/24093636 | 24093636 | |
| 37480 | 37480 | 1921-08-20 | 3 | d | Some American-born Japanese claim that they are actually white people. | Canada | http://trove.nla.gov.au/newspaper/page/24093654 | 24093654 | |
| 37514 | 37514 | 1921-08-27 | 3 | d | One hundred revolutionaries are shot dead in Brazil in a rebellion. | Canada | http://trove.nla.gov.au/newspaper/page/24093662 | 24093662 | |
| 37590 | 37590 | 1921-09-17 | 3 | d | Flood in Texas, America. | Canada | http://trove.nla.gov.au/newspaper/page/24093686 | 24093686 | |
| 37672 | 37672 | 1921-10-08 | 3 | d | Earthquake in America. | Canada | http://trove.nla.gov.au/newspaper/page/24093710 | 24093710 | |
| 37874 | 37874 | 1921-11-19 | 3 | d | Chinese delegate talks to American journalist before the opening of the Washington Conference. | Canada | http://trove.nla.gov.au/newspaper/page/24093758 | 24093758 | |
| 40285 | 40285 | 1923-08-25 | 3 | d | America and Mexico resume diplomatic relations. | Canada | http://trove.nla.gov.au/newspaper/page/24094519 | 24094519 | |
| 40361 | 40361 | 1923-09-08 | 3 | d | Canadian government regards China as unfriendly country. | Canada | http://trove.nla.gov.au/newspaper/page/24094535 | 24094535 | |
| 42909 | 42909 | 1925-03-28 | 3 | d | A coal mine explodes in the west of Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24101077 | 24101077 | |
| 48487 | 48487 | 1929-09-21 | 8 | d | A plane accident in America. | Canada | http://trove.nla.gov.au/newspaper/page/24099371 | 24099371 | |
| 48838 | 48838 | 1930-02-01 | 2 | d | Another wave of anti-Asian movement in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24099511 | 24099511 | |
| 49267 | 49267 | 1930-06-28 | 2 | d | Feud and fighting of the Chinese societies in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24099683 | 24099683 | |
| 50435 | 50435 | 1931-06-20 | 8 | d | British ship finds new island. | Canada | http://trove.nla.gov.au/newspaper/page/24090427 | 24090427 | |
| 51192 | 51192 | 1932-02-13 | 8 | d | Japanese prime minister on their invasion of Manchuria and Shanghai. | Canada | http://trove.nla.gov.au/newspaper/page/24090702 | 24090702 | |
| 55080 | 55080 | 1935-05-04 | 8 | d | Naval power of the United States of America. | Canada | http://trove.nla.gov.au/newspaper/page/24096423 | 24096423 | |
| 55503 | 55503 | 1935-10-12 | 3 | d | Canada seeks to leave away the world war. | Canada | http://trove.nla.gov.au/newspaper/page/24096603 | 24096603 |
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]);