This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
6981 | 6981 | 1901-02-02 | 2 | a | Imperial edicts on October 24 and 25. | China | http://trove.nla.gov.au/newspaper/page/24099938 | 24099938 | |
6982 | 6982 | 1901-02-02 | 2 | a-b | The second and final part of an article saying that China needs to replace old officials with the new ones. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099938 | 24099938 | |
6983 | 6983 | 1901-02-02 | 2 | b-c | The second part of a record of the talks between Li Hongzhang and Prince Qing, China's negotiators, and the commander of international troops for a peace protocol after the Boxer Uprising. | China | http://trove.nla.gov.au/newspaper/page/24099938 | 24099938 | |
6984 | 6984 | 1901-02-02 | 2 | c-d | Mills built to produce flour for international troops; compensation suggested to pay Chinese religious believers; business to resume; international troops in the south and north of Beijing. | Other... | http://trove.nla.gov.au/newspaper/page/24099938 | 24099938 | |
6985 | 6985 | 1901-02-02 | 2 | d | Tianjin is now under the control of international troops and the newly-selected Chinese administrator is Ding Jiali. | China | http://trove.nla.gov.au/newspaper/page/24099938 | 24099938 | |
6986 | 6986 | 1901-02-02 | 2 | d | The Empress Dowager considers staying in Xi'an permanently. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099938 | 24099938 | |
6987 | 6987 | 1901-02-02 | 2 | d | A sailor from Melbourne was drowned in Murray River near Albury. | Australia | http://trove.nla.gov.au/newspaper/page/24099938 | 24099938 | |
6988 | 6988 | 1901-02-02 | 2 | d | Storm near Adelaide in South Australia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099938 | 24099938 | |
6989 | 6989 | 1901-02-02 | 2 | d | After the death of Queen Victoria, many shops in Sydney flying mourning banners in front of their shops. Some in Parramatta were stolen during the weekend. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099938 | 24099938 | |
6990 | 6990 | 1901-02-02 | 2 | d | A doctor in Spain has magic skills which allow him to cure diseases. | Other... | http://trove.nla.gov.au/newspaper/page/24099938 | 24099938 | |
6991 | 6991 | 1901-02-02 | 2 | e | Several companies in Guangzhou are bidding to obtain a license to establish a new gambling business. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099938 | 24099938 | |
6992 | 6992 | 1901-02-02 | 2 | e | Bandits and robbery in Shunde and Zhaoqing, Guangdong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099938 | 24099938 | |
6993 | 6993 | 1901-02-02 | 2 | f | A philanthropist in Gaoyao was repaid. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099938 | 24099938 | |
6994 | 6994 | 1901-02-02 | 2 | f | A further report on the missionary cases in Guangdong, such as Panyu, Shunde, Heshan, Xinhui and Nanhai. | China | http://trove.nla.gov.au/newspaper/page/24099938 | 24099938 |
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]);