This data as json, CSV (advanced)
Link | rowid | date | page | column ▲ | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
28323 | 28323 | 1913-12-27 | 3 | b | Prince of Germany might be forced to divorce. | Germany | http://trove.nla.gov.au/newspaper/page/24092936 | 24092936 | |
28356 | 28356 | 1914-01-03 | 3 | b | Chinese government approves German company to build railway in north China. | Germany | http://trove.nla.gov.au/newspaper/page/24092944 | 24092944 | |
28420 | 28420 | 1914-01-17 | 3 | b | Prince of Germany leaves the army and his farewell speech. | Germany | http://trove.nla.gov.au/newspaper/page/24092960 | 24092960 | |
28510 | 28510 | 1914-02-28 | 3 | b | German government interferes with newspaper publishing. | Germany | http://trove.nla.gov.au/newspaper/page/24093021 | 24093021 | |
28571 | 28571 | 1914-03-14 | 3 | b | Russian authority prepares to attack Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24093037 | 24093037 | |
28596 | 28596 | 1914-03-21 | 3 | b | German authority imposes war tax and the protest from other countries. | Germany | http://trove.nla.gov.au/newspaper/page/24093045 | 24093045 | |
28720 | 28720 | 1914-04-18 | 3 | b | German authority to collect special tax for war. | Germany | http://trove.nla.gov.au/newspaper/page/24093077 | 24093077 | |
28780 | 28780 | 1914-05-02 | 3 | b | German authority to impose more taxes. | Germany | http://trove.nla.gov.au/newspaper/page/24093093 | 24093093 | |
28833 | 28833 | 1914-05-16 | 3 | b | Diplomatic relation between Germany and France deteriorates. | Germany | http://trove.nla.gov.au/newspaper/page/24093109 | 24093109 | |
30020 | 30020 | 1915-05-08 | 3 | b | German public reports announce different results of battle situation. | Germany | http://trove.nla.gov.au/newspaper/page/24094832 | 24094832 | |
30125 | 30125 | 1915-06-05 | 3 | b | Germany attempts to make Romania a neutral nation. | Germany | http://trove.nla.gov.au/newspaper/page/24094864 | 24094864 | |
30126 | 30126 | 1915-06-05 | 3 | b | A Russian warship is sunken by Turkish submarine in the Black Sea. | Germany | http://trove.nla.gov.au/newspaper/page/24094864 | 24094864 | |
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 | |
30553 | 30553 | 1915-10-09 | 3 | b | Battle situation in west Europe between German, British and French troops. | Germany | http://trove.nla.gov.au/newspaper/page/24095010 | 24095010 | |
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 | |
42861 | 42861 | 1925-03-14 | 7 | b | Issues about the Chancellor in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24101065 | 24101065 | |
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 | |
44934 | 44934 | 1926-07-10 | 7 | b | Floods in Europe. | Germany | http://trove.nla.gov.au/newspaper/page/24101627 | 24101627 | |
46158 | 46158 | 1927-09-10 | 5 | b | Floods in Poland. | Germany | http://trove.nla.gov.au/newspaper/page/24098521 | 24098521 | |
46455 | 46455 | 1927-11-19 | 5 | b | German invents new ship. | Germany | http://trove.nla.gov.au/newspaper/page/24098601 | 24098601 | |
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 | |
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 | |
49623 | 49623 | 1930-10-25 | 8 | b | Workers in Germany on strike. | Germany | http://trove.nla.gov.au/newspaper/page/24099828 | 24099828 | |
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 | |
50615 | 50615 | 1931-08-15 | 8 | b | Train bombed in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24090493 | 24090493 | |
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 | |
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 | |
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 | |
52938 | 52938 | 1933-06-03 | 3 | b | Chinese General Ma Zhanshan talks in Berlin. | Germany | http://trove.nla.gov.au/newspaper/page/24091243 | 24091243 | |
54528 | 54528 | 1934-09-22 | 3 | b | A talk by Hitler in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24096165 | 24096165 | |
54693 | 54693 | 1934-11-24 | 6 | b | German government and press censorship. | Germany | http://trove.nla.gov.au/newspaper/page/24096244 | 24096244 | |
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 | |
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 | |
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 | |
29064 | 29064 | 1914-07-18 | 3 | a-b | Serbia gangs assassinate Austrian prince and now target the Emperor of Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24093179 | 24093179 | |
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 | |
26180 | 26180 | 1912-05-25 | 3 | a | Volcano eruption in America | A volcano near Panama Canal erupted, resulting in huge casualties. | Germany | http://trove.nla.gov.au/newspaper/page/24092247 | 24092247 |
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]);