New paper by Cameron Campbell on exam degree holders at the end of the Qing

Hu Heng at the Institute of Qing History at Renmin University just published a paper on the appointment of prefects during the Qing, with Bijia Chen and me as second and third authors. The paper makes use of spatial data as well as the government ratings of prefectures that determined who controlled the appointment of their prefects, and makes use of the CGED-Q to examine the qualifications, and previous and subsequent appointments of prefects. The paper is available here: http://dx.doi.org/10.6743%2fNAJ.202008_37.0009 Here is the abstract:

知府在清代地方行政體系中的地位十分重要,其選任方式及空間差異是觀察清王朝政治治理方式的絕佳窗口。依據新考訂的清代府的缺分、等第資料,對其進行量化統計和GIS分析,可以看出交通、政務、賦稅、治安等幾項主要指標的空間分布差異,進而依據這些指標確定知府選任權:歸皇帝簡放的請旨缺、歸吏部銓選的部選缺與歸督撫調任的題調缺。請旨缺佔了48.3%,基本分布在全國最重要區域;題調缺佔26.1%,原主要分布於雲貴桂湘等苗疆分布區,後漸包括內地省區交界等特殊地區,晚清新設省區的府則幾乎全部定為題調缺;部選缺佔25.6%,多位於內地省區邊緣。這一空間分布大體匹配中國各區域治理難度,但也存在對西南邊疆差異化對待、忽略海疆府份缺分的及時更改、資格固化等問題。缺分分布與知府選任關係密切,通過對目前已建設的《縉紳錄》數據庫1833-1912年段,從近300萬條職官數據中提取,共得到37,752條、3,403人的知府數據。利用STATA進行分類、匯總、關聯、追蹤等技術處理,可以看出知府旗漢比例、籍貫分布特別是湖南籍知府在晚清的上升態勢,為理解晚清乃至民國以降中國政治版圖變遷提供新的數據基礎。知府來源於京官系統比例約61.9%,地方系統約35.8%,京官外放遠大於地方晉升的模式無疑對州縣官的激勵帶來消極影響。知府晉升概率達21%,其中與缺分關係密切,最要缺所在的知府,升遷比例達26.3%,要缺所在的知府,升遷比例為23.5%,特別是省會所在的首府,更高達40.5%。清代知府選任權力分配及各類制度變異背後,體現著中央與地方圍繞地方重要官員任免權的角力,由於清代官僚體系「治官之官多、治民之官少」的固有弊端,以及知府一級選任中京官外放比例遠高於地方晉升的結構所限,清代地方治理在「府」一級出現一定程度「上下不通」的局面。晚清督撫權力的增大及委署知府的普遍實施無疑是對這一弊端的調整與補救,但又將帶來新的權力失衡的風險。

Prefects played an essential role in the system of local government during the Qing dynasty. Examining the process by which they were appointed, including exceptions and variations, sheds light on the governing strategies of the Qing state. We conduct spatial and quantitative analysis of the appointment of prefects based on the most recent data on the government’s ratings of the significance and difficulty (chongfanpinan and quefen) for each prefecture. The results reveal the importance of the process of appointment of variations across prefectures in transportation, government affairs, revenue collection, and public security. They collectively determined who had the authority to appoint the prefect for a prefecture: the Emperor (gingzhi que), the Board of Personnel (buxuan que), or the Governor-General (tidiao que). Appointments by the Emperor accounted for 48.3 percent of prefectures. These were in the most important regions of the country. Appointments by the Governor-General accounted for 26.1 percent of prefectures. At the beginning they were mainly in the regions where the Miao resided, including Yunnan, Guizhou, Guangxi and Hunan. Later, some prefectures on the provincial boundaries were also included. In the late Qing, prefects in all the newly created provinces were appointed by Govermors-General. Appointments by the Board of Personnel accounted for 25.6% of prefectures and they were concentrated in areas close to the boundaries of inland provinces. The spatial distribution of the classifications generally followed the government’s assessment of the difficulties of governing various regions in China, but there were exceptions and problems like the differentiation of treatment in the Southwestern boundary regions, neglect of the change of prefectures and classifications in coastal border areas and qualification immutability. The classification of prefectures was closely related to the appointment of prefects. We analyzed the career histories of 3403 prefects recorded in 37752 entries about Qing civil servants extracted from the 3,000,000 in nearly CGED-Q database. Using STATA to categorize, summarize, correlate and track these data ,, we examine the time trends in the characteristics of prefects, including the proportions of Manchu or Han prefects and their province of origin. For the latter, we focused specifically on the increase in the number of prefects from Hunan in the late Qing period. The results of our analysis make use of new data to advance our understanding of the political geography of China in the late Qing and the Republican periods. Regarding the career transitions in the civil service, 61.9 percent of prefects were transferred from posts in the central govermment and only 35.8 percent were promoted from posts in local govermments. This undoubtedly had a negative effect on the motivation of county magistrates. Prospects for promotion for prefects was generally high: 21 percent would reach higher office. For prefects who served in prefectures categorized as most significant (zuiyao gue) and significant (vao gue), the chance of promotion was between 23.5 and 26.3 percent. Those who were prefects in provincial capitals had even higher chances of being promoted: 40.5 percent. The distribution of control over the appointment of prefects and the institutional changes over time reveal the tension and competition over power between the central and local government. In the Qing, governance at the prefectural level was characterized as "blocking between the upper and the lower [level of government]". This was partly driven by the structure of the system, according to which officials were more likely to manage other officials than govern people, and prefects were more likely to be transferred from the central government than promoted from lower levels of local government. The increased power of Governor-Generals and the prevalence of temporary appointments for prefects may have been responses to these drawbacks, but the imbalance of the distribution of power was also a challenge for the state.


