This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 9327 | 9327 | 1901-12-14 | 2 | f | A house in New South Wales was on fire. | Australia | http://trove.nla.gov.au/newspaper/page/24100265 | 24100265 | |
| 9329 | 9329 | 1901-12-14 | 3 | a | A cargo train in Canada ran into a river after a bridge collapsed. | Australia | http://trove.nla.gov.au/newspaper/page/24100264 | 24100264 | |
| 9330 | 9330 | 1901-12-14 | 3 | a | France considers how to spend the money it received as a result of the Boxer indemnity China paid. | Australia | http://trove.nla.gov.au/newspaper/page/24100264 | 24100264 | |
| 9331 | 9331 | 1901-12-14 | 3 | a | A young man in Germany murdered dozens of people. | Australia | http://trove.nla.gov.au/newspaper/page/24100264 | 24100264 | |
| 9332 | 9332 | 1901-12-14 | 3 | a | A thief was caught in a tailor shop on George Street, Sydney. | Australia | http://trove.nla.gov.au/newspaper/page/24100264 | 24100264 | |
| 9333 | 9333 | 1901-12-14 | 3 | a | A night watchman in Sydney injured others. | Australia | http://trove.nla.gov.au/newspaper/page/24100264 | 24100264 | |
| 9339 | 9339 | 1901-12-14 | 3 | c | Indian and German soldiers clash in Tianjin. | Australia | http://trove.nla.gov.au/newspaper/page/24100264 | 24100264 | |
| 9343 | 9343 | 1901-12-14 | 3 | d | A carriage in Victoria was capsized, two passengers were injured. | Australia | http://trove.nla.gov.au/newspaper/page/24100264 | 24100264 |
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]);