China Government Employee Database – Qing (CGED-Q) 中国历史官员量化数据库(清代)

This project will offer a new perspective on the Qing bureaucracy and Qing political elites by allowing us to examine the state in its entirety using longitudinal individual-level data that covers nearly all civil offices and their holders. At the micro-level, we examine how geographic origin, mode of appointment, family background, and other characteristics of government employees during the Qing (1644-1911) dynasty influenced individual career trajectories. For mode of appointment, we distinguish officials according to whether they entered service by examination qualification, office purchase, or by virtue of hereditary affiliation with the Eight Banner system. By linkage to other sources, we also examine the role of family background and exam performance. At the macro-level we examine changes over time in the composition of the bureaucracy and of specific ministries and agencies. We assess the implications of key developments during the Qing for the  structure and composition of the state.

This study is distinctive in that previous studies of officials and other government employees have mainly been case studies of specific individuals or government offices. Larger scale studies have focused on examination qualification holders, and assumed that they represented the political elite. Studies of the bureaucracy, or specific ministries, have generally been institutional histories. To our knowledge, this is one of the first longitudinal studies of any national bureaucracy, contemporary or modern, in its entirety, using micro-data on the careers and family and geographic origins of nearly all officials.

Starting in spring 2019, we began making the data public in stages. See below for details.



To carry out this study, we are constructing a database of government employees during the Qing, the China Government Employee Database – Qing (CGED-Q). Our core information come from the jinshenlu (缙绅录), a publication that appeared every three months and listed almost every civil office including information about the holder’s name, place of origin, ethnicity, location of post, job title, and other details. positions ranged from high offices in the Six Ministries (六部) and other central government units down to low-level offices in county administrations. Nominative linkage of the records of the same official in different editions has proven straightforward, allowing us to construct and study career histories. Each edition lists 13,000-15,000 employees. We are also entering lists of military officials from zhongshubeilan (中樞備覧). These editions typically record 7000-8000 military officials each.

Available records by season, 1750-1912. Restricted to offices and positions that only appear in official editions.

The data we have entered so far spans the period between 1750 and 1912 and is most complete for the period 1850 to 1912. The figure to the left summarizes the record counts for civil offices between 1750 and 1912. As of May 2019 we have entered 3,373,995 records for approximately 340,373 civil and military positions. 2,979,413 records are civil positions and 394,582 are military positions. These records are drawn from 211 jinshenlu editions and 50 zhongshubeilan editions.

We have also created a searchable database of most of the jinshenlu personnel records that we have already entered.  Right now it allows search by surname and given name in traditional characters. We hope that this is useful for anyone who may want to look up an ancestor’s personnel records, or for researchers who are interested in looking up the records of a specific officials. Here are more details about the search facility. Siwei Fu, a PhD student in Computer Science at HKUST, created the search site and has been updating it when we have provided new data. The site is kindly hosted on a server at Professor Huamin Qu’s VisGroup.

We published our first descriptive results in an article in Qingshi yanjiu (清史研究) in 2016. Please look at the abstract or download the full text, in Chinese. According to these initial results, a large share of the highest officials were actually from the Eight Banners, not holders of examination qualifications. The hereditary status of Eight Banner officials allowed them to enter service through channels other than the well-known examination system. Meanwhile, of the holders of the highest examination qualification, jinshi (進士), only a small fraction actually held high office. The vast majority of employed jinshi held much more mundane positions in the government.  Many surprisingly do not appear to have been been employed at all. Chen Bijia lead-authored a paper on Bannermen serving in Beijing between 1900-1912 which appeared in Qingshi yanjiu (清史研究) in 2018.

For additional information about the family origins and other characteristics of officials, we are constructing and linking databases from such other sources as timinglu (题名录), zhujuan (朱卷), tongnian chilu (同年齒錄) and other sources with the jinshenlu data. These sources provide names of ancestors, kin, teachers, and classmates. For ancestors, they provide examination qualifications. By linkage, we can trace whether ancestors were government employees. Some of these materials were available through the China Biographical Database Project, with whom we are cooperating. Huang Yifei, a Caltech PhD graduate, has kindly shared a large volume of 同年齿录 and 乡试录 that he had collected for his dissertation. We have also exchanged data with Professor Liu Cheng-yun and his group  at the Institute of History and Philology at the Academia Sinica.

Project History

