Description Usage Format Source References See Also Examples
Data for 3142 counties in the United States.
1 | data("county_complete")
|
A data frame with 3142 observations on the following 111 variables.
stateState.
nameCounty name.
FIPSFIPS code.
pop20002000 population.
pop20102010 population.
pop20112011 population.
pop20122012 population.
pop20132013 population.
pop20142014 population.
pop20152015 population.
pop20162016 population.
pop20172017 population.
age_under_5_2010Percent of population under 5 (2010).
age_under_5_2017Percent of population under 5 (2017).
age_under_18_2010Percent of population under 18 (2010).
age_over_65_2010Percent of population over 65 (2010). It seems likely that this should actually be “over 64”.
age_over_64_2017Percent of population over 64 (2017).
median_age_2017Median age of the population (2017).
female_2010Percent of population that is female (2010).
white_2010Percent of population that is white (2010).
black_2010Percent of population that is black (2010).
black_2017Percent of population that is black (2017).
native_2010Percent of population that is a Native American (2010).
native_2017Percent of population that is a Native American (2017).
asian_2010Percent of population that is a Asian (2010).
asian_2017Percent of population that is a Asian (2017).
pac_isl_2010Percent of population that is Hawaii or Pacific Islander (2010).
pac_isl_2017Percent of population that is Hawaii or Pacific Islander (2017).
other_single_race_2017Percent of population that identifies as a single other race not listed (2017).
two_plus_races_2010Percent of population that identifies as two or more races (2010).
two_plus_races_2017Percent of population that identifies as two or more races (2017).
hispanic_2010Percent of population that is Hispanic (2010).
hispanic_2017Percent of population that is Hispanic (2017).
white_not_hispanic_2010Percent of population that is white and not Hispanic (2010).
white_not_hispanic_2017Percent of population that is white and not Hispanic (2017).
speak_english_only_2017Percent of population (5 and older) that speaks English only (2017).
no_move_in_one_plus_year_2010Percent of population that has not moved in at least one year (2006-2010).
foreign_born_2010Percent of population that is foreign-born (2006-2010).
foreign_spoken_at_home_2010Percent of population that speaks a foreign language at home (2006-2010).
women_16_to_50_birth_rate_2017Birth rate for women aged 16 to 50 (2017).
hs_grad_2010Percent of population that is a high school graduate (2006-2010).
hs_grad_2016Percent of population that is a high school graduate (2012-2016).
hs_grad_2017Percent of population that is a high school graduate (2013-2017).
some_college_2016Percent of population with some college education (2012-2016).
some_college_2017Percent of population with some college education (2013-2017).
bachelors_2010Percent of population that earned a bachelor's degree (2006-2010).
bachelors_2016Percent of population that earned a bachelor's degree (2012-2016).
bachelors_2017Percent of population that earned a bachelor's degree (2013-2017).
veterans_2010Percent of population that are veterans (2006-2010).
veterans_2017Percent of population that are veterans (2013-2017).
mean_work_travel_2010Mean travel time to work (2006-2010).
mean_work_travel_2017Mean travel time to work (2013-2017).
broadband_2017Percent of households with a subscription for broadband internet (2013-2017).
computer_2017Percent of households with a computer (2013-2017).
housing_units_2010Number of housing units (2010).
homeownership_2010Homeownership rate (2006-2010).
housing_multi_unit_2010Housing units in multi-unit structures (2006-2010).
median_val_owner_occupied_2010Median value of owner-occupied housing units (2006-2010).
households_2010Households (2006-2010).
households_2017Number of households (average over 2013-2017).
persons_per_household_2010Persons per household (2006-2010).
persons_per_household_2017Number of households (average over 2013-2017).
per_capita_income_2010Per capita money income in past 12 months (2010 dollars, 2006-2010)
per_capita_income_2017Per capita money income in past 12 months (2017 dollars, 2013-2017)
metro_2013Whether the county contained a metropolitan area in 2013.
median_household_income_2010Median household income (2010 dollars, 2006-2010).
median_household_income_2016Median household income (2016 dollars, 2012-2016).
median_household_income_2017Median household income (2017 dollars, 2013-2017).
private_nonfarm_establishments_2009Private nonfarm establishments (2009).
private_nonfarm_employment_2009Private nonfarm employment (2009).
percent_change_private_nonfarm_employment_2009Private nonfarm employment, percent change from 2000 to 2009.
nonemployment_establishments_2009Nonemployer establishments (2009).
firms_2007Total number of firms (2007).
black_owned_firms_2007Black-owned firms, percent (2007).
native_owned_firms_2007Native American-owned firms, percent (2007).
asian_owned_firms_2007Asian-owned firms, percent (2007).
pac_isl_owned_firms_2007Native Hawaiian and other Pacific Islander-owned firms, percent (2007).
hispanic_owned_firms_2007Hispanic-owned firms, percent (2007).
women_owned_firms_2007Women-owned firms, percent (2007).
manufacturer_shipments_2007Manufacturer shipments, 2007 ($1000).
mercent_whole_sales_2007Merchange wholesaler sales, 2007 ($1000).
sales_2007Retail sales, 2007 ($1000).
sales_per_capita_2007Retail sales per capita, 2007.
accommodation_food_service_2007Accommodation and food services sales, 2007 ($1000).
building_permits_2010Building permits (2010).
fed_spending_2009Federal spending, in thousands of dollars (2009).
area_2010Land area in square miles (2010).
density_2010Persons per square mile (2010).
smoking_ban_2010Describes whether the type of county-level smoking ban in place in 2010, taking one of the values "none", "partial", or "comprehensive".
poverty_2010Percent of population below poverty level (2006-2010).
poverty_2016Percent of population below poverty level (2012-2016).
poverty_2017Percent of population below poverty level (2013-2017).
poverty_age_under_5_2017Percent of population aged under 5 that lives below the poverty level (2013-2017).
poverty_age_under_18_2017Percent of population aged under 18 that lives below the poverty level (2013-2017).
civilian_labor_force_2007Civilian labor force in 2007.
employed_2007Number of civilians employed in 2007.
unemployed_2007Number of civilians unemployed in 2007.
unemployment_rate_2007Unemployment rate in 2007.
civilian_labor_force_2008Civilian labor force in 2008.
employed_2008Number of civilians employed in 2008.
unemployed_2008Number of civilians unemployed in 2008.
unemployment_rate_2008Unemployment rate in 2008.
civilian_labor_force_2009Civilian labor force in 2009.
employed_2009Number of civilians employed in 2009.
unemployed_2009Number of civilians unemployed in 2009.
unemployment_rate_2009Unemployment rate in 2009.
civilian_labor_force_2010Civilian labor force in 2010.
employed_2010Number of civilians employed in 2010.
unemployed_2010Number of civilians unemployed in 2010.
unemployment_rate_2010Unemployment rate in 2010.
civilian_labor_force_2011Civilian labor force in 2011.
employed_2011Number of civilians employed in 2011.
unemployed_2011Number of civilians unemployed in 2011.
unemployment_rate_2011Unemployment rate in 2011.
civilian_labor_force_2012Civilian labor force in 2012.
employed_2012Number of civilians employed in 2012.
unemployed_2012Number of civilians unemployed in 2012.
unemployment_rate_2012Unemployment rate in 2012.
civilian_labor_force_2013Civilian labor force in 2013.
employed_2013Number of civilians employed in 2013.
unemployed_2013Number of civilians unemployed in 2013.
unemployment_rate_2013Unemployment rate in 2013.
civilian_labor_force_2014Civilian labor force in 2014.
employed_2014Number of civilians employed in 2014.
unemployed_2014Number of civilians unemployed in 2014.
unemployment_rate_2014Unemployment rate in 2014.
civilian_labor_force_2015Civilian labor force in 2015.
employed_2015Number of civilians employed in 2015.
unemployed_2015Number of civilians unemployed in 2015.
unemployment_rate_2015Unemployment rate in 2015.
civilian_labor_force_2016Civilian labor force in 2016.
employed_2016Number of civilians employed in 2016.
unemployed_2016Number of civilians unemployed in 2016.
unemployment_rate_2016Unemployment rate in 2016.
uninsured_2017Percent of civilian population that is uninsured (2013-2017).
uninsured_age_under_6_2017Percent of civilian population aged under 6 years that is uninsured (2013-2017).
uninsured_age_under_19_2017Percent of civilian population aged under 19 years that is uninsured (2013-2017).
uninsured_age_over_74_2017Percent of civilian population aged over 74 years that is uninsured (2013-2017).
civilian_labor_force_2017Civilian labor force in 2017.
employed_2017Number of civilians employed in 2017.
unemployed_2017Number of civilians unemployed in 2017.
unemployment_rate_2017Unemployment rate in 2017.
The data prior to 2011 was from http://census.gov, though the exact page it came from is no longer available.
More recent data comes from the following sources.
Download links for spreadsheets were found on https://www.ers.usda.gov/data-products/county-level-data-sets/download-data/
Unemployment - Bureau of Labor Statistics - LAUS data - https://www.bls.gov/lau/
Median Household Income - Census Bureau - SAIPE data - https://www.census.gov/did/www/saipe/
The original data table was prepared by USDA, Economic Research Service.
Census Bureau.
2012-16 American Community Survey 5-yr average.
The original data table was prepared by USDA, Economic Research Service.
Tim Parker (tparker at ers.usda.gov) is a contact for much of the new data incorporated into this data set. Thank you Tim!
OpenIntro Statistics, openintro.org/os
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 | data(county_complete)
d <- county_complete
head(d, 3)
d$pop_change <- 100 * (d$pop2017 / d$pop2013 - 1)
plot(d$poverty_2016, d$pop_change,
cex = sqrt(d$pop2017) / 1e3,
col = ifelse(d$metro_2013 == 1, COL[1, 4], COL[2, 4]),
pch = 19,
ylim = c(-10, 25))
subset(d, pop_change < -10 | pop_change > 25, na.rm = TRUE)
plot(d$metro_2013 + rnorm(nrow(d), sd = 0.1), d$pop2013,
ylim = c(min(d$pop2013, na.rm = TRUE), 1e6),
log = "y")
plot(d$poverty_2016, d$median_household_income_2016,
cex = sqrt(d$pop2017) / 1e3,
col = ifelse(d$metro_2013 == 1, COL[1, 4], COL[2, 4]),
pch = 19)
plot(d$unemployment_rate_2017, d$poverty_2016,
cex = sqrt(d$pop2017) / 1e3,
col = ifelse(d$metro_2013 == 1, COL[1, 4], COL[2, 4]),
pch = 19)
# Definition for the `county` data set.
county <- data.frame(
name = d$name,
state = d$state,
pop2000 = d$pop2000,
pop2010 = d$pop2010,
pop2017 = d$pop2017,
pop_change = round(d$pop_change, 2),
poverty = d$poverty_2017,
homeownership = d$homeownership_2010,
multi_unit = d$housing_multi_unit_2010,
unemployment_rate = d$unemployment_rate_2017,
metro = ifelse(d$metro_2013 == 1, "yes", "no"), # Categorical, ordinal
median_edu = factor(
ifelse(d$hs_grad_2017 < 50, "below_hs",
ifelse(d$some_college_2017 + d$bachelors_2017 < 50 & d$hs_grad_2017,
"hs_diploma",
ifelse(d$bachelors_2017 > 50, "bachelors", "some_college"))),
levels = c("below_hs", "hs_diploma", "some_college", "bachelors")),
per_capita_income = d$per_capita_income_2017,
median_hh_income = d$median_household_income_2017,
smoking_ban = factor(d$smoking_ban_2010,
levels = c("none", "partial", "complete")))
boxplot(county$median_hh_income ~ county$median_edu,
ylim = c(0, max(county$median_hh_income, na.rm = TRUE)))
## Not run:
library(ggplot2)
qplot(unemployment_rate_2017, pop_change, data = d, geom = c("point", "smooth"))
qplot(poverty_2016, pop_change, data = d, geom = c("point", "smooth"))
qplot(poverty_2016, pop_change, data = d, geom = c("point", "smooth"))
qplot(
hs_grad_2010,
hs_grad_2016 / hs_grad_2010,
data = d,
geom = c("point", "smooth"))
qplot(median_household_income_2010,
median_household_income_2016 / median_household_income_2010,
data = d,
geom = c("point", "smooth"))
## End(Not run)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.