This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 |
25695 | 25695 | 1912-02-03 | 7 | b-c | Beijing news | Yuan Shikai has utmost power over state affairs. Members of State Advisory Committee leave Beijing one after another. Manchu aristocrats worry about their future. | Other... | http://trove.nla.gov.au/newspaper/page/24092094 | 24092094 |
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]);