This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
17978 | 17978 | 1907-08-24 | 2 | c | Important news. Chinese government bans its soldiers from opium smoking. | Britain | http://trove.nla.gov.au/newspaper/page/26801444 | 26801444 | |
17985 | 17985 | 1907-08-24 | 3 | c | British foreign secretary confirms that they would not reduce China's payment of Boxer Indemnity. Total amount of the indemnity China has to pay Russia, Germany, France, Britain, America, Japan, Italy, Belgium, and Austria. | Britain | http://trove.nla.gov.au/newspaper/page/26801443 | 26801443 | |
17987 | 17987 | 1907-08-24 | 3 | d | Some German people suggest their government will return to Jiaozhou in Shandong province to China. Comments by Tung Wah Times. | Britain | http://trove.nla.gov.au/newspaper/page/26801443 | 26801443 | |
18009 | 18009 | 1907-08-24 | 7 | c | Explosion of a coal mine in Shandong province claims 112 lives, 2 German and 110 Chinese. | Britain | http://trove.nla.gov.au/newspaper/page/26801447 | 26801447 |
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]);