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 |
---|---|---|---|---|---|---|---|---|---|
254 | 254 | 1898-07-23 | 3 | b | Sailor on ship from New York to Adelaide dies during the voyage. | http://trove.nla.gov.au/newspaper/page/24102072 | 24102072 | ||
255 | 255 | 1898-07-23 | 3 | b | Russia builds more gunboats to arm its navy. | http://trove.nla.gov.au/newspaper/page/24102072 | 24102072 | ||
269 | 269 | 1898-07-23 | 2 | b | Frenchmen in Shanghai force Chinese residents to move temples and graves in French Settlement. Clash causes injuries. | http://trove.nla.gov.au/newspaper/page/24102071 | 24102071 | ||
281 | 281 | 1898-07-23 | 4 | b | Rebellion movement Black Flag causes more social chaos in Guangxi. Numbers of rebels increasing. | http://trove.nla.gov.au/newspaper/page/24102069 | 24102069 | ||
282 | 282 | 1898-07-23 | 4 | b | Man committs suicide by jumping in front of traint in Parrammata, Sydney. | http://trove.nla.gov.au/newspaper/page/24102069 | 24102069 | ||
283 | 283 | 1898-07-23 | 4 | b | Shop owner in New Castle fined for selling wine outside legal hours for liquor sales. | http://trove.nla.gov.au/newspaper/page/24102069 | 24102069 | ||
302 | 302 | 1898-07-23 | 2 | b | Tornado in Guangdong destroys large amount of grain. | http://trove.nla.gov.au/newspaper/page/24102071 | 24102071 | ||
303 | 303 | 1898-07-23 | 2 | b | Rich man in western Chaoyang cuts off his hair and becomes monk. | http://trove.nla.gov.au/newspaper/page/24102071 | 24102071 |
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]);