This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
19403 | 19403 | 1908-05-30 | 2 | c-d | Beijing news. Gentry in Yunnan province appeal to abolish treaty with French company on the exploitation of mining resources in Yunnan. Imperial scholar Xu Zexin and others oppose imperial commissioner of Guizhou Lu Hongshu's attempt to apply for loans from French company. Mining in Guizhou and involvement of British companies. Beiyang minister to be removed. Chinese government seeks to regain its rights of inland navigation. | China | http://trove.nla.gov.au/newspaper/page/26801750 | 26801750 | |
19418 | 19418 | 1908-05-30 | 3 | c-d | American parliamentarian Harrison talks about possible threat from Japan. | America | http://trove.nla.gov.au/newspaper/page/26801749 | 26801749 |
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]);