This data as json, CSV (advanced)
Link | rowid | date | page | column ▼ | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
23203 | 23203 | 1910-07-23 | 6 | a | Chinese graduates from Columbia University and University of North California, including Chen Huanzhang and Chen Huabing. | America | http://trove.nla.gov.au/newspaper/page/26802710 | 26802710 | |
24152 | 24152 | 1911-01-14 | 3 | a | Japan and the Philippines | According to a Filipino surveyor, Japan is intended to take over Manila before 1915 when it starts a war with America. | America | http://trove.nla.gov.au/newspaper/page/24091596 | 24091596 |
24332 | 24332 | 1911-02-18 | 3 | a | The US pays attention to China's famine | The US pays attention to China's famine and sends food and others to China. | America | http://trove.nla.gov.au/newspaper/page/24091669 | 24091669 |
24384 | 24384 | 1911-03-04 | 3 | a | America strictly bans opium | America forfeited illegal opium mostly from Canada and Mexico and announced it strictly bans opium. | America | http://trove.nla.gov.au/newspaper/page/24091685 | 24091685 |
24506 | 24506 | 1911-05-13 | 3 | a | Strikes in America | Several strikes happened in America. | America | http://trove.nla.gov.au/newspaper/page/24091769 | 24091769 |
24543 | 24543 | 1911-05-20 | 3 | a | Call for revising entry ban on Chinese | Chinese business association call for American government to revise its entry ban on Chinese. | America | http://trove.nla.gov.au/newspaper/page/24091779 | 24091779 |
24581 | 24581 | 1911-05-29 | 3 | a | Hot weather in America | Hot weather in America resulted in loss of many people's lives. | America | ||
24678 | 24678 | 1911-07-08 | 3 | a | Earthquake in America | Earthquake happened in America but no casualties and damages. | America | http://trove.nla.gov.au/newspaper/page/24091834 | 24091834 |
24698 | 24698 | 1911-07-15 | 3 | a | Hot weather in America | Several people died from hot weather in America. | America | http://trove.nla.gov.au/newspaper/page/24091842 | 24091842 |
24848 | 24848 | 1911-08-19 | 3 | a | Relationship between America and Japan | Japanese general is well entertained during his American trip. | America | http://trove.nla.gov.au/newspaper/page/24091882 | 24091882 |
24885 | 24885 | 1911-08-26 | 3 | a | Britain-America treaty | Steps need to be taken to the establishment of the Britain-America treaty. | America | http://trove.nla.gov.au/newspaper/page/24091890 | 24091890 |
24954 | 24954 | 1911-09-09 | 3 | a | Japanese general returns home | Dong Xiang, the Japanese general returns to Japan after visiting Europe and America. | America | http://trove.nla.gov.au/newspaper/page/24091907 | 24091907 |
24955 | 24955 | 1911-09-09 | 3 | a | Election of American president | Candidates from different parties are competing for the position of president. | America | http://trove.nla.gov.au/newspaper/page/24091907 | 24091907 |
24991 | 24991 | 1911-09-16 | 3 | a | China asks for compensation | China sends envoy to deal with Mexico's government about the compensation of the killing of Chinese there. | America | http://trove.nla.gov.au/newspaper/page/24091920 | 24091920 |
25059 | 25059 | 1911-09-30 | 3 | a | Japanese spy | A Japanese diplomat might be a spy. | America | http://trove.nla.gov.au/newspaper/page/24091937 | 24091937 |
25459 | 25459 | 1911-12-23 | 3 | a | Britain and Germany are to fight each other | A British senator says in New York that a war will occur between Britain and Germany. | America | http://trove.nla.gov.au/newspaper/page/24092042 | 24092042 |
25646 | 25646 | 1912-01-27 | 3 | a | Demand for recognition | The Republic of China demands recognition from America , who awaits for other big powers's views. | America | http://trove.nla.gov.au/newspaper/page/24092082 | 24092082 |
25710 | 25710 | 1912-02-10 | 3 | a | Japan and America | America tries to block Japan's request for concession in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24092098 | 24092098 |
26004 | 26004 | 1912-04-13 | 3 | a | Floods in America | Huge flooding occurs in Mid-America, resulted in casulties. | America | http://trove.nla.gov.au/newspaper/page/24092199 | 24092199 |
26006 | 26006 | 1912-04-13 | 3 | a | Mexican government is strong in its words | Mexican government replies sharply to America who asks whether Japan has asked to lease Mexican land. | America | http://trove.nla.gov.au/newspaper/page/24092199 | 24092199 |
26034 | 26034 | 1912-04-20 | 3 | a | Former American president dies | Former American president and army chief during south-north war died. | America | http://trove.nla.gov.au/newspaper/page/24092207 | 24092207 |
26181 | 26181 | 1912-05-25 | 3 | a | American Gold Lake floods | A flood happened in Gold Lake area in America, resulting in casulties. | America | http://trove.nla.gov.au/newspaper/page/24092247 | 24092247 |
26245 | 26245 | 1912-06-08 | 3 | a | Death by fire penalty on a black rapist | A black man in America was penalised for death by fire due to his raping an infant girl. | America | http://trove.nla.gov.au/newspaper/page/24092263 | 24092263 |
26249 | 26249 | 1912-06-08 | 3 | a | Electric vehicles contest | An electric vehicles contest was held in Indiana. | America | http://trove.nla.gov.au/newspaper/page/24092263 | 24092263 |
26288 | 26288 | 1912-06-15 | 3 | a | Riots in Cuba | Black riots attack American sugar factories in Cuba. America intends to send more troops there. | America | http://trove.nla.gov.au/newspaper/page/24092271 | 24092271 |
26539 | 26539 | 1912-08-10 | 3 | a | Two boys accidently burn a man dead. | America | http://trove.nla.gov.au/newspaper/page/24092335 | 24092335 | |
26657 | 26657 | 1912-08-31 | 3 | a | Smuggling drugs in postage found in Honolulu. | America | http://trove.nla.gov.au/newspaper/page/24092359 | 24092359 | |
26697 | 26697 | 1912-09-07 | 3 | a | American woman intends to assassinate American president. | America | http://trove.nla.gov.au/newspaper/page/24092367 | 24092367 | |
27197 | 27197 | 1913-03-29 | 3 | a | American Bank cancels loans to China due to American government's disapproval. America discusses recognition of Republic China. | America | http://trove.nla.gov.au/newspaper/page/24092624 | 24092624 | |
27258 | 27258 | 1913-04-12 | 3 | a | American president recognises Republic China and urges other nations to do so. | America | http://trove.nla.gov.au/newspaper/page/24092640 | 24092640 | |
27295 | 27295 | 1913-04-19 | 3 | a | America postpones recognition of Republic China. | America | http://trove.nla.gov.au/newspaper/page/24092648 | 24092648 | |
27298 | 27298 | 1913-04-19 | 3 | a | America joins competition of adding warships. | America | http://trove.nla.gov.au/newspaper/page/24092648 | 24092648 | |
27520 | 27520 | 1913-06-28 | 3 | a | Heat wave swallows Chicago and some people die to the hot weather. | America | http://trove.nla.gov.au/newspaper/page/24092728 | 24092728 | |
27586 | 27586 | 1913-07-12 | 3 | a | Heat wave sweeps New York. | America | http://trove.nla.gov.au/newspaper/page/24092744 | 24092744 | |
27738 | 27738 | 1913-08-16 | 3 | a | Anti-Japanese movement in America and the motives. | America | http://trove.nla.gov.au/newspaper/page/24092784 | 24092784 | |
27739 | 27739 | 1913-08-16 | 3 | a | President of Mexico refuses to accept American envoy. | America | http://trove.nla.gov.au/newspaper/page/24092784 | 24092784 | |
27742 | 27742 | 1913-08-16 | 3 | a | Six illegal Chinese immigrants are detained by American customs. | America | http://trove.nla.gov.au/newspaper/page/24092784 | 24092784 | |
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 | |
28007 | 28007 | 1913-10-18 | 3 | a | American government has decided to build more warships. | America | http://trove.nla.gov.au/newspaper/page/24092856 | 24092856 | |
28065 | 28065 | 1913-11-01 | 3 | a | Marriage and divorce in America and the study. | America | http://trove.nla.gov.au/newspaper/page/24092872 | 24092872 | |
28231 | 28231 | 1913-12-06 | 3 | a | Train in America uses radio communication. | America | http://trove.nla.gov.au/newspaper/page/24092912 | 24092912 | |
28383 | 28383 | 1914-01-10 | 3 | a | American government accepts refugees from Mexico. | America | http://trove.nla.gov.au/newspaper/page/24092952 | 24092952 | |
28628 | 28628 | 1914-03-28 | 3 | a | People from Mexico rush to the border of the United States of America. | America | http://trove.nla.gov.au/newspaper/page/24093053 | 24093053 | |
28685 | 28685 | 1914-04-11 | 3 | a | American parliament once again to ban Indian immigrants. | America | http://trove.nla.gov.au/newspaper/page/24093069 | 24093069 | |
28686 | 28686 | 1914-04-11 | 3 | a | American President Woodrow Wilson on the immigration policy. | America | http://trove.nla.gov.au/newspaper/page/24093069 | 24093069 | |
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 | |
29347 | 29347 | 1914-10-31 | 3 | a | American newspaper comments on the neutrality of China in the World War I. | America | http://trove.nla.gov.au/newspaper/page/24093303 | 24093303 | |
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 | |
29745 | 29745 | 1915-03-13 | 3 | a | American president's current policies on domestic and foreign affairs. | America | http://trove.nla.gov.au/newspaper/page/24094768 | 24094768 | |
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 | |
30743 | 30743 | 1915-11-27 | 3 | a | Dr Li Jia Bai, an American, comments on China's restoring imperial system and predicts that it will bring disaster to China. | America | http://trove.nla.gov.au/newspaper/page/24095066 | 24095066 | |
30849 | 30849 | 1915-12-25 | 3 | a | Overseas Chinese in Boston, America, oppose imperial system in China. | America | http://trove.nla.gov.au/newspaper/page/24095101 | 24095101 | |
31478 | 31478 | 1916-08-12 | 6 | a | A New York newspaper reports China's foreign debt. New York Times reports financial chaos in China. | America | http://trove.nla.gov.au/newspaper/page/24095369 | 24095369 | |
33507 | 33507 | 1918-08-10 | 6 | a | Chinese descendant in America joins the army and fight in France. | America | http://trove.nla.gov.au/newspaper/page/24097392 | 24097392 | |
34100 | 34100 | 1919-02-08 | 11 | a | American people survey the railways in China and their report. | America | http://trove.nla.gov.au/newspaper/page/24097606 | 24097606 | |
34371 | 34371 | 1919-04-12 | 3 | a | American President Wilson on the importance of the League of Nations. | America | http://trove.nla.gov.au/newspaper/page/24097677 | 24097677 | |
34879 | 34879 | 1919-09-13 | 3 | a | Chinese community in San Diego writes to American senator on the Shandong issues. | America | http://trove.nla.gov.au/newspaper/page/24097859 | 24097859 | |
35044 | 35044 | 1919-11-08 | 6 | a | Russian troops arrive in Manchuria. | America | http://trove.nla.gov.au/newspaper/page/24097930 | 24097930 | |
35047 | 35047 | 1919-11-08 | 6 | a | China borrows loans from American bank. Chinese government in deficit. | America | http://trove.nla.gov.au/newspaper/page/24097930 | 24097930 | |
35072 | 35072 | 1919-11-22 | 6 | a | Japan's policy in Korea. | America | http://trove.nla.gov.au/newspaper/page/24097948 | 24097948 | |
35073 | 35073 | 1919-11-22 | 6 | a | Epidemic in Turkey. | America | http://trove.nla.gov.au/newspaper/page/24097948 | 24097948 | |
35074 | 35074 | 1919-11-22 | 6 | a | Proposal in America to lend loans to the Chinese government. | America | http://trove.nla.gov.au/newspaper/page/24097948 | 24097948 | |
35075 | 35075 | 1919-11-22 | 6 | a | American senators have different opinion with President Wilson on the Shandong issues. | America | http://trove.nla.gov.au/newspaper/page/24097948 | 24097948 | |
35087 | 35087 | 1919-11-29 | 6 | a | Yan sheng gong, descent of Confucius, dies in Shandong. | America | http://trove.nla.gov.au/newspaper/page/24097956 | 24097956 | |
35088 | 35088 | 1919-11-29 | 6 | a | Number of American troops. | America | http://trove.nla.gov.au/newspaper/page/24097956 | 24097956 | |
35089 | 35089 | 1919-11-29 | 6 | a | Jin Yunpeng to organise new cabinet as the Chinese premier. | America | http://trove.nla.gov.au/newspaper/page/24097956 | 24097956 | |
35107 | 35107 | 1919-12-06 | 6 | a | Former Japanese ambassador to Washington on the Shandong issues. | America | http://trove.nla.gov.au/newspaper/page/24097964 | 24097964 | |
35109 | 35109 | 1919-12-06 | 6 | a | Bolshevik Party in Japan and Korea. | America | http://trove.nla.gov.au/newspaper/page/24097964 | 24097964 | |
35110 | 35110 | 1919-12-06 | 6 | a | Commander-in-chief of The Allies on the proposed League of Nations. | America | http://trove.nla.gov.au/newspaper/page/24097964 | 24097964 | |
35136 | 35136 | 1919-12-13 | 6 | a | Treaties between America and Japan over the Far East Asian issues. | America | http://trove.nla.gov.au/newspaper/page/24097972 | 24097972 | |
35157 | 35157 | 1919-12-20 | 6 | a | America expands navy. | America | http://trove.nla.gov.au/newspaper/page/24097980 | 24097980 | |
35159 | 35159 | 1919-12-20 | 6 | a | China's effort to borrow foreign loans. | America | http://trove.nla.gov.au/newspaper/page/24097980 | 24097980 | |
35160 | 35160 | 1919-12-20 | 6 | a | Revenue of the railway in China. | America | http://trove.nla.gov.au/newspaper/page/24097980 | 24097980 | |
35182 | 35182 | 1919-12-27 | 6 | a | China cuts military budget. | America | http://trove.nla.gov.au/newspaper/page/24097988 | 24097988 | |
35205 | 35205 | 1920-01-03 | 6 | a | Japanese cabinet to ask Chinese authority to stop anti-Japanese movement throughout China. | America | http://trove.nla.gov.au/newspaper/page/24097996 | 24097996 | |
35267 | 35267 | 1920-01-24 | 6 | a | China and Japan to start talks on the return of Qingdao. | America | http://trove.nla.gov.au/newspaper/page/24098020 | 24098020 | |
35268 | 35268 | 1920-01-24 | 6 | a | Secret diplomacy between Japan and Mexico. | America | http://trove.nla.gov.au/newspaper/page/24098020 | 24098020 | |
35282 | 35282 | 1920-01-31 | 6 | a | The effect of Chinese boycott to Japanese goods. | America | http://trove.nla.gov.au/newspaper/page/24098028 | 24098028 | |
35307 | 35307 | 1920-02-07 | 6 | a | Chinese government will not talk directly with Japan over the Shandong issues. | America | http://trove.nla.gov.au/newspaper/page/24098036 | 24098036 | |
35327 | 35327 | 1920-02-14 | 6 | a | American naval warships. | America | http://trove.nla.gov.au/newspaper/page/24098044 | 24098044 | |
35328 | 35328 | 1920-02-14 | 6 | a | Strike in Hawaii. | America | http://trove.nla.gov.au/newspaper/page/24098044 | 24098044 | |
35329 | 35329 | 1920-02-14 | 6 | a | Boycott to American goods in Canada. | America | http://trove.nla.gov.au/newspaper/page/24098044 | 24098044 | |
36528 | 36528 | 1921-01-22 | 3 | a | Japanese blocks Russian transportation in Siberia. | America | http://trove.nla.gov.au/newspaper/page/24093401 | 24093401 | |
36792 | 36792 | 1921-04-02 | 3 | a | An American parliamentarian predicts a war in the future between the yellow and the white peoples. | America | http://trove.nla.gov.au/newspaper/page/24093492 | 24093492 | |
37974 | 37974 | 1921-12-10 | 6 | a | The Far Eastern affairs at the Washington Conference. | America | http://trove.nla.gov.au/newspaper/page/24093787 | 24093787 | |
37975 | 37975 | 1921-12-10 | 6 | a | Japanese want to invade Manchuria. | America | http://trove.nla.gov.au/newspaper/page/24093787 | 24093787 | |
38009 | 38009 | 1921-12-17 | 6 | a | The United States, Great Britain, Japan, and France sign Four-Power Pact on Pacific question. | America | http://trove.nla.gov.au/newspaper/page/24093795 | 24093795 | |
38255 | 38255 | 1922-02-11 | 3 | a | British delegates oppose to discuss the Twenty-one Demands. | America | http://trove.nla.gov.au/newspaper/page/24093863 | 24093863 | |
38256 | 38256 | 1922-02-11 | 3 | a | Russia and China may unite to resist Japanese invasion. | America | http://trove.nla.gov.au/newspaper/page/24093863 | 24093863 | |
38300 | 38300 | 1922-02-18 | 6 | a | First part of a translation on race and colour of the human beings. | America | http://trove.nla.gov.au/newspaper/page/24093876 | 24093876 | |
38396 | 38396 | 1922-03-11 | 3 | a | Japanese delegation to the Washington Conference successfully blocks the discussion on Siberian issues. | America | http://trove.nla.gov.au/newspaper/page/24093895 | 24093895 | |
38564 | 38564 | 1922-04-15 | 3 | a | Chinese delegate to the Washington Conference on the solution to Chinese problem. Foreign adviser of Chinese government on the Washington Conference. | America | http://trove.nla.gov.au/newspaper/page/24093935 | 24093935 | |
38565 | 38565 | 1922-04-15 | 3 | a | China and Japan sign a treaty to solve the Shandong problem. | America | http://trove.nla.gov.au/newspaper/page/24093935 | 24093935 | |
38584 | 38584 | 1922-04-15 | 7 | a | Japan starts to withdraw its troops from Shandong. | America | http://trove.nla.gov.au/newspaper/page/24093939 | 24093939 | |
39187 | 39187 | 1922-12-23 | 7 | a | A ban robber in America. | America | http://trove.nla.gov.au/newspaper/page/24094231 | 24094231 | |
39260 | 39260 | 1923-01-13 | 3 | a | A notice issued by the Chinese consulate in Mexico on the Chinese immigration to Mexico, family reunion, new application for business or study in Mexico and other matters. | America | http://trove.nla.gov.au/newspaper/page/24094251 | 24094251 | |
39823 | 39823 | 1923-05-05 | 7 | a | An employee of the British-American Tobacco Company is kidnapped by bandits in Guangdong. | America | http://trove.nla.gov.au/newspaper/page/24094395 | 24094395 | |
39825 | 39825 | 1923-05-05 | 7 | a | American consuls in Harbin and Chita are returning. | America | http://trove.nla.gov.au/newspaper/page/24094395 | 24094395 |
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]);