This data as json, CSV (advanced)
Link | rowid | date | page ▼ | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
20220 | 20220 | 1908-11-07 | 6 | c | An experimental flying ship in Germany falls. | Germany | http://trove.nla.gov.au/newspaper/page/26801944 | 26801944 | |
20253 | 20253 | 1908-11-14 | 6 | c | Newspaper publishing in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/26801952 | 26801952 | |
20468 | 20468 | 1909-01-02 | 6 | c | France and Germany have concluded their negotiation on the arrest of some deserted German soldiers in Morocco. | Germany | http://trove.nla.gov.au/newspaper/page/26802008 | 26802008 | |
20620 | 20620 | 1909-02-06 | 6 | c | Germans build a submarine. | Germany | http://trove.nla.gov.au/newspaper/page/26802072 | 26802072 | |
23794 | 23794 | 1910-11-12 | 6 | b | Germany's naval budget. | Germany | http://trove.nla.gov.au/newspaper/page/26802838 | 26802838 | |
39335 | 39335 | 1923-01-27 | 6 | d | Change of political situation in Europe. | Germany | http://trove.nla.gov.au/newspaper/page/24094272 | 24094272 | |
40138 | 40138 | 1923-07-21 | 6 | d | Ammunition factory in Germany has no directors. | Germany | http://trove.nla.gov.au/newspaper/page/24094484 | 24094484 | |
40166 | 40166 | 1923-07-28 | 6 | d | French troops in Germany. German authority seeks help from American government to maintain the value of mark. | Germany | http://trove.nla.gov.au/newspaper/page/24094492 | 24094492 | |
52767 | 52767 | 1933-04-15 | 6 | d | Crisis between Germany and Poland. | Germany | http://trove.nla.gov.au/newspaper/page/24091192 | 24091192 | |
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 | |
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 | |
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 | |
21156 | 21156 | 1909-06-12 | 7 | b | Tang Shaoyi is on his way to Shanghai. | Germany | http://trove.nla.gov.au/newspaper/page/26802217 | 26802217 | |
23959 | 23959 | 1910-12-10 | 7 | c-d | German Prince and his wife on the way to tour Asia. | Germany | http://trove.nla.gov.au/newspaper/page/26802869 | 26802869 | |
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 | |
30242 | 30242 | 1915-07-03 | 7 | b | The anniversary ceremony for memorising Austrian prince murdered is held both in Austria and Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24094900 | 24094900 | |
30435 | 30435 | 1915-09-04 | 7 | b | Germany refuses to admit its heavy loss in navy fight with Russia in Li Jia (ppp) Strait. | Germany | http://trove.nla.gov.au/newspaper/page/24094974 | 24094974 | |
38976 | 38976 | 1922-11-04 | 7 | b | Emperor of Germany, William, wants to marry a widow. | Germany | http://trove.nla.gov.au/newspaper/page/24094173 | 24094173 | |
41448 | 41448 | 1924-04-19 | 7 | b | A German teacher is sacked for introducing students to naked exercise. | Germany | http://trove.nla.gov.au/newspaper/page/24100691 | 24100691 | |
42751 | 42751 | 1925-02-21 | 7 | a-b | Rumour on the tri-alliance of China, Japan and Russia. | Germany | http://trove.nla.gov.au/newspaper/page/24101037 | 24101037 | |
42861 | 42861 | 1925-03-14 | 7 | b | Issues about the Chancellor in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24101065 | 24101065 | |
43436 | 43436 | 1925-07-04 | 7 | c | Chinese students in Berlin force Chinese ambassador Xu Shuzheng to sign a document. | Germany | http://trove.nla.gov.au/newspaper/page/24101195 | 24101195 | |
44934 | 44934 | 1926-07-10 | 7 | b | Floods in Europe. | Germany | http://trove.nla.gov.au/newspaper/page/24101627 | 24101627 | |
27905 | 27905 | 1913-09-20 | 8 | b | China and Russia may have clash on the Mongolian issues. | Germany | http://trove.nla.gov.au/newspaper/page/24092831 | 24092831 | |
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 | |
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 | |
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 | |
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 | |
55061 | 55061 | 1935-04-27 | 8 | d | Dethroned emperor of Germany is sick. | Germany | http://trove.nla.gov.au/newspaper/page/24096412 | 24096412 | |
55627 | 55627 | 1935-11-30 | 8 | a | Germany in heavy debt. | Germany | http://trove.nla.gov.au/newspaper/page/24096666 | 24096666 | |
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 | |
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 | |
56442 | 56442 | 1936-11-21 | 8 | c | Airforce troops in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24097073 | 24097073 |
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]);