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 |
---|---|---|---|---|---|---|---|---|---|
29142 | 29142 | 1914-08-08 | 3 | b-c | The coming large-scale war (World War I) in Europe and different response of various countries (Austria, Russia, Italy, Germany, France, Britain,), market in panic and other social & political influence. | Other... | http://trove.nla.gov.au/newspaper/page/24093203 | 24093203 | |
29143 | 29143 | 1914-08-08 | 3 | c | Local residents in Java and a Chinese magistrate is murdered. | Other... | http://trove.nla.gov.au/newspaper/page/24093203 | 24093203 | |
29144 | 29144 | 1914-08-08 | 3 | c | Deposed Mexican president Victoriano Huerta is on the way to Spain. | Other... | http://trove.nla.gov.au/newspaper/page/24093203 | 24093203 | |
29151 | 29151 | 1914-08-08 | 7 | b-c | The war (World War I) breaks out in Europe (war between Germany and France, Britain declares war with Germany, Australian army in Queensland fire at fleeing German ship) and report on the battles. | Other... | http://trove.nla.gov.au/newspaper/page/24093207 | 24093207 |
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]);