This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
8172 | 8172 | 1901-07-17 | 2 | f | Foreign missionaries in Tianjin comment on the future of China. | China | http://trove.nla.gov.au/newspaper/page/24100110 | 24100110 | |
8173 | 8173 | 1901-07-17 | 2 | f | The sixth and final part of an official note presented to Chinese government by ambassadors from America, France, Japan, Britain, Belgium, Italy, Austria, Germany and the Netherlands, which require the Chinese government to punish all those who colluded with the Boxers. A list of Chinese officials who were in collusion with the Boxers. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100110 | 24100110 |
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]);