This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36293 | 36293 | 1920-11-13 | 3 | e | London banks stop to lend to Canadian and Australian banks. | Canada | http://trove.nla.gov.au/newspaper/page/24098378 | 24098378 | |
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 | |
36359 | 36359 | 1920-12-04 | 3 | e | Sinn Fein in Ireland and the riots. | Canada | http://trove.nla.gov.au/newspaper/page/24098402 | 24098402 | |
36379 | 36379 | 1920-12-11 | 3 | c | A letter from Mo Rongxin to Tang Tingguang. | Canada | http://trove.nla.gov.au/newspaper/page/24098410 | 24098410 | |
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 | |
36478 | 36478 | 1921-01-08 | 33 | c | Riots in Italy. | Canada | |||
36594 | 36594 | 1921-02-05 | 3 | c | Another revolutionary movement in Mexico. | Canada | http://trove.nla.gov.au/newspaper/page/24093417 | 24093417 | |
36662 | 36662 | 1921-02-26 | 3 | c | Group fighting of the Chinese communities in California. | Canada | http://trove.nla.gov.au/newspaper/page/24093452 | 24093452 | |
36797 | 36797 | 1921-04-02 | 3 | c | Envoy of Chinese government seeks cooperation from Britain, France and America in their attempt to regain extraterritoriality. | Canada | http://trove.nla.gov.au/newspaper/page/24093492 | 24093492 | |
36830 | 36830 | 1921-04-09 | 3 | b | American telegraph companies in China and the encouragement from their government. | Canada | http://trove.nla.gov.au/newspaper/page/24093500 | 24093500 | |
36835 | 36835 | 1921-04-09 | 3 | c | Fire in Manila and the casualties. | Canada | http://trove.nla.gov.au/newspaper/page/24093500 | 24093500 | |
36912 | 36912 | 1921-04-30 | 3 | c | Chinese legal expert Huang Qingqi on the revision of some international treaties. | Canada | http://trove.nla.gov.au/newspaper/page/24093524 | 24093524 | |
36940 | 36940 | 1921-05-07 | 3 | c | Canadian parliament discusses issues of Chinese and Japanese immigration. | Canada | http://trove.nla.gov.au/newspaper/page/24093532 | 24093532 | |
36967 | 36967 | 1921-05-14 | 3 | c | A Japanese cargo ship sinks in fire near Washington. | Canada | http://trove.nla.gov.au/newspaper/page/24093540 | 24093540 | |
37026 | 37026 | 1921-05-28 | 3 | c | A train is bombed near Chicago and more than 20 people injured. | Canada | http://trove.nla.gov.au/newspaper/page/24093556 | 24093556 | |
37059 | 37059 | 1921-06-04 | 3 | c | Relations between Britain, America and Japan. | Canada | http://trove.nla.gov.au/newspaper/page/24093564 | 24093564 | |
37061 | 37061 | 1921-06-04 | 3 | c | Beijing government orders the arrest of Sun Yatsen. | Canada | http://trove.nla.gov.au/newspaper/page/24093564 | 24093564 | |
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 | |
37095 | 37095 | 1921-06-11 | 3 | d | Flood in Colorado, United States. | Canada | http://trove.nla.gov.au/newspaper/page/24093572 | 24093572 | |
37117 | 37117 | 1921-06-18 | 3 | c | Mutiny in Yichang, Hubei province, and response of international community. | Canada | http://trove.nla.gov.au/newspaper/page/24093580 | 24093580 | |
37119 | 37119 | 1921-06-18 | 3 | c | Another mutiny in Wuchang, Hubei province. | Canada | http://trove.nla.gov.au/newspaper/page/24093580 | 24093580 | |
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 | |
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 | |
37302 | 37302 | 1921-07-09 | 3 | c | Mutiny in Hankou. | Canada | http://trove.nla.gov.au/newspaper/page/24093604 | 24093604 | |
37417 | 37417 | 1921-08-06 | 3 | d | The war between Greece and Turkey. | Canada | http://trove.nla.gov.au/newspaper/page/24093636 | 24093636 | |
37441 | 37441 | 1921-08-13 | 3 | c-d | Negotiation between American and Mexico on disarmament issues. | Canada | http://trove.nla.gov.au/newspaper/page/24093644 | 24093644 | |
37458 | 37458 | 1921-08-13 | 7 | c | Chinese government had recognised Washington Conference, international conference called by the United States to limit the naval arms race and to work out security agreements in the Pacific area. | Canada | http://trove.nla.gov.au/newspaper/page/24093648 | 24093648 | |
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 | |
37510 | 37510 | 1921-08-27 | 3 | c | Delegation from America and China to the Washington Conference. The Chinese delegation is headed by Foreign Minister Yan Huiqing. | Canada | http://trove.nla.gov.au/newspaper/page/24093662 | 24093662 | |
37512 | 37512 | 1921-08-27 | 3 | c-d | Chinese government sends a delegation of 100 to the Pacific disarmament conference. | Canada | http://trove.nla.gov.au/newspaper/page/24093662 | 24093662 | |
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 | |
37524 | 37524 | 1921-08-27 | 7 | b | American and British authorities on the peace in the Pacific region. | Canada | http://trove.nla.gov.au/newspaper/page/24093666 | 24093666 | |
37587 | 37587 | 1921-09-17 | 3 | c | Prime Minister of New Zealand William Ferguson Massey talks in Canada and supports the Anglo-Japanese alliance. | Canada | http://trove.nla.gov.au/newspaper/page/24093686 | 24093686 | |
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 | |
37812 | 37812 | 1921-11-05 | 3 | e | Chinese government to borrow some more money from American banks. | Canada | http://trove.nla.gov.au/newspaper/page/24093742 | 24093742 | |
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 | |
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 | |
37876 | 37876 | 1921-11-19 | 3 | e | American government and its Open Door policy in China. | Canada | http://trove.nla.gov.au/newspaper/page/24093758 | 24093758 | |
37903 | 37903 | 1921-11-26 | 3 | d-e | French delegation to the Washington Conference on the Far Eastern problems. | Canada | http://trove.nla.gov.au/newspaper/page/24093766 | 24093766 | |
38007 | 38007 | 1921-12-17 | 6 | a | Sun Yatsen has started his north expedition. | Canada | http://trove.nla.gov.au/newspaper/page/24093795 | 24093795 | |
38471 | 38471 | 1922-03-25 | 3 | e | Japan withdraws its troops from Shandong. | Canada | http://trove.nla.gov.au/newspaper/page/24093911 | 24093911 | |
38474 | 38474 | 1922-03-25 | 3 | e | Japan prepares to welcome Prince of Britain. | Canada | http://trove.nla.gov.au/newspaper/page/24093911 | 24093911 | |
38540 | 38540 | 1922-04-08 | 3 | e | American senate approves treaty signed with China. | Canada | http://trove.nla.gov.au/newspaper/page/24093927 | 24093927 | |
38549 | 38549 | 1922-04-08 | 7 | b | Textile workers are on strike in America. | Canada | http://trove.nla.gov.au/newspaper/page/24093931 | 24093931 | |
38572 | 38572 | 1922-04-15 | 3 | e | A bank robbery in New York. | Canada | http://trove.nla.gov.au/newspaper/page/24093935 | 24093935 | |
38678 | 38678 | 1922-05-06 | 3 | e | Zhang Zuolin leads his army to attack Beijing. | Canada | http://trove.nla.gov.au/newspaper/page/24093959 | 24093959 | |
38779 | 38779 | 1922-05-27 | 3 | f | Comments on Zhang Zuolin's independence declaration. | Canada | http://trove.nla.gov.au/newspaper/page/24093985 | 24093985 | |
38829 | 38829 | 1922-06-03 | 7 | c | Situation in Beijing and the war between Wu Peifu and Zhang Zuolin. | Canada | http://trove.nla.gov.au/newspaper/page/24093997 | 24093997 | |
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 | |
39056 | 39056 | 1922-11-25 | 3 | e | Hawaiian authority detains weapons that are smuggled to China. | Canada | http://trove.nla.gov.au/newspaper/page/24094195 | 24094195 | |
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 | |
39680 | 39680 | 1923-03-31 | 7 | b | Beijing people demand the abrogation of the Twenty-one Demands. | Canada | http://trove.nla.gov.au/newspaper/page/24094354 | 24094354 | |
39845 | 39845 | 1923-05-12 | 6 | c | Chinese government in Beijing wants to borrow loans from Britain, America, France and Japan. | Canada | http://trove.nla.gov.au/newspaper/page/24094404 | 24094404 | |
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 | |
40392 | 40392 | 1923-09-15 | 3 | e | Storm in Argentina. | Canada | http://trove.nla.gov.au/newspaper/page/24094543 | 24094543 | |
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 | |
40626 | 40626 | 1923-11-03 | 3 | e | Bank robbery in America. | Canada | http://trove.nla.gov.au/newspaper/page/24094599 | 24094599 | |
40827 | 40827 | 1923-12-22 | 3 | e-f | Earthquake in South America. | Canada | http://trove.nla.gov.au/newspaper/page/24094655 | 24094655 | |
40855 | 40855 | 1923-12-29 | 3 | c | Earthquake in Mexico. | Canada | http://trove.nla.gov.au/newspaper/page/24094663 | 24094663 | |
40874 | 40874 | 1923-12-29 | 7 | c-d | Canadian authority issues new regulations on Chinese immigration. | Canada | http://trove.nla.gov.au/newspaper/page/24094667 | 24094667 | |
40987 | 40987 | 1924-01-26 | 3 | e-f | Canadian trade commissioner to Japan requests his government to provide loans to the reconstruction in Tokyo. | Canada | http://trove.nla.gov.au/newspaper/page/24100581 | 24100581 | |
40999 | 40999 | 1924-01-26 | 7 | c | Canadian immigration authority bars Chinese businessman Xiao Yueting from returning to Vancouver. | Canada | http://trove.nla.gov.au/newspaper/page/24100585 | 24100585 | |
41262 | 41262 | 1924-03-15 | 3 | e | Earthquake in Canada and the casualties. | Canada | http://trove.nla.gov.au/newspaper/page/24100647 | 24100647 | |
41369 | 41369 | 1924-04-05 | 3 | e | A coal mine accident in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24100671 | 24100671 | |
41467 | 41467 | 1924-04-26 | 3 | e | American House of Representatives formally approves to ban Japanese immigrant. | Canada | http://trove.nla.gov.au/newspaper/page/24100695 | 24100695 | |
41669 | 41669 | 1924-06-07 | 6 | d-e | Chinese communities in Vancouver (Chinese Chamber of Commerce, Chinese Society, zhi gong tang, Constitutional Party and others) welcome Luo Chang, new Chinese consul-general. | Canada | http://trove.nla.gov.au/newspaper/page/24100749 | 24100749 | |
41697 | 41697 | 1924-06-14 | 3 | e | Canadian customs authority confirms that Spanish consul is interviewed for wine smuggling. | Canada | http://trove.nla.gov.au/newspaper/page/24100752 | 24100752 | |
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 | |
41950 | 41950 | 1924-08-16 | 3 | e | Two hundred Chinese gamblers in Canada are detained by the police. | Canada | http://trove.nla.gov.au/newspaper/page/24100824 | 24100824 | |
42313 | 42313 | 1924-11-15 | 3 | e | Turmoil in China reduces the ginseng production. | Canada | http://trove.nla.gov.au/newspaper/page/24100928 | 24100928 | |
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 | |
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 | |
42915 | 42915 | 1925-03-28 | 3 | e | Flood in Peru. | Canada | http://trove.nla.gov.au/newspaper/page/24101077 | 24101077 | |
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 | |
42965 | 42965 | 1925-04-04 | 7 | c | Bandits hijack a train in Chicago. | Canada | http://trove.nla.gov.au/newspaper/page/24101089 | 24101089 | |
43026 | 43026 | 1925-04-18 | 5 | c | Further report on the earthquake in Mexico. | Canada | http://trove.nla.gov.au/newspaper/page/24101103 | 24101103 | |
43139 | 43139 | 1925-05-09 | 5 | b | Anti-Chinese movement in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24101127 | 24101127 | |
43181 | 43181 | 1925-05-16 | 5 | b | An explosion outside of Pittsburgh, United States, claims eight lives. | Canada | http://trove.nla.gov.au/newspaper/page/24101135 | 24101135 | |
43225 | 43225 | 1925-05-23 | 5 | b | A submarine cable to be built from Victoria state to Suva, Fiji. | Canada | http://trove.nla.gov.au/newspaper/page/24101143 | 24101143 | |
43258 | 43258 | 1925-05-30 | 5 | a | A rich man in America lives together with a widow and is shot dead by her daughter. | Canada | http://trove.nla.gov.au/newspaper/page/24101151 | 24101151 | |
43601 | 43601 | 1925-08-08 | 5 | a | Fire in Havana and the damages. | Canada | http://trove.nla.gov.au/newspaper/page/24101235 | 24101235 | |
43732 | 43732 | 1925-08-29 | 6 | b | Chinese sailors on aboard of British ships are on strike in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24101262 | 24101262 | |
43843 | 43843 | 1925-09-19 | 5 | b | Timber burned to ashes in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24101283 | 24101283 | |
44726 | 44726 | 1926-05-15 | 5 | a | Riots in Central American countries. | Canada | http://trove.nla.gov.au/newspaper/page/24101559 | 24101559 | |
44780 | 44780 | 1926-05-29 | 5 | a | Revolution in Nicaragua. | Canada | http://trove.nla.gov.au/newspaper/page/24101575 | 24101575 | |
45263 | 45263 | 1926-10-30 | 5 | c | Storm in Havana and the damages. | Canada | http://trove.nla.gov.au/newspaper/page/24101761 | 24101761 | |
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 | |
45824 | 45824 | 1927-06-18 | 5 | c | Demonstration at the front of American consulate in Vancouver. | Canada | http://trove.nla.gov.au/newspaper/page/24102028 | 24102028 | |
46232 | 46232 | 1927-09-24 | 9 | a-d | Guangdong news/ Agricultural authority handles some cases. Commercial chamber and the land tax. Chinese navy and the pirates. Jiang Jieshi has secured many new recruits for his army. Editors of Popular Weekly (min zhong zhou kan) was wanted by the provincial authority. Profit reduced of the Guangzhou-Hankou railway. Government offices are forced to move out ordinary residence. Japanese warships arrives Wuzhou, Guangxi. Insects eat crops in Nanxiong county. Bandits in Dongguan, Zhongshan, and Heshan county. | Canada | |||
46324 | 46324 | 1927-10-22 | 2 | e | Feng Yuxiang removes Jin Yunpeng. | Canada | http://trove.nla.gov.au/newspaper/page/24098568 | 24098568 | |
46851 | 46851 | 1928-03-17 | 7 | a | A passenger ship is stranded in Boston. | Canada | http://trove.nla.gov.au/newspaper/page/24098731 | 24098731 | |
46878 | 46878 | 1928-03-24 | 7 | a | Parliament of the British Columbia in Canada to restrict the entry of Chinese and Japanese immigrants. | Canada | http://trove.nla.gov.au/newspaper/page/24098739 | 24098739 | |
47524 | 47524 | 1928-10-20 | 8 | a | Romanian authority deport Hungarian workers. | Canada | http://trove.nla.gov.au/newspaper/page/24098992 | 24098992 |
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]);