This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31249 | 31249 | 1916-05-20 | 8 | b-d | Beijing news/ Yuan Shikai's government gives up ownership of the railway in north Manchuria. German newspaper reports the current situation in southwest China. Troops in Guizhou province and their movement. Reasons for abolition of autocratic monarchy. Tang Jiyao and his attitude towards Yuan Shikai. | China | http://trove.nla.gov.au/newspaper/page/24095273 | 24095273 |
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]);