This data as json, CSV (advanced)
Suggested facets: column
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
855 | 855 | 1898-10-01 | 3 | a-b-c | Report to His Majesty from Sheng Xuanhuai and Board of Revenue (hu bu) on establishment of Bank of China. | http://trove.nla.gov.au/newspaper/page/24102148 | 24102148 | ||
856 | 856 | 1898-10-01 | 3 | c | Man in Ararat was sentenced to 10 years' imprisonment for bank robbery. | http://trove.nla.gov.au/newspaper/page/24102148 | 24102148 | ||
857 | 857 | 1898-10-01 | 3 | c-d | Retired police officer in NSW killed his wife and child. | http://trove.nla.gov.au/newspaper/page/24102148 | 24102148 | ||
858 | 858 | 1898-10-01 | 3 | d | Priest in Melbourne crushed to death in horse-riding accident. | http://trove.nla.gov.au/newspaper/page/24102148 | 24102148 | ||
859 | 859 | 1898-10-01 | 3 | d-e | Man in Sydney kills five family members because he was not able to feed them. | http://trove.nla.gov.au/newspaper/page/24102148 | 24102148 | ||
860 | 860 | 1898-10-01 | 3 | e | Melbourne man kills his lover. | http://trove.nla.gov.au/newspaper/page/24102148 | 24102148 | ||
861 | 861 | 1898-10-01 | 3 | e | Man robbed on Sydney street while returning home at night. | http://trove.nla.gov.au/newspaper/page/24102148 | 24102148 | ||
862 | 862 | 1898-10-01 | 3 | e-f | Man in Zhaoqing dies young. | http://trove.nla.gov.au/newspaper/page/24102148 | 24102148 | ||
863 | 863 | 1898-10-01 | 3 | f | Melbourne man travels long distance on bicycle. | http://trove.nla.gov.au/newspaper/page/24102148 | 24102148 | ||
864 | 864 | 1898-10-01 | 3 | f | Britain builds six more torpedo boats. | http://trove.nla.gov.au/newspaper/page/24102148 | 24102148 |
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]);