CDC 500 Cities

Dozens of Public Health Datapoints Reported by Residents of 500 US Cities

@kaggle.cdc_500_cities

Table List

1 table(309.84 KB)

N 500 Cities Cdc

@kaggle.cdc_500_cities.n_500_cities_cdc

309.84 KB
500 rows
117 columns
Only the first 100 columns are shown

stateabbr StateAbbr	placename PlaceName	placefips PlaceFIPS	population2010 Population2010	access2_crudeprev ACCESS2 CrudePrev	access2_crude95ci ACCESS2 Crude95CI	access2_adjprev ACCESS2 AdjPrev	access2_adj95ci ACCESS2 Adj95CI	arthritis_crudeprev ARTHRITIS CrudePrev	arthritis_crude95ci ARTHRITIS Crude95CI	arthritis_adjprev ARTHRITIS AdjPrev	arthritis_adj95ci ARTHRITIS Adj95CI	binge_crudeprev BINGE CrudePrev	binge_crude95ci BINGE Crude95CI	binge_adjprev BINGE AdjPrev	binge_adj95ci BINGE Adj95CI	bphigh_crudeprev BPHIGH CrudePrev	bphigh_crude95ci BPHIGH Crude95CI	bphigh_adjprev BPHIGH AdjPrev	bphigh_adj95ci BPHIGH Adj95CI	bpmed_crudeprev BPMED CrudePrev	bpmed_crude95ci BPMED Crude95CI	bpmed_adjprev BPMED AdjPrev	bpmed_adj95ci BPMED Adj95CI	cancer_crudeprev CANCER CrudePrev	cancer_crude95ci CANCER Crude95CI	cancer_adjprev CANCER AdjPrev	cancer_adj95ci CANCER Adj95CI	casthma_crudeprev CASTHMA CrudePrev	casthma_crude95ci CASTHMA Crude95CI	casthma_adjprev CASTHMA AdjPrev	casthma_adj95ci CASTHMA Adj95CI	chd_crudeprev CHD CrudePrev	chd_crude95ci CHD Crude95CI	chd_adjprev CHD AdjPrev	chd_adj95ci CHD Adj95CI	checkup_crudeprev CHECKUP CrudePrev	checkup_crude95ci CHECKUP Crude95CI	checkup_adjprev CHECKUP AdjPrev	checkup_adj95ci CHECKUP Adj95CI	cholscreen_crudeprev CHOLSCREEN CrudePrev	cholscreen_crude95ci CHOLSCREEN Crude95CI	cholscreen_adjprev CHOLSCREEN AdjPrev	cholscreen_adj95ci CHOLSCREEN Adj95CI	colon_screen_crudeprev COLON SCREEN CrudePrev	colon_screen_crude95ci COLON SCREEN Crude95CI	colon_screen_adjprev COLON SCREEN AdjPrev	colon_screen_adj95ci COLON SCREEN Adj95CI	copd_crudeprev COPD CrudePrev	copd_crude95ci COPD Crude95CI	copd_adjprev COPD AdjPrev	copd_adj95ci COPD Adj95CI	corem_crudeprev COREM CrudePrev	corem_crude95ci COREM Crude95CI	corem_adjprev COREM AdjPrev	corem_adj95ci COREM Adj95CI	corew_crudeprev COREW CrudePrev	corew_crude95ci COREW Crude95CI	corew_adjprev COREW AdjPrev	corew_adj95ci COREW Adj95CI	csmoking_crudeprev CSMOKING CrudePrev	csmoking_crude95ci CSMOKING Crude95CI	csmoking_adjprev CSMOKING AdjPrev	csmoking_adj95ci CSMOKING Adj95CI	dental_crudeprev DENTAL CrudePrev	dental_crude95ci DENTAL Crude95CI	dental_adjprev DENTAL AdjPrev	dental_adj95ci DENTAL Adj95CI	diabetes_crudeprev DIABETES CrudePrev	diabetes_crude95ci DIABETES Crude95CI	diabetes_adjprev DIABETES AdjPrev	diabetes_adj95ci DIABETES Adj95CI	highchol_crudeprev HIGHCHOL CrudePrev	highchol_crude95ci HIGHCHOL Crude95CI	highchol_adjprev HIGHCHOL AdjPrev	highchol_adj95ci HIGHCHOL Adj95CI	kidney_crudeprev KIDNEY CrudePrev	kidney_crude95ci KIDNEY Crude95CI	kidney_adjprev KIDNEY AdjPrev	kidney_adj95ci KIDNEY Adj95CI	lpa_crudeprev LPA CrudePrev	lpa_crude95ci LPA Crude95CI	lpa_adjprev LPA AdjPrev	lpa_adj95ci LPA Adj95CI	mammouse_crudeprev MAMMOUSE CrudePrev	mammouse_crude95ci MAMMOUSE Crude95CI	mammouse_adjprev MAMMOUSE AdjPrev	mammouse_adj95ci MAMMOUSE Adj95CI	mhlth_crudeprev MHLTH CrudePrev	mhlth_crude95ci MHLTH Crude95CI	mhlth_adjprev MHLTH AdjPrev	mhlth_adj95ci MHLTH Adj95CI	obesity_crudeprev OBESITY CrudePrev	obesity_crude95ci OBESITY Crude95CI	obesity_adjprev OBESITY AdjPrev	obesity_adj95ci OBESITY Adj95CI	paptest_crudeprev PAPTEST CrudePrev	paptest_crude95ci PAPTEST Crude95CI	paptest_adjprev PAPTEST AdjPrev	paptest_adj95ci PAPTEST Adj95CI
AL	Birmingham	107000	212237	22.6	(22.1, 23.0)	21.4	(21.0, 21.8)	32.6	(32.5, 32.8)	32.6	(32.5, 32.8)	11.5	(11.5, 11.6)	11.4	(11.3, 11.4)	45.6	(45.5, 45.8)	45.9	(45.7, 46.1)	81.4	(81.3, 81.5)	70.5	(70.3, 70.6)	6.1	( 6.0, 6.1)	6.1	( 6.1, 6.1)	11.4	(11.3, 11.5)	11.4	(11.3, 11.5)	7.7	( 7.6, 7.8)	7.6	( 7.6, 7.7)	77.3	(77.2, 77.4)	77.3	(77.2, 77.4)	73.3	(73.0, 73.6)	74.4	(74.1, 74.7)	61.1	(60.6, 61.6)	62.7	(62.2, 63.1)	9.5	( 9.3, 9.7)	9.4	( 9.3, 9.6)	29.9	(29.2, 30.5)	30.3	(29.6, 30.9)	27.3	(26.7, 27.9)	27.9	(27.3, 28.4)	21.9	(21.5, 22.3)	22	(21.6, 22.3)	49.3	(48.7, 49.8)	49.1	(48.6, 49.6)	16.2	(16.0, 16.3)	16.1	(16.0, 16.2)	39.7	(39.5, 39.9)	35.4	(35.3, 35.6)	3.3	( 3.3, 3.3)	3.3	( 3.3, 3.3)	31.5	(31.2, 31.9)	31.7	(31.3, 32.1)	76.8	(76.4, 77.2)	79.7	(79.3, 80.1)	17	(16.8, 17.2)	17	(16.7, 17.2)	31.7	(31.6, 31.7)	39	(38.8, 39.1)	78.6	(78.2, 78.9)	80.1	(79.7, 80.4)
AL	Hoover	135896	81619	10.6	(10.2, 11.1)	10.2	( 9.7, 10.7)	26.3	(26.0, 26.6)	25.3	(25.0, 25.6)	15.4	(15.3, 15.5)	15.7	(15.5, 15.8)	32.9	(32.6, 33.2)	31.9	(31.6, 32.2)	78.1	(77.8, 78.3)	63.8	(63.6, 64.1)	7	( 7.0, 7.1)	6.8	( 6.7, 6.9)	8.2	( 8.0, 8.3)	8.2	( 8.0, 8.3)	5.5	( 5.4, 5.7)	5.4	( 5.2, 5.5)	74.1	(73.9, 74.3)	73.9	(73.7, 74.1)	78.1	(77.6, 78.5)	77	(76.6, 77.5)	72.4	(71.7, 73.1)	73.6	(72.9, 74.2)	5.5	( 5.3, 5.7)	5.3	( 5.1, 5.5)	41.7	(40.2, 43.1)	42.3	(40.8, 43.7)	41.5	(40.2, 42.7)	42.2	(40.9, 43.5)	13.3	(12.7, 13.8)	13.2	(12.6, 13.7)	72.7	(72.0, 73.4)	72.7	(71.9, 73.4)	8	( 7.9, 8.2)	7.7	( 7.6, 7.8)	39.5	(39.2, 39.8)	35	(34.7, 35.2)	2.3	( 2.2, 2.3)	2.2	( 2.2, 2.3)	18	(17.5, 18.5)	17.8	(17.3, 18.3)	79.7	(78.9, 80.4)	82.1	(81.4, 82.9)	10.8	(10.5, 11.1)	10.8	(10.5, 11.1)	21.1	(21.1, 21.3)	24.7	(24.4, 25.0)	85.8	(85.3, 86.2)	86.3	(85.8, 86.8)
AL	Huntsville	137000	180105	17.4	(16.9, 17.8)	16.3	(15.9, 16.7)	30	(29.8, 30.2)	29.4	(29.2, 29.6)	12.2	(12.1, 12.3)	12.3	(12.2, 12.4)	37.3	(37.1, 37.6)	36.7	(36.5, 36.9)	79.1	(78.9, 79.2)	66.9	(66.7, 67.1)	6.8	( 6.8, 6.9)	6.5	( 6.5, 6.6)	9.7	( 9.6, 9.8)	9.6	( 9.5, 9.7)	7	( 6.9, 7.1)	6.7	( 6.6, 6.8)	71.2	(71.0, 71.4)	70.8	(70.6, 70.9)	75.5	(75.2, 75.9)	76.2	(75.8, 76.5)	65	(64.5, 65.5)	65.8	(65.3, 66.3)	7.7	( 7.6, 7.9)	7.5	( 7.4, 7.7)	39.5	(38.6, 40.4)	39.7	(38.8, 40.6)	36.6	(35.9, 37.5)	36.9	(36.1, 37.7)	20.9	(20.4, 21.4)	21.3	(20.8, 21.8)	60.7	(60.1, 61.2)	60.5	(60.0, 61.1)	11	(10.9, 11.1)	10.7	(10.5, 10.8)	40.3	(40.1, 40.6)	35.8	(35.6, 35.9)	2.7	( 2.6, 2.7)	2.6	( 2.6, 2.6)	25	(24.5, 25.4)	24.9	(24.5, 25.3)	76.9	(76.4, 77.4)	80	(79.5, 80.5)	14	(13.7, 14.2)	14	(13.8, 14.2)	26.4	(26.2, 26.4)	32	(31.8, 32.2)	82.4	(82.0, 82.7)	83.5	(83.1, 83.9)
AL	Mobile	150000	195111	20	(19.6, 20.4)	19.1	(18.7, 19.5)	33.1	(32.9, 33.2)	31.8	(31.7, 32.0)	12.5	(12.4, 12.6)	12.8	(12.7, 12.8)	44.1	(43.9, 44.2)	43	(42.8, 43.2)	81.1	(81.0, 81.2)	69.3	(69.1, 69.4)	6.9	( 6.8, 6.9)	6.5	( 6.4, 6.5)	10.7	(10.6, 10.8)	10.7	(10.6, 10.8)	8.2	( 8.1, 8.2)	7.6	( 7.5, 7.7)	73	(72.9, 73.1)	72.4	(72.3, 72.5)	73.2	(72.9, 73.5)	73.2	(72.9, 73.5)	61.6	(61.2, 62.1)	62.7	(62.3, 63.1)	9.1	( 8.9, 9.2)	8.7	( 8.5, 8.8)	33.9	(33.2, 34.6)	34.3	(33.6, 35.0)	31.6	(31.0, 32.2)	32.2	(31.6, 32.9)	21.5	(21.2, 21.9)	22	(21.6, 22.3)	52.9	(52.4, 53.4)	52.6	(52.1, 53.1)	14.5	(14.3, 14.6)	13.8	(13.7, 13.9)	43.1	(42.9, 43.3)	37.6	(37.5, 37.7)	3.2	( 3.1, 3.2)	3.1	( 3.0, 3.1)	27.6	(27.3, 28.0)	27.4	(27.1, 27.8)	76	(75.6, 76.5)	80.1	(79.7, 80.5)	15.7	(15.5, 15.9)	15.8	(15.6, 16.0)	30.8	(30.7, 30.9)	37.6	(37.4, 37.8)	80.8	(80.5, 81.1)	81.9	(81.6, 82.2)
AL	Montgomery	151000	205764	19.7	(19.2, 20.2)	18.5	(18.1, 19.0)	31	(30.8, 31.2)	31.4	(31.2, 31.6)	12.5	(12.4, 12.5)	12.2	(12.2, 12.3)	40.1	(39.9, 40.3)	40.6	(40.4, 40.8)	80.6	(80.4, 80.7)	70.3	(70.1, 70.5)	6.2	( 6.2, 6.3)	6.4	( 6.3, 6.4)	10.8	(10.7, 11.0)	10.8	(10.7, 10.9)	7.1	( 7.0, 7.2)	7.2	( 7.1, 7.3)	75	(74.9, 75.2)	75.2	(75.0, 75.3)	74	(73.6, 74.3)	75.1	(74.8, 75.4)	62.1	(61.6, 62.6)	63.3	(62.7, 63.9)	8.6	( 8.5, 8.8)	8.6	( 8.5, 8.8)	31.6	(30.9, 32.4)	32.1	(31.3, 32.9)	27.2	(26.5, 27.9)	27.7	(27.0, 28.3)	21.4	(20.9, 21.8)	21.3	(20.9, 21.8)	57.1	(56.6, 57.7)	57.1	(56.6, 57.7)	13.2	(13.0, 13.3)	13.3	(13.1, 13.4)	40.7	(40.5, 40.9)	36.9	(36.7, 37.0)	3	( 3.0, 3.0)	3.1	( 3.0, 3.1)	27.7	(27.3, 28.1)	27.9	(27.5, 28.3)	77.1	(76.5, 77.6)	80.2	(79.6, 80.7)	15.6	(15.3, 15.8)	15.5	(15.2, 15.7)	30.2	(30.0, 30.3)	36.8	(36.6, 37.1)	81.7	(81.3, 82.1)	83	(82.7, 83.4)
AL	Tuscaloosa	177256	90468	20.3	(19.4, 21.4)	18.5	(17.9, 19.2)	24.8	(24.6, 25.0)	32.3	(32.1, 32.6)	14.4	(14.1, 14.6)	12.1	(11.9, 12.2)	31.7	(31.4, 32.1)	40	(39.7, 40.3)	74.6	(74.2, 75.0)	69	(68.8, 69.3)	5	( 4.9, 5.0)	6.5	( 6.4, 6.6)	11.2	(11.0, 11.5)	10.9	(10.7, 11.1)	5.6	( 5.5, 5.7)	7.4	( 7.2, 7.5)	71.2	(70.7, 71.6)	74.3	(74.1, 74.5)	63.4	(62.2, 64.4)	74.4	(73.9, 74.9)	63.1	(62.3, 63.8)	64.2	(63.4, 64.9)	7.6	( 7.4, 7.8)	9.1	( 8.9, 9.4)	35.5	(34.2, 36.8)	36	(34.7, 37.3)	33.2	(32.2, 34.2)	33.7	(32.7, 34.8)	22.9	(21.9, 23.9)	23.2	(22.6, 23.9)	57.2	(55.9, 58.3)	56.4	(55.6, 57.2)	10.2	(10.0, 10.3)	13.6	(13.4, 13.8)	38	(37.5, 38.6)	38.7	(38.5, 38.9)	2.3	( 2.3, 2.4)	2.9	( 2.9, 3.0)	25.8	(25.1, 26.5)	28.6	(28.0, 29.2)	77.1	(76.4, 77.8)	79.8	(79.1, 80.5)	16.3	(15.9, 16.8)	15.9	(15.5, 16.2)	31.8	(31.6, 31.9)	38.5	(38.2, 38.8)	77.2	(76.3, 78.0)	81	(80.4, 81.5)
AK	Anchorage	203000	291826	15.5	(15.2, 15.8)	14.5	(14.3, 14.8)	19.3	(19.2, 19.4)	21.3	(21.2, 21.4)	21.6	(21.5, 21.7)	20.2	(20.1, 20.3)	27.8	(27.6, 27.9)	30.2	(30.1, 30.4)	62.1	(62.0, 62.3)	49	(48.8, 49.1)	5.3	( 5.2, 5.3)	6.2	( 6.1, 6.2)	8.7	( 8.6, 8.8)	8.6	( 8.5, 8.6)	4.2	( 4.1, 4.2)	5	( 4.9, 5.1)	58.9	(58.8, 59.1)	60.7	(60.6, 60.8)	68	(67.7, 68.3)	70.2	(69.9, 70.4)	57.5	(56.9, 58.0)	60.3	(59.9, 60.7)	4.7	( 4.6, 4.8)	5	( 5.0, 5.1)	32.4	(31.7, 33.1)	33.4	(32.8, 34.1)	28.8	(28.2, 29.4)	29	(28.4, 29.6)	19.2	(18.9, 19.6)	18.3	(18.0, 18.6)	65.8	(65.3, 66.2)	66	(65.5, 66.4)	7.4	( 7.3, 7.5)	8.2	( 8.1, 8.2)	35.9	(35.7, 36.0)	32.9	(32.8, 33.1)	2.1	( 2.0, 2.1)	2.3	( 2.3, 2.3)	18.5	(18.2, 18.7)	19.2	(19.0, 19.5)	68.9	(68.3, 69.4)	70.4	(69.9, 70.9)	9.8	( 9.6, 9.9)	9.4	( 9.2, 9.5)	22.3	(22.3, 22.4)	27.7	(27.5, 27.9)	78.3	(78.0, 78.7)	79.9	(79.6, 80.2)
AZ	Avondale	404720	76238	23.4	(22.6, 24.1)	21.4	(20.8, 22.1)	18.5	(18.3, 18.6)	23	(22.8, 23.2)	16.6	(16.5, 16.8)	14.7	(14.6, 14.8)	23.3	(23.1, 23.5)	28.4	(28.1, 28.6)	66.5	(66.2, 66.8)	56	(55.7, 56.2)	4.1	( 4.0, 4.1)	5.5	( 5.5, 5.6)	10	( 9.9, 10.2)	9.9	( 9.8, 10.0)	4.3	( 4.2, 4.3)	6.1	( 6.0, 6.2)	61.8	(61.5, 62.0)	64.8	(64.6, 65.0)	66.1	(65.5, 66.6)	70.7	(70.3, 71.2)	56.6	(55.8, 57.4)	59	(58.3, 59.8)	5.5	( 5.3, 5.6)	6.5	( 6.3, 6.7)	28.3	(27.3, 29.3)	29.1	(28.1, 30.1)	27.5	(26.7, 28.4)	27.5	(26.7, 28.4)	19.7	(19.2, 20.3)	18.5	(18.1, 19.0)	56.4	(55.6, 57.2)	56.7	(55.9, 57.4)	8.7	( 8.6, 8.8)	11	(10.9, 11.2)	34.1	(33.9, 34.4)	33.9	(33.7, 34.1)	2.9	( 2.8, 2.9)	3.6	( 3.6, 3.7)	22.6	(22.1, 23.1)	24.3	(23.9, 24.8)	75.9	(75.3, 76.6)	77.2	(76.6, 78.0)	13.1	(12.8, 13.4)	12.6	(12.3, 12.8)	23.4	(23.2, 23.5)	30.1	(29.9, 30.3)	79.7	(79.2, 80.3)	80.3	(79.9, 80.9)
AZ	Chandler	412000	236123	13.1	(12.8, 13.5)	12.3	(12.0, 12.7)	19.4	(19.3, 19.5)	21.2	(21.1, 21.4)	17	(16.9, 17.1)	16.2	(16.1, 16.2)	24	(23.8, 24.1)	26	(25.9, 26.2)	69.1	(68.9, 69.3)	54.8	(54.6, 54.9)	5.2	( 5.2, 5.2)	6	( 6.0, 6.1)	9.2	( 9.2, 9.3)	9.1	( 9.1, 9.2)	4.2	( 4.1, 4.2)	5	( 4.9, 5.1)	64.6	(64.5, 64.7)	66.1	(65.9, 66.2)	71.8	(71.5, 72.1)	72.8	(72.5, 73.1)	64.8	(64.3, 65.2)	67	(66.5, 67.4)	4.9	( 4.8, 5.0)	5.3	( 5.2, 5.4)	33.8	(32.9, 34.6)	34.5	(33.6, 35.3)	34.8	(34.0, 35.6)	35.2	(34.3, 36.0)	16.1	(15.7, 16.4)	15.3	(15.0, 15.6)	67.7	(67.2, 68.2)	68	(67.5, 68.4)	7.1	( 7.0, 7.1)	7.7	( 7.7, 7.8)	35.5	(35.3, 35.7)	33.1	(32.9, 33.2)	2.8	( 2.8, 2.8)	3.1	( 3.1, 3.2)	17	(16.7, 17.2)	17.4	(17.1, 17.8)	78.6	(78.2, 79.0)	80.3	(79.9, 80.7)	10.5	(10.4, 10.7)	10.2	(10.0, 10.3)	19.9	(19.8, 20.0)	24.5	(24.3, 24.6)	83	(82.6, 83.3)	83.5	(83.2, 83.8)
AZ	Gilbert	427400	208453	10.5	(10.2, 10.8)	9.7	( 9.5, 10.0)	18.2	(18.0, 18.3)	20.8	(20.7, 21.0)	18.5	(18.4, 18.6)	17.2	(17.1, 17.2)	22.2	(22.0, 22.4)	25.3	(25.1, 25.5)	67.2	(66.9, 67.4)	54.2	(54.0, 54.3)	5	( 4.9, 5.0)	6.1	( 6.1, 6.2)	9.1	( 9.0, 9.2)	9	( 8.9, 9.0)	3.7	( 3.6, 3.7)	4.8	( 4.7, 4.9)	64.2	(64.1, 64.4)	66.3	(66.2, 66.4)	72.3	(71.9, 72.7)	73.8	(73.4, 74.1)	66.5	(66.0, 67.0)	69	(68.5, 69.4)	4.5	( 4.4, 4.6)	4.9	( 4.8, 5.1)	34.6	(33.7, 35.5)	35.7	(34.8, 36.5)	36.7	(35.8, 37.6)	36.9	(36.1, 37.7)	15.8	(15.4, 16.2)	14.7	(14.3, 15.1)	70.8	(70.2, 71.3)	71.2	(70.6, 71.7)	6.1	( 6.0, 6.2)	7.1	( 7.0, 7.1)	34.1	(33.9, 34.2)	32.8	(32.6, 32.9)	2.6	( 2.6, 2.6)	3	( 3.0, 3.1)	14.9	(14.6, 15.2)	15.6	(15.3, 15.9)	79.6	(79.1, 80.1)	81.2	(80.7, 81.7)	10.1	( 9.9, 10.3)	9.6	( 9.5, 9.8)	19.2	(19.1, 19.3)	23.5	(23.3, 23.7)	84.7	(84.4, 85.0)	85	(84.6, 85.3)


