This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
7434 | 7434 | 1901-04-10 | 3 | a | Xu Chengyu, Xu Tong's son, colludes with the Boxers. | China | http://trove.nla.gov.au/newspaper/page/24099999 | 24099999 | |
7435 | 7435 | 1901-04-10 | 3 | a | Shen Zhongli in Zhangjiakou persuaded the international troops to retreat. | Other... | http://trove.nla.gov.au/newspaper/page/24099999 | 24099999 | |
7436 | 7436 | 1901-04-10 | 3 | a | Li Hongzhang's interview with George Morrison, reporter of The Times in London, on the progress of peace negotiations; Japan says they will help China if China refuses to sign the treaty with Russia; Empress Dowager orderes Dong Fuxiang to a station in Gansu province; Chinese government replies to Russia on the treaty; responses of Li Hongzhang to the treaty with Russia; Russian government is outraged at China's reply; Li Hongzhang's comments on Manchuria issue. | Other... | http://trove.nla.gov.au/newspaper/page/24099999 | 24099999 | |
7437 | 7437 | 1901-04-10 | 3 | d | A man from Ashfield, Sydney, drowned while swimming. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099999 | 24099999 | |
7438 | 7438 | 1901-04-10 | 3 | d | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099999 | 24099999 |
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]);