This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25289 | 25289 | 1911-11-18 | 3 | a-b | Riots record in China | Russia and Britain send more troops to protect their interests in China. Manchu imperial members secretly meets to get Russia's protection. Revolutionary army and government troops are violently killing each other. Manchu troops are killing innocent people in Nanjing. Yuan Shikai resigns from premier of the cabinet. Yuan Shikai writes to Li Yuanhong to express his support. | China | http://trove.nla.gov.au/newspaper/page/24092001 | 24092001 |
25293 | 25293 | 1911-11-18 | 6 | b | Riots record in China | The revolutionary army controls Areas along Yangtse River. One hundred thousand people escape to Tianjing and price of rice rises sharply. | China | http://trove.nla.gov.au/newspaper/page/24092006 | 24092006 |
25299 | 25299 | 1911-11-18 | 7 | b | Riots record in China | Manchu troops are brutally killing innocent people. Foreigner are required to stay at home. People in Beijing welcome the return of Yuan Shikai. Wu Tingfang askes the emperor to retreat. Revolutionaries accidently killed each other. Her majesty asks Yuan Shikai protect the country. Wu Tingfang notifies foreign ambassadors that a new parliament is to set up in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/24092005 | 24092005 |
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]);