CGED-Q Research Seminar and Training Workshop at Central China Normal University, July 28-August 3, 2024

In conjunction with the next public release of data from the CGED-Q JSL, there will be a research conference and training workshop at Central China Normal University July 28-August 3 in conjunction with the next public release of data from the China Government Employee Dataset-Qing (CGED_Q) Jinshenlu. The conference will be July 29 and July 30. Papers that make use of Jinshenlu and related sources are welcome. The training workshop will be July 31-August 2.

Here is the announcement of the research conference in Chinese:

https://mp.weixin.qq.com/s/_4A0DO6hglCS2iHW2xscQA

Here is the announcement for the training workshop in Chinese:

https://mp.weixin.qq.com/s/XTGWh6r0dWxYUmJAEUtZWA

New paper on the organizational demography of Qing officialdom in 社會科學研究

A paper by Cameron Campbell and Shuaiqi GAO on the organizational demography of Qing officialdom has been published in 社會科學研究. You can read it in its entirety in a post at the journal’s official account. You can download the PDF at the entry for the paper at the journal’s website. The English version is available at Soc ArXiv.

The article was one of seven journal articles selected for inclusion in the History (历史) category in April 2024《中国社会科学文摘》(China Social Science Digest). https://mp.weixin.qq.com/s/WYe_MogUK_DA2EfPHe2FqA

Abstract

中国历史官员量化数据库——(清)缙绅录(CGED?Q JSL)中文官的纵向关联记录揭示了19世纪清代文官整体的职业动态。定量分析的结果表明,清代官僚系统的总体情况就像一个当代的大型组织,文官离职率在任职的第一年内很高,然后下降,之后趋于稳定。19世纪下半叶,官员的离职率整体下降,但于清末十年中上升。官员离职率下降导致拥有功名的候缺待补官员群体谋求仕途和进一步晋升的机会不断减少。同时,异途官员的人数不断增加,加剧了官场竞争。不同类别、品级官员的职业动态在不同历史时期的变化趋势差异较大,尤其是高品级官员的离职率对清代后期的官场平衡具有深刻影响。清代文官的职业动态一方面揭示了清代文官组织人口学的基本特征,另一方面也为解释清代特定官员群体或特定时期的官员个案研究提供了重要参考。

We study the organizational demography of the Qing civil service from 1830 to 1911. Before the 20th century, the Qing bureaucracy was one of the largest non-military organizations in the world in terms of numbers of regular employees. At any given time, approximately 13,000 officials held formal appointments. We present the basic features of its organizational demography using data on nearly all civil officials with formal appointments from 1830 to 1912. We make use of longitudinally linked records of officials in the China Government Employee Database – Jinshenlu (CGED-Q JSL) to reconstruct rates of exit from service, the career lengths of officials, and the number of years since first appointment for currently serving officials. While previous studies of the Qing have examined turnover in specific types of posts, they have not considered the dynamics of complete careers. We find that exit rates in the first year of service were high and then low and stable afterward. While most officials only served for a short time, currently serving officials were relatively experienced. We also show that rates of exit from service declined for much of the last half of the 19th century, and then increased in the first decade of the 20th century. Declining turnover in the last half of the 19th century would have reduced opportunities for degree holders seeking posts and for officials seeking promotion at a time when the number of holders of purchased degrees competing for posts was increasing. We also compare different categories of officials. The results not only illuminate basic features of the organizational demography of Qing officialdom, but also provide a baseline for interpreting results from case studies of specific groups of officials or specific time periods.

Here is the full reference:

康文林 (Cameron Campbell) and 高帅奇(Gao Shuaiqi). 2024. 清代文官的组织人口学研究, 1830-1911 (The Organizational Demography of the Qing Civil Service, 1830-1911). 社会科学研究 (Social Science Research). 1:157-169.

Workshop on Chinese Historical Databases: Sources, Methods, Prospects held at HKUST, January 11-12, 2024

Participants at the workshop Chiense Historical DatabasesL Sources, Methods, Prospects held at HKUST on January 11 and 12, 2024

Cameron Campbell organized a meeting on Chinese Historical Databases: Sources, Methods, Prospects on January 11 and 12, 2024 at the Hong Kong University of Science and Technology.

The meeting is one in a series of activities intended to promote the development of research infrastructure for studying China’s past organized under the auspices of and with support from the RGC Areas of Excellence Project Quantitative History of China (Chen Zhiwu PI). Staff from the HKUST School of Humanities and Social Sciences, including Lee-Campbell Group RA Shengbin Wei, provided logistical support.

The meeting brought together historians and social scientists constructing databases suited for the quantitative analysis of Chinese history. Participants from Hong Kong, mainland China, and Europe introduced their databases. These included projects that were already complete, others were in progress, and some were in the planning stages. Presentations and discussion focused not only on the content of the databases and prospects for analysis, but nuts and bolts issues related to the construction, preservation, documentation and dissemination of the databases. Several presentations covered techniques being used to automate the creation of databases, including OCR, tokenization, entity recognition, and record linkage.

