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 |
JSON shape: default, array, newline-delimited
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]);