This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 23794 | 23794 | 1910-11-12 | 6 | b | Germany's naval budget. | Germany | http://trove.nla.gov.au/newspaper/page/26802838 | 26802838 | |
| 39335 | 39335 | 1923-01-27 | 6 | d | Change of political situation in Europe. | Germany | http://trove.nla.gov.au/newspaper/page/24094272 | 24094272 | |
| 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 | |
| 52767 | 52767 | 1933-04-15 | 6 | d | Crisis between Germany and Poland. | Germany | http://trove.nla.gov.au/newspaper/page/24091192 | 24091192 | |
| 53039 | 53039 | 1933-07-01 | 6 | c | German government bans Socialist Party members. | Germany | http://trove.nla.gov.au/newspaper/page/24091282 | 24091282 | |
| 53179 | 53179 | 1933-08-12 | 6 | a | Communists executed in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24091330 | 24091330 | |
| 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 | |
| 54069 | 54069 | 1934-04-14 | 6 | c | Population increase in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24095976 | 24095976 | |
| 54419 | 54419 | 1934-08-11 | 6 | a | German President dies and a further report. | Germany | http://trove.nla.gov.au/newspaper/page/24096120 | 24096120 | |
| 54438 | 54438 | 1934-08-18 | 6 | a | Funeral for the German president. | Germany | http://trove.nla.gov.au/newspaper/page/24096128 | 24096128 | |
| 54693 | 54693 | 1934-11-24 | 6 | b | German government and press censorship. | Germany | http://trove.nla.gov.au/newspaper/page/24096244 | 24096244 | |
| 54709 | 54709 | 1934-12-01 | 6 | a | Proposal in France for alliance with Russia for the containment of Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24096251 | 24096251 | |
| 54924 | 54924 | 1935-03-02 | 6 | a | Dethroned emperor of Germany wants to return. | Germany | http://trove.nla.gov.au/newspaper/page/24096347 | 24096347 | |
| 54984 | 54984 | 1935-03-30 | 6 | b | Enlistment in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24096379 | 24096379 |
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]);