This data as json, CSV (advanced)
Suggested facets: date, page, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
5410 | 5410 | 1900-06-06 | 2 | e | Russian newspaper says they will use their military base of Lushun and Dalian in China to take over Korea and the whole of east Asia. | Russia | http://trove.nla.gov.au/newspaper/page/24102829 | 24102829 | |
7939 | 7939 | 1901-06-15 | 2 | e | Recent development in the political situation in Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24100077 | 24100077 | |
31025 | 31025 | 1916-03-11 | 3 | e | Battle situation in Gao Jia Suo (ppp) between Russian and Turkish troops. | Russia | http://trove.nla.gov.au/newspaper/page/24095186 | 24095186 | |
45709 | 45709 | 1927-05-14 | 2 | e | Soviet Russian authority bans Chinese community to set up Chinese school. | Russia | http://trove.nla.gov.au/newspaper/page/24101984 | 24101984 | |
45710 | 45710 | 1927-05-14 | 2 | e | The devaluation of Russian currency. | Russia | http://trove.nla.gov.au/newspaper/page/24101984 | 24101984 | |
45772 | 45772 | 1927-06-04 | 3 | e | Number and name of Russian people arrested in China. | Russia | http://trove.nla.gov.au/newspaper/page/24102008 | 24102008 | |
45788 | 45788 | 1927-06-11 | 2 | e | Prostitution in the Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24102018 | 24102018 | |
46478 | 46478 | 1927-11-26 | 3 | e | Rebellions in the Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24098607 | 24098607 | |
54038 | 54038 | 1934-04-07 | 3 | e | Soviet Russia criticises the puppet Manchurian state. | Russia | http://trove.nla.gov.au/newspaper/page/24095963 | 24095963 | |
54051 | 54051 | 1934-04-07 | 6 | e | Japan regards China as its protectorate. | Russia | http://trove.nla.gov.au/newspaper/page/24095968 | 24095968 | |
54340 | 54340 | 1934-07-21 | 3 | e | Economic development in Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24096091 | 24096091 | |
54616 | 54616 | 1934-10-20 | 3 | e | Stalin is seriously ill. | Russia | http://trove.nla.gov.au/newspaper/page/24096197 | 24096197 | |
55866 | 55866 | 1936-03-07 | 8 | e | French parliament approves the treaty with Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24096774 | 24096774 | |
56215 | 56215 | 1936-08-29 | 3 | e | Soviet Russian authority releases four Japanese soldiers. | Russia | http://trove.nla.gov.au/newspaper/page/24096969 | 24096969 |
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]);