This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 43026 | 43026 | 1925-04-18 | 5 | c | Further report on the earthquake in Mexico. | Canada | http://trove.nla.gov.au/newspaper/page/24101103 | 24101103 | |
| 43139 | 43139 | 1925-05-09 | 5 | b | Anti-Chinese movement in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24101127 | 24101127 | |
| 43181 | 43181 | 1925-05-16 | 5 | b | An explosion outside of Pittsburgh, United States, claims eight lives. | Canada | http://trove.nla.gov.au/newspaper/page/24101135 | 24101135 | |
| 43225 | 43225 | 1925-05-23 | 5 | b | A submarine cable to be built from Victoria state to Suva, Fiji. | Canada | http://trove.nla.gov.au/newspaper/page/24101143 | 24101143 | |
| 43258 | 43258 | 1925-05-30 | 5 | a | A rich man in America lives together with a widow and is shot dead by her daughter. | Canada | http://trove.nla.gov.au/newspaper/page/24101151 | 24101151 | |
| 43601 | 43601 | 1925-08-08 | 5 | a | Fire in Havana and the damages. | Canada | http://trove.nla.gov.au/newspaper/page/24101235 | 24101235 | |
| 43843 | 43843 | 1925-09-19 | 5 | b | Timber burned to ashes in Canada. | Canada | http://trove.nla.gov.au/newspaper/page/24101283 | 24101283 | |
| 44726 | 44726 | 1926-05-15 | 5 | a | Riots in Central American countries. | Canada | http://trove.nla.gov.au/newspaper/page/24101559 | 24101559 | |
| 44780 | 44780 | 1926-05-29 | 5 | a | Revolution in Nicaragua. | Canada | http://trove.nla.gov.au/newspaper/page/24101575 | 24101575 | |
| 45263 | 45263 | 1926-10-30 | 5 | c | Storm in Havana and the damages. | Canada | http://trove.nla.gov.au/newspaper/page/24101761 | 24101761 | |
| 45824 | 45824 | 1927-06-18 | 5 | c | Demonstration at the front of American consulate in Vancouver. | Canada | http://trove.nla.gov.au/newspaper/page/24102028 | 24102028 |
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]);