This data as json, CSV (advanced)
Suggested facets: page, page_url, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
3703 | 3703 | 1899-09-30 | 2 | e | The men who allegedly killed a Chinese in New Zealand were released free of charge. | http://trove.nla.gov.au/newspaper/page/24102550 | 24102550 | ||
3704 | 3704 | 1899-09-30 | 2 | e | A girl in Parramatta, Sydney, attempted suicide but was saved. | http://trove.nla.gov.au/newspaper/page/24102550 | 24102550 | ||
3705 | 3705 | 1899-09-30 | 2 | e | Two boys in New South Wales drowned. | http://trove.nla.gov.au/newspaper/page/24102550 | 24102550 | ||
3719 | 3719 | 1899-09-30 | 3 | e | A girl in Melbourne was compensated for being bitten by a dog. | http://trove.nla.gov.au/newspaper/page/24102549 | 24102549 | ||
3720 | 3720 | 1899-09-30 | 3 | e | The numbers printed on coins indicate whether or not they are counterfeit. | http://trove.nla.gov.au/newspaper/page/24102549 | 24102549 | ||
3721 | 3721 | 1899-09-30 | 3 | e | Queensland cares for orphans. | http://trove.nla.gov.au/newspaper/page/24102549 | 24102549 | ||
3722 | 3722 | 1899-09-30 | 3 | e | Man charged with rape; Chinese man in Shepparton faces court charge with rape. | http://trove.nla.gov.au/newspaper/page/24102549 | 24102549 | ||
3723 | 3723 | 1899-09-30 | 3 | e | A father in Melbourne was sentenced to seven years' imprisonment for committing incest. | http://trove.nla.gov.au/newspaper/page/24102549 | 24102549 |
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]);