This data as json, CSV (advanced)
Suggested facets: column, title, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 20123 | 20123 | 1908-10-17 | 6 | b-c | More Russian people are moving to live in Siberia. | Russia | http://trove.nla.gov.au/newspaper/page/26801919 | 26801919 | |
| 20218 | 20218 | 1908-11-07 | 6 | b | Epidemics in St Petersburg; report on the casualties. | Russia | http://trove.nla.gov.au/newspaper/page/26801944 | 26801944 | |
| 20404 | 20404 | 1908-12-19 | 6 | c | Bandits in St Petersburg publish their own newspaper. | Russia | http://trove.nla.gov.au/newspaper/page/26801992 | 26801992 | |
| 20715 | 20715 | 1909-02-27 | 6 | b | Russian authority expands its army significantly. | Russia | http://trove.nla.gov.au/newspaper/page/26802096 | 26802096 | |
| 20780 | 20780 | 1909-03-13 | 6 | c | Russian authority raises huge amounts of money for railway construction and army building. | Russia | http://trove.nla.gov.au/newspaper/page/26802112 | 26802112 | |
| 20847 | 20847 | 1909-03-27 | 6 | c | Russian parliament puts forward new proposal for administration in the Far East. | Russia | http://trove.nla.gov.au/newspaper/page/26802128 | 26802128 | |
| 21025 | 21025 | 1909-05-15 | 6 | c | Russian authority removes military department. | Russia | http://trove.nla.gov.au/newspaper/page/26802186 | 26802186 | |
| 21491 | 21491 | 1909-08-14 | 6 | c | Japan's conspiracy in Manchuria. | Russia | http://trove.nla.gov.au/newspaper/page/26802292 | 26802292 | |
| 24484 | 24484 | 1911-03-25 | 6 | b | The change of cabinet in Russia | Russia has a new cabinet due to the resign of the president. | Russia | http://trove.nla.gov.au/newspaper/page/24091715 | 24091715 |
| 24527 | 24527 | 1911-05-13 | 6 | b | War may happen between China and Japan | War may result from trade disagreements between China and Japan. | Russia | http://trove.nla.gov.au/newspaper/page/24091774 | 24091774 |
| 24902 | 24902 | 1911-08-26 | 6 | b | Persian government seeks relations with other nations | Persian government seeks relations with other nations such as Britain and Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24091895 | 24091895 |
| 25762 | 25762 | 1912-02-17 | 6 | b | Strict regulations on Americans | Russian parliament is to forbid American Jews entering and levy heavy tax on American businessmen. | Russia | http://trove.nla.gov.au/newspaper/page/24092111 | 24092111 |
| 25848 | 25848 | 1912-03-09 | 6 | c | Russian Suicide Association | A strange suicide association appears in Russia, which anyone who wants to commit suicide can join. | Russia | http://trove.nla.gov.au/newspaper/page/24092161 | 24092161 |
| 35046 | 35046 | 1919-11-08 | 6 | a | Military clashes in Russia and the casualties. | Russia | http://trove.nla.gov.au/newspaper/page/24097930 | 24097930 | |
| 37973 | 37973 | 1921-12-10 | 6 | a | Riots in Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24093787 | 24093787 | |
| 38105 | 38105 | 1922-01-07 | 6 | b | Leon Trotsky reports to the Soviet parliament in Moscow the reduction of Red Army troops. | Russia | http://trove.nla.gov.au/newspaper/page/24093819 | 24093819 | |
| 43372 | 43372 | 1925-06-20 | 6 | a | Labour union in Soviet Russia donates to Chinese demonstrators in Shanghai and the victim's family. | Russia | http://trove.nla.gov.au/newspaper/page/24101180 | 24101180 | |
| 44604 | 44604 | 1926-04-10 | 6 | b | Chinese in Russia and their loss due to the revolution. | Russia | http://trove.nla.gov.au/newspaper/page/24101522 | 24101522 | |
| 52670 | 52670 | 1933-03-18 | 6 | a | Soviet Russia remains neutral over the Manchurian issues. | Russia | http://trove.nla.gov.au/newspaper/page/24091160 | 24091160 | |
| 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 | |
| 54004 | 54004 | 1934-03-24 | 6 | d | Rebellion of Muslims in Xinjiang. | Russia | http://trove.nla.gov.au/newspaper/page/24091577 | 24091577 | |
| 54051 | 54051 | 1934-04-07 | 6 | e | Japan regards China as its protectorate. | Russia | http://trove.nla.gov.au/newspaper/page/24095968 | 24095968 | |
| 54083 | 54083 | 1934-04-21 | 6 | a | Russian plane saves sailors. | Russia | http://trove.nla.gov.au/newspaper/page/24095990 | 24095990 | |
| 54124 | 54124 | 1934-05-05 | 6 | c | Soviet Russia comments on Japan's warnings to China. | Russia | http://trove.nla.gov.au/newspaper/page/24096006 | 24096006 | |
| 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 | |
| 54673 | 54673 | 1934-11-17 | 6 | a | Celebrations in Soviet Russia on the National Day. | Russia | http://trove.nla.gov.au/newspaper/page/24096236 | 24096236 | |
| 54771 | 54771 | 1935-01-05 | 6 | a | Soviet Russian authority punishes dissidents. | Russia | http://trove.nla.gov.au/newspaper/page/24096283 | 24096283 | |
| 54863 | 54863 | 1935-02-09 | 6 | a | The Seventh Congress of the Soviet Communist Party in Moscow. | Russia | http://trove.nla.gov.au/newspaper/page/24096323 | 24096323 | |
| 54891 | 54891 | 1935-02-16 | 6 | b | Soviet Russia changes its parliament system. | Russia | http://trove.nla.gov.au/newspaper/page/24096331 | 24096331 | |
| 54985 | 54985 | 1935-03-30 | 6 | b | Soviet Russian authority arrests monarchists. | Russia | http://trove.nla.gov.au/newspaper/page/24096379 | 24096379 |
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]);