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 |
---|---|---|---|---|---|---|---|---|---|
8968 | 8968 | 1901-11-02 | 2 | a | Imperial edicts on June 8, 19 and 20. | China | http://trove.nla.gov.au/newspaper/page/24100217 | 24100217 | |
8969 | 8969 | 1901-11-02 | 2 | a-c | The sixth and final part of memorial report from Liu Kunyi and Zhang Zhidong on cultivation of young people. | China | http://trove.nla.gov.au/newspaper/page/24100217 | 24100217 | |
8971 | 8971 | 1901-11-02 | 2 | c | Preparation are undergoing for the imperial return. | China | http://trove.nla.gov.au/newspaper/page/24100217 | 24100217 | |
8972 | 8972 | 1901-11-02 | 2 | c | China is to punish the Boxers harshly. | China | http://trove.nla.gov.au/newspaper/page/24100217 | 24100217 | |
8973 | 8973 | 1901-11-02 | 2 | c | Salary levels for officials of the foreign affairs department. | China | http://trove.nla.gov.au/newspaper/page/24100217 | 24100217 | |
8974 | 8974 | 1901-11-02 | 2 | d | China is to change its customs after the peace protocol. | China | http://trove.nla.gov.au/newspaper/page/24100217 | 24100217 | |
8975 | 8975 | 1901-11-02 | 2 | d | Flooding in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24100217 | 24100217 | |
8976 | 8976 | 1901-11-02 | 2 | d | Report on Dong Fuxiang. | China | http://trove.nla.gov.au/newspaper/page/24100217 | 24100217 | |
8977 | 8977 | 1901-11-02 | 2 | d | The Illness of Li Hongzhang. | China | http://trove.nla.gov.au/newspaper/page/24100217 | 24100217 | |
8978 | 8978 | 1901-11-02 | 2 | d | Dust rain in Guangzhou. | China | http://trove.nla.gov.au/newspaper/page/24100217 | 24100217 | |
8979 | 8979 | 1901-11-02 | 2 | d | A disaster in Shantou involved quite a few families. | China | http://trove.nla.gov.au/newspaper/page/24100217 | 24100217 | |
8980 | 8980 | 1901-11-02 | 2 | e | A boy in Guangzhou repelled the bandits. | China | http://trove.nla.gov.au/newspaper/page/24100217 | 24100217 | |
8988 | 8988 | 1901-11-02 | 2 | f | Hundreds of frogs found lakeside in Xinhui county, Guangdong. | China | http://trove.nla.gov.au/newspaper/page/24100217 | 24100217 | |
8990 | 8990 | 1901-11-02 | 3 | a | Imperial martial arts examination will go ahead in Hubei province. | China | http://trove.nla.gov.au/newspaper/page/24100216 | 24100216 | |
8991 | 8991 | 1901-11-02 | 3 | a | Guangdong authority will re-organise and clean all family clans in the province. | China | http://trove.nla.gov.au/newspaper/page/24100216 | 24100216 | |
8992 | 8992 | 1901-11-02 | 3 | b | Li Hongzhang is seriously sick; Chongwenmen in Beijing now opens earlier everyday; He Naiying and Gan Dazhang have been removed from their positions; Emperor is pleased reading report from Liu Kunyi and Zhang Zhidong; Zhang Zhidong to be promoted. | China | http://trove.nla.gov.au/newspaper/page/24100216 | 24100216 | |
8993 | 8993 | 1901-11-02 | 3 | b | A letter from Western friend in Dalian about Russians in Manchuria. | China | http://trove.nla.gov.au/newspaper/page/24100216 | 24100216 | |
9000 | 9000 | 1901-11-02 | 3 | e | Mad scholar Hu Jin, of Sichuan province, in exile. | China | http://trove.nla.gov.au/newspaper/page/24100216 | 24100216 |
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]);