Lee-Campbell Group members including Cameron Campbell, Dong Hao, Gao Shuaqi, Chen Jun, Wu Yibei, James Lee, Hou Yueran and Matt Noellert made presentations introducing their databases.

In addition to the presenters, other faculty and students attended as observers.

The meeting concluded with the development of plans for training workshops for historians to help them learn how to construct databases and make use of existing ones.

Christian Henriot has written a more detailed discussion of the Chinese historical databases meeting at the ENEP website.

Opening

Introductory Remarks by Chen Zhiwu, Cameron Campbell

Session 1 – New Approaches

Chair: Cameron Campbell

Lin Zhan
Content and Value of the Chinese Genealogy Database

Guenther Lomas
The Process of Building the Chinese Genealogy Database

Chen Yuqi
Geocoding the Past World: Unearthing Coordinates of Early China from Texts Using Large Language Models

Session 2 – Geographic, Economic, and Other Context

Chair: Chen Zhiwu

Hu Heng
清史时空综合数据平台-清史地理信息系统和基于地方志的清代职官信息集成数据库

Ma Debin
Quantifying Living Standards, an Overview

Ziang Liu
Early Modern Wages: Data and Limits

Gao Shuaiqi
清代危机(灾害)量化数据的应用与局限

Session 3  – Late Imperial China I

Chair: James Lee

Ma Min
基于近代传教士档案的人物数据库设想

Dong Hao
East Asian Population Databases

Christian Henriot
Modern China Historical Database: Current Status and Future Prospects

Session 4 – Late Imperial China II

Chair: Debin Ma

Cameron Campbell
CGED-Q: Current Status and Future Plans

Chen Jun
CGED-Q ZSBL: Military Officials

Fu Haiyan
近代中国寺庙登记表数据库及初步的研究

Session 5 – ROC

Chair: Dong Hao

Yibei Wu
Late Qing and Beiyang Student Records, and Beiyang and ROC Officials

Hou Yueran
Construction of Occupational Database of Tsinghua Students Studying in America with Boxer Indemnity Fund (1909-1944)

Lik Hang Tsui
Ink Trails: Correspondence and Connections in a Dataset of Epistolary Manuscripts from Song China

Session 6 – ROC and PRC

Chair: Christian Henriot

Matthew Noellert
Lee-Campbell Group Post-1949 Rural Datasets

James Lee
Lee-Campbell Group PRC and ROC Educational, Academic, and Professional Datasets

Chen Ting
Post-1949 County Gazetteers

Pierre Landry
China’s provincial CCP élite since 1921

Future Directions

Panel with remarks by Cameron Campbell, Zhiwu Chen, Christian Henriot, and James Z. Lee

Participant Roster

CampbellCameron康文林
ChenJun陈俊
ChenTing陈婷
ChenYuqi陈钰琪
ChenZhiwu陈志武
DongHao董浩
FuHaiyan付海晏
GaoShuaiqi高帅奇
HenriotChristian安克强
HouYueran侯玥然
HuHeng胡恒
HuCunlu胡存璐
KanHongliu阚红柳
LandryPierre李磊
LeeJames李中清
LinZhan林展
LiuZiang刘紫昂
LomasGuenther罗孟德
MaDebin马德斌
MaMin马敏
NoellertMatthew倪志宏
TsuiLik Hang徐力恒
XueQin薛勤
WeiShengbin韦圣彬
YangYang杨阳
YuBruce虞越
ZhangLawrence张乐翔
WuYibei吴艺贝
BethKwok郭靖琦
MilesSteven麦哲维

New publication using process mining to study the careers of Qing officials in the CGED-Q JSL

Adam Burke at the Queensland University of Technology lead-authored a paper “State Snapshot Process Discovery on Career Paths of Qing Dynasty Civil Servants” that introduces a new process mining technique he calls ‘state snapshot process discovery’ and illustrates it by application to our CGED-Q JSL data on the careers of jinshi officials. Cameron Campbell is a co-author. The paper has been accepted for presentation at the 5th International Conference on Process Mining (ICPM2023), in Rome, Italy, in October 2023.

A pre-print of the paper is available at Adam’s website: https://adamburkeware.net/papers/burke_et_al_state_snap_qing_icpm2023.pdf

Here is a figure from the paper that summarizes the empirical reconstruction of the careers of first and second tier (一甲 and 二甲) jinshi in the years after they earned their degree. One of the attractions of the CGED-Q JSL for demonstrating this technique was that there were canonical career pathways specified by regulations for such high-ranked degree holders, thus it was possible to assess whether the empirical results derived from the data were consistent with the canonical career pathways. We hope that extensions of this technique, and possibly other techniques, can be used to explore the trajectories of officials with more mundane qualifications.

