Article Index

2 rows where "date" is on date 1914-08-01 and source = "Germany"

Filter results

This data as json, CSV (advanced)

Suggested facets: date (date)

Link rowid ▼ date page column title description source page_url trove_id
29113 29113 1914-08-01 3 a   Number of pilots in Germany. Germany http://trove.nla.gov.au/newspaper/page/24093195 24093195
29132 29132 1914-08-01 7 b-c   Austrian archduke Francis Ferdinand and his wife, Sophie, are shot dead in the Bosnian capital, Sarajevo. Austrians send ultimate to Serbs. Austrian and Serbs suspend their diplomatic relations. The ultimate are refused. A large-scale war (World War I) breaks out in Europe. Germany http://trove.nla.gov.au/newspaper/page/24093199 24093199

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