This data as json, CSV (advanced)
Suggested facets: page, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 6894 | 6894 | 1901-01-19 | 3 | d | South Russia experienced heavy snowfalls. | Russia | http://trove.nla.gov.au/newspaper/page/24099921 | 24099921 | |
| 6932 | 6932 | 1901-01-26 | 2 | d | Members of a secret Russian society tried to assassinate the Tzar of Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24099930 | 24099930 | |
| 7093 | 7093 | 1901-02-13 | 3 | d | Oilfield fire in Baku, Russia, has claimed hundreds of lives. | Russia | http://trove.nla.gov.au/newspaper/page/24099949 | 24099949 | |
| 7858 | 7858 | 1901-06-05 | 2 | d | Russia has given up on efforts to make China sign the treaty on Manchuria. | Russia | http://trove.nla.gov.au/newspaper/page/24100063 | 24100063 | |
| 8323 | 8323 | 1901-08-03 | 3 | d | Russian authority has arrested many dissidents or rebels. | Russia | http://trove.nla.gov.au/newspaper/page/24100129 | 24100129 | |
| 8727 | 8727 | 1901-10-02 | 3 | d | Japan is preparing for Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24100180 | 24100180 | |
| 9342 | 9342 | 1901-12-14 | 3 | d | Russia tries to kill rats in order to prevent the plague. | Russia | http://trove.nla.gov.au/newspaper/page/24100264 | 24100264 | |
| 9373 | 9373 | 1901-12-18 | 3 | d | Building of Siberia railway has been completed. | Russia | http://trove.nla.gov.au/newspaper/page/24100268 | 24100268 | |
| 9640 | 9640 | 1902-01-22 | 2 | d | Russian newspaper claims that the Boxer rebellion was not incited by Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24100307 | 24100307 | |
| 10036 | 10036 | 1902-03-15 | 3 | d | A train accident in Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24100354 | 24100354 | |
| 10402 | 10402 | 1902-04-23 | 3 | d | A Russian minister was assassinated recently. | Russia | http://trove.nla.gov.au/newspaper/page/24100399 | 24100399 | |
| 13634 | 13634 | 1904-08-06 | 2 | d | Russian minister for internal affairs has been assassinated. | Russia | http://trove.nla.gov.au/newspaper/page/26800495 | 26800495 | |
| 19959 | 19959 | 1908-09-12 | 3 | d | Russian educational authority to ban woman students in the university. | Russia | http://trove.nla.gov.au/newspaper/page/26801874 | 26801874 | |
| 29671 | 29671 | 1915-02-06 | 3 | d | Situation of Jia Li Sa (ppp) war. | Russia | http://trove.nla.gov.au/newspaper/page/24094711 | 24094711 | |
| 29672 | 29672 | 1915-02-06 | 3 | d | More Turkish troops are sent to rescue their encircled troop in Russian border. | Russia | http://trove.nla.gov.au/newspaper/page/24094711 | 24094711 | |
| 29822 | 29822 | 1915-03-27 | 3 | d | Battle situation in eastern Peruse between Russian troops and German troops. | Russia | http://trove.nla.gov.au/newspaper/page/24094784 | 24094784 | |
| 29861 | 29861 | 1915-04-03 | 3 | d | German warships are found in Mediterran sea. | Russia | http://trove.nla.gov.au/newspaper/page/24094792 | 24094792 | |
| 29862 | 29862 | 1915-04-03 | 3 | d | Battle situation in Gocaso between Russian and Turkish troops. | Russia | http://trove.nla.gov.au/newspaper/page/24094792 | 24094792 | |
| 29934 | 29934 | 1915-04-17 | 3 | d | Russian troops win a number of battles in Portland. | Russia | http://trove.nla.gov.au/newspaper/page/24094808 | 24094808 | |
| 30098 | 30098 | 1915-05-29 | 3 | d | Russian navy is ashore on Turkish coast. | Russia | http://trove.nla.gov.au/newspaper/page/24094856 | 24094856 | |
| 30099 | 30099 | 1915-05-29 | 3 | d | Battle situation between Russian and Turkish troops. | Russia | http://trove.nla.gov.au/newspaper/page/24094856 | 24094856 | |
| 30559 | 30559 | 1915-10-09 | 3 | d | Battle situation in east Europe between Russian, German and Austrian troops (continued). | Russia | http://trove.nla.gov.au/newspaper/page/24095010 | 24095010 | |
| 30608 | 30608 | 1915-10-23 | 3 | d | Battle situation in east Europe between Russian and German troops. | Russia | http://trove.nla.gov.au/newspaper/page/24095026 | 24095026 | |
| 30609 | 30609 | 1915-10-23 | 3 | d | British submarines sank five German ships and three French ships are sunken by German submarines. | Russia | http://trove.nla.gov.au/newspaper/page/24095026 | 24095026 | |
| 30724 | 30724 | 1915-11-20 | 3 | d | Battle situation in east Europe between Russian and German-Austrian troops. | Russia | http://trove.nla.gov.au/newspaper/page/24095058 | 24095058 | |
| 30809 | 30809 | 1915-12-11 | 3 | d | Battle situation between Russia and Turkey. | Russia | http://trove.nla.gov.au/newspaper/page/24095083 | 24095083 | |
| 41402 | 41402 | 1924-04-12 | 3 | d | The end of imperial Russian families. | Russia | http://trove.nla.gov.au/newspaper/page/24100679 | 24100679 | |
| 46099 | 46099 | 1927-08-27 | 3 | d | The Far East Bank is closed down in Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24098503 | 24098503 | |
| 48368 | 48368 | 1929-08-10 | 8 | d | A Soviet Russian newspaper claims that China is deceived by others. | Russia | |||
| 48872 | 48872 | 1930-02-08 | 8 | d | Soviet Russian government bans the sale of meat. | Russia | http://trove.nla.gov.au/newspaper/page/24099525 | 24099525 | |
| 48934 | 48934 | 1930-03-01 | 8 | d | Russian newspaper explains why to ban slaughtering animals. | Russia | http://trove.nla.gov.au/newspaper/page/24099553 | 24099553 | |
| 50747 | 50747 | 1931-09-26 | 8 | d | Russia dispatches troops to Manchuria. | Russia | http://trove.nla.gov.au/newspaper/page/24090541 | 24090541 | |
| 52275 | 52275 | 1932-12-03 | 3 | d | The war between Japan and America is unavoidable. | Russia | http://trove.nla.gov.au/newspaper/page/24091039 | 24091039 | |
| 52847 | 52847 | 1933-05-06 | 6 | d | May Day parade in Moscow. | Russia | http://trove.nla.gov.au/newspaper/page/24091216 | 24091216 | |
| 52872 | 52872 | 1933-05-13 | 6 | d | Atheist university set up in Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24091224 | 24091224 | |
| 53029 | 53029 | 1933-07-01 | 3 | d | The Jewish problems in Soviet Russia after the October Revolution. | Russia | http://trove.nla.gov.au/newspaper/page/24091277 | 24091277 | |
| 53030 | 53030 | 1933-07-01 | 3 | d | Anti-Chinese movement in Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24091277 | 24091277 | |
| 53839 | 53839 | 1934-02-10 | 5 | d | Soviet Russia manufactures new type of train. | Russia | http://trove.nla.gov.au/newspaper/page/24091528 | 24091528 | |
| 53937 | 53937 | 1934-03-10 | 3 | d | Stalin delivers a speech and his comments on the Chinese issues. | Russia | http://trove.nla.gov.au/newspaper/page/24091556 | 24091556 | |
| 53965 | 53965 | 1934-03-17 | 3 | d | Russian government increases salary payment to the Red Army in the Far East. | Russia | http://trove.nla.gov.au/newspaper/page/24091564 | 24091564 | |
| 54004 | 54004 | 1934-03-24 | 6 | d | Rebellion of Muslims in Xinjiang. | Russia | http://trove.nla.gov.au/newspaper/page/24091577 | 24091577 | |
| 54146 | 54146 | 1934-05-12 | 6 | d | The air forces of Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24096014 | 24096014 | |
| 54587 | 54587 | 1934-10-06 | 6 | d | A Russian man is sentenced for bigamy. | Russia | http://trove.nla.gov.au/newspaper/page/24096186 | 24096186 | |
| 55282 | 55282 | 1935-07-20 | 8 | d | Soviet Russia to rebuild Moscow. | Russia | http://trove.nla.gov.au/newspaper/page/24096510 | 24096510 | |
| 56185 | 56185 | 1936-08-22 | 3 | d | The naval force of Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24096961 | 24096961 | |
| 56281 | 56281 | 1936-09-19 | 8 | d | Exercise of the Red Army in Soviet Union. | Russia | http://trove.nla.gov.au/newspaper/page/24097002 | 24097002 | |
| 56308 | 56308 | 1936-10-03 | 3 | d | Japanese execute Soviet Russian soldiers. | Russia | http://trove.nla.gov.au/newspaper/page/24097011 | 24097011 | |
| 56427 | 56427 | 1936-11-14 | 8 | d | Celebration of October Revolution in Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24097065 | 24097065 |
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]);