This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25595 | 25595 | 1912-01-20 | 2 | c | Shandong wants independent | People in Shandong want independent from the Qing government. | Other... | http://trove.nla.gov.au/newspaper/page/24092075 | 24092075 |
25611 | 25611 | 1912-01-20 | 3 | c | Current situation in Hunan | Hunan military government is designing government official system and preparing for election. | China | http://trove.nla.gov.au/newspaper/page/24092074 | 24092074 |
25612 | 25612 | 1912-01-20 | 3 | c | Panic in Shangdong | Officials and wealthy people have been fleeing to Qingdao and other assumed safe places since the revolutionary uprising in Hunan. | China | http://trove.nla.gov.au/newspaper/page/24092074 | 24092074 |
25618 | 25618 | 1912-01-20 | 6 | c | Should Qing emperor abdicate? | Qing ministers support emperor's abdication and Yuan Shikai is proposed by the emperor to be the first president of the republic. | China | http://trove.nla.gov.au/newspaper/page/24092079 | 24092079 |
25619 | 25619 | 1912-01-20 | 6 | c | Yuan Shikai's peace negotiation conditions | Yuan Shikai made 14 provisions in his peace negotiation conditions including establishing the Empire of China. | China | http://trove.nla.gov.au/newspaper/page/24092079 | 24092079 |
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]);