This data as json, CSV (advanced)
date (date) 3 ✖
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
8207 | 8207 | 1901-07-20 | 3 | C | The war between Britain and Transvaal, in South Africa. | Other... | http://trove.nla.gov.au/newspaper/page/24100113 | 24100113 | |
24719 | 24719 | 1911-07-15 | 8 | C | China sends its battleship to Mexico | China sends its battleship to Mexico for the indemnity from Mexico. | Other... | http://trove.nla.gov.au/newspaper/page/24091849 | 24091849 |
26738 | 26738 | 1912-09-14 | 3 | C | Beijing news/ Vice president Li lists six major problems in foreign relations. President Yuan intends to issue national treasury bonds. Premier Lu urges governors to continue donations to saving Chinese nation. Mongolia living Buddha disappointed with bombs bought for threatening those not supporting independence. Britain supports Japanese-Russian treaty. Chinese government surprises at foreign media report about chaos in Beijing. Chinese special envoy goest to Mongolia to settle down potential conflict between Chinese and Mongolians. Conflict between pigtail cut association and pigtail protection association. Shanghai Huangpujiang found a big snake. | Other... | http://trove.nla.gov.au/newspaper/page/24092375 | 24092375 |
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]);