This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
20181 | 20181 | 1908-10-31 | 2-3 | c-a | Third part of the memorial report from the Constitutional Research Institution (xian zheng bian cha guan) on necessary preparation in the next few years for constitutional reform, establishment of parliament and the draft of new constitution of China. | China | http://trove.nla.gov.au/newspaper/page/26801932 | 26801932 |
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]);