This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
6074 | 6074 | 1900-09-15 | 2 | d | French foreign minister talks with US government on withdrawal of troops from China; German comments on Russia's suggestion to withdraw troops from China; communications between Russian and German governments on troops in China. | China | http://trove.nla.gov.au/newspaper/page/24102948 | 24102948 | |
6075 | 6075 | 1900-09-15 | 2 | d | Riots on Guangzhou streets; Liu Yuanting and his army are passing through Hunan and Hubei provinces on their way north; Xiamen is now in peace. | Other... | http://trove.nla.gov.au/newspaper/page/24102948 | 24102948 | |
6076 | 6076 | 1900-09-15 | 2 | d | Governor Xu of Fujian province signed memoranda with foreign missions there which includes, 1) foreigners and their property are to be protected by local government; and 2) no foreign troops in Fuzhou, capital of the province. | China | http://trove.nla.gov.au/newspaper/page/24102948 | 24102948 | |
6077 | 6077 | 1900-09-15 | 2 | d | Comments from the Western government on Li Hongzhang's performance. | China | http://trove.nla.gov.au/newspaper/page/24102948 | 24102948 |
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]);