MedicalClaimsSynthetic1M

Medical claims synthetic 1M sample

@kaggle.drscarlat_medicalclaimssynthetic1m

Table List

1 table(51.31 MB)

Medicalclaimssynthetic1m

@kaggle.drscarlat_medicalclaimssynthetic1m.medicalclaimssynthetic1m

51.31 MB
1000000 rows
43 columns

desynpuf_id DESYNPUF ID	bene_birth_dt BENE BIRTH DT	bene_sex_ident_cd BENE SEX IDENT CD	bene_race_cd BENE RACE CD	bene_esrd_ind BENE ESRD IND	sp_state_code SP STATE CODE	bene_county_cd BENE COUNTY CD	bene_hi_cvrage_tot_mons BENE HI CVRAGE TOT MONS	bene_smi_cvrage_tot_mons BENE SMI CVRAGE TOT MONS	bene_hmo_cvrage_tot_mons BENE HMO CVRAGE TOT MONS	plan_cvrg_mos_num PLAN CVRG MOS NUM	sp_alzhdmta SP ALZHDMTA	sp_chf SP CHF	sp_chrnkidn SP CHRNKIDN	sp_cncr SP CNCR	sp_copd SP COPD	sp_depressn SP DEPRESSN	sp_diabetes SP DIABETES	sp_ischmcht SP ISCHMCHT	sp_osteoprs SP OSTEOPRS	sp_ra_oa SP RA OA	sp_strketia SP STRKETIA	medreimb_ip MEDREIMB IP	benres_ip BENRES IP	medreimb_op MEDREIMB OP	benres_op BENRES OP	medreimb_car MEDREIMB CAR	benres_car BENRES CAR	pppymt_car PPPYMT CAR	clm_id CLM ID	clm_from_dt CLM FROM DT	clm_thru_dt CLM THRU DT	icd9_dgns_cd_1 ICD9 DGNS CD 1	prf_physn_npi_1 PRF PHYSN NPI 1	hcpcs_cd_1 HCPCS CD 1	line_nch_pmt_amt_1 LINE NCH PMT AMT 1	line_coinsrnc_amt_1 LINE COINSRNC AMT 1	line_prcsg_ind_cd_1 LINE PRCSG IND CD 1	line_icd9_dgns_cd_1 LINE ICD9 DGNS CD 1
BAC397A752FA03A7	19330101	2	1	Y	31	150	12	12	12	12	2	2	2	1	2	2	2	2	1	2	2			2030	630	7110	2090		286773380559375	20081212	20081212	1629	6502930399	99213	190	60	X	1629
BE4841C03C968C6B	19341201	2	1	Y	45	552	12	12		12	1	1	1	2	1	1	1	1	2	1	2			510	450	1620	370		586343332492846	20080808	20080808	4281	2497672561	99213	60	10	A	4280
0DCFC21B16C7A18F	19300901	2	1	0	5	430	12	12		12	2	2	2	2	2	2	2	2	2	2	2								286123380679174	20090917	20090917	4019	3714600044	99214	80	20	A	4011
5ED5E5248B290111	19220201	2	1	0	33	800	12	12	12	12	2	2	1	2	2	2	2	1	1	2	2			600	290	740	380		436983306060135	20081122	20081122	49121	7607074983	99213	50	10	A	496
7FA31DE58F7B26E1	19280801	2	1	0	10	510	12	12			2	2	2	2	2	2	1	2	2	2	2					370	90		436293304029596	20081013	20081013	38601	6928372628	99213	50	10	A	38611
D965F29256538662	19400301	2	2	0	1	510	12	12	12	12	2	2	2	2	2	2	2	1	2	2	2			200	50	510	80		586363333120170	20080410	20080410	4011	2202521638	99214	70		A	4011
B652355A855FDBD0	19380601	2	1	0	5	200	12	8		12	2	2	2	2	2	2	2	2	2	2	2								737133362610859	20080718	20080718	4011	2475058558	99214			A	4011
487D72BA0918D329	19320901	1	1	0	24	710	12	12			2	1	1	1	2	1	1	1	2	2	2			3480	140	5360	1320	400	286383380211516	20080118	20080118	80852	1931272243	99213		30	A	8072
8327C0EE2974AE37	19371201	2	3	0	5	440	12	12		12	2	1	2	2	1	1	1	1	2	2	2	4000	1068	280	280	4400	1090	100	436333306098296	20090120	20090120	V149	3003380258	99212	50	10	A	6929
A75F4D7A8D9ECDF9	19360101	1	1	Y	33	590	12	12		12	2	2	1	2	1	2	2	2	2	2	2			300	1410	1190	280		436593307971019	20090410	20090410	7925	1973668724	99214		20	A	5853


CREATE TABLE medicalclaimssynthetic1m (
  "desynpuf_id" VARCHAR,
  "bene_birth_dt" BIGINT,
  "bene_death_dt" BIGINT,
  "bene_sex_ident_cd" BIGINT,
  "bene_race_cd" BIGINT,
  "bene_esrd_ind" VARCHAR,
  "sp_state_code" BIGINT,
  "bene_county_cd" BIGINT,
  "bene_hi_cvrage_tot_mons" BIGINT,
  "bene_smi_cvrage_tot_mons" BIGINT,
  "bene_hmo_cvrage_tot_mons" BIGINT,
  "plan_cvrg_mos_num" BIGINT,
  "sp_alzhdmta" BIGINT,
  "sp_chf" BIGINT,
  "sp_chrnkidn" BIGINT,
  "sp_cncr" BIGINT,
  "sp_copd" BIGINT,
  "sp_depressn" BIGINT,
  "sp_diabetes" BIGINT,
  "sp_ischmcht" BIGINT,
  "sp_osteoprs" BIGINT,
  "sp_ra_oa" BIGINT,
  "sp_strketia" BIGINT,
  "medreimb_ip" DOUBLE,
  "benres_ip" DOUBLE,
  "pppymt_ip" DOUBLE,
  "medreimb_op" DOUBLE,
  "benres_op" DOUBLE,
  "pppymt_op" DOUBLE,
  "medreimb_car" DOUBLE,
  "benres_car" DOUBLE,
  "pppymt_car" DOUBLE,
  "clm_id" BIGINT,
  "clm_from_dt" BIGINT,
  "clm_thru_dt" BIGINT,
  "icd9_dgns_cd_1" VARCHAR,
  "prf_physn_npi_1" DOUBLE,
  "hcpcs_cd_1" BIGINT,
  "line_nch_pmt_amt_1" DOUBLE,
  "line_bene_ptb_ddctbl_amt_1" DOUBLE,
  "line_coinsrnc_amt_1" DOUBLE,
  "line_prcsg_ind_cd_1" VARCHAR,
  "line_icd9_dgns_cd_1" VARCHAR
);