This data as json, CSV (advanced)
Suggested facets: page, date (date)
Link | rowid | date | page | column | title | description ▼ | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
37875 | 37875 | 1921-11-19 | 3 | d-e | Adviser of the Chinese government comments on the Anglo-Japanese alliance before the opening of the Washington Conference. | America | http://trove.nla.gov.au/newspaper/page/24093758 | 24093758 | |
40747 | 40747 | 1923-12-01 | 3 | d-e | American army has new weapons. | America | http://trove.nla.gov.au/newspaper/page/24094631 | 24094631 | |
41983 | 41983 | 1924-08-23 | 3 | d-e | American donations to the flooding areas in Henan, Hunan, Anhui and Guangdong provinces in China. | America | http://trove.nla.gov.au/newspaper/page/24100832 | 24100832 | |
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 | |
39759 | 39759 | 1923-04-21 | 3 | d-e | China's naval fleet. | America | http://trove.nla.gov.au/newspaper/page/24094375 | 24094375 | |
40955 | 40955 | 1924-01-19 | 3 | d-e | Chinese President Cao Kun appoints Sun Baoqi new premier of China who has organised a new cabinet. | America | http://trove.nla.gov.au/newspaper/page/24100573 | 24100573 | |
9625 | 9625 | 1902-01-18 | 3 | d-e | Chinese Wu Wenhua in Honolulu has been licensed to practise law. | America | http://trove.nla.gov.au/newspaper/page/24100302 | 24100302 | |
38399 | 38399 | 1922-03-11 | 3 | d-e | Chinese and Japanese sailors are arrested in Taiwan for hijack attempt. | America | http://trove.nla.gov.au/newspaper/page/24093895 | 24093895 | |
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 | |
40980 | 40980 | 1924-01-26 | 2 | d-e | Foreign (American) newspapers report the presidential election in China. | America | http://trove.nla.gov.au/newspaper/page/24100582 | 24100582 | |
35150 | 35150 | 1919-12-20 | 2 | d-e | Further report on the political changes in China. | America | http://trove.nla.gov.au/newspaper/page/24097976 | 24097976 | |
37740 | 37740 | 1921-10-22 | 3 | d-e | Japan seeks American assistance to solve the Shandong problem. | America | http://trove.nla.gov.au/newspaper/page/24093726 | 24093726 | |
39977 | 39977 | 1923-06-16 | 3 | d-e | Japanese authority adopts harsh policy towards Communist activists. | America | http://trove.nla.gov.au/newspaper/page/24094439 | 24094439 | |
32832 | 32832 | 1918-01-05 | 2 | d-e | Japanese envoy speaks in New York and his insulting words on China. | America | http://trove.nla.gov.au/newspaper/page/24097123 | 24097123 | |
40496 | 40496 | 1923-10-06 | 3 | d-e | Japanese government appropriates money for disaster relief in the earthquake stricken area. And report on the earthquake refugees. | America | http://trove.nla.gov.au/newspaper/page/24094567 | 24094567 | |
40013 | 40013 | 1923-06-23 | 3 | d-e | President Li Yuanhong flees Beijing and has arrived Tianjin. | America | http://trove.nla.gov.au/newspaper/page/24094447 | 24094447 | |
4841 | 4841 | 1900-03-28 | 2 | d-e | Reports on the epidemic in Honolulu and casualties of the Chinese communities there. | America | http://trove.nla.gov.au/newspaper/page/24102747 | 24102747 | |
38469 | 38469 | 1922-03-25 | 3 | d-e | Russian authority to withdraw their troops from Mongolia. | America | http://trove.nla.gov.au/newspaper/page/24093911 | 24093911 | |
41268 | 41268 | 1924-03-15 | 6 | d-e | The Philippines island and the obvious influence of Chinese culture, observed by American professor. | America | http://trove.nla.gov.au/newspaper/page/24100652 | 24100652 | |
38298 | 38298 | 1922-02-18 | 3 | d-e | The Washington Conference is closed. American President Warren Harding submits the treaty to the Parliament. | America | http://trove.nla.gov.au/newspaper/page/24093871 | 24093871 | |
8394 | 8394 | 1901-08-24 | 2 | d-e | Three Chinese, Xu Shiqin, Xue Zhongying and Lu Jin'en, were detained on their arrival in San Francisco. The arrest was recommended by Chinese consul He You and Chinese ambassador Wu Tingfang. | America | http://trove.nla.gov.au/newspaper/page/24100144 | 24100144 | |
40258 | 40258 | 1923-08-18 | 3 | d-e | Zhang Zuolin's army in Manchuria suppress bandits. | America | http://trove.nla.gov.au/newspaper/page/24094511 | 24094511 |
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]);