The project was initially conceived in summer 2013, when Yuxue Ren at Shanghai Jiaotong University showed Cameron Campbell and James Lee work she was doing with jinshenlu 缙绅录 records of government employees in northeast China. Campbell, with assistance from Lee and Ren, then obtained funding from the Hong Kong Research Grants Council for the 2014-2017 period to enter the 2.8 million 缙绅录 records reprinted by Tsinghua as the 清代縉紳錄集成 in order to study the Qing bureaucracy in its entirety. Bijia Chen, HKUST PhD student in Social Science, joined the project in 2015 with support from the Hong Kong PhD Funding Scheme. In addition to using the data for her dissertation on the careers of Qing officials 1850-1912, Bijia has played a key role in the coordination of the data entry and also has been updating the documentation of the data for public release. Lawrence Zhang, joined HKUST fall 2016 as an assistant professor in history and is working with the Lee-Campbell Group to compare data from lists of office purchasers he has collected from libraries in China including Taiwan to their data in the 缙绅录 and elsewhere.

Data entry has been carried out since 2014 by a team of full-time coders, including Ge Xiaodong, Ji Yang, Ren Yubai,  Liu Beiyi, and Zhao Mi. Two coders who started with us have retired: Sun Huicheng and Xiao Xing. We are very grateful to all of them for their commitment and perseverance.

We are also collaborating with the Institute for Qing History at Renmin University to release the CGED-Q publicly in phases, beginning in 2019 with the data from the New Administration 新政时期 period 1900-1912. The links for downloading these data are below. We have initiated a number of collaborative papers with various scholars coordinated partly with these data releases as well as with other funded projects.

We estimate that in addition to the 2.8 million jinshenlu 缙绅录 records reprinted by the Tsinghua University Library as the 清代縉紳錄集 成 that we have already entered, there are an almost equal number of other records scattered in a variety of libraries. We have identified editions that should contain some 1.5 million records in holdings in the Columbia University Library, the Harvard Yenching Library, the Palace Museum Library in Beijing and other locations. We are very thankful to Columbia University, Harvard Yenching Library and the Library of Congress for making editions available online or by other means of access.


HK RGC GRF 16400114. Spatial, Temporal, and Social Network Influences on Officials’ Careers during the Qing: Creation and Analysis of a National Database from the Jin Shen Lu. 2014-2017 (Cameron Campbell PI).

HK RGC GRF 16601718. Family Background Influences on the Appointment and Career Mobility of Qing Officials With Examination Degrees. $1,105,600 HKD in Direct Costs. (Cameron Campbell PI). 2018-2021.

Research Output

As with our other projects we will incorporate the results of our CGED-Q related research in our on-line course Understanding China, 1700-2000: A Data Analytic Approach, in this case as Part Four – Who Gets Authority.


任玉雪 (Yuxue REN), 陈必佳 (Bijia CHEN), 郝小雯 (Xiaowen Hao), 康文林 (Cameron Campbell), 李中清 (James Z. Lee). 2016. “清代缙绅录量化数据库与官僚群体研究  清史研究 (The Qing Jinshenlu Database: A New Source for the Study of Qing Officials)”  清史研究  (Qing History Journal). 2016年11月第四期:61-77.

陈必佳 (Bijia CHEN),康文林 (Cameron Campbell), 李中清 (James Z. Lee). 2018. 清末新政前后旗人与宗室官员的官职变化初探——以《缙绅录》数据库为材料的分析(The Transition of Banner and Imperial Lineage Officials During the Late Qing Reform Period: Evidence from the Qing Jinshenlu Database). 清史研究 (Qing History Journal) (4):10-20.

Publicly Released Data

CGED-Q: 1900-1912 JINSHENLU Public Release

The following links are for download of our 2019 public release of our  jinshenlu (缙绅录) records of civil officials in the Qing for the period 1900-1912 and accompanying documentation. The release consists of 638,152 records of 50,049 officials (based on our linkage) recorded in 43 quarterly editions.

The data in the release are as much as possible a direct transcription of the contents of the original sources. For this release, we have not attempted to ‘correct’ any mistakes or inconsistencies that were apparent in the original data since doing so would require us to introduce our assumptions. Along these lines, the release data have not been processed to reconcile differences in orthography for the same character, link individuals, and so forth. In our own analysis, we use data that we have processed extensively to resolve inconsistencies, correct problems, and link individuals across time, and in 2020 we anticipate releasing some of our constructed or transformed variables.

Please make sure to download and read carefully the README (声明) files as well as the User Guide (用户指南) along with the data. It is urgent that users understand the requirements re acknowledging the funding source that supported the creation of the database and its public release and citation of the User Guide and relevant publications. It is also urgent that users understand the known limitations and caveats regarding the data that are described in the User Guide.

This is a preliminary release. The final version will be released in October 2019. We expect the documentation and possibly the data to change as mistakes or other problems come to light, so please check back on a regular basis for updates until the final version is released in October 2019.

The data will also be available at a platform maintained by the Institute of Qing History at Renmin University. As soon as a link is available, we will post it here.

We will have a workshop introducing the public release July 19-22 at Central China Normal University in Wuhan.

