This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
7179 | 7179 | 1901-03-06 | 3 | a | Russia forces Chinese ambassador to sign an agreement granting Russia more Chinese territory; Italian gunboats in Zhejiang; Britain appoints new commander for their troops in China; the railway from Beijing to Shanhaiguan will be returned to China later. | Other... | http://trove.nla.gov.au/newspaper/page/24099962 | 24099962 | |
7180 | 7180 | 1901-03-06 | 3 | a | An American captain was ordered to stop sailing the ship in heavy fog. | America | http://trove.nla.gov.au/newspaper/page/24099962 | 24099962 | |
7181 | 7181 | 1901-03-06 | 3 | a | Census and population of Germany. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099962 | 24099962 | |
7182 | 7182 | 1901-03-06 | 3 | a | An American coal mine was on fire. | America | http://trove.nla.gov.au/newspaper/page/24099962 | 24099962 | |
7183 | 7183 | 1901-03-06 | 3 | b | Emperor of Germany and his wife were frightened while touring the city. | Australia | http://trove.nla.gov.au/newspaper/page/24099962 | 24099962 | |
7184 | 7184 | 1901-03-06 | 3 | b | A girl in Tamworth, New South Wales, drowned in bath water. | Australia | http://trove.nla.gov.au/newspaper/page/24099962 | 24099962 | |
7185 | 7185 | 1901-03-06 | 3 | b | Russia forces China to follow their demands while Britain and Japan advise China not to do so; Russia transfers the railway from Tanggu to Shanhaiguan to Britain; Zhili province appoints officials following advice of foreigners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099962 | 24099962 | |
7186 | 7186 | 1901-03-06 | 3 | b | The Empress praised Qin Chunxuan; Rong Lu in the court; Empress Dowager cancels her plan to Sichuan; hotels were crowded as many provincial officials arrived in Xi'an; charity institutions were crowded; Lu Chuanlin suggested to build temples for Li Bingheng and Yu Lu; Lu Chuanlin was defeated by Qin Yunjie in power struggle. | Other... | http://trove.nla.gov.au/newspaper/page/24099962 | 24099962 | |
7187 | 7187 | 1901-03-06 | 3 | b | Famine in Shaanxi. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099962 | 24099962 | |
7188 | 7188 | 1901-03-06 | 3 | c | A notice from Liu Kunyi, governor of Zhejiang and Jiangsu provinces. | China | http://trove.nla.gov.au/newspaper/page/24099962 | 24099962 | |
7189 | 7189 | 1901-03-06 | 3 | c | Zhang Zhidong suggests another reform plan. | China | http://trove.nla.gov.au/newspaper/page/24099962 | 24099962 | |
7190 | 7190 | 1901-03-06 | 3 | c | Gentry in Guangdong, Li Guolian and Chen Zhaochang, suggests collecting money in order to purchase tributes. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099962 | 24099962 | |
7191 | 7191 | 1901-03-06 | 3 | c | Talented female doctors in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099962 | 24099962 | |
7192 | 7192 | 1901-03-06 | 3 | d | Storm in the Pacific destroys some cargo ships. | Australia | http://trove.nla.gov.au/newspaper/page/24099962 | 24099962 | |
7193 | 7193 | 1901-03-06 | 3 | d | A passer-by in Newtown, Sydney, was beaten by thugs. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099962 | 24099962 | |
7194 | 7194 | 1901-03-06 | 3 | d | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099962 | 24099962 |
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]);