This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
21133 | 21133 | 1909-06-12 | 3 | a-b | Correspondence from Macao/ Portuguese in Macao gather for the future. Opening of Xiangzhou town in Xiangshan county has significant influence upon business in Macao. Opium trade in Macao and the decline. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802213 | 26802213 | |
21134 | 21134 | 1909-06-12 | 3 | b-c | Beijing news/ Effort for naval rejuvenation. Volumes of books published on foreign political systems. Preparation in Hunan province for the establishment of legislature assembly. Opium to be totally banned within three years. China and Britain start negotiation on the return of Weihaiwei. The Shandong University established by German and its courses. | China | http://trove.nla.gov.au/newspaper/page/26802213 | 26802213 | |
21135 | 21135 | 1909-06-12 | 3 | c-d | Guangdong news/ Provincial authorities take precautions against instigation by revolutionaries. Railway project in Xinning county has been completed. Governor general Zhang Renjun asks for a report from Chenghai county on the Mayu island. News on the demarcation of Macao border with Guangzhou. The market is dull in Macao. A survey on the coastline islands, especially in Xin'an, Xiangshan, Xinhui, Xinning and Chixi counties. Xisha islands to be inhabited. Gambling in Zengcheng county and the effort to ban gambling. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802213 | 26802213 | |
21136 | 21136 | 1909-06-12 | 3 | d | Submarine cables in the world in 1897 and 1907. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802213 | 26802213 | |
21137 | 21137 | 1909-06-12 | 3 | d | Population in New York and their original countries. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802213 | 26802213 | |
21138 | 21138 | 1909-06-12 | 3 | d | Tung Wah Times comments on China's foreign policy. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802213 | 26802213 |
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]);