This data as json, CSV (advanced)
Suggested facets: page, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
39759 | 39759 | 1923-04-21 | 3 | d-e | China's naval fleet. | America | http://trove.nla.gov.au/newspaper/page/24094375 | 24094375 | |
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 | |
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 | |
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 | |
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 | |
40747 | 40747 | 1923-12-01 | 3 | d-e | American army has new weapons. | America | http://trove.nla.gov.au/newspaper/page/24094631 | 24094631 | |
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 | |
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 | |
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 | |
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 |
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]);