This data as json, CSV (advanced)
Suggested facets: column, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 19054 | 19054 | 1908-03-21 | 3 | a | French President to visit London. | Australia | http://trove.nla.gov.au/newspaper/page/26801669 | 26801669 | |
| 19055 | 19055 | 1908-03-21 | 3 | a | A Swedish man tries to assassinate King of Norway. | Australia | http://trove.nla.gov.au/newspaper/page/26801669 | 26801669 | |
| 19056 | 19056 | 1908-03-21 | 3 | a | Ten Indian immigrants are penalised in British Colombia. | Australia | http://trove.nla.gov.au/newspaper/page/26801669 | 26801669 | |
| 19057 | 19057 | 1908-03-21 | 3 | a | King of Spain narrowly escapes an assassination while reviewing Austrian army. | Australia | http://trove.nla.gov.au/newspaper/page/26801669 | 26801669 | |
| 19058 | 19058 | 1908-03-21 | 3 | a | The British-French Exhibition will be opened in London in May by the French President and the King of United Kingdom. | Australia | http://trove.nla.gov.au/newspaper/page/26801669 | 26801669 | |
| 19059 | 19059 | 1908-03-21 | 3 | a | Both import and export of France decline in January and February, 1908. | Australia | http://trove.nla.gov.au/newspaper/page/26801669 | 26801669 | |
| 19060 | 19060 | 1908-03-21 | 3 | a | A man from Boston travels around the world by motorbike and arrives in Jerusalem. | Australia | http://trove.nla.gov.au/newspaper/page/26801669 | 26801669 | |
| 19061 | 19061 | 1908-03-21 | 3 | a | Chaos in south India. | Australia | http://trove.nla.gov.au/newspaper/page/26801669 | 26801669 | |
| 19062 | 19062 | 1908-03-21 | 3 | b | Germany plans to build railway in its African colony. | Australia | http://trove.nla.gov.au/newspaper/page/26801669 | 26801669 | |
| 19063 | 19063 | 1908-03-21 | 3 | b | Japan comments on the proposed visit of American naval fleet to Australia. Canada also invites a visit of American fleet. | Australia | http://trove.nla.gov.au/newspaper/page/26801669 | 26801669 | |
| 19067 | 19067 | 1908-03-21 | 3 | d | Translation. Daily Telegraph in Sydney reports China's apology to Japan, and a translation of the report. | Australia | http://trove.nla.gov.au/newspaper/page/26801669 | 26801669 |
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]);