This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
19012 | 19012 | 1908-03-14 | 2 | b-c | Important news/ Shanxi province regains its mining resources. China to organise and train new army in Yunnan province to guard against possible French invasion. Robert Hart retires to his home country England. China to redeem the railway from Beijing to Hankou with loans from Belgian source. China to appoint an official for fishing issues in the Xijiang River of Guangdong. Yuan Shikai revises laws drafted for newspaper publishing. Beijing students to be disciplined. Zhang Renjun has news proposal for the reform of currency system. Chinese government asks British authority in Singapore to deport Sun Yatsen. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801662 | 26801662 | |
19028 | 19028 | 1908-03-14 | 6 | b-c | Negotiations between China and Japan over the Jiandao island and the difficulties. Proposal to set up a school to train customs officers. Chen Bi tries to separate post service from the customs. | Hong Kong | http://trove.nla.gov.au/newspaper/page/26801666 | 26801666 | |
19041 | 19041 | 1908-03-14 | 7 | b-c | A letter from a steamship company regarding Chinese passengers and their comments about the service en route. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801665 | 26801665 | |
19046 | 19046 | 1908-03-14 | 8 | b-c | A report submitted by du cha yuan suggests establishing the state parliament. | China | http://trove.nla.gov.au/newspaper/page/26801668 | 26801668 |
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]);