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.
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.
Việt Nam: Văn Hóa, Chính Trị 