This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid | date | page | column | title | description ▼ | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
30550 | 30550 | 1915-10-09 | 2-3 | d-a | Pacific Post and Shipping Company in America is to be bought by Chinese capital and to be a Chinese New Pacific Shipping Company. Feng Sui is now negotiating with the company leaders now. | America | http://trove.nla.gov.au/newspaper/page/24095011 | 24095011 | |
38093 | 38093 | 1922-01-07 | 2-3 | d-a | American Secretary of State talks about China problem at the Washington Conference. | America | http://trove.nla.gov.au/newspaper/page/24093815 | 24093815 | |
37407 | 37407 | 1921-08-06 | 2-3 | d-a | Chinese ambassador to Washington Shi Zhaoji explains to American businessmen in New Jersey why China opposes to the Anglo-Japanese Alliance. | America | http://trove.nla.gov.au/newspaper/page/24093637 | 24093637 | |
19278 | 19278 | 1908-05-02 | 2-3 | d-a | Correspondence from America. Chinese communities in the United States support the boycott to Japanese goods. | America | http://trove.nla.gov.au/newspaper/page/26801718 | 26801718 | |
38634 | 38634 | 1922-04-29 | 2-3 | f-a | Dr John Dewey on the Open Door policy in China. | America | http://trove.nla.gov.au/newspaper/page/24093952 | 24093952 | |
36729 | 36729 | 1921-03-19 | 2-3 | d-a | Japanese ambassador to London talks about the Shandong problem. | America | http://trove.nla.gov.au/newspaper/page/24093477 | 24093477 | |
23012 | 23012 | 1910-06-25 | 2-3 | b-a | Miscellaneous report on Prince Zai Tao's visit to America. Photograph of the delegation in San Francisco with local officials, Welcome by the Chinese communities in San Francisco, New York and other cities. | America | http://trove.nla.gov.au/newspaper/page/26802674 | 26802674 | |
13889 | 13889 | 1904-10-08 | 2-3 | d | Number of population in Hawaii. Number of local residents, Chinese, Japanese, Portuguese, black people, and others. | America | http://trove.nla.gov.au/newspaper/page/26800540 | 26800540 | |
30494 | 30494 | 1915-09-25 | 2-3 | d-a | Qi Xuan, a Chinese student in America, invents a Chinese typewriter which ranks the first in the world. | America | http://trove.nla.gov.au/newspaper/page/24094995 | 24094995 | |
38563 | 38563 | 1922-04-15 | 2-3 | f-a | Shi Zhaoji on the achievements of the Washington Conference. | America | http://trove.nla.gov.au/newspaper/page/24093936 | 24093936 |
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]);