This data as json, CSV (advanced)
Suggested facets: column, title, date (date)
Link | rowid | date | page | column ▼ | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22581 | 22581 | 1910-03-26 | 8 | a | An open letter from Chinese Empire Reform Association in St Louise, America, regarding Zhenhua company and the murder of Liu Shiji. | America | http://trove.nla.gov.au/newspaper/page/26802575 | 26802575 | |
27773 | 27773 | 1913-08-23 | 8 | a | Governor of New York refuses to resign on embezzlement. | America | http://trove.nla.gov.au/newspaper/page/24092799 | 24092799 | |
29222 | 29222 | 1914-09-05 | 8 | a | American immigration authority maltreats Chinese delegation who are on their way to the Panama Exhibition, and the report. | America | http://trove.nla.gov.au/newspaper/page/24093242 | 24093242 | |
29415 | 29415 | 1914-11-21 | 8 | a | American people on the arbitration treaty between China and the United States. | America | http://trove.nla.gov.au/newspaper/page/24093336 | 24093336 | |
29560 | 29560 | 1915-01-09 | 8 | a | St Francisco Constitutional Party organises New World Airship Company, which is to provide airships for China. | America | http://trove.nla.gov.au/newspaper/page/24094686 | 24094686 | |
30031 | 30031 | 1915-05-08 | 8 | a | Chinese miserable experience in Mid-America. | America | http://trove.nla.gov.au/newspaper/page/24094839 | 24094839 | |
30032 | 30032 | 1915-05-08 | 8 | a | Record of Panama Canal Sports Contest. | America | http://trove.nla.gov.au/newspaper/page/24094839 | 24094839 | |
47104 | 47104 | 1928-06-02 | 8 | a | Gas explosion in America and the tragedy. | America | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
47173 | 47173 | 1928-06-23 | 8 | a | Export of gold coins from the United States of America. | America | http://trove.nla.gov.au/newspaper/page/24098856 | 24098856 | |
47305 | 47305 | 1928-08-04 | 8 | a | Bandits rob shops in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24098904 | 24098904 | |
47368 | 47368 | 1928-08-25 | 8 | a | American government on the recent negotiation between China and Japan. | America | http://trove.nla.gov.au/newspaper/page/24098928 | 24098928 | |
47391 | 47391 | 1928-09-01 | 8 | a | Traffic accident in a tunnel in America and the casualties. | America | http://trove.nla.gov.au/newspaper/page/24098936 | 24098936 | |
47465 | 47465 | 1928-09-29 | 8 | a | Bandits in Hawaii. | America | http://trove.nla.gov.au/newspaper/page/24098968 | 24098968 | |
47474 | 47474 | 1928-10-06 | 8 | a | American scholar on the current situations in Manchuria. | America | http://trove.nla.gov.au/newspaper/page/24098976 | 24098976 | |
47494 | 47494 | 1928-10-13 | 8 | a | New York customs officers seize opium from a ship. | America | http://trove.nla.gov.au/newspaper/page/24098984 | 24098984 | |
47575 | 47575 | 1928-11-10 | 8 | a | Presidential election in America and the betting. | America | http://trove.nla.gov.au/newspaper/page/24099016 | 24099016 | |
47593 | 47593 | 1928-11-17 | 8 | a | A ship sinks near New York. | America | http://trove.nla.gov.au/newspaper/page/24099024 | 24099024 | |
47612 | 47612 | 1928-11-24 | 8 | a | American authority detains Communist activists and the report. | America | http://trove.nla.gov.au/newspaper/page/24099032 | 24099032 | |
47614 | 47614 | 1928-11-24 | 8 | a | Floods in America. | America | http://trove.nla.gov.au/newspaper/page/24099032 | 24099032 | |
47659 | 47659 | 1928-12-08 | 8 | a | Earthquake in Chile. | America | http://trove.nla.gov.au/newspaper/page/24099048 | 24099048 | |
47694 | 47694 | 1928-12-22 | 8 | a | Chaos in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24099064 | 24099064 | |
47697 | 47697 | 1928-12-22 | 8 | a | Tobacco import of China and the competition. | America | http://trove.nla.gov.au/newspaper/page/24099064 | 24099064 | |
47747 | 47747 | 1929-01-12 | 8 | a | Epidemic disease in America and the casualties. | America | http://trove.nla.gov.au/newspaper/page/24099088 | 24099088 | |
47879 | 47879 | 1929-03-09 | 8 | a | Bandits and robberies in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24099144 | 24099144 | |
47903 | 47903 | 1929-03-16 | 8 | a | More chaos in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24099152 | 24099152 | |
47929 | 47929 | 1929-03-23 | 8 | a | Floods in America. | America | http://trove.nla.gov.au/newspaper/page/24099160 | 24099160 | |
48009 | 48009 | 1929-04-13 | 8 | a | American businessmen on the development of aviation industry in China. | America | http://trove.nla.gov.au/newspaper/page/24099184 | 24099184 | |
48269 | 48269 | 1929-07-06 | 8 | a | Amount of loans from America. | America | http://trove.nla.gov.au/newspaper/page/24099278 | 24099278 | |
49951 | 49951 | 1931-01-31 | 8 | a | Many poor people in America need help. | America | http://trove.nla.gov.au/newspaper/page/24090262 | 24090262 | |
50023 | 50023 | 1931-02-21 | 8 | a | Unemployed people have demonstrations in America. | America | http://trove.nla.gov.au/newspaper/page/24090290 | 24090290 | |
50043 | 50043 | 1931-02-28 | 8 | a | American senate on the economic recession. | America | http://trove.nla.gov.au/newspaper/page/24090298 | 24090298 | |
50044 | 50044 | 1931-02-28 | 8 | a | Chinese communities in American on the loans to the Chinese government. | America | http://trove.nla.gov.au/newspaper/page/24090298 | 24090298 | |
50763 | 50763 | 1931-10-03 | 8 | a | Japanese ambassador in Washington denies any invasion of Manchuria. | America | http://trove.nla.gov.au/newspaper/page/24090549 | 24090549 | |
51082 | 51082 | 1932-01-16 | 8 | a | American president on the international treaties and Japanese invasion of Manchuria. American government on the Japanese invasion of China. | America | http://trove.nla.gov.au/newspaper/page/24090668 | 24090668 | |
51134 | 51134 | 1932-01-30 | 8 | a | Presidential election in America. | America | http://trove.nla.gov.au/newspaper/page/24090684 | 24090684 | |
51135 | 51135 | 1932-01-30 | 8 | a | America will not stop Japanese invasion of China. | America | http://trove.nla.gov.au/newspaper/page/24090684 | 24090684 | |
51308 | 51308 | 1932-03-19 | 8 | a | Anti-Japanese demonstration in America. | America | http://trove.nla.gov.au/newspaper/page/24090742 | 24090742 | |
51606 | 51606 | 1932-06-11 | 8 | a | American government increase tax rates. | America | http://trove.nla.gov.au/newspaper/page/24090838 | 24090838 | |
51669 | 51669 | 1932-07-02 | 8 | a | More banks bankrupt in America. | America | http://trove.nla.gov.au/newspaper/page/24090862 | 24090862 | |
51694 | 51694 | 1932-07-09 | 8 | a | Britain, France and Japan disagree to the disarmament proposal put forward by the American president. | America | http://trove.nla.gov.au/newspaper/page/24090870 | 24090870 | |
51737 | 51737 | 1932-07-23 | 8 | a | Retired servicemen on demonstration in America. | America | http://trove.nla.gov.au/newspaper/page/24090886 | 24090886 | |
51780 | 51780 | 1932-08-06 | 8 | a | Martial law proclaimed in Washington. | America | http://trove.nla.gov.au/newspaper/page/24090902 | 24090902 | |
52220 | 52220 | 1932-11-19 | 8 | a | Result of the election in America. | America | http://trove.nla.gov.au/newspaper/page/24091030 | 24091030 | |
52473 | 52473 | 1933-01-28 | 8 | a | American President Roosevelt and his foreign policy. | America | http://trove.nla.gov.au/newspaper/page/24091104 | 24091104 | |
55017 | 55017 | 1935-04-13 | 8 | a | The life of Soviet Russian people. | America | http://trove.nla.gov.au/newspaper/page/24096397 | 24096397 | |
55057 | 55057 | 1935-04-27 | 8 | a | Sandstorm in America. | America | http://trove.nla.gov.au/newspaper/page/24096412 | 24096412 | |
55146 | 55146 | 1935-05-25 | 8 | a | Freight service between China and America. | America | http://trove.nla.gov.au/newspaper/page/24096447 | 24096447 | |
55260 | 55260 | 1935-07-13 | 8 | a | Independence celebration in America. | America | http://trove.nla.gov.au/newspaper/page/24096502 | 24096502 | |
55334 | 55334 | 1935-08-10 | 8 | a | A robbery in New York. | America | http://trove.nla.gov.au/newspaper/page/24096535 | 24096535 | |
55376 | 55376 | 1935-08-24 | 8 | a | American people look down upon the Emperor of Japan. | America | http://trove.nla.gov.au/newspaper/page/24096551 | 24096551 | |
55456 | 55456 | 1935-09-21 | 8 | a | American customs imposes heavy tax on German products. | America | http://trove.nla.gov.au/newspaper/page/24096585 | 24096585 | |
55491 | 55491 | 1935-10-05 | 8 | a | Coal miners on strike in America. | America | http://trove.nla.gov.au/newspaper/page/24096601 | 24096601 | |
55626 | 55626 | 1935-11-30 | 8 | a | American government has approved the independence of the Philippines. | America | http://trove.nla.gov.au/newspaper/page/24096666 | 24096666 | |
55945 | 55945 | 1936-04-04 | 8 | a | Floods in America. | America | http://trove.nla.gov.au/newspaper/page/24096806 | 24096806 | |
56106 | 56106 | 1936-07-25 | 8 | a | A prediction on the war in the Pacific region. | America | http://trove.nla.gov.au/newspaper/page/24096936 | 24096936 | |
56107 | 56107 | 1936-07-25 | 8 | a | Military expense of the American government. | America | http://trove.nla.gov.au/newspaper/page/24096936 | 24096936 | |
18637 | 18637 | 1907-12-14 | 8 | a-b | First part of a report, prepared by Chen Huanzhang, on celebrations organised by Chinese communities in New York on the birthday of Confucius. | America | http://trove.nla.gov.au/newspaper/page/26801578 | 26801578 | |
18675 | 18675 | 1907-12-21 | 8 | a-b | Second part of a report, prepared by Chen Huanzhang, on celebrations organised by Chinese communities in New York on the birthday of Confucius. | America | http://trove.nla.gov.au/newspaper/page/26801586 | 26801586 | |
18707 | 18707 | 1907-12-28 | 8 | a-b | Third and final part of the report, prepared by Chen Huanzhang, on celebrations organised by Chinese communities in New York on the birthday of Confucius. | America | http://trove.nla.gov.au/newspaper/page/26801594 | 26801594 | |
19188 | 19188 | 1908-04-11 | 8 | a-b | American secretary of industry and commerce reports to the parliament. The report covers issues such as Chinese immigration, trade statistics between China and America, and number of Chinese immigrants in the United States. | America | http://trove.nla.gov.au/newspaper/page/26801700 | 26801700 | |
22704 | 22704 | 1910-04-23 | 8 | a-b | Governor-General of Guangdong and Guangxi province Yuan Shuxun responds to the case of Liu Shiji. Zhenhua shareholders in America denounce Ou Jujia. | America | http://trove.nla.gov.au/newspaper/page/26802605 | 26802605 | |
22825 | 22825 | 1910-05-14 | 8 | a-b | First part of a report on the truth about Zhenhua company's fundraising and the sale of floating shares in America, report by Liang Chaojie. | America | http://trove.nla.gov.au/newspaper/page/26802631 | 26802631 | |
22854 | 22854 | 1910-05-21 | 8 | a-b | Second part of the report on the truth about Zhenhua company's fundraising and the sale of floating shares in America, report by Liang Chaojie. | America | http://trove.nla.gov.au/newspaper/page/26802639 | 26802639 | |
22888 | 22888 | 1910-05-28 | 8 | a-b | Third part of the report on the truth about Zhenhua company's fundraising and the sale of floating shares in America, report by Liang Chaojie. | America | http://trove.nla.gov.au/newspaper/page/26802648 | 26802648 | |
22927 | 22927 | 1910-06-04 | 8 | a-b | Fourth part of the report on the truth about Zhenhua company's fundraising and the sale of floating shares in America, report by Liang Chaojie. | America | http://trove.nla.gov.au/newspaper/page/26802656 | 26802656 | |
23251 | 23251 | 1910-07-30 | 8 | a-b | A report submitted by the Chinese Empire Reform Association in Chicago via Prince Zai Tao. | America | http://trove.nla.gov.au/newspaper/page/26802720 | 26802720 | |
29289 | 29289 | 1914-10-03 | 8 | a-b | Chinese Masonic Society (hong men) in San Francisco refuses to cooperate with Sun Yatsen for his Third Revolution. American expert on the revolutionary movement in China. | America | http://trove.nla.gov.au/newspaper/page/24093276 | 24093276 | |
34342 | 34342 | 1919-03-29 | 8 | a-b | The assassination of Huang Ding, Chinese education supervisor in Washington, and the police investigation. | America | http://trove.nla.gov.au/newspaper/page/24097668 | 24097668 | |
22889 | 22889 | 1910-05-28 | 8 | b | Fights and assassinations in the Chinese communities in New York and Philadelphia. | America | http://trove.nla.gov.au/newspaper/page/26802648 | 26802648 | |
22967 | 22967 | 1910-06-11 | 8 | b | Fifth and final part of the report on the truth about Zhenhua company's fundraising and the sale of floating shares in America, report by Liang Chaojie. | America | http://trove.nla.gov.au/newspaper/page/26802664 | 26802664 | |
27781 | 27781 | 1913-08-23 | 8 | b | Chaos in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24092799 | 24092799 | |
29136 | 29136 | 1914-08-01 | 8 | b | A Chinese businessman is detained in the United States of America and wins his case in the court. | America | http://trove.nla.gov.au/newspaper/page/24093202 | 24093202 | |
29629 | 29629 | 1915-01-23 | 8 | b | China Associations in America are against Chinese government's plan of making loans from American capitalists. | America | http://trove.nla.gov.au/newspaper/page/24094702 | 24094702 | |
30111 | 30111 | 1915-05-29 | 8 | b | News of Panama International Sports Contest. | America | http://trove.nla.gov.au/newspaper/page/24094862 | 24094862 | |
30112 | 30112 | 1915-05-29 | 8 | b | American Airship Company is to send Chen Xuda to China to open a pilot training school. | America | http://trove.nla.gov.au/newspaper/page/24094862 | 24094862 | |
47110 | 47110 | 1928-06-02 | 8 | b | Japan's attitude on the disarmament treaty. | America | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
47500 | 47500 | 1928-10-13 | 8 | b | Bandits in New York. | America | http://trove.nla.gov.au/newspaper/page/24098984 | 24098984 | |
47502 | 47502 | 1928-10-13 | 8 | b | Muslims in Gansu province, China, on riots and the report. | America | http://trove.nla.gov.au/newspaper/page/24098984 | 24098984 | |
47783 | 47783 | 1929-01-26 | 8 | b | A robbery in broad daylight in New York. | America | http://trove.nla.gov.au/newspaper/page/24099104 | 24099104 | |
48013 | 48013 | 1929-04-13 | 8 | b | Bandits in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24099184 | 24099184 | |
48301 | 48301 | 1929-07-20 | 8 | b | Investigation finds that many people are involved in the opium smuggling following the detainment of Chinese deputy-consul's wife in San Francisco. A further report on the investigation on the opium smuggling. | America | http://trove.nla.gov.au/newspaper/page/24099294 | 24099294 | |
49680 | 49680 | 1930-11-08 | 8 | b | Jiang Jieshi dispatches envoy to borrow loans from America. | America | http://trove.nla.gov.au/newspaper/page/24099843 | 24099843 | |
49728 | 49728 | 1930-11-22 | 8 | b | Foreigners injured in the labour disputes in Peru. | America | http://trove.nla.gov.au/newspaper/page/24099860 | 24099860 | |
49751 | 49751 | 1930-11-29 | 8 | b | Storm in Honolulu and the damages. | America | http://trove.nla.gov.au/newspaper/page/24099868 | 24099868 | |
49754 | 49754 | 1930-11-29 | 8 | b | British ambassador requests Peruvian government to protect foreigners during the chaos. | America | http://trove.nla.gov.au/newspaper/page/24099868 | 24099868 | |
49804 | 49804 | 1930-12-13 | 8 | b | Police in Washington fire tear bombs at the communist demonstrators. | America | http://trove.nla.gov.au/newspaper/page/24099884 | 24099884 | |
49821 | 49821 | 1930-12-20 | 8 | b | Another big bank in America goes bankruptcy. | America | http://trove.nla.gov.au/newspaper/page/24099892 | 24099892 | |
49910 | 49910 | 1931-01-17 | 8 | b | American President is optimistic for the future of employment. | America | http://trove.nla.gov.au/newspaper/page/24090246 | 24090246 | |
49912 | 49912 | 1931-01-17 | 8 | b | Silver price runs down sharply. | America | http://trove.nla.gov.au/newspaper/page/24090246 | 24090246 | |
49934 | 49934 | 1931-01-24 | 8 | b | American government has new policy against the communist movement. | America | http://trove.nla.gov.au/newspaper/page/24090254 | 24090254 | |
50025 | 50025 | 1931-02-21 | 8 | b | Mine owner in America commits suicide because of the economic recession. | America | http://trove.nla.gov.au/newspaper/page/24090290 | 24090290 | |
50076 | 50076 | 1931-03-07 | 8 | b | Police in Japan and America arrest communists. | America | http://trove.nla.gov.au/newspaper/page/24090306 | 24090306 | |
50118 | 50118 | 1931-03-21 | 8 | b | Jewellery shop in New York robbed. | America | http://trove.nla.gov.au/newspaper/page/24090321 | 24090321 | |
50122 | 50122 | 1931-03-21 | 8 | b | American people and their income. | America | http://trove.nla.gov.au/newspaper/page/24090321 | 24090321 | |
50143 | 50143 | 1931-03-28 | 8 | b | America has more storage of gold than any other countries. | America | http://trove.nla.gov.au/newspaper/page/24090331 | 24090331 | |
50171 | 50171 | 1931-04-04 | 8 | b | New South Wales of Australia refuses to repay interest of loans to Britain. | America | http://trove.nla.gov.au/newspaper/page/24090338 | 24090338 | |
50189 | 50189 | 1931-04-11 | 8 | b | Bandits and robberies in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24090346 | 24090346 | |
50190 | 50190 | 1931-04-11 | 8 | b | Earthquake in central America. | America | http://trove.nla.gov.au/newspaper/page/24090346 | 24090346 | |
50208 | 50208 | 1931-04-18 | 8 | b | Brother of Emperor of Japan escapes from an attack on his arrival in New York. | America | http://trove.nla.gov.au/newspaper/page/24090355 | 24090355 | |
50212 | 50212 | 1931-04-18 | 8 | b | Statistics on robberies and thefts in New York. | America | http://trove.nla.gov.au/newspaper/page/24090355 | 24090355 |
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]);