This data as json, CSV (advanced)
Suggested facets: date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 38514 | 38514 | 1922-04-01 | 7 | b | A factory worker dies at his post and his wife demands compensation. | South America | http://trove.nla.gov.au/newspaper/page/24093923 | 24093923 | |
| 49734 | 49734 | 1930-11-22 | 8 | b | Australia news/ Chinese garden robbed near Sydney. Returned servicemen in Sydney defrauded by girls. A man is penalised for illegally selling wines. Bank robbery in Sydney. Gibbs Bright Company changes line. Woman in Sydney imprisoned for theft. Butchers on strike in Sydney and the report. Sydney police stop communist demonstration. | South America | http://trove.nla.gov.au/newspaper/page/24099860 | 24099860 | |
| 50049 | 50049 | 1931-02-28 | 8 | b | Prince of Britain continues his tour in South America. | South America | http://trove.nla.gov.au/newspaper/page/24090298 | 24090298 |
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]);