This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 21156 | 21156 | 1909-06-12 | 7 | b | Tang Shaoyi is on his way to Shanghai. | Germany | http://trove.nla.gov.au/newspaper/page/26802217 | 26802217 | |
| 23959 | 23959 | 1910-12-10 | 7 | c-d | German Prince and his wife on the way to tour Asia. | Germany | http://trove.nla.gov.au/newspaper/page/26802869 | 26802869 | |
| 29132 | 29132 | 1914-08-01 | 7 | b-c | Austrian archduke Francis Ferdinand and his wife, Sophie, are shot dead in the Bosnian capital, Sarajevo. Austrians send ultimate to Serbs. Austrian and Serbs suspend their diplomatic relations. The ultimate are refused. A large-scale war (World War I) breaks out in Europe. | Germany | http://trove.nla.gov.au/newspaper/page/24093199 | 24093199 | |
| 30242 | 30242 | 1915-07-03 | 7 | b | The anniversary ceremony for memorising Austrian prince murdered is held both in Austria and Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24094900 | 24094900 | |
| 30435 | 30435 | 1915-09-04 | 7 | b | Germany refuses to admit its heavy loss in navy fight with Russia in Li Jia (ppp) Strait. | Germany | http://trove.nla.gov.au/newspaper/page/24094974 | 24094974 | |
| 38976 | 38976 | 1922-11-04 | 7 | b | Emperor of Germany, William, wants to marry a widow. | Germany | http://trove.nla.gov.au/newspaper/page/24094173 | 24094173 | |
| 41448 | 41448 | 1924-04-19 | 7 | b | A German teacher is sacked for introducing students to naked exercise. | Germany | http://trove.nla.gov.au/newspaper/page/24100691 | 24100691 | |
| 42751 | 42751 | 1925-02-21 | 7 | a-b | Rumour on the tri-alliance of China, Japan and Russia. | Germany | http://trove.nla.gov.au/newspaper/page/24101037 | 24101037 | |
| 42861 | 42861 | 1925-03-14 | 7 | b | Issues about the Chancellor in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24101065 | 24101065 | |
| 43436 | 43436 | 1925-07-04 | 7 | c | Chinese students in Berlin force Chinese ambassador Xu Shuzheng to sign a document. | Germany | http://trove.nla.gov.au/newspaper/page/24101195 | 24101195 | |
| 44934 | 44934 | 1926-07-10 | 7 | b | Floods in Europe. | Germany | http://trove.nla.gov.au/newspaper/page/24101627 | 24101627 |
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]);