This data as json, CSV (advanced)
description 1 ✖
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28040 | 28040 | 1913-10-25 | 3 | b-c | Beijing news/ Chinese premier order to check financial situations of each province. Education minister Wang Daxie and his policy. Names of the rebellions wanted by the Government. Financial difficulty in Jiangxi province and the aftermath. Defence in Songjiang, Shanghai. Fighting in Mongolia between local residents and Han troops. | China | http://trove.nla.gov.au/newspaper/page/24092864 | 24092864 |
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]);