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 |
---|---|---|---|---|---|---|---|---|---|
2253 | 2253 | 1899-04-19 | 2 | e | Cost of war; number of casualties; recent clashes between US troops and local forces. | http://trove.nla.gov.au/newspaper/page/24102368 | 24102368 | ||
2254 | 2254 | 1899-04-19 | 2 | e | German revenged in Shandong by using landmines; forced by Russia, China has changed its mind on the bidding of Hankou-Guangzhou railway; France and Belgium were given such a privilege due to their loans to China; Queen of Britain is back home after tour France. | http://trove.nla.gov.au/newspaper/page/24102368 | 24102368 | ||
2276 | 2276 | 1899-04-19 | 3 | e | Reports on the famine in Xuzhou. | http://trove.nla.gov.au/newspaper/page/24102367 | 24102367 | ||
2277 | 2277 | 1899-04-19 | 3 | e | A poem written by Chen Zi'e on the Qingming Festival. | http://trove.nla.gov.au/newspaper/page/24102367 | 24102367 | ||
2278 | 2278 | 1899-04-19 | 3 | e | Disease outbreak in Hong Kong claims lives. | http://trove.nla.gov.au/newspaper/page/24102367 | 24102367 | ||
2279 | 2279 | 1899-04-19 | 3 | e | The value of the Queen of England's crown. | http://trove.nla.gov.au/newspaper/page/24102367 | 24102367 |
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]);