This data as json, CSV (advanced)
Suggested facets: page, date (date)
Link | rowid | date | page | column ▼ | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
8738 | 8738 | 1901-10-05 | 2 | b-d | The first part of a letter, prepared by Huang Liang, Zhong Muxian and the Chinese Empire Reform Association in Honolulu, to Tao Mo, governor of Guangdong province. | America | http://trove.nla.gov.au/newspaper/page/24100185 | 24100185 | |
9591 | 9591 | 1902-01-15 | 3 | b-d | First part of the report on the first rally of Chinese community in Honolulu to protest against Portuguese occupation of Xiangshan. Speeches and speakers at the rally. | America | http://trove.nla.gov.au/newspaper/page/24100298 | 24100298 | |
9624 | 9624 | 1902-01-18 | 3 | b-d | Second part of the report on the first rally of Chinese community in Honolulu to protest against Portuguese occupation of Xiangshan. Speeches and speakers at the rally. | America | http://trove.nla.gov.au/newspaper/page/24100302 | 24100302 | |
18601 | 18601 | 1907-12-07 | 8 | b-d | First part of report on a Chinese community in San Francisco's fight for equal opportunity in education between Chinese and other school children. | America | http://trove.nla.gov.au/newspaper/page/26801570 | 26801570 | |
41809 | 41809 | 1924-07-12 | 6 | b-d | The new restriction issued by American authority to the Chinese immigrant. | America | http://trove.nla.gov.au/newspaper/page/24100789 | 24100789 | |
44176 | 44176 | 1925-11-28 | 3 | b-d | American Secretary of State Frank B. Kellogg speaks in Detroit on the China policy (general policy, rate of tariff, consular jurisdiction and others). | America | http://trove.nla.gov.au/newspaper/page/24101364 | 24101364 |
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]);