This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
8252 | 8252 | 1901-07-27 | 2 | f | Wife of the President of Transvaal died of long illness. | Other... | http://trove.nla.gov.au/newspaper/page/24100122 | 24100122 | |
8253 | 8253 | 1901-07-27 | 2 | f | A brand of new gramophone. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100122 | 24100122 | |
8254 | 8254 | 1901-07-27 | 2 | f | The second part of couplets in remembrance of Yuan Chang, Xu Jingcheng and Xu Chengyu, respectively written by Liao Ningchun, Sun Jiahu, Shi Shaotang, Li Miantang, Xu Dinghe, Pu Hua, Wang Bing, Sun Rui, Zhou Hongsun, Shao Naizheng, Shao Ding, Zhu Dazhao, Xu Zhijin, and others. | China | http://trove.nla.gov.au/newspaper/page/24100122 | 24100122 |
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]);