This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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]);