This data as json, CSV (advanced)
Suggested facets: column, title, date (date)
Link | rowid | date | page | column | title | description ▼ | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
9355 | 9355 | 1901-12-18 | 2 | e | A German gentleman was beaten in an American pub for his comments on President McKinley. | America | http://trove.nla.gov.au/newspaper/page/24100269 | 24100269 | |
29212 | 29212 | 1914-09-05 | 2 | d | A New York newspaper on Sun Yatsen and China. | America | http://trove.nla.gov.au/newspaper/page/24093236 | 24093236 | |
43420 | 43420 | 1925-07-04 | 2 | c-d | A New York newspaper suggests to disarm. | America | http://trove.nla.gov.au/newspaper/page/24101192 | 24101192 | |
6746 | 6746 | 1900-12-29 | 2 | f | A bank teller in Washington was sacked for embezzlement. He avenged his sacking by shooting other bank employees. | America | http://trove.nla.gov.au/newspaper/page/24103065 | 24103065 | |
49266 | 49266 | 1930-06-28 | 2 | c | A black man rape white woman in America and the aftermath. | America | http://trove.nla.gov.au/newspaper/page/24099683 | 24099683 | |
8835 | 8835 | 1901-10-16 | 2 | e | A bridge in New York collapsed. | America | http://trove.nla.gov.au/newspaper/page/24100197 | 24100197 | |
47527 | 47527 | 1928-10-27 | 2 | c | A case of kidnap in Hawaii and the ransom. | America | http://trove.nla.gov.au/newspaper/page/24098994 | 24098994 | |
4819 | 4819 | 1900-03-24 | 2 | f | A coal mine accident in America. | America | http://trove.nla.gov.au/newspaper/page/24102743 | 24102743 | |
8805 | 8805 | 1901-10-12 | 2 | e | A drunkard in America derives benefits from drinking. | America | http://trove.nla.gov.au/newspaper/page/24100193 | 24100193 | |
7742 | 7742 | 1901-05-22 | 2 | d | A female scientist in New York looks like a man. | America | http://trove.nla.gov.au/newspaper/page/24100047 | 24100047 | |
8804 | 8804 | 1901-10-12 | 2 | d | A girl in America used her resourcefulness to save her father. | America | http://trove.nla.gov.au/newspaper/page/24100193 | 24100193 | |
37960 | 37960 | 1921-12-10 | 2 | d | A letter from Chinese Embassy in Tokyo calls for unity among Chinese communities. | America | http://trove.nla.gov.au/newspaper/page/24093783 | 24093783 | |
5737 | 5737 | 1900-07-25 | 2 | a-c | A letter from Chinese Empire Reform Association in San Francisco, America, to Li Hongzhang, Governor of Guangdong. | America | http://trove.nla.gov.au/newspaper/page/24102886 | 24102886 | |
4837 | 4837 | 1900-03-28 | 2 | a | A letter from Chinese Society in San Francisco to Liang Qichao regarding his security concerns if he wanted to visit America. | America | http://trove.nla.gov.au/newspaper/page/24102747 | 24102747 | |
8387 | 8387 | 1901-08-24 | 2 | b-c | A letter from San Francisco reporting that an American scholar is trying to help the Emperor of China to resume power. | America | http://trove.nla.gov.au/newspaper/page/24100144 | 24100144 | |
23670 | 23670 | 1910-10-22 | 2 | b-c | A letter from the Chinese Empire Reform Association in America to Prince Zai Xun. | America | http://trove.nla.gov.au/newspaper/page/26802810 | 26802810 | |
9014 | 9014 | 1901-11-06 | 2 | e | A love story in San Francisco, America. | America | http://trove.nla.gov.au/newspaper/page/24100221 | 24100221 | |
7167 | 7167 | 1901-03-06 | 2 | d | A mail ship sank into ocean near America and dozens of its passengers died. | America | http://trove.nla.gov.au/newspaper/page/24099963 | 24099963 | |
7077 | 7077 | 1901-02-13 | 2 | e | A man from San Francisco with leprosy was refused entery to Honolulu. | America | http://trove.nla.gov.au/newspaper/page/24099950 | 24099950 | |
7593 | 7593 | 1901-05-01 | 2 | f | A man in America died during a boxing match on the platform. | America | http://trove.nla.gov.au/newspaper/page/24100024 | 24100024 | |
5619 | 5619 | 1900-07-07 | 2 | d | A man in Honolulu who died of epidemic was cremated. | America | http://trove.nla.gov.au/newspaper/page/24102866 | 24102866 | |
10013 | 10013 | 1902-03-15 | 2 | e | A meeting in San Francisco discussed the proposal to increasing immigration regulations and ban the entry of Chinese into the state. | America | http://trove.nla.gov.au/newspaper/page/24100355 | 24100355 | |
4912 | 4912 | 1900-04-07 | 2 | f | A newspaper in Washington comments on China's open door policy. | America | http://trove.nla.gov.au/newspaper/page/24102759 | 24102759 | |
24066 | 24066 | 1910-12-31 | 2 | a-b | A petition from Chinese communities in America, Canada and Mexico to Prince Zai Xun for the establishment of national parliament. | America | http://trove.nla.gov.au/newspaper/page/26802890 | 26802890 | |
23983 | 23983 | 1910-12-17 | 2 | a-b | A petition from the Chinese Empire Reform Association in Chicago to Prince Zai Xun for the establishment of national parliament and the lift of ban on political parties. | America | http://trove.nla.gov.au/newspaper/page/26802874 | 26802874 | |
6403 | 6403 | 1900-11-07 | 2 | e | A pharmacy shop in New York exploded. | America | http://trove.nla.gov.au/newspaper/page/24103008 | 24103008 | |
8983 | 8983 | 1901-11-02 | 2 | e | A preidiction published in a Washington newspaper about the future of East Asia. | America | http://trove.nla.gov.au/newspaper/page/24100217 | 24100217 | |
8831 | 8831 | 1901-10-16 | 2 | d | A racist organisation, White Boxers, hold a gathering in San Francisco. | America | http://trove.nla.gov.au/newspaper/page/24100197 | 24100197 | |
52234 | 52234 | 1932-11-26 | 2 | e | A recent talk by Assistant Secretary of State of America. | America | http://trove.nla.gov.au/newspaper/page/24091032 | 24091032 | |
22475 | 22475 | 1910-03-12 | 2 | a-b | A report prepared by Wu Hongkui and 20 other Chinese businessmen in America on the crimes committed by Ye En, Ou Jujia and Liang Shaoxian. | America | http://trove.nla.gov.au/newspaper/page/26802552 | 26802552 | |
8338 | 8338 | 1901-08-07 | 2 | e | A scholar talks about the history of Chinese in Honolulu. | America | http://trove.nla.gov.au/newspaper/page/24100135 | 24100135 | |
7099 | 7099 | 1901-02-16 | 2 | d | A silver mine in America exploded. | America | http://trove.nla.gov.au/newspaper/page/24099954 | 24099954 | |
48128 | 48128 | 1929-05-25 | 2 | f | A skyscraper to be built in New York. | America | http://trove.nla.gov.au/newspaper/page/24099223 | 24099223 | |
6817 | 6817 | 1901-01-09 | 2 | f | A smart Chinese in America invented a new typesetting machine. | America | http://trove.nla.gov.au/newspaper/page/24099910 | 24099910 | |
9080 | 9080 | 1901-11-13 | 2 | f | A smart girl with a disability in America. | America | http://trove.nla.gov.au/newspaper/page/24100229 | 24100229 | |
52583 | 52583 | 1933-02-25 | 2 | c | A speech by Shi Zhaoji, Chinese ambassador in Washington. | America | http://trove.nla.gov.au/newspaper/page/24091130 | 24091130 | |
12908 | 12908 | 1904-03-19 | 2 | d | A telegram from the Chinese Empire Reform Association in California to the American Secretary of State. | America | http://trove.nla.gov.au/newspaper/page/26800395 | 26800395 | |
7940 | 7940 | 1901-06-15 | 2 | f | A truck and a train collided in the USA. | America | http://trove.nla.gov.au/newspaper/page/24100077 | 24100077 | |
4963 | 4963 | 1900-04-14 | 2 | f | A type of big snake and other strange animals in the ocean off South Africa. | America | http://trove.nla.gov.au/newspaper/page/24102767 | 24102767 | |
22443 | 22443 | 1910-03-05 | 2 | a-b | A warning notice to Ye En from Huang Shichu and other members of the Chinese Empire Reform Association in America. | America | http://trove.nla.gov.au/newspaper/page/26802544 | 26802544 | |
4519 | 4519 | 1900-01-27 | 2 | f | A well in America blew out blue soil. | America | http://trove.nla.gov.au/newspaper/page/24102687 | 24102687 | |
25094 | 25094 | 1911-10-07 | 2 | d | A woman director for American Coin Bureau | A woman is promoted director for American Coin Bureau. | America | http://trove.nla.gov.au/newspaper/page/24091947 | 24091947 |
13052 | 13052 | 1904-04-16 | 2 | d | Advantages for Japanese to win the war against Russia. | America | http://trove.nla.gov.au/newspaper/page/26800415 | 26800415 | |
8635 | 8635 | 1901-09-25 | 2 | e | America had timber harvest in the Philippines. | America | http://trove.nla.gov.au/newspaper/page/24100173 | 24100173 | |
54699 | 54699 | 1934-12-01 | 2 | d | America purchases more silver from overseas. | America | http://trove.nla.gov.au/newspaper/page/24096247 | 24096247 | |
36906 | 36906 | 1921-04-30 | 2 | d | American President Harding calls for donations to famine victims in north China. | America | http://trove.nla.gov.au/newspaper/page/24093525 | 24093525 | |
48408 | 48408 | 1929-08-31 | 2 | e | American President Herbert Hoover on an international peace agreement. | America | http://trove.nla.gov.au/newspaper/page/24099341 | 24099341 | |
52433 | 52433 | 1933-01-21 | 2 | f | American President Roosevelt and his foreign policy. | America | http://trove.nla.gov.au/newspaper/page/24091090 | 24091090 | |
37959 | 37959 | 1921-12-10 | 2 | c-d | American President Warren Harding may intervene in the dispute between China and Japan over the Shandong problem. | America | http://trove.nla.gov.au/newspaper/page/24093783 | 24093783 | |
33813 | 33813 | 1918-11-16 | 2 | e | American President Wilson comments on the World War I. | America | http://trove.nla.gov.au/newspaper/page/24097502 | 24097502 | |
7748 | 7748 | 1901-05-22 | 2 | f | American President tours the country; a newspaper in New York was ordered to pay compensation for defamation. | America | http://trove.nla.gov.au/newspaper/page/24100047 | 24100047 | |
46321 | 46321 | 1927-10-22 | 2 | d | American Secretary of State on the relations with China, Japan, Manchuria and Mongolia. | America | http://trove.nla.gov.au/newspaper/page/24098568 | 24098568 | |
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 | |
47035 | 47035 | 1928-05-19 | 2 | c | American authority denies the entry of Song Qingling. | America | http://trove.nla.gov.au/newspaper/page/24098810 | 24098810 | |
46977 | 46977 | 1928-04-28 | 2 | d | American authority forbids to buy Soviet Russian currency. | America | http://trove.nla.gov.au/newspaper/page/24098776 | 24098776 | |
41190 | 41190 | 1924-03-01 | 2 | e-f | American authority issues new regulation on importation of Chinese products. | America | http://trove.nla.gov.au/newspaper/page/24100632 | 24100632 | |
41222 | 41222 | 1924-03-08 | 2 | e | American businessman offers awards for world peace. | America | http://trove.nla.gov.au/newspaper/page/24100640 | 24100640 | |
55682 | 55682 | 1935-12-28 | 2 | a | American businessmen sell oil to Italy. | America | http://trove.nla.gov.au/newspaper/page/24096696 | 24096696 | |
48256 | 48256 | 1929-07-06 | 2 | f | American charity organisations donate to the famine areas in north China, report by Wu Chaoshu. | America | http://trove.nla.gov.au/newspaper/page/24099272 | 24099272 | |
47478 | 47478 | 1928-10-13 | 2 | c | American doctor on the control of population growth. | America | http://trove.nla.gov.au/newspaper/page/24098978 | 24098978 | |
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 | |
32852 | 32852 | 1918-01-12 | 2 | f | American farmers meet and request the government to employ some Chinese labourers. | America | http://trove.nla.gov.au/newspaper/page/24097131 | 24097131 | |
45655 | 45655 | 1927-04-30 | 2 | c | American government and the international disarmament conference. | America | http://trove.nla.gov.au/newspaper/page/24101964 | 24101964 | |
45553 | 45553 | 1927-03-19 | 2 | d | American government announces its China policy and the specific issues. | America | http://trove.nla.gov.au/newspaper/page/24101916 | 24101916 | |
8703 | 8703 | 1901-10-02 | 2 | e | American government considers compensating the Chinese community for burning the houses to ashes during the epidemic period. | America | http://trove.nla.gov.au/newspaper/page/24100181 | 24100181 | |
5978 | 5978 | 1900-09-01 | 2 | f | American government delays their compensation for burning down the houses in Chinese community. | America | http://trove.nla.gov.au/newspaper/page/24102931 | 24102931 | |
10588 | 10588 | 1902-05-14 | 2 | e | American government has agreed to compensate the Chinese community in Honolulu for burning their houses during the period of epidemic. The compensation will be paid in instalments. | America | http://trove.nla.gov.au/newspaper/page/24100424 | 24100424 | |
46034 | 46034 | 1927-08-13 | 2 | f | American government has not yet finalised its China policy. | America | http://trove.nla.gov.au/newspaper/page/24098488 | 24098488 | |
49990 | 49990 | 1931-02-14 | 2 | d | American government implements stricter restrictions on foreign immigration. | America | http://trove.nla.gov.au/newspaper/page/24090272 | 24090272 | |
9682 | 9682 | 1902-01-25 | 2 | f | American government imposes stricter regulations to ban Chinese entry, a plea from Chinese communities in America to Chinese government, Guangdong governor and Chinese ambassador to Washington for help. | America | http://trove.nla.gov.au/newspaper/page/24100311 | 24100311 | |
8806 | 8806 | 1901-10-12 | 2 | e | American government prohibits Chinese going to other countries via the United States. | America | http://trove.nla.gov.au/newspaper/page/24100193 | 24100193 | |
51884 | 51884 | 1932-09-10 | 2 | d | American government punishes illegal businessmen. | America | http://trove.nla.gov.au/newspaper/page/24090938 | 24090938 | |
45711 | 45711 | 1927-05-14 | 2 | f | American government sends envoy to investigate agriculture in China. | America | http://trove.nla.gov.au/newspaper/page/24101984 | 24101984 | |
10078 | 10078 | 1902-03-22 | 2 | f | American government sent 10 children to learn Chinese in their Beijing embassy. | America | http://trove.nla.gov.au/newspaper/page/24100364 | 24100364 | |
37145 | 37145 | 1921-06-25 | 2 | d | American government will not support Sun Yatsen. | America | http://trove.nla.gov.au/newspaper/page/24093589 | 24093589 | |
5791 | 5791 | 1900-08-01 | 2 | f | American law now effective in Honolulu. | America | http://trove.nla.gov.au/newspaper/page/24102894 | 24102894 | |
46976 | 46976 | 1928-04-28 | 2 | d | American medical professor studies Chinese traditional medicine. | America | http://trove.nla.gov.au/newspaper/page/24098776 | 24098776 | |
29364 | 29364 | 1914-11-07 | 2 | d | American newspaper and its report from Beijing on the China affairs (Japanese troops in Longkou, of Shandong province, and others). | America | http://trove.nla.gov.au/newspaper/page/24093312 | 24093312 | |
37696 | 37696 | 1921-10-15 | 2 | c | American newspaper comments on the Washington Conference and its possible influence upon China. | America | http://trove.nla.gov.au/newspaper/page/24093719 | 24093719 | |
49271 | 49271 | 1930-06-28 | 2 | e | American people are closely watching the business in Shanghai. | America | http://trove.nla.gov.au/newspaper/page/24099683 | 24099683 | |
45656 | 45656 | 1927-04-30 | 2 | c | American people on their government's China policy. | America | http://trove.nla.gov.au/newspaper/page/24101964 | 24101964 | |
45729 | 45729 | 1927-05-21 | 2 | d | American senator comes to visit China. | America | http://trove.nla.gov.au/newspaper/page/24101992 | 24101992 | |
34985 | 34985 | 1919-10-18 | 2 | d-e | American senator opposes to the resolution on Shandong province passed at the Paris Peace Conference. | America | http://trove.nla.gov.au/newspaper/page/24097900 | 24097900 | |
26913 | 26913 | 1913-01-25 | 2 | d | American women equal right committee member calls for imitation of Chinese women clothing. | America | http://trove.nla.gov.au/newspaper/page/24092553 | 24092553 | |
37996 | 37996 | 1921-12-17 | 2 | c-d | American's attitude towards China at the Washington Conference. | America | http://trove.nla.gov.au/newspaper/page/24093791 | 24093791 | |
49989 | 49989 | 1931-02-14 | 2 | d | American-born Chinese Liu Chengji of New York wins more medals than any other American soldiers for his bravery during the World War I. | America | http://trove.nla.gov.au/newspaper/page/24090272 | 24090272 | |
13450 | 13450 | 1904-07-02 | 2 | d | An American journalist reports and comments on morale of Japanese people and the yellow peril. | America | http://trove.nla.gov.au/newspaper/page/26800470 | 26800470 | |
9161 | 9161 | 1901-11-23 | 2 | e | An American man seeks a partner through a newspaper. | America | http://trove.nla.gov.au/newspaper/page/24100241 | 24100241 | |
36825 | 36825 | 1921-04-09 | 2 | c | An American senator proposed that the government should help transport grain donations to the famine region in north China. | America | http://trove.nla.gov.au/newspaper/page/24093501 | 24093501 | |
6455 | 6455 | 1900-11-17 | 2 | f | An American ship sank into the ocean. | America | http://trove.nla.gov.au/newspaper/page/24103017 | 24103017 | |
8107 | 8107 | 1901-07-06 | 2 | d | An American ship struck a rock. | America | http://trove.nla.gov.au/newspaper/page/24100101 | 24100101 | |
49712 | 49712 | 1930-11-22 | 2 | d | An aeroplane is detained on the border of America and Mexico for carrying Chinese immigrants illegally into America. | America | http://trove.nla.gov.au/newspaper/page/24099854 | 24099854 | |
10079 | 10079 | 1902-03-22 | 2 | f | An anarchist party praised the man who murdered President McKinley, of the United States. | America | http://trove.nla.gov.au/newspaper/page/24100364 | 24100364 | |
46699 | 46699 | 1928-02-04 | 2 | b-c | An article selected from Chicago Tribune says America should not maintain its privileges in China by force, and should seek friendship relations with China. | America | http://trove.nla.gov.au/newspaper/page/24098680 | 24098680 | |
10363 | 10363 | 1902-04-19 | 2 | f | An article, selected from the New China Times in Honolulu, warns overseas Xiangshan fellows the Portuguese have attempted to take control of their home county. | America | http://trove.nla.gov.au/newspaper/page/24100396 | 24100396 | |
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 | |
14052 | 14052 | 1904-12-10 | 2 | a-b | An editorial, selected from a Chinese newspaper in Hawaii, comments on the practice of cutting pigtails and changes to dress in China. | America | http://trove.nla.gov.au/newspaper/page/26800585 | 26800585 | |
6858 | 6858 | 1901-01-16 | 2 | e | An orphanage in New York was on fire. | America | http://trove.nla.gov.au/newspaper/page/24099918 | 24099918 | |
29743 | 29743 | 1915-03-13 | 2 | d | Anti-Yuan parties in America decide to help Yuan Shikai fight against foreign invasion. | America | http://trove.nla.gov.au/newspaper/page/24094769 | 24094769 | |
52388 | 52388 | 1933-01-07 | 2 | f | Army veterans in America and their protest. | America | http://trove.nla.gov.au/newspaper/page/24091074 | 24091074 |
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]);