This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27162 | 27162 | 1913-03-22 | 2 | c | President Yuan carefully plans war against Mongolia. | Other... | http://trove.nla.gov.au/newspaper/page/24092617 | 24092617 | |
27185 | 27185 | 1913-03-22 | 8 | c | Survey on each provincial election of senate members. | Other... | http://trove.nla.gov.au/newspaper/page/24092623 | 24092623 | |
27186 | 27186 | 1913-03-22 | 8 | c | Former Qing government official intends to sell Qing treasuries to foreign shop. | Other... | http://trove.nla.gov.au/newspaper/page/24092623 | 24092623 | |
27187 | 27187 | 1913-03-22 | 8 | c | Report about where former Qing princes live. | Other... | http://trove.nla.gov.au/newspaper/page/24092623 | 24092623 |
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]);