This data as json, CSV (advanced)
Suggested facets: column, title, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
19005 | 19005 | 1908-03-07 | 8 | a-b | First part of the foreword to the Chinese newspaper xin bao, official paper of the Chinese Empire Reform Association in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/26801660 | 26801660 | |
19045 | 19045 | 1908-03-14 | 8 | a-b | Second and final part of the foreword to the Chinese newspaper xin bao, official organ of the Chinese Empire Reform Association in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/26801668 | 26801668 | |
22582 | 22582 | 1910-03-26 | 8 | a-b | An open letter from Chinese Empire Reform Association in Canada regarding Zhenhua company and the murder of Liu Shiji. | Canada | http://trove.nla.gov.au/newspaper/page/26802575 | 26802575 | |
22583 | 22583 | 1910-03-26 | 8 | c | An letter from Deng Gui, of Vancouver, Canada, on Ou Jujia and and his crimes. | Canada | http://trove.nla.gov.au/newspaper/page/26802575 | 26802575 | |
24141 | 24141 | 1911-01-07 | 8 | c | The National anti-opium organisation | The National anti-opium organisation urged to ban opium trade. | Canada | http://trove.nla.gov.au/newspaper/page/24091595 | 24091595 |
24643 | 24643 | 1911-06-10 | 8 | c | New regulations on Chinese labourers by Canadian Government | More tax and other strict regulations issued by the Canadian government on Chinese labourers. | Canada | http://trove.nla.gov.au/newspaper/page/24091809 | 24091809 |
25155 | 25155 | 1911-10-14 | 8 | b | Celebrating the triumph of Huai Re newpaper | Huai Re newspaper won the triumph in criticising Sun Yatsen's revolutionary newspaper in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24091964 | 24091964 |
28145 | 28145 | 1913-11-15 | 8 | a | First part of a report on the Chinese in Canada and their sufferings. | Canada | http://trove.nla.gov.au/newspaper/page/24092895 | 24092895 | |
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 | |
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 | |
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 | |
47524 | 47524 | 1928-10-20 | 8 | a | Romanian authority deport Hungarian workers. | Canada | http://trove.nla.gov.au/newspaper/page/24098992 | 24098992 | |
47958 | 47958 | 1929-03-30 | 8 | b | Guangdong dispatches troops to Jiangxi. | Canada | http://trove.nla.gov.au/newspaper/page/24099168 | 24099168 | |
48209 | 48209 | 1929-06-15 | 8 | a | Water shortage in Hong Kong. | Canada | http://trove.nla.gov.au/newspaper/page/24099254 | 24099254 | |
48487 | 48487 | 1929-09-21 | 8 | d | A plane accident in America. | Canada | http://trove.nla.gov.au/newspaper/page/24099371 | 24099371 | |
48507 | 48507 | 1929-09-28 | 8 | c | Russian immigrants are detained in Vancouver, Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24099379 | 24099379 | |
48871 | 48871 | 1930-02-08 | 8 | c | The Nanjing government abrogates the agreement with America on aviation cooperation. Jiang Jieshi is on the way to Guangdong to personally command the army. | Canada | http://trove.nla.gov.au/newspaper/page/24099525 | 24099525 | |
49045 | 49045 | 1930-04-05 | 8 | e | The unemployment in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24099591 | 24099591 | |
49424 | 49424 | 1930-08-16 | 8 | c | Insect pest in Canada and the affect upon agricultural harvest. | Canada | http://trove.nla.gov.au/newspaper/page/24099744 | 24099744 | |
49610 | 49610 | 1930-10-18 | 8 | e | Canadian authority may increase tariff rate. | Canada | http://trove.nla.gov.au/newspaper/page/24099819 | 24099819 | |
49628 | 49628 | 1930-10-25 | 8 | c | Brazil banks transport case to Britain and America. | Canada | http://trove.nla.gov.au/newspaper/page/24099828 | 24099828 | |
49980 | 49980 | 1931-02-07 | 8 | b | Number of unemployed people in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24090270 | 24090270 | |
50002 | 50002 | 1931-02-14 | 8 | b | Sale of Australian wheat in China. | Canada | http://trove.nla.gov.au/newspaper/page/24090278 | 24090278 | |
50046 | 50046 | 1931-02-28 | 8 | b | An old couple in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24090298 | 24090298 | |
50169 | 50169 | 1931-04-04 | 8 | b | Cold weather in America and Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24090338 | 24090338 | |
50191 | 50191 | 1931-04-11 | 8 | b | Chinese government may stop import of foreign wheat. | Canada | http://trove.nla.gov.au/newspaper/page/24090346 | 24090346 | |
50329 | 50329 | 1931-05-23 | 8 | b | Australian flour sells well in the Chinese market. | Canada | http://trove.nla.gov.au/newspaper/page/24090395 | 24090395 | |
50435 | 50435 | 1931-06-20 | 8 | d | British ship finds new island. | Canada | http://trove.nla.gov.au/newspaper/page/24090427 | 24090427 | |
50527 | 50527 | 1931-07-18 | 8 | b | Canadian government subsidises the farmers. | Canada | http://trove.nla.gov.au/newspaper/page/24090459 | 24090459 | |
50666 | 50666 | 1931-08-29 | 8 | c | More disasters strike Hankou, China. | Canada | http://trove.nla.gov.au/newspaper/page/24090509 | 24090509 | |
50705 | 50705 | 1931-09-12 | 8 | b | Mexico deports Chinese. | Canada | http://trove.nla.gov.au/newspaper/page/24090525 | 24090525 | |
50959 | 50959 | 1931-12-12 | 8 | b | Clash between police and civilians in Peru. | Canada | http://trove.nla.gov.au/newspaper/page/24090635 | 24090635 | |
51137 | 51137 | 1932-01-30 | 8 | b | Canadian authority prohibits Chinese immigrants from employing white people. | Canada | http://trove.nla.gov.au/newspaper/page/24090684 | 24090684 | |
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 | |
51237 | 51237 | 1932-02-27 | 8 | A | Canadian pilots seek to serve China and the report. | Canada | http://trove.nla.gov.au/newspaper/page/24090718 | 24090718 | |
51266 | 51266 | 1932-03-05 | 8 | a | America and Canada to organise an air force troops to aid China. | Canada | http://trove.nla.gov.au/newspaper/page/24090726 | 24090726 | |
51503 | 51503 | 1932-05-07 | 8 | a | Police in Canada arrest communist activists. | Canada | http://trove.nla.gov.au/newspaper/page/24090798 | 24090798 | |
51608 | 51608 | 1932-06-11 | 8 | a | Earthquake in Mexico. | Canada | http://trove.nla.gov.au/newspaper/page/24090838 | 24090838 | |
51609 | 51609 | 1932-06-11 | 8 | b | Coup in Chile. | Canada | http://trove.nla.gov.au/newspaper/page/24090838 | 24090838 | |
52167 | 52167 | 1932-11-05 | 8 | e | Provincial governments of Canada to sell wheat to China. | Canada | http://trove.nla.gov.au/newspaper/page/24091014 | 24091014 | |
52200 | 52200 | 1932-11-12 | 8 | c | Election to be held in America. | Canada | http://trove.nla.gov.au/newspaper/page/24091021 | 24091021 | |
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 | |
55110 | 55110 | 1935-05-11 | 8 | c | Canada refuses Japanese goods. | Canada | http://trove.nla.gov.au/newspaper/page/24096431 | 24096431 | |
55128 | 55128 | 1935-05-18 | 8 | a | Japan boycotts to Canadian goods. | Canada | http://trove.nla.gov.au/newspaper/page/24096439 | 24096439 | |
55298 | 55298 | 1935-07-27 | 8 | c | Australian Prime Minister Lyon visits Canada and an accident. | Canada | http://trove.nla.gov.au/newspaper/page/24096519 | 24096519 |
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]);