This data as json, CSV (advanced)
Suggested facets: column, source
Link | rowid ▼ | date | page | column | title | description | source | page_url | trove_id |
---|---|---|---|---|---|---|---|---|---|
22708 | 22708 | 1910-04-30 | 2 | a-b | Second and final part of the editorial claims that local self-government would be foundation for constitutional reform. | Tung Wah | http://trove.nla.gov.au/newspaper/page/26802607 | 26802607 | |
22709 | 22709 | 1910-04-30 | 2 | b-c | Imperial edict on February 7, 8 and 9 on appointment and removal of some officials. | China | http://trove.nla.gov.au/newspaper/page/26802607 | 26802607 | |
22710 | 22710 | 1910-04-30 | 2 | c | News in brief/ Security guard Zhi Bin blocks the war of Prince Regent and reports corruption. German and Russian students in Beijing. Foreign countries compete each other to contract the Sichuan-Hubei railway project. Li Jingyi reports that French want to control post service in Yunnan province. Census under preparation. Uniform for girl students in Beijing. Two French engineers in the Beijing-Hankou railway project apply for Chinese citizenship. Russian rebuffs attempt of Britain and America in Manchuria. Post service to be unified by 1913. Number of students in Beijing University. | China | http://trove.nla.gov.au/newspaper/page/26802607 | 26802607 | |
22711 | 22711 | 1910-04-30 | 2 | c | Liang Cheng might be accredited to Germany. | China | http://trove.nla.gov.au/newspaper/page/26802607 | 26802607 | |
22712 | 22712 | 1910-04-30 | 2 | c | An order in Guangdong to catch Ou Jujia, of Zhenhua company. | China | http://trove.nla.gov.au/newspaper/page/26802607 | 26802607 | |
22713 | 22713 | 1910-04-30 | 2 | d | Further report on the rebellion and chaos in Changsha, capital of Hunan province. | China | http://trove.nla.gov.au/newspaper/page/26802607 | 26802607 |
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]);