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 |
|---|---|---|---|---|---|---|---|---|---|
| 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]);