This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33730 | 33730 | 1918-10-12 | 8 | a-c | Beijing news/ Rumour says Xu Shuzheng has been executed by Zhang Zuolin. Liang Shiyi agrees to be the speaker of the parliament and his conditions. Cao Kun demands to control of munitions factory. Chen Guangyuan reports the banditry in Jiangxi province. Chinese cabinet approves to continue repayment the indemnity to Russia. Storm in Wuchang and the damages. News on the dethroned Qing family. Competition of martial arts in Nanjing. | China | http://trove.nla.gov.au/newspaper/page/24097468 | 24097468 | |
33731 | 33731 | 1918-10-12 | 8 | c-d | Guangdong news/ Governor Li Yaohan returns to Guangzhou. Long Yuguang in Fujian province and his movements. Restrictions on the sale of official properties. The railway from Guangzhou to Kowloon is still under repaired. Bandits in Dongguan are killed for robbery. Bandits in Shunde county and their kidnaps. Bandits in Gaoming and Xinhui county and their robberies. | China | http://trove.nla.gov.au/newspaper/page/24097468 | 24097468 |
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]);