This data as json, CSV (advanced)
Suggested facets: source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
19274 | 19274 | 1908-05-02 | 2 | b-c | An imperial edict to ban opium smoking and trade. | China | http://trove.nla.gov.au/newspaper/page/26801718 | 26801718 | |
19280 | 19280 | 1908-05-02 | 3 | b-c | Zhang Renjun ordered to survey and map Chinese territorial waters. Guangxi province encourages Guangdong businessmen to invest in the cultivation of wasteland. Guangdong is urged to report the educational development in the past few years. Survey for the railway project from Guangzhou to Kowloon and from Guangzhou to Xiamen (Amoy). Local authority in Guangzhou and the capture of revolutionaries. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801717 | 26801717 | |
19289 | 19289 | 1908-05-02 | 6 | b-c | Report on the protest movement in China and boycott of Japanese goods. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801722 | 26801722 | |
19308 | 19308 | 1908-05-02 | 8 | b-c | Third and final part of the loan contract for the Shanghai-Hangzhou-Ningbo railway project and signed between Chinese ministry of foreign affairs and British company. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801724 | 26801724 |
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]);