CMS Data Entrepreneurs Synthetic Public Use File - DESynPUF

By CMS

Synthetic Medicare patient data public use file

Product type

Dataset

Update frequency

Historical

Updated

Sep 21, 2020

Delivery method

Download

Metadata is available for each file version of the dataset. A JSON file can be downloaded once you subscribe to the dataset. The information below is an example of the metadata included in each JSON file.

Dataset file name: DE1_0_2009_Beneficiary_Summary_File_Sample_1.zip

Key Statistics

Total records

114,538

Missing values

0.969%

Duplicate rows

Columns

Categorical

Numeric

Date/time

Correlations

Correlated columns

MEDREIMB_OP and BENRES_OP, MEDREIMB_IP and BENRES_IP, MEDREIMB_CAR and BENRES_CAR

Column name	Type	Unique values	Min value	Max value
BENE_DEATH_DT	numeric	12	20090100	20091200
BENE_BIRTH_DT	numeric	900	19090101	19831201
BENE_SEX_IDENT_CD	numeric	2	1	2
BENE_RACE_CD	numeric	4	1	5
SP_STATE_CODE	numeric	52	1	54
BENE_COUNTY_CD	numeric	307	0	999
BENE_HI_CVRAGE_TOT_MONS	numeric	13	0	12
BENE_SMI_CVRAGE_TOT_MONS	numeric	13	0	12
BENE_HMO_CVRAGE_TOT_MONS	numeric	13	0	12
SP_ALZHDMTA	numeric	2	1	2
PLAN_CVRG_MOS_NUM	numeric	13	0	12
SP_CNCR	numeric	2	1	2
SP_CHRNKIDN	numeric	2	1	2
SP_CHF	numeric	2	1	2
SP_COPD	numeric	2	1	2
SP_DEPRESSN	numeric	2	1	2
SP_OSTEOPRS	numeric	2	1	2
SP_DIABETES	numeric	2	1	2
SP_ISCHMCHT	numeric	2	1	2
SP_RA_OA	numeric	2	1	2
SP_STRKETIA	numeric	2	1	2
PPPYMT_IP	numeric	67	0	91000
BENRES_IP	numeric	106	0	38272
MEDREIMB_OP	numeric	1,527	-80	46480
MEDREIMB_IP	numeric	2,090	-2000	136100
BENRES_OP	numeric	646	0	13840
MEDREIMB_CAR	numeric	1,055	0	16540
PPPYMT_OP	numeric	87	0	19000
PPPYMT_CAR	numeric	139	0	2200
BENRES_CAR	numeric	330	0	4690
BENE_ESRD_IND	categorical	2	1	1
DESYNPUF_ID	text	114,538	16	16