This data as json, CSV (advanced)
Link | rowid | date | page | column | title | description ▲ | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
36592 | 36592 | 1921-02-05 | 3 | c | Tokyo government keeps watch on American citizens in Japan. | America | http://trove.nla.gov.au/newspaper/page/24093417 | 24093417 | |
47697 | 47697 | 1928-12-22 | 8 | a | Tobacco import of China and the competition. | America | http://trove.nla.gov.au/newspaper/page/24099064 | 24099064 | |
43884 | 43884 | 1925-09-26 | 5 | c | Tobacco consumption in America. | America | http://trove.nla.gov.au/newspaper/page/24101291 | 24101291 | |
8133 | 8133 | 1901-07-13 | 2 | d | Timely rain after a long drought in America. | America | http://trove.nla.gov.au/newspaper/page/24100106 | 24100106 | |
7915 | 7915 | 1901-06-12 | 2 | e | Three robbers in America are on the run. | America | http://trove.nla.gov.au/newspaper/page/24100073 | 24100073 | |
54814 | 54814 | 1935-01-26 | 3 | a | Three priorities for the American government at the moment. | America | http://trove.nla.gov.au/newspaper/page/24096302 | 24096302 | |
34722 | 34722 | 1919-07-26 | 3 | e-f | Three patriotic men commit suicide in the front of Chinese President Xu Shichang. | America | http://trove.nla.gov.au/newspaper/page/24097801 | 24097801 | |
50436 | 50436 | 1931-06-20 | 8 | d | Three more banks are closed down in America. | America | http://trove.nla.gov.au/newspaper/page/24090427 | 24090427 | |
42272 | 42272 | 1924-11-01 | 7 | c | Three illegal Chinese immigrants are smuggled from Singapore into New York in a container and one of them is found dead on arrival. | America | http://trove.nla.gov.au/newspaper/page/24100916 | 24100916 | |
8394 | 8394 | 1901-08-24 | 2 | d-e | Three Chinese, Xu Shiqin, Xue Zhongying and Lu Jin'en, were detained on their arrival in San Francisco. The arrest was recommended by Chinese consul He You and Chinese ambassador Wu Tingfang. | America | http://trove.nla.gov.au/newspaper/page/24100144 | 24100144 | |
34877 | 34877 | 1919-09-13 | 2 | e-f | Three Chinese delegates to the Paris Peace Conference visit America and their talks there. | America | http://trove.nla.gov.au/newspaper/page/24097860 | 24097860 | |
50837 | 50837 | 1931-10-24 | 8 | c | Thomas Edison dies. | America | http://trove.nla.gov.au/newspaper/page/24090573 | 24090573 | |
34617 | 34617 | 1919-06-28 | 2 | c-d | Third part of the report written by American journalist that reveals Japan's conspiracy in China. | America | http://trove.nla.gov.au/newspaper/page/24097768 | 24097768 | |
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 | |
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 | |
12761 | 12761 | 1904-02-06 | 2 | a | Third part of Liang Qichao's article on boundaries of family clans and native regions, published in a San Francisco Chinese newspaper. | America | http://trove.nla.gov.au/newspaper/page/26800372 | 26800372 | |
47418 | 47418 | 1928-09-15 | 2 | b | Third and final part of the speech by Dr Chen Huanzhang in San Francisco on the quintessence of Confucianism. | America | http://trove.nla.gov.au/newspaper/page/24098946 | 24098946 | |
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 | |
18676 | 18676 | 1907-12-21 | 8 | c-d | Third and final part of the report on the fighting of Chinese community in San Francisco for equal educational opportunity between Chinese and other school children. | America | http://trove.nla.gov.au/newspaper/page/26801586 | 26801586 | |
49863 | 49863 | 1931-01-10 | 2 | e | The zhong hua gong suo (Chinese Society) mediates the conflicts of Chinese societies in the east of America. | America | http://trove.nla.gov.au/newspaper/page/24090232 | 24090232 | |
51347 | 51347 | 1932-04-02 | 2 | d | The zhi gong tang and the Constitutionalist Party (xian zheng dang) in San Francisco donate to the Chinese army for their resistance to Japanese invaders. | America | http://trove.nla.gov.au/newspaper/page/24090752 | 24090752 | |
45261 | 45261 | 1926-10-30 | 3 | f | The world chemistry conference in Philadelphia. | America | http://trove.nla.gov.au/newspaper/page/24101759 | 24101759 | |
36012 | 36012 | 1920-08-14 | 7 | b | The war in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24098272 | 24098272 | |
35960 | 35960 | 1920-07-31 | 3 | d | The war in Beijing ends. | America | http://trove.nla.gov.au/newspaper/page/24098252 | 24098252 | |
28781 | 28781 | 1914-05-02 | 3 | b | The war clouds between American and Mexico. | America | http://trove.nla.gov.au/newspaper/page/24093093 | 24093093 | |
35582 | 35582 | 1920-04-10 | 3 | c | The war between America and Germany ends. | America | http://trove.nla.gov.au/newspaper/page/24098116 | 24098116 | |
38262 | 38262 | 1922-02-11 | 3 | d | The treaty between Britain, America and Japan signed at the Washington Conference. | America | http://trove.nla.gov.au/newspaper/page/24093863 | 24093863 | |
56183 | 56183 | 1936-08-22 | 3 | c | The trade war between America and Germany. | America | http://trove.nla.gov.au/newspaper/page/24096961 | 24096961 | |
5671 | 5671 | 1900-07-14 | 2 | b | The third part of the report on Liang Qichao's visit to Honolulu, written by Tan Dou. | America | http://trove.nla.gov.au/newspaper/page/24102874 | 24102874 | |
20716 | 20716 | 1909-02-27 | 6 | b | The third international fishing conference in Washington. | America | http://trove.nla.gov.au/newspaper/page/26802096 | 26802096 | |
25296 | 25296 | 1911-11-18 | 6 | b | The shortest man in the world | The shortest man is in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24092006 | 24092006 |
5614 | 5614 | 1900-07-07 | 2 | c | The second part of the report on Liang Qichao's tour to Honolulu, written by Tan Dou. | America | http://trove.nla.gov.au/newspaper/page/24102866 | 24102866 | |
8766 | 8766 | 1901-10-09 | 2 | c | The second part of a letter, prepared by Huang Liang, Zhong Muxian and the Chinese Empire Reform Association in Honolulu, to Tao Mo, governor of Guangdong province. | America | http://trove.nla.gov.au/newspaper/page/24100189 | 24100189 | |
7620 | 7620 | 1901-05-08 | 2 | e | The second and final part of a report on Li Hongzhang's meeting with He Xiaosheng in Shanghai in order to seek his help. | America | http://trove.nla.gov.au/newspaper/page/24100031 | 24100031 | |
40467 | 40467 | 1923-09-29 | 6 | b-c | The sale of public property in Guangdong, an article published in the World News (shi jie ri bao) in San Francisco. | America | http://trove.nla.gov.au/newspaper/page/24094564 | 24094564 | |
35249 | 35249 | 1920-01-17 | 6 | b | The sale of Japanese products in American market. | America | http://trove.nla.gov.au/newspaper/page/24098012 | 24098012 | |
30805 | 30805 | 1915-12-11 | 3 | c | The riot papaty is to make toubles in Shanhai. | America | http://trove.nla.gov.au/newspaper/page/24095083 | 24095083 | |
35690 | 35690 | 1920-05-15 | 3 | d | The railway in Siberia and the relations between Japan and America. | America | http://trove.nla.gov.au/newspaper/page/24098158 | 24098158 | |
20373 | 20373 | 1908-12-12 | 6 | b | The project of Panama Canal. | America | http://trove.nla.gov.au/newspaper/page/26801984 | 26801984 | |
30251 | 30251 | 1915-07-10 | 2 | c-d | The process of Sino-Japan's negotiation. | America | http://trove.nla.gov.au/newspaper/page/24094905 | 24094905 | |
56211 | 56211 | 1936-08-29 | 3 | a | The power of American navy. | America | http://trove.nla.gov.au/newspaper/page/24096969 | 24096969 | |
34252 | 34252 | 1919-03-08 | 6 | c | The peace treaty to be signed by German delegates at the Paris conference. | America | http://trove.nla.gov.au/newspaper/page/24097642 | 24097642 | |
5346 | 5346 | 1900-05-30 | 2 | e | The organisation and activities of the Chinese Empire Reform Association in Honolulu. | America | http://trove.nla.gov.au/newspaper/page/24102820 | 24102820 | |
5947 | 5947 | 1900-08-29 | 2 | d | The oldest doctor in the USA. | America | http://trove.nla.gov.au/newspaper/page/24102927 | 24102927 | |
24745 | 24745 | 1911-07-22 | 6 | b | Less Chinese in America | The number of Chinese is reducing in America due to the introduction of entry restriction on Chinese. | America | http://trove.nla.gov.au/newspaper/page/24091855 | 24091855 |
41809 | 41809 | 1924-07-12 | 6 | b-d | The new restriction issued by American authority to the Chinese immigrant. | America | http://trove.nla.gov.au/newspaper/page/24100789 | 24100789 | |
36270 | 36270 | 1920-11-06 | 3 | e | The new military government in Guangdong and the peace talks in China. | America | http://trove.nla.gov.au/newspaper/page/24098368 | 24098368 | |
31383 | 31383 | 1916-07-08 | 3 | e | The negotiations between America and Mexico. American government to expand its naval forces. | America | http://trove.nla.gov.au/newspaper/page/24095323 | 24095323 | |
33743 | 33743 | 1918-10-19 | 6 | a-c | The murder and robbery in Xiangshan county, Guangdong. | America | http://trove.nla.gov.au/newspaper/page/24097474 | 24097474 | |
34058 | 34058 | 1919-02-01 | 3 | f | The management of the railway in Siberia. | America | http://trove.nla.gov.au/newspaper/page/24097590 | 24097590 | |
8559 | 8559 | 1901-09-18 | 2 | e | The man who shot American President, William McKinley, has been captured. | America | http://trove.nla.gov.au/newspaper/page/24100165 | 24100165 | |
8704 | 8704 | 1901-10-02 | 2 | e | The man who assassinated President William McKinley was on trial. | America | http://trove.nla.gov.au/newspaper/page/24100181 | 24100181 | |
8747 | 8747 | 1901-10-05 | 2 | f | The man who assassinated President McKinley was sentenced to death. | America | http://trove.nla.gov.au/newspaper/page/24100185 | 24100185 | |
8723 | 8723 | 1901-10-02 | 3 | c | The man who assassinated American President William McKinley was sentenced by the court. | America | http://trove.nla.gov.au/newspaper/page/24100180 | 24100180 | |
50580 | 50580 | 1931-08-01 | 8 | c | The longest road in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24090475 | 24090475 | |
55017 | 55017 | 1935-04-13 | 8 | a | The life of Soviet Russian people. | America | http://trove.nla.gov.au/newspaper/page/24096397 | 24096397 | |
46682 | 46682 | 1928-01-21 | 3 | b | The international radio conference in Washington, Japan's attitude towards Lushun and Dalian, and the comments by Chinese delegate Wang Jingchun. | America | http://trove.nla.gov.au/newspaper/page/24098671 | 24098671 | |
54135 | 54135 | 1934-05-12 | 3 | e | The independence of the Philippines from America. | America | http://trove.nla.gov.au/newspaper/page/24096009 | 24096009 | |
47910 | 47910 | 1929-03-23 | 2 | b | The future prospect of industry in China, article selected from an English newspaper in San Francisco. | America | http://trove.nla.gov.au/newspaper/page/24099154 | 24099154 | |
45413 | 45413 | 1927-01-08 | 3 | f | The future of trade between China and America. | America | http://trove.nla.gov.au/newspaper/page/24101839 | 24101839 | |
56453 | 56453 | 1936-11-28 | 3 | e | The future of business in China is pessimistic. | America | http://trove.nla.gov.au/newspaper/page/24097076 | 24097076 | |
35748 | 35748 | 1920-05-29 | 3 | d | The future of Chinese economy is not optimistic. | America | http://trove.nla.gov.au/newspaper/page/24098176 | 24098176 | |
5720 | 5720 | 1900-07-21 | 2 | c | The fourth part of the report on Liang Qichao's visit to Honolulu, written by Tan Dou. | America | http://trove.nla.gov.au/newspaper/page/24102882 | 24102882 | |
5694 | 5694 | 1900-07-18 | 2 | c-d | The fourth part of the report on Liang Qichao's visit to Honolulu, written by Secretary Tan Dou. | America | http://trove.nla.gov.au/newspaper/page/24102878 | 24102878 | |
24361 | 24361 | 1911-02-25 | 3 | b | News concerning Liang Dunyan | The former high-level official, Liang Songsheng, visited Havard. Liang Yonghu and Tang Guoan came with him. | America | http://trove.nla.gov.au/newspaper/page/24091677 | 24091677 |
30770 | 30770 | 1915-11-27 | 8 | b-c | The first transport ship of Chinese Postage and Shipping Company in San Francisco starts its service and attracts many overseas Chinese. | America | http://trove.nla.gov.au/newspaper/page/24095072 | 24095072 | |
5590 | 5590 | 1900-07-04 | 2 | b-c | The first part of a report on Liang Qichao's tour to Honolulu, written by Tan Dou. | America | http://trove.nla.gov.au/newspaper/page/24102862 | 24102862 | |
8738 | 8738 | 1901-10-05 | 2 | b-d | The first part of a letter, prepared by Huang Liang, Zhong Muxian and the Chinese Empire Reform Association in Honolulu, to Tao Mo, governor of Guangdong province. | America | http://trove.nla.gov.au/newspaper/page/24100185 | 24100185 | |
5738 | 5738 | 1900-07-25 | 2 | c-d | The fifth and final part of the report on Liang Qichao's visit to Honolulu, written by Tan Dou. | America | http://trove.nla.gov.au/newspaper/page/24102886 | 24102886 | |
34948 | 34948 | 1919-10-04 | 3 | c | The end of war between China and Germany. | America | http://trove.nla.gov.au/newspaper/page/24097883 | 24097883 | |
35213 | 35213 | 1920-01-03 | 6 | b | The end of the Emperor of Germany. | America | http://trove.nla.gov.au/newspaper/page/24097996 | 24097996 | |
33985 | 33985 | 1919-01-11 | 3 | c | The election in the United States of America. | America | http://trove.nla.gov.au/newspaper/page/24097566 | 24097566 | |
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 | |
37362 | 37362 | 1921-07-23 | 3 | c | The disarmament proposal by American government and the response from Japan and China. | America | http://trove.nla.gov.au/newspaper/page/24093620 | 24093620 | |
12291 | 12291 | 1903-10-03 | 3 | a | The daughter of President Roosevelt attends a function with a black girl. | America | http://trove.nla.gov.au/newspaper/page/26800300 | 26800300 | |
54134 | 54134 | 1934-05-12 | 3 | d | The communist activists in American navy. | America | http://trove.nla.gov.au/newspaper/page/24096009 | 24096009 | |
36250 | 36250 | 1920-10-30 | 3 | d | The change of Japan's foreign policy. | America | http://trove.nla.gov.au/newspaper/page/24098360 | 24098360 | |
56444 | 56444 | 1936-11-21 | 8 | e | The bridge project in San Francisco is completed. | America | http://trove.nla.gov.au/newspaper/page/24097073 | 24097073 | |
45386 | 45386 | 1926-12-25 | 3 | f | The birthplace of George Washington found. | America | http://trove.nla.gov.au/newspaper/page/24101823 | 24101823 | |
31875 | 31875 | 1917-01-06 | 6 | c | The attitude of Mexican government in its negotiation with America. Political chaos in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24095543 | 24095543 | |
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 | |
4799 | 4799 | 1900-03-21 | 3 | a | The antithetical couplets prepared by American Chinese Empire Reform Association. | America | http://trove.nla.gov.au/newspaper/page/24102738 | 24102738 | |
9575 | 9575 | 1902-01-15 | 2 | f | The amount of national debt in the world. | America | http://trove.nla.gov.au/newspaper/page/24100299 | 24100299 | |
35668 | 35668 | 1920-05-08 | 3 | d | The ambitious Japan and its military plan. | America | http://trove.nla.gov.au/newspaper/page/24098150 | 24098150 | |
36915 | 36915 | 1921-04-30 | 3 | c | The alliance of Japan and Britain and the treaty negotiation between Japan and America. | America | http://trove.nla.gov.au/newspaper/page/24093524 | 24093524 | |
32266 | 32266 | 1917-04-28 | 3 | e | The alliance between Germany, Japan and Russia. | America | http://trove.nla.gov.au/newspaper/page/24095672 | 24095672 | |
5795 | 5795 | 1900-08-01 | 3 | a | The activities of Chinese Empire Reform Association in Honolulu. | America | http://trove.nla.gov.au/newspaper/page/24102893 | 24102893 | |
39328 | 39328 | 1923-01-27 | 3 | f | The Zhang Shaozeng cabinet and its conflict with the parliament. Beijing students break in the parliament chamber. | America | http://trove.nla.gov.au/newspaper/page/24094267 | 24094267 | |
37976 | 37976 | 1921-12-10 | 6 | b | The Washington Conference sees different opinions on the return of international concessions to Chinese government. | America | http://trove.nla.gov.au/newspaper/page/24093787 | 24093787 | |
38298 | 38298 | 1922-02-18 | 3 | d-e | The Washington Conference is closed. American President Warren Harding submits the treaty to the Parliament. | America | http://trove.nla.gov.au/newspaper/page/24093871 | 24093871 | |
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 | |
18064 | 18064 | 1907-09-07 | 3 | c | The United States would like to give up the Philippines island. | America | http://trove.nla.gov.au/newspaper/page/26801459 | 26801459 | |
8758 | 8758 | 1901-10-05 | 3 | d | The United States of America has a new president. | America | http://trove.nla.gov.au/newspaper/page/24100184 | 24100184 | |
18223 | 18223 | 1907-10-05 | 3 | c | The United States challenges Japan in the Pacific region which might lead to a war. | America | http://trove.nla.gov.au/newspaper/page/26801491 | 26801491 | |
4986 | 4986 | 1900-04-18 | 2 | c | The USA has significantly increased its military budget. | America | http://trove.nla.gov.au/newspaper/page/24102771 | 24102771 | |
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 |
38429 | 38429 | 1922-03-18 | 2 | e-f | The Twenty-one Demands after the Washington Conference. | America | http://trove.nla.gov.au/newspaper/page/24093904 | 24093904 | |
5613 | 5613 | 1900-07-07 | 2 | b-c | The San Francisco authority considers closing Chinatown there as they suspect epidemics have been found in the Chinese community. | America | http://trove.nla.gov.au/newspaper/page/24102866 | 24102866 | |
20437 | 20437 | 1908-12-26 | 6 | c | The Republican party wins the presidential election in the United States of America. | America | http://trove.nla.gov.au/newspaper/page/26802000 | 26802000 | |
33967 | 33967 | 1919-01-04 | 3 | f | The Republic of Ireland and its social turmoil. | America | http://trove.nla.gov.au/newspaper/page/24097557 | 24097557 |
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]);