This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
25160 | 25160 | 1911-10-21 | 2 | a-b | Revolution unrest results from railways unrest in China | The revolutionary riots and unrest are actually caused by the railways unrest in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24091967 | 24091967 |
25161 | 25161 | 1911-10-21 | 2 | b-c | Notice of Constitutional Friends' Association calling for donation | Beijing Constitutional Friends' Association calls on donation for supporting its activities. | China | http://trove.nla.gov.au/newspaper/page/24091967 | 24091967 |
25162 | 25162 | 1911-10-21 | 2 | c | Headline news | Government plans to award titles to graduates from various schools. Navy plans to add warships. Cai Naihuang is returning to China. Navy ministry is to put its plan into practice. Court examination is to be terminated. Sheng Bingkong is to be governor of Yunnan. | China | http://trove.nla.gov.au/newspaper/page/24091967 | 24091967 |
25163 | 25163 | 1911-10-21 | 2 | c-d | Japanese Asian Association | Japanese Asia Association aims to expand invasions of Japan in Asia. | Russia | http://trove.nla.gov.au/newspaper/page/24091967 | 24091967 |
25164 | 25164 | 1911-10-21 | 2 | d | Struggles in political world | Li Jiaju advises to set up new official system. Prince Qing takes sick leave. Che Gong powerful as the minister of finance. Governor of Guangdong is in troubling situation. | China | http://trove.nla.gov.au/newspaper/page/24091967 | 24091967 |
25165 | 25165 | 1911-10-21 | 2 | d | Railways unrest in Shichuan | Britain asks to send troops to Shichuan to settle down railways unrest but get refused. | China | http://trove.nla.gov.au/newspaper/page/24091967 | 24091967 |
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]);