This data as json, CSV (advanced)
Suggested facets: page, column, title, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 13532 | 13532 | 1904-07-16 | 3 | b | A revolutionary party in Russia has issued a proclamation. | Germany | http://trove.nla.gov.au/newspaper/page/26800479 | 26800479 | |
| 16319 | 16319 | 1906-10-13 | 2 | d | More than 20,000 bandits found in the coastal area of Shandong province. | Germany | http://trove.nla.gov.au/newspaper/page/26801107 | 26801107 | |
| 19244 | 19244 | 1908-04-25 | 3 | b | A famous old church in Berlin is burned to ashes. | Germany | http://trove.nla.gov.au/newspaper/page/26801709 | 26801709 | |
| 19587 | 19587 | 1908-07-04 | 2 | b-c | A comparison of imports and exports of Germany in 1906 and 1907. | Germany | http://trove.nla.gov.au/newspaper/page/26801792 | 26801792 | |
| 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 | |
| 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 | |
| 21665 | 21665 | 1909-09-18 | 3 | d | King of Belgium encourages Belgian capitalist to invest in China. | Germany | http://trove.nla.gov.au/newspaper/page/26802327 | 26802327 | |
| 22425 | 22425 | 1910-02-26 | 3 | b | German newspaper on German's interest in Manchuria and China. | Germany | http://trove.nla.gov.au/newspaper/page/26802535 | 26802535 | |
| 22859 | 22859 | 1910-05-28 | 2 | b | Yin Chang is appointed general commander of Chinese army and his policy. | Germany | http://trove.nla.gov.au/newspaper/page/26802641 | 26802641 | |
| 23784 | 23784 | 1910-11-12 | 3 | b | Prince of Germany starts his tour to the Far East. | Germany | http://trove.nla.gov.au/newspaper/page/26802833 | 26802833 | |
| 23794 | 23794 | 1910-11-12 | 6 | b | Germany's naval budget. | Germany | http://trove.nla.gov.au/newspaper/page/26802838 | 26802838 | |
| 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 | |
| 24035 | 24035 | 1910-12-24 | 3 | b-c | German parliament approves self-government in Alsace-Lorraine. | Germany | http://trove.nla.gov.au/newspaper/page/26802881 | 26802881 | |
| 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 |
| 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 |
| 26257 | 26257 | 1912-06-08 | 3 | b | German business ships are equipped with radio communication | German government orders all business ships be equipped with radio communication. | Germany | http://trove.nla.gov.au/newspaper/page/24092263 | 24092263 |
| 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 | |
| 26500 | 26500 | 1912-08-03 | 3 | b | Greece buys more warships from Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24092327 | 24092327 | |
| 26506 | 26506 | 1912-08-03 | 3 | b | German colony minister rejects black and white couple's divoice. | 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 | |
| 26968 | 26968 | 1913-02-08 | 3 | b | Germany plans to build wireless stations. | Germany | http://trove.nla.gov.au/newspaper/page/24092568 | 24092568 | |
| 27003 | 27003 | 1913-02-15 | 3 | b | German parliament approves its navy budget. | Germany | http://trove.nla.gov.au/newspaper/page/24092576 | 24092576 | |
| 27097 | 27097 | 1913-03-08 | 3 | b | British King and Queen attend banquet by German ambassador to Britain. | Germany | http://trove.nla.gov.au/newspaper/page/24092600 | 24092600 | |
| 27342 | 27342 | 1913-04-26 | 3 | b | French social party members asked to leave Germany due to their speech against Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24092656 | 24092656 | |
| 27549 | 27549 | 1913-07-05 | 3 | a | Germany has saved huge amount of gold. | Germany | http://trove.nla.gov.au/newspaper/page/24092736 | 24092736 | |
| 27824 | 27824 | 1913-09-06 | 3 | b | Riots in Wuhu, capital of Anhui province, fire at the German warship in the Yangtze River. | Germany | http://trove.nla.gov.au/newspaper/page/24092808 | 24092808 | |
| 27829 | 27829 | 1913-09-06 | 3 | c | Chinese government, on behalf of the riots in Wuhu, apologise to Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24092808 | 24092808 | |
| 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 | |
| 27858 | 27858 | 1913-09-13 | 3 | b | Airship across Atlantic. | Germany | http://trove.nla.gov.au/newspaper/page/24092816 | 24092816 | |
| 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 | |
| 27985 | 27985 | 1913-10-11 | 3 | b | Damages in Bulgaria caused by the war. | Germany | http://trove.nla.gov.au/newspaper/page/24092848 | 24092848 | |
| 28037 | 28037 | 1913-10-25 | 3 | b | German airship has accident during its flying test. | Germany | http://trove.nla.gov.au/newspaper/page/24092864 | 24092864 | |
| 28157 | 28157 | 1913-11-22 | 3 | b | Japan sets up consulate in Brazil. | Germany | http://trove.nla.gov.au/newspaper/page/24092896 | 24092896 | |
| 28300 | 28300 | 1913-12-20 | 3 | c | Germany withdraws from the Panama Exhibition in San Francisco. | Germany | http://trove.nla.gov.au/newspaper/page/24092928 | 24092928 | |
| 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 | |
| 28393 | 28393 | 1914-01-10 | 3 | c | Heavy snow in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24092952 | 24092952 | |
| 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 | |
| 28605 | 28605 | 1914-03-21 | 3 | c | The war clouds over Germany, Russia, France and Austria. | 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 | |
| 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 | |
| 29113 | 29113 | 1914-08-01 | 3 | a | Number of pilots in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24093195 | 24093195 | |
| 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 | |
| 29990 | 29990 | 1915-05-01 | 3 | c | German public reports have made different announcements on its troops' achievement. | Germany | http://trove.nla.gov.au/newspaper/page/24094824 | 24094824 | |
| 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 | |
| 30366 | 30366 | 1915-08-14 | 3 | b-c | Battle situation in east Europe between German and Russian troops. | Germany | http://trove.nla.gov.au/newspaper/page/24094944 | 24094944 | |
| 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 | |
| 34052 | 34052 | 1919-02-01 | 3 | c | Emperor of Germany William II gives up the throne and the report. | Germany | http://trove.nla.gov.au/newspaper/page/24097590 | 24097590 | |
| 34305 | 34305 | 1919-03-22 | 3 | e | Internal chaos in Germany and the damages. | Germany | http://trove.nla.gov.au/newspaper/page/24097653 | 24097653 | |
| 35986 | 35986 | 1920-08-07 | 3 | d | The Bolshevik Party in Poland and the disasters. | Germany | http://trove.nla.gov.au/newspaper/page/24098260 | 24098260 | |
| 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 | |
| 39335 | 39335 | 1923-01-27 | 6 | d | Change of political situation in Europe. | Germany | http://trove.nla.gov.au/newspaper/page/24094272 | 24094272 | |
| 39637 | 39637 | 1923-03-24 | 3 | d | German territory under the occupation of French army. | Germany | http://trove.nla.gov.au/newspaper/page/24094342 | 24094342 | |
| 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 | |
| 40313 | 40313 | 1923-09-01 | 2 | c-d | Population of the world. | Germany | http://trove.nla.gov.au/newspaper/page/24094528 | 24094528 | |
| 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 | |
| 42564 | 42564 | 1925-01-10 | 3 | e | New Year's greetings in Berlin, capital of Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24100994 | 24100994 | |
| 42734 | 42734 | 1925-02-21 | 3 | e | German authority arrests Communists. | Germany | http://trove.nla.gov.au/newspaper/page/24101033 | 24101033 | |
| 42741 | 42741 | 1925-02-21 | 3 | f | Coal mine explides in Germany and the tragedy. | Germany | http://trove.nla.gov.au/newspaper/page/24101033 | 24101033 | |
| 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 | |
| 42804 | 42804 | 1925-03-07 | 3 | e | German Chancellor is ill. | Germany | http://trove.nla.gov.au/newspaper/page/24101053 | 24101053 | |
| 42808 | 42808 | 1925-03-07 | 3 | f | German Chancellor dies. | Germany | http://trove.nla.gov.au/newspaper/page/24101053 | 24101053 | |
| 42843 | 42843 | 1925-03-14 | 3 | d | Election of Chancellor in Germany. Funeral of the late German Chancellor. | Germany | http://trove.nla.gov.au/newspaper/page/24101061 | 24101061 | |
| 42861 | 42861 | 1925-03-14 | 7 | b | Issues about the Chancellor in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24101065 | 24101065 | |
| 42945 | 42945 | 1925-04-04 | 3 | d | Germany and the League of Nations. | Germany | http://trove.nla.gov.au/newspaper/page/24101085 | 24101085 | |
| 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 | |
| 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 | |
| 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 | |
| 44934 | 44934 | 1926-07-10 | 7 | b | Floods in Europe. | Germany | http://trove.nla.gov.au/newspaper/page/24101627 | 24101627 | |
| 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 | |
| 45647 | 45647 | 1927-04-23 | 3 | e | Economic recovery in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24101955 | 24101955 | |
| 45787 | 45787 | 1927-06-11 | 2 | c-d | Germany and its naval forces. | Germany | http://trove.nla.gov.au/newspaper/page/24102018 | 24102018 | |
| 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 |
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]);