This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25674 | 25674 | 1912-02-03 | 2 | c | Actions of big powers intervention on Chinese finance | Big powers designed 6 provisions as further conditions for China's future loans. | China | http://trove.nla.gov.au/newspaper/page/24092091 | 24092091 |
25684 | 25684 | 1912-02-03 | 3 | c | Beijing news | More people are supporting republic system in China. Hunan people are angry with Yuan Shude's supporting actions to Qing government. Sun Shaohou is elected as governor of Anhui military government. Tang Guiliang is promoted chief commander of revolutionary troops in Yuezhou, Hunan. Shichun military government notifies its people to keep social order. Li Hefai's house is taken over by the revolutionary army. | China | http://trove.nla.gov.au/newspaper/page/24092090 | 24092090 |
25688 | 25688 | 1912-02-03 | 6 | c | Censor in China | Statistics of Chinese people, foreign people in China. | China | http://trove.nla.gov.au/newspaper/page/24092095 | 24092095 |
25689 | 25689 | 1912-02-03 | 6 | c | Panic in Fentian | Revolutionaries in Fentian, northeast China, caused social instabilities there and Japan was asked to protect people there. | China | http://trove.nla.gov.au/newspaper/page/24092095 | 24092095 |
25690 | 25690 | 1912-02-03 | 6 | c | Important cable news | President Sun Yatsen askes permission for borrowing Guangdong railways' mortgage for northward expedition army. | China | http://trove.nla.gov.au/newspaper/page/24092095 | 24092095 |
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]);