This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
2548 | 2548 | 1899-05-24 | 3 | b | On the international peace conference to be held in St Petersburg. | http://trove.nla.gov.au/newspaper/page/24102407 | 24102407 | ||
2549 | 2549 | 1899-05-24 | 3 | b | The war over steel prices in Britain and the USA; copper prices in London; bicycle company in America; Britain and France negotiate over their interest in Africa. | http://trove.nla.gov.au/newspaper/page/24102407 | 24102407 | ||
2550 | 2550 | 1899-05-24 | 3 | b | Loans taken out in the building of the railway from Beijing to northeastern China. | http://trove.nla.gov.au/newspaper/page/24102407 | 24102407 | ||
2551 | 2551 | 1899-05-24 | 3 | b | The Prince will inspect a military parade in London. | http://trove.nla.gov.au/newspaper/page/24102407 | 24102407 |
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]);