This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
32171 | 32171 | 1917-03-24 | 6 | a-b | Beijing news/ More security guards recruited for President Li Yuanhong. Military headquarters in Beijing asks current situations in Guangdong. Kang Youwei requests the central government to issue Books of Classics. Military governor of Jiangxi Li Chun reports banditry in his province. Educational authority to encourage overseas Chinese students for their study in China. The Yellow River bridge to be rebuilt for the Beijing-Hankou railway. Opium ban committee issues warnings to Vice-President Feng Guozhang. Ministry of Agriculture and Commerce issues new regulations on land cultivation. | China | http://trove.nla.gov.au/newspaper/page/24095637 | 24095637 | |
32172 | 32172 | 1917-03-24 | 6 | b-c | Guangdong news/ Governor Zhu Qinglan is urged to support the establishment of Guangzhou University. Government troops in Zhaoqing are suppressing bandits. Lu Rongting and Zhu Qinglan mourn the death of Liu Yongfu. Government military commanders are bribed by bandits. The breakup of America and Germany and its influence on the business in Guangzhou. Hong Kong governor to visit Guangzhou. Bandits suppressed in Dongguan county. Xu Mian in Guangzhou. Seven village women are kidnapped by bandits in Xinhui county. | China | http://trove.nla.gov.au/newspaper/page/24095637 | 24095637 |
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]);