Article Index

8 rows where "date" is on date 1901-12-14 and source = "Australia"

Filter results

This data as json, CSV (advanced)

Suggested facets: page, column, page_url, trove_id, date (date)

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

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