countyhealth16: Countyhealthrankings.org 2016 dataset

countyhealth16R Documentation

Countyhealthrankings.org 2016 dataset

Description

This data set provides a variety of health indicators for each US county.

Usage

data('countyhealth16')

Format

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"

Source

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


ejanalysis/countyhealthrankings documentation built on March 25, 2022, 9:15 a.m.