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 |
|---|---|---|---|---|---|---|---|---|---|
| 7195 | 7195 | 1901-03-09 | 2 | a | Imperial edicts on November 28. | China | http://trove.nla.gov.au/newspaper/page/24099967 | 24099967 | |
| 7196 | 7196 | 1901-03-09 | 2 | a-c | A study of the parliamentary systems in European countries. | China | http://trove.nla.gov.au/newspaper/page/24099967 | 24099967 | |
| 7197 | 7197 | 1901-03-09 | 2 | c | Different ethnics and languages in Beijing; British officer attacked while travelling; relief for the famine area in Shaanxi province. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099967 | 24099967 | |
| 7198 | 7198 | 1901-03-09 | 2 | c | The Empress and the Emperor both cried on hearing the news of the famine. | China | http://trove.nla.gov.au/newspaper/page/24099967 | 24099967 | |
| 7199 | 7199 | 1901-03-09 | 2 | c | A copy of the peace protocol that foreign governments presented to Chinese government for approval. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099967 | 24099967 | |
| 7200 | 7200 | 1901-03-09 | 2 | d | Guangdong experienced a good harvest this year. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099967 | 24099967 | |
| 7201 | 7201 | 1901-03-09 | 2 | d | Guangdong provincial government considers reducing the security guards. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099967 | 24099967 | |
| 7202 | 7202 | 1901-03-09 | 2 | e | Some gambling houses have opened in Guangzhou. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099967 | 24099967 | |
| 7203 | 7203 | 1901-03-09 | 2 | e | County governments in Guangdong have arrested many bandits, especially in Xiangshan county. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099967 | 24099967 | |
| 7204 | 7204 | 1901-03-09 | 2 | e | China is still in the process of considering the peace agreement; Germany informed Li Hongzhang that China should not just negotiate with one country; Yu Xian has been executed in Gansu for his collusion with Boxers; Dong Fuxiang in Gansu; France will withdraw some of their soldiers from China; Russia wants to totally control Manchuria; number of foreign missionaries murdered by Boxers. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099967 | 24099967 | |
| 7205 | 7205 | 1901-03-09 | 2 | f | Russia forces China to sign the Manchuria agreement they have prepared; Japan wants to have similar treatment from China; King Edward of Britain visits Germany; shooting stars seen in Cooma, NSW. | Other... | http://trove.nla.gov.au/newspaper/page/24099967 | 24099967 | |
| 7206 | 7206 | 1901-03-09 | 2 | f | A rabbit hunter in Armidale, NSW, shot and killed a man. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099967 | 24099967 | |
| 7207 | 7207 | 1901-03-09 | 2 | f | A rich man in Britain built a cool room to store food. | Singapore | http://trove.nla.gov.au/newspaper/page/24099967 | 24099967 | |
| 7208 | 7208 | 1901-03-09 | 3 | a | The longest railway in the world; to measure the Earth; the richest man; exploration to the North Pole and expenditure; bachelors' club in London. | Other... | http://trove.nla.gov.au/newspaper/page/24099966 | 24099966 | |
| 7209 | 7209 | 1901-03-09 | 3 | a | A new novel in China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099966 | 24099966 | |
| 7210 | 7210 | 1901-03-09 | 3 | b | Business in Japan was influenced by chaos in China. | Japan | http://trove.nla.gov.au/newspaper/page/24099966 | 24099966 | |
| 7211 | 7211 | 1901-03-09 | 3 | b | Bandits are active near Beijing; Japanese troops in Langfang were attacked by bandits; bandits in Yangcun village, Baihe River and other areas. | China | http://trove.nla.gov.au/newspaper/page/24099966 | 24099966 | |
| 7212 | 7212 | 1901-03-09 | 3 | b | Four men will be executed for their collusion with Boxers, He Naiying, Wang Peiyou, and another two. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099966 | 24099966 | |
| 7213 | 7213 | 1901-03-09 | 3 | c | French foreign minister on China; British foreign secretary on China; the Emperor on the way back to Beijing. | China | http://trove.nla.gov.au/newspaper/page/24099966 | 24099966 | |
| 7214 | 7214 | 1901-03-09 | 3 | c | A Beijing official pretends to be a scholar. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24099966 | 24099966 | |
| 7215 | 7215 | 1901-03-09 | 3 | d | Chen Dayou, accountant of a Chinese shop in Sydney, was robbed in broad daylight. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099966 | 24099966 | |
| 7216 | 7216 | 1901-03-09 | 3 | d | Police in Geelong are investigating the death of a girl. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099966 | 24099966 | |
| 7217 | 7217 | 1901-03-09 | 3 | d | Three Chinese return home with gold. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099966 | 24099966 | |
| 7218 | 7218 | 1901-03-09 | 3 | d | Timetable of ocean liners. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24099966 | 24099966 |
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]);