This data as json, CSV (advanced)
Suggested facets: column, title, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
48985 | 48985 | 1930-03-15 | 8 | c | Communist riots are arrested in New York. | America | http://trove.nla.gov.au/newspaper/page/24099568 | 24099568 | |
49103 | 49103 | 1930-04-26 | 8 | c | Banditry in America. | America | http://trove.nla.gov.au/newspaper/page/24099617 | 24099617 | |
49206 | 49206 | 1930-05-31 | 8 | d | Number of people killed in car accident in America. | America | http://trove.nla.gov.au/newspaper/page/24099657 | 24099657 | |
49208 | 49208 | 1930-05-31 | 8 | d | A cargo ship on fire in Honolulu. | America | http://trove.nla.gov.au/newspaper/page/24099657 | 24099657 | |
49246 | 49246 | 1930-06-14 | 8 | d | Robbery in New York. | America | http://trove.nla.gov.au/newspaper/page/24099673 | 24099673 | |
49338 | 49338 | 1930-07-19 | 8 | c | A plane crashes in America and the casualties. | America | http://trove.nla.gov.au/newspaper/page/24099713 | 24099713 | |
49421 | 49421 | 1930-08-16 | 8 | c | Long drought in America. | America | http://trove.nla.gov.au/newspaper/page/24099744 | 24099744 | |
49483 | 49483 | 1930-09-06 | 8 | c | Military government organised in Peru. | America | http://trove.nla.gov.au/newspaper/page/24099771 | 24099771 | |
49506 | 49506 | 1930-09-13 | 8 | c | Hurricane in central America. | America | http://trove.nla.gov.au/newspaper/page/24099779 | 24099779 | |
49603 | 49603 | 1930-10-18 | 8 | c | Riots in Brazil. | America | http://trove.nla.gov.au/newspaper/page/24099819 | 24099819 | |
49647 | 49647 | 1930-11-01 | 8 | c | American President Hoover bans weapon sales to rebellions in Brazil. | America | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
49648 | 49648 | 1930-11-01 | 8 | c | American navy to build more warships. | America | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
49650 | 49650 | 1930-11-01 | 8 | c | American government helps the unemployed. | America | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
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 | |
49705 | 49705 | 1930-11-15 | 8 | c | Train robbed in America. | America | http://trove.nla.gov.au/newspaper/page/24099851 | 24099851 | |
49708 | 49708 | 1930-11-15 | 8 | c | Number of unemployed people increases sharply in America. | America | http://trove.nla.gov.au/newspaper/page/24099851 | 24099851 | |
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 |
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]);