This data as json, CSV (advanced)
Suggested facets: page, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
7735 | 7735 | 1901-05-22 | 2 | b-c | A letter from Tao Mo, governor of Guangdong and Guangxi provinces, to the Chinese consul in Singapore in regards to Qiu Shuyuan and Lin Wenqing. | Singapore | http://trove.nla.gov.au/newspaper/page/24100047 | 24100047 | |
7746 | 7746 | 1901-05-22 | 2 | e | Why Yuan Chang and Xu Jingcheng were executed. | Singapore | http://trove.nla.gov.au/newspaper/page/24100047 | 24100047 | |
7750 | 7750 | 1901-05-22 | 2 | f | Huang Fucheng and Li Ai'sheng, both from Fujian province, cultivate wasteland with hundreds of peasants coming from Fujian, China. Deng Gongshu and Zheng Zaoshang, both from Guangdong, are keen to follow. | Singapore | http://trove.nla.gov.au/newspaper/page/24100047 | 24100047 | |
7753 | 7753 | 1901-05-22 | 3 | a | Qiu Shuyuan replied from Singapore to Tao Mo, governor of Guangdong. | Singapore | http://trove.nla.gov.au/newspaper/page/24100046 | 24100046 |
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]);