This data as json, CSV (advanced)
Suggested facets: page, column, page_url, trove_id, date (date)
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
9253 | 9253 | 1901-12-07 | 2 | a | Imperial edicts on Sheng Xuanhuai's memorial report on July 12. | China | http://trove.nla.gov.au/newspaper/page/24100257 | 24100257 | |
9254 | 9254 | 1901-12-07 | 2 | a-b | Fourth and final part of the report from Shou Shan, Chinese army general in Heilongjiang province. | China | http://trove.nla.gov.au/newspaper/page/24100257 | 24100257 | |
9256 | 9256 | 1901-12-07 | 2 | c | Beijing paid half salary in July to the government officials. | China | http://trove.nla.gov.au/newspaper/page/24100257 | 24100257 | |
9257 | 9257 | 1901-12-07 | 2 | c | Beijing has set up a police school. | China | http://trove.nla.gov.au/newspaper/page/24100257 | 24100257 | |
9258 | 9258 | 1901-12-07 | 2 | c | Shaanxi province can expect a good harvest this year. | China | http://trove.nla.gov.au/newspaper/page/24100257 | 24100257 | |
9259 | 9259 | 1901-12-07 | 2 | d | Yin Houpei, education supervisor of Hubei province will stay in his office although he is very conservative. | China | http://trove.nla.gov.au/newspaper/page/24100257 | 24100257 | |
9260 | 9260 | 1901-12-07 | 2 | d | Regulation and requirement for imperial examination this year. | China | http://trove.nla.gov.au/newspaper/page/24100257 | 24100257 | |
9261 | 9261 | 1901-12-07 | 2 | d | Chen Lishi, an official candidate in Guangdong province, was rewarded for his donations to the country. | China | http://trove.nla.gov.au/newspaper/page/24100257 | 24100257 | |
9262 | 9262 | 1901-12-07 | 2 | d | Report on the withdrawal of international troops from Beijing. | China | http://trove.nla.gov.au/newspaper/page/24100257 | 24100257 | |
9263 | 9263 | 1901-12-07 | 2 | e | A man in Fuzhou, Fujian province, died as a result of debt. | China | http://trove.nla.gov.au/newspaper/page/24100257 | 24100257 | |
9264 | 9264 | 1901-12-07 | 2 | e | Russian troops are going to Lushun (Port Arthur). | China | http://trove.nla.gov.au/newspaper/page/24100257 | 24100257 | |
9265 | 9265 | 1901-12-07 | 2 | e | Recent relations between China and Italy. | China | http://trove.nla.gov.au/newspaper/page/24100257 | 24100257 | |
9266 | 9266 | 1901-12-07 | 2 | e-f | Clashes between Chinese residents and Russian soldiers in Aihui, on the border between China and Russia. | China | http://trove.nla.gov.au/newspaper/page/24100257 | 24100257 | |
9267 | 9267 | 1901-12-07 | 2 | f | Piece of valuable calligraphy in Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24100257 | 24100257 | |
9271 | 9271 | 1901-12-07 | 3 | a | Dong Fuxiang and his army now in Ningxia. | China | http://trove.nla.gov.au/newspaper/page/24100256 | 24100256 | |
9272 | 9272 | 1901-12-07 | 3 | a | China appoints Zhang Deyi as the new ambassador to Britain as Luo Fenglu asks for leave. | China | http://trove.nla.gov.au/newspaper/page/24100256 | 24100256 | |
9273 | 9273 | 1901-12-07 | 3 | a | Report on the imperial martial arts examination in Fuzhou, Fujian province. | China | http://trove.nla.gov.au/newspaper/page/24100256 | 24100256 | |
9275 | 9275 | 1901-12-07 | 3 | b | The imperial court in Xi'an leads a luxurious life in the famine region. | China | http://trove.nla.gov.au/newspaper/page/24100256 | 24100256 | |
9276 | 9276 | 1901-12-07 | 3 | b | No martial arts examination in Guangdong this year. | China | http://trove.nla.gov.au/newspaper/page/24100256 | 24100256 | |
9279 | 9279 | 1901-12-07 | 3 | c | Chinese cabinet postpones its return to Beijing; China will pay compensation to foreign missionaries; remnants of the Boxers in Zhili province. | China | http://trove.nla.gov.au/newspaper/page/24100256 | 24100256 |
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]);