This data as json, CSV (advanced)
Suggested facets: column, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
730 | 730 | 1898-09-10 | 3 | a-b-c | Second part of report written by Wen Ti to His Majesty impeaching Kang Youwei (to be continued). | http://trove.nla.gov.au/newspaper/page/24102128 | 24102128 | ||
731 | 731 | 1898-09-10 | 3 | c | Train accident in England kills six. | http://trove.nla.gov.au/newspaper/page/24102128 | 24102128 | ||
732 | 732 | 1898-09-10 | 3 | c-d | Old man in Guangzhou hands in money he picked up on way home. | http://trove.nla.gov.au/newspaper/page/24102128 | 24102128 | ||
733 | 733 | 1898-09-10 | 3 | d | Melbourne woman sues pharmacy for negligently selling medication to husband. | http://trove.nla.gov.au/newspaper/page/24102128 | 24102128 | ||
734 | 734 | 1898-09-10 | 3 | d-e | Court case, adultery, Dongguan. | http://trove.nla.gov.au/newspaper/page/24102128 | 24102128 | ||
735 | 735 | 1898-09-10 | 3 | e-f | Father in Panyu kills his three sons. | http://trove.nla.gov.au/newspaper/page/24102128 | 24102128 | ||
736 | 736 | 1898-09-10 | 3 | f | Italian man lives for 33 days on water alone. | http://trove.nla.gov.au/newspaper/page/24102128 | 24102128 | ||
737 | 737 | 1898-09-10 | 3 | f | People site ghost in Bendigo which walks the streets at night. | http://trove.nla.gov.au/newspaper/page/24102128 | 24102128 |
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]);