This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25721 | 25721 | 1912-02-10 | 6 | a-b | Beijing current situation | Prince Zan Tao's adviser suggests to him to get rid of Yuan Shikai first and then crack down republicans. Conflicts between Yuan Shikai and Prince Zan Tao. Yuan Shikai does not get what he expected when he came to Beijing. | Other... | http://trove.nla.gov.au/newspaper/page/24092103 | 24092103 |
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]);