Article Index

3 rows where column = "b" and source = "South America"

Filter results

This data as json, CSV (advanced)

Suggested facets: page, 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

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 
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]);