This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28497 | 28497 | 1914-02-28 | 2 | c-d | Salary paid to Chinese President Yuan Shikai and salaries of president in other countries. | China | http://trove.nla.gov.au/newspaper/page/24093022 | 24093022 | |
28513 | 28513 | 1914-02-28 | 3 | c-d | Beijing news/ President Yuan Shikai orders to disband all political parties. Yuan Shikai on Confucianism. President Yuan Shikai on the New Year. President Yuan Shikai dispatches troops to Mongolia. Tibet issues and the negotiation between Britain and China. | China | http://trove.nla.gov.au/newspaper/page/24093021 | 24093021 |
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]);