CGED-Q JSL 1760-1798 Draft Release

We have made available a draft release of the China Government Employee Dataset-Qing (CGED-Q) Jinshenlu (JSL) 1760-1798 data at the HKUST Dataspace:

https://dataspace.hkust.edu.hk/dataset.xhtml?persistentId=doi:10.14711/dataset/E9GKRS

We expect to release a final version later in the year reflected corrections to any problems identified by users.

We are grateful to Xue Qing and Bijia Chen who spotted issues with the data before it was released.

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.

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:

Chinese Translation of Campbell’s and Lee’s Historical Chinese Microdata: 40 Years of Dataset Construction by the Lee-Campbell Research Group

A Chinese translation of Cameron Campbell’s and James Lee’s Historical Life Course Studies paper “Historical Chinese Microdata. 40 Years of Dataset Construction by the Lee-Campbell Research Group” is forthcoming in a volume of Big Data and the Study of Chinese History 大数据与中国历史研究. The title of the translation is 中国历史量化微观大数据李中清康文林团队40年学术回顾. This paper reviews all of our projects since 1979, including construction of datasets and the study of topics in population, family, and social mobility. Pending the appearance of the volume, we are making a PDF of the translation available.

Here is the PDF of the Chinese translation of Historical Chinese Microdata. 40 Years of Dataset Construction by the Lee-Campbell Research Group.

Here is the English language original, in case you missed it.

 

New paper on nominative linkage in the CGED-Q in Historical Life Course Studies

Cameron Campbell and Bijia Chen published a paper “Nominative Linkage of Records of Officials in the China Government Employee Dataset-Qing (CGED-Q)” in Historical Life Course Studies. It shares their experience with nominative linkage in the CGED-Q. It is  intended to be useful to others who are engaged in large-scale, automated nominative linkage (disambiguation) of individuals in historical Chinese-language sources.

While the approach that they arrived at after many iterations may be specific to the CGED-Q and its contents, the summary of the challenges will be of broader interest, and the methods should at least be a roadmap for others with related projects. Major issues the paper documents and then addresses include the use of variant orthographies for the same character in different editions or sources, replacement of characters with ones that look similar but are actually completely different, replacement of characters with homophones, inconsistencies in the writing of the names of counties, and changes in boundaries that led the same county to be associated with different provinces in different sources or editions.

The complete tabulations that are the basis of the tables in the paper are also available. These include the frequencies of surnames and given names in the CGED-Q JSL, and the frequencies of discordance across record of the same individual in the recording of surnames, characters in given names, and place of origin. The tabulations can be downloaded at the HKUST and Harvard Dataspaces:

https://dataspace.hkust.edu.hk/dataset.xhtml?persistentId=doi:10.14711/dataset/M8HQEA

https://dataverse.harvard.edu/dataset.xhtml?persistentId=doi:10.7910/DVN/4OSP8V

Those not specifically interested in linkage may still be interested in the tabulations of surnames and characters in given names.

ERRATA

Footnote 21 on page 245 states that “Huguang湖廣” refers to “Hunan and Guangdong”. Ma Ziyao has written to point out that “In most cases, however, it has been a legacy term for Hubei and Hunan. The “guang” here originally comes from Guangxi during the Yuan but should not be mistaken for the Qing-era Liangguang兩廣 region to the south of Hunan.” We are grateful to Ma Ziyao for bringing this to our attention.

New paper recapping 40 years of ‘big data’ research on population, family and social history by James Lee, Cameron Campbell and collaborators

James Lee and Cameron Campbell in Daoyi in 1987

Cameron Campbell and James Lee just published an article on the contributions of the Lee-Campbell Research Group to a new scholarship of discovery in Chinese population history, family history, and socio-economic history based on our construction and analysis from 1979 to 2020 of large historical datasets from largely archival records.  Our paper first introduces these datasets, then describes our joint research, and concludes with a summary of our major analytic results. This publication is an invited contribution to a special issue of Historical Life Course Studies which introduces the major historical population databases. Papers on the Quebec BALSAC project and the Historical Sample of the Netherlands are already posted.

Here is the web page:

https://doi.org/10.51964/hlcs9303

This both a career retrospective and a comprehensive summary of everything that James, Cameron and the Lee-Campbell Group have done together over more than four decades that ties everything together and shows how each project led to the next. It starts from our early efforts in population history using household registers, and proceeds sequentially up to the present day, including our new projects on university students, civil officials, and educated professionals.

In front of the No. 1 Historical Archives in Beijing in 1987

The section on the history of our collaboration will hopefully be the most readable: it starts with James Lee’s visit to China in 1979 to look for records in historical archives that could be turned into databases, then Cameron  shows up in 1987 at the end his sophomore year at Caltech. Later others joined to form what is now the Lee-Campbell Group. We also talk about our involvement in the Eurasia Project in Population and Family History including what we hope will be interesting anecdotes, reminisces, and reflections.

The introduction to our databases and summary of results, meanwhile, is the first time we have put almost everything we have done together in one place. We hope that it will be useful for those who may be familiar with specific pieces of our work to gain a better sense of the larger research agenda In into which these pieces fit.

This was a fun paper to write, especially the history section which includes some discussion of our faculty years at Caltech 1982-2002, UCLA 1996-2015, Michigan 1980-1982, 1995-1996, 2002-2009 and most recently HKUST 2009/2013-onwards and the contributions of these institutions and our colleagues to advancing our research projects.

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