This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
426 | 426 | 1898-08-10 | 4 | a | Four women in Melbourne detained for illegal prostitution. | http://trove.nla.gov.au/newspaper/page/24102089 | 24102089 | ||
427 | 427 | 1898-08-10 | 4 | a-b | Man in Sydney broke promise to woman. | http://trove.nla.gov.au/newspaper/page/24102089 | 24102089 | ||
428 | 428 | 1898-08-10 | 4 | b | Sydney is preparing new regulations to cater for increasing traffic. | http://trove.nla.gov.au/newspaper/page/24102089 | 24102089 | ||
429 | 429 | 1898-08-10 | 4 | b-c | Crime, boy sentenced for stealing in Sydney. | http://trove.nla.gov.au/newspaper/page/24102089 | 24102089 | ||
430 | 430 | 1898-08-10 | 4 | c | Man dies in Sydney hotel. | http://trove.nla.gov.au/newspaper/page/24102089 | 24102089 | ||
431 | 431 | 1898-08-10 | 4 | c | Ship with cargo of gold sales for San Francisco from Sydney. | http://trove.nla.gov.au/newspaper/page/24102089 | 24102089 | ||
432 | 432 | 1898-08-10 | 4 | c | Ocean liner returns to Hong Kong with Chinese passengers and gold. | http://trove.nla.gov.au/newspaper/page/24102089 | 24102089 | ||
433 | 433 | 1898-08-10 | 4 | e | Timetable of liners' arrivals to and departures from Asian ports. | http://trove.nla.gov.au/newspaper/page/24102089 | 24102089 | ||
434 | 434 | 1898-08-10 | 4 | e | Price list of products in Sydney market. | http://trove.nla.gov.au/newspaper/page/24102089 | 24102089 | ||
435 | 435 | 1898-08-10 | 4 | e | Price list of products in Melbourne market. | http://trove.nla.gov.au/newspaper/page/24102089 | 24102089 |
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]);