This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25599 | 25599 | 1912-01-20 | 3 | a | Qing emperor abdicates | Qing emperor is to abdicate shortly and China is to be a republic country. | China | http://trove.nla.gov.au/newspaper/page/24092074 | 24092074 |
25600 | 25600 | 1912-01-20 | 3 | a | Crisis in the frontiers | A violent riot occurs in Xingjiang where the rebels claim to establish an independent republic . | China | http://trove.nla.gov.au/newspaper/page/24092074 | 24092074 |
25601 | 25601 | 1912-01-20 | 3 | a | Military state of government troops and the revolutionary troops | Government troops are marching to Henan to stop the revolutionary troops that aim to occupy the province. | China | http://trove.nla.gov.au/newspaper/page/24092074 | 24092074 |
25602 | 25602 | 1912-01-20 | 3 | a-b | Russia's supports for Mongolia's independence | Russia conspires and supports Mongolia's independence during the revolution, and the religious leaders of Exterior Mongolia drive away government officials and announce independence. | China | http://trove.nla.gov.au/newspaper/page/24092074 | 24092074 |
25603 | 25603 | 1912-01-20 | 3 | b | Big powers have not recognised the republic | Warships of big powers in Yangtse River were not allowed to congratulate Sun Yatsen's inauguration as the temporary president of the republic of China. | China | http://trove.nla.gov.au/newspaper/page/24092074 | 24092074 |
25604 | 25604 | 1912-01-20 | 3 | b | North expedition | The revolutionary troops in Shanghai are to send an expedition army northward. | China | http://trove.nla.gov.au/newspaper/page/24092074 | 24092074 |
25605 | 25605 | 1912-01-20 | 3 | b | Dark age of killings, raping and robbing | Killing, raping and robbing widespread during revolution and thousands of Man women commit suicides preventing from being raped. | China | http://trove.nla.gov.au/newspaper/page/24092074 | 24092074 |
25606 | 25606 | 1912-01-20 | 3 | b | Fire in New York | An insurance company was burned, resulting in huge casualties. | America | http://trove.nla.gov.au/newspaper/page/24092074 | 24092074 |
25607 | 25607 | 1912-01-20 | 3 | b | German emperor is to meet Austrian emperor | German emperor is to travel to Austria in May and meet its emperor. | Other... | http://trove.nla.gov.au/newspaper/page/24092074 | 24092074 |
25608 | 25608 | 1912-01-20 | 3 | b | British emperor to return home | British emperor leaves India and returns to Britain. | Other... | http://trove.nla.gov.au/newspaper/page/24092074 | 24092074 |
25609 | 25609 | 1912-01-20 | 3 | b | Census in France | Statistics of French population. | Other... | http://trove.nla.gov.au/newspaper/page/24092074 | 24092074 |
25610 | 25610 | 1912-01-20 | 3 | b | Expense of Japanese navy expansion | Japan cuts down other government expenses to build more warships. | Japan | http://trove.nla.gov.au/newspaper/page/24092074 | 24092074 |
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 |
25613 | 25613 | 1912-01-20 | 3 | c-d | Guangdong news | Huang Shilong determines to resign from the government. Governor Hu asks Huang Shilong not to resign. Elected military representives are going to Hunan to assist military planning. A robbery occurs in a hotel in Guangdong. Some people advise Guangdong government to levy heavy tax on opium rather than ban it. A conflict occurs between two troops resulting in battles in Guangdong. The revolutionary troops disembowelled Zhen Jiasheng for revenging his killing revolutionaries. More than twenty people were disembowelled in various ways by the revolutionary troops. Temporary government in Guangzhou is electing its chiefs of the senate. | China | http://trove.nla.gov.au/newspaper/page/24092074 | 24092074 |
25614 | 25614 | 1912-01-20 | 3 | d | Comment on current situation in China | The new government should be careful not to kill innocent people resulting from evil persons' false witnesses . | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092074 | 24092074 |
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]);