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 2009–2010

@kaggle.maheshdadhich_us_healthcare_data.nhanes_2009_2010

4.89 MB
10537 rows
412 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	drqsdt4 DRQSDT4	drqsdt7 DRQSDT7	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
51624	171886.802965	182302.928036	1	23	2	2	18	2	1	1	13	4		4	2			10	1844	74.68	233.86	128.29	24.3	74.08	28.037	27.071	13.276	285	8.18	5.3976053469300003e-79	609	705	33	917	369	27897	542	1.655	2.68	22.81	1.172	432	207	225	577	349.7	1.41	5.3976053469300003e-79	184.2	1.7	45.2	1231	1058	417	12.71	8.27	2.032	2664	3254	110.9	541	166	5.3976053469300003e-79	9159.27	0.977	0.561	0.335	0.729	0.852	3.122	14.237	6.909	1.274	25.425	0.104	5.3976053469300003e-79	11.607	1.295	5.3976053469300003e-79	0.163	0.015	0.03	0.059	3	6000	5.3976053469300003e-79	6000	4
51625	52953.3032796	127261.657958	1	41	2	2	7	7	1	2	1	4		4	2			17	1829	67.18	256.55	114.57	11.4	59.98	20.75	17.96	15.651	221	7.9	1.69	250	377	24	1489	23	3491	373	1.571	1.454	17.938	1.669	386	184	200	518	220.1	3.53	5.3976053469300003e-79	93.2	5.1	30	913	1136	208	9.77	10.05	1.337	3566	1734	99	3	107	5.3976053469300003e-79	1384.37	0.561	0.368	0.38	0.495	0.821	2.122	11.137	4.47	0.752	16.836	0.121	0.001	14.02	1.255	5.3976053469300003e-79	0.143	0.005	0.021	0.039	2	325.88	325.88	5.3976053469300003e-79	1
51626	29699.6526327	43756.0765968	1	42	2	2	7	2	1	1	13	1	2	3	2			8	1852	63.41	261.86	140.36	16.9	61.24	24.462	19.442	11.45	475	4.48	5.3976053469300003e-79	1365	1375	5.3976053469300003e-79	70	10	5.3976053469300003e-79	750	2.872	4.453	33.472	3.287	1215	1028	187	1935	436	10.59	6.25	45.2	17.6	20.5	1669	1539	304	29.78	25.65	1.042	2223	2172	137.5	5.3976053469300003e-79	5.3976053469300003e-79	5.3976053469300003e-79	1080.1	0.899	0.774	0.703	0.839	0.848	3.063	11.919	5.243	0.351	18.981	0.083	5.3976053469300003e-79	9.861	1.277	5.3976053469300003e-79	0.19	5.3976053469300003e-79	0.007	0.059	2	5.3976053469300003e-79	5.3976053469300003e-79	5.3976053469300003e-79	1
51627	25592.8591649	45085.3239239	1	25	2	2	2	5	1	1	2	1	2	3	2			14	3752	169.05	327.74	94.85	18.7	198.05	77.116	55.458	48.826	761	8.27	5.3976053469300003e-79	1146	1192	14	513	47	13459	658	2.335	3.084	43.575	1.949	583	353	230	831	627.1	5.05	5.3976053469300003e-79	49.1	11.9	52.5	3176	3595	355	19.08	16.08	1.214	8331	3457	234.9	29	5.3976053469300003e-79	5.3976053469300003e-79	1658.23	2.2	1.656	1.15	2.212	2.551	8.812	37.346	18.989	2.018	51.796	0.704	0.018	42.705	4.998	0.017	0.485	0.046	0.055	0.069	2	103.69	103.69	5.3976053469300003e-79	1
51628	17509.7792663	14286.3500716	1	42	2	2	13	1	1	1	13	1	3	4	2			14	1913	50.06	259.66	105.51	11.6	76.84	19.837	30.47	20.289	277	6.29	5.3976053469300003e-79	130	1054	101	11017	40	5.3976053469300003e-79	21614	1.234	1.309	15.733	1.321	408	172	236	529	212.9	1.61	5.3976053469300003e-79	71.1	2	1044.9	699	1012	169	11.78	5.24	0.965	3946	1682	78.7	168	9	5.3976053469300003e-79	2334.14	0.123	0.078	0.081	0.147	0.394	0.846	12.145	5.644	1.794	28.356	0.214	0.032	17.779	2.201	0.003	0.161	0.006	0.012	0.022	2	785.06	785.06	5.3976053469300003e-79	1
51629	11829.2489099	32486.8657959	1	25	2	2	8	7	1	1	13	4		4	2			17	3123	97.75	418.5	211.92	29	123.56	39.011	51.232	21.469	249	8.04	5.3976053469300003e-79	367	501	197	1484	34	7085	685	2.074	2.139	23.756	2.144	540	124	413	628	353.3	6.4	5.3976053469300003e-79	44.4	8	110.7	1562	2016	372	19.15	15.23	1.582	4840	4013	126.4	101	140	5.3976053469300003e-79	3929.88	0.754	0.575	0.499	0.643	0.618	3.327	20.329	11.297	1.579	48.269	0.539	0.149	18.88	2.381	5.3976053469300003e-79	0.099	0.002	0.001	0.008	3	1718.26	5.3976053469300003e-79	1718.26	4
51630	135969.226393	147522.260409	1	41	2	2	3	2	1	1	13	4		1	1		7	15	1345	79.47	191.04	75.93	21.3	32.41	8.791	12.262	8.573	142	5.17	5.3976053469300003e-79	231	306	17	872	25	5.3976053469300003e-79	1457	2.56	2.068	26.95	2.334	188	25	162	205	298.7	2.11	5.3976053469300003e-79	42.6	2.2	53.6	603	1311	340	8.44	9.32	1.048	2754	3078	133.3	267	5.3976053469300003e-79	5.3976053469300003e-79	2652.37	0.092	0.056	0.035	0.081	0.112	0.426	5.302	2.216	0.28	11.716	0.133	0.001	7.648	0.775	5.3976053469300003e-79	0.109	5.3976053469300003e-79	5.3976053469300003e-79	5.3976053469300003e-79	2	5.3976053469300003e-79	5.3976053469300003e-79	5.3976053469300003e-79	4
51631			5
51632			5
51633	16307.2014943	15725.1916077	1	25	2	2	2	2	1	1	13	4		2	1	4		19	1565	88.37	189.65	108.42	17.5	45.7	15.891	17.491	9.245	173	6.85	5.3976053469300003e-79	753	1243	1414	5169	21	13324	1191	2.005	4.27	22.215	1.719	300	69	231	348	482.3	6.26	5.3976053469300003e-79	128.7	15	61.8	1818	1894	353	7.1	10.22	0.844	2530	4308	94.7	639	5.3976053469300003e-79	11.2	3618.83	0.299	0.222	0.165	0.338	0.387	1.282	8.504	3.804	0.516	16.356	0.23	5.3976053469300003e-79	8.433	0.691	5.3976053469300003e-79	0.065	5.3976053469300003e-79	0.001	0.007	2	5.3976053469300003e-79	5.3976053469300003e-79	5.3976053469300003e-79	1


CREATE TABLE nhanes_2009_2010 (
  "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
);