This data as json, CSV (advanced)
description 1 ✖
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28726 | 28726 | 1914-04-18 | 3 | b-c | Beijing news/ Discussions in China on the reform of local administrative system. President Yuan Shikai and the revolutionary rebels. China to borrow loans from France for railway construction. Xu Donghai and the reform of cabinet system in China. Jiangxi provincial authority asks for financial assistance. | China | http://trove.nla.gov.au/newspaper/page/24093077 | 24093077 |
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]);