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 |
|---|---|---|---|---|---|---|---|---|---|
| 5471 | 5471 | 1900-06-13 | 2 | f | Russia employs more Chinese labourers to build the railway to China. | Russia | http://trove.nla.gov.au/newspaper/page/24102838 | 24102838 | |
| 31050 | 31050 | 1916-03-18 | 3 | f | Battle situation in east Europe between Russian and German troops. | Russia | http://trove.nla.gov.au/newspaper/page/24095194 | 24095194 | |
| 34753 | 34753 | 1919-08-02 | 3 | f | Bandits in Russia and the robbery. | Russia | http://trove.nla.gov.au/newspaper/page/24097809 | 24097809 | |
| 39866 | 39866 | 1923-05-19 | 3 | f | Polish government to borrow loans from France for weapon industry and the response from Russian authority. | Russia | http://trove.nla.gov.au/newspaper/page/24094407 | 24094407 | |
| 41290 | 41290 | 1924-03-22 | 2 | f | Political situation in Moscow after the death of Lenin. | Russia | http://trove.nla.gov.au/newspaper/page/24100656 | 24100656 | |
| 45560 | 45560 | 1927-03-19 | 3 | f | Russian and Chinese communist party and the Comintern. | Russia | http://trove.nla.gov.au/newspaper/page/24101915 | 24101915 | |
| 45562 | 45562 | 1927-03-19 | 3 | f | German scientists and their research in the Barents Sea. | Russia | http://trove.nla.gov.au/newspaper/page/24101915 | 24101915 | |
| 45747 | 45747 | 1927-05-28 | 2 | f | Military education in Soviet Russia. | Russia | http://trove.nla.gov.au/newspaper/page/24102000 | 24102000 | |
| 46177 | 46177 | 1927-09-17 | 2 | f | Arrests of Chinese in Vladivostok. | Russia | http://trove.nla.gov.au/newspaper/page/24098528 | 24098528 | |
| 46385 | 46385 | 1927-11-05 | 2 | f | Soviet Russia moves its diplomatic attention to Europe. | Russia | http://trove.nla.gov.au/newspaper/page/24098584 | 24098584 | |
| 48516 | 48516 | 1929-10-05 | 2 | f | Soviet Russia has different opinions on the China policy. | Russia | http://trove.nla.gov.au/newspaper/page/24099381 | 24099381 | |
| 48552 | 48552 | 1929-10-19 | 2 | f | Some Russian people are anti-Communist and support the friendship with China. | Russia | http://trove.nla.gov.au/newspaper/page/24099397 | 24099397 | |
| 51068 | 51068 | 1932-01-16 | 2 | f | Comments by the Soviet Russia on the Manchurian incident. | Russia | http://trove.nla.gov.au/newspaper/page/24090662 | 24090662 | |
| 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 | |
| 52457 | 52457 | 1933-01-28 | 2 | f | Russian people welcome Chinese national hero of fighting Japanese. | Russia | http://trove.nla.gov.au/newspaper/page/24091098 | 24091098 | |
| 52602 | 52602 | 1933-03-04 | 2 | f | Stalin on the relationship with Japanese. | Russia | http://trove.nla.gov.au/newspaper/page/24091138 | 24091138 |
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]);