This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25615 | 25615 | 1912-01-20 | 6 | a-b | Fujian Governor's letter to overseas Chinese in Southeast Asia | Fujian governor calls on overseas Chinese to invest in Fujian and buy government loans, supporting the revolutionary government at the early stage. | China | http://trove.nla.gov.au/newspaper/page/24092079 | 24092079 |
25616 | 25616 | 1912-01-20 | 6 | b | Brief introduction about Zhang Shaohui and Lan Tianwei | Zhang Shaohui and Lan Tianwei once studied military in Japan. | China | http://trove.nla.gov.au/newspaper/page/24092079 | 24092079 |
25617 | 25617 | 1912-01-20 | 6 | b-c | Extraordinary teenage in Fujian revolutioary toops | Wang Jiegong, a small-built teenage in Fujian troops, made some extraordinary deeds during battles. | China | http://trove.nla.gov.au/newspaper/page/24092079 | 24092079 |
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]);