Article Index

4 rows where column = "b-c" and source = "Germany"

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
19587 19587 1908-07-04 2 b-c   A comparison of imports and exports of Germany in 1906 and 1907. Germany http://trove.nla.gov.au/newspaper/page/26801792 26801792
24035 24035 1910-12-24 3 b-c   German parliament approves self-government in Alsace-Lorraine. Germany http://trove.nla.gov.au/newspaper/page/26802881 26802881
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
30366 30366 1915-08-14 3 b-c   Battle situation in east Europe between German and Russian troops. Germany http://trove.nla.gov.au/newspaper/page/24094944 24094944

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