This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21510 | 21510 | 1909-08-21 | 2 | c-d | Beijing news/ The end of Prince Qing. Proposal to reward donators to naval building. Prince Regent selects talented people. Prince Su suggests Weihaiwei to be naval port. Chinese students in America and their achievement (including Wang Chonghui, Hu Dunfu and Zhang Dachun). China to organise an industrial exhibition in 1918. Government officials, following the example of Prince Regent, are reading newspapers more frequently. | China | http://trove.nla.gov.au/newspaper/page/26802296 | 26802296 | |
21514 | 21514 | 1909-08-21 | 3 | b | German interfere with railway building in Shandong province. | China | http://trove.nla.gov.au/newspaper/page/26802295 | 26802295 | |
21549 | 21549 | 1909-08-21 | 8 | c | Beiyang (Tianjin) officialdom is in panic following Zhili governor Yang Shixiang is found embezzlement. | China | http://trove.nla.gov.au/newspaper/page/26802302 | 26802302 |
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]);