This data as json, CSV (advanced)
date (date) 2 ✖
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
3620 | 3620 | 1899-09-20 | 2 | e | A Chinese in New Castle was penalised for gambling illegally. | http://trove.nla.gov.au/newspaper/page/24102538 | 24102538 | ||
54524 | 54524 | 1934-09-15 | 6 | e | Australia news/ Flu in Melbourne. Visitor talks about Japan on his return to Sydney. Chinese Chamber of Commerce in Sydney entertains Sydney health authority official. NSW state government offers rewards to the capture of robber. Some girls disappear in Sydney and the report. A mysterious plan near Brisbane. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24096162 | 24096162 |
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]);