This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
6100 | 6100 | 1900-09-19 | 2 | a-b | The second part of a report on Rong Lu's collusion with Boxers with a purpose to attack foreigners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102952 | 24102952 | |
6101 | 6101 | 1900-09-19 | 2 | b-c | A public letter, written by anonymous author, to governors throughout China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102952 | 24102952 | |
6102 | 6102 | 1900-09-19 | 2 | c-d | A poor scholar in Shunde has been busy preparing for the imperial examination but it stopped this year. | China | http://trove.nla.gov.au/newspaper/page/24102952 | 24102952 | |
6103 | 6103 | 1900-09-19 | 2 | d | A father in Melbourne killed his son through poisoning him. | Australia | http://trove.nla.gov.au/newspaper/page/24102952 | 24102952 | |
6104 | 6104 | 1900-09-19 | 2 | d | Russian and French troops ordered to leave Beijing if possible; British ambassador congratulates Governor of India; some foreign troops on the way from Tianjin to Baoding; Li Hongzhang and Qing Qinwang are empowered to negotiate with foreign governments; number of casualties (foreign missionaries and their family members, Chinese followers, etc); a gunboat from South Australia arrived Hong Kong. | Other... | http://trove.nla.gov.au/newspaper/page/24102952 | 24102952 | |
6105 | 6105 | 1900-09-19 | 2 | e | A young man in Queensland drowns when trying to save a girl. | Australia | http://trove.nla.gov.au/newspaper/page/24102952 | 24102952 | |
6106 | 6106 | 1900-09-19 | 2 | e | Niaolongshan Fortifications, on the border of Shangyuan, Yizheng and Liuhe counties, have been refurbished. | China | http://trove.nla.gov.au/newspaper/page/24102952 | 24102952 | |
6107 | 6107 | 1900-09-19 | 2 | e | Russia and Japan discuss Beijing affairs; Russia tries to send more troops to Beijing; murderers who killed German ambassador are still on the run; clashes between Chinese and American soldiers; clashes between Russian soldiers and Boxers near Beijing; a group of Japanese navy landed in Shanghai. | Other... | http://trove.nla.gov.au/newspaper/page/24102952 | 24102952 | |
6108 | 6108 | 1900-09-19 | 2 | f | How telephone can help people to communicate. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102952 | 24102952 | |
6109 | 6109 | 1900-09-19 | 2 | f | Two girls in Sydney were imprisoned for secret sex services. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102952 | 24102952 | |
6110 | 6110 | 1900-09-19 | 2 | f | Bandit Fu Zankai and his men have surrendered to government. | China | http://trove.nla.gov.au/newspaper/page/24102952 | 24102952 | |
6111 | 6111 | 1900-09-19 | 2 | f | Thieves caught in Shunde while robbing shops. | China | http://trove.nla.gov.au/newspaper/page/24102952 | 24102952 | |
6112 | 6112 | 1900-09-19 | 2 | f | A passenger boat in Shunde county, Guangdong, was capsized but no one was drowned. | China | http://trove.nla.gov.au/newspaper/page/24102952 | 24102952 |
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]);