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 |
---|---|---|---|---|---|---|---|---|---|
5086 | 5086 | 1900-04-28 | 2 | c | Some Westerners in Shanghai say that reform party members should be protected. | China | http://trove.nla.gov.au/newspaper/page/24102783 | 24102783 | |
5087 | 5087 | 1900-04-28 | 2 | c | Russian envoy and Chinese government discuss the Manchuria affairs; Wang Juetang called in many times to meet the Empress; Gang Yi comments on reformer Jing Liansan; a high-level official comments on the functions of telegram and railway. | China | http://trove.nla.gov.au/newspaper/page/24102783 | 24102783 | |
5088 | 5088 | 1900-04-28 | 2 | d | Demarcation of the China-Burma border and clashes between Chinese and British troops. | China | http://trove.nla.gov.au/newspaper/page/24102783 | 24102783 | |
5089 | 5089 | 1900-04-28 | 2 | d | Imperial scholars Chen Ding, Wu Shizhao, Gui Duo, Zhou Xi'en and Shen Peng were sentenced to life imprisonment for various charges. | China | http://trove.nla.gov.au/newspaper/page/24102783 | 24102783 | |
5094 | 5094 | 1900-04-28 | 2 | e | Kidnap and ransom in Zhaoqing, Guangdong province. | China | http://trove.nla.gov.au/newspaper/page/24102783 | 24102783 | |
5098 | 5098 | 1900-04-28 | 2 | f | Three doctors were called in to see the Emperor. | China | http://trove.nla.gov.au/newspaper/page/24102783 | 24102783 | |
5105 | 5105 | 1900-04-28 | 3 | b | Four poems written by Liu Kunyi, Governor of Jiangsu and Zhejiang, after meeting the Empress. | China | http://trove.nla.gov.au/newspaper/page/24102782 | 24102782 | |
5106 | 5106 | 1900-04-28 | 3 | b | Russian in Lusun, Dalian, Jinzhou and other areas of Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24102782 | 24102782 | |
5107 | 5107 | 1900-04-28 | 3 | c | Residents in central Hubei report seeing a comet. | China | http://trove.nla.gov.au/newspaper/page/24102782 | 24102782 | |
5110 | 5110 | 1900-04-28 | 3 | c | Gentry and philanthropists in Shanghai send a petition to Li Hongzhang, governor of Guangdong, regarding the Jing Liansan affairs. | China | http://trove.nla.gov.au/newspaper/page/24102782 | 24102782 |
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]);