countyhealth16 | R Documentation |
This data set provides a variety of health indicators for each US county.
data('countyhealth16')
A data.frame with 3191 rows (Counties) and 362 columns (variables)
[1] "STATECODE"
[2] "COUNTYCODE"
[3] "State"
[4] "County"
[5] "County.that.was.not.ranked"
[6] "Premature.death.Value"
[7] "Premature.death.Numerator"
[8] "Premature.death.Denominator"
[9] "Premature.death.Lower.Confidence.Interval"
[10] "Premature.death.Upper.Confidence.Interval"
[11] "Poor.or.fair.health.Value"
[12] "Poor.or.fair.health.Numerator"
[13] "Poor.or.fair.health.Denominator"
[14] "Poor.or.fair.health.Lower.Confidence.Interval"
[15] "Poor.or.fair.health.Upper.Confidence.Interval"
[16] "Poor.physical.health.days.Value"
[17] "Poor.physical.health.days.Numerator"
[18] "Poor.physical.health.days.Denominator"
[19] "Poor.physical.health.days.Lower.Confidence.Interval"
[20] "Poor.physical.health.days.Upper.Confidence.Interval"
[21] "Poor.mental.health.days.Value"
[22] "Poor.mental.health.days.Numerator"
[23] "Poor.mental.health.days.Denominator"
[24] "Poor.mental.health.days.Lower.Confidence.Interval"
[25] "Poor.mental.health.days.Upper.Confidence.Interval"
[26] "Low.birthweight.Value"
[27] "Low.birthweight.Numerator"
[28] "Low.birthweight.Denominator"
[29] "Low.birthweight.Lower.Confidence.Interval"
[30] "Low.birthweight.Upper.Confidence.Interval"
[31] "Adult.smoking.Value"
[32] "Adult.smoking.Numerator"
[33] "Adult.smoking.Denominator"
[34] "Adult.smoking.Lower.Confidence.Interval"
[35] "Adult.smoking.Upper.Confidence.Interval"
[36] "Adult.obesity.Value"
[37] "Adult.obesity.Numerator"
[38] "Adult.obesity.Denominator"
[39] "Adult.obesity.Lower.Confidence.Interval"
[40] "Adult.obesity.Upper.Confidence.Interval"
[41] "Food.environment.index.Value"
[42] "Food.environment.index.Numerator"
[43] "Food.environment.index.Denominator"
[44] "Food.environment.index.Lower.Confidence.Interval"
[45] "Food.environment.index.Upper.Confidence.Interval"
[46] "Physical.inactivity.Value"
[47] "Physical.inactivity.Numerator"
[48] "Physical.inactivity.Denominator"
[49] "Physical.inactivity.Lower.Confidence.Interval"
[50] "Physical.inactivity.Upper.Confidence.Interval"
[51] "Access.to.exercise.opportunities.Value"
[52] "Access.to.exercise.opportunities.Numerator"
[53] "Access.to.exercise.opportunities.Denominator"
[54] "Access.to.exercise.opportunities.Lower.Confidence.Interval"
[55] "Access.to.exercise.opportunities.Upper.Confidence.Interval"
[56] "Excessive.drinking.Value"
[57] "Excessive.drinking.Numerator"
[58] "Excessive.drinking.Denominator"
[59] "Excessive.drinking.Lower.Confidence.Interval"
[60] "Excessive.drinking.Upper.Confidence.Interval"
[61] "Alcohol.impaired.driving.deaths.Value"
[62] "Alcohol.impaired.driving.deaths.Numerator"
[63] "Alcohol.impaired.driving.deaths.Denominator"
[64] "Alcohol.impaired.driving.deaths.Lower.Confidence.Interval"
[65] "Alcohol.impaired.driving.deaths.Upper.Confidence.Interval"
[66] "Sexually.transmitted.infections.Value"
[67] "Sexually.transmitted.infections.Numerator"
[68] "Sexually.transmitted.infections.Denominator"
[69] "Sexually.transmitted.infections.Lower.Confidence.Interval"
[70] "Sexually.transmitted.infections.Upper.Confidence.Interval"
[71] "Teen.births.Value"
[72] "Teen.births.Numerator"
[73] "Teen.births.Denominator"
[74] "Teen.births.Lower.Confidence.Interval"
[75] "Teen.births.Upper.Confidence.Interval"
[76] "Uninsured.Value"
[77] "Uninsured.Numerator"
[78] "Uninsured.Denominator"
[79] "Uninsured.Lower.Confidence.Interval"
[80] "Uninsured.Upper.Confidence.Interval"
[81] "Primary.care.physicians.Value"
[82] "Primary.care.physicians.Ratio"
[83] "Primary.care.physicians.Numerator"
[84] "Primary.care.physicians.Denominator"
[85] "Primary.care.physicians.Lower.Confidence.Interval"
[86] "Primary.care.physicians.Upper.Confidence.Interval"
[87] "Dentists.Value"
[88] "Dentists.Ratio"
[89] "Dentists.Numerator"
[90] "Dentists.Denominator"
[91] "Dentists.Lower.Confidence.Interval"
[92] "Dentists.Upper.Confidence.Interval"
[93] "Mental.health.providers.Value"
[94] "Mental.health.providers.Ratio"
[95] "Mental.health.providers.Numerator"
[96] "Mental.health.providers.Denominator"
[97] "Mental.health.providers.Lower.Confidence.Interval"
[98] "Mental.health.providers.Upper.Confidence.Interval"
[99] "Preventable.hospital.stays.Value"
[100] "Preventable.hospital.stays.Numerator"
[101] "Preventable.hospital.stays.Denominator"
[102] "Preventable.hospital.stays.Lower.Confidence.Interval"
[103] "Preventable.hospital.stays.Upper.Confidence.Interval"
[104] "Diabetic.screening.Value"
[105] "Diabetic.screening.Numerator"
[106] "Diabetic.screening.Denominator"
[107] "Diabetic.screening.Lower.Confidence.Interval"
[108] "Diabetic.screening.Upper.Confidence.Interval"
[109] "Mammography.screening.Value"
[110] "Mammography.screening.Numerator"
[111] "Mammography.screening.Denominator"
[112] "Mammography.screening.Lower.Confidence.Interval"
[113] "Mammography.screening.Upper.Confidence.Interval"
[114] "High.school.graduation.Value"
[115] "High.school.graduation.Numerator"
[116] "High.school.graduation.Denominator"
[117] "High.school.graduation.Lower.Confidence.Interval"
[118] "High.school.graduation.Upper.Confidence.Interval"
[119] "Some.college.Value"
[120] "Some.college.Numerator"
[121] "Some.college.Denominator"
[122] "Some.college.Lower.Confidence.Interval"
[123] "Some.college.Upper.Confidence.Interval"
[124] "Unemployment.Value"
[125] "Unemployment.Numerator"
[126] "Unemployment.Denominator"
[127] "Unemployment.Lower.Confidence.Interval"
[128] "Unemployment.Upper.Confidence.Interval"
[129] "Children.in.poverty.Value"
[130] "Children.in.poverty.Numerator"
[131] "Children.in.poverty.Denominator"
[132] "Children.in.poverty.Lower.Confidence.Interval"
[133] "Children.in.poverty.Upper.Confidence.Interval"
[134] "Income.inequality.Value"
[135] "Income.inequality.Numerator"
[136] "Income.inequality.Denominator"
[137] "Income.inequality.Lower.Confidence.Interval"
[138] "Income.inequality.Upper.Confidence.Interval"
[139] "Children.in.single.parent.households.Value"
[140] "Children.in.single.parent.households.Numerator"
[141] "Children.in.single.parent.households.Denominator"
[142] "Children.in.single.parent.households.Lower.Confidence.Interval"
[143] "Children.in.single.parent.households.Upper.Confidence.Interval"
[144] "Social.associations.Value"
[145] "Social.associations.Numerator"
[146] "Social.associations.Denominator"
[147] "Social.associations.Lower.Confidence.Interval"
[148] "Social.associations.Upper.Confidence.Interval"
[149] "Violent.crime.Value"
[150] "Violent.crime.Numerator"
[151] "Violent.crime.Denominator"
[152] "Violent.crime.Lower.Confidence.Interval"
[153] "Violent.crime.Upper.Confidence.Interval"
[154] "Injury.deaths.Value"
[155] "Injury.deaths.Numerator"
[156] "Injury.deaths.Denominator"
[157] "Injury.deaths.Lower.Confidence.Interval"
[158] "Injury.deaths.Upper.Confidence.Interval"
[159] "Air.pollution...particulate.matter.Value"
[160] "Air.pollution...particulate.matter.Numerator"
[161] "Air.pollution...particulate.matter.Denominator"
[162] "Air.pollution...particulate.matter.Lower.Confidence.Interval"
[163] "Air.pollution...particulate.matter.Upper.Confidence.Interval"
[164] "Drinking.water.violations.Value"
[165] "Drinking.water.violations.Numerator"
[166] "Drinking.water.violations.Denominator"
[167] "Drinking.water.violations.Lower.Confidence.Interval"
[168] "Drinking.water.violations.Upper.Confidence.Interval"
[169] "Severe.housing.problems.Value"
[170] "Severe.housing.problems.Numerator"
[171] "Severe.housing.problems.Denominator"
[172] "Severe.housing.problems.Lower.Confidence.Interval"
[173] "Severe.housing.problems.Upper.Confidence.Interval"
[174] "Driving.alone.to.work.Value"
[175] "Driving.alone.to.work.Numerator"
[176] "Driving.alone.to.work.Denominator"
[177] "Driving.alone.to.work.Lower.Confidence.Interval"
[178] "Driving.alone.to.work.Upper.Confidence.Interval"
[179] "Long.commute...driving.alone.Value"
[180] "Long.commute...driving.alone.Numerator"
[181] "Long.commute...driving.alone.Denominator"
[182] "Long.commute...driving.alone.Lower.Confidence.Interval"
[183] "Long.commute...driving.alone.Upper.Confidence.Interval"
[184] "Premature.age.adjusted.mortality.Value"
[185] "Premature.age.adjusted.mortality.Numerator"
[186] "Premature.age.adjusted.mortality.Denominator"
[187] "Premature.age.adjusted.mortality.Lower.Confidence.Interval"
[188] "Premature.age.adjusted.mortality.Upper.Confidence.Interval"
[189] "Child.mortality.Value"
[190] "Child.mortality.Numerator"
[191] "Child.mortality.Denominator"
[192] "Child.mortality.Lower.Confidence.Interval"
[193] "Child.mortality.Upper.Confidence.Interval"
[194] "Infant.mortality.Value"
[195] "Infant.mortality.Numerator"
[196] "Infant.mortality.Denominator"
[197] "Infant.mortality.Lower.Confidence.Interval"
[198] "Infant.mortality.Upper.Confidence.Interval"
[199] "Frequent.physical.distress.Value"
[200] "Frequent.physical.distress.Numerator"
[201] "Frequent.physical.distress.Denominator"
[202] "Frequent.physical.distress.Lower.Confidence.Interval"
[203] "Frequent.physical.distress.Upper.Confidence.Interval"
[204] "Frequent.mental.distress.Value"
[205] "Frequent.mental.distress.Numerator"
[206] "Frequent.mental.distress.Denominator"
[207] "Frequent.mental.distress.Lower.Confidence.Interval"
[208] "Frequent.mental.distress.Upper.Confidence.Interval"
[209] "Diabetes.Value"
[210] "Diabetes.Numerator"
[211] "Diabetes.Denominator"
[212] "Diabetes.Lower.Confidence.Interval"
[213] "Diabetes.Upper.Confidence.Interval"
[214] "HIV.prevalence.rate.Value"
[215] "HIV.prevalence.rate.Numerator"
[216] "HIV.prevalence.rate.Denominator"
[217] "HIV.prevalence.rate.Lower.Confidence.Interval"
[218] "HIV.prevalence.rate.Upper.Confidence.Interval"
[219] "Food.insecurity.Value"
[220] "Food.insecurity.Numerator"
[221] "Food.insecurity.Denominator"
[222] "Food.insecurity.Lower.Confidence.Interval"
[223] "Food.insecurity.Upper.Confidence.Interval"
[224] "Limited.access.to.healthy.foods.Value"
[225] "Limited.access.to.healthy.foods.Numerator"
[226] "Limited.access.to.healthy.foods.Denominator"
[227] "Limited.access.to.healthy.foods.Lower.Confidence.Interval"
[228] "Limited.access.to.healthy.foods.Upper.Confidence.Interval"
[229] "Drug.Overdose.Deaths.Value"
[230] "Drug.Overdose.Deaths.Numerator"
[231] "Drug.Overdose.Deaths.Denominator"
[232] "Drug.Overdose.Deaths.Lower.Confidence.Interval"
[233] "Drug.Overdose.Deaths.Upper.Confidence.Interval"
[234] "Drug.Overdose.Deaths..Modeled.Value"
[235] "Drug.Overdose.Deaths..Modeled.Numerator"
[236] "Drug.Overdose.Deaths..Modeled.Denominator"
[237] "Drug.Overdose.Deaths..Modeled.Lower.Confidence.Interval"
[238] "Drug.Overdose.Deaths..Modeled.Upper.Confidence.Interval"
[239] "Motor.vehicle.crash.deaths.Value"
[240] "Motor.vehicle.crash.deaths.Numerator"
[241] "Motor.vehicle.crash.deaths.Denominator"
[242] "Motor.vehicle.crash.deaths.Lower.Confidence.Interval"
[243] "Motor.vehicle.crash.deaths.Upper.Confidence.Interval"
[244] "Insufficient.sleep.Value"
[245] "Insufficient.sleep.Numerator"
[246] "Insufficient.sleep.Denominator"
[247] "Insufficient.sleep.Lower.Confidence.Interval"
[248] "Insufficient.sleep.Upper.Confidence.Interval"
[249] "Uninsured.adults.Value"
[250] "Uninsured.adults.Numerator"
[251] "Uninsured.adults.Denominator"
[252] "Uninsured.adults.Lower.Confidence.Interval"
[253] "Uninsured.adults.Upper.Confidence.Interval"
[254] "Uninsured.children.Value"
[255] "Uninsured.children.Numerator"
[256] "Uninsured.children.Denominator"
[257] "Uninsured.children.Lower.Confidence.Interval"
[258] "Uninsured.children.Upper.Confidence.Interval"
[259] "Health.care.costs.Value"
[260] "Health.care.costs.Numerator"
[261] "Health.care.costs.Denominator"
[262] "Health.care.costs.Lower.Confidence.Interval"
[263] "Health.care.costs.Upper.Confidence.Interval"
[264] "Other.primary.care.providers.Value"
[265] "Other.primary.care.providers.Ratio"
[266] "Other.primary.care.providers.Numerator"
[267] "Other.primary.care.providers.Denominator"
[268] "Other.primary.care.providers.Lower.Confidence.Interval"
[269] "Other.primary.care.providers.Upper.Confidence.Interval"
[270] "Median.household.income.Value"
[271] "Median.household.income.Numerator"
[272] "Median.household.income.Denominator"
[273] "Median.household.income.Lower.Confidence.Interval"
[274] "Median.household.income.Upper.Confidence.Interval"
[275] "Children.eligible.for.free.lunch.Value"
[276] "Children.eligible.for.free.lunch.Numerator"
[277] "Children.eligible.for.free.lunch.Denominator"
[278] "Children.eligible.for.free.lunch.Lower.Confidence.Interval"
[279] "Children.eligible.for.free.lunch.Upper.Confidence.Interval"
[280] "Residential.segregation...Black.White.Value"
[281] "Residential.segregation...Black.White.Numerator"
[282] "Residential.segregation...Black.White.Denominator"
[283] "Residential.segregation...Black.White.Lower.Confidence.Interval"
[284] "Residential.segregation...Black.White.Upper.Confidence.Interval"
[285] "Residential.segregation.non.White.White.Value"
[286] "Residential.segregation.non.White.White.Numerator"
[287] "Residential.segregation.non.White.White.Denominator"
[288] "Residential.segregation.non.White.White.Lower.Confidence.Interval"
[289] "Residential.segregation.non.White.White.Upper.Confidence.Interval"
[290] "Homicide.rate.Value"
[291] "Homicide.rate.Numerator"
[292] "Homicide.rate.Denominator"
[293] "Homicide.rate.Lower.Confidence.Interval"
[294] "Homicide.rate.Upper.Confidence.Interval"
[295] "Population.estimate.Value"
[296] "Population.estimate.Numerator"
[297] "Population.estimate.denominator"
[298] "Population.estimate.Lower.Confidence.Interval"
[299] "Population.estimate.Upper.Confidence.Interval"
[300] "Percent.of.population.below.18.years.of.age"
[301] "Percent.of.population.below.18.years.of.age.Numerator"
[302] "Percent.of.population.below.18.years.of.age.denominator"
[303] "Percent.of.population.below.18.years.of.age.Lower.Confidence.Interval"
[304] "Percent.of.population.below.18.years.of.age.Upper.Confidence.Interval"
[305] "Percent.of.population.aged.65.years.and.older"
[306] "Percent.of.population.aged.65.years.and.older.Numerator"
[307] "Percent.of.population.aged.65.years.and.older.denominator"
[308] "Percent.of.population.aged.65.years.and.older.Lower.Confidence.Interval"
[309] "Percent.of.population.aged.65.years.and.older.Upper.Confidence.Interval"
[310] "Percent.of.population.that.is.non.Hispanic.African.American"
[311] "Percent.of.population.that.is.non.Hispanic.African.American.Numerator"
[312] "Percent.of.population.that.is.non.Hispanic.African.American.denominator"
[313] "Percent.of.population.that.is.non.Hispanic.African.American.Lower.Confidence.Interval"
[314] "Percent.of.population.that.is.non.Hispanic.African.American.Upper.Confidence.Interval"
[315] "Percent.of.population.that.is.American.Indian.or.Alaskan.Native"
[316] "Percent.of.population.that.is.American.Indian.or.Alaskan.Native.Numerator"
[317] "Percent.of.population.that.is.American.Indian.or.Alaskan.Native.denominator"
[318] "Percent.of.population.that.is.American.Indian.or.Alaskan.Native.Lower.Confidence.Interval"
[319] "Percent.of.population.that.is.American.Indian.or.Alaskan.Native.Upper.Confidence.Interval"
[320] "Percent.of.population.that.is.Asian"
[321] "Percent.of.population.that.is.Asian.Numerator"
[322] "Percent.of.population.that.is.Asian.denominator"
[323] "Percent.of.population.that.is.Asian.Lower.Confidence.Interval"
[324] "Percent.of.population.that.is.Asian.Upper.Confidence.Interval"
[325] "Percent.of.population.that.is.Native.Hawaiian.or.Other.Pacific.Islander"
[326] "Percent.of.population.that.is.Native.Hawaiian.or.Other.Pacific.Islander.Numerator"
[327] "Percent.of.population.that.is.Native.Hawaiian.or.Other.Pacific.Islander.denominator"
[328] "Percent.of.population.that.is.Native.Hawaiian.or.Other.Pacific.Islander.Lower.Confidence.Interval"
[329] "Percent.of.population.that.is.Native.Hawaiian.or.Other.Pacific.Islander.Upper.Confidence.Interval"
[330] "Percent.of.population.that.is.Hispanic"
[331] "Percent.of.population.that.is.Hispanic.Numerator"
[332] "Percent.of.population.that.is.Hispanic.denominator"
[333] "Percent.of.population.that.is.Hispanic.Lower.Confidence.Interval"
[334] "Percent.of.population.that.is.Hispanic.Upper.Confidence.Interval"
[335] "Percent.of.population.that.is.non.Hispanic.White"
[336] "Percent.of.population.that.is.non.Hispanic.White.Numerator"
[337] "Percent.of.population.that.is.non.Hispanic.White.denominator"
[338] "Percent.of.population.that.is.non.Hispanic.White.Lower.Confidence.Interval"
[339] "Percent.of.population.that.is.non.Hispanic.White.Upper.Confidence.Interval"
[340] "Population.that.is.not.proficient.in.English.Value"
[341] "Population.that.is.not.proficient.in.English.Numerator"
[342] "Population.that.is.not.proficient.in.English.Denominator"
[343] "Population.that.is.not.proficient.in.English.Lower.Confidence.Interval"
[344] "Population.that.is.not.proficient.in.English.Upper.Confidence.Interval"
[345] "Percent.of.population.that.is.female"
[346] "Percent.of.population.that.is.female.Numerator"
[347] "Percent.of.population.that.is.female.denominator"
[348] "Percent.of.population.that.is.female.Lower.Confidence.Interval"
[349] "Percent.of.population.that.is.female.Upper.Confidence.Interval"
[350] "Population.living.in.a.rural.area.Value"
[351] "Population.living.in.a.rural.area.Numerator"
[352] "Population.living.in.a.rural.area.Denominator"
[353] "Population.living.in.a.rural.area.Lower.Confidence.Interval"
[354] "Population.living.in.a.rural.area.Upper.Confidence.Interval"
[355] "Rank.for.Variable.HO"
[356] "Rank.for.Variable.MORTALITY"
[357] "Rank.for.Variable.MORBIDITY"
[358] "Rank.for.Variable.HF"
[359] "Rank.for.Variable.HB"
[360] "Rank.for.Variable.CC"
[361] "Rank.for.Variable.SF"
[362] "Rank.for.Variable.PE"
2014 - 2019 datasets from http://www.countyhealthrankings.org/explore-health-rankings/rankings-data-documentation
e.g.,
utils::browseURL('http://www.countyhealthrankings.org/rankings/data')
or
fname <- 'analytic_data2019_0.csv'
utils::download.file(url = paste('http://www.countyhealthrankings.org/sites/default/files/', fname, sep = ”), destfile = fname)
### maybe better to use readr::read_csv() since it is better at guessing preferred format of each column
countyhealth19 <- utils::read.csv(fname, stringsAsFactors = FALSE)
require(readr)
countyhealth19 <- readr::read_csv(fname, skip = 1, col_types = paste('ccccc', paste(rep('d',534-5), collapse = ”), sep = ”))
countyhealth19 <- as.data.frame(countyhealth19)
colfullnames19 <- readr::read_csv(fname, n_max = 1, col_names = FALSE)
colfullnames19 <- as.vector(unlist(colfullnames19)) # simpler
countyhealth19[1:5, 1:9]
save(countyhealth19, file = 'countyhealth19.RData')
save(colfullnames19, file = 'colfullnames19.RData')
2014/2015 data obtained 3/27/2015 and slightly modified to provide
5 digit FIPS as character field, and ST field as copy of State field.
The 2016 data was obtained 3/17/2016 and was not modified
The 2017 data was obtained 3/28/2018
The 2018 data was obtained 3/28/2018
The 2019 data was obtained 4/22/2019
Also see: http://www.countyhealthrankings.org/about-us
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.