This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21357 | 21357 | 1909-07-24 | 2 | b-c | Beijing news/ Britain, America, Germany and France are competing to build naval vessels for China. Yuan Shikai, Tang Shaoyi and Qin Chunxuan and their political future. Prince regent seeks to preserve the sovereignty of China. Bogus emperor is arrested in Yunnan province. Ministry of Communications sets out privilege of railway shareholders. Citizenship law under revision. Japan to set up bank in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/26802262 | 26802262 |
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]);