This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31215 | 31215 | 1916-05-13 | 3 | a-c | Yuan Shikai borrows money from America. Report on the abdication of Yuan Shikai. Mediators for Yuan Shikai. | China | http://trove.nla.gov.au/newspaper/page/24095259 | 24095259 | |
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]);