U.S. Healthcare Data

Population Health, Diseases, Drugs, Nutritions, Health-plans

@kaggle.maheshdadhich_us_healthcare_data

Table List

11 tables(33.32 MB)

Drugs Package

Drugs Unfinished Package

Star Rating Fall High Performing Plans

Star Rating Fall Low Performing Plans

Star Rating Spring High Performing Plans

Star Rating Spring Low Performing Plans

Nhanes 2005–2006

@kaggle.maheshdadhich_us_healthcare_data.nhanes_2005_2006

4.88 MB
10348 rows
465 columns
Only the first 100 columns are shown

seqn SEQN	wtdrd1 WTDRD1	wtdr2d WTDR2D	dr1drstz DR1DRSTZ	dr1exmer DR1EXMER	drabf DRABF	drdint DRDINT	dr1day DR1DAY	dr1lang DR1LANG	dr1mnrsp DR1MNRSP	dr1helpd DR1HELPD	dbq095z DBQ095Z	dbd100 DBD100	drqsprep DRQSPREP	drqsdiet DRQSDIET	drqsdt8 DRQSDT8	dr1tnumf DR1TNUMF	dr1tkcal DR1TKCAL	dr1tprot DR1TPROT	dr1tcarb DR1TCARB	dr1tsugr DR1TSUGR	dr1tfibe DR1TFIBE	dr1ttfat DR1TTFAT	dr1tsfat DR1TSFAT	dr1tmfat DR1TMFAT	dr1tpfat DR1TPFAT	dr1tchol DR1TCHOL	dr1tatoc DR1TATOC	dr1tatoa DR1TATOA	dr1tret DR1TRET	dr1tvara DR1TVARA	dr1tacar DR1TACAR	dr1tbcar DR1TBCAR	dr1tcryp DR1TCRYP	dr1tlyco DR1TLYCO	dr1tlz DR1TLZ	dr1tvb1 DR1TVB1	dr1tvb2 DR1TVB2	dr1tniac DR1TNIAC	dr1tvb6 DR1TVB6	dr1tfola DR1TFOLA	dr1tfa DR1TFA	dr1tff DR1TFF	dr1tfdfe DR1TFDFE	dr1tchl DR1TCHL	dr1tvb12 DR1TVB12	dr1tb12a DR1TB12A	dr1tvc DR1TVC	dr1tvk DR1TVK	dr1tcalc DR1TCALC	dr1tphos DR1TPHOS	dr1tmagn DR1TMAGN	dr1tiron DR1TIRON	dr1tzinc DR1TZINC	dr1tcopp DR1TCOPP	dr1tsodi DR1TSODI	dr1tpota DR1TPOTA	dr1tsele DR1TSELE	dr1tcaff DR1TCAFF	dr1ttheo DR1TTHEO	dr1talco DR1TALCO	dr1tmois DR1TMOIS	dr1ts040 DR1TS040	dr1ts060 DR1TS060	dr1ts080 DR1TS080	dr1ts100 DR1TS100	dr1ts120 DR1TS120	dr1ts140 DR1TS140	dr1ts160 DR1TS160	dr1ts180 DR1TS180	dr1tm161 DR1TM161	dr1tm181 DR1TM181	dr1tm201 DR1TM201	dr1tm221 DR1TM221	dr1tp182 DR1TP182	dr1tp183 DR1TP183	dr1tp184 DR1TP184	dr1tp204 DR1TP204	dr1tp205 DR1TP205	dr1tp225 DR1TP225	dr1tp226 DR1TP226	dr1_300 DR1–300	dr1_320z DR1–320Z	dr1_330z DR1–330Z	dr1bwatz DR1BWATZ	dr1tws DR1TWS	drd340 DRD340	drd350a DRD350A	drd350b DRD350B	drd350bq DRD350BQ	drd350c DRD350C
31127	4718.87325234	5906.47236231	1	57	2	2	7	1	3	13	4		1	2		16	1421	50.42	171.45	139.02	4.6	61.28	25.994	20.509	8.098	365	3.34	5.3976053469300003e-79	373	457	21	1049	44	1	409	0.811	2.334	6.952	1.19	154	36	118	178	305.4	5.71	5.3976053469300003e-79	173.8	26	1127	1165	185	5.74	6.34	0.6	1652	2637	73.3	5.3976053469300003e-79	9	5.3976053469300003e-79	1481.96	0.654	0.65	0.651	0.694	0.697	3.002	13.133	6.112	0.801	19.35	0.145	0.06	6.72	1.257	0.004	0.091	0.003	5.3976053469300003e-79	0.021	1	5.3976053469300003e-79	5.3976053469300003e-79	5.3976053469300003e-79	4
31128	3933.78904645	4250.89043527	1	16	2	2	6	1	1	13	1	3	2	2		11	1402	32.51	180.88	88.69	10	65.05	23.381	17.128	17.755	70	7.78	5.3976053469300003e-79	190	196	5.3976053469300003e-79	73	15	5.3976053469300003e-79	75	0.381	1.092	8.096	1.088	141	30	111	162	85.9	1.72	5.3976053469300003e-79	25	31.6	645	737	150	4.55	5.47	0.784	1432	2452	35.8	33	120	5.3976053469300003e-79	751.83	0.483	0.314	0.23	0.34	0.41	1.918	15.353	3.803	0.544	16.268	0.163	0.001	16.768	0.963	5.3976053469300003e-79	0.014	5.3976053469300003e-79	0.002	0.003	2	5.3976053469300003e-79	5.3976053469300003e-79	5.3976053469300003e-79	99	2
31129	26719.805504	26719.805504	1	10	2	2	2	1	1	13	1	1	3	2		17	4110	139.89	684.22	498.82	14.5	94.73	38.599	37.018	12.18	423	3.78	5.3976053469300003e-79	360	382	2	288	5	3759	264	1.79	2.652	44.532	2.233	338	209	129	482	393.3	3.98	5.3976053469300003e-79	538.5	45.1	2024	1938	328	15.93	12.02	2.333	5038	2722	206.3	7	74	5.3976053469300003e-79	5642.64	1.069	0.621	0.467	0.765	1.026	3.901	19.459	9.895	2.074	33.751	0.34	0.068	10.734	0.985	5.3976053469300003e-79	0.206	0.017	0.017	0.039	3	500	5.3976053469300003e-79	500	1	1	2	1	2	2
31130			5
31131	13595.8959399	14822.4793259	1	16	2	2	6	1	1	13	4		3	2		15	1458	27.43	233.73	146.01	6.4	50.86	18.274	20.745	7.641	48	2.34	5.3976053469300003e-79	114	120	5.3976053469300003e-79	76	5.3976053469300003e-79	3477	85	0.752	0.886	8.369	0.385	299	75	224	352	91.6	1.03	5.3976053469300003e-79	47.3	23.4	401	483	144	7.04	3.43	0.68	1426	1565	36	13	139	5.3976053469300003e-79	1432.32	0.292	0.148	0.368	0.401	2.841	1.837	7.31	4.684	0.33	19.489	0.167	0.005	7.085	0.46	5.3976053469300003e-79	0.013	0.006	0.002	0.028	3	192.56	192.56	5.3976053469300003e-79	1	2
31132	40484.1359968	45660.6386702	1	23	2	2	3	1	1	13	2	2	1	2		28	2168	75.81	269.93	111.54	20.3	60.16	17.608	17.494	19.114	138	20.19	12.93	314	813	51	5934	39	2572	373	3.703	3.849	48.134	4.502	801	569	233	1199	318.8	8.92	6.42	124.8	48.7	1508	1180	314	30.51	24.8	1.194	3708	3757	111.7	260	5.3976053469300003e-79	40.8	3043.57	0.017	0.033	0.293	0.266	1.795	1.067	10.121	3.66	0.674	16.492	0.179	0.001	17.279	1.655	5.3976053469300003e-79	0.097	0.001	0.003	0.004	2	829.5	770.25	59.25	1	2
31133	3823.24039147	5530.8810603	1	10	2	2	7	1	1	13	1	1	3	1	8	9	1688	45.92	238.62	136.71	8.3	63.84	18.362	27.206	16.037	132	2.06	5.3976053469300003e-79	53	143	250	490	941	5.3976053469300003e-79	443	0.741	0.78	16.696	0.917	104	44	60	136	141.8	3.1	5.3976053469300003e-79	41	51.9	348	804	127	6.84	6.86	0.6	1937	1295	75.9	71	5.3976053469300003e-79	5.3976053469300003e-79	1294.03	0.186	0.064	0.044	0.107	0.129	0.949	10.482	5.735	1.07	25.74	0.2	0.044	14.425	1.38	0.131	0.092	5.3976053469300003e-79	5.3976053469300003e-79	5.3976053469300003e-79	3	118.5	5.3976053469300003e-79	118.5	4	1	2	2		2
31134	35629.2008381	38210.9058912	1	91	2	2	1	1	1	13	1	1	4	2		14	2159	67.11	299.8	140.26	16.4	79.3	23.41	30.854	19.074	480	4.66	5.3976053469300003e-79	339	374	5.3976053469300003e-79	417	8	9146	601	1.589	1.925	19.482	1.513	284	130	156	376	402.5	3.11	5.3976053469300003e-79	34.9	80.1	704	955	210	14.47	11.86	1.219	4373	2666	108.6	142	5.3976053469300003e-79	5.3976053469300003e-79	864.97	0.406	0.247	0.146	0.331	0.363	1.508	12.966	6.984	0.931	29.307	0.111	0.012	17.228	1.561	5.3976053469300003e-79	0.177	0.005	5.3976053469300003e-79	0.032	2	5.3976053469300003e-79	5.3976053469300003e-79	5.3976053469300003e-79	2	2
31135	15339.3426745	16332.9261659	1	23	2	2	6	1	2	3	4		4	2		18	1290	43.57	148.26	89.05	9.6	59.33	24.771	20.754	11.052	107	10.34	7.76	775	1470	997	7812	47	5.3976053469300003e-79	1179	1.052	1.607	12.785	1.1	283	200	83	420	168	4.33	2.26	127.6	75.1	1002	855	178	16.86	10.66	0.948	1271	1763	62.1	5.3976053469300003e-79	5.3976053469300003e-79	5.3976053469300003e-79	1436.69	0.497	0.265	0.654	0.656	3.084	2.863	12.303	3.852	0.459	20.017	0.058	0.005	9.508	0.993	0.003	0.212	0.032	0.01	0.255	2	222.19	222.19	5.3976053469300003e-79	1
31137	9354.74942769	9703.53330601	1	25	2	2	5	1	1	13	1	2	4	2		22	2866	82.06	342.56	177.96	15	133.92	39.094	46.28	38.037	203	12.07	5.3976053469300003e-79	454	518	63	636	191	1833	671	1.694	2.372	20.325	1.045	484	241	243	652	231.2	6.17	5.3976053469300003e-79	131.9	138.4	1236	1482	251	17.78	13.21	1.411	4117	2592	134	71	386	5.3976053469300003e-79	2338.72	0.755	0.236	0.292	0.633	0.777	3.159	21.909	10.075	1.349	43.986	0.332	0.012	34.139	3.079	0.186	0.074	5.3976053469300003e-79	5.3976053469300003e-79	0.002	2	694.38	444.38	250	99	2


