Shanghai CCP members by Ethnicity around 02/September/2020.

Out of 1,956,731 ( one million nine hundreds fifty six thousands seven hundred and thirty one ) CCP members in Shanghai; 1,935,764 ( one million nine hundred thirty five thousand seven hundred and sixty four ) are of Han ethnicity!!

— Please click on the image to view in full size.

Shanghai CCP members by Ethnicity around 02/September/2020.

I downloaded this data around September 2020, from:

• [預覽 / Online preview — https://gitlab.com/shanghai-ccp-member-db/shanghai-ccp-member-db/-/blob/master/preview/shanghai-ccp-member.csv?expanded=true&viewer=simple — ( 8191 / 1956731 rows )
• [下載 / Download — https://gitlab.com/shanghai-ccp-member-db/shanghai-ccp-member-db/-/raw/master/shanghai-ccp-member.csv — full csv file
• [下載 / Download — https://gitlab.com/shanghai-ccp-member-db/shanghai-ccp-member-db/-/raw/master/shanghai-ccp-member.db — full sqlite database
  

None of these links appears to exist anymore. The author listed their source: https://lihkg.com/thread/2162349/page/1 — and this link still exists and the content is in Chinese.

shanghai-ccp-member.db is a SQLite database, which can be opened with SQLiteStudio. This database has 1,956,731 ( one million nine hundreds fifty six thousands seven hundreds and thirty one ) records. Each record has the following info:

• Name
• Sex
• Ethnicity
• Home Town
• Organisation
• ID Card Number
• Address
• Mobile Phone
• Phone Number
• Education

This is the SQL query I wrote to pull out the data for the chart:

select ethnicity, count(ethnicity) as “count” from member group by ethnicity order by count desc;

This is my copy of the original data:

https://drive.google.com/file/d/1CofC0Gy9eTn7JD6TK-2ohj41gyD9GL-V/view?usp=sharing

03/02/2022.