This data as json, CSV (advanced)
Suggested facets: 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| 42945 | 42945 | 1925-04-04 | 3 | d | Germany and the League of Nations. | Germany | http://trove.nla.gov.au/newspaper/page/24101085 | 24101085 | |
| 45647 | 45647 | 1927-04-23 | 3 | e | Economic recovery in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24101955 | 24101955 | |
| 46587 | 46587 | 1927-12-24 | 3 | b | German scientist predicts natural disasters. | Germany | http://trove.nla.gov.au/newspaper/page/24098639 | 24098639 | |
| 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 | |
| 53242 | 53242 | 1933-09-02 | 3 | e | Jewish people in Germany and their life. | Germany | http://trove.nla.gov.au/newspaper/page/24091349 | 24091349 | |
| 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 | |
| 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 | |
| 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 | |
| 55712 | 55712 | 1936-01-11 | 3 | c | British ambassador in Berlin meets Hitler. | Germany | http://trove.nla.gov.au/newspaper/page/24096703 | 24096703 | |
| 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 | |
| 56334 | 56334 | 1936-10-17 | 3 | c | Hitler awards medal to Japanese delegation. | Germany | http://trove.nla.gov.au/newspaper/page/24097027 | 24097027 | |
| 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]);