This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31367 | 31367 | 1916-07-01 | 7 | a-b | Australia news/ Chinese men in Sydney are shot and injured and the court hearings. Opium smuggled and caught by the New South Wales customs. Census and the statistics of population in New South Wales in 1915. | Australia | http://trove.nla.gov.au/newspaper/page/24095319 | 24095319 |
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]);