This data as json, CSV (advanced)
Suggested facets: column, source
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 | |
9255 | 9255 | 1901-12-07 | 2 | b-c | The second part of an article, written by a Japanese viscount, on the education of Chinese people. | Japan | 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 | |
9268 | 9268 | 1901-12-07 | 2 | f | A woman in Britain wants to divorce her husband. | Australia | http://trove.nla.gov.au/newspaper/page/24100257 | 24100257 | |
9269 | 9269 | 1901-12-07 | 2 | f | A bank employee in London was arrested for embezzlement. | Britain | http://trove.nla.gov.au/newspaper/page/24100257 | 24100257 | |
9270 | 9270 | 1901-12-07 | 2 | f | Report on Prince Chun's arrival in Hong Kong on his way back to China. | Hong Kong | http://trove.nla.gov.au/newspaper/page/24100257 | 24100257 |
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]);