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 2011–2012

@kaggle.maheshdadhich_us_healthcare_data.nhanes_2011_2012

4.54 MB
9756 rows
449 columns
Only the first 100 columns are shown

seqn SEQN	wtdrd1 WTDRD1	wtdr2d WTDR2D	dr1drstz DR1DRSTZ	dr1exmer DR1EXMER	drabf DRABF	drdint DRDINT	dr1dbih DR1DBIH	dr1day DR1DAY	dr1lang DR1LANG	dr1mnrsp DR1MNRSP	dr1helpd DR1HELPD	dbq095z DBQ095Z	dbd100 DBD100	drqsprep DRQSPREP	drqsdiet DRQSDIET	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	dr1tvd DR1TVD	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
62161	58373.3757155	46955.9120177	1	63	2	2	9	6	1	1	2	1	1	4	2	13	2969	104.68	359.59	109.09	18.6	123.81	40.763	43.673	31.878	328	8.47	5.3976053469300003e-79	721	737	7	194	9	5.3976053469300003e-79	427	2.115	2.383	23.428	1.414	432	253	179	610	310.6	3.89	5.3976053469300003e-79	64.9	7.1	54.4	1961	2142	333	17.96	11.62	1.248	4975	2473	152.1	5.3976053469300003e-79	5.3976053469300003e-79	5.3976053469300003e-79	2570.53	1.403	0.557	0.353	0.737	0.657	4.185	22.436	8.626	1.957	40.472	0.339	0.007	29.565	1.966	0.004	0.112	0.005	0.006	0.024	2	1420	1420	5.3976053469300003e-79	1
62162	15886.6092649	13901.1702663	1	42	2	2	29	1	1	2	13	1	2	3	2	12	1494	61.09	203.18	112.71	9	48.94	18.998	15.287	11.302	202	4.06	5.3976053469300003e-79	304	325	5.3976053469300003e-79	255	2	6353	138	0.919	1.295	18.892	1.314	332	215	118	480	157.3	3.4	1.29	15.7	2.1	39.1	789	910	136	12.27	9.69	0.566	2262	1180	86.3	3	22	5.3976053469300003e-79	1220.03	0.394	0.319	0.217	0.451	0.496	1.79	10.552	4.25	0.793	14.156	0.157	0.01	9.88	1.127	0.005	0.136	0.011	0.024	0.009	2	472.19	5.3976053469300003e-79	472.19	1
62163	3876.44110371	2755.06160577	1	25	2	2	3	6	1	1	13	1	2	4	2	9	1789	72.64	280.23	114.94	7.4	41.95	14.386	19.528	5.03	138	2.61	5.3976053469300003e-79	999	1006	5.3976053469300003e-79	75	5.3976053469300003e-79	3480	87	1.782	2.797	19.352	1.886	567	487	81	911	268.6	9.69	2.49	12.5	14.5	22	1495	1573	256	26.93	16.66	0.84	3071	2552	96.3	3	121	5.3976053469300003e-79	1306.1	0.042	5.3976053469300003e-79	0.012	0.05	0.058	0.786	9.288	3.834	1.41	17.836	0.125	0.008	4.399	0.594	5.3976053469300003e-79	0.021	0.001	0.006	5.3976053469300003e-79	3	5.3976053469300003e-79	5.3976053469300003e-79	5.3976053469300003e-79	99
62164	70653.580056	52879.4794779	1	42	2	2	19	7	1	1	13	4		1	2	20	1115	73.13	91.67	32.29	9.5	51.54	10.697	21.133	15.144	207	4.52	5.3976053469300003e-79	15	66	41	567	82	2146	614	0.584	1.435	16.794	1.48	130	5.3976053469300003e-79	130	130	198.9	0.54	5.3976053469300003e-79	49.9	0.1	98.2	396	835	189	5.27	4.82	0.911	3392	1953	89.5	251	5.3976053469300003e-79	5.3976053469300003e-79	5104.52	5.3976053469300003e-79	5.3976053469300003e-79	0.015	0.043	0.145	0.188	6.387	3.428	0.828	19.562	0.156	0.105	13.196	1.408	0.036	0.21	0.004	0.022	0.024	2	3555	3555	5.3976053469300003e-79	1
62165	5910.00270905	9478.00185598	1	25	2	2	12	6	1	1	13	1	1	3	2	10	1472	76.35	143.52	72.34	6.9	67.8	18.616	21.394	23.022	260	7.86	5.3976053469300003e-79	182	193	1	133	5.3976053469300003e-79	2571	87	0.651	1.057	23.861	1.085	177	79	98	233	186.7	1.67	5.3976053469300003e-79	2.4	1.9	21.7	637	1098	149	6.59	5.56	1.147	2421	1347	97.1	21	28	5.3976053469300003e-79	1267.16	0.35	0.117	0.086	0.188	0.161	1.217	11.6	4.225	1.794	18.848	0.182	0.007	21.319	0.958	0.017	0.121	0.006	0.011	0.007	3	500	5.3976053469300003e-79	500	4
62166			5
62167	2771.4243395	2291.1844948	1	42	2	2	3	6	6	2	10	4		4	2	8	930	14.25	116.83	78.94	2.6	46.64	17.493	15.119	11.928	24	4.8	2.46	349	350	5.3976053469300003e-79	8	5.3976053469300003e-79	5.3976053469300003e-79	18	0.717	0.902	6.007	0.355	104	58	46	146	75.2	0.79	0.77	33.8	5.6	69	284	293	76	12.61	3.88	0.682	438	596	11.8	11	83	5.3976053469300003e-79	693.79	0.009	5.3976053469300003e-79	0.54	0.425	2.849	1.414	7.045	4.913	0.275	14.685	0.098	0.007	10.644	1.255	5.3976053469300003e-79	0.139	5.3976053469300003e-79	5.3976053469300003e-79	0.067	3	148.13	148.13	5.3976053469300003e-79	99
62168			5
62169	16775.152629	14306.3696153	1	25	2	2	30	1	1	1	13	4		2	2	6	1831	77.46	297.51	78.19	4.3	34.61	12.921	11.448	7.272	205	2.68	5.3976053469300003e-79	225	227	5.3976053469300003e-79	37	1	5.3976053469300003e-79	78	1.529	1.303	23.928	1.894	456	398	59	738	209.9	2.51	5.3976053469300003e-79	0.7	4.5	14.5	709	1129	193	11.25	7.69	0.742	2828	1465	115.8	40	77	5.3976053469300003e-79	1230.52	0.309	0.175	0.21	0.328	0.971	1.064	6.176	3.346	0.394	10.579	0.085	5.3976053469300003e-79	6.106	0.801	5.3976053469300003e-79	0.121	0.005	0.013	0.013	2	5.3976053469300003e-79	5.3976053469300003e-79	5.3976053469300003e-79	4
62170	3684.99103572	2655.62053452	1	25	2	2	15	7	1	1	13	4		4	2	8	1620	81.28	123.38	33.84	8.2	87.21	28.107	34.034	16.036	312	5.24	5.3976053469300003e-79	27	75	64	531	5	1544	466	1.002	0.914	21.676	1.539	225	100	124	294	318.2	7.25	5.3976053469300003e-79	16.6	0.8	54.4	303	811	152	10.7	18.11	0.778	2078	1849	85.6	5.3976053469300003e-79	5.3976053469300003e-79	5.3976053469300003e-79	2760.54	0.093	5.3976053469300003e-79	0.017	0.017	0.036	1.289	15.599	9.783	1.605	31.204	0.277	0.005	14.46	1.356	5.3976053469300003e-79	0.157	0.008	0.042	0.013	3	2370	2370	5.3976053469300003e-79	1


CREATE TABLE nhanes_2011_2012 (
  "seqn" DOUBLE,
  "wtdrd1" DOUBLE,
  "wtdr2d" DOUBLE,
  "dr1drstz" DOUBLE,
  "dr1exmer" DOUBLE,
  "drabf" DOUBLE,
  "drdint" DOUBLE,
  "dr1dbih" 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,
  "drqsdt9" DOUBLE,
  "drqsdt10" DOUBLE,
  "drqsdt11" DOUBLE,
  "drqsdt12" 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,
  "dr1tvd" 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
);