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]);