This data as json, CSV (advanced)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
20210 | 20210 | 1908-11-07 | 3 | a-b | Guangdong news. Some government officials are rehabilitated and reappointed official positions. Foreign Catholic father in Guangzhou helps his Chinese follower Wu Jiemin to fight in the court. An anonymous woman donates to charity institution in Guangzhou. Teacher Wang Zemin in Guangzhou nurse school dissects a dog in the biology class. New bank notes in Guangzhou. A meeting of the Guangzhou Local Self-government Research Society. Longxi Self-government Research Institute is opened. Quit-opium-smoking Society meets and the discussion. Self-government association set up in Ninghai town of Xinning county. Port city surveyed for international trade in the future. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801939 | 26801939 | |
20211 | 20211 | 1908-11-07 | 3 | b-c | Correspondence from Guangxi. Shopkeepers in Hexian county on strike and an investigation under way. Bandits in Wuxuan and Pingle areas. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801939 | 26801939 | |
20212 | 20212 | 1908-11-07 | 3 | c | A serious family clan fighting near Guangzhou and the casualties. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801939 | 26801939 | |
20213 | 20213 | 1908-11-07 | 3 | c-d | Solution to the family feud and fighting in Gujing town of Xinhui county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801939 | 26801939 |
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]);