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.


Paper on CGED-Q visualization in IEEE Transactions on Visualization and Computer Graphics by Bijia Chen, Cameron Campbell and others

Bijia Chen and Cameron Campbell were co-authors on a paper titled “Interactive Visual Exploration of Longitudinal Historical Career Mobility Data” that just appeared in IEEE Transactions on Visualization and Computer Graphics that introduces CareerLens, a visualization platform for exploring the careers of officials and their social networks in the China Government Employee Dataset-Qing. The lead author, Yifang Wang, is a PhD student of Professor Huamin Qu, a colleague in the Department of Computer Science and Engineering at HKUST whose research focuses on visualization and graphics. Other co-authors include Professor Qu and members of his VisLab group.

Here is a link to the paper:

Wang Yifang’s website has a page about the paper that includes a downloadable PDF, for those of you who can’t access it from the IEEE website.

An example of the CareerLens interface

And the abstract…

Abstract: The increased availability of quantitative historical datasets has provided new research opportunities for multiple disciplines in social science. In this paper, we work closely with the constructors of a new dataset, CGED-Q (China Government Employee Database-Qing), that records the career trajectories of over 340,000 government officials in the Qing bureaucracy in China from 1760 to 1912. We use these data to study career mobility from a historical perspective and understand social mobility and inequality. However, existing statistical approaches are inadequate for analyzing career mobility in this historical dataset with its fine-grained attributes and long time span, since they are mostly hypothesis-driven and require substantial effort. We propose CareerLens, an interactive visual analytics system for assisting experts in exploring, understanding, and reasoning from historical career data. With CareerLens, experts examine mobility patterns in three levels-of-detail, namely, the macro-level providing a summary of overall mobility, the meso-level extracting latent group mobility patterns, and the micro-level revealing social relationships of individuals. We demonstrate the effectiveness and usability of CareerLens through two case studies and receive encouraging feedback from follow-up interviews with domain experts