This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
6296 | 6296 | 1900-10-17 | 2 | a-b | The first part of an essay on Zhang Zhidong's execution of reformers. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102987 | 24102987 | |
6297 | 6297 | 1900-10-17 | 2 | b-c | The first part of a letter from Jing Liansan to Li Hongzhang. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24102987 | 24102987 | |
6298 | 6298 | 1900-10-17 | 2 | c | Boxers worship Confucius, Guandi, Dong Fuxiang and Li Bingheng. | China | http://trove.nla.gov.au/newspaper/page/24102987 | 24102987 | |
6299 | 6299 | 1900-10-17 | 2 | c-d | The Empress and the Emperor in Shanxi. | China | http://trove.nla.gov.au/newspaper/page/24102987 | 24102987 | |
6300 | 6300 | 1900-10-17 | 2 | d | Saving the Emperor Army, of Datong in Anhui province, issues a notice. | China | http://trove.nla.gov.au/newspaper/page/24102987 | 24102987 | |
6301 | 6301 | 1900-10-17 | 2 | d | Bandits in Heshan county, Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102987 | 24102987 | |
6302 | 6302 | 1900-10-17 | 2 | e | The first part of the diary written by a Guangdong man who was working in Tianjin during the Boxer turmoil. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24102987 | 24102987 | |
6303 | 6303 | 1900-10-17 | 2 | e | Russia and Germany occupy important positions in China; Russia and Germany sign an agreement about the railway from Tanggu to Beijing; American ambassador confirms the number of Boxers who attacked foreign missions; foreign troops in Beijing need more provisions; Chinese and foreign troops clashed in Baoding, Zhili province; American envoy reported that more riots in south China may be possible if peace negotiation delayed further; some people in Foshan attacked churches. | Other... | http://trove.nla.gov.au/newspaper/page/24102987 | 24102987 | |
6304 | 6304 | 1900-10-17 | 2 | f | Further report on Sun Yatsen and the attempt to assassinate Kang Youwei in Singapore. | Singapore | http://trove.nla.gov.au/newspaper/page/24102987 | 24102987 |
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]);