16 May 2019 release Download at HKUST
README / 声明 (English/Chinese) Download
User Guide 用户指南 (in Chinese) Download
Data (tab-delimited text .zip file) Download (via Dropbox)*
Data (.xlsx .zip file) Download (via Dropbox)*

*Dropbox download may not work in some locations.


All files are also available for download at the Renmin University Institute of Qing History Digital Qing History Laboratory Qing Historical Data Sharing Platform.

Please send inquiries to

Academic Presentations

Examination Qualifications and Civil Service Employment during the Qing (1644-1911): New Evidence From Big Data. 2017 清代《缙绅录》研究工作坊 (2017 Qing dynasty Jinshenlu Research Workshop). Humanities and Social Science Research Center, Geographic Information Science Research Center, Population History Programme, Academia Sinica, Taipei, August 17-18, 2017.

Examination Qualifications and Civil Service Employment during the Qing (1644-1911): New Evidence From Big Data, Longitudinal Studies Centre – Scotland (LSCS) Research Group Seminar, Edinburgh, Scotland, 10 July 2017.

Examination Qualifications and Civil Service Employment during the Qing (1644-1911): New Evidence From Big Data, Paris School of Economics, Paris, France, June 21, 2017.

清代官员仕途:基于缙绅录数据库分析的新认识  (Careers of Qing Dynasty Officials: New Findings from the Analysis of the Jinshenlu Database), 华中师范大学人文社会科学高等研究”开放与交叉”主题学术讲座(第三十六期) 大数据与中国历史研究第10讲 (China China Normal University Institute for Advanced Studies in Humanities and Social Science “Openness and Intersection” Theme Academic Lecture, 36th Term, Big Data and Historical Research Lecture #10), Wuhan, Hubei, February 27, 2017.

“试析清代进士的入仕与官职——清代缙绅录量化数据库与进士题名录的匹配尝试(Analyzing Official Careers of Jinshi during the Qing–Evidence from Linkage between the Qing JSL Dataset and Timinglu Dataset),”第十四届科举制与科举学国际学术研讨会(14th International Academic Meeting on Keju system and Keju studies), Imperial Examination Museum, Nanjing, Jiangsu, China, December 19-20, 2016.

“Official Careers During the Qing(1644-1911): Evidence from the Jinshenlu.” At the panel “Chinese State Culture and Bureaucracy”, Social Science History Association (SSHA) meetings, Chicago, November 17-20,2016.

“Official Careers During the Qing (1644-1911): Evidence from the Jinshenlu.” At the session “Elites,” International Sociological Association Research Council on Social Stratification (RC-28) meetings, Bern, Switzerland, August 29-31, 2016.

“清代縉紳錄資料庫及相關研究,” 兩岸三地學術研討會, Nanjing, Jiangsu, June 28-29, 2016.

“清代缙绅录数据库及相关研究(Qing Jinshenlu database and related research),”数字人文与清史研究工作坊(Workshop on Digital Humanities and Qing History Study),Renmin University of China, Beijing, China, May 28-29, 2016.

“Civil Service Careers during the Qing Dynasty (1644-1911): Preliminary results from the 缙绅录 database.” 数字人文新动向——中国历代传记资料库, Digging into Data 工作坊 (New Directions in Digital Humanities: Chinese Historical Database – Digging into Data Workshop). Tsinghua University, Beijing, China, January 8-10, 2016.

“清代缙绅录数据库及相关研究 (Qing dynasty Jinshenlu database and related research),” 传承与开启—大数据时代下的历史研究 (Tradition and Change: Historical Research in the Era of Big Data). Shanghai University, December 4-6, 2015.

“清代官員的仕途:基於縉紳錄的初步分析 (Bureaucratic Careers During the Qing (1644-1911) Dynasty: Preliminary Results from the Jinshenlu)”, 2015東亞歷史人口研究資料庫工作坊 (2015 Workshop on East Asian Historical Demography Databases, Program on Historical Demography), Research Center for Humanities and Social Sciences, Academia Sinica, Taipei, Taiwan, November 20, 2015.

“科举与官员仕途:基于清缙绅录的初步分析 (Examinations and Official Careers: Preliminary Results from Analysis of the Jinshenlu),” 第十二届科举制与科举学国际学术研讨会 (12th International Academic Meeting on Keju system and Keju studies), Xiamen University, Xiamen, Fujian, China, November 23-25, 2015.

“Civil Service Careers during the Qing Dynasty (1644-1911): Preliminary results from the 缙绅录 database,” UCLA California Center for Population Research, May 27, 2015

“The Scholarship of Discovery and Big Historical Data on China,” at the Session 50 Years of Qing Studies: A Conversation with Past and Current Editors of “Late Imperial China,” Annual Meeting of the Association of Asian Studies, Chicago, 27 March, 2015.