This data as json, CSV (advanced)
Suggested facets: date, column, page_url, trove_id, date (date)
Link | rowid | date | page | column ▼ | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
55627 | 55627 | 1935-11-30 | 8 | a | Germany in heavy debt. | Germany | http://trove.nla.gov.au/newspaper/page/24096666 | 24096666 | |
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 | |
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 | |
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 | |
49651 | 49651 | 1930-11-01 | 8 | c | German politicians cut their salary. | Germany | http://trove.nla.gov.au/newspaper/page/24099835 | 24099835 | |
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 | |
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 | |
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 | |
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 | |
56442 | 56442 | 1936-11-21 | 8 | c | Airforce troops in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24097073 | 24097073 | |
48510 | 48510 | 1929-09-28 | 8 | d | Man-made fog in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24099379 | 24099379 | |
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 | |
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 | |
55061 | 55061 | 1935-04-27 | 8 | d | Dethroned emperor of Germany is sick. | Germany | http://trove.nla.gov.au/newspaper/page/24096412 | 24096412 | |
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 |
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]);