Last active
February 24, 2024 23:30
-
-
Save alexhiggins732/4df3db8c8743a7d6ed4f05d30894bffa to your computer and use it in GitHub Desktop.
English version of Leaked database of 1.95 million Chinese Communist Party members
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/*English version of the leaked database of 1.95 million Chinese Communist Party Members | |
that have infiltrated US and Western Companies, Government and Educational Institutions. | |
The report showed massive communist infiltration in Western firms and governments, including the United States | |
CSV Dataset can be dowloaded here: https://t.co/6I0SGZvRAX?amp=1 | |
shanghai-ccp-member-ch-en.csv 511.2 MB | |
SHA256 Hash: AA376F6C18388E138ACCCCCB2D18FC72E9B40191BF89C5CC691157455353D0D5 | |
*/ | |
CREATE TABLE [dbo].[ShanghaiCCPMember]( | |
[id] [int] NOT NULL constraint PK_ShanghaiCCPMemberID primary key, | |
[name] [nvarchar](20) NOT NULL, | |
[sex] [nvarchar](1) NOT NULL, | |
[ethnicity] [nvarchar](5) NOT NULL, | |
[hometown] [nvarchar](14) NULL, | |
[organization] [nvarchar](56) NULL, | |
[id_card_num] [nvarchar](59) NULL, | |
[address] [nvarchar](70) NULL, | |
[mobile_num] [nvarchar](22) NULL, | |
[phone_num] [nvarchar](34) NULL, | |
[education] [nvarchar](12) NULL, | |
[name_en] [nvarchar](60) NULL, | |
[ethnicity_en] [nvarchar](19) NULL, | |
[hometown_en] [nvarchar](65) NULL, | |
[organization_en] [nvarchar](342) NULL, | |
[address_en] [nvarchar](197) NULL, | |
[education_en] [nvarchar](90) NULL | |
) ON [PRIMARY] | |
GO |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment