This data as json, CSV (advanced)
Suggested facets: column, title, date (date)
| Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
|---|---|---|---|---|---|---|---|---|---|
| 22675 | 22675 | 1910-04-16 | 8 | b | Chinese business association in Nanyang. | Russia | http://trove.nla.gov.au/newspaper/page/26802597 | 26802597 | |
| 25177 | 25177 | 1911-10-21 | 8 | b | Travel notes of Siberia | Railways development, races, resources and customs of Siberia. | Russia | http://trove.nla.gov.au/newspaper/page/24091973 | 24091973 |
| 47974 | 47974 | 1929-04-06 | 8 | a | Soviet Russia seeks to control Afghanistan. | Russia | http://trove.nla.gov.au/newspaper/page/24099176 | 24099176 | |
| 48368 | 48368 | 1929-08-10 | 8 | d | A Soviet Russian newspaper claims that China is deceived by others. | Russia | |||
| 48566 | 48566 | 1929-10-19 | 8 | c | No freedom for religious belief in Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24099403 | 24099403 | |
| 48611 | 48611 | 1929-11-02 | 8 | c | Soviet Russian authority arrests monarchists. | Russia | http://trove.nla.gov.au/newspaper/page/24099419 | 24099419 | |
| 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 | |
| 49464 | 49464 | 1930-08-30 | 8 | c | Soviet Russian government robs wheat from farmers. | Russia | http://trove.nla.gov.au/newspaper/page/24099763 | 24099763 | |
| 49701 | 49701 | 1930-11-15 | 8 | b | Russian government executes farmers. | Russia | http://trove.nla.gov.au/newspaper/page/24099851 | 24099851 | |
| 50210 | 50210 | 1931-04-18 | 8 | b | Russian authority banishes farmers. | Russia | http://trove.nla.gov.au/newspaper/page/24090355 | 24090355 | |
| 50246 | 50246 | 1931-04-25 | 8 | c | Trade relationship between Russia and Canada. | Russia | http://trove.nla.gov.au/newspaper/page/24090363 | 24090363 | |
| 50529 | 50529 | 1931-07-18 | 8 | c | French plane has accident in Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24090459 | 24090459 | |
| 50577 | 50577 | 1931-08-01 | 8 | b | Soviet Union to build a radio station. | Russia | http://trove.nla.gov.au/newspaper/page/24090475 | 24090475 | |
| 50747 | 50747 | 1931-09-26 | 8 | d | Russia dispatches troops to Manchuria. | Russia | http://trove.nla.gov.au/newspaper/page/24090541 | 24090541 | |
| 51692 | 51692 | 1932-07-09 | 8 | a | Shi Zhaoji, envoy of the Chinese government, arrives in Moscow for talks to resume diplomatic relations. | Russia | http://trove.nla.gov.au/newspaper/page/24090870 | 24090870 | |
| 52168 | 52168 | 1932-11-05 | 8 | f | General Su Bingwen in Manchuria releases Japanese POWs. | Russia | http://trove.nla.gov.au/newspaper/page/24091014 | 24091014 | |
| 55111 | 55111 | 1935-05-11 | 8 | c | Army parade in Moscow. | Russia | http://trove.nla.gov.au/newspaper/page/24096431 | 24096431 | |
| 55148 | 55148 | 1935-05-25 | 8 | c | Airforce troops of the Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24096447 | 24096447 | |
| 55261 | 55261 | 1935-07-13 | 8 | c | Aviation industry in Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24096502 | 24096502 | |
| 55282 | 55282 | 1935-07-20 | 8 | d | Soviet Russia to rebuild Moscow. | Russia | http://trove.nla.gov.au/newspaper/page/24096510 | 24096510 | |
| 55338 | 55338 | 1935-08-10 | 8 | b | Russian submarine sinks during an exercise. | Russia | http://trove.nla.gov.au/newspaper/page/24096535 | 24096535 | |
| 55543 | 55543 | 1935-10-26 | 8 | a | Border clash between Russia and Japan. | Russia | http://trove.nla.gov.au/newspaper/page/24096626 | 24096626 | |
| 55806 | 55806 | 1936-02-15 | 8 | c | Soviet Russia reforms its parliament system. | Russia | http://trove.nla.gov.au/newspaper/page/24096750 | 24096750 | |
| 55866 | 55866 | 1936-03-07 | 8 | e | French parliament approves the treaty with Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24096774 | 24096774 | |
| 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 | |
| 56427 | 56427 | 1936-11-14 | 8 | d | Celebration of October Revolution in Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24097065 | 24097065 | |
| 56502 | 56502 | 1936-12-19 | 8 | a | Soviet Russia strengthen its national defence. | Russia | http://trove.nla.gov.au/newspaper/page/24097109 | 24097109 | |
| 56525 | 56525 | 1936-12-26 | 8 | c | Soviet Russian claim that Japanese instigate chaos in Shaanxi province. | Russia | http://trove.nla.gov.au/newspaper/page/24097120 | 24097120 |
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]);