This data as json, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
19785 | 19785 | 1908-08-08 | 3 | a-b | Beijing news. Dispute between Zhang Zhidong and Yuan Shikai. Bureau of Military Affairs (jun ji chu) offers rewards for the capture of Sun Yatsen. Newly-arrived Japanese ambassador to Beijing comments on the relation between China and Japan. Tang Shaoyi supports to borrow foreign loans in order to rejuvenate Chinese navy. Chinese government to revise its regulation on foreign missionary work in China. Direct election of county & prefectural magistrate to be stopped. Zheng wen she sets up a branch in Yangzhou, of Jiangsu province. American government will sponsor an international opium conference in Shanghai and the report. Floods in Zhejiang, Fujiang and Jiangxi province. | China | http://trove.nla.gov.au/newspaper/page/26801834 | 26801834 | |
19798 | 19798 | 1908-08-08 | 6 | a-b | Translation. China to send more army students to France. Chinese cruise in Xijiang River, Guangdong. Chinese businessmen and Portuguese authority in Macao. | Other... | http://trove.nla.gov.au/newspaper/page/26801839 | 26801839 | |
19815 | 19815 | 1908-08-08 | 8 | a-b | Further report on floods in Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26801841 | 26801841 |
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]);