This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
8394 | 8394 | 1901-08-24 | 2 | d-e | Three Chinese, Xu Shiqin, Xue Zhongying and Lu Jin'en, were detained on their arrival in San Francisco. The arrest was recommended by Chinese consul He You and Chinese ambassador Wu Tingfang. | America | http://trove.nla.gov.au/newspaper/page/24100144 | 24100144 |
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]);