This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27734 | 27734 | 1913-08-16 | 2 | b-d | Orders issued by the interim president Yuan Shikai on worship of Confucius, rewards to Huang Rongliang and Australian Chinese community for their contribution to China's national construction, and suppress to rebellions in the south. | China | http://trove.nla.gov.au/newspaper/page/24092785 | 24092785 |
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]);