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 |
|---|---|---|---|---|---|---|---|---|---|
| 8183 | 8183 | 1901-07-20 | 2 | a | Imperial edicts on April 5. | China | http://trove.nla.gov.au/newspaper/page/24100114 | 24100114 | |
| 8184 | 8184 | 1901-07-20 | 2 | a-c | The second part of an article, selected from a Shanghai newspaper, on possible changes to China in the twentieth century. | China | http://trove.nla.gov.au/newspaper/page/24100114 | 24100114 | |
| 8185 | 8185 | 1901-07-20 | 2 | c | A flour mill of Newtown, Sydney, was on fire. | Australia | http://trove.nla.gov.au/newspaper/page/24100114 | 24100114 | |
| 8186 | 8186 | 1901-07-20 | 2 | c | Heat wave hit London and Paris, claiming some casualties. | Australia | http://trove.nla.gov.au/newspaper/page/24100114 | 24100114 | |
| 8187 | 8187 | 1901-07-20 | 2 | c | Prince Duan and his army are now moving to Shanxi province. | China | http://trove.nla.gov.au/newspaper/page/24100114 | 24100114 | |
| 8188 | 8188 | 1901-07-20 | 2 | c | Prince Chun, brother of Emperor Guangxu, is to apologise to Germany for the murder of the German ambassador by Boxers in Beijing. | China | http://trove.nla.gov.au/newspaper/page/24100114 | 24100114 | |
| 8189 | 8189 | 1901-07-20 | 2 | c | Some Chinese officials are still on a wanted list for their collusion with Boxers. | China | http://trove.nla.gov.au/newspaper/page/24100114 | 24100114 | |
| 8190 | 8190 | 1901-07-20 | 2 | d | China is going to collect poll tax in order to pay the compensation. | China | http://trove.nla.gov.au/newspaper/page/24100114 | 24100114 | |
| 8191 | 8191 | 1901-07-20 | 2 | d | France considers taking Hainan Island away from China. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100114 | 24100114 | |
| 8192 | 8192 | 1901-07-20 | 2 | d | Palaces under refurbishment for the return of the Emperor; foreign troops in the Palace will withdraw. | China | http://trove.nla.gov.au/newspaper/page/24100114 | 24100114 | |
| 8193 | 8193 | 1901-07-20 | 2 | e | The war between Britain and Transvaal, South Africa. | Other... | http://trove.nla.gov.au/newspaper/page/24100114 | 24100114 | |
| 8194 | 8194 | 1901-07-20 | 2 | e | Prince of Britain left South Australia for Western Australia. | Australia | http://trove.nla.gov.au/newspaper/page/24100114 | 24100114 | |
| 8195 | 8195 | 1901-07-20 | 2 | e | Heat wave hit New York. | America | http://trove.nla.gov.au/newspaper/page/24100114 | 24100114 | |
| 8196 | 8196 | 1901-07-20 | 2 | e | Story of Jing Liansan, a reformer. | China | http://trove.nla.gov.au/newspaper/page/24100114 | 24100114 | |
| 8197 | 8197 | 1901-07-20 | 2 | f | Conservatives are more likely to be promoted. | China | http://trove.nla.gov.au/newspaper/page/24100114 | 24100114 | |
| 8198 | 8198 | 1901-07-20 | 2 | f | A public notice found in Tianjin issued by foreign missions. | China | http://trove.nla.gov.au/newspaper/page/24100114 | 24100114 | |
| 8199 | 8199 | 1901-07-20 | 3 | a | Belgium ambassador to Beijing has been appointed advisor of the zongli yamen. | China | http://trove.nla.gov.au/newspaper/page/24100113 | 24100113 | |
| 8200 | 8200 | 1901-07-20 | 3 | a | Japanese troops have transported all artillery they looted in north China to their country. | China | http://trove.nla.gov.au/newspaper/page/24100113 | 24100113 | |
| 8201 | 8201 | 1901-07-20 | 3 | a | A report on the market in Xi'an. | China | http://trove.nla.gov.au/newspaper/page/24100113 | 24100113 | |
| 8202 | 8202 | 1901-07-20 | 3 | a | Report on the death of Li Tingxiao. | China | http://trove.nla.gov.au/newspaper/page/24100113 | 24100113 | |
| 8203 | 8203 | 1901-07-20 | 3 | a | Families fight in Nanhai county, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24100113 | 24100113 | |
| 8204 | 8204 | 1901-07-20 | 3 | b | Flooding in Qingyuan county, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24100113 | 24100113 | |
| 8205 | 8205 | 1901-07-20 | 3 | b | Steel workers in America are on strike. | America | http://trove.nla.gov.au/newspaper/page/24100113 | 24100113 | |
| 8206 | 8206 | 1901-07-20 | 3 | b | Optical theory for planting in America. | Other... | http://trove.nla.gov.au/newspaper/page/24100113 | 24100113 | |
| 8207 | 8207 | 1901-07-20 | 3 | C | The war between Britain and Transvaal, in South Africa. | Other... | http://trove.nla.gov.au/newspaper/page/24100113 | 24100113 | |
| 8208 | 8208 | 1901-07-20 | 3 | c | A note of thanks from Liu Wugao, a Chinese in Melbourne who was injured. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100113 | 24100113 | |
| 8209 | 8209 | 1901-07-20 | 3 | c | Two men in Sydney were penalised for stealing from a Chinese. | Australia | http://trove.nla.gov.au/newspaper/page/24100113 | 24100113 | |
| 8210 | 8210 | 1901-07-20 | 3 | d | Xu Yingkui, governor of Fujian province, changes the curriculum of a college in Fuzhou. | China | http://trove.nla.gov.au/newspaper/page/24100113 | 24100113 | |
| 8211 | 8211 | 1901-07-20 | 3 | d | Empress Dowager's private savings. | China | http://trove.nla.gov.au/newspaper/page/24100113 | 24100113 | |
| 8212 | 8212 | 1901-07-20 | 3 | d | Empress Dowager seems ready for reform. | China | http://trove.nla.gov.au/newspaper/page/24100113 | 24100113 | |
| 8213 | 8213 | 1901-07-20 | 3 | d | Timetable of ocean lienrs. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100113 | 24100113 |
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]);