This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
8916 | 8916 | 1901-10-26 | 2 | d | A criminal in Italy has been captured after three years' on the run. | Australia | http://trove.nla.gov.au/newspaper/page/24100209 | 24100209 | |
8918 | 8918 | 1901-10-26 | 2 | e | Reports on the chaos in the Philippines. | Australia | http://trove.nla.gov.au/newspaper/page/24100209 | 24100209 | |
8919 | 8919 | 1901-10-26 | 2 | e | Queensland will not allow newspaper to be published on Sundays. | Australia | http://trove.nla.gov.au/newspaper/page/24100209 | 24100209 | |
8920 | 8920 | 1901-10-26 | 2 | e | Australia will prohibit liner companies from employing any coloured people. Japanese government protests against such policy. | Australia | http://trove.nla.gov.au/newspaper/page/24100209 | 24100209 | |
8922 | 8922 | 1901-10-26 | 2 | f | A French man invents a fast boat. | Australia | http://trove.nla.gov.au/newspaper/page/24100209 | 24100209 | |
8931 | 8931 | 1901-10-26 | 3 | e | A robbery in Brisbane, Queensland. | Australia | http://trove.nla.gov.au/newspaper/page/24100208 | 24100208 |
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]);