This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25410 | 25410 | 1911-12-09 | 8 | a | Li's letter to Sha Zhenbing | Revolutionary leader, Li Yuanhong's letter to Sha Zhenbing (nnn) about the revolution happening in China. | Other... | http://trove.nla.gov.au/newspaper/page/24092033 | 24092033 |
25411 | 25411 | 1911-12-09 | 8 | a-b | Revolutionary army in Hubei | Recent revolutionary army activities in Hubei including increase of troop number, number of ammunitions, union of different groups of revolutionary armies, negotiation with government about stopping fighting and leader Li Hongyuan sends notes to all foreign consulates to China. | Other... | http://trove.nla.gov.au/newspaper/page/24092033 | 24092033 |
25412 | 25412 | 1911-12-09 | 8 | b-d | Revolutionary activities in Shanghai | Several revolutionary activities happen in Shanghai including conflict between police and several revolutionaries, people told by Shanghai military government to be happy with establishment of republic China and calm and do whatever they usually do, bombing of Shanghai Ammunition Manufacture Bureau by revolutionaries, revolutionaries set fire on Transport Bureau and key train stations guarded by revolutionary soldiers, revolutionaries set rewards for capture of Liu Yan who fled away, Shanghai Consuls' Society set up, revolutionaries occupy Longhua ammunition factory and Wu Zhiyong appointed as negotiator for revolutionaries. | Other... | http://trove.nla.gov.au/newspaper/page/24092033 | 24092033 |
25413 | 25413 | 1911-12-09 | 8 | d | Haiming's notes | Contrast between general Li Yuanhong and Zhang Biao for their attitude towards soldiers; Tie Zhong is most powerful man of Man nationality in Hubei army and a general was killed for his disobedience to the government. | Other... | http://trove.nla.gov.au/newspaper/page/24092033 | 24092033 |
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]);