This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31216 | 31216 | 1916-05-13 | 3 | d-f | The World War I (German warships attack British port. British warships are sunken. Turkish army on the way to Suez Canal. Chaos in Ireland pacified. Former Russian army commander is imprisoned. Battles in eastern and western Europe). | Other... | http://trove.nla.gov.au/newspaper/page/24095259 | 24095259 |
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]);