This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25252 | 25252 | 1911-11-11 | 2 | a-b | The relaltions between the government and people after the revolution. | The future government and people should cooperate to build a constitutional country in China. | Other... | http://trove.nla.gov.au/newspaper/page/24091993 | 24091993 |
25253 | 25253 | 1911-11-11 | 2 | b | Special cable news | Prince Qing resigns from the cabinet and Yuan Shikai takes over the position of premier. | China | http://trove.nla.gov.au/newspaper/page/24091993 | 24091993 |
25254 | 25254 | 1911-11-11 | 2 | b | Brief introduction about Li Jiaju | Shixu resigns and Li Jiaju is now chief of Zi Zheng Yuan. | China | http://trove.nla.gov.au/newspaper/page/24091993 | 24091993 |
25255 | 25255 | 1911-11-11 | 2 | b-c | Headline news | Navy Ministry is to build warships and set up military institutions.The Post and Transport Ministry is to return railway shares to previous owners. Legal cases in some places are subject to direct administration of central legislation. Examination result of overseas graduates is exposed. Wu Bingwei impedes Fu Kaisen. Another election of senators will be held in Shichun. | China | http://trove.nla.gov.au/newspaper/page/24091993 | 24091993 |
25256 | 25256 | 1911-11-11 | 2 | c | Opium ban issues between China and Britain | Opium ban leads to profit reduction of British businessmen. | China | http://trove.nla.gov.au/newspaper/page/24091993 | 24091993 |
25257 | 25257 | 1911-11-11 | 2 | c-d | Guangzhou-Julong railway opens | News on Guang-Ju railway opening ceremony. | China | http://trove.nla.gov.au/newspaper/page/24091993 | 24091993 |
25258 | 25258 | 1911-11-11 | 2 | d | Second graduation ceremony of Nan Qiang Public Institute | A big ceremony is held for second graduation of Nan Qiang Public Institute. | China | http://trove.nla.gov.au/newspaper/page/24091993 | 24091993 |
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]);