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 2013–2014

@kaggle.maheshdadhich_us_healthcare_data.nhanes_2013_2014

4.59 MB
10175 rows
439 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	dr1sty DR1STY	dr1sky DR1SKY	drqsdiet DRQSDIET	drqsdt7 DRQSDT7	drqsdt91 DRQSDT91	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
73557	16888.327864	12930.890649	1	49	2	2	6	2	1	1	13	3	2	4	2		2			11	1574	43.63	239.59	176.47	10.8	52.81	17.819	18.493	8.829	209	3.92	5.3976053469300003e-79	70	110	60	304	278	1398	430	1.057	1.216	11.804	0.951	285	66	219	330	216.3	2.79	5.3976053469300003e-79	241.4	3.3	29.2	949	756	206	8.41	8.85	1.072	1323	2228	62.5	203	36	5.3976053469300003e-79	2701.79	0.219	0.099	0.103	0.153	0.346	1.221	9.694	5.408	1.173	16.796	0.121	0.001	7.932	0.769	5.3976053469300003e-79	0.094	0.001	5.3976053469300003e-79	0.01	2	960	960
73558	17932.143865	12684.148869	1	59	2	2	4	1	1	1	13	1	2	3	1	1	2			8	5062	338.13	423.78	44.99	16.7	124.29	53.408	35.481	20.505	2584	20.94	5.3976053469300003e-79	1477	1488	5.3976053469300003e-79	145	12	5.3976053469300003e-79	899	4.178	5.168	65.396	4.415	1243	601	641	1662	2149	21.45	5.3976053469300003e-79	2.3	15.2	23.4	3193	6427	903	26.88	30.36	4.13	9726	4930	715.8	240	5.3976053469300003e-79	119	6779.99	1.872	1.16	0.802	1.286	1.297	6.516	27.952	12.107	2.208	32.429	0.086	5.3976053469300003e-79	15.483	1.774	0.007	0.728	1.003	0.104	1.139	2	360	360
73559	59641.81293	39394.236709	1	49	2	2	18	6	1	1	13	1	1	2	2		1	7		27	1743	64.61	224.39	102.9	9.9	65.97	25.263	20.902	12.953	88	8.87	5.3976053469300003e-79	616	655	21	449	35	515	300	1.648	1.747	18.342	1.906	423	290	133	625	161.2	3.78	1.42	195.1	4	40.4	877	1198	210	17.57	8.98	0.949	2943	1694	98.3	45	71	5.3976053469300003e-79	3766.7	0.358	0.128	0.371	0.455	3.008	2.067	10.691	7.497	0.531	19.91	0.164	0.005	11.705	1.092	5.3976053469300003e-79	0.042	0.001	0.006	0.002	2	1254	5.3976053469300003e-79
73560	142203.069917	125966.366442	1	54	2	2	21	3	1	1	12	1	1	3	2		2			19	1490	77.75	162.92	80.58	10.6	58.27	23.511	16.986	9.617	187	2.16	5.3976053469300003e-79	515	545	20	237	223	5.3976053469300003e-79	583	1.407	2.186	21.903	1.807	275	126	148	363	268.9	8.76	1.55	93	9.9	31.5	1521	1495	183	14.19	13.84	0.542	2745	2088	91.2	5.3976053469300003e-79	5.3976053469300003e-79	5.3976053469300003e-79	980.45	0.265	0.201	0.213	0.385	0.907	1.979	13.051	5.384	1.009	7.771	0.203	0.003	8.466	0.948	0.002	0.089	0.007	0.006	0.004	2	225	225
73561	59052.357033	39004.892993	1	63	2	2	18	1	1	1	13	4		4	2		1		91	7	1421	55.24	178.2	87.78	12.3	55.36	4.479	26.216	1.263	41	53.17	5.3976053469300003e-79	738	863	5.3976053469300003e-79	1476	5.3976053469300003e-79	5.3976053469300003e-79	5.3976053469300003e-79	1.484	1.72	15.857	2.757	390	389	1	667	218.1	8.3	8.29	236.5	23.5	126	1410	1182	396	17.72	17.73	1.984	797	1445	68.7	24	5.3976053469300003e-79	5.3976053469300003e-79	1029.69	0.017	0.005	0.003	0.008	0.009	0.069	1.506	1.649	0.038	22.673	0.268	5.3976053469300003e-79	1.048	0.062	5.3976053469300003e-79	5.3976053469300003e-79	5.3976053469300003e-79	5.3976053469300003e-79	5.3976053469300003e-79	2	240	5.3976053469300003e-79
73562	49890.828664	5.3976053469300003e-79	1	49	2	1	11	3	1	1	13	1	3	3	1	1	2			17	1785	55.11	189.59	81.75	22.6	93.92	22.155	40.013	23.55	534	12.3	5.3976053469300003e-79	272	355	172	776	300	2339	2101	1.227	1.92	17.119	1.892	458	76	384	511	465.7	1.68	5.3976053469300003e-79	224.4	6	103.9	1156	1021	243	9.52	5.96	1.02	2651	3002	84	144	5.3976053469300003e-79	5.3976053469300003e-79	2412.08	0.241	0.078	0.091	0.18	0.151	1.031	15.065	4.633	2.129	37.405	0.248	0.006	21.036	2.012	5.3976053469300003e-79	0.262	0.005	0.013	0.063	1	1014	5.3976053469300003e-79
73563	31417.217097	40735.782424	4	54	1	2	2	3	1	2	13	4		1	2		2			10																																																																		2	5.3976053469300003e-79	5.3976053469300003e-79
73564	78988.755072	52173.157754	1	54	2	2	12	7	1	1	13	4		1	2		2			21	2585	91.15	300.16	128.23	24.8	91.03	25.989	20.97	37.652	152	16.11	7.43	861	1373	1970	5153	55	1030	843	2.201	2.006	29.342	2.77	543	336	209	780	299.1	3.3	5.3976053469300003e-79	72	5.7	212.4	775	1732	552	20.1	15.54	2.522	2778	2608	131.4	4	67	34.2	2160.8	0.075	0.087	0.875	0.774	5.748	2.286	10.84	4.722	0.334	20.334	0.214	0.025	33.709	3.695	5.3976053469300003e-79	0.127	0.007	0.011	0.011	2	1134	1134
73566	30697.88078	5.3976053469300003e-79	1	49	2	1	3	2	1	1	13	4		3	2		2			14	1580	42.26	226.32	85.92	13.1	41.31	10.911	14.878	13.6	39	5.75	5.3976053469300003e-79	478	491	5.3976053469300003e-79	182	5.3976053469300003e-79	5.3976053469300003e-79	211	1.431	2.188	13.148	1.615	219	87	132	279	196.2	2.73	5.3976053469300003e-79	79.4	5.7	73.9	1125	938	265	7.65	5.93	1.324	2014	3067	48.7	266	11	22.3	4560.78	0.176	0.11	0.192	0.251	1.046	0.935	5.226	2.627	0.195	14.246	0.122	5.3976053469300003e-79	11.887	1.705	5.3976053469300003e-79	5.3976053469300003e-79	5.3976053469300003e-79	0.001	5.3976053469300003e-79	3	2610	2610
73567	44503.03602	5.3976053469300003e-79	1	61	2	1	16	7	1	1	13	1	1	4	2		2			7	2021	38.09	216.59	98.01	7	82.95	28.438	24.3	24.586	81	5.86	5.3976053469300003e-79	9	11	3	19	8	5.3976053469300003e-79	55	1.461	1.133	19.301	1.282	298	145	153	398	256.9	0.79	5.3976053469300003e-79	9.1	0.3	88.5	225	941	189	10.25	3.63	0.839	2017	1382	61.1	43	75	39.1	2434.11	5.3976053469300003e-79	5.3976053469300003e-79	0.026	0.053	0.201	0.491	21.283	5.745	0.207	23.834	0.188	0.037	21.955	2.502	5.3976053469300003e-79	0.081	5.3976053469300003e-79	0.001	0.004	2	720	5.3976053469300003e-79


CREATE TABLE nhanes_2013_2014 (
  "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,
  "dr1sty" DOUBLE,
  "dr1sky" DOUBLE,
  "drqsdiet" DOUBLE,
  "drqsdt1" DOUBLE,
  "drqsdt2" DOUBLE,
  "drqsdt3" DOUBLE,
  "drqsdt4" DOUBLE,
  "drqsdt5" VARCHAR,
  "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
);