This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
5641 | 5641 | 1900-07-11 | 2 | b | China should have commodities fair in order to promote business development. | China | http://trove.nla.gov.au/newspaper/page/24102870 | 24102870 | |
5642 | 5642 | 1900-07-11 | 2 | b-c | Britain encourages Japan to send more troops to China; number of British gunboats in China; British diplomats in Beijing and Tianjin; clashes between Chinese and German soldiers; Japan sends more troops to China; German ambassador to Beijing requests for military help from his country; clashes between Chinese and British troops. | China | http://trove.nla.gov.au/newspaper/page/24102870 | 24102870 | |
5645 | 5645 | 1900-07-11 | 2 | c | Bandits in Xijiang River, Guangdong, clashed with government forces. | China | http://trove.nla.gov.au/newspaper/page/24102870 | 24102870 | |
5647 | 5647 | 1900-07-11 | 2 | d | Bandits in Guangning county, Guangdong, hide in the mountain caves. | China | http://trove.nla.gov.au/newspaper/page/24102870 | 24102870 | |
5649 | 5649 | 1900-07-11 | 2 | d | List of imperial examiners for Guangdong province, including Chen Botao, Cui Yong'an, Zhang Xuehua, Li Jiaju, Liang Shiyi, Wu Guidan, Wu Quancui, Cheng Youqi, Chen Qinggui, etc. | China | http://trove.nla.gov.au/newspaper/page/24102870 | 24102870 | |
5650 | 5650 | 1900-07-11 | 2 | d | Report on the daily life of Wong Tonghe. | China | http://trove.nla.gov.au/newspaper/page/24102870 | 24102870 | |
5651 | 5651 | 1900-07-11 | 2 | e | An imperial scholar suggests we avoid using characters for both people and place names if the characters are same as translations. | China | http://trove.nla.gov.au/newspaper/page/24102870 | 24102870 | |
5655 | 5655 | 1900-07-11 | 2 | e | Robert Hart in Beijing; British, German and Italian embassies are safe; recent clashes between Chinese and foreign armies near Beijing; Boxers and Chinese troops were defeated; clashes between Chinese and British troops in Shanghai; foreign women and children are leaving Tianjin; foreign missionaries and Chinese followers were killed by Boxers and their heads were hung on the wall; German government on China situation; number of German soldiers in China. | China | http://trove.nla.gov.au/newspaper/page/24102870 | 24102870 | |
5659 | 5659 | 1900-07-11 | 2 | f | A fortuneteller in Tianjin predicts development in China. | China | http://trove.nla.gov.au/newspaper/page/24102870 | 24102870 | |
5661 | 5661 | 1900-07-11 | 3 | a | Xu Tiger (Xu laohu), of Zhenjiang, Jiangsu province, is organising his troops for rebellion. | China | http://trove.nla.gov.au/newspaper/page/24102869 | 24102869 | |
5663 | 5663 | 1900-07-11 | 3 | a | China and Japan agree on compensation for injury sustained by Japanese people in Xiamen, Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24102869 | 24102869 | |
5665 | 5665 | 1900-07-11 | 3 | b | Nanhai county set timelimit for local bandits to surrender. | China | http://trove.nla.gov.au/newspaper/page/24102869 | 24102869 | |
5666 | 5666 | 1900-07-11 | 3 | b | Bandits on the border of Hunan, Guizhou and Guangxi provinces. | China | http://trove.nla.gov.au/newspaper/page/24102869 | 24102869 | |
5667 | 5667 | 1900-07-11 | 3 | b | Russia, Japan, Britain, France and Germany send more troops to Beijing; Britain recalls Chinese ambassador; Luo Fenglu concerned for the safety of foreigners in China. | China | http://trove.nla.gov.au/newspaper/page/24102869 | 24102869 | |
5668 | 5668 | 1900-07-11 | 3 | b | Exports from China are increasing. | China | http://trove.nla.gov.au/newspaper/page/24102869 | 24102869 |
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]);