This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
23858 | 23858 | 1910-11-26 | 2 | b-c | News in brief/ Two American engineers are surveying for the railway project from Yunnan to Sichuan. Tang Shaoyi to take his office as minister of communications. Board of Revenue plans to borrow money from America in order to repay indemnity to other countries. Gifts prepared for the coming German prince. New administrative division proposed for Tibet and Mongolia. Financial deficit in Jiangsu, Zhili and other provinces. German officer to train Chinese troops. Zai Xun visits Japan. Regulations for newspaper publishing to be revised. | China | http://trove.nla.gov.au/newspaper/page/26802850 | 26802850 | |
23898 | 23898 | 1910-11-26 | 8 | b-c | Fourth part of a message to the nation on the delay of establishment of national parliament, selected from guo feng bao in Shanghai. | China | http://trove.nla.gov.au/newspaper/page/26802856 | 26802856 |
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]);