This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
667 | 667 | 1898-08-31 | 2 | c | Report on wheat harvest in NSW, Victoria and South Australia. | http://trove.nla.gov.au/newspaper/page/24102115 | 24102115 | ||
668 | 668 | 1898-08-31 | 2 | c | Sorcerer in Guangzhou claims he arrived from another world. | http://trove.nla.gov.au/newspaper/page/24102115 | 24102115 | ||
669 | 669 | 1898-08-31 | 2 | c-d | Song calls for practice of foot-binding to stop amongst women. | http://trove.nla.gov.au/newspaper/page/24102115 | 24102115 | ||
670 | 670 | 1898-08-31 | 2 | d | Two White men penalised for smuggling cigarettes. | http://trove.nla.gov.au/newspaper/page/24102115 | 24102115 | ||
671 | 671 | 1898-08-31 | 2 | d | People arrested while protesting against unemployment levels outside Royal palace in London | http://trove.nla.gov.au/newspaper/page/24102115 | 24102115 | ||
672 | 672 | 1898-08-31 | 2 | d-e | Man drowns in Wuzhou, Guangxi. | http://trove.nla.gov.au/newspaper/page/24102115 | 24102115 | ||
673 | 673 | 1898-08-31 | 2 | e | Statistics on number of people involved in agricultural production in New Zealand. | http://trove.nla.gov.au/newspaper/page/24102115 | 24102115 | ||
674 | 674 | 1898-08-31 | 2 | e-f | Current situation in Lushun, northeastern China. | http://trove.nla.gov.au/newspaper/page/24102115 | 24102115 | ||
675 | 675 | 1898-08-31 | 2 | f | Rich man in London murdered, money stolen. | http://trove.nla.gov.au/newspaper/page/24102115 | 24102115 |
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]);