This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
4903 | 4903 | 1900-04-07 | 2 | c | A gold mining accident in Western Australia claims one life and one injury; the Australian federation is on the way and selection of commonwealth capital is yet to be decided, Albury is currently the favourite; burglary in Kalgoorlie, Western Australia; a train in New Zealand nearly derailed; robbery on the border of New South Wales and Victoria; island people in the Pacific need grain; a post office in Queensland burgled. | Australia | http://trove.nla.gov.au/newspaper/page/24102759 | 24102759 | |
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 | |
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 | |
4914 | 4914 | 1900-04-07 | 2 | f | Cattle competition in New South Wales; Windsor experienced a good harvest; Queensland donates funds to the famine area in India. | Australia | http://trove.nla.gov.au/newspaper/page/24102759 | 24102759 |
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]);