This data as json, CSV (advanced)
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 |
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]);