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 |
|---|---|---|---|---|---|---|---|---|---|
| 7363 | 7363 | 1901-04-03 | 2 | a | Imperial edicts on December 14. | China | http://trove.nla.gov.au/newspaper/page/24099992 | 24099992 | |
| 7364 | 7364 | 1901-04-03 | 2 | b-c | The second part of an article claiming that the peace negotiations with foreign governments may require the Emperor's return to power. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099992 | 24099992 | |
| 7365 | 7365 | 1901-04-03 | 2 | c | Report on the new governor of Guangdong and Guangxi provinces. | China | http://trove.nla.gov.au/newspaper/page/24099992 | 24099992 | |
| 7366 | 7366 | 1901-04-03 | 2 | c-d | The draft peace agreement that China is discussing with foreign governments. | China | http://trove.nla.gov.au/newspaper/page/24099992 | 24099992 | |
| 7367 | 7367 | 1901-04-03 | 2 | d | Empress Dowager inquiries into the death of Xu Tong and Song Qing; Rong Lu in the court; arrogant prince; grain prices in Xi'an; famine and refugees in Shaanxi. | China | http://trove.nla.gov.au/newspaper/page/24099992 | 24099992 | |
| 7368 | 7368 | 1901-04-03 | 2 | d | Government police station in Beijing does little to help social stability. | China | http://trove.nla.gov.au/newspaper/page/24099992 | 24099992 | |
| 7369 | 7369 | 1901-04-03 | 2 | d | Imperial buildings need to be refurbished; many courtmaids have committed suicide. | China | http://trove.nla.gov.au/newspaper/page/24099992 | 24099992 | |
| 7370 | 7370 | 1901-04-03 | 2 | e | Members of the Chinese delegation for peace negotiations with foreign countries. | China | http://trove.nla.gov.au/newspaper/page/24099992 | 24099992 | |
| 7371 | 7371 | 1901-04-03 | 2 | e | Russia and Japan want to form alliances on the China issues; British gunboat moves from Xiamen to Dagu; China appoints a new ambassador Nie Jigui to Britain. He replaces Luo Fenglu. | Other... | http://trove.nla.gov.au/newspaper/page/24099992 | 24099992 | |
| 7372 | 7372 | 1901-04-03 | 2 | e | Russian government has punished college students for voicing their political opinions. | Other... | http://trove.nla.gov.au/newspaper/page/24099992 | 24099992 | |
| 7373 | 7373 | 1901-04-03 | 2 | e | Tornado disasters in Alabama, United States. | America | http://trove.nla.gov.au/newspaper/page/24099992 | 24099992 | |
| 7374 | 7374 | 1901-04-03 | 2 | e | A girl in Sydney was abducted. | Australia | http://trove.nla.gov.au/newspaper/page/24099992 | 24099992 | |
| 7375 | 7375 | 1901-04-03 | 2 | f | A new clock in America. | Other... | http://trove.nla.gov.au/newspaper/page/24099992 | 24099992 | |
| 7376 | 7376 | 1901-04-03 | 2 | f | The second and final part of a letter from China's chief negotiators to the foreign diplomats in Beijing. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099992 | 24099992 | |
| 7377 | 7377 | 1901-04-03 | 3 | a | Tianjin is going to pull down the city wall. | China | http://trove.nla.gov.au/newspaper/page/24099991 | 24099991 | |
| 7378 | 7378 | 1901-04-03 | 3 | a | Imperial edict on the treaty with Russia; China to approve the draft agreement; Liu Kunyi, Zhang Zhidong and other local governors advise the Emperor not to sign the treaty with Russia; British ambassador blames Chinese negotiators; Japanese Prime Minister on China; a soldier from New South Wales dies in China. | Other... | http://trove.nla.gov.au/newspaper/page/24099991 | 24099991 | |
| 7379 | 7379 | 1901-04-03 | 3 | b | Bandits and robbery in Guangzhou. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099991 | 24099991 | |
| 7380 | 7380 | 1901-04-03 | 3 | b | Bandits in Nanhai, the response of the government. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099991 | 24099991 | |
| 7381 | 7381 | 1901-04-03 | 3 | b | A mother in Guangzhou met her son after many years. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099991 | 24099991 | |
| 7382 | 7382 | 1901-04-03 | 3 | c | A Sydney man was sentenced for embezzlement. | Australia | http://trove.nla.gov.au/newspaper/page/24099991 | 24099991 | |
| 7383 | 7383 | 1901-04-03 | 3 | c | A jewellery shop in Sydney was robbed. | Australia | http://trove.nla.gov.au/newspaper/page/24099991 | 24099991 | |
| 7384 | 7384 | 1901-04-03 | 3 | c | Governors and imperial commissioners advise the Emperor not to sign the treaty with Russia; British parliament comments on China issues; Chinese cabinet moves from Xi'an to Kaifeng in Henan province. | Other... | http://trove.nla.gov.au/newspaper/page/24099991 | 24099991 | |
| 7385 | 7385 | 1901-04-03 | 3 | d | Dong Fuxiang and his army; story of Fan Zengxiang. | China | http://trove.nla.gov.au/newspaper/page/24099991 | 24099991 | |
| 7386 | 7386 | 1901-04-03 | 3 | d | France is going to purchase more gunboats. | Australia | http://trove.nla.gov.au/newspaper/page/24099991 | 24099991 | |
| 7387 | 7387 | 1901-04-03 | 3 | d | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099991 | 24099991 |
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]);