This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
34520 | 34520 | 1919-05-24 | 6 | b | A train in New Zealand overturns. Australian pilot disappears while across the Atlantic Ocean. Korean people seek independence at the Paris Peace Conference. Emperor of Germany may be brought to trial. German warships now owned by Britain. | Other... | http://trove.nla.gov.au/newspaper/page/24097730 | 24097730 |
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]);