This data as json, CSV (advanced)
Suggested facets: date, page, title, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 25494 | 25494 | 1911-12-30 | 3 | a | A huge gun appears | Germany has build a huge gun as long as 60 feet. | Germany | http://trove.nla.gov.au/newspaper/page/24092050 | 24092050 |
| 25712 | 25712 | 1912-02-10 | 3 | a | German bans intermarriage | German bans its people to intermarry Samoans. | Germany | http://trove.nla.gov.au/newspaper/page/24092098 | 24092098 |
| 25782 | 25782 | 1912-02-24 | 11 | a | German and non-German students in German universities | Statistics of German students and students from other countries in German universities. | Germany | http://trove.nla.gov.au/newspaper/page/24092125 | 24092125 |
| 26419 | 26419 | 1912-07-20 | 3 | a | French spy sentenced in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24092311 | 24092311 | |
| 26496 | 26496 | 1912-08-03 | 3 | a | German aircraft's speed is fastest in the world. | Germany | http://trove.nla.gov.au/newspaper/page/24092327 | 24092327 | |
| 26538 | 26538 | 1912-08-10 | 3 | a | Germany not happy with China's appointment of British journalist of The Times as political adviser as he criticises German invasion of China. | Germany | http://trove.nla.gov.au/newspaper/page/24092335 | 24092335 | |
| 26727 | 26727 | 1912-09-14 | 3 | a | Debate over tax of the Pananma Canal. | Germany | http://trove.nla.gov.au/newspaper/page/24092375 | 24092375 | |
| 26728 | 26728 | 1912-09-14 | 3 | a | Swedish king inspects big army exercise. | Germany | http://trove.nla.gov.au/newspaper/page/24092375 | 24092375 | |
| 26764 | 26764 | 1912-09-21 | 3 | a | Italy soon reaches peace agreement with Turkey. | Germany | http://trove.nla.gov.au/newspaper/page/24092383 | 24092383 | |
| 27549 | 27549 | 1913-07-05 | 3 | a | Germany has saved huge amount of gold. | Germany | http://trove.nla.gov.au/newspaper/page/24092736 | 24092736 | |
| 27853 | 27853 | 1913-09-13 | 3 | a | Germany to install radio communication in Nanyang islands including Samoa. | Germany | http://trove.nla.gov.au/newspaper/page/24092816 | 24092816 | |
| 27854 | 27854 | 1913-09-13 | 3 | a | A woman in Berlin presents a bundle of flowers to the Emperor and causes panic. | Germany | http://trove.nla.gov.au/newspaper/page/24092816 | 24092816 | |
| 29113 | 29113 | 1914-08-01 | 3 | a | Number of pilots in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24093195 | 24093195 | |
| 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 | |
| 45477 | 45477 | 1927-02-05 | 12 | a | Industrial development and prosperity in Germany after the World War I. | Germany | http://trove.nla.gov.au/newspaper/page/24101881 | 24101881 | |
| 46006 | 46006 | 1927-08-06 | 5 | a | Inheritance of the emperor of Romania. | Germany | http://trove.nla.gov.au/newspaper/page/24098481 | 24098481 | |
| 46280 | 46280 | 1927-10-08 | 5 | a | Fire in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24098553 | 24098553 | |
| 46392 | 46392 | 1927-11-05 | 5 | a | President of Germany is sick. | 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 | |
| 47103 | 47103 | 1928-06-02 | 8 | a | Gas factory explodes in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24098832 | 24098832 | |
| 47129 | 47129 | 1928-06-09 | 8 | a | A big plane manufactured in Berlin, Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24098840 | 24098840 | |
| 48102 | 48102 | 1929-05-11 | 8 | a | The Communist movement in Berlin, Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24099216 | 24099216 | |
| 51738 | 51738 | 1932-07-23 | 8 | a | German government bans demonstration of any political parties. | Germany | http://trove.nla.gov.au/newspaper/page/24090886 | 24090886 | |
| 53179 | 53179 | 1933-08-12 | 6 | a | Communists executed in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24091330 | 24091330 | |
| 54419 | 54419 | 1934-08-11 | 6 | a | German President dies and a further report. | Germany | http://trove.nla.gov.au/newspaper/page/24096120 | 24096120 | |
| 54438 | 54438 | 1934-08-18 | 6 | a | Funeral for the German president. | Germany | http://trove.nla.gov.au/newspaper/page/24096128 | 24096128 | |
| 54508 | 54508 | 1934-09-15 | 3 | a | German government increases its military budget. | Germany | http://trove.nla.gov.au/newspaper/page/24096157 | 24096157 | |
| 54709 | 54709 | 1934-12-01 | 6 | a | Proposal in France for alliance with Russia for the containment of Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24096251 | 24096251 | |
| 54924 | 54924 | 1935-03-02 | 6 | a | Dethroned emperor of Germany wants to return. | Germany | http://trove.nla.gov.au/newspaper/page/24096347 | 24096347 | |
| 55627 | 55627 | 1935-11-30 | 8 | a | Germany in heavy debt. | Germany | http://trove.nla.gov.au/newspaper/page/24096666 | 24096666 | |
| 56096 | 56096 | 1936-07-25 | 3 | a | Shanghai may be on the same level with Berlin within five years. | Germany | http://trove.nla.gov.au/newspaper/page/24096929 | 24096929 |
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]);