This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
10794 | 10794 | 1902-06-04 | 3 | a | A town in the United States tries to deport all Chinese. | America | http://trove.nla.gov.au/newspaper/page/24100447 | 24100447 | |
10797 | 10797 | 1902-06-04 | 3 | b | A happy couple in America. | America | http://trove.nla.gov.au/newspaper/page/24100447 | 24100447 | |
10853 | 10853 | 1902-06-14 | 2 | e | Chinese ambassador to Washington, Wu Tingfang, resigns in protest of American immigration discrimination policy. | America | http://trove.nla.gov.au/newspaper/page/24100457 | 24100457 | |
10861 | 10861 | 1902-06-14 | 3 | a-b | Popular party in south China, their anti-Manchurian slogans and the possibility of riots. | America | http://trove.nla.gov.au/newspaper/page/24100456 | 24100456 | |
10899 | 10899 | 1902-06-18 | 3 | b | Storm in America. | America | http://trove.nla.gov.au/newspaper/page/24100460 | 24100460 | |
11042 | 11042 | 1902-09-27 | 6 | b | Indigestion in Belgium causes a death. | America | http://trove.nla.gov.au/newspaper/page/24100497 | 24100497 | |
11116 | 11116 | 1902-10-25 | 3 | a | Report on the American law that to ban Chinese immigrants. | America | http://trove.nla.gov.au/newspaper/page/24100519 | 24100519 | |
11117 | 11117 | 1902-10-25 | 3 | a | A Chinese consul to Honolulu was sent back for opium smuggling. American government suggests Chinese community there to elect a consul instead. | America | http://trove.nla.gov.au/newspaper/page/24100519 | 24100519 | |
11233 | 11233 | 1902-11-29 | 3 | b | Hawaii is relaxing its immigration restriction on the arrival of Chinese farmers. | America | http://trove.nla.gov.au/newspaper/page/24100539 | 24100539 | |
11237 | 11237 | 1902-11-29 | 3 | c | Xu Shiqin, Kang Youwei's student, receives respect on his arrival of America. | America | http://trove.nla.gov.au/newspaper/page/24100539 | 24100539 | |
11240 | 11240 | 1902-11-29 | 3 | c | Riots in Cuba. | America | http://trove.nla.gov.au/newspaper/page/24100539 | 24100539 | |
11259 | 11259 | 1902-12-06 | 3 | a | Competition between steel companies in America. | America | http://trove.nla.gov.au/newspaper/page/24100543 | 24100543 | |
11260 | 11260 | 1902-12-06 | 3 | a | Xu Shiqin, Kang Youwei's favourite student, Rong Hong, Yu Jiaming and Peng Xinyou delivered speeches in New York. | America | http://trove.nla.gov.au/newspaper/page/24100543 | 24100543 | |
11261 | 11261 | 1902-12-06 | 3 | a | Xue Jinqin, Wang Jianzu, and Tan Tianchi delivered patriotic speeches in San Francisco. | America | http://trove.nla.gov.au/newspaper/page/24100543 | 24100543 | |
11287 | 11287 | 1902-12-13 | 3 | b | Chinese ambassador to America, Wu Tingfang, was invited to speak at the Labour Party conference but was welcomed by stones. | America | http://trove.nla.gov.au/newspaper/page/24100547 | 24100547 | |
11323 | 11323 | 1902-12-20 | 3 | c | Chinese ambassador to America, Wu Tingfang, is returning. | America | http://trove.nla.gov.au/newspaper/page/24100553 | 24100553 | |
11346 | 11346 | 1903-01-03 | 3 | a | Wu Wenhua, a talented Chinese lawyer in Honolulu. | America | http://trove.nla.gov.au/newspaper/page/26800147 | 26800147 | |
11375 | 11375 | 1903-01-10 | 3 | a | A branch of the Chinese Empire Reform Association has been established in New York. Speakers at the inaugural ceremony are Zhao Wansheng, Xu Shiqin, Peng Xinyou, Yu Jiaming, and Feng Yuemao. | America | http://trove.nla.gov.au/newspaper/page/26800150 | 26800150 | |
11379 | 11379 | 1903-01-10 | 3 | b | A dog in Chicago, United States, saved his master. | America | http://trove.nla.gov.au/newspaper/page/26800150 | 26800150 | |
11381 | 11381 | 1903-01-10 | 3 | b | Wu Wenhua, Chinese lawyer in Honolulu, gave an emotional speech at a gathering. | America | http://trove.nla.gov.au/newspaper/page/26800150 | 26800150 | |
11387 | 11387 | 1903-01-10 | 3 | c | An American man built a sailboat school. | America | http://trove.nla.gov.au/newspaper/page/26800150 | 26800150 | |
11444 | 11444 | 1903-01-24 | 3 | a | Ms Xue Jinqin's speech at a conference of the Chinese Empire Reform Association in San Francisco. | America | http://trove.nla.gov.au/newspaper/page/26800158 | 26800158 | |
11445 | 11445 | 1903-01-24 | 3 | a | American President Roosevelt signs an agreement which would enable a telephone line to connect America and China. | America | http://trove.nla.gov.au/newspaper/page/26800158 | 26800158 | |
11449 | 11449 | 1903-01-24 | 3 | b | Fat people in America have a sports game. | America | http://trove.nla.gov.au/newspaper/page/26800158 | 26800158 | |
11451 | 11451 | 1903-01-24 | 3 | b | Builders' association in Hawaii agrees to employ some Chinese workers. | America | http://trove.nla.gov.au/newspaper/page/26800158 | 26800158 | |
11505 | 11505 | 1903-02-14 | 3 | a | A branch of the Chinese Empire Reform Association has been established in Philadelphia, USA; Chinese community in Vancouver is to build an office for the Chinese Empire Reform Association. | America | http://trove.nla.gov.au/newspaper/page/26800168 | 26800168 | |
11506 | 11506 | 1903-02-14 | 3 | a | Chinese community in San Francisco is to have a daily newspaper. The chief-editor is Ou Maocai. | America | http://trove.nla.gov.au/newspaper/page/26800168 | 26800168 | |
11508 | 11508 | 1903-02-14 | 3 | a | A rich and beautiful American girl likes to travel around the world. | America | http://trove.nla.gov.au/newspaper/page/26800168 | 26800168 | |
11513 | 11513 | 1903-02-14 | 3 | b | Bernard, a British gentleman, is very kind and helpful to Chinese immigrants in America. | America | http://trove.nla.gov.au/newspaper/page/26800168 | 26800168 | |
11540 | 11540 | 1903-02-21 | 3 | a | Report on the suffering of Chinese in Honolulu. | America | http://trove.nla.gov.au/newspaper/page/26800172 | 26800172 | |
11576 | 11576 | 1903-02-28 | 3 | c | Chinese immigrants will be permitted to land in the Philippines. | America | http://trove.nla.gov.au/newspaper/page/26800176 | 26800176 | |
11596 | 11596 | 1903-03-07 | 3 | b | Compensations from American government to the Chinese residents in Honolulu for burning down their houses during the epidemic period. | America | http://trove.nla.gov.au/newspaper/page/26800180 | 26800180 | |
11618 | 11618 | 1903-03-14 | 2 | c | American engineer comments on the railway building from Hankou to Guangzhou. | America | http://trove.nla.gov.au/newspaper/page/26800187 | 26800187 | |
11628 | 11628 | 1903-03-14 | 3 | c | The Guangzhi translation and publishing company in Shanghai has raised a lot capital by floating shares, both in America and in Japan. | America | http://trove.nla.gov.au/newspaper/page/26800186 | 26800186 | |
11675 | 11675 | 1903-03-28 | 3 | a | A Thai student in America. | America | http://trove.nla.gov.au/newspaper/page/26800194 | 26800194 | |
11727 | 11727 | 1903-04-11 | 3 | a | Republicans in Alabama, United States, electe a candidate to replace President Theodore Roosevelt. | America | http://trove.nla.gov.au/newspaper/page/26800202 | 26800202 | |
11729 | 11729 | 1903-04-11 | 3 | a | A French scientist died in a soul test. | America | http://trove.nla.gov.au/newspaper/page/26800202 | 26800202 | |
11779 | 11779 | 1903-04-25 | 3 | b | Kang Tongbi, Kang Youwei's daughter, is now in America. | America | http://trove.nla.gov.au/newspaper/page/26800210 | 26800210 | |
11871 | 11871 | 1903-05-23 | 2 | a | An article, written by Li Hongzhang's private doctor, on the separatist regime and the building of a new dynasty in China. | America | http://trove.nla.gov.au/newspaper/page/26800228 | 26800228 | |
11875 | 11875 | 1903-05-23 | 2 | b | Wang Chonghui, Xue Xianzhou and dozens of other Chinese students have a hard life in America as Chinese government stopped providing them financial assistance. | America | http://trove.nla.gov.au/newspaper/page/26800228 | 26800228 | |
12000 | 12000 | 1903-07-11 | 3 | a | Some people in San Francisco suggest moving Chinatown outside of the city. | America | http://trove.nla.gov.au/newspaper/page/26800252 | 26800252 | |
12041 | 12041 | 1903-07-18 | 3 | b | Hawaii will ban entry of Japanese. | America | http://trove.nla.gov.au/newspaper/page/26800256 | 26800256 | |
12042 | 12042 | 1903-07-18 | 3 | b | An American farmer invents electrical fertiliser. | America | http://trove.nla.gov.au/newspaper/page/26800256 | 26800256 | |
12043 | 12043 | 1903-07-18 | 3 | b | A big cake in New York. | America | http://trove.nla.gov.au/newspaper/page/26800256 | 26800256 | |
12066 | 12066 | 1903-07-25 | 3 | a | Report on Liang Qichao's visit to New York. | America | http://trove.nla.gov.au/newspaper/page/26800260 | 26800260 | |
12085 | 12085 | 1903-08-01 | 3 | a | Liang Qichao's visit to San Francisco and Harvard. | America | http://trove.nla.gov.au/newspaper/page/26800264 | 26800264 | |
12088 | 12088 | 1903-08-01 | 3 | b | Chinese in New York set up a Society of East Asia, and involvement of Chinese Consul General. | America | http://trove.nla.gov.au/newspaper/page/26800264 | 26800264 | |
12089 | 12089 | 1903-08-01 | 3 | c | Dozens of American workers in New York donated skins to save their fellow. | America | http://trove.nla.gov.au/newspaper/page/26800264 | 26800264 | |
12129 | 12129 | 1903-08-15 | 3 | a | President Roosevelt of America is seeking another term of office. | America | http://trove.nla.gov.au/newspaper/page/26800272 | 26800272 | |
12131 | 12131 | 1903-08-15 | 3 | a | Chinese student Wang Chonghui was admitted to the degree of Master of Law in Yale University, Zhang Yuquan bachelor's degree. | America | http://trove.nla.gov.au/newspaper/page/26800272 | 26800272 | |
12132 | 12132 | 1903-08-15 | 3 | b | Chinese communities in America try to unite in order to resist the strict regulations imposed by American government from July. | America | http://trove.nla.gov.au/newspaper/page/26800272 | 26800272 | |
12133 | 12133 | 1903-08-15 | 3 | b | Several Chinese immigrants are under custody in San Francisco. | America | http://trove.nla.gov.au/newspaper/page/26800272 | 26800272 | |
12158 | 12158 | 1903-08-22 | 3 | a | Report on Liang Qichao's visit to the Chinese community in Boston. | America | http://trove.nla.gov.au/newspaper/page/26800276 | 26800276 | |
12175 | 12175 | 1903-08-29 | 3 | a | Report on Liang Qichao's visit to Washington, Philadelphia and New York. | America | http://trove.nla.gov.au/newspaper/page/26800280 | 26800280 | |
12176 | 12176 | 1903-08-29 | 3 | b | Writer of public notices and their salary in America. | America | http://trove.nla.gov.au/newspaper/page/26800280 | 26800280 | |
12177 | 12177 | 1903-08-29 | 3 | b | Hawaii is to ban entry of Americans. | America | http://trove.nla.gov.au/newspaper/page/26800280 | 26800280 | |
12218 | 12218 | 1903-09-12 | 3 | a | Liang Qichao's visit to Washington; his meeting with the Secretary of State, former President and others. | America | http://trove.nla.gov.au/newspaper/page/26800288 | 26800288 | |
12220 | 12220 | 1903-09-12 | 3 | a | Chinese communities in Hawaii are to build a Guangdong school. | America | http://trove.nla.gov.au/newspaper/page/26800288 | 26800288 | |
12243 | 12243 | 1903-09-19 | 3 | a | Colombia University in America is to establish a Department of Journalism. | America | http://trove.nla.gov.au/newspaper/page/26800292 | 26800292 | |
12245 | 12245 | 1903-09-19 | 3 | a | Chinese community in New York sends a plea to American and British government asking for their help to the reformers in China. | America | http://trove.nla.gov.au/newspaper/page/26800292 | 26800292 | |
12246 | 12246 | 1903-09-19 | 3 | a | A newspaper in Los Angeles reports and comments on current political situations in China. | America | http://trove.nla.gov.au/newspaper/page/26800292 | 26800292 | |
12249 | 12249 | 1903-09-19 | 3 | b | Bones were found in a gold mine in America. | America | http://trove.nla.gov.au/newspaper/page/26800292 | 26800292 | |
12267 | 12267 | 1903-09-26 | 3 | a | Representatives of Jewish people around the world had a conference in Basel, Switzerland, with a purpose to set up their own country. | America | http://trove.nla.gov.au/newspaper/page/26800296 | 26800296 | |
12269 | 12269 | 1903-09-26 | 3 | b | An American company builds a ship that can cross the Atlanta Ocean within two days. | America | http://trove.nla.gov.au/newspaper/page/26800296 | 26800296 | |
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 | |
12316 | 12316 | 1903-10-10 | 3 | a | An Italian man tries to walk through nine countries in three years. | America | http://trove.nla.gov.au/newspaper/page/26800304 | 26800304 | |
12323 | 12323 | 1903-10-10 | 3 | c | An American man insures his life to the value of four million dollars. | America | http://trove.nla.gov.au/newspaper/page/26800304 | 26800304 | |
12337 | 12337 | 1903-10-17 | 3 | a | Report on Liang Qichao's visit to the United States of America. | America | http://trove.nla.gov.au/newspaper/page/26800308 | 26800308 | |
12338 | 12338 | 1903-10-17 | 3 | a | Kang Tongbi, Kang Youwei's daughter, Ye Huibo, and Liang Qixun, Liang Qichao's brother, arrive in St Louis. | America | http://trove.nla.gov.au/newspaper/page/26800308 | 26800308 | |
12401 | 12401 | 1903-11-07 | 3 | a | A conference of the Chinese students' association in the United States of America. | America | http://trove.nla.gov.au/newspaper/page/26800320 | 26800320 | |
12403 | 12403 | 1903-11-07 | 3 | b | A report on Liang Qichao's visit to America. | America | http://trove.nla.gov.au/newspaper/page/26800320 | 26800320 | |
12407 | 12407 | 1903-11-07 | 3 | b | Report on the daughter of President Roosevelt. | America | http://trove.nla.gov.au/newspaper/page/26800320 | 26800320 | |
12412 | 12412 | 1903-11-07 | 3 | c | Sun Yatsen has returned to Honolulu. | America | http://trove.nla.gov.au/newspaper/page/26800320 | 26800320 | |
12432 | 12432 | 1903-11-14 | 2 | d | Liang Qichao's speech in the USA. | America | http://trove.nla.gov.au/newspaper/page/26800325 | 26800325 | |
12444 | 12444 | 1903-11-14 | 3 | c | An American businessman bought a flower vase with 20 million dollars. | America | http://trove.nla.gov.au/newspaper/page/26800324 | 26800324 | |
12470 | 12470 | 1903-11-21 | 3 | a | Report on a meeting of the Chinese Empire Reform Association in Merida, Mexico. | America | http://trove.nla.gov.au/newspaper/page/26800328 | 26800328 | |
12471 | 12471 | 1903-11-21 | 3 | a | A British earl talks to American journalist after touring Japan and China. | America | http://trove.nla.gov.au/newspaper/page/26800328 | 26800328 | |
12476 | 12476 | 1903-11-21 | 3 | b | American President Roosevelt says they will support a civil government in Panama. Reports and comments in the New York Times. | America | http://trove.nla.gov.au/newspaper/page/26800328 | 26800328 | |
12503 | 12503 | 1903-11-28 | 3 | a | Lu Zhaoyuan, Lin Lianqiu and other Chinese women in San Francisco invite Liang Qichao, Bao Chi and Xue Jinqin to discuss women's rights and feminism at a theatre. Only women are allowed to enter. | America | http://trove.nla.gov.au/newspaper/page/26800332 | 26800332 | |
12504 | 12504 | 1903-11-28 | 3 | a | Liang Qichao speaks to the Chinese Empire Reform Association in Warren, America. | America | http://trove.nla.gov.au/newspaper/page/26800332 | 26800332 | |
12505 | 12505 | 1903-11-28 | 3 | a | Feminism. Xue Jinqin talks about women's rights to her Chinese sisters in San Francisco. | America | http://trove.nla.gov.au/newspaper/page/26800332 | 26800332 | |
12507 | 12507 | 1903-11-28 | 3 | b | Japanese in Hawaii advocate military nationalism. | America | http://trove.nla.gov.au/newspaper/page/26800332 | 26800332 | |
12535 | 12535 | 1903-12-05 | 3 | a | Liang Qichao has left San Francisco for Los Angeles. | America | http://trove.nla.gov.au/newspaper/page/26800336 | 26800336 | |
12536 | 12536 | 1903-12-05 | 3 | b | The 65,000 Japanese in Hawaii are going to unite and form their own organisation. | America | http://trove.nla.gov.au/newspaper/page/26800336 | 26800336 | |
12538 | 12538 | 1903-12-05 | 3 | b | President Roosevelt in tight security while attending his uncle's funeral. | America | http://trove.nla.gov.au/newspaper/page/26800336 | 26800336 | |
12539 | 12539 | 1903-12-05 | 3 | b | Several child bandits were arrested in Chicago. | America | http://trove.nla.gov.au/newspaper/page/26800336 | 26800336 | |
12559 | 12559 | 1903-12-12 | 2 | d | Kang Tongbi arrives Chicago and starts another Chinese women's association there. | America | http://trove.nla.gov.au/newspaper/page/26800341 | 26800341 | |
12563 | 12563 | 1903-12-12 | 3 | a | American schools recruit and train young and talented Filipinos. | America | http://trove.nla.gov.au/newspaper/page/26800340 | 26800340 | |
12569 | 12569 | 1903-12-12 | 3 | b | Educational statistics of the United States. | America | http://trove.nla.gov.au/newspaper/page/26800340 | 26800340 | |
12574 | 12574 | 1903-12-19 | 2 | a-b | Liang Qichao's visit to Los Angeles. Liang's speech there. The Chinese Empire Reform Association and its activities. | America | http://trove.nla.gov.au/newspaper/page/26800345 | 26800345 | |
12591 | 12591 | 1903-12-19 | 3 | a | Kang Tongbi, Kang Youwei's daughter, visits Chicago, New York and Harvard. | America | http://trove.nla.gov.au/newspaper/page/26800344 | 26800344 | |
12620 | 12620 | 1903-12-26 | 3 | a | Chinese businessmen in America are to set up a school in Guangzhou. | America | http://trove.nla.gov.au/newspaper/page/26800348 | 26800348 | |
12621 | 12621 | 1903-12-26 | 3 | a | School teachers in New York are to set up an association. | America | http://trove.nla.gov.au/newspaper/page/26800348 | 26800348 | |
12623 | 12623 | 1903-12-26 | 3 | a | America's President Roosevelt meets special envoy from Panama. | America | http://trove.nla.gov.au/newspaper/page/26800348 | 26800348 | |
12626 | 12626 | 1903-12-26 | 3 | b | Lower House of American parliament approves the trade treaty with China. | America | http://trove.nla.gov.au/newspaper/page/26800348 | 26800348 | |
12674 | 12674 | 1904-01-09 | 2 | d | Liang Qichao's visit to San Francisco. | America | http://trove.nla.gov.au/newspaper/page/26800357 | 26800357 | |
12675 | 12675 | 1904-01-09 | 2 | d | Chinese communities (societies/ associations) in San Francisco donate to establish a Guangdong school. | America | http://trove.nla.gov.au/newspaper/page/26800357 | 26800357 | |
12706 | 12706 | 1904-01-23 | 2 | a | First 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/26800365 | 26800365 | |
12734 | 12734 | 1904-01-30 | 2 | a-b | Second 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/26800369 | 26800369 | |
12737 | 12737 | 1904-01-30 | 2 | b | American ambassador to Korea says Russia is the biggest threat in northeast Asia. | America | http://trove.nla.gov.au/newspaper/page/26800369 | 26800369 |
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]);