This data as json, CSV (advanced)
Suggested facets: page, column, date (date)
Link | rowid | date | page ▲ | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
13022 | 13022 | 1904-04-09 | Suppl't | b | Floods in America. | America | http://trove.nla.gov.au/newspaper/page/26800411 | 26800411 | |
13131 | 13131 | 1904-04-30 | Suppl't | a-b | An article, selected from a New York newspaper, respectively analyses advantages and disadvantages of Russia and Japan | America | http://trove.nla.gov.au/newspaper/page/26800426 | 26800426 | |
13273 | 13273 | 1904-05-28 | Suppl't | a | Second and final part of a report from the Chinese community in Honolulu. | America | http://trove.nla.gov.au/newspaper/page/26800446 | 26800446 | |
13275 | 13275 | 1904-05-28 | Suppl't | b | Senate of the United States of America has failed to pass a law banning Chinese immigrants. | America | http://trove.nla.gov.au/newspaper/page/26800446 | 26800446 | |
13276 | 13276 | 1904-05-28 | Suppl't | b | Bei Lunzi, Chinese representative to St Louise Fair, met President Roosevelt of the United States. | America | http://trove.nla.gov.au/newspaper/page/26800446 | 26800446 | |
13279 | 13279 | 1904-05-28 | Suppl't | c | Patriotic Chinese youth in San Francisco cut their pigtails. | America | http://trove.nla.gov.au/newspaper/page/26800446 | 26800446 | |
13380 | 13380 | 1904-06-18 | Suppl't | b | Chinese student Yan Yizhen has excellent school performance in Columbia University. | America | http://trove.nla.gov.au/newspaper/page/26800461 | 26800461 | |
13421 | 13421 | 1904-06-25 | Suppl't | b | Chinese envoy Bei Zi in St Louise, United States. | America | http://trove.nla.gov.au/newspaper/page/26800466 | 26800466 | |
13671 | 13671 | 1904-08-13 | Suppl't | a | An article, selected from an American newspaper, discusses the Yellow Peril. | America | http://trove.nla.gov.au/newspaper/page/26800501 | 26800501 | |
13676 | 13676 | 1904-08-13 | Suppl't | b | America's view on what China would be like after the Russo-Japanese War. | America | http://trove.nla.gov.au/newspaper/page/26800501 | 26800501 | |
13791 | 13791 | 1904-09-10 | Suppl't | b | A priest in Chicago, USA, was attacked for advocating interracial marriage between black and white people. | America | http://trove.nla.gov.au/newspaper/page/26800521 | 26800521 | |
14001 | 14001 | 1904-11-19 | Suppl't | a | President Roosevelt of the Untied States has won another term. | America | http://trove.nla.gov.au/newspaper/page/26800571 | 26800571 | |
14005 | 14005 | 1904-11-19 | Suppl't | b | American navy is expanding. | America | http://trove.nla.gov.au/newspaper/page/26800571 | 26800571 | |
14131 | 14131 | 1904-12-31 | Suppl't | c | Kang Youwei arrives in Vancouver. He will travel to the United States. | America | http://trove.nla.gov.au/newspaper/page/26800601 | 26800601 | |
14148 | 14148 | 1905-01-07 | Suppl't | a | Farmers in Southern America have started to destroy some cotton in order to retain a reasonable price. | America | http://trove.nla.gov.au/newspaper/page/26800606 | 26800606 | |
14489 | 14489 | 1905-05-20 | Suppl't | b | Japan puts forward their conditions for truce with Russia. | America | http://trove.nla.gov.au/newspaper/page/26800697 | 26800697 | |
14793 | 14793 | 1905-09-16 | Suppl't | a | Japanese Prime Minister Katsura Taro is keen to teach China and Korea on reform and new politics. | America | http://trove.nla.gov.au/newspaper/page/26800778 | 26800778 | |
18601 | 18601 | 1907-12-07 | 8 | b-d | First part of report on a Chinese community in San Francisco's fight for equal opportunity in education between Chinese and other school children. | America | http://trove.nla.gov.au/newspaper/page/26801570 | 26801570 | |
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 | |
18638 | 18638 | 1907-12-14 | 8 | b-c | Second 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/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 | |
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 | |
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 | |
18898 | 18898 | 1908-02-15 | 8 | b-c | Correspondence from America. Li Huanlou graduates from a New York school and translation of his graduation certificate. Another group of Chinese students arrives Boston. Anti-Japanese movement in San Francisco and the Chinese community there. | America | http://trove.nla.gov.au/newspaper/page/26801636 | 26801636 | |
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 | |
19622 | 19622 | 1908-07-04 | 8 | b-c | Chinese Society (zhong hua hui guan) in San Francisco writes and supports navy levy. | America | http://trove.nla.gov.au/newspaper/page/26801798 | 26801798 | |
20913 | 20913 | 1909-04-10 | 8 | d | Name list of shareholders in New York of the Guangmei Agriculture and Husbandry Company (Guangmei nong mu gong si) in Guangxi province. | America | http://trove.nla.gov.au/newspaper/page/26802146 | 26802146 | |
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 | |
22584 | 22584 | 1910-03-26 | 8 | c-d | An open letter from the Chinese Empire Reform Association in Washington and Boston regarding the Zhenhua company and other relevant issues. | America | http://trove.nla.gov.au/newspaper/page/26802575 | 26802575 | |
22607 | 22607 | 1910-04-02 | 8 | c-d | Members of the Chinese Empire Reform Association in America and Canada send their warning message to Ye En, of Zhenhua industrial company (Jun Wah Sut Yip Co. Ltd). | America | |||
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 | |
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 | |
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 | |
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 | |
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 | |
23702 | 23702 | 1910-10-22 | 8 | b-c | Correspondence from America/ Chinese students in central part of the United States of American gather and the report. | America | http://trove.nla.gov.au/newspaper/page/26802816 | 26802816 | |
23940 | 23940 | 1910-12-03 | 8 | c | Chinese Empire Reform Association in the east of America welcomes Zai Xun. | America | http://trove.nla.gov.au/newspaper/page/26802864 | 26802864 | |
24601 | 24601 | 1911-05-29 | 8 | c | Miscellous | Sun Wen begs for donations to support its revolution. | America | ||
24978 | 24978 | 1911-09-09 | 8 | d | Ally Association Secretary commits suicide | Zhong Xingchu, secretary of the revolutionary party commits suicide in America. | America | http://trove.nla.gov.au/newspaper/page/24091916 | 24091916 |
27019 | 27019 | 1913-02-15 | 8 | c-d | Report of fifth International Business Conference in Boston. | America | http://trove.nla.gov.au/newspaper/page/24092583 | 24092583 | |
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 | |
27781 | 27781 | 1913-08-23 | 8 | b | Chaos in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24092799 | 24092799 | |
28052 | 28052 | 1913-10-25 | 8 | c | Correspondence from New York/ Establishment of the Nationalist Association in New York, its organisation and members. | America | http://trove.nla.gov.au/newspaper/page/24092871 | 24092871 | |
29085 | 29085 | 1914-07-18 | 8 | b-c | Rich men in the United States of American and their wealth. | America | http://trove.nla.gov.au/newspaper/page/24093186 | 24093186 | |
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 | |
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 | |
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 | |
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 | |
29532 | 29532 | 1915-01-02 | 8 | c | American president goes to Panama Canal for a sport contest for celebrating the canal's starting service. | America | http://trove.nla.gov.au/newspaper/page/24094677 | 24094677 | |
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 | |
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 | |
30007 | 30007 | 1915-05-01 | 8 | c | America is to send a business delegation to China. | America | http://trove.nla.gov.au/newspaper/page/24094831 | 24094831 | |
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 | |
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 | |
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 | |
31297 | 31297 | 1916-06-03 | 8 | d-e | Chinese community in San Francisco and their lawyer protest against American parliament for discriminative immigration policy. | America | http://trove.nla.gov.au/newspaper/page/24095290 | 24095290 | |
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 | |
47104 | 47104 | 1928-06-02 | 8 | a | Gas explosion in America and the tragedy. | America | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
47110 | 47110 | 1928-06-02 | 8 | b | Japan's attitude on the disarmament treaty. | 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 | |
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 | |
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 | |
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 | |
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 | |
48013 | 48013 | 1929-04-13 | 8 | b | Bandits in Chicago. | 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 | |
48286 | 48286 | 1929-07-13 | 8 | c | Wife of Chinese deputy consul to San Francisco is detained by American customs for opium smuggling. | America | http://trove.nla.gov.au/newspaper/page/24099285 | 24099285 | |
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 | |
48384 | 48384 | 1929-08-17 | 8 | e | Chinese in America have a traffic accident. | America | http://trove.nla.gov.au/newspaper/page/24099329 | 24099329 | |
48450 | 48450 | 1929-09-07 | 8 | d | Two ships collide near San Francisco. | America | http://trove.nla.gov.au/newspaper/page/24099355 | 24099355 | |
48508 | 48508 | 1929-09-28 | 8 | d | American coast guards detain British ship for illegal wines. | America | http://trove.nla.gov.au/newspaper/page/24099379 | 24099379 | |
48526 | 48526 | 1929-10-05 | 8 | c | American woman is imprisoned for driving without licence. | America | http://trove.nla.gov.au/newspaper/page/24099387 | 24099387 | |
48529 | 48529 | 1929-10-05 | 8 | d | Earthquake in Hawaii. | America | http://trove.nla.gov.au/newspaper/page/24099387 | 24099387 | |
48548 | 48548 | 1929-10-12 | 8 | c | Robbery in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24099395 | 24099395 | |
48635 | 48635 | 1929-11-09 | 8 | e | A survey on rich men and women in America. | America | http://trove.nla.gov.au/newspaper/page/24099427 | 24099427 | |
48728 | 48728 | 1929-12-14 | 8 | d | Bomb explosion in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24099469 | 24099469 | |
48870 | 48870 | 1930-02-08 | 8 | c | Banditry in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24099525 | 24099525 | |
48896 | 48896 | 1930-02-15 | 8 | d | Bandits arrested in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24099533 | 24099533 |
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]);