This data as json, CSV (advanced)
Suggested facets: column, source, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
11149 | 11149 | 1902-11-08 | 2 | a-b | First part of a report on another clash between Cai Jun, Chinese ambassador to Tokyo, and Chinese students in Japan. | Japan | http://trove.nla.gov.au/newspaper/page/24100528 | 24100528 | |
11150 | 11150 | 1902-11-08 | 2 | b | Empress Dowager entertains family members of foreign missions in the Summer Palace; homage to the Western Imperial Mausoleum; Chinese ambassador to Japan Cai Jun to be recalled; social security in Beijing is now satisfactory. | China | http://trove.nla.gov.au/newspaper/page/24100528 | 24100528 | |
11151 | 11151 | 1902-11-08 | 2 | b | American engineer of the Hankou-Guangzhou railway talks about preparation and progress of the project. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100528 | 24100528 | |
11152 | 11152 | 1902-11-08 | 2 | b | Bandits and robbery in Zhaoqing, Guangdong province, and Wuzhou of Guangxi province. | China | http://trove.nla.gov.au/newspaper/page/24100528 | 24100528 | |
11153 | 11153 | 1902-11-08 | 2 | c | Zhou Fu has been appointed imperial commissioner of Shandong province. The current commissioner Zhang Renjun moves to Henan province. | China | http://trove.nla.gov.au/newspaper/page/24100528 | 24100528 | |
11154 | 11154 | 1902-11-08 | 2 | c | Qin Chunxuan has been appointed governor of Sichuan province. | China | http://trove.nla.gov.au/newspaper/page/24100528 | 24100528 | |
11155 | 11155 | 1902-11-08 | 2 | c | Rumours about the return of Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24100528 | 24100528 | |
11156 | 11156 | 1902-11-08 | 2 | c | Rumours say Wu Rulun talks inappropriately while in Japan. | China | http://trove.nla.gov.au/newspaper/page/24100528 | 24100528 | |
11157 | 11157 | 1902-11-08 | 2 | c | Portuguese seek approval from Chinese government to build a railway. | China | http://trove.nla.gov.au/newspaper/page/24100528 | 24100528 | |
11158 | 11158 | 1902-11-08 | 2 | c | Butchers in Shantou, Guangdong, are on strike in protest against new taxes. | China | http://trove.nla.gov.au/newspaper/page/24100528 | 24100528 | |
11159 | 11159 | 1902-11-08 | 2 | c | Indian soldiers in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24100528 | 24100528 | |
11160 | 11160 | 1902-11-08 | 2 | c | Pigtail in a Hong Kong textile factory caused accidents. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100528 | 24100528 |
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]);