This data as json, CSV (advanced)
Suggested facets: source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
9621 | 9621 | 1902-01-18 | 3 | b | The arrest of Dong Fuxiang has not been confirmed. | Australia | http://trove.nla.gov.au/newspaper/page/24100302 | 24100302 | |
9622 | 9622 | 1902-01-18 | 3 | b | Wang Wenshao appointed in charge of railway and mineral resources while Zhang Yanmou the railway from Beijing to Shanhaiguan. | China | http://trove.nla.gov.au/newspaper/page/24100302 | 24100302 | |
9623 | 9623 | 1902-01-18 | 3 | b | French ambassador in Beijing demands Chinese government protects Catholics and punish those who harass churches. | China | http://trove.nla.gov.au/newspaper/page/24100302 | 24100302 |
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]);