This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28795 | 28795 | 1914-05-09 | 2 | b-c | Orders issued by Chinese President Yuan Shikai to suppress revolutionary rebels in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24093102 | 24093102 | |
28804 | 28804 | 1914-05-09 | 3 | b-c | Pirates hijack a liner Tai'an near Hong Kong, set it ablaze, and some passengers die. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24093101 | 24093101 | |
28815 | 28815 | 1914-05-09 | 6 | b-c | French authority in the Guangzhou Bay to increase tax and their negotiations with the China side. French troops in Vietnam cross the boundary with China. Russian authority dispatches more troops to Jilin and Heilongjiang area (northeast of China). | China | http://trove.nla.gov.au/newspaper/page/24093106 | 24093106 | |
28821 | 28821 | 1914-05-09 | 8 | b-c | Guangdong news/ New governor might be appointed to replace Li Kaishen. Li Yaohan in Zhaoqing and Wu Xiangda in Chaozhou are promoted. Bank notes issued in Guangdong. Bandits in Shunde and Nanhai county. A woman is sentenced for arms smuggling. Troops harass local residents in Lecong and the report on three cases. | China | http://trove.nla.gov.au/newspaper/page/24093108 | 24093108 |
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]);