This data as json, CSV (advanced)
Suggested facets: page, column, source, page_url, trove_id, 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 | |
| 11161 | 11161 | 1902-11-08 | 3 | a | New South Wales parliament sits again. | Australia | http://trove.nla.gov.au/newspaper/page/24100527 | 24100527 | |
| 11162 | 11162 | 1902-11-08 | 3 | a | British in South Africa; Yuan Shikai has been appointed Prime Minister; a commercial association in Shanghai praise the trade treaty between China and Britain; Japan to revise its immigration law. | Other... | http://trove.nla.gov.au/newspaper/page/24100527 | 24100527 | |
| 11163 | 11163 | 1902-11-08 | 3 | b | A Sydney man comments on Shanghai and Hong Kong after his tour. | Australia | http://trove.nla.gov.au/newspaper/page/24100527 | 24100527 | |
| 11164 | 11164 | 1902-11-08 | 3 | b | France seeks the contract to build a railway from Guizhou to Sichuan province. | Japan | http://trove.nla.gov.au/newspaper/page/24100527 | 24100527 | |
| 11165 | 11165 | 1902-11-08 | 3 | b | Thailand's relations with foreign countries. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100527 | 24100527 | |
| 11166 | 11166 | 1902-11-08 | 3 | b | A ship from Westport, New Zealand, to Hong Kong, sank into the ocean, together with 500 Chinese coffins and 5000 ton coal. | Australia | http://trove.nla.gov.au/newspaper/page/24100527 | 24100527 | |
| 11167 | 11167 | 1902-11-08 | 3 | c | A Chinese shop in Sydney consigned for shipment two boxes of cigarettes to a shop in Glen Innes. | Australia | http://trove.nla.gov.au/newspaper/page/24100527 | 24100527 | |
| 11168 | 11168 | 1902-11-08 | 3 | c | Li Liang, who was detained for providing false testimony, has been released. | Australia | http://trove.nla.gov.au/newspaper/page/24100527 | 24100527 | |
| 11169 | 11169 | 1902-11-08 | 3 | c | Japanese consulate in Sydney had a party to celebrate birthday of the Emperor of Japan. Chinese attendants include Tang Caizhi, Liu Ruxing, Ouyang Qing, Li Bu, Mei Guangda, Situ Qian, and Sun Jinsheng. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100527 | 24100527 | |
| 11170 | 11170 | 1902-11-08 | 3 | c | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100527 | 24100527 |
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]);