This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25876 | 25876 | 1912-03-16 | 3 | b-c | Beijing news | Republic upper house holds meeting. President Sun willing to hand over presidency to Yuan Shikai for peaceful transition. Manchu aristocrats once secretly discussed about getting rid of Yuan Shikai. President Sun tries to win foreign countries's recognition of his republic. Number of army in the north recognising republic. | Other... | http://trove.nla.gov.au/newspaper/page/24092164 | 24092164 |
25888 | 25888 | 1912-03-16 | 7 | b-c | Rebels in Guangzhou | Rebels fight government troops in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24092169 | 24092169 |
25893 | 25893 | 1912-03-16 | 8 | b-c | Manchu aristocrats' deposits in foreign banks | Number of Manchu aristocrats' deposits in foreign banks. | Other... | http://trove.nla.gov.au/newspaper/page/24092172 | 24092172 |
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]);