CREATE TABLE n_500_cities_cdc (
  "stateabbr" VARCHAR,
  "placename" VARCHAR,
  "placefips" BIGINT,
  "population2010" BIGINT,
  "access2_crudeprev" DOUBLE,
  "access2_crude95ci" VARCHAR,
  "access2_adjprev" DOUBLE,
  "access2_adj95ci" VARCHAR,
  "arthritis_crudeprev" DOUBLE,
  "arthritis_crude95ci" VARCHAR,
  "arthritis_adjprev" DOUBLE,
  "arthritis_adj95ci" VARCHAR,
  "binge_crudeprev" DOUBLE,
  "binge_crude95ci" VARCHAR,
  "binge_adjprev" DOUBLE,
  "binge_adj95ci" VARCHAR,
  "bphigh_crudeprev" DOUBLE,
  "bphigh_crude95ci" VARCHAR,
  "bphigh_adjprev" DOUBLE,
  "bphigh_adj95ci" VARCHAR,
  "bpmed_crudeprev" DOUBLE,
  "bpmed_crude95ci" VARCHAR,
  "bpmed_adjprev" DOUBLE,
  "bpmed_adj95ci" VARCHAR,
  "cancer_crudeprev" DOUBLE,
  "cancer_crude95ci" VARCHAR,
  "cancer_adjprev" DOUBLE,
  "cancer_adj95ci" VARCHAR,
  "casthma_crudeprev" DOUBLE,
  "casthma_crude95ci" VARCHAR,
  "casthma_adjprev" DOUBLE,
  "casthma_adj95ci" VARCHAR,
  "chd_crudeprev" DOUBLE,
  "chd_crude95ci" VARCHAR,
  "chd_adjprev" DOUBLE,
  "chd_adj95ci" VARCHAR,
  "checkup_crudeprev" DOUBLE,
  "checkup_crude95ci" VARCHAR,
  "checkup_adjprev" DOUBLE,
  "checkup_adj95ci" VARCHAR,
  "cholscreen_crudeprev" DOUBLE,
  "cholscreen_crude95ci" VARCHAR,
  "cholscreen_adjprev" DOUBLE,
  "cholscreen_adj95ci" VARCHAR,
  "colon_screen_crudeprev" DOUBLE,
  "colon_screen_crude95ci" VARCHAR,
  "colon_screen_adjprev" DOUBLE,
  "colon_screen_adj95ci" VARCHAR,
  "copd_crudeprev" DOUBLE,
  "copd_crude95ci" VARCHAR,
  "copd_adjprev" DOUBLE,
  "copd_adj95ci" VARCHAR,
  "corem_crudeprev" DOUBLE,
  "corem_crude95ci" VARCHAR,
  "corem_adjprev" DOUBLE,
  "corem_adj95ci" VARCHAR,
  "corew_crudeprev" DOUBLE,
  "corew_crude95ci" VARCHAR,
  "corew_adjprev" DOUBLE,
  "corew_adj95ci" VARCHAR,
  "csmoking_crudeprev" DOUBLE,
  "csmoking_crude95ci" VARCHAR,
  "csmoking_adjprev" DOUBLE,
  "csmoking_adj95ci" VARCHAR,
  "dental_crudeprev" DOUBLE,
  "dental_crude95ci" VARCHAR,
  "dental_adjprev" DOUBLE,
  "dental_adj95ci" VARCHAR,
  "diabetes_crudeprev" DOUBLE,
  "diabetes_crude95ci" VARCHAR,
  "diabetes_adjprev" DOUBLE,
  "diabetes_adj95ci" VARCHAR,
  "highchol_crudeprev" DOUBLE,
  "highchol_crude95ci" VARCHAR,
  "highchol_adjprev" DOUBLE,
  "highchol_adj95ci" VARCHAR,
  "kidney_crudeprev" DOUBLE,
  "kidney_crude95ci" VARCHAR,
  "kidney_adjprev" DOUBLE,
  "kidney_adj95ci" VARCHAR,
  "lpa_crudeprev" DOUBLE,
  "lpa_crude95ci" VARCHAR,
  "lpa_adjprev" DOUBLE,
  "lpa_adj95ci" VARCHAR,
  "mammouse_crudeprev" DOUBLE,
  "mammouse_crude95ci" VARCHAR,
  "mammouse_adjprev" DOUBLE,
  "mammouse_adj95ci" VARCHAR,
  "mhlth_crudeprev" DOUBLE,
  "mhlth_crude95ci" VARCHAR,
  "mhlth_adjprev" DOUBLE,
  "mhlth_adj95ci" VARCHAR,
  "obesity_crudeprev" DOUBLE,
  "obesity_crude95ci" VARCHAR,
  "obesity_adjprev" DOUBLE,
  "obesity_adj95ci" VARCHAR,
  "paptest_crudeprev" DOUBLE,
  "paptest_crude95ci" VARCHAR,
  "paptest_adjprev" DOUBLE,
  "paptest_adj95ci" VARCHAR
);