CREATE TABLE nhanes_2005_2006 (
  "seqn" DOUBLE,
  "wtdrd1" DOUBLE,
  "wtdr2d" DOUBLE,
  "dr1drstz" DOUBLE,
  "dr1exmer" DOUBLE,
  "drabf" DOUBLE,
  "drdint" DOUBLE,
  "dr1day" DOUBLE,
  "dr1lang" DOUBLE,
  "dr1mnrsp" DOUBLE,
  "dr1helpd" DOUBLE,
  "dbq095z" DOUBLE,
  "dbd100" DOUBLE,
  "drqsprep" DOUBLE,
  "drqsdiet" DOUBLE,
  "drqsdt1" DOUBLE,
  "drqsdt2" DOUBLE,
  "drqsdt3" DOUBLE,
  "drqsdt4" DOUBLE,
  "drqsdt5" DOUBLE,
  "drqsdt6" DOUBLE,
  "drqsdt7" DOUBLE,
  "drqsdt8" DOUBLE,
  "drqsdt91" DOUBLE,
  "dr1tnumf" DOUBLE,
  "dr1tkcal" DOUBLE,
  "dr1tprot" DOUBLE,
  "dr1tcarb" DOUBLE,
  "dr1tsugr" DOUBLE,
  "dr1tfibe" DOUBLE,
  "dr1ttfat" DOUBLE,
  "dr1tsfat" DOUBLE,
  "dr1tmfat" DOUBLE,
  "dr1tpfat" DOUBLE,
  "dr1tchol" DOUBLE,
  "dr1tatoc" DOUBLE,
  "dr1tatoa" DOUBLE,
  "dr1tret" DOUBLE,
  "dr1tvara" DOUBLE,
  "dr1tacar" DOUBLE,
  "dr1tbcar" DOUBLE,
  "dr1tcryp" DOUBLE,
  "dr1tlyco" DOUBLE,
  "dr1tlz" DOUBLE,
  "dr1tvb1" DOUBLE,
  "dr1tvb2" DOUBLE,
  "dr1tniac" DOUBLE,
  "dr1tvb6" DOUBLE,
  "dr1tfola" DOUBLE,
  "dr1tfa" DOUBLE,
  "dr1tff" DOUBLE,
  "dr1tfdfe" DOUBLE,
  "dr1tchl" DOUBLE,
  "dr1tvb12" DOUBLE,
  "dr1tb12a" DOUBLE,
  "dr1tvc" DOUBLE,
  "dr1tvk" DOUBLE,
  "dr1tcalc" DOUBLE,
  "dr1tphos" DOUBLE,
  "dr1tmagn" DOUBLE,
  "dr1tiron" DOUBLE,
  "dr1tzinc" DOUBLE,
  "dr1tcopp" DOUBLE,
  "dr1tsodi" DOUBLE,
  "dr1tpota" DOUBLE,
  "dr1tsele" DOUBLE,
  "dr1tcaff" DOUBLE,
  "dr1ttheo" DOUBLE,
  "dr1talco" DOUBLE,
  "dr1tmois" DOUBLE,
  "dr1ts040" DOUBLE,
  "dr1ts060" DOUBLE,
  "dr1ts080" DOUBLE,
  "dr1ts100" DOUBLE,
  "dr1ts120" DOUBLE,
  "dr1ts140" DOUBLE,
  "dr1ts160" DOUBLE,
  "dr1ts180" DOUBLE,
  "dr1tm161" DOUBLE,
  "dr1tm181" DOUBLE,
  "dr1tm201" DOUBLE,
  "dr1tm221" DOUBLE,
  "dr1tp182" DOUBLE,
  "dr1tp183" DOUBLE,
  "dr1tp184" DOUBLE,
  "dr1tp204" DOUBLE,
  "dr1tp205" DOUBLE,
  "dr1tp225" DOUBLE,
  "dr1tp226" DOUBLE,
  "dr1_300" DOUBLE,
  "dr1_320z" DOUBLE,
  "dr1_330z" DOUBLE,
  "dr1bwatz" DOUBLE,
  "dr1tws" DOUBLE,
  "drd340" DOUBLE,
  "drd350a" DOUBLE,
  "drd350aq" DOUBLE,
  "drd350b" DOUBLE,
  "drd350bq" DOUBLE,
  "drd350c" DOUBLE
);