This data as json, CSV (advanced)
Suggested facets: date, column, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 42982 | 42982 | 1925-04-11 | 5 | b | Eighty-four German soldiers are drowned in an accident. | Germany | http://trove.nla.gov.au/newspaper/page/24101095 | 24101095 | |
| 43147 | 43147 | 1925-05-09 | 5 | c | Germany has new Chancellor Hans Luther. | Germany | http://trove.nla.gov.au/newspaper/page/24101127 | 24101127 | |
| 44391 | 44391 | 1926-02-06 | 5 | a | German authority and the League of Nations. | Germany | http://trove.nla.gov.au/newspaper/page/24101448 | 24101448 | |
| 44460 | 44460 | 1926-02-27 | 5 | a | Salary of the German president. | Germany | http://trove.nla.gov.au/newspaper/page/24101471 | 24101471 | |
| 44462 | 44462 | 1926-02-27 | 5 | a | German government helps industrial development. | Germany | http://trove.nla.gov.au/newspaper/page/24101471 | 24101471 | |
| 44763 | 44763 | 1926-05-22 | 5 | c | New cabinet organised in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24101567 | 24101567 | |
| 46006 | 46006 | 1927-08-06 | 5 | a | Inheritance of the emperor of Romania. | Germany | http://trove.nla.gov.au/newspaper/page/24098481 | 24098481 | |
| 46016 | 46016 | 1927-08-06 | 5 | c | Preparation for the World War II. | Germany | http://trove.nla.gov.au/newspaper/page/24098481 | 24098481 | |
| 46047 | 46047 | 1927-08-13 | 5 | c | Germany to convene a disarmament conference. | Germany | http://trove.nla.gov.au/newspaper/page/24098489 | 24098489 | |
| 46158 | 46158 | 1927-09-10 | 5 | b | Floods in Poland. | Germany | http://trove.nla.gov.au/newspaper/page/24098521 | 24098521 | |
| 46280 | 46280 | 1927-10-08 | 5 | a | Fire in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24098553 | 24098553 | |
| 46372 | 46372 | 1927-10-29 | 5 | c | German government intervenes with the strike. | Germany | http://trove.nla.gov.au/newspaper/page/24098577 | 24098577 | |
| 46392 | 46392 | 1927-11-05 | 5 | a | President of Germany is sick. | Germany | http://trove.nla.gov.au/newspaper/page/24098585 | 24098585 | |
| 46398 | 46398 | 1927-11-05 | 5 | c | Germany in recovery. | Germany | http://trove.nla.gov.au/newspaper/page/24098585 | 24098585 | |
| 46420 | 46420 | 1927-11-12 | 5 | a | The Sun Club in Berlin and their naked sunbath. | Germany | http://trove.nla.gov.au/newspaper/page/24098593 | 24098593 | |
| 46455 | 46455 | 1927-11-19 | 5 | b | German invents new ship. | Germany | http://trove.nla.gov.au/newspaper/page/24098601 | 24098601 | |
| 46735 | 46735 | 1928-02-11 | 5 | b | Demonstration in Berlin and the clash with police. | Germany | http://trove.nla.gov.au/newspaper/page/24098689 | 24098689 |
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]);