For this paper, Cameron Campbell helped Adam and the other collaborators (Sander Leemans and Moe T. Wynn) understand the data that we provided, and advise on adjustments to accommodate undocumented or otherwise unanticipated features of the data in successive iterations, and then assist in the writing of sections related to the data and the historical context, background on the social science studies of careers, the interpretation of the results.

We are happy to collaborate with computer scientists and other researchers developing techniques for understanding careers and trajectories more generally in complex longitudinal data, who need data like the CGED-Q to showcase their approaches.

New 大数据与中国历史 Chinese translation of Cameron Campbell’s and James Lee’s 40 year career retrospective is now available

The 4th edition of the annual 大数据与中国历史 (Big Data and Chinese History), edited by Fu Haiyan at Central China Normal University, is out now from 社会科学文献出版社 (Social Science Documents Publishing House). It includes a Chinese translation of my and James Lee’s career retrospective, summarizing our work over the last four decades constructing and analyzing historical population and other databases for China.

The full text is available here.

Here is a link to the volume’s page at Dangdang in case you want to order:

http://product.dangdang.com/29580832.html

The English language original of our retrospective is available here: https://hlcs.nl/article/view/9303

Here is the complete reference for the Chinese language translation:

康文林 (Cameron Campbell),李中清 (James Lee). 2023. 中国历史量化微观大数据:李中清-康文林团队40 年学术回顾 in 付海晏 Ed. 大数据与中国历史研究. 第4辑. Beijing:社会科学文献出版社 Social Sciences Academic Press (China), 74-114.

English version of forthcoming paper on the organizational demography of the Qing civil service

社會科學研究 (Social Science Research) published by the Sichuan Academy of Social Science has accepted our paper “The Organizational Demography of the Qing Civil Service, 1830-1911” and tentatively scheduled it for publication in 2024. In the meantime, they have given permission for us to share the original English language version:

The Organizational Demography of the Qing Civil Service, 1830-1911

Please cite the Chinese language version if you refer to it:

康文林 (Cameron Campbell) and 高帅奇(Gao Shuaiqi). 2024. 清代文官的组织人口学研究, 1830-1911 (The Organizational Demography of the Qing Civil Service, 1830-1911). 社会科学研究 (Social Science Research). 1:161-173.

The paper is largely descriptive. It uses the CGED-Q JSL to measure the turnover of officials, career lengths, and years since appointment for currently serving officials. It was inspired by the older literature on organizational demography that sought to relate the performance of organizations to aggregate ‘demographic’ features such as their turnover, length of service and so forth. We hope that it will be a useful reference for anyone studying Qing officialdom. Previous studies of the dynamics of Qing official have focused on the lengths of appointments to specific posts, and turnover in those posts, rather than entire careers.

Here is the abstract:

We study the organizational demography of the Qing civil service from 1830 to 1911. Before the 20th century, the Qing bureaucracy was one of the largest non-military organizations in the world in terms of numbers of regular employees. At any given time, approximately 13,000 officials held formal appointments. We present the basic features of its organizational demography using data on nearly all civil officials with formal appointments from 1830 to 1912. We make use of longitudinally linked records of officials in the China Government Employee Database – Jinshenlu (CGED-Q JSL) to reconstruct rates of exit from service, the career lengths of officials, and the number of years since first appointment for currently serving officials. While previous studies of the Qing have examined turnover in specific types of posts, they have not considered the dynamics of complete careers. We find that exit rates in the first year of service were high and then low and stable afterward. While most officials only served for a short time, currently serving officials were relatively experienced. We also show that rates of exit from service declined for much of the last half of the 19th century, and then increased in the first decade of the 20th century. Declining turnover in the last half of the 19th century would have reduced opportunities for degree holders seeking posts and for officials seeking promotion at a time when the number of holders of purchased degrees competing for posts was increasing. We also compare different categories of officials. The results not only illuminate basic features of the organizational demography of Qing officialdom, but also provide a baseline for interpreting results from case studies of specific groups of officials or specific time periods.

Here’s a figure from the paper, presenting time trends in rates of exit from service in the next three months for officials with different amounts of experience:

Tutorial for using R to analyze the CGED-Q JSL Public Releases

Chen Jun, my MA student at Central China Normal University, has shared slides and sample code he produced to help anyone planning to use R to analyze the CGED-Q JSL public releases. The materials are all in Chinese. They introduce how to import the public data into R, create and transform variables, process strings to create variables, and tabulate and graph results. We hope that this will be useful to users of the data.

New paper by others using CMGPD-LN

We were pleased to learn that Yu Bai, Yanjun Li, and Pak Hong Lam had just published a paper “Quantity-quality trade-off in Northeast China during the Qing dynasty” in the Journal of Population Economics using the public release of the CMGPD-LN! We hope their paper along with other recent publications by others using the dataset will inspire others to use it.

Here is a link to their paper: https://link.springer.com/article/10.1007/s00148-022-00933-x

We are eternally grateful for the support from NICHHD that allowed us to prepare the CMGPD-LN for release, and to ICPSR for hosting the dataset.