This data as json, CSV (advanced)
Suggested facets: source, 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 | |
19454 | 19454 | 1908-06-06 | 7 | a-b | Two liner captains are penalised in Sydney for illegal entry of Chinese sailors. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801762 | 26801762 | |
19461 | 19461 | 1908-06-06 | 8 | a-b | A report submitted by Yang Shiqi on Chinese communities in Nanyang and their business activities. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801765 | 26801765 |
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]);