This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
355 | 355 | 1898-08-03 | 4 | a | Germany has more infantrymen than other countries. Residents cannot leave their region without prior permission. | http://trove.nla.gov.au/newspaper/page/24102081 | 24102081 | ||
356 | 356 | 1898-08-03 | 4 | a-b | Beautiful woman from Perth dies in sea while trying to cross strait with three men. | http://trove.nla.gov.au/newspaper/page/24102081 | 24102081 | ||
357 | 357 | 1898-08-03 | 4 | b | New Zealand will collect bicycle levy to fund repair of roads. | http://trove.nla.gov.au/newspaper/page/24102081 | 24102081 | ||
358 | 358 | 1898-08-03 | 4 | b | White man arrested for selling liquor to Aboriginal man. | http://trove.nla.gov.au/newspaper/page/24102081 | 24102081 | ||
359 | 359 | 1898-08-03 | 4 | b | Price of rice is increasing due to serious draught. | http://trove.nla.gov.au/newspaper/page/24102081 | 24102081 | ||
360 | 360 | 1898-08-03 | 4 | c | Some pork and beef products in NSW are infected with virus. | http://trove.nla.gov.au/newspaper/page/24102081 | 24102081 | ||
361 | 361 | 1898-08-03 | 4 | c | About 28 white men are under arrest for gambling in Melbourne. | http://trove.nla.gov.au/newspaper/page/24102081 | 24102081 | ||
362 | 362 | 1898-08-03 | 4 | c | Young bicyclist in Sydney detained after knocking down old woman on street. | http://trove.nla.gov.au/newspaper/page/24102081 | 24102081 | ||
363 | 363 | 1898-08-03 | 4 | d | Price list of products in Sydney market. | http://trove.nla.gov.au/newspaper/page/24102081 | 24102081 | ||
364 | 364 | 1898-08-03 | 4 | d | Price list of vegetables, fruits and groceries on Melbourne market. | http://trove.nla.gov.au/newspaper/page/24102081 | 24102081 |
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]);