This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25746 | 25746 | 1912-02-17 | 2 | c-d | Li Yuanhong's current activities | Li Yuanhong is elected as vice president of the Republic of China. Li's official building is to be expanded. Li orders to make new currency for the new government. Student Army aroused opposition by forcing people to cut queue and Li orders to stop the ruthless measures. Sun Wu, Xu Shengjing, Peng Hanqian were recommended to be candidates for senators but lost in the election. | France | http://trove.nla.gov.au/newspaper/page/24092107 | 24092107 |
25760 | 25760 | 1912-02-17 | 3 | c-d | Guangdong news | The revolutionary ally party member Deng Shaocong is trying to kill He Yunshang and Deng zhenwu, two revolutionary officials. Eight foreign warships come to Guangdong sea and defence works are building in foreign leasing areas. Huang Shilong comes to Nanjing and is likely to be commander of the new army. Long Jiguang issues regulations for protecting foreigners. Zhaochen county is to levy tax on ox butchers. Xunde county is badly suffered from robberies. | China | http://trove.nla.gov.au/newspaper/page/24092106 | 24092106 |
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]);