This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
18217 | 18217 | 1907-10-05 | 2 | c-d | Chaos in Guangxi and Jiangxi provinces. British gunboat on the way to Guangxi to protect British consulate. Italian missionary is murdered in the Jiangxi chaos. | Britain | http://trove.nla.gov.au/newspaper/page/26801492 | 26801492 | |
18225 | 18225 | 1907-10-05 | 3 | c | Long Live the Yellow people. Yuan Shikai proposes specifically to abolish the boundary between Manchurian and Han people by withdrawing all Manchurian garrison from local China. And comments by Tung Wah Times. | Britain | http://trove.nla.gov.au/newspaper/page/26801491 | 26801491 |
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]);