This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27868 | 27868 | 1913-09-13 | 7 | a-b | Australia news/ Queensland authority issues new restriction on Chinese sugarcane growers. Sydney customs seize smuggled opium. Chinese opium smoker is penalised in Sydney. Local parliamentarian in New South Wales oppose to the bail out of a Chinese convict. Australia has new merchant ship. New South Wales authority inspects Chinese gambling. | Australia | http://trove.nla.gov.au/newspaper/page/24092820 | 24092820 |
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]);