This data as json, CSV (advanced)
Suggested facets: date, column, title, description, page_url, trove_id, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 25661 | 25661 | 1912-01-27 | 7 | b | Riot in the China's west border | Some revolutionary troops occupied several places in Xingjiang and neighbouring areas. | Russia | http://trove.nla.gov.au/newspaper/page/24092086 | 24092086 |
| 25662 | 25662 | 1912-01-27 | 7 | b | Russia and Mongolia | Russia refuses China to enter Mongolia since Mongolia declared independence. | Russia | http://trove.nla.gov.au/newspaper/page/24092086 | 24092086 |
| 26443 | 26443 | 1912-07-20 | 7 | c | Chinese soldiers in Xinjiang burn more than 100 Russians. | Russia | http://trove.nla.gov.au/newspaper/page/24092315 | 24092315 | |
| 26895 | 26895 | 1913-01-18 | 7 | c | Russia presses China to pay its Boxer Indemnity. Strict disciplines for Russian navy students. | Russia | http://trove.nla.gov.au/newspaper/page/24092548 | 24092548 | |
| 27935 | 27935 | 1913-09-27 | 7 | c | Fire in Ningguta, Manchuria. | Russia | http://trove.nla.gov.au/newspaper/page/24092836 | 24092836 | |
| 29559 | 29559 | 1915-01-09 | 7 | c | European War/ Russian troops have defeated Turkish troops in a battle, capturing many weapons. | Russia | http://trove.nla.gov.au/newspaper/page/24094683 | 24094683 | |
| 29590 | 29590 | 1915-01-16 | 7 | b | Russian troops win a number of battles in Portland. | Russia | http://trove.nla.gov.au/newspaper/page/24094691 | 24094691 | |
| 29678 | 29678 | 1915-02-06 | 7 | b | Turkish troops invades southern Parse. | Russia | http://trove.nla.gov.au/newspaper/page/24094715 | 24094715 | |
| 29679 | 29679 | 1915-02-06 | 7 | c | People in Portland suffer a shortage of food. | Russia | http://trove.nla.gov.au/newspaper/page/24094715 | 24094715 | |
| 29680 | 29680 | 1915-02-06 | 7 | c | Russian troops won repeated battles in East Europe. | Russia | http://trove.nla.gov.au/newspaper/page/24094715 | 24094715 | |
| 29731 | 29731 | 1915-03-06 | 7 | b | Russian troops are fighting with German and Austrian troops in East Europe, winning a few battles. | Russia | http://trove.nla.gov.au/newspaper/page/24094764 | 24094764 | |
| 29799 | 29799 | 1915-03-20 | 7 | b | Battle situation in East Europe between Russian and German troops. | Russia | http://trove.nla.gov.au/newspaper/page/24094780 | 24094780 | |
| 29836 | 29836 | 1915-03-27 | 7 | c | Russian troops has occupied Pi Chang Mei Lu (ppp) city of Austria. | Russia | http://trove.nla.gov.au/newspaper/page/24094788 | 24094788 | |
| 29871 | 29871 | 1915-04-03 | 7 | b | German troops attack Russian troops in Russia-owned Portland area. | Russia | http://trove.nla.gov.au/newspaper/page/24094796 | 24094796 | |
| 29999 | 29999 | 1915-05-01 | 7 | a-c | Battle situation in east Europe between Russian and Austrian troops. | Russia | http://trove.nla.gov.au/newspaper/page/24094828 | 24094828 | |
| 30218 | 30218 | 1915-06-26 | 7 | b | Battle situation in East Europe between Russian andTurkish troops. | Russia | http://trove.nla.gov.au/newspaper/page/24094892 | 24094892 | |
| 30219 | 30219 | 1915-06-26 | 7 | b-c | Russia is worrying about Swaziland joining the war. | Russia | http://trove.nla.gov.au/newspaper/page/24094892 | 24094892 | |
| 30243 | 30243 | 1915-07-03 | 7 | b-c | Battle situation in east Europe between Russian and German troops. | Russia | http://trove.nla.gov.au/newspaper/page/24094900 | 24094900 | |
| 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 | |
| 30892 | 30892 | 1916-01-15 | 7 | b | Battle situation in east Europe between Russian and German troops. | Russia | http://trove.nla.gov.au/newspaper/page/24095113 | 24095113 | |
| 34406 | 34406 | 1919-04-19 | 7 | b | Famine in Moscow. | Russia | http://trove.nla.gov.au/newspaper/page/24097689 | 24097689 | |
| 45524 | 45524 | 1927-03-05 | 7 | c | Soviet Russian authority collect heavy tax on imported leather. | Russia | http://trove.nla.gov.au/newspaper/page/24101903 | 24101903 | |
| 46378 | 46378 | 1927-10-29 | 7 | c | Leon Trotsky is removed from the Bolshevik Party. | Russia | http://trove.nla.gov.au/newspaper/page/24098579 | 24098579 | |
| 46761 | 46761 | 1928-02-18 | 7 | a | Divorce is very popular in Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24098699 | 24098699 | |
| 46800 | 46800 | 1928-03-03 | 7 | a | Value of gold in the Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24098715 | 24098715 | |
| 46945 | 46945 | 1928-04-14 | 7 | a | Farmers are detained in Soviet Russia for illegal storage of grains. | Russia | http://trove.nla.gov.au/newspaper/page/24098763 | 24098763 | |
| 55722 | 55722 | 1936-01-11 | 7 | a | Russia is afraid of Japanese invasion of Mongolia. | Russia | http://trove.nla.gov.au/newspaper/page/24096707 | 24096707 |
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]);