This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25048 | 25048 | 1911-09-30 | 2 | a-b | Commentary | A commentary is on the future of China's political parties. | Other... | http://trove.nla.gov.au/newspaper/page/24091938 | 24091938 |
25049 | 25049 | 1911-09-30 | 2 | b | Imperial edicts | Several imperial edicts. | Other... | http://trove.nla.gov.au/newspaper/page/24091938 | 24091938 |
25050 | 25050 | 1911-09-30 | 2 | b | Brief headline news | The Regent asks navy chief to discuss with Britain about the issue of Weihai Bay in Shandong. Department of Transport insists to borrow foreign loans to build a railway in Sichuan. The Regent asks minister for civil affairs to reform within the department. Inspector might be promoted to governor of Yunnan. Governor for Yunnan and Guizhou asks for resign due to his dissatisfaction with the government's attitude toward the issue of Pianma (ppp). Xiaodi's new appointment. Premier assistant anounces all imperial edicts and documents should be sent to the cabinet political newspaper office for publication. Financial department approves governor Zhang Renjun's request for borrowing foreign loans. New Chinese coins are accepted by foreign countries. | Other... | http://trove.nla.gov.au/newspaper/page/24091938 | 24091938 |
25051 | 25051 | 1911-09-30 | 2 | b-c | China-Portugal negotiation about Macao | China-Portugal negotiation about Macao is still under way. | Other... | http://trove.nla.gov.au/newspaper/page/24091938 | 24091938 |
25052 | 25052 | 1911-09-30 | 2 | c | A new subway in New York | A opening ceremony is held for a new subway in New York. | Other... | http://trove.nla.gov.au/newspaper/page/24091938 | 24091938 |
25053 | 25053 | 1911-09-30 | 2 | c-d | Secrets of appointment of senior officials | Some secrets have been revealed about how senior officials are appointed and dismissed. | Other... | http://trove.nla.gov.au/newspaper/page/24091938 | 24091938 |
25054 | 25054 | 1911-09-30 | 2 | d | Flood in Anhui | Anhui has another flood. | China | http://trove.nla.gov.au/newspaper/page/24091938 | 24091938 |
25055 | 25055 | 1911-09-30 | 2 | d | Census in Nanyang Islands | Census in Nanyang islands. | Other... | http://trove.nla.gov.au/newspaper/page/24091938 | 24091938 |
25056 | 25056 | 1911-09-30 | 2 | d | Prince Zhen is in depression | Prince Zhen is in depression after he returned from the British coronation. | China | http://trove.nla.gov.au/newspaper/page/24091938 | 24091938 |
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]);