This data as json, CSV (advanced)
Suggested facets: page, source, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
7095 | 7095 | 1901-02-16 | 2 | a | Imperial edicts on November 2 and 4. | China | http://trove.nla.gov.au/newspaper/page/24099954 | 24099954 | |
7111 | 7111 | 1901-02-16 | 2 | a | British commander in Beijing helped the poor. | China | http://trove.nla.gov.au/newspaper/page/24099954 | 24099954 | |
7112 | 7112 | 1901-02-16 | 3 | a | A holiday notice from the newspaper. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099953 | 24099953 | |
7113 | 7113 | 1901-02-16 | 3 | a | Ammunition transported for Hunan province sank into water on the way. | China | http://trove.nla.gov.au/newspaper/page/24099953 | 24099953 | |
7114 | 7114 | 1901-02-16 | 3 | a | Residents of Changsha, capital of Hunan province, came out on the streets on hearing a rumour of fire. | China | http://trove.nla.gov.au/newspaper/page/24099953 | 24099953 | |
7115 | 7115 | 1901-02-16 | 3 | a | Boats transporting articles of tribute to Xi'an were stranded in Xiang River, Shaanxi province. | China | http://trove.nla.gov.au/newspaper/page/24099953 | 24099953 | |
7116 | 7116 | 1901-02-16 | 3 | a | Some of the Boxers fled Zhili for Henan province; three government officials in Henan province were found in collaboration with Boxers. | China | http://trove.nla.gov.au/newspaper/page/24099953 | 24099953 |
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]);