CGED-Q Jinshenlu 1900-1912 Public Release Tabulation and Visualization Platform

Charlie Liu, an undergraduate in the Quantitative Social Analysis program at HKUST, created a platform for producing tabulations and visualizations with the CGED-Q Jinshenlu 1900-1912 Public Release. At the platform, users can explore the contents of the publicly released CGED-Q  for the period 1900-1912 without having to download data and open it in a statistical package in R or Stata. Among the available variables are province and county of origin, location of current post, Banner status, and exam or purchase degree (出身). Here is the CGED-Q tabulation and visualization platform.

Our CGED-Q project page has more information about the CGED-Q itself, including links to sites where advanced users can download the data to be analyzed in a statistical package like R or Stata. These sites also include documentation.

As a reminder, if you’re looking for a specific official, the entire CGED-Q is searchable via this platform, originally created by Fi Siwei and housed on a server by the HKUST VisGroup.


New Lee-Campbell Group Dataverse at Harvard Dataverse, with CGED-Q Jinshenlu 1900-1912 Public Release

We have created a Lee-Campbell Group Dataverse at Harvard Dataverse to host the CGED-Q Jinshenlu 1900-1912 Public Release and future publicly releases. This will complement the sites that already host our public data at the HKUST Dataspace and the Renmin University Institute of Qing History. We hope that this will facilitate access to the data by users in North America and also increase the visibility of the publicly released data.

Lee-Campbell Group Dataverse at Harvard Dataverse

CGED-Q Jinshenlu 1900-1912 Public Release at Harvard Dataverse

Data will continue to be available at the existing sites. Please see the CGED-Q page for links.

China Multi-Generational Panel Dataset Wins a Prize

At the 2020 Chinese Digital Humanities Annual Meeting (中国数字人文年会), the China Multi Generational Panel Dataset 中国多世代人口数据库 CMGPD was awarded the inaugural “最佳题材奖” Prize.  This is the 14th prize or similar recognition awarded to Lee-Campbell group research projects and our first for something other than a book or article.  See Publications and Prizes for a complete list.


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


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:

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.


New Online Search Function for Records of Officials in the 缙绅录 Made Publicly Accessible

We’ve made it possible to search the database of records for Qing officials that we are constructing from the 缙绅录, which was a sort of personnel directory published every three months (!) during the Qing, and listed approximately 13,000-15,000 officials each time, depending on the edition. We also have some editions of 中樞備覽 which list military officials. To learn more about the China Government Employee Database – Qing (CGED-Q), including our plans for the future, please visit our project page. We also have a paper in Chinese describing the database.

If you would like to look anyone up, perhaps an ancestor who served as an official, or someone you are already conducting research on, please give it a try: Note that at present, it doesn’t work with Firefox.

All we ask is that if you have additional information on whoever you search for, please provide some details and your contact information in the form that shows up below the search results. We are particularly interested in years of birth and death, and names of ancestors.

We were inspired to do this because we had already begun fielding informal requests from people who asked us if we could find their ancestors, and wanted to make this more widely available.

Fu Siwei, a PhD student in computer science who is working with us on visualization of these and other historical databases, did this search facility as a side project. Lawrence Zhang, Bijia Chen, and other members of the research group provided a lot of feedback on various iterations.

Right now we’re only allowing for lookup of individuals. Following our standard practice, we will begin making the data publicly available, period by period. Our first release will be of late Guangxu and early Xuantong material, sometime in 2018.

Disclaimers and caveats

We’re still entering data. Right now our coverage of the early 20th century and late 19th century is the most complete. Coverage before the middle of the 19th century is pretty spotty.

It’s in Chinese, and for the search, you need to enter traditional Chinese, since that’s the way the original data is.


Computer Scientists Use CMGPD to Develop Visualization Tools for Genealogical Data

Qu Huamin (HKUST Computer Science) and collaborators have been using the China Multigenerational Panel Dataset-Liaoning to test and showcase visualization tools they have been developing for multidimensional genealogical data. Multidimensional refers to the fact that the genealogical data not only identify ancestors and kin, but describe additional characteristics. They recently published a paper describing these tools and the results of applying them to CMGPD in the IEEE Transactions on Human-Machine Systems: While developing their tools and testing them with the CMGPD, they have consulted frequently with members of the Lee-Campbell Group not only about the data, but the needs of likely users. This collaboration between historians, social scientists, and computer scientists is an example of the sort of cross-disciplinary interaction and engagement that is common at HKUST.

The tools that Professor Qu and his collaborators are developing allow for the visualization of these characteristics, highlighting ancestors or kin with specified traits, while at the same time organizing the presentation as a traditional family tree. This allows for visualization of patterns within families, for example, whether certain outcomes are more apparent in specific family branches, or whether lineage experienced changes in specific time periods.

Lee-Campbell Research Group and Institute of Qing History Sign MOU


On 6 January 2017, a delegation from the Institute of Qing History at Renmin University visited the HKUST School of Humanities and Social Science and signed a MOU to cooperate in post graduate student training as well as the organization of a series of scholarly meetings associated with periodic public data releases from the CGED-Q including the production and distribution of related scholarly materials such as a series of accompanying User Guides.


Renmin delegates included Zhu Hu 朱浒, Director of the Institute of Qing History, Hu Heng 胡恒, Vice Director of the Institute of Qing History, Liu Wenpeng 刘文鹏, Vice Director of the Institute of Qing History, and Hu Xiangyu 胡祥雨, Associate Professor at the Institute of Qing History.  HKUST counterparts included James Z. Lee, Dean of the School of Humanities and Social Science, Cameron Campbell, SHSS Associate Dean for Research and Graduate Study, Lawrence Zhang, Assistant Professor of History, Bijia Chen, PhD candidate in social science and HKPFS recipient, and Lian Bai, the Head of the HKUST SHSS International and Mainland Program Office.