This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24985 | 24985 | 1911-09-16 | 2 | b-c | Brief headline news | Son of the premier asks his father to retire. No official examination this year. Premier asks for retirement but the Regent asks him to hold the position. The cabinet proposes change of offical system. Premier proposes Confucian family member to assist making of the constitution. Cai Naidao is a fugitive. Shanghai was attacked by a severe storm. Big fire results in loss of hundreds of houses, boats and lives in Wuchang, Hubei. Change of government personnel. Storm and flood disasters in several provinces. | Other... | http://trove.nla.gov.au/newspaper/page/24091921 | 24091921 |
25010 | 25010 | 1911-09-16 | 7 | b-c | Handling of flood issue | Chinese government allocates funds to handle the issue of recent floods. | China | http://trove.nla.gov.au/newspaper/page/24091924 | 24091924 |
25013 | 25013 | 1911-09-16 | 8 | b-c | Negotiations about Macao | Several military actions have been taken due to increasing intension of the Macao issue. | Other... | http://trove.nla.gov.au/newspaper/page/24091927 | 24091927 |
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]);