This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
19446 | 19446 | 1908-06-06 | 6 | a-b | Correspondence from America. Guan Jingxin, son of a Hong Kong millionaire, is travelling around the world with his wife and has arrived in Hawaii. Chinese communities in San Francisco discuss and support the navy tax. Californian governor talks in San Diego the defence of America. | America | http://trove.nla.gov.au/newspaper/page/26801763 | 26801763 |
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]);