This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid | date | page | column ▼ | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
42861 | 42861 | 1925-03-14 | 7 | b | Issues about the Chancellor in Germany. | Germany | http://trove.nla.gov.au/newspaper/page/24101065 | 24101065 | |
44934 | 44934 | 1926-07-10 | 7 | b | Floods in Europe. | Germany | http://trove.nla.gov.au/newspaper/page/24101627 | 24101627 | |
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 | |
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 | |
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 |
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]);