This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
20081 | 20081 | 1908-10-10 | 3 | b-c | Guangdong news/ Hainan businessmen request for replacement of Haikou customs officer. Changes of the board of Guangzhou-Hankou railway. Disaster relief in Shantou. Li Jiazhuo returns to Guangdong. Nanhai and Panyu county authorities are instructed to check properties owned by Li Shigui. Effort to suppress bandits on the border of Dong'an and Yangjiang counties. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801906 | 26801906 | |
20082 | 20082 | 1908-10-10 | 3 | c | Correspondence from Xiamen. Preparation in Xiamen to welcome the arrival of American naval fleet. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801906 | 26801906 | |
20083 | 20083 | 1908-10-10 | 3 | c-d | Jianghan Daily in Hankou is sealed up and a further report on the reasons. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801906 | 26801906 | |
20084 | 20084 | 1908-10-10 | 3 | d | Important report. A London newspaper reports that foreign governments have agreed to stop morphine exports to China. Bandits in Guangdong hijack passenger liner. | Other... | http://trove.nla.gov.au/newspaper/page/26801906 | 26801906 | |
20085 | 20085 | 1908-10-10 | 3 | d | Floods in India and the casualties. | Britain | http://trove.nla.gov.au/newspaper/page/26801906 | 26801906 | |
20086 | 20086 | 1908-10-10 | 3 | d | London newspaper reports on the detainment of Japanese fishing boats by Russian authority. | Britain | http://trove.nla.gov.au/newspaper/page/26801906 | 26801906 |
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]);