This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
6472 | 6472 | 1900-11-21 | 2 | e | Russian orders other foreign troops to leave the railway from Tanggu to Beijing; China will agree to most requirements imposed by foreign governments; USA wants to punish troublemakers and demands compensation from Chinese government; a group of Russian soldiers were besieged by Chinese troops in the north of Shanhaiguan; Russia source says German and French soldiers are robbers. | Other... | http://trove.nla.gov.au/newspaper/page/24103021 | 24103021 | |
6476 | 6476 | 1900-11-21 | 2 | f | China's negotiators contact foreign missions in Beijing for possible solution of the chaos; Empress Dowager authorises Hart to contact foreign governments for the number of compensation; Japanese troops withdrew from Beijing and Tianjin and their whereabouts are unknown; a group of German soldiers going the tombs of Ming dynasty. | Other... | http://trove.nla.gov.au/newspaper/page/24103021 | 24103021 | |
6486 | 6486 | 1900-11-21 | 3 | b | Chinese ambassador to France talks about China's peace negotiation with foreign governments; Russia sends provisions to their troops in Manchuria; Russian demands Chinese government to appoint an official for Manchuria; a British missionary eyes were burned; Duan wang and Dong Fuxiang started revolt in Gansu province. | Other... | http://trove.nla.gov.au/newspaper/page/24103020 | 24103020 |
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]);