This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
16036 | 16036 | 1906-08-11 | 5 | c | Article written by Kang Youwei in memory of Xu Weijing, a Chinese businessman in Victoria, Canada, who starts the Chinese Empire Reform Association there. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801054 | 26801054 | |
16037 | 16037 | 1906-08-11 | 5 | c | Chinese communities in Mexico enthusiastically donate to the Guangdong Public school. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801054 | 26801054 | |
16038 | 16038 | 1906-08-11 | 5 | c | Chinese community in London, Ontario, Canada, to set up a branch of the Chinese Empire Reform Association, and an open letter from them. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801054 | 26801054 | |
16039 | 16039 | 1906-08-11 | 5 | c | Third part of the new American immigration law specifically for Chinese. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801054 | 26801054 |
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]);