This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27748 | 27748 | 1913-08-16 | 3 | c | Beijing news/ Proposal to commemorate Confucius. Reform of the provincial politics. The Progressive and the Nationalist Parties to support interim President Yuan Shikai. Investigation on the salary of local military governors. Warning by Xiong Xiling to the national parliament. | China | http://trove.nla.gov.au/newspaper/page/24092784 | 24092784 | |
27756 | 27756 | 1913-08-16 | 7 | c | Miscellaneous report on Chinese politics. | China | http://trove.nla.gov.au/newspaper/page/24092788 | 24092788 |
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]);