This data as json, CSV (advanced)
Suggested facets: page, date (date)
Link | rowid | date | page | column ▼ | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
52767 | 52767 | 1933-04-15 | 6 | d | Crisis between Germany and Poland. | Germany | http://trove.nla.gov.au/newspaper/page/24091192 | 24091192 | |
53739 | 53739 | 1934-01-06 | 6 | d | Zhang Xueliang on the way back to China. | Germany | http://trove.nla.gov.au/newspaper/page/24091491 | 24091491 | |
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 | |
55061 | 55061 | 1935-04-27 | 8 | d | Dethroned emperor of Germany is sick. | Germany | http://trove.nla.gov.au/newspaper/page/24096412 | 24096412 | |
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 | |
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]);