This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
18896 | 18896 | 1908-02-15 | 8 | a-b | Railway news. Reports on disputes over the railway building in Jiangsu and Zhejiang province (attempt to borrow foreign loan, protest against foreign loans, and efforts of local authority to pacify the protest). | China | http://trove.nla.gov.au/newspaper/page/26801636 | 26801636 | |
18897 | 18897 | 1908-02-15 | 8 | b | News from Fujian. The Triad Society bandits on the border of Yongding, Pinghe and Nanjing counties and response of local government authorities. Compensation agreement achieved for the murder of two foreigners in Tong'an county years ago. Fuzhou shipyard and its development in the past few years. Local gentry and railway building in Fujian province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801636 | 26801636 | |
18898 | 18898 | 1908-02-15 | 8 | b-c | Correspondence from America. Li Huanlou graduates from a New York school and translation of his graduation certificate. Another group of Chinese students arrives Boston. Anti-Japanese movement in San Francisco and the Chinese community there. | America | http://trove.nla.gov.au/newspaper/page/26801636 | 26801636 | |
18899 | 18899 | 1908-02-15 | 8 | c-d | Jokes. Wise remark of an experienced Chinese official. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801636 | 26801636 | |
18900 | 18900 | 1908-02-15 | 8 | d | Last couplets prepared by Tan Zhuangfei. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801636 | 26801636 |
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]);