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 |
---|---|---|---|---|---|---|---|---|---|
24151 | 24151 | 1911-01-14 | 3 | a | Special cable news | A suggestion that to totally prevent imported opium, the government should have another meeting with India; an international anti-opium conference will be held in Hague, Holand; fire in New York's Chinatown. | Other... | http://trove.nla.gov.au/newspaper/page/24091596 | 24091596 |
24157 | 24157 | 1911-01-14 | 3 | a | Political situation in Persia | The Cabinet members resigned as a result of rebellions in the South and proposal of a federation system. | Other... | http://trove.nla.gov.au/newspaper/page/24091596 | 24091596 |
24159 | 24159 | 1911-01-14 | 3 | b | Serious earthquakes in Istanbol, Turkey | Damages resulted from serious earthquakes. | Other... | http://trove.nla.gov.au/newspaper/page/24091596 | 24091596 |
24173 | 24173 | 1911-01-14 | 7 | b-c | A notice to urge for donation to relief floods in Jiangsu and Anhui | A letter from New Zealand's Chinese diplomat, Huang Rongliang, to urge for donation to relief the damages caused by the floods in Jiangsu and Anhui, as well as thank you people's donation (including those from Westerners). | Other... | http://trove.nla.gov.au/newspaper/page/24091600 | 24091600 |
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]);