This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
31163 | 31163 | 1916-04-22 | 7 | a-b | Australia news/ A Chinese garden in Sydney is burglarised and the case. A Chinese man who married a Western girl is sentenced and his life in the Sydney prison. A white woman is arrested in New South Wales for wearing military uniform. About 20 woman workers in Melbourne are poisoned by fish and chips. Gold production in New South Wales and the statistics. | Australia | http://trove.nla.gov.au/newspaper/page/24095239 | 24095239 |
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]);