This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
5506 | 5506 | 1900-06-20 | 2 | c | The first part of a report on the death of Li Lianying, an eunuch in Beijing court. | China | http://trove.nla.gov.au/newspaper/page/24102846 | 24102846 | |
5507 | 5507 | 1900-06-20 | 2 | d | Report on the riots in Tainan and other areas in Taiwan against Japanese. | China | http://trove.nla.gov.au/newspaper/page/24102846 | 24102846 | |
5508 | 5508 | 1900-06-20 | 2 | d | Rumours in Wenzhou, Zhejiang province, on local rebels such as Gelaohui, and rumous about Kang Youwei. | China | http://trove.nla.gov.au/newspaper/page/24102846 | 24102846 | |
5510 | 5510 | 1900-06-20 | 2 | d | Bandits in Xiamen, Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24102846 | 24102846 | |
5511 | 5511 | 1900-06-20 | 2 | e | Xu Tong, together with Gang Yi, is the key figure to dethrone the Emperor. | China | http://trove.nla.gov.au/newspaper/page/24102846 | 24102846 | |
5512 | 5512 | 1900-06-20 | 2 | e | Liu Kunyi, Governor of Jiangsu and Zhejiang, will take office soon. | China | http://trove.nla.gov.au/newspaper/page/24102846 | 24102846 | |
5516 | 5516 | 1900-06-20 | 2 | e | Japanese government sends more soldiers to China and demands control of Zhejiang, Fujian and Jiangxi provinces; Britain, following Russia, move some soldiers from Hong Kong to Beijing; Boxers burn the holiday house of British ambassador's wife; Dozens of British and American missionaries gathered in Beijing for security reason; hundreds of Chinese followers were not hurt as protected by American troops; Boxers attack churches in Baoding, Hebei province. | China | http://trove.nla.gov.au/newspaper/page/24102846 | 24102846 | |
5519 | 5519 | 1900-06-20 | 2 | f | Number of soldiers in Beijing from different countries. | China | http://trove.nla.gov.au/newspaper/page/24102846 | 24102846 | |
5520 | 5520 | 1900-06-20 | 2 | f | A Japanese consul was killed by the Empress' security guards. | China | http://trove.nla.gov.au/newspaper/page/24102846 | 24102846 | |
5521 | 5521 | 1900-06-20 | 2 | f | A female missionary from the USA was killed in Conghua county, Guangdong province. | China | http://trove.nla.gov.au/newspaper/page/24102846 | 24102846 | |
5528 | 5528 | 1900-06-20 | 3 | b | Charity institutions in east Guangdong and donations from different people. | China | http://trove.nla.gov.au/newspaper/page/24102845 | 24102845 | |
5529 | 5529 | 1900-06-20 | 3 | b | Boxers are training their soldiers publicly in Tianjin; America transports provisions to their troops in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24102845 | 24102845 | |
5541 | 5541 | 1900-06-20 | 2 | d | Zhang Zhidong is to report to the court. | China | http://trove.nla.gov.au/newspaper/page/24102846 | 24102846 | |
5543 | 5543 | 1900-06-20 | 2 | e | Bandits in Zengcheng, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24102846 | 24102846 | |
5544 | 5544 | 1900-06-20 | 2 | f | Some people wrote to high-level officials in Beijing assuming Liang Qichao's name. | China | http://trove.nla.gov.au/newspaper/page/24102846 | 24102846 | |
5545 | 5545 | 1900-06-20 | 2 | f | Bandits in Guangdong demand a ransom. | China | http://trove.nla.gov.au/newspaper/page/24102846 | 24102846 | |
5546 | 5546 | 1900-06-20 | 2 | f | Clashes in Beijing between Boxers and foreign forces. | China | http://trove.nla.gov.au/newspaper/page/24102846 | 24102846 | |
5547 | 5547 | 1900-06-20 | 2 | f | Clashes between Russian and Chinese soldiers in Shanhaiguan. | China | http://trove.nla.gov.au/newspaper/page/24102846 | 24102846 | |
5550 | 5550 | 1900-06-20 | 3 | a | British troops back to Tianjin from Beijing; competition between foreign countries on sending troops to China; Russia stationed more troops on its border with China; riots in Yunnan province; Empress Dowager encouraged the Boxer rebellion. | China | http://trove.nla.gov.au/newspaper/page/24102845 | 24102845 | |
5551 | 5551 | 1900-06-20 | 3 | b | Funds for railways from Hankou to Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24102845 | 24102845 | |
5553 | 5553 | 1900-06-20 | 3 | b | A train accident in Hankou, Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24102845 | 24102845 |
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]);