This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24357 | 24357 | 1911-02-25 | 3 | b | Beijing's Royal family and officidom | As Manchu decease might invade Beijing, the Royal family and other officials were looking into leaving Beijing. If this happens, either China or Russia would take over the city in the name of protection. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24091677 | 24091677 |
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]);