This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21134 | 21134 | 1909-06-12 | 3 | b-c | Beijing news/ Effort for naval rejuvenation. Volumes of books published on foreign political systems. Preparation in Hunan province for the establishment of legislature assembly. Opium to be totally banned within three years. China and Britain start negotiation on the return of Weihaiwei. The Shandong University established by German and its courses. | China | http://trove.nla.gov.au/newspaper/page/26802213 | 26802213 |
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]);