This data as json, CSV (advanced)
Suggested facets: source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
24530 | 24530 | 1911-05-13 | 8 | a | Imperial edicts | Zeng Qizhe is asked to take a position in Beijing. Fu Lun takes the post of minister for agriculture, industry and commerce. New appointments for the state advisory committee. Li Jiaben and Liu Ruzeng were appointed new positions in the department of justice. Each governor was asked to well control its budget. Lin Shaonian was appointed minister assistant for department of civil affairs. Qu Shiqi was appointed a new post and several other edicts. | Other... | http://trove.nla.gov.au/newspaper/page/24091776 | 24091776 |
24531 | 24531 | 1911-05-13 | 8 | a-b | Bankrupt of Yishanyuan Bank | Details of the bankrupt of Yishanyuan Bank were revealed. | China | http://trove.nla.gov.au/newspaper/page/24091776 | 24091776 |
24532 | 24532 | 1911-05-13 | 8 | b | Senior officials' indulge in decadent life | Several senior officials in Beijing indulge in decadent life. | China | http://trove.nla.gov.au/newspaper/page/24091776 | 24091776 |
24533 | 24533 | 1911-05-13 | 8 | b-c | Killing of General Fu | The story of the killing of General Fu was told. | Other... | http://trove.nla.gov.au/newspaper/page/24091776 | 24091776 |
24534 | 24534 | 1911-05-13 | 8 | c | Donations to Jiangsu and Anhui | Donations from Association for Imperial Constitution in Sydney. More than 30 donators' names listed. | Other... | http://trove.nla.gov.au/newspaper/page/24091776 | 24091776 |
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]);