This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25634 | 25634 | 1912-01-27 | 2 | a | Personnel and administration system of the new government should take lessons from the Qing government | A comment suggests that the new government should be careful of using officials, putting the interest of country and people above anything else. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24092083 | 24092083 |
25635 | 25635 | 1912-01-27 | 2 | a-b | Huang Shilong's resignation | The reason for Huang Shilong's resignation is unclear and it is not good for Guangdong people. | China | http://trove.nla.gov.au/newspaper/page/24092083 | 24092083 |
25636 | 25636 | 1912-01-27 | 2 | b | Letter from Henan Petition Bureau to Yuan Shikai | A letter to Yuan Shikai calls on him to support the establishment of a republic China. | China | http://trove.nla.gov.au/newspaper/page/24092083 | 24092083 |
25637 | 25637 | 1912-01-27 | 2 | b-c | Letter from Tianjing | People in Tianjing opposed the foreign loans by the government. | China | http://trove.nla.gov.au/newspaper/page/24092083 | 24092083 |
25638 | 25638 | 1912-01-27 | 2 | c | Current letters from Hubei | Teenage troop, women troop and monk troop are organised in Hubei to assist north expedition. Hubei troops welcome and respect troops from Hunan. | China | http://trove.nla.gov.au/newspaper/page/24092083 | 24092083 |
25639 | 25639 | 1912-01-27 | 2 | c | A glorious deed of a Hunan army officer | Liu Yutang, a Hunanese, led a troop bravely fighting against the enemy troops and died in the battle. | China | http://trove.nla.gov.au/newspaper/page/24092083 | 24092083 |
25640 | 25640 | 1912-01-27 | 2 | c-d | Introduction of Fu's troop | Fu's troop is a troop led by Li Fucheng, is successful of occupying Shanghai after bitter battles. | China | http://trove.nla.gov.au/newspaper/page/24092083 | 24092083 |
25641 | 25641 | 1912-01-27 | 2 | d | Foreign intervention on Chinese finance | Statistics of foreign loans need to be refunded during the year and additional condition addicted with the loans. | China | http://trove.nla.gov.au/newspaper/page/24092083 | 24092083 |
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]);