This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
20643 | 20643 | 1909-02-13 | 3 | a-b | China news/ Preparation for constitutional reform at the beginning of the reign of Emperor Xuantong. Office hours for Prince Regent in the court. Chinese government asks for the withdrawal of foreign gunboats in Anhui province. Chinese army studies manufacturing technology for different weapons. Mansion to be built for Prince Regent. Naval port surveyed in north China. Three big factories to be built in Tianjin, Henan, and Pingxiang of Jiangxi province. Empress is an honest woman. | China | http://trove.nla.gov.au/newspaper/page/26802075 | 26802075 | |
20644 | 20644 | 1909-02-13 | 3 | b-c | Guangdong news/ Chinese who returned from overseas with foreign citizenship are forbidden to interfere with local legal disputes. New policy on foreign missionary work in China. Opium smoking paraphernalia confiscated in Guangzhou. Suspects detained in Guangzhou for arms smuggling. Report on the Guangzhou-Kowloon railway project last year. Guangdong authority provides subsidy for | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802075 | 26802075 | |
20645 | 20645 | 1909-02-13 | 3 | c-d | A report on the state funeral service for the late Emperor Guangxu. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802075 | 26802075 | |
20646 | 20646 | 1909-02-13 | 3 | d | A letter from Harvard University on negotiations between China and foreign countries in the past decade. | America | http://trove.nla.gov.au/newspaper/page/26802075 | 26802075 |
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]);