This data as json, CSV (advanced)
Link | rowid | date | page | column ▲ | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
38853 | 38853 | 1922-06-10 | 3 | f | Old parliament of the Republic of China may be convened again. | America | http://trove.nla.gov.au/newspaper/page/24094001 | 24094001 | |
38855 | 38855 | 1922-06-10 | 3 | f | Wu Peifu's attitude towards Sun Yatsen. | America | http://trove.nla.gov.au/newspaper/page/24094001 | 24094001 | |
38890 | 38890 | 1922-06-17 | 3 | f | Zhang Zuolin is required to withdraw his troops within three days. | America | http://trove.nla.gov.au/newspaper/page/24094009 | 24094009 | |
38891 | 38891 | 1922-06-17 | 3 | f | Assassination in Mexico. | America | http://trove.nla.gov.au/newspaper/page/24094009 | 24094009 | |
38920 | 38920 | 1922-06-24 | 3 | f | Fire in the Long Island, New York. | America | http://trove.nla.gov.au/newspaper/page/24094017 | 24094017 | |
38921 | 38921 | 1922-06-24 | 3 | f | Representatives from three northeastern provinces meet in Fengtian and declare self-government. | America | http://trove.nla.gov.au/newspaper/page/24094017 | 24094017 | |
38964 | 38964 | 1922-11-04 | 3 | f | Red Army enters Hunchun following the withdrawal of Japanese troops. | America | http://trove.nla.gov.au/newspaper/page/24094169 | 24094169 | |
38965 | 38965 | 1922-11-04 | 3 | f | Japan suggests for a Pacific conference on the immigration issues. | America | http://trove.nla.gov.au/newspaper/page/24094169 | 24094169 | |
39000 | 39000 | 1922-11-11 | 3 | f | Bandits in America hijack a train. | America | http://trove.nla.gov.au/newspaper/page/24094179 | 24094179 | |
39024 | 39024 | 1922-11-18 | 3 | f | A ship on fire in the Yangtze River. | America | http://trove.nla.gov.au/newspaper/page/24094187 | 24094187 | |
39299 | 39299 | 1923-01-20 | 3 | f | Current situation in Guangdong and the payment of Boxer Indemnity. | America | http://trove.nla.gov.au/newspaper/page/24094259 | 24094259 | |
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 | |
39363 | 39363 | 1923-02-03 | 3 | f | Envoy of Lenin's Soviet Russian government, Adolf Joffe, talks with Sun Yatsen in Shanghai and a joint communique issued on communist movement in China. | America | http://trove.nla.gov.au/newspaper/page/24094275 | 24094275 | |
39394 | 39394 | 1923-02-10 | 3 | f | Russian refugees arrive the Philippines. | America | http://trove.nla.gov.au/newspaper/page/24094285 | 24094285 | |
39395 | 39395 | 1923-02-10 | 3 | f | How the British government use the Boxer Indemnity paid by China. | America | http://trove.nla.gov.au/newspaper/page/24094285 | 24094285 | |
39667 | 39667 | 1923-03-31 | 3 | f | Japan wants to expand its forces in China. | America | http://trove.nla.gov.au/newspaper/page/24094350 | 24094350 | |
39668 | 39668 | 1923-03-31 | 3 | f | Disarmament in Japan and the aftermath. | America | http://trove.nla.gov.au/newspaper/page/24094350 | 24094350 | |
39669 | 39669 | 1923-03-31 | 3 | f | New York bank lends to Japanese government for their administration in Korea. | America | http://trove.nla.gov.au/newspaper/page/24094350 | 24094350 | |
39789 | 39789 | 1923-04-28 | 3 | f | Shopkeepers on strike in Xiamen (Amoy), Fujian. | America | http://trove.nla.gov.au/newspaper/page/24094383 | 24094383 | |
39868 | 39868 | 1923-05-19 | 3 | f | Chinese Premier Zhang Shaozeng has fled Beijing. | America | http://trove.nla.gov.au/newspaper/page/24094407 | 24094407 | |
39869 | 39869 | 1923-05-19 | 3 | f | American Secretary of State to convene a Beijing conference to assess legal improvement in China. | America | http://trove.nla.gov.au/newspaper/page/24094407 | 24094407 | |
39894 | 39894 | 1923-05-26 | 3 | f | Miscellaneous report on the kidnap of foreign train passengers in Shandong province. | America | http://trove.nla.gov.au/newspaper/page/24094415 | 24094415 | |
39951 | 39951 | 1923-06-09 | 3 | f | Negotiation over the kidnap of foreign train passengers in Shandong province. | America | http://trove.nla.gov.au/newspaper/page/24094431 | 24094431 | |
39953 | 39953 | 1923-06-09 | 3 | f | Soviet Russian authority detains Japanese fishing boat. | America | http://trove.nla.gov.au/newspaper/page/24094431 | 24094431 | |
40501 | 40501 | 1923-10-06 | 3 | f | A train falls into river in storm (America). | America | http://trove.nla.gov.au/newspaper/page/24094567 | 24094567 | |
41470 | 41470 | 1924-04-26 | 3 | f | Statistics on suicide in America. | America | http://trove.nla.gov.au/newspaper/page/24100695 | 24100695 | |
41568 | 41568 | 1924-05-17 | 3 | f | American senators oppose to the postpone of ban on Japanese immigrant. | America | http://trove.nla.gov.au/newspaper/page/24100720 | 24100720 | |
41628 | 41628 | 1924-05-31 | 3 | f | A child hostage is murdered in Chicago. | America | http://trove.nla.gov.au/newspaper/page/24100736 | 24100736 | |
41749 | 41749 | 1924-06-28 | 3 | f | Anti-Japanese emotions in America. | America | http://trove.nla.gov.au/newspaper/page/24100768 | 24100768 | |
42528 | 42528 | 1925-01-03 | 3 | f | A British ship is detained by American authority for wine smuggling. | America | http://trove.nla.gov.au/newspaper/page/24100986 | 24100986 | |
42598 | 42598 | 1925-01-17 | 3 | f | Ghost chases a man in San Francisco. | America | http://trove.nla.gov.au/newspaper/page/24101002 | 24101002 | |
42738 | 42738 | 1925-02-21 | 3 | f | Heavy fog in New York and the accident. | America | http://trove.nla.gov.au/newspaper/page/24101033 | 24101033 | |
42743 | 42743 | 1925-02-21 | 3 | f | American naval fleet comes to visit Australia. | America | http://trove.nla.gov.au/newspaper/page/24101033 | 24101033 | |
42848 | 42848 | 1925-03-14 | 3 | f | American naval fleet on the way to visit Australia. | America | http://trove.nla.gov.au/newspaper/page/24101061 | 24101061 | |
45171 | 45171 | 1926-09-25 | 3 | f | American's view on the future war with Japan. | America | http://trove.nla.gov.au/newspaper/page/24101719 | 24101719 | |
45261 | 45261 | 1926-10-30 | 3 | f | The world chemistry conference in Philadelphia. | America | http://trove.nla.gov.au/newspaper/page/24101759 | 24101759 | |
45386 | 45386 | 1926-12-25 | 3 | f | The birthplace of George Washington found. | America | http://trove.nla.gov.au/newspaper/page/24101823 | 24101823 | |
45387 | 45387 | 1926-12-25 | 3 | f | American government on the proposed revision of treaties with China. | America | http://trove.nla.gov.au/newspaper/page/24101823 | 24101823 | |
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 | |
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 | |
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 | |
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 | |
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 | |
49530 | 49530 | 1930-09-27 | 2 | f | Cars and murders in America. | America | http://trove.nla.gov.au/newspaper/page/24099790 | 24099790 | |
49789 | 49789 | 1930-12-13 | 2 | f | Homeless people in New York and the relief work. | America | http://trove.nla.gov.au/newspaper/page/24099878 | 24099878 | |
51769 | 51769 | 1932-08-06 | 2 | f | Japanese seek recognition from American government of the Manchuria state. | America | http://trove.nla.gov.au/newspaper/page/24090896 | 24090896 | |
52388 | 52388 | 1933-01-07 | 2 | f | Army veterans in America and their protest. | America | http://trove.nla.gov.au/newspaper/page/24091074 | 24091074 | |
52433 | 52433 | 1933-01-21 | 2 | f | American President Roosevelt and his foreign policy. | America | http://trove.nla.gov.au/newspaper/page/24091090 | 24091090 | |
53996 | 53996 | 1934-03-24 | 3 | f | American government maintain the silver price. | America | http://trove.nla.gov.au/newspaper/page/24091572 | 24091572 | |
54219 | 54219 | 1934-06-09 | 3 | f | Repayment of war loans to America. | America | http://trove.nla.gov.au/newspaper/page/24096043 | 24096043 | |
54373 | 54373 | 1934-07-28 | 3 | f | American weapon export to China and Japan. | America | http://trove.nla.gov.au/newspaper/page/24096099 | 24096099 | |
54514 | 54514 | 1934-09-15 | 3 | f | Republican Party in America criticises the policy of President Roosevelt. | America | http://trove.nla.gov.au/newspaper/page/24096157 | 24096157 | |
54532 | 54532 | 1934-09-22 | 3 | f | Japan may give up its naval agreement signed with America. | America | http://trove.nla.gov.au/newspaper/page/24096165 | 24096165 | |
32386 | 32386 | 1917-06-16 | 3 | e-f | Japan will not interfere with the chaos in China. Zhang Xun enters Beijing with his troops. The chaos in China may be pacified. | America | http://trove.nla.gov.au/newspaper/page/24095728 | 24095728 | |
34193 | 34193 | 1919-02-22 | 3 | e-f | War clouds over China and Japan. | America | http://trove.nla.gov.au/newspaper/page/24097619 | 24097619 | |
34670 | 34670 | 1919-07-12 | 3 | e-f | Britain, France, Italy, Japan and America are trying to mediate the conflicts in China between the south and the north. | America | http://trove.nla.gov.au/newspaper/page/24097783 | 24097783 | |
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 | |
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 | |
37843 | 37843 | 1921-11-12 | 3 | e-f | Japanese Prime Minister Hara Takashi is assassinated. | America | http://trove.nla.gov.au/newspaper/page/24093750 | 24093750 | |
37878 | 37878 | 1921-11-19 | 3 | e-f | Proposal for disarmament at the Washington Conference. | America | http://trove.nla.gov.au/newspaper/page/24093758 | 24093758 | |
38038 | 38038 | 1921-12-24 | 3 | e-f | Discussion at the Washington Conference on the Chinese, especially Shandong problems. | America | http://trove.nla.gov.au/newspaper/page/24093798 | 24093798 | |
38102 | 38102 | 1922-01-07 | 3 | e-f | Washing Conference and the disarmament. Thorny problems at the Conference. | America | http://trove.nla.gov.au/newspaper/page/24093814 | 24093814 | |
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 | |
40463 | 40463 | 1923-09-29 | 3 | e-f | American newspaper reports the battle in Changsha, capital of Hunan province. | America | http://trove.nla.gov.au/newspaper/page/24094559 | 24094559 | |
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 | |
41537 | 41537 | 1924-05-10 | 3 | e-f | Germany builds huge submarine. | America | http://trove.nla.gov.au/newspaper/page/24100712 | 24100712 | |
41664 | 41664 | 1924-06-07 | 3 | e-f | Korean people try to bombard British and American consulates in Seoul. | America | http://trove.nla.gov.au/newspaper/page/24100744 | 24100744 | |
45542 | 45542 | 1927-03-12 | 3 | e-f | A survey on the rich and single women in America. | America | http://trove.nla.gov.au/newspaper/page/24101907 | 24101907 | |
4842 | 4842 | 1900-03-28 | 2 | e | China and Mexico conclud a treaty of commerce in Washington. | America | http://trove.nla.gov.au/newspaper/page/24102747 | 24102747 | |
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 | |
5620 | 5620 | 1900-07-07 | 2 | e | George Picasso, a famous lawyer in Honolulu, entertained Liang Qichao for his patriotism. | America | http://trove.nla.gov.au/newspaper/page/24102866 | 24102866 | |
5928 | 5928 | 1900-08-25 | 2 | e | Liang Qichao leaves Honolulu for Japan. | America | http://trove.nla.gov.au/newspaper/page/24102923 | 24102923 | |
5951 | 5951 | 1900-08-29 | 2 | e | Several Chinese women in Honolulu join the Chinese Empire Reform Association. They are very active members. | America | http://trove.nla.gov.au/newspaper/page/24102927 | 24102927 | |
6403 | 6403 | 1900-11-07 | 2 | e | A pharmacy shop in New York exploded. | America | http://trove.nla.gov.au/newspaper/page/24103008 | 24103008 | |
6405 | 6405 | 1900-11-07 | 2 | e | Japanese in Honolulu organise a demonstration to demand compensation from American government for burning down their houses during the epidemic. | America | http://trove.nla.gov.au/newspaper/page/24103008 | 24103008 | |
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 | |
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 | |
7373 | 7373 | 1901-04-03 | 2 | e | Tornado disasters in Alabama, United States. | America | http://trove.nla.gov.au/newspaper/page/24099992 | 24099992 | |
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 | |
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 | |
8138 | 8138 | 1901-07-13 | 2 | e | Chinese student in America Tan Yali comments the chaos in China. | America | http://trove.nla.gov.au/newspaper/page/24100106 | 24100106 | |
8195 | 8195 | 1901-07-20 | 2 | e | Heat wave hit New York. | America | http://trove.nla.gov.au/newspaper/page/24100114 | 24100114 | |
8250 | 8250 | 1901-07-27 | 2 | e | Mr Liang, a Chinese in America, was not allowed to reunion with his son coming from China. | America | http://trove.nla.gov.au/newspaper/page/24100122 | 24100122 | |
8276 | 8276 | 1901-07-31 | 2 | e | Li Hongzhang seeks help from American Chinese community for the famine area of Shaanxi. | America | http://trove.nla.gov.au/newspaper/page/24100126 | 24100126 | |
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 | |
8371 | 8371 | 1901-08-17 | 2 | e | Chinese will be banned to enter Cuba which is now under control of America. | America | http://trove.nla.gov.au/newspaper/page/24100140 | 24100140 | |
8424 | 8424 | 1901-08-27 | 2 | e | Sun Yatsen is on the way from Honolulu to China. | America | |||
8496 | 8496 | 1901-09-04 | 2 | e | Every Chinese is going to be thoroughly searched when entering Honolulu for suspected tobacco smuggling. | America | http://trove.nla.gov.au/newspaper/page/24100156 | 24100156 | |
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 | |
8635 | 8635 | 1901-09-25 | 2 | e | America had timber harvest in the Philippines. | America | http://trove.nla.gov.au/newspaper/page/24100173 | 24100173 | |
8636 | 8636 | 1901-09-25 | 2 | e | Population in Honolulu. | America | http://trove.nla.gov.au/newspaper/page/24100173 | 24100173 | |
8667 | 8667 | 1901-09-28 | 2 | e | Chinese ambassador to America, Wu Tingfang, demands compensation from American government for their damages to Chinese properties in Hawaii. | America | http://trove.nla.gov.au/newspaper/page/24100177 | 24100177 | |
8702 | 8702 | 1901-10-02 | 2 | e | Sun Yatsen was detained by customs officers on arrival in San Francisco. Chinese ambassador Wu Tingfang requests the American government send him to China. He was released after a few weeks. | America | http://trove.nla.gov.au/newspaper/page/24100181 | 24100181 | |
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 | |
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 | |
8794 | 8794 | 1901-10-09 | 3 | e | Many people in America request severely punishing the man who murdered President McKinley. | America | http://trove.nla.gov.au/newspaper/page/24100188 | 24100188 | |
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 | |
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 | |
8833 | 8833 | 1901-10-16 | 2 | e | Residents of Boston donated to the fund of ransom money needed to secure the freedom of a female American missionary. | America | http://trove.nla.gov.au/newspaper/page/24100197 | 24100197 | |
8835 | 8835 | 1901-10-16 | 2 | e | A bridge in New York collapsed. | America | http://trove.nla.gov.au/newspaper/page/24100197 | 24100197 |
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]);