This data as json, CSV (advanced)
Suggested facets: date, column, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 43177 | 43177 | 1925-05-16 | 5 | b | Bandits are trapped while robbing a bank in Moscow, Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24101135 | 24101135 | |
| 43223 | 43223 | 1925-05-23 | 5 | b | A political prisoner in Russia commits suicide. | Russia | http://trove.nla.gov.au/newspaper/page/24101143 | 24101143 | |
| 44155 | 44155 | 1925-11-21 | 5 | c | Dictatorship of the Soviet communist regime. | Russia | http://trove.nla.gov.au/newspaper/page/24101358 | 24101358 | |
| 44573 | 44573 | 1926-04-03 | 5 | b | News from Leningrad on the social life there. | Russia | http://trove.nla.gov.au/newspaper/page/24101511 | 24101511 | |
| 44874 | 44874 | 1926-06-26 | 5 | a | Soviet Russia replies to the protest of the British government. | Russia | http://trove.nla.gov.au/newspaper/page/24101610 | 24101610 | |
| 45008 | 45008 | 1926-07-31 | 5 | c | News on the Third International, or Communist International, byname Comintern. | Russia | http://trove.nla.gov.au/newspaper/page/24101649 | 24101649 | |
| 45823 | 45823 | 1927-06-18 | 5 | c | Attempt to bomb the communist meeting in Moscow. | Russia | http://trove.nla.gov.au/newspaper/page/24102028 | 24102028 | |
| 46013 | 46013 | 1927-08-06 | 5 | c | Stalin publishes a speech in newspaper. | Russia | http://trove.nla.gov.au/newspaper/page/24098481 | 24098481 | |
| 46106 | 46106 | 1927-08-27 | 5 | c | Rumours on riots in Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24098505 | 24098505 | |
| 46187 | 46187 | 1927-09-17 | 5 | b | Soviet Russian authority treats strikers cruelly. | Russia | http://trove.nla.gov.au/newspaper/page/24098529 | 24098529 | |
| 46218 | 46218 | 1927-09-24 | 5 | b | Earthquake near the Black Sea. | Russia | http://trove.nla.gov.au/newspaper/page/24098537 | 24098537 | |
| 46219 | 46219 | 1927-09-24 | 5 | b | Chen Youren and his recent talks in Moscow. | Russia | http://trove.nla.gov.au/newspaper/page/24098537 | 24098537 | |
| 46281 | 46281 | 1927-10-08 | 5 | a | A Russian woman murders her husband. | Russia | http://trove.nla.gov.au/newspaper/page/24098553 | 24098553 | |
| 46448 | 46448 | 1927-11-19 | 5 | a | Leon Trotsky and different voices in the 10th anniversary celebration of the October Revolution in Moscow. | Russia | http://trove.nla.gov.au/newspaper/page/24098601 | 24098601 | |
| 46728 | 46728 | 1928-02-11 | 5 | a | Rumours on the rebellions in the south of the Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24098689 | 24098689 | |
| 51419 | 51419 | 1932-04-16 | 5 | b | Soviet Russia to expand their troops. | Russia | http://trove.nla.gov.au/newspaper/page/24090769 | 24090769 | |
| 51731 | 51731 | 1932-07-23 | 5 | a | Official newspaper of the Soviet Union government comments on the military power of Japan and America. | Russia | http://trove.nla.gov.au/newspaper/page/24090881 | 24090881 | |
| 52396 | 52396 | 1933-01-14 | 5 | b | Scenery near the North Pole. | Russia | |||
| 53839 | 53839 | 1934-02-10 | 5 | d | Soviet Russia manufactures new type of train. | Russia | http://trove.nla.gov.au/newspaper/page/24091528 | 24091528 |
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]);