Article Index

4 rows where "date" is on date 1901-06-12, source = "Australia" and trove_id = 24100072

Filter results

This data as json, CSV (advanced)

Suggested facets: column, date (date)

Link rowid ▼ date page column title description source page_url trove_id
7923 7923 1901-06-12 3 b   Many rabbits in Mona Vale, New South Wales. Australia http://trove.nla.gov.au/newspaper/page/24100072 24100072
7925 7925 1901-06-12 3 b   A woman passenger died suddenly while travelling in a carriage. Australia http://trove.nla.gov.au/newspaper/page/24100072 24100072
7926 7926 1901-06-12 3 b   A girl in Coonamble, New South Wales, died in a fire. Australia http://trove.nla.gov.au/newspaper/page/24100072 24100072
7928 7928 1901-06-12 3 c   Chinese Liu Wugao in Carlton, Melbourne, was injured when travelling by train. Australia http://trove.nla.gov.au/newspaper/page/24100072 24100072

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]);