This data as json, CSV (advanced)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 46533 | 46533 | 1927-12-10 | 2 | f | Genghis Khan's grave found in Mongolia. | Germany | http://trove.nla.gov.au/newspaper/page/24098624 | 24098624 | |
| 46587 | 46587 | 1927-12-24 | 3 | b | German scientist predicts natural disasters. | Germany | http://trove.nla.gov.au/newspaper/page/24098639 | 24098639 | |
| 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 | |
| 47089 | 47089 | 1928-06-02 | 2 | c | The amalgamation Germany and Austria. | Germany | http://trove.nla.gov.au/newspaper/page/24098826 | 24098826 | |
| 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 | |
| 48510 | 48510 | 1929-09-28 | 8 | d | Man-made fog in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24099379 | 24099379 | |
| 48674 | 48674 | 1929-11-30 | 2 | b | A survey on the military forces of the Soviet Russia. | Germany | http://trove.nla.gov.au/newspaper/page/24099447 | 24099447 | |
| 48792 | 48792 | 1930-01-11 | 8 | c | Quite a few people commit suicide in Germany since the New Year. | Germany | http://trove.nla.gov.au/newspaper/page/24099493 | 24099493 | |
| 49340 | 49340 | 1930-07-19 | 8 | c | Coal mine explodes in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24099713 | 24099713 | |
| 49623 | 49623 | 1930-10-25 | 8 | b | Workers in Germany on strike. | Germany | http://trove.nla.gov.au/newspaper/page/24099828 | 24099828 | |
| 49629 | 49629 | 1930-10-25 | 8 | d | Clash between the communists and police in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24099828 | 24099828 | |
| 49651 | 49651 | 1930-11-01 | 8 | c | German politicians cut their salary. | Germany | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
| 49840 | 49840 | 1930-12-27 | 8 | b | All foreign troops have left Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24099899 | 24099899 | |
| 50047 | 50047 | 1931-02-28 | 8 | b | Explosion of a coal mine in Germany claims many lives. | Germany | http://trove.nla.gov.au/newspaper/page/24090298 | 24090298 | |
| 50530 | 50530 | 1931-07-18 | 8 | c | Almost all banks in Germany stop their business. | Germany | http://trove.nla.gov.au/newspaper/page/24090459 | 24090459 | |
| 50531 | 50531 | 1931-07-18 | 8 | c | Economic panic in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24090459 | 24090459 | |
| 50554 | 50554 | 1931-07-25 | 8 | c | The Communist members in Germany rob shops. | Germany | http://trove.nla.gov.au/newspaper/page/24090467 | 24090467 | |
| 50555 | 50555 | 1931-07-25 | 8 | c | Martial law enforced in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24090467 | 24090467 | |
| 50615 | 50615 | 1931-08-15 | 8 | b | Train bombed in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24090493 | 24090493 | |
| 51084 | 51084 | 1932-01-16 | 8 | c | Germany is unable to repay the debts of war. | Germany | http://trove.nla.gov.au/newspaper/page/24090668 | 24090668 | |
| 51377 | 51377 | 1932-04-09 | 2 | e | Methods to prevent gas bombs. | Germany | http://trove.nla.gov.au/newspaper/page/24090760 | 24090760 | |
| 51434 | 51434 | 1932-04-16 | 8 | b | Presidential election in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24090774 | 24090774 | |
| 51671 | 51671 | 1932-07-02 | 8 | b | Internal chaos in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24090862 | 24090862 | |
| 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 | |
| 51762 | 51762 | 1932-07-30 | 8 | b | German government denies arms sale to Japan. | Germany | http://trove.nla.gov.au/newspaper/page/24090894 | 24090894 | |
| 51781 | 51781 | 1932-08-06 | 8 | b | Hu Shi is elected member of the Preussische Akademie Der Wisseuschalteu. | Germany | http://trove.nla.gov.au/newspaper/page/24090902 | 24090902 | |
| 51785 | 51785 | 1932-08-06 | 8 | c | Election in Germany and the chaos. | Germany | http://trove.nla.gov.au/newspaper/page/24090902 | 24090902 | |
| 52110 | 52110 | 1932-10-29 | 8 | c | Japanese ambassador in Germany is recalled back. | Germany | http://trove.nla.gov.au/newspaper/page/24091006 | 24091006 | |
| 52163 | 52163 | 1932-11-05 | 8 | d | Speech by German member of the delegation of League of Nations on the Chinese situations. | Germany | http://trove.nla.gov.au/newspaper/page/24091014 | 24091014 | |
| 52229 | 52229 | 1932-11-26 | 2 | c | Rightist movement in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24091032 | 24091032 | |
| 52257 | 52257 | 1932-11-26 | 8 | b | German President and the new cabinet to be organised. | Germany | http://trove.nla.gov.au/newspaper/page/24091038 | 24091038 | |
| 52767 | 52767 | 1933-04-15 | 6 | d | Crisis between Germany and Poland. | Germany | http://trove.nla.gov.au/newspaper/page/24091192 | 24091192 | |
| 52777 | 52777 | 1933-04-22 | 3 | c | German changes its national flag. | Germany | http://trove.nla.gov.au/newspaper/page/24091195 | 24091195 | |
| 52806 | 52806 | 1933-04-29 | 3 | c | Casualties of the famine in Russia. | Germany | http://trove.nla.gov.au/newspaper/page/24091203 | 24091203 | |
| 52938 | 52938 | 1933-06-03 | 3 | b | Chinese General Ma Zhanshan talks in Berlin. | Germany | http://trove.nla.gov.au/newspaper/page/24091243 | 24091243 | |
| 53039 | 53039 | 1933-07-01 | 6 | c | German government bans Socialist Party members. | Germany | http://trove.nla.gov.au/newspaper/page/24091282 | 24091282 | |
| 53179 | 53179 | 1933-08-12 | 6 | a | Communists executed in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24091330 | 24091330 | |
| 53242 | 53242 | 1933-09-02 | 3 | e | Jewish people in Germany and their life. | Germany | http://trove.nla.gov.au/newspaper/page/24091349 | 24091349 | |
| 53739 | 53739 | 1934-01-06 | 6 | d | Zhang Xueliang on the way back to China. | Germany | http://trove.nla.gov.au/newspaper/page/24091491 | 24091491 | |
| 54069 | 54069 | 1934-04-14 | 6 | c | Population increase in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24095976 | 24095976 | |
| 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 | |
| 54528 | 54528 | 1934-09-22 | 3 | b | A talk by Hitler in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24096165 | 24096165 | |
| 54596 | 54596 | 1934-10-13 | 3 | d | Germany disagrees with Britain, France and Italy on the mutual agreement between Eastern European countries. | Germany | http://trove.nla.gov.au/newspaper/page/24096189 | 24096189 | |
| 54693 | 54693 | 1934-11-24 | 6 | b | German government and press censorship. | Germany | http://trove.nla.gov.au/newspaper/page/24096244 | 24096244 | |
| 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 | |
| 54984 | 54984 | 1935-03-30 | 6 | b | Enlistment in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24096379 | 24096379 | |
| 55049 | 55049 | 1935-04-27 | 3 | b | New enlistment system in Germany and the protest of other countries. | Germany | http://trove.nla.gov.au/newspaper/page/24096406 | 24096406 | |
| 55061 | 55061 | 1935-04-27 | 8 | d | Dethroned emperor of Germany is sick. | Germany | http://trove.nla.gov.au/newspaper/page/24096412 | 24096412 | |
| 55141 | 55141 | 1935-05-25 | 3 | e | Germany continues its arms expansion. | Germany | http://trove.nla.gov.au/newspaper/page/24096440 | 24096440 | |
| 55216 | 55216 | 1935-06-22 | 3 | c | Germany invents torpedo cruisers. | Germany | http://trove.nla.gov.au/newspaper/page/24096472 | 24096472 | |
| 55244 | 55244 | 1935-07-06 | 3 | e | German envoy to discuss naval cooperation with Britain. | Germany | http://trove.nla.gov.au/newspaper/page/24096488 | 24096488 | |
| 55467 | 55467 | 1935-09-28 | 3 | d | German treasurer advises his fellow people to lead a thrifty life. | Germany | http://trove.nla.gov.au/newspaper/page/24096586 | 24096586 | |
| 55521 | 55521 | 1935-10-19 | 3 | e | Germany refuses to join other European countries for the group safety. | Germany | http://trove.nla.gov.au/newspaper/page/24096611 | 24096611 | |
| 55555 | 55555 | 1935-11-02 | 3 | c | Diplomatic negotiations between Hungary and Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24096627 | 24096627 | |
| 55627 | 55627 | 1935-11-30 | 8 | a | Germany in heavy debt. | Germany | http://trove.nla.gov.au/newspaper/page/24096666 | 24096666 | |
| 55712 | 55712 | 1936-01-11 | 3 | c | British ambassador in Berlin meets Hitler. | Germany | http://trove.nla.gov.au/newspaper/page/24096703 | 24096703 | |
| 55891 | 55891 | 1936-03-14 | 8 | c | Maenuvre of German troops along the Rhein River. | Germany | http://trove.nla.gov.au/newspaper/page/24096782 | 24096782 | |
| 55950 | 55950 | 1936-04-04 | 8 | d | The election in Germany and the winner. | Germany | http://trove.nla.gov.au/newspaper/page/24096806 | 24096806 | |
| 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 | |
| 56140 | 56140 | 1936-08-08 | 3 | e | Delegation of the Manchurian government arrives Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24096945 | 24096945 | |
| 56212 | 56212 | 1936-08-29 | 3 | b | Dai Jitao, Wang Zhengting and Zou Lu visit Germany and the welcome. | Germany | http://trove.nla.gov.au/newspaper/page/24096969 | 24096969 | |
| 56223 | 56223 | 1936-08-29 | 8 | d | Five eastern European countries to jointly guard against Soviet Russia. | Germany | http://trove.nla.gov.au/newspaper/page/24096976 | 24096976 | |
| 56334 | 56334 | 1936-10-17 | 3 | c | Hitler awards medal to Japanese delegation. | Germany | http://trove.nla.gov.au/newspaper/page/24097027 | 24097027 | |
| 56442 | 56442 | 1936-11-21 | 8 | c | Airforce troops in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24097073 | 24097073 | |
| 56469 | 56469 | 1936-12-05 | 3 | b | German newspaper on the relations between China and Japan. | Germany | http://trove.nla.gov.au/newspaper/page/24097084 | 24097084 | |
| 56520 | 56520 | 1936-12-26 | 3 | c | Hitler declares to abrogate the peace treaty. | Germany | http://trove.nla.gov.au/newspaper/page/24097110 | 24097110 |
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]);