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