This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
5286 | 5286 | 1900-05-23 | 2 | d | Honolulu authority burns down many Japanese and Chinese houses in order to prevent epidemics. Japanese government now seeks compensation on behalf of their people. However, Chinese government and their consuls there take no action. | America | http://trove.nla.gov.au/newspaper/page/24102812 | 24102812 |
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]);