This data as json, CSV (advanced)
Suggested facets: page, date (date)
Link | rowid | date | page | column ▼ | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
4838 | 4838 | 1900-03-28 | 2 | a-c | Liang Qichao's letter replying to the Chinese Society in San Francisco in regard to his security concern. | America | http://trove.nla.gov.au/newspaper/page/24102747 | 24102747 | |
5142 | 5142 | 1900-05-05 | 2 | a-c | Yang Gu, China's consul to Honolulu, issues a notice advising the Chinese community to stay away from Chinese Empire Reform Association. This article, written by anonymous author, comments on this notice. | America | http://trove.nla.gov.au/newspaper/page/24102792 | 24102792 | |
5737 | 5737 | 1900-07-25 | 2 | a-c | A letter from Chinese Empire Reform Association in San Francisco, America, to Li Hongzhang, Governor of Guangdong. | America | http://trove.nla.gov.au/newspaper/page/24102886 | 24102886 | |
22317 | 22317 | 1910-01-29 | 2 | a-c | Second and final part of the petition from the Chinese Empire Reform Association in America suggests that the ban on gambling should be completed before any fundraising for naval rebuilding. | America | http://trove.nla.gov.au/newspaper/page/26802480 | 26802480 | |
33743 | 33743 | 1918-10-19 | 6 | a-c | The murder and robbery in Xiangshan county, Guangdong. | America | http://trove.nla.gov.au/newspaper/page/24097474 | 24097474 | |
34901 | 34901 | 1919-09-20 | 3 | a-c | American parliament debates China policy. | America | http://trove.nla.gov.au/newspaper/page/24097867 | 24097867 | |
38397 | 38397 | 1922-03-11 | 3 | a-c | American Secretary of State Charles Hughes talks Shandong issues to the Washington Conference. | America | http://trove.nla.gov.au/newspaper/page/24093895 | 24093895 | |
44125 | 44125 | 1925-11-14 | 6 | a-c | American and Chinese Association (mei guo yuan hua hui) in San Francisco issues a declaration on the China affairs. | America | http://trove.nla.gov.au/newspaper/page/24101353 | 24101353 |
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]);