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 |
---|---|---|---|---|---|---|---|---|---|
8238 | 8238 | 1901-07-24 | 3 | d | A British hero was awarded for his brave fighting in Africa. | Other... | http://trove.nla.gov.au/newspaper/page/24100117 | 24100117 | |
8229 | 8229 | 1901-07-24 | 3 | a | A Sydney man was penalised for selling wines without license. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100117 | 24100117 | |
8215 | 8215 | 1901-07-24 | 2 | a-b | A letter from Tang Jiazheng to Prince Qing suggesting, 1) to set up an advisory committee and, 2) to set up more schools. | China | http://trove.nla.gov.au/newspaper/page/24100118 | 24100118 | |
8230 | 8230 | 1901-07-24 | 3 | a | A man in Sydney was punished for being drunken. | Australia | http://trove.nla.gov.au/newspaper/page/24100117 | 24100117 | |
8225 | 8225 | 1901-07-24 | 2 | e | A rapist in Fujian province was castrated. | China | http://trove.nla.gov.au/newspaper/page/24100118 | 24100118 | |
8223 | 8223 | 1901-07-24 | 2 | e | An actress of Britain is seeking for compensation for defamation. | Australia | http://trove.nla.gov.au/newspaper/page/24100118 | 24100118 | |
8228 | 8228 | 1901-07-24 | 3 | a | An earl in Britain was punished for bigamy. | Other... | http://trove.nla.gov.au/newspaper/page/24100117 | 24100117 | |
8235 | 8235 | 1901-07-24 | 3 | c | An old man in Sydney refused to go to nursing home. | Australia | http://trove.nla.gov.au/newspaper/page/24100117 | 24100117 | |
8224 | 8224 | 1901-07-24 | 2 | e | Chemical composition of human body. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100118 | 24100118 | |
8220 | 8220 | 1901-07-24 | 2 | d | Difference between the Empress and the Emperor on new policy. | China | http://trove.nla.gov.au/newspaper/page/24100118 | 24100118 | |
8218 | 8218 | 1901-07-24 | 2 | d | Dignity of Rong Lu, Lu Chuanlin and Wang Wenshao. | China | http://trove.nla.gov.au/newspaper/page/24100118 | 24100118 | |
8234 | 8234 | 1901-07-24 | 3 | c | Fire in Sydney caused much damages. | Australia | http://trove.nla.gov.au/newspaper/page/24100117 | 24100117 | |
8237 | 8237 | 1901-07-24 | 3 | d | Heat wave lingering in Paris and London. | Australia | http://trove.nla.gov.au/newspaper/page/24100117 | 24100117 | |
8214 | 8214 | 1901-07-24 | 2 | a | Imperial edicts on April 21. | China | http://trove.nla.gov.au/newspaper/page/24100118 | 24100118 | |
8239 | 8239 | 1901-07-24 | 3 | d | Liner timetable. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100117 | 24100117 | |
8222 | 8222 | 1901-07-24 | 2 | e | Relations between Russia and Britain over the China issues; ancestor's land given to Italy; Indian soldiers in Tianjin. | China | http://trove.nla.gov.au/newspaper/page/24100118 | 24100118 | |
8231 | 8231 | 1901-07-24 | 3 | b | Religious chaos in the Philippines. | Australia | http://trove.nla.gov.au/newspaper/page/24100117 | 24100117 | |
8226 | 8226 | 1901-07-24 | 2 | f | Some Manchurian bannermen in Guangzhou were put into prison. | China | http://trove.nla.gov.au/newspaper/page/24100118 | 24100118 | |
8221 | 8221 | 1901-07-24 | 2 | d | Story of Prince Chun, brother of Emperor Guangxu. | China | http://trove.nla.gov.au/newspaper/page/24100118 | 24100118 | |
8236 | 8236 | 1901-07-24 | 3 | d | The Hong Kong -Shanghai Bank in Singapore found the bank notes they lost. | Singapore | http://trove.nla.gov.au/newspaper/page/24100117 | 24100117 | |
8227 | 8227 | 1901-07-24 | 2 | f | The first part of couplets in remembrance of Yuan Chang, Xu Jingcheng and Xu Chengyu, respectively written by Tao Mo, Li Zhongtang, Huang Jianfan, Chen Baoyuan, Jin Zhaofan, Fang Ruizeng, Wang Cunshan, Yan Fu, Yan Xinhou, Wang Deling, Sun Tingxian, Wang Zhonglin, Zhao Fengchang, Liu Shupin, Liao Yuchun, and others. | China | http://trove.nla.gov.au/newspaper/page/24100118 | 24100118 | |
8217 | 8217 | 1901-07-24 | 2 | d | The newly established office for political reform and its officials Rong Lu, Fan Zengxiang, Lu Chuanlin, Chen Bangrui, Guo Zengxin, Sun Baoqi, Xu Shichang, Xu Shoupeng, Zhang Peilun, and others. | China | http://trove.nla.gov.au/newspaper/page/24100118 | 24100118 | |
8216 | 8216 | 1901-07-24 | 2 | b-d | The third and final part of an article, selected from a Shanghai newspaper, on possible changes of China in the twentieth century. | China | http://trove.nla.gov.au/newspaper/page/24100118 | 24100118 | |
8233 | 8233 | 1901-07-24 | 3 | b-c | The third part of a report on the meeting of Sydney Chinese community: 1) to set up a Chinese merchants association and the draft of constitution; 2) assistance provided to the poor and old Chinese for their return to China. | Tung Wah | http://trove.nla.gov.au/newspaper/page/24100117 | 24100117 | |
8232 | 8232 | 1901-07-24 | 3 | b | Three American soldiers in Beijing were imprisoned for looting. | China | http://trove.nla.gov.au/newspaper/page/24100117 | 24100117 | |
8219 | 8219 | 1901-07-24 | 2 | d | Zhang Zhidong is trying to shut down newspapers in order to stop rumours. | China | http://trove.nla.gov.au/newspaper/page/24100118 | 24100118 |
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]);