3 ms·
Translation: member.name: (2/11) Total rows: 1956731 Null rows: 0 Blank rows: 0 Distinct values: 1072319 Most
by Zarel 6y ago
Translation:
member.name: (2/11)
Total rows: 1956731
Null rows: 0
Blank rows: 0
Distinct values: 1072319
Most common:
650: 张伟 - Zhang Wei (Grand)
621: 张敏 - Zhang Ming (Agile)
620: 王伟 - Wang Wei (Grand)
579: 张磊 - Zhang Lei (Open)
507: 王磊 - Wang Lei (Open)
488: 陈洁 - Chen Jie (Clean)
479: 张杰 - Zhang Jie (Outstanding)
448: 王勇 - Wang Yong (Brave)
442: 李伟 - Li Wei (Grand)
434: 张静 - Zhang Jing (Calm)
I've annotated the names with their meanings because I find them pretty interesting. In Chinese, names should not overlap (unlike most of the rest of the world, where names are chosen by picking from a list of common names, in China, names are chosen by picking a unique sequence of characters not used by anyone else you're aware of).
These names are all one-character long, rather than the standard two characters, and the surnames are some of the most common in China, so they end up having nonzero overlap.
member.sex: (3/11)
Total rows: 1956731
Null rows: 0
Blank rows: 0
Distinct values: 2
Most common:
1229406: 男 - male
727325: 女 - female
member.ethnicity: (4/11)
Total rows: 1956731
Null rows: 0
Blank rows: 0
Distinct values: 51
Most common:
1935764: 汉族 - Han
7636: 回族 - Hui
4588: 满族 - Manchu
2282: 蒙古族 - Mongol
1468: 土家族 - Tujia
954: 壮族 - Zhuang
741: 朝鲜族 - Korean
638: 苗族 - Miao
351: 白族 - Bai
319: 侗族 - Dong
member.hometown: (5/11)
Total rows: 1956731
Null rows: 0
Blank rows: 0
Distinct values: 2875
Most common:
846850: 上海 - Shanghai
350361: null
139903: 江苏 - Jiangsu
80958: 浙江 - Zhejiang
29935: 上海宝山 - Shanghai Baoshan district
29705: 山东 - Shandong
26366: 上海崇明 - Shanghai Chongming county
26120: 安徽 - Anhui
17697: 上海嘉定 - Shanghai Jiading district
14745: 上海南汇 - Shanghai Nanhui district
member.organization: (6/11)
Total rows: 1956731
Null rows: 0
Blank rows: 0
Distinct values: 77453
Most common:
3533: 退休支部 - retirement branch
1925: 第一党支部 - first party branch
1796: 机关党支部 - party branch
1759: 校逾期未归 - [not completed]
1552: 退休一支部 - retirement 1 branch
1528: 第二党支部 - second party branch
1508: 退休二支部 - retirement 2 branch
1443: 退休党支部 - retirement party branch
1243: 第三党支部 - third party branch
955: 离退休党支部 - ending retirement party branch
member.education: (11/11)
Total rows: 1956731
Null rows: 0
Blank rows: 0
Distinct values: 22
Most common:
589531: 大学 - university
360788: 大专 - junior college
300370: 初中 - in progress
230117: 普通高中 - regular high school
161803: 硕士研究生 - master's student
158041: 中等专科 - specialized secondary school
93859: 小学 - elementary
25460: 博士研究生 - doctoral student
14729: 技工学校 - vocational high school
8894: 其他 - other
- ardy42 6y ago> These names are all one-character long, rather than the standard two characters, and the surnames are some of the most common in China, so they end up having nonzero overlap. Two character given names aren't standard. At least in some places, in some families, they alternate between one and two characters from generation to generation.
- yorwba 6y ago> 300370: 初中 - in progress Actually "middle school" (as opposed to 高中 "high school").