This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
15890 | 15890 | 1906-07-07 | 5 | b | An article, published in Pittsburgh Chronicle Telegraph, about stories of Huang Kuanzhuo, a businessman and member of the Chinese Empire Reform Association in Mexico who is enthusiastic in the community and in association affairs. | America | http://trove.nla.gov.au/newspaper/page/26801027 | 26801027 | |
15945 | 15945 | 1906-07-21 | 5 | a | First part of questions and answers, selected from a Chinese newspaper (wei xin bao) in New York, about establishment and operation of the Mexico Bank, the official bank of the Chinese Empire Reform Association. | America | http://trove.nla.gov.au/newspaper/page/26801036 | 26801036 | |
15975 | 15975 | 1906-07-28 | 5 | a-b | Report selected from a New York Chinese newspaper (wei xin bao) on the establishment of Mexico bank, official bank of the Chinese Empire Reform Association. Share floating and special shares. Preparation and future operation. | America | http://trove.nla.gov.au/newspaper/page/26801042 | 26801042 | |
16004 | 16004 | 1906-08-04 | 5 | a | Second part of the questions and answers, selected from a Chinese newspaper (wei xin bao) in New York, about establishment and operation of the Mexico Bank, the official bank of the Chinese Empire Reform Association. | America | http://trove.nla.gov.au/newspaper/page/26801048 | 26801048 | |
16030 | 16030 | 1906-08-11 | 5 | a-b | Third part of questions and answers, selected from a Chinese newspaper (wei xin bao) in New York, on the establishment and operation of the Mexico Bank, the official bank of the Chinese Empire Reform Association. | America | http://trove.nla.gov.au/newspaper/page/26801054 | 26801054 | |
16071 | 16071 | 1906-08-18 | 5 | a | Fourth and final part of the questions and answers, selected from a Chinese newspaper (wei xin bao) in New York, about establishment and operation of the Mexico Bank, the official bank of the Chinese Empire Reform Association. | America | http://trove.nla.gov.au/newspaper/page/26801060 | 26801060 | |
42985 | 42985 | 1925-04-11 | 5 | b | Police in New York, Chicago and San Francisco collaborate in their pursuit of criminals. | America | http://trove.nla.gov.au/newspaper/page/24101095 | 24101095 | |
42988 | 42988 | 1925-04-11 | 5 | c | Robbery and theft in Chicago and other places of America. | America | http://trove.nla.gov.au/newspaper/page/24101095 | 24101095 | |
43031 | 43031 | 1925-04-18 | 5 | c | Textile industry in America. | America | http://trove.nla.gov.au/newspaper/page/24101103 | 24101103 | |
43060 | 43060 | 1925-04-25 | 5 | a-b | American customs authority detains a British ship for wine smuggling. | America | http://trove.nla.gov.au/newspaper/page/24101111 | 24101111 | |
43066 | 43066 | 1925-04-25 | 5 | c | Secret talks between Russia and Japan. | America | http://trove.nla.gov.au/newspaper/page/24101111 | 24101111 | |
43099 | 43099 | 1925-05-02 | 5 | b | American government dispatches naval vessels to protect their people in Honduras. | America | http://trove.nla.gov.au/newspaper/page/24101119 | 24101119 | |
43100 | 43100 | 1925-05-02 | 5 | b | A Japanese cargo ship sinks in the north Atlanta. | America | http://trove.nla.gov.au/newspaper/page/24101119 | 24101119 | |
43143 | 43143 | 1925-05-09 | 5 | b | New York authority takes precautions against communist propaganda. | America | http://trove.nla.gov.au/newspaper/page/24101127 | 24101127 | |
43262 | 43262 | 1925-05-30 | 5 | b | An express ship in America. | America | http://trove.nla.gov.au/newspaper/page/24101151 | 24101151 | |
43455 | 43455 | 1925-07-11 | 5 | c | American naval fleet comets to visit Australia. | America | http://trove.nla.gov.au/newspaper/page/24101201 | 24101201 | |
43498 | 43498 | 1925-07-18 | 5 | c | American president Calvin Coolidge to organise an international conference on the Far East issues. | America | http://trove.nla.gov.au/newspaper/page/24101209 | 24101209 | |
43531 | 43531 | 1925-07-25 | 5 | c | Robbery in New York. | America | http://trove.nla.gov.au/newspaper/page/24101217 | 24101217 | |
43533 | 43533 | 1925-07-25 | 5 | c | American government recommends to discuss the extraterritoriality in China. | America | http://trove.nla.gov.au/newspaper/page/24101217 | 24101217 | |
43571 | 43571 | 1925-08-01 | 5 | c | Britain, America and Japan and their China policy. | America | http://trove.nla.gov.au/newspaper/page/24101227 | 24101227 | |
43574 | 43574 | 1925-08-01 | 5 | c | American government and their China policy. | America | http://trove.nla.gov.au/newspaper/page/24101227 | 24101227 | |
43603 | 43603 | 1925-08-08 | 5 | a | American president Calvin Coolidge proposes further disarmament. | America | http://trove.nla.gov.au/newspaper/page/24101235 | 24101235 | |
43605 | 43605 | 1925-08-08 | 5 | b | American president Calvin Coolidge writes to the governor-general of Australia for their Asia policy. | America | http://trove.nla.gov.au/newspaper/page/24101235 | 24101235 | |
43607 | 43607 | 1925-08-08 | 5 | b | Bandits in Chicago rob a hotel. | America | http://trove.nla.gov.au/newspaper/page/24101235 | 24101235 | |
43645 | 43645 | 1925-08-15 | 5 | c | An international conference to be held in Beijing on the revision of Chinese tariff. | America | http://trove.nla.gov.au/newspaper/page/24101243 | 24101243 | |
43646 | 43646 | 1925-08-15 | 5 | c | Coal miners in Atlantic city, America, prepares for a strike. | America | http://trove.nla.gov.au/newspaper/page/24101243 | 24101243 | |
43763 | 43763 | 1925-09-05 | 5 | c | American government to send representative to the tariff conference in China. | America | http://trove.nla.gov.au/newspaper/page/24101267 | 24101267 | |
43844 | 43844 | 1925-09-19 | 5 | b | Police in New York orders Chinese communities to stop fighting and arrest some. | America | http://trove.nla.gov.au/newspaper/page/24101283 | 24101283 | |
43846 | 43846 | 1925-09-19 | 5 | c | Population increases sharply in America from 1870 to 1920. | America | http://trove.nla.gov.au/newspaper/page/24101283 | 24101283 | |
43883 | 43883 | 1925-09-26 | 5 | b | American authorities try to stop the fighting among Chinese communities. | America | http://trove.nla.gov.au/newspaper/page/24101291 | 24101291 | |
43884 | 43884 | 1925-09-26 | 5 | c | Tobacco consumption in America. | America | http://trove.nla.gov.au/newspaper/page/24101291 | 24101291 | |
43889 | 43889 | 1925-09-26 | 5 | c | Signs for chaos in China. | America | http://trove.nla.gov.au/newspaper/page/24101291 | 24101291 | |
43958 | 43958 | 1925-10-10 | 5 | a | Chinese consul in New York mediates the fighting among Chinese communities. Australian trade commissioner to Washington talks about business. | America | http://trove.nla.gov.au/newspaper/page/24101307 | 24101307 | |
43962 | 43962 | 1925-10-10 | 5 | b | France and America dispute over the debt repayment. | America | http://trove.nla.gov.au/newspaper/page/24101307 | 24101307 | |
43994 | 43994 | 1925-10-17 | 5 | b | British representatives attend labour conference in Atlantic City, America. | America | http://trove.nla.gov.au/newspaper/page/24101315 | 24101315 | |
43998 | 43998 | 1925-10-17 | 5 | c | Labour Party in America opposes to any change of restriction on Japanese immigrant. | America | http://trove.nla.gov.au/newspaper/page/24101315 | 24101315 | |
44027 | 44027 | 1925-10-24 | 5 | c | American on the coming tariff conference in Beijing. | America | http://trove.nla.gov.au/newspaper/page/24101323 | 24101323 | |
44083 | 44083 | 1925-11-07 | 5 | a | A passenger train derails in America. | America | http://trove.nla.gov.au/newspaper/page/24101341 | 24101341 | |
44084 | 44084 | 1925-11-07 | 5 | a | A bank robbery in America. | America | http://trove.nla.gov.au/newspaper/page/24101341 | 24101341 | |
44115 | 44115 | 1925-11-14 | 5 | a | Disaccord between America and Italy over the debt repayment. | America | http://trove.nla.gov.au/newspaper/page/24101350 | 24101350 | |
44145 | 44145 | 1925-11-21 | 5 | a | British immigrants to America. | America | http://trove.nla.gov.au/newspaper/page/24101358 | 24101358 | |
44147 | 44147 | 1925-11-21 | 5 | a | Two trains collide in heavy fog in New York and 13 passengers died. | America | http://trove.nla.gov.au/newspaper/page/24101358 | 24101358 | |
44156 | 44156 | 1925-11-21 | 5 | c | American Secretary of State speaks to the League of Nations. | America | http://trove.nla.gov.au/newspaper/page/24101358 | 24101358 | |
44178 | 44178 | 1925-11-28 | 5 | a | A dockyard in New Orlean, United States of America, is set alight. | America | http://trove.nla.gov.au/newspaper/page/24101366 | 24101366 | |
44180 | 44180 | 1925-11-28 | 5 | a | Italian government seeks for loans from America to deal with internal financial crisis. | America | http://trove.nla.gov.au/newspaper/page/24101366 | 24101366 | |
44205 | 44205 | 1925-12-05 | 5 | a | Robberies in the United States of America. | America | http://trove.nla.gov.au/newspaper/page/24101374 | 24101374 | |
44213 | 44213 | 1925-12-05 | 5 | c | American customs officers detain illegal Chinese immigrants who hide in coffin on arrival of Hawaii. | America | http://trove.nla.gov.au/newspaper/page/24101374 | 24101374 | |
44238 | 44238 | 1925-12-12 | 5 | a | Robbery in New York. | America | http://trove.nla.gov.au/newspaper/page/24101384 | 24101384 | |
44240 | 44240 | 1925-12-12 | 5 | a-b | America will cooperate with the League of Nations for disarmament. | America | http://trove.nla.gov.au/newspaper/page/24101384 | 24101384 | |
44268 | 44268 | 1925-12-19 | 5 | a | Homicide case in Pittsburgh, United States. | America | http://trove.nla.gov.au/newspaper/page/24101392 | 24101392 | |
44419 | 44419 | 1926-02-13 | 5 | c | Heavy snow in New York. | America | http://trove.nla.gov.au/newspaper/page/24101456 | 24101456 | |
44480 | 44480 | 1926-03-06 | 5 | b | Tax cut in America. | America | http://trove.nla.gov.au/newspaper/page/24101479 | 24101479 | |
44530 | 44530 | 1926-03-20 | 5 | c | Japan dispatches gunboats to Dagu, near Tianjin. | America | http://trove.nla.gov.au/newspaper/page/24101495 | 24101495 | |
44549 | 44549 | 1926-03-27 | 5 | a | American naval fleet on the way to China. | America | http://trove.nla.gov.au/newspaper/page/24101503 | 24101503 | |
44600 | 44600 | 1926-04-10 | 5 | c | A theatre collapses in Mexico during performance. | America | http://trove.nla.gov.au/newspaper/page/24101519 | 24101519 | |
44601 | 44601 | 1926-04-10 | 5 | c | China may have a big war. | America | http://trove.nla.gov.au/newspaper/page/24101519 | 24101519 | |
44671 | 44671 | 1926-05-01 | 5 | a | New immigration regulations in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24101543 | 24101543 | |
44831 | 44831 | 1926-06-12 | 5 | b | Fire in San Francisco. | America | http://trove.nla.gov.au/newspaper/page/24101591 | 24101591 | |
44908 | 44908 | 1926-07-03 | 5 | b | Floods in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24101617 | 24101617 | |
45002 | 45002 | 1926-07-31 | 5 | a | Heat waves in America. | America | http://trove.nla.gov.au/newspaper/page/24101649 | 24101649 | |
45101 | 45101 | 1926-08-28 | 5 | a | Revolution in Nicaragua. | America | http://trove.nla.gov.au/newspaper/page/24101681 | 24101681 | |
45103 | 45103 | 1926-08-28 | 5 | b | American government to abolish the extraterritoriality in China. | America | http://trove.nla.gov.au/newspaper/page/24101681 | 24101681 | |
45180 | 45180 | 1926-09-25 | 5 | c | Storm in America. | America | http://trove.nla.gov.au/newspaper/page/24101721 | 24101721 | |
45696 | 45696 | 1927-05-07 | 5 | c | Floods in the United States of America. | America | http://trove.nla.gov.au/newspaper/page/24101975 | 24101975 | |
46045 | 46045 | 1927-08-13 | 5 | b | Governor-General of the Philippines dies. | America | http://trove.nla.gov.au/newspaper/page/24098489 | 24098489 | |
46074 | 46074 | 1927-08-20 | 5 | a | Riots in Bolivia, South America. | America | http://trove.nla.gov.au/newspaper/page/24098497 | 24098497 | |
46216 | 46216 | 1927-09-24 | 5 | a | Heat waves in America. | America | http://trove.nla.gov.au/newspaper/page/24098537 | 24098537 | |
46244 | 46244 | 1927-10-01 | 5 | a | Bandits in Nicaragua. | America | http://trove.nla.gov.au/newspaper/page/24098545 | 24098545 | |
46287 | 46287 | 1927-10-08 | 5 | c | Hurricane in St Louis, America. | America | http://trove.nla.gov.au/newspaper/page/24098553 | 24098553 | |
46307 | 46307 | 1927-10-15 | 5 | b | Leader of rebellions is arrested in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24098561 | 24098561 | |
46462 | 46462 | 1927-11-19 | 5 | c | Gas explosion in Pittsburgh, America. | America | http://trove.nla.gov.au/newspaper/page/24098601 | 24098601 | |
46483 | 46483 | 1927-11-26 | 5 | b | Mobil company makes huge profit. | America | http://trove.nla.gov.au/newspaper/page/24098609 | 24098609 | |
46512 | 46512 | 1927-12-03 | 5 | a-b | Loans sought in America for the railway construction in south Manchuria, and the oppositions. | America | http://trove.nla.gov.au/newspaper/page/24098617 | 24098617 | |
46514 | 46514 | 1927-12-03 | 5 | b | Prisoners in San Francisco on riots. | America | http://trove.nla.gov.au/newspaper/page/24098617 | 24098617 | |
46551 | 46551 | 1927-12-10 | 5 | c | Rich woman in America sells her ear. | America | http://trove.nla.gov.au/newspaper/page/24098625 | 24098625 | |
46572 | 46572 | 1927-12-17 | 5 | b | New Ford cars manufactured. | America | http://trove.nla.gov.au/newspaper/page/24098633 | 24098633 | |
46646 | 46646 | 1928-01-07 | 5 | b | Bandits rob a bank in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24098657 | 24098657 | |
46665 | 46665 | 1928-01-14 | 5 | a | Cold winter in America. | America | http://trove.nla.gov.au/newspaper/page/24098665 | 24098665 | |
46731 | 46731 | 1928-02-11 | 5 | a | Suicides in New York and the report. | America | http://trove.nla.gov.au/newspaper/page/24098689 | 24098689 | |
46738 | 46738 | 1928-02-11 | 5 | c | New treaty signed between America and France. | America | http://trove.nla.gov.au/newspaper/page/24098689 | 24098689 | |
48165 | 48165 | 1929-06-01 | 5 | d | American government provides loans to Soviet Russia. | America | http://trove.nla.gov.au/newspaper/page/24099233 | 24099233 | |
50324 | 50324 | 1931-05-23 | 5 | c | Number of divorce declines in America. | America | http://trove.nla.gov.au/newspaper/page/24090390 | 24090390 | |
50881 | 50881 | 1931-11-14 | 5 | a | The Chinese Society (zhong hua hui guan) in San Francisco issues a circular telegram which requests to abolish the Party control of administration. | America | http://trove.nla.gov.au/newspaper/page/24090592 | 24090592 | |
50909 | 50909 | 1931-11-28 | 5 | e | Open telegram issued by the Chinese Constitutionalist Party in America. | America | http://trove.nla.gov.au/newspaper/page/24090614 | 24090614 | |
51155 | 51155 | 1932-02-06 | 5 | a | American government closely watching Japanese in Shanghai. | America | http://trove.nla.gov.au/newspaper/page/24090689 | 24090689 | |
51156 | 51156 | 1932-02-06 | 5 | a | American parliamentarians suggest to break off economic relations with Japan. | America | http://trove.nla.gov.au/newspaper/page/24090689 | 24090689 | |
51160 | 51160 | 1932-02-06 | 5 | b | American government dispatches warships to Shanghai. | America | http://trove.nla.gov.au/newspaper/page/24090689 | 24090689 | |
51358 | 51358 | 1932-04-02 | 5 | a | American Secretary of State on the war in Shanghai. | America | http://trove.nla.gov.au/newspaper/page/24090753 | 24090753 | |
52191 | 52191 | 1932-11-12 | 5 | e | The Chinese communities in the United States of America organise memorial gathering for the martyrs killed during the resistance to Japanese invasion of Shanghai and selection of the couplets. | America | http://trove.nla.gov.au/newspaper/page/24091017 | 24091017 | |
52216 | 52216 | 1932-11-19 | 5 | d | The Chinese communities in the United States of America organise memorial gathering for the martyrs killed during the resistance to Japanese invasion of Shanghai and selection of the couplets. | America | http://trove.nla.gov.au/newspaper/page/24091026 | 24091026 | |
52249 | 52249 | 1932-11-26 | 5 | b | The Chinese communities in the United States of America organise memorial gathering for the martyrs killed during the resistance to Japanese invasion of Shanghai and selection of the couplets. | America | http://trove.nla.gov.au/newspaper/page/24091033 | 24091033 | |
52278 | 52278 | 1932-12-03 | 5 | b | The Chinese communities in the United States of America organise memorial gathering for the martyrs killed during the resistance to Japanese invasion of Shanghai and selection of the couplets. | America | http://trove.nla.gov.au/newspaper/page/24091041 | 24091041 | |
52303 | 52303 | 1932-12-10 | 5 | c | The Chinese communities in the United States of America organise memorial gathering for the martyrs killed during the resistance to Japanese invasion of Shanghai and selection of the couplets. | America | http://trove.nla.gov.au/newspaper/page/24091049 | 24091049 | |
52337 | 52337 | 1932-12-17 | 5 | b | The Chinese communities in the United States of America organise memorial gathering for the martyrs killed during the resistance to Japanese invasion of Shanghai and selection of the couplets. | America | http://trove.nla.gov.au/newspaper/page/24091059 | 24091059 | |
52468 | 52468 | 1933-01-28 | 5 | b | A woman in Chicago sleeps for nine months. | America | http://trove.nla.gov.au/newspaper/page/24091099 | 24091099 | |
53031 | 53031 | 1933-07-01 | 5 | a | First part of a report on the territories China has ceded in the past 50 years. | America | http://trove.nla.gov.au/newspaper/page/24091279 | 24091279 | |
53057 | 53057 | 1933-07-08 | 5 | b | Second part of a report on the territories China has ceded in the past 50 years. | America | http://trove.nla.gov.au/newspaper/page/24091287 | 24091287 | |
53058 | 53058 | 1933-07-08 | 5 | d | Wine bath in New York. | America | http://trove.nla.gov.au/newspaper/page/24091287 | 24091287 | |
53422 | 53422 | 1933-10-21 | 5 | a | Medical progress in Soviet Russia. | America | http://trove.nla.gov.au/newspaper/page/24091407 | 24091407 | |
53888 | 53888 | 1934-02-24 | 5 | a | Prose by Liang Chaojie on the birthday of his mother. | America | http://trove.nla.gov.au/newspaper/page/24091542 | 24091542 |
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]);