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 |
|---|---|---|---|---|---|---|---|---|---|
| 13282 | 13282 | 1904-06-04 | 2 | a | Sixth part of the article, selected from a Hong Kong newspaper, commenting on China's history and cultural traditions. | Hong Kong | http://trove.nla.gov.au/newspaper/page/26800450 | 26800450 | |
| 13283 | 13283 | 1904-06-04 | 2 | b | Report on the Summer Palace in Beijing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800450 | 26800450 | |
| 13284 | 13284 | 1904-06-04 | 2 | b | Eunuch Li Lianying's red cap indicates his powerful position. | China | http://trove.nla.gov.au/newspaper/page/26800450 | 26800450 | |
| 13285 | 13285 | 1904-06-04 | 2 | c | A wharf to be built in Changshan. Changsha will be opened for international business. | China | http://trove.nla.gov.au/newspaper/page/26800450 | 26800450 | |
| 13286 | 13286 | 1904-06-04 | 2 | c | Riots in Jijing, Yanzhou and Caozhou in Shandong province. | China | http://trove.nla.gov.au/newspaper/page/26800450 | 26800450 | |
| 13287 | 13287 | 1904-06-04 | 2 | c | Local residents in Sichuan and north Guizhou province have organised themselves to fight foreigners. | China | http://trove.nla.gov.au/newspaper/page/26800450 | 26800450 | |
| 13288 | 13288 | 1904-06-04 | 2 | c | Some money, deducted from government officials' salary, might be used for army training. | China | http://trove.nla.gov.au/newspaper/page/26800450 | 26800450 | |
| 13289 | 13289 | 1904-06-04 | 2 | c | Rebellions in the east of Jilin province to fight Russian. | China | http://trove.nla.gov.au/newspaper/page/26800450 | 26800450 | |
| 13290 | 13290 | 1904-06-04 | 2 | c | Army training authority requests ammunition depot to be established in the capital of each province. | China | http://trove.nla.gov.au/newspaper/page/26800450 | 26800450 | |
| 13291 | 13291 | 1904-06-04 | 2 | c | Board of Revenue suggests establishing a national bank. | China | http://trove.nla.gov.au/newspaper/page/26800450 | 26800450 | |
| 13292 | 13292 | 1904-06-04 | 2 | c | Imperial commissioner of Hubei province Duan Fang is leaving at the expiration of his term of office. Duan Fang applies for an overseas tour at his own expense. | China | http://trove.nla.gov.au/newspaper/page/26800450 | 26800450 | |
| 13293 | 13293 | 1904-06-04 | 2 | c | Education in Mongolia. Chinese and Japanese teachers there. Mongolia sent students to study overseas. Postal service in Mongolia. Agriculture and cotton production in Mongolia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800450 | 26800450 | |
| 13294 | 13294 | 1904-06-04 | 2 | c | Hubei province is to send more students to study in European countries. | China | http://trove.nla.gov.au/newspaper/page/26800450 | 26800450 | |
| 13295 | 13295 | 1904-06-04 | 2 | d | Report on a school fight in Taiwan under Japanese regime. | China | http://trove.nla.gov.au/newspaper/page/26800450 | 26800450 | |
| 13296 | 13296 | 1904-06-04 | 2 | d | Ms Zhang Zhujun is to lead the Red Cross in China. | China | http://trove.nla.gov.au/newspaper/page/26800450 | 26800450 | |
| 13297 | 13297 | 1904-06-04 | 2 | d | Report on the escape of Pei Jingfu and Li Shigui, former magistrate of Nanhai county, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/26800450 | 26800450 | |
| 13298 | 13298 | 1904-06-04 | 2 | d | Guangdong governor sends gunboats to arrest Pei Jingfu, the suspected criminal, but was refused by Portuguese authority in Macao. | China | http://trove.nla.gov.au/newspaper/page/26800450 | 26800450 | |
| 13299 | 13299 | 1904-06-04 | 2 | d | Copy of the oath of a Korean revolutionary party. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800450 | 26800450 | |
| 13300 | 13300 | 1904-06-04 | 3 | a | Business in Russia has been significantly influenced by the war in the east. | Australia | http://trove.nla.gov.au/newspaper/page/26800449 | 26800449 | |
| 13301 | 13301 | 1904-06-04 | 3 | a | Internal rebellion and crisis in Russia. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800449 | 26800449 | |
| 13302 | 13302 | 1904-06-04 | 3 | a-b | Miscellaneous report on the war between Russia and Japan in Manchuria. | Other... | http://trove.nla.gov.au/newspaper/page/26800449 | 26800449 | |
| 13303 | 13303 | 1904-06-04 | 3 | b | Principal of a Russian school comments on the Russo-Japanese War. | Britain | http://trove.nla.gov.au/newspaper/page/26800449 | 26800449 | |
| 13304 | 13304 | 1904-06-04 | 3 | b | Chinese commanders in Manchuria, Ma Yukun and others, are poised to fight Russia. | Britain | http://trove.nla.gov.au/newspaper/page/26800449 | 26800449 | |
| 13305 | 13305 | 1904-06-04 | 3 | b | Russian and Japanese have both refused Red Cross staff sent by China, Britain, Germany, America and France. | China | http://trove.nla.gov.au/newspaper/page/26800449 | 26800449 | |
| 13306 | 13306 | 1904-06-04 | Suppl't | a | An essay on the revolutionary movement and its influence. | China | http://trove.nla.gov.au/newspaper/page/26800451 | 26800451 | |
| 13307 | 13307 | 1904-06-04 | Suppl't | a | Stories about Zhang Zhidong and Yuan Shikai. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800451 | 26800451 | |
| 13308 | 13308 | 1904-06-04 | Suppl't | a | An old scholar worries about change of the world. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800451 | 26800451 | |
| 13309 | 13309 | 1904-06-04 | Suppl't | b | Some people are allowed to see the face of Empress Dowager. | China | http://trove.nla.gov.au/newspaper/page/26800451 | 26800451 | |
| 13310 | 13310 | 1904-06-04 | Suppl't | b | Authorities of Gaoyao county, Guangdong, are to impose new tax for fish fry. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800451 | 26800451 | |
| 13311 | 13311 | 1904-06-04 | Suppl't | b | Xiangshan county, Guangdong, saw riots for the new pig tax. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800451 | 26800451 | |
| 13312 | 13312 | 1904-06-04 | Suppl't | b | Japanese troops have taken over Dalian. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800451 | 26800451 | |
| 13313 | 13313 | 1904-06-04 | Suppl't | b | Russian ambassador to Beijing told Chinese government that they want to get Mongolia. | Britain | http://trove.nla.gov.au/newspaper/page/26800451 | 26800451 | |
| 13314 | 13314 | 1904-06-04 | Suppl't | b | Some further reports on the war between Russia and Japan in Manchuria. | Other... | http://trove.nla.gov.au/newspaper/page/26800451 | 26800451 | |
| 13315 | 13315 | 1904-06-04 | Suppl't | b | Britain is to take over Tibet. | China | http://trove.nla.gov.au/newspaper/page/26800451 | 26800451 | |
| 13316 | 13316 | 1904-06-04 | Suppl't | c | A young Chinese man was robbed in Sydney. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800451 | 26800451 | |
| 13317 | 13317 | 1904-06-04 | Suppl't | c | Pei Jingfu has been arrested. | Hong Kong | http://trove.nla.gov.au/newspaper/page/26800451 | 26800451 | |
| 13318 | 13318 | 1904-06-04 | Suppl't | c | Fang Gonghui and his son Fang Dazhi, of Guangdong, donate their books to a Guangzhou university. | China | http://trove.nla.gov.au/newspaper/page/26800451 | 26800451 | |
| 13319 | 13319 | 1904-06-04 | Suppl't | c | Gold price in Hong Kong. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800451 | 26800451 | |
| 13320 | 13320 | 1904-06-04 | Suppl't | c | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26800451 | 26800451 |
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]);