This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
23158 | 23158 | 1910-07-16 | 6 | a | Some Chinese businessmen in San Francisco call for a boycott to American goods in protest against their discrimination against Chinese immigrants. | America | http://trove.nla.gov.au/newspaper/page/26802702 | 26802702 | |
23159 | 23159 | 1910-07-16 | 6 | a-b | Deposed King of Persia Mohammad 'Ali Shah is now a mild man. Queen of Hawaii seeks compensation from American government. | Other... | http://trove.nla.gov.au/newspaper/page/26802702 | 26802702 | |
23160 | 23160 | 1910-07-16 | 6 | b | Prince Regent considers pardoning reformers of the 1898 Reform Movement. | China | http://trove.nla.gov.au/newspaper/page/26802702 | 26802702 | |
23161 | 23161 | 1910-07-16 | 6 | b | Revolutionary posters in Beijing and their plan to rebellion in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/26802702 | 26802702 | |
23162 | 23162 | 1910-07-16 | 6 | b | Chinese businessman from Nanyang, Liang Bingnong, purchases the first entry ticket of the National Industrial Exposition in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/26802702 | 26802702 | |
23163 | 23163 | 1910-07-16 | 6 | b | Prince Su urges to set up national parliament. | China | http://trove.nla.gov.au/newspaper/page/26802702 | 26802702 | |
23164 | 23164 | 1910-07-16 | 6 | b | Message from priest/ Extracts of the New Testament. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802702 | 26802702 |
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]);