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

Participants at the July 2019 workshop at Central China Normal University to introduce the CGED-Q Jinshenlu Public Release

We 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项目介绍第二节


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 午餐
14:00 CGED-Q的记录连接和其他相关议题:
15:00 文官系统中有科名的官员及旗人官员 陈必佳
15:45 清朝的回避制度 任玉雪
16:15 冲繁疲难和地方官员的任职 胡恒
16:45 讨论  
17:30 结束
7月22日 9:00


学员将被分成小组,运用R, Python或STATA进行简单的分析
10:00 休息15分钟
10:15 分享和讨论
12:15 闭幕式
12:30 结束


马  敏      华中师范大学

彭南生      华中师范大学

李中清      香港科技大学

康文林      香港科技大学

付海晏      华中师范大学

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

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

胡  迪      南京师范大学

任玉雪      上海交通大学

陈必佳      香港科技大学

任韵竹      香港科技大学

陈煦萌      香港科技大学

张梦迪      香港科技大学

王彦邦      香港科技大学

吴艺贝      上海交通大学

杨  莉      上海交通大学

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.


Renmin University:

Emma Zang wins American Sociological Association Section on Asia/Asian-America “Best Graduate Student Paper” award

Emma Zang, HKUST Social Science MPhil and Duke PhD graduate, was awarded “Best Graduate Student Paper” by the American Sociological Association Section on Asia/Asian-America for our Demography paper “Males’ Later-Life Mortality Consequences of Co-residence With Paternal Grandparents: Evidence From Northeast China, 1789-1909” which she lead-authored. The paper used the CMGPD to study how co-residence with paternal grandparents in childhood affected mortality in later life.  The award will be presented in August 2019 at the business meeting of the Asia/Asian-America  section at the American Sociological Association.

Emma will also be taking a tenure-track position as an Assistant Professor in Sociology at Yale in July 2019.

Congratulations to Emma!

Zang, Emma., Cameron Campbell 2018. Males’ Later-Life Mortality Consequences of Coresidence With Paternal Grandparents: Evidence From Northeast China, 1789-1909. Demography. 55(2):435-57. PDF.

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.

China Government Employee Database-Qing (CGED-Q) 2019 Summer Workshop

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-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:

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.


Paper on interethnic marriage during the Qing designated “Editor’s Choice” by the journal Demographic Research

The paper “Interethnic marriage in Northeast China, 1866-1913” that I co-authored with Lee-Campbell group PhD student Bijia Chen (lead) and Lee-Campbell group PhD graduate Dong Hao (now an Assistant Professor at Peking University) that was published this year in Demographic Research has been named Editor’s Choice by the journal’s editorial board as one of the best papers published in volume 38. The paper examines patterns of intermarriage between Han and Manchu in a frontier population in northeast China from the mid-19th century to the beginning of the 20th century. It finds that intermarriage between the two groups was not uncommon and also increased over time. The chances of intermarriage depended on village and family context as well as individual socioeconomic and demographic characteristics. The article is available Open Access here:

The complete list of papers selected as Editor’s Choice:

Lee-Campbell Group at the Social Science History Association meetings in Phoenix, November 8-11, 2018

Nine members of the Lee-Campbell group will be presenting a total of 10 papers in 9 different sessions at the Social Science History Association meetings in Phoenix, November 8-11, 2018. There will be papers from all of our projects, including Qing civil service careers, Republican higher education and employment, family and social change in mid-20th century China, and historical demography. Three members will be chairing or serving as discussant at sessions.

For a complete schedule, please see this entry at the Lee-Campbell Group web page.


Ethnic intermarriage in northeast China during the late Qing

Current student Bijia Chen, former student Hao Dong and I recently published a paper in Demographic Research on ethnic intermarriage in Shuangcheng, Heilongjiang, during the late Qing:

This paper grew out of Bijia’s MPhil thesis. It uses registered ethnicity of males and inferred ethnicity of wives to examine marriage between Han, Manchu, and others within the Banner populations in Shuangcheng in the late 19th century. Wife’s ethnicity was inferred from her surname. The population is a useful one to study because the Han, Manchu and others who composed it were all part of the Banners, and marriages between them were not subject to rules that forbade or discouraged marriage between Banners and non-Banners. In other words, it is an opportunity to study boundaries between Manchu and Han in a setting where they were not subject to regulations on Banner/non-Banner marriage that would have had the side effect of making Manchu/Han marriage difficult in most other parts of China.

The analysis uses the CMGPD Shuangcheng database, which is available for download from ICPSR:


Demographic Estimate of the Population of the Eight Banners

I just noticed that the final version of the manuscript of my paper with James Lee and Mark Elliott entitled “Demographic estimate of the population of the Eight Banners” is available for download at the Harvard institutional repository.

Here is the full citation:

Elliott, Mark C., Cameron Campbell, and James Lee. 2016. A Demographic Estimate of the Population of the Qing Banners. Études chinoises. XXXV-1: 9-40.

Hopefully this paper will be useful and interesting to anyone working on Qing history.