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 |
|---|---|---|---|---|---|---|---|---|---|
| 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]);