This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
33925 | 33925 | 1918-12-21 | 8 | a-b | Beijing news/ Jin Yunpeng becomes military commander for the coming war with the south. Governor of Rehe province Jiang Guiti appeals for peace. The Chinese cabinet moves to the Zhongnanhai (Central and South Sea). President Xu Shichang relies upon Sun Baoqi. The commander of Fengtian army. Signs for chaos in the Outer Mongolia. France to employ some Chinese labourers. Lupomania in Shanghai. Flu in the Yangtze River area. | China | http://trove.nla.gov.au/newspaper/page/24097548 | 24097548 | |
33926 | 33926 | 1918-12-21 | 8 | b-c | Guangdong news/ Some city wall to be demolished. British settlement in Shamian, Guangzhou, drive out German nationals. Proposal for joint defence of Guangdong and Guangxi. A woman in Guangzhou turns to prostitute after loss in the gambling. Bandits in Xinhui county. A witch in Guangzhou and her performance. | China | http://trove.nla.gov.au/newspaper/page/24097548 | 24097548 |
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]);