This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22131 | 22131 | 1909-12-18 | 3 | b | Parliament of the United States of America sits. | Britain | http://trove.nla.gov.au/newspaper/page/26802431 | 26802431 | |
22132 | 22132 | 1909-12-18 | 3 | b | Persia starts financial reform. | Britain | http://trove.nla.gov.au/newspaper/page/26802431 | 26802431 | |
22133 | 22133 | 1909-12-18 | 3 | b | American adventurer starts his exploration to the North Pole. | Britain | http://trove.nla.gov.au/newspaper/page/26802431 | 26802431 | |
22134 | 22134 | 1909-12-18 | 3 | b | German arsenal makes profits. | Britain | http://trove.nla.gov.au/newspaper/page/26802431 | 26802431 | |
22135 | 22135 | 1909-12-18 | 3 | b | A silk factory in Britain is burned to ashes. | Britain | http://trove.nla.gov.au/newspaper/page/26802431 | 26802431 | |
22136 | 22136 | 1909-12-18 | 3 | b | British man invents big and speedy warship. | Britain | http://trove.nla.gov.au/newspaper/page/26802431 | 26802431 | |
22137 | 22137 | 1909-12-18 | 3 | b | Tornado in Lake Eric claims 59 lives. | Britain | http://trove.nla.gov.au/newspaper/page/26802431 | 26802431 | |
22138 | 22138 | 1909-12-18 | 3 | b | King of Belgium is seriously ill. | Britain | http://trove.nla.gov.au/newspaper/page/26802431 | 26802431 |
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]);