This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27116 | 27116 | 1913-03-08 | 7 | a | Australian news/ Sydney tram tunnel proposed. Sydney gas workers on strike for wage increase. Illegal Chinese migrants die on ship to Australia. Court tells Australian born Chinese children allowed to stay in Australia. | Other... | http://trove.nla.gov.au/newspaper/page/24092604 | 24092604 |
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]);