This data as json, CSV (advanced)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 28180 | 28180 | 1913-11-22 | 8 | a | Second and final part of the report on the Chinese in Canada and their sufferings. | Canada | http://trove.nla.gov.au/newspaper/page/24092903 | 24092903 | |
| 28233 | 28233 | 1913-12-06 | 3 | b | Radio communication in Ottawa, Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24092912 | 24092912 | |
| 28266 | 28266 | 1913-12-13 | 3 | a-b | Japanese population in Canada increases. | Canada | http://trove.nla.gov.au/newspaper/page/24092920 | 24092920 | |
| 28268 | 28268 | 1913-12-13 | 3 | b | A Canadian railway company to build a 10-mile-long tunnel. | Canada | http://trove.nla.gov.au/newspaper/page/24092920 | 24092920 | |
| 28275 | 28275 | 1913-12-13 | 3 | c | Canadian authority to ban entry of Asian immigrants. | Canada | http://trove.nla.gov.au/newspaper/page/24092920 | 24092920 | |
| 28334 | 28334 | 1913-12-27 | 3 | c | Revenue increases in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24092936 | 24092936 | |
| 28695 | 28695 | 1914-04-11 | 3 | b | Immigration officer from Western Australia comments on the yellow peril in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24093069 | 24093069 | |
| 28718 | 28718 | 1914-04-18 | 3 | b | Chinese house servant in Vancouver murders his employer. | Canada | http://trove.nla.gov.au/newspaper/page/24093077 | 24093077 | |
| 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 | |
| 28754 | 28754 | 1914-04-25 | 3 | c | Trial on the Chinese house servant in Vancouver for his murder of the hostess. | Canada | http://trove.nla.gov.au/newspaper/page/24093085 | 24093085 | |
| 28805 | 28805 | 1914-05-09 | 3 | c | Canadian government helps to build a railway across the continent. | Canada | http://trove.nla.gov.au/newspaper/page/24093101 | 24093101 | |
| 28942 | 28942 | 1914-06-13 | 3 | c-d | Canadian parliament to revise regulation on Asian immigration. | Canada | http://trove.nla.gov.au/newspaper/page/24093139 | 24093139 | |
| 28967 | 28967 | 1914-06-20 | 3 | c | Canadian authority refuses the entry of some Indian immigrants. | Canada | http://trove.nla.gov.au/newspaper/page/24093147 | 24093147 | |
| 29043 | 29043 | 1914-07-11 | 3 | c | A Canadian newspaper reporter is sacked for discriminative writings. Nearly 200 Canadian teachers visit London. | Canada | http://trove.nla.gov.au/newspaper/page/24093171 | 24093171 | |
| 29073 | 29073 | 1914-07-18 | 3 | c | Canadian authority refuses to pay Indian immigrants for their return. | Canada | http://trove.nla.gov.au/newspaper/page/24093179 | 24093179 | |
| 29099 | 29099 | 1914-07-25 | 3 | c | Canadian authority and the Indian immigrants. | Canada | http://trove.nla.gov.au/newspaper/page/24093187 | 24093187 | |
| 29627 | 29627 | 1915-01-23 | 7 | c | Social parties from various neutral countries hold a war mediation conference in Danmark. | Canada | http://trove.nla.gov.au/newspaper/page/24094699 | 24094699 | |
| 29779 | 29779 | 1915-03-20 | 3 | b | Japan's unreasonable demands on China result in overseas Chinese in America and Canada refusing to buy Japanese goods. | Canada | http://trove.nla.gov.au/newspaper/page/24094776 | 24094776 | |
| 29781 | 29781 | 1915-03-20 | 3 | b | Portland is to be independent from Russia. | Canada | http://trove.nla.gov.au/newspaper/page/24094776 | 24094776 | |
| 29797 | 29797 | 1915-03-20 | 7 | b | Japan sends warships and troops to Manchu and other ports in China. | Canada | http://trove.nla.gov.au/newspaper/page/24094780 | 24094780 | |
| 29972 | 29972 | 1915-04-24 | 8 | a | Chinese businessmen suffer greatly from the Canadian Bank's bankruptcy. | Canada | http://trove.nla.gov.au/newspaper/page/24094823 | 24094823 | |
| 30124 | 30124 | 1915-06-05 | 3 | b | Treaty between China and Japan is signed in Japan. | Canada | http://trove.nla.gov.au/newspaper/page/24094864 | 24094864 | |
| 30136 | 30136 | 1915-06-05 | 7 | b | Japanese politicians are gathering to oppose their government for the treaty with China. | Canada | http://trove.nla.gov.au/newspaper/page/24094868 | 24094868 | |
| 30241 | 30241 | 1915-07-03 | 7 | b | Statistics of soldiers killed and warships lost in the war from all warring nations. | Canada | http://trove.nla.gov.au/newspaper/page/24094900 | 24094900 | |
| 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 | |
| 30695 | 30695 | 1915-11-13 | 3 | c | Some 2,000 women joining army in Serbia fight against enemy troops. | Canada | http://trove.nla.gov.au/newspaper/page/24095050 | 24095050 | |
| 30699 | 30699 | 1915-11-13 | 3 | c | Swaziland proposes all warring countries to stop war and have peace negotiation. | Canada | http://trove.nla.gov.au/newspaper/page/24095050 | 24095050 | |
| 30720 | 30720 | 1915-11-20 | 3 | c | A riot taking place in Egypt attempts to throw down the government and advocate Egypt's independence. | Canada | http://trove.nla.gov.au/newspaper/page/24095058 | 24095058 | |
| 30733 | 30733 | 1915-11-20 | 7 | b | Shanghai governor Zhu Qinghui is assassinated by the revolutionary party in Shanghai. | Canada | http://trove.nla.gov.au/newspaper/page/24095062 | 24095062 | |
| 30816 | 30816 | 1915-12-11 | 8 | a | Strange legal case in Beijing/ Wu Baojun is sentenced to death for his conspiracy on looting properties of his previous master. | Canada | http://trove.nla.gov.au/newspaper/page/24095092 | 24095092 | |
| 31120 | 31120 | 1916-04-08 | 7 | b | Signs of chaos in China and the panic. | Canada | http://trove.nla.gov.au/newspaper/page/24095223 | 24095223 | |
| 31479 | 31479 | 1916-08-12 | 6 | a | Japan to return Shandong to China and the report. | Canada | http://trove.nla.gov.au/newspaper/page/24095369 | 24095369 | |
| 32159 | 32159 | 1917-03-17 | 7 | c | Casualties of the World War I. | Canada | http://trove.nla.gov.au/newspaper/page/24095628 | 24095628 | |
| 32168 | 32168 | 1917-03-24 | 3 | c-d | Diplomatic relations between China and Germany suspended. | Canada | http://trove.nla.gov.au/newspaper/page/24095632 | 24095632 | |
| 32354 | 32354 | 1917-06-02 | 7 | c | Li Jingyi is appointed Chinese Premier. | Canada | http://trove.nla.gov.au/newspaper/page/24095716 | 24095716 | |
| 32356 | 32356 | 1917-06-02 | 7 | c | Fire in Tokyo. | Canada | http://trove.nla.gov.au/newspaper/page/24095716 | 24095716 | |
| 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 | |
| 32451 | 32451 | 1917-07-07 | 7 | c | Tremendous political change in China following the restoration of Emperor Xuantong to the throne, and response of American Chinese communities. | Canada | http://trove.nla.gov.au/newspaper/page/24095756 | 24095756 | |
| 32544 | 32544 | 1917-08-11 | 3 | e | China to declare war with Germany. | Canada | http://trove.nla.gov.au/newspaper/page/24095792 | 24095792 | |
| 32550 | 32550 | 1917-08-11 | 7 | c | Foreign report on the current politics in China. | Canada | http://trove.nla.gov.au/newspaper/page/24095796 | 24095796 | |
| 33108 | 33108 | 1918-03-16 | 3 | e | Chinese army does not enter Siberia. | Canada | http://trove.nla.gov.au/newspaper/page/24097215 | 24097215 | |
| 33205 | 33205 | 1918-04-20 | 3 | e | Japan's motives in China. | Canada | http://trove.nla.gov.au/newspaper/page/24097255 | 24097255 | |
| 33223 | 33223 | 1918-04-27 | 3 | c | Canadian journalist comments on the crisis in China and its relations to the international peace. | Canada | http://trove.nla.gov.au/newspaper/page/24097263 | 24097263 | |
| 33251 | 33251 | 1918-05-04 | 7 | c | China seeks co-operation from Japan to jointly resist enemies. | Canada | http://trove.nla.gov.au/newspaper/page/24097275 | 24097275 | |
| 33278 | 33278 | 1918-05-11 | 7 | c | Duan Qirui's ship collide with another passenger ferry in Hankou, Hubei. | Canada | http://trove.nla.gov.au/newspaper/page/24097285 | 24097285 | |
| 33546 | 33546 | 1918-08-24 | 2 | e | Tang Hualong arrives Canada for a tour. | Canada | http://trove.nla.gov.au/newspaper/page/24097404 | 24097404 | |
| 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 | |
| 33733 | 33733 | 1918-10-19 | 2 | d-e | Tang Hualong is murdered by Wang Chang in Canada and the detailed report. | Canada | http://trove.nla.gov.au/newspaper/page/24097470 | 24097470 | |
| 33801 | 33801 | 1918-11-09 | 3 | e | China may demand the return of Jiaozhou peninsula after the War, says the Chinese consul in San Francisco. | Canada | http://trove.nla.gov.au/newspaper/page/24097493 | 24097493 | |
| 33838 | 33838 | 1918-11-23 | 7 | b | A Chinese revolutionary argues that foreign countries should not interfere with the internal affairs of China. | Canada | http://trove.nla.gov.au/newspaper/page/24097513 | 24097513 | |
| 33856 | 33856 | 1918-11-30 | 7 | c | Chinese president orders to destroy large amount of opium in Shanghai. | Canada | http://trove.nla.gov.au/newspaper/page/24097521 | 24097521 | |
| 33895 | 33895 | 1918-12-14 | 3 | f | Earthquake in Chile, South America. | Canada | http://trove.nla.gov.au/newspaper/page/24097533 | 24097533 | |
| 33896 | 33896 | 1918-12-14 | 3 | e | Storm in Honolulu, Hawaii. | 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 | |
| 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 | |
| 33962 | 33962 | 1919-01-04 | 3 | e | Canadian authority detains members of the Chinese Nationalist Party (Guomindang). | Canada | http://trove.nla.gov.au/newspaper/page/24097557 | 24097557 | |
| 34010 | 34010 | 1919-01-18 | 3 | e | Former American president Roosevelt dies. | Canada | http://trove.nla.gov.au/newspaper/page/24097574 | 24097574 | |
| 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 | |
| 34312 | 34312 | 1919-03-22 | 6 | c | Canadian government disbands the Chinese Nationalist Party (Guomindang). | Canada | http://trove.nla.gov.au/newspaper/page/24097658 | 24097658 | |
| 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 | |
| 34401 | 34401 | 1919-04-19 | 6 | c | Japanese in Seoul, Korea, kill more than 1,000 Korean people. | Canada | http://trove.nla.gov.au/newspaper/page/24097690 | 24097690 | |
| 34454 | 34454 | 1919-05-03 | 6 | c | The Allies countries have finalised the treaty with Germany at the Paris Peace Conference. | Canada | http://trove.nla.gov.au/newspaper/page/24097706 | 24097706 | |
| 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 | |
| 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 | |
| 34556 | 34556 | 1919-06-07 | 3 | d | Canadian government bars Chinese labourers from entry. | Canada | http://trove.nla.gov.au/newspaper/page/24097741 | 24097741 | |
| 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 | |
| 34673 | 34673 | 1919-07-12 | 3 | 3 | Political turmoil in Peru. | Canada | http://trove.nla.gov.au/newspaper/page/24097783 | 24097783 | |
| 34754 | 34754 | 1919-08-02 | 3 | f | Many American servicemen marry foreign women. | Canada | http://trove.nla.gov.au/newspaper/page/24097809 | 24097809 | |
| 34779 | 34779 | 1919-08-09 | 6 | c | Japanese foreign minister talks on the Shandong issue. | Canada | http://trove.nla.gov.au/newspaper/page/24097824 | 24097824 | |
| 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 | |
| 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 | |
| 34905 | 34905 | 1919-09-20 | 3 | c | Storm in Xiamen, of Fujian province. | Canada | http://trove.nla.gov.au/newspaper/page/24097867 | 24097867 | |
| 34906 | 34906 | 1919-09-20 | 3 | c | Japanese troops in Seoul on high alert. | Canada | http://trove.nla.gov.au/newspaper/page/24097867 | 24097867 | |
| 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 | |
| 34935 | 34935 | 1919-09-27 | 7 | c | British authority transfers Chinese labourers to Vancouver, Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24097879 | 24097879 | |
| 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 | |
| 34979 | 34979 | 1919-10-11 | 6 | c | Chinese communities in Canada and their patriotism. | Canada | http://trove.nla.gov.au/newspaper/page/24097896 | 24097896 | |
| 34990 | 34990 | 1919-10-18 | 3 | b | Negotiation between America and Japan over the Siberian issues. | Canada | http://trove.nla.gov.au/newspaper/page/24097899 | 24097899 | |
| 35012 | 35012 | 1919-10-25 | 3 | c | Japanese ambassador in Washington talks on the Shandong issues. | Canada | http://trove.nla.gov.au/newspaper/page/24097907 | 24097907 | |
| 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 | |
| 35206 | 35206 | 1920-01-03 | 6 | a | British soldiers fight Indian rebels in the north of India. | Canada | http://trove.nla.gov.au/newspaper/page/24097996 | 24097996 | |
| 35215 | 35215 | 1920-01-03 | 6 | b | Flu in Japan. | Canada | http://trove.nla.gov.au/newspaper/page/24097996 | 24097996 | |
| 35232 | 35232 | 1920-01-10 | 6 | b | Canadian authority bans Japanese fishing in order to help the returned servicemen. | Canada | http://trove.nla.gov.au/newspaper/page/24098004 | 24098004 | |
| 35233 | 35233 | 1920-01-10 | 6 | b | Former Chinese president Feng Guozhang dies in Beijing. | Canada | http://trove.nla.gov.au/newspaper/page/24098004 | 24098004 | |
| 35236 | 35236 | 1920-01-10 | 6 | b | Earthquake in Mexico. | Canada | http://trove.nla.gov.au/newspaper/page/24098004 | 24098004 | |
| 35246 | 35246 | 1920-01-17 | 6 | a | Earthquake in Mexico. | Canada | http://trove.nla.gov.au/newspaper/page/24098012 | 24098012 | |
| 35308 | 35308 | 1920-02-07 | 6 | b | Sugarcane workers are on strike in Hawaii. | Canada | http://trove.nla.gov.au/newspaper/page/24098036 | 24098036 | |
| 35313 | 35313 | 1920-02-07 | 6 | b | Japan urges China to talk over Shandong issues. | Canada | http://trove.nla.gov.au/newspaper/page/24098036 | 24098036 | |
| 35462 | 35462 | 1920-03-06 | 3 | c | Canadian authority is considering to prohibit Japanese from purchasing property. | Canada | http://trove.nla.gov.au/newspaper/page/24098076 | 24098076 | |
| 35471 | 35471 | 1920-03-06 | 6 | b | Parliamentarian election in Japan. | Canada | http://trove.nla.gov.au/newspaper/page/24098081 | 24098081 | |
| 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 | |
| 35667 | 35667 | 1920-05-08 | 3 | c | Turmoil in Mexico. | Canada | http://trove.nla.gov.au/newspaper/page/24098150 | 24098150 | |
| 35669 | 35669 | 1920-05-08 | 3 | d | German official on the Shandong issues. | Canada | http://trove.nla.gov.au/newspaper/page/24098150 | 24098150 | |
| 35827 | 35827 | 1920-06-19 | 3 | e | Oil ship in Kobe are on fire. | Canada | http://trove.nla.gov.au/newspaper/page/24098201 | 24098201 |
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]);