This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25261 | 25261 | 1911-11-11 | 3 | a-b | Riots record in China | Yuan Shikai is negotiating with Li Yuanhong. Military revolts in various places result in huge casualties. Wu Tingfang is on the side of revolutionaries. Zi Zheng Yuan admits differences between revolutionary parties and the riot bandits. | China | http://trove.nla.gov.au/newspaper/page/24091992 | 24091992 |
25272 | 25272 | 1911-11-11 | 6 | b | Riots record in China | More people and places support the revolutionaries. | China | http://trove.nla.gov.au/newspaper/page/24091997 | 24091997 |
25275 | 25275 | 1911-11-11 | 7 | b | Riots record in China | A new governor of Shangxi was killed by the Manchu soldier. All railways to Beijing are in controls of the revolutionaries. Li Yuanhong, the head of revolutionaries proposes to establish a federal republic country. The imperial family is to move out from Beijing. | China | http://trove.nla.gov.au/newspaper/page/24091996 | 24091996 |
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]);