胡恆(Hu Heng), 陳必佳(Bijia Chen) and 康文林(Cameron D. Campbell. 2020. 清代知府選任的空間與量化分析——以政區分等、《縉紳錄》數據庫為中心 (The Appointment of Prefects during the Qing —- A Spatial and Quantitative Analysis Focusing on the System of Administrative Division and Using the CGED-Q). 新亞學報(New Asia Journal).37(August):339-398. http://dx.doi.org/10.6743%2fNAJ.202008_37.0009

English language paper introducing the CGED-Q published in the Journal of Chinese History

Our paper providing an introduction in English to the China Government Employee Dataset-Qing (CGED-Q) is now available at the Journal of Chinese History. The paper is lead-authored by Bijia Chen and is based on the second chapter of her PhD dissertation, which she defended in 2019. The paper will appear in the July 2020 issue.

Here is the abstract:

We introduce the China Government Employee Database—Qing (CGED-Q), a new resource for the quantitative study of Qing officialdom. The CGED-Q details the backgrounds, characteristics and careers of Qing officials who served between 1760 and 1912, with nearly complete coverage of officials serving after 1830. We draw information on careers from the Roster of Government Personnel (jinshenlu), which in each quarterly edition listed approximately 12,500 regular civil offices and their holders in the central government and the provinces. Information about backgrounds and characteristics comes from such linked sources as lists of exam degree holders. In some years, information on military officials is also available. As of February 2020, the CGED-Q comprises 3,817,219 records, of which 3,354,897 are civil offices and the remainder are military. In this article we review the progress and prospects of the project, introduce the sources, transcription procedures, and constructed variables, and provide examples of results to showcase its potential.

Bijia Chen is now a postdoc at  the Renmin University Institute of Qing History.

For more information about the CGED-Q, please see the CGED-Q project page.

Errata

Page 2 – Footnote 1 – line 10 – Zhenan should be Zhinan

Page 3- second line in paragraph after heading ‘Origin, current status, and future plans…’, ‘ongoing of study’ should be ‘ongoing study’

Page 3 – Footnote 6 – line 2 – Lishi Yanjiu should be Qingshi Yanjiu

Page 8 – Footnote 22 – line 1 – Jizhi should be Jiazhi

Page 8 – Footnote 26 – line 1 – Jijie should be Ji

 

Bijia Chen publishes comment on jinshenlu 縉紳錄 as a source

At the end of 2019, Bijia Chen published an extensive note in the Qing History Journal (清史研究) on the importance of the jinshenlu 縉紳錄 as a source of information on the Qing Civil Service, providing clarification and explanation in response to some possibly misleading points made in a 2018 清史研究 article. The full reference for and link to Bijia’s article are below.

陈必佳 (Bijia Chen). 2019. 再论《缙绅录》记载的准确性及其史料价值 (Re-visiting the Accuracy and the Robustness of the Jinshenlu as an Historical Source), 清史研究  (The Qing History Journal), 2019 (4) 129-133.
http://kns.cnki.net/kcms/detail/detail.aspx?filename=QSYJ201904013&dbcode=CJFQ&dbname=CJFDTEMP&v=

 

Lee-Campbell Group celebrates Xiao Xing’s retirement and contributions

 

James Lee and Xiao Xing

On December 13, 2019, the Lee-Campbell Group held a dinner in Beijing in honor of Xiao Xing, who retired in 2018 after working with us for 20 years.

Xiao Xing was the first coder we engaged in mainland China in 1998 after we decided to move our data entry there. She helped enter material for many of our databases, including but not limited to the CMGPD-LN, CMGPD-SC and more recently the CGED-Q. She also helped with the training of new coders. Her feedback also played a role in the specification of protocols for data entry.

James Lee, Cameron Campbell, Bijia Chen and our coders in Beijing.

It has been a tremendous pleasure to work with Xiao Xing for two decades. We are grateful for all of her contributions and wish her the best in her retirement.

 

CGED-Q 1900-1912 Jinshenlu public release workshop held at Central China Normal University

Participants at the workshopWe held a workshop on July 20-22 at Central China Normal University to introduce the China Government Employee Database-Qing (CGED-Q) Jinshenlu 1900-1912 public release. The workshop was co-organized by the Renmin University Institute of Qing History, the Hong Kong University of Science and Technology Division of Social Science, and Central China Normal University, and the local organizer was the Central China Normal University School of History and Culture. Faculty and students from HKUST, Renmin University, Central China Normal University and other institutions made presentations introducing the public release and other major databases, providing examples of applications, and explaining how to load the data into major statistical packages. The participants included 34 postgraduate students from a variety of institutions in the mainland and elsewhere, a number of guests from Central China Normal University and other institutions in Wuhan. The program is below.

时间 内容 主讲人
7月19日 14:00-18:30 报到
7月20日 9:00 开幕式
9:30 合影
9:45  《中国历史官员量化数据库――清代》(以下简称CGED-Q)项目的历史、现状和未来 康文林,任玉雪
10:15 介绍人民大学清史研究所数字清史实验室(清史数据共享平台) 胡恒
10:45 休息15分钟
11:00 华中师大的大数据历史研究的源起 马敏、付海晏
11:30 李中清—康文林团队其他相关科研项目介绍 李中清、任韵竹
12:30 午餐
14:00 CGED-Q项目介绍第一节

源起及数据库内容

陈必佳、康文林、任玉雪
15:00 CGED-Q项目介绍第二节

数据库的优势与不足

陈必佳、康文林、任玉雪
休息15分钟
16:15 清代《缙绅录》的内容来源与出版过程 阚红柳
16:45 讨论  
17:15 结束
7月21日 8:45 如何应用STATA对CGED-Q进行量化分析 陈必佳
9:45 应用Python分析CGED-Q中文官仕途的可能性和文官群体仕途的共性 王彦邦、陈煦萌
10:45 休息15分钟
11:00 应用RGIS分析CGED-Q中以县级行政区划为单位的文官系统规律及变化 张梦迪
12:00 指导使用R, STATA和Python分析数据和相关问题答疑  
12:30 午餐
以CGED-Q为核心的相关研究
14:00 CGED-Q的记录连接和其他相关议题:
以家庭背景和文官仕途之关系为例
康文林
15:00 文官系统中有科名的官员及旗人官员 陈必佳
  休息15分钟  
15:45 清朝的回避制度 任玉雪
16:15 冲繁疲难和地方官员的任职 胡恒
16:45 讨论  
17:30 结束
7月22日 9:00

 

练习:
学员将被分成小组,运用R, Python或STATA进行简单的分析
陈必佳、康文林、张梦迪、陈煦萌、王彦邦
10:00 休息15分钟
10:15 分享和讨论
学员陈述并讨论数据分析的初步结果及展开其他问题研究的想法
 
12:15 闭幕式
12:30 结束

Presenters

马  敏      华中师范大学

彭南生      华中师范大学

李中清      香港科技大学

康文林      香港科技大学

付海晏      华中师范大学

胡  恒      中国人民大学清史研究所

阚红柳      中国人民大学清史研究所

胡  迪      南京师范大学

任玉雪      上海交通大学

陈必佳      香港科技大学

任韵竹      香港科技大学

陈煦萌      香港科技大学

张梦迪      香港科技大学

王彦邦      香港科技大学

吴艺贝      上海交通大学

杨  莉      上海交通大学

Updated version of CGED-Q 1900-1912 Jinshenlu Public Release available for download

We prepared a new version of the CGED-Q 1900-1912 Jinshenlu Public Release that removes leading and trailing blank spaces from all fields. The blank spaces were introduced during the data entry process and are unnecessary. Users previously had to remove them with the trim command in STATA or the equivalent in R or whatever other package they were using.

We have also prepared a version of the release where all the column headings/variables names are in pinyin rather than Chinese characters. We learned that R and possibly some other packages have trouble with Unicode variable names.

The files are available at the usual download sites.

HKUST: https://dataspace.ust.hk/bib/E9GKRS

Renmin University: http://39.96.59.69/DownloadFile/DLFile

China Government Employee Database – Qing (CGED-Q) 1900-1912 Jinshenlu records available for download

We have made available a ‘beta’ version of the China Government Employee Database – Qing (CGED-Q) 1900-1912 Jinshenlu public release that includes data and documentation. The release consists of 638,152 records of 50,049 officials (based on our linkage) recorded in 43 quarterly editions. For more details, including links for downloading the data, please visit our CGED-Q Project Page.

The final, formal release will be in October. Until then, we will be updating data and documentation as problems are identified.

2019 Summer Workshop Introducing the 1900-1912 Jinshenlu Public Release

The Lee-Campbell group at HKUST in cooperation with the Institute of Qing History at Renmin University and the Institute of History and Culture at Central China Normal University is organizing a workshop to introduce the first public release from our China Government Employee Database-Qing (CGED-Q) database.

Civil officials according to whether they are Qiren or civilian, and serving in the capital or outside the capital, between 1900 and 1912. Constructed with the CGED-Q.

The initial release will consist of roughly 600,000 records of 60,000 civil officials who were recorded in the quarterly editions of the jinshenlu (缙绅录) between 1900 and 1912. Along with accompanying documentation, it will be available for download in May 2019 at sites at Renmin University and HKUST. In the coming years, the Lee-Campbell group plans to release all of the data, which at present consists of approximately 3.2 million records.

For additional information about the workshop, please see the announcement at the Renmin University Institute for Qing History website.

For an introduction to the CGED-Q, please see this project page at the Lee-Campbell Group website.

Construction and public release of the CGED-Q database has been supported by RGC GRF 16601718 and 16400114.

 

Paper on Banner officials in the Qing civil service 1900-1912 published in 清史研究

Our student Bijia Chen’s lead-authored paper on Banner officials in the Qing civil service between 1900 and 1912 recently appeared in 清史研究 (Studies in Qing History). The paper is titled 清末新政前后旗人与宗室官员的官职变化初探——以《缙绅录》数据库为材料的分析 (The Transition of Banner and Imperial Lineage Officials During the Late Qing Reform Period: Evidence from the Qing Jinshenlu Database) and examines how officials who were Bannermen were affected by the reforms and other changes in the New Government period (新政时期). The paper is available for download here:

http://qsyj.iqh.net.cn/CN/abstract/abstract2384.shtml

The paper makes use of the China Government Employee Database-Qing (CGED-Q) which we are constructing from the 缙绅录 and related materials. More detail about this project is available here.

New Article on Changes in the Social and Geographic Origins of China’s Educated Elites (1865-2014) Published in 《社会学研究》

Lee-Campbell group members Chen Liang, Hao Dong, Yunzhu Ren and James Lee published an article 江山代有才人出——中国教育精英的来源与转变 (Social Transformation and Elite Education: Changes in the Social and Geographic Origins of China’s Educated Elites 1865-2014) in the May 2017 issue of 《社会学研究》 (the Chinese-language journal Sociological Studies). Using data from the China Government Employee Database-Qing (CGED-Q) and the China University Student Dataset – Republic of China and Peoples Republic of China (CUSD-ROC and CUSD-PRC) they contrast the profound changes in social and geographic origins of China’s educated elite in four distinct periods: 1865-1905, 1906-1952, 1953-2003, and 2004-2014. They conclude that these fundamental transformations reflect the ability of the Chinese system of educational testing to legitimate new elites in different eras with different recruitment criteria, rather than merely to reproduce the intergenerational transmission of existing elites, as is the case of elite education in many other parts of the world.

The English and Chinese language abstract as well as a PDF of the paper (in Chinese) are available for download here:

http://www.shxyj.org/Magazine/Show?id=18161