This data as json, CSV (advanced)
Suggested facets: page, title, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 24994 | 24994 | 1911-09-16 | 3 | a-b | Jews expelled | About five thousand jews are to be expelled by Russian government. | Russia | http://trove.nla.gov.au/newspaper/page/24091920 | 24091920 |
| 25060 | 25060 | 1911-09-30 | 3 | a-b | Russian president dies | Russian president died of shooting by a jewdish several weeks ago. | Russia | http://trove.nla.gov.au/newspaper/page/24091937 | 24091937 |
| 25713 | 25713 | 1912-02-10 | 3 | a-b | Britain-Russia relation | Some British parliament members are welcome for their visit to Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24092098 | 24092098 |
| 26327 | 26327 | 1912-06-22 | 3 | a-b | Tram robbed | Russian tram is robbed and driver killed. | Russia | http://trove.nla.gov.au/newspaper/page/24092279 | 24092279 |
| 28032 | 28032 | 1913-10-25 | 3 | a-b | A Jewish rabbi is arrested in Russia on the death of a child. | Russia | http://trove.nla.gov.au/newspaper/page/24092864 | 24092864 | |
| 30675 | 30675 | 1915-11-06 | 7 | a-b | German troops in Li Jia (ppp) port suffer setbacks due to insufficient ammunition. | Russia | http://trove.nla.gov.au/newspaper/page/24095046 | 24095046 | |
| 30745 | 30745 | 1915-11-27 | 3 | a-b | Germany is to train troops of Persia and Russia sends more troops to Persia. | Russia | http://trove.nla.gov.au/newspaper/page/24095066 | 24095066 |
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]);