This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
4904 | 4904 | 1900-04-07 | 2 | d | A ship from Singapore to Western Australia has passengers infected with smallpox. | Australia | http://trove.nla.gov.au/newspaper/page/24102759 | 24102759 | |
4905 | 4905 | 1900-04-07 | 2 | d | A post office in Queensland was burgled. | Australia | http://trove.nla.gov.au/newspaper/page/24102759 | 24102759 | |
4906 | 4906 | 1900-04-07 | 2 | d | A girl in New Zealand drowned trying to save her brother. | New Zealand | http://trove.nla.gov.au/newspaper/page/24102759 | 24102759 | |
4907 | 4907 | 1900-04-07 | 2 | d | Seaman punished for luring his fellow to work in another ship; woman in Melbourne sentenced for helping another woman abortion; Chinese gardener penalised for dumping garbage in a public place; man in Perth charged for rape; man in Clayton brought to court for beating his sister-in-law. | Australia | http://trove.nla.gov.au/newspaper/page/24102759 | 24102759 | |
4921 | 4921 | 1900-04-07 | 3 | d | Five Chinese, on the way from New Zealand to China, were permitted to land in Sydney to visit their friends and family members. The landing was guaranteed by Zheng Tianlu, editor of Tung Wah. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102758 | 24102758 |
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]);