This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
3180 | 3180 | 1899-07-29 | 3 | d | Two robbers in Melbourne have been identified. | http://trove.nla.gov.au/newspaper/page/24102480 | 24102480 | ||
3181 | 3181 | 1899-07-29 | 3 | d | Several bodies found after a ship accident near Fremantle, Western Australia. | http://trove.nla.gov.au/newspaper/page/24102480 | 24102480 | ||
3182 | 3182 | 1899-07-29 | 3 | d | German Parliament cut the power of its king. | http://trove.nla.gov.au/newspaper/page/24102480 | 24102480 | ||
3183 | 3183 | 1899-07-29 | 3 | d | Powerful radio invented. | http://trove.nla.gov.au/newspaper/page/24102480 | 24102480 | ||
3184 | 3184 | 1899-07-29 | 3 | d | Britain prepares to fight with Transvaal. | http://trove.nla.gov.au/newspaper/page/24102480 | 24102480 | ||
3185 | 3185 | 1899-07-29 | 3 | d | Britain and America in disputes over the international peace conference. | http://trove.nla.gov.au/newspaper/page/24102480 | 24102480 | ||
3186 | 3186 | 1899-07-29 | 3 | d | Queen of England sends telegram to sympathise with the family's of workers who recently died. | http://trove.nla.gov.au/newspaper/page/24102480 | 24102480 |
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]);