This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
15975 | 15975 | 1906-07-28 | 5 | a-b | Report selected from a New York Chinese newspaper (wei xin bao) on the establishment of Mexico bank, official bank of the Chinese Empire Reform Association. Share floating and special shares. Preparation and future operation. | America | http://trove.nla.gov.au/newspaper/page/26801042 | 26801042 | |
15976 | 15976 | 1906-07-28 | 5 | b-c | Chinese communities in Australia and New Zealand donate to help Chinese victims of the San Francisco earthquake. Names listed. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801042 | 26801042 | |
15977 | 15977 | 1906-07-28 | 5 | c | Chinese ambassador to Washington Liang Zhendong notifies Shanghai business association that Chinese victims of the San Francisco earthquake are not in need of any more donations. Chinese communities in Australia will also stop donating soon. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801042 | 26801042 |
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]);