This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
27027 | 27027 | 1913-02-22 | 2 | c-d | Draft of provincial chief supervisor. | Other... | http://trove.nla.gov.au/newspaper/page/24092585 | 24092585 | |
27049 | 27049 | 1913-02-22 | 8 | c-d | Singapore Chinese donate to support China's war against Russia over Mongolian issue. Woman lets baby die due to her madness with religion. Prostitutes active in Indonesia. Singapore Chinese reluctant to cut pigtail. | Other... | http://trove.nla.gov.au/newspaper/page/24092591 | 24092591 |
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]);