R: United States Counties

county_complete {usdata}

R Documentation

United States Counties

Description

Data for 3142 counties in the United States.

Usage

county_complete

Format

A data frame with 3142 observations on the following 188 variables.

state: State.
name: County name.
fips: FIPS code.
pop2000: 2000 population.
pop2010: 2010 population.
pop2011: 2011 population.

names

pop2012: 2012 population.
pop2013: 2013 population.
pop2014: 2014 population.
pop2015: 2015 population.
pop2016: 2016 population.
pop2017: 2017 population.
age_under_5_2010: Percent of population under 5 (2010).
age_under_5_2017: Percent of population under 5 (2017).
age_under_18_2010: Percent of population under 18 (2010).
age_over_65_2010: Percent of population over 65 (2010).
age_over_65_2017: Percent of population over 65 (2017).
median_age_2017: Median age (2017).
female_2010: Percent of population that is female (2010).
white_2010: Percent of population that is white (2010).
black_2010: Percent of population that is black (2010).
black_2017: Percent of population that is black (2017).
native_2010: Percent of population that is a Native American (2010).
native_2017: Percent of population that is a Native American (2017).
asian_2010: Percent of population that is a Asian (2010).
asian_2017: Percent of population that is a Asian (2017).
pac_isl_2010: Percent of population that is Hawaii or Pacific Islander (2010).
pac_isl_2017: Percent of population that is Hawaii or Pacific Islander (2017).
other_single_race_2017: Percent of population that identifies as another single race (2017).
two_plus_races_2010: Percent of population that identifies as two or more races (2010).
two_plus_races_2017: Percent of population that identifies as two or more races (2017).
hispanic_2010: Percent of population that is Hispanic (2010).
hispanic_2017: Percent of population that is Hispanic (2017).
white_not_hispanic_2010: Percent of population that is white and not Hispanic (2010).
white_not_hispanic_2017: Percent of population that is white and not Hispanic (2017).
speak_english_only_2017: Percent of population that speaks English only (2017).
no_move_in_one_plus_year_2010: Percent of population that has not moved in at least one year (2006-2010).
foreign_born_2010: Percent of population that is foreign-born (2006-2010).
foreign_spoken_at_home_2010: Percent of population that speaks a foreign language at home (2006-2010).
women_16_to_50_birth_rate_2017: Birth rate for women ages 16 to 50 (2017).
hs_grad_2010: Percent of population that is a high school graduate (2006-2010).
hs_grad_2016: Percent of population that is a high school graduate (2012-2016).
hs_grad_2017: Percent of population that is a high school graduate (2017).
some_college_2016: Percent of population with some college education (2012-2016).
some_college_2017: Percent of population with some college education (2017).
bachelors_2010: Percent of population that earned a bachelor's degree (2006-2010).
bachelors_2016: Percent of population that earned a bachelor's degree (2012-2016).
bachelors_2017: Percent of population that earned a bachelor's degree (2017).
veterans_2010: Percent of population that are veterans (2006-2010).
veterans_2017: Percent of population that are veterans (2017).
mean_work_travel_2010: Mean travel time to work (2006-2010).
mean_work_travel_2017: Mean travel time to work (2017).
broadband_2017: Percent of population who has access to broadband (2017).
computer_2017: Percent of population who has access to a computer (2017).
housing_units_2010: Number of housing units (2010).
homeownership_2010: Home ownership rate (2006-2010).
housing_multi_unit_2010: Housing units in multi-unit structures (2006-2010).
median_val_owner_occupied_2010: Median value of owner-occupied housing units (2006-2010).
households_2010: Households (2006-2010).
households_2017: Households (2017).
persons_per_household_2010: Persons per household (2006-2010).
persons_per_household_2017: Persons per household (2017).
per_capita_income_2010: Per capita money income in past 12 months (2010 dollars, 2006-2010)
per_capita_income_2017: Per capita money income in past 12 months (2017 dollars, 2017)
metro_2013: Whether the county contained a metropolitan area in 2013.
median_household_income_2010: Median household income (2006-2010).
median_household_income_2016: Median household income (2012-2016).
median_household_income_2017: Median household income (2017).
private_nonfarm_establishments_2009: Private nonfarm establishments (2009).
private_nonfarm_employment_2009: Private nonfarm employment (2009).
percent_change_private_nonfarm_employment_2009: Private nonfarm employment, percent change from 2000 to 2009.
nonemployment_establishments_2009: Nonemployer establishments (2009).
firms_2007: Total number of firms (2007).
black_owned_firms_2007: Black-owned firms, percent (2007).
native_owned_firms_2007: Native American-owned firms, percent (2007).
asian_owned_firms_2007: Asian-owned firms, percent (2007).
pac_isl_owned_firms_2007: Native Hawaiian and other Pacific Islander-owned firms, percent (2007).
hispanic_owned_firms_2007: Hispanic-owned firms, percent (2007).
women_owned_firms_2007: Women-owned firms, percent (2007).
manufacturer_shipments_2007: Manufacturer shipments, 2007 ($1000).
mercent_whole_sales_2007: Mercent wholesaler sales, 2007 ($1000).
sales_2007: Retail sales, 2007 ($1000).
sales_per_capita_2007: Retail sales per capita, 2007.
accommodation_food_service_2007: Accommodation and food services sales, 2007 ($1000).
building_permits_2010: Building permits (2010).
fed_spending_2009: Federal spending, in thousands of dollars (2009).
area_2010: Land area in square miles (2010).
density_2010: Persons per square mile (2010).
smoking_ban_2010: Describes whether the type of county-level smoking ban in place in 2010, taking one of the values "none", "partial", or "comprehensive".
poverty_2010: Percent of population below poverty level (2006-2010).
poverty_2016: Percent of population below poverty level (2012-2016).
poverty_2017: Percent of population below poverty level (2017).
poverty_age_under_5_2017: Percent of population under age 5 below poverty level (2017).
poverty_age_under_18_2017: Percent of population under age 18 below poverty level (2017).
civilian_labor_force_2007: Civilian labor force in 2007.
employed_2007: Number of civilians employed in 2007.
unemployed_2007: Number of civilians unemployed in 2007.
unemployment_rate_2007: Unemployment rate in 2007.
civilian_labor_force_2008: Civilian labor force in 2008.
employed_2008: Number of civilians employed in 2008.
unemployed_2008: Number of civilians unemployed in 2008.
unemployment_rate_2008: Unemployment rate in 2008.
civilian_labor_force_2009: Civilian labor force in 2009.
employed_2009: Number of civilians employed in 2009.
unemployed_2009: Number of civilians unemployed in 2009.
unemployment_rate_2009: Unemployment rate in 2009.
civilian_labor_force_2010: Civilian labor force in 2010.
employed_2010: Number of civilians employed in 2010.
unemployed_2010: Number of civilians unemployed in 2010.
unemployment_rate_2010: Unemployment rate in 2010.
civilian_labor_force_2011: Civilian labor force in 2011.
employed_2011: Number of civilians employed in 2011.
unemployed_2011: Number of civilians unemployed in 2011.
unemployment_rate_2011: Unemployment rate in 2011.
civilian_labor_force_2012: Civilian labor force in 2012.
employed_2012: Number of civilians employed in 2012.
unemployed_2012: Number of civilians unemployed in 2012.
unemployment_rate_2012: Unemployment rate in 2012.
civilian_labor_force_2013: Civilian labor force in 2013.
employed_2013: Number of civilians employed in 2013.
unemployed_2013: Number of civilians unemployed in 2013.
unemployment_rate_2013: Unemployment rate in 2013.
civilian_labor_force_2014: Civilian labor force in 2014.
employed_2014: Number of civilians employed in 2014.
unemployed_2014: Number of civilians unemployed in 2014.
unemployment_rate_2014: Unemployment rate in 2014.
civilian_labor_force_2015: Civilian labor force in 2015.
employed_2015: Number of civilians employed in 2015.
unemployed_2015: Number of civilians unemployed in 2015.
unemployment_rate_2015: Unemployment rate in 2015.
civilian_labor_force_2016: Civilian labor force in 2016.
employed_2016: Number of civilians employed in 2016.
unemployed_2016: Number of civilians unemployed in 2016.
unemployment_rate_2016: Unemployment rate in 2016.
uninsured_2017: Percent of population who are uninsured (2017).
uninsured_age_under_6_2017: Percent of population under 6 who are uninsured (2017).
uninsured_age_under_19_2017: Percent of population under 19 who are uninsured (2017).
uninsured_age_over_74_2017: Percent of population under 74 who are uninsured (2017).
civilian_labor_force_2017: Civilian labor force in 2017.
employed_2017: Number of civilians employed in 2017.
unemployed_2017: Number of civilians unemployed in 2017.
unemployment_rate_2017: Unemployment rate in 2017.
median_individual_income_2019: Median individual income (2019).
pop_2019: 2019 population.
white_2019: Percent of population that is white alone (2015-2019).
black_2019: Percent of population that is black alone (2015-2019).
native_2019: Percent of population that is Native American alone (2015-2019).
asian_2019: Percent of population that is Asian alone (2015-2019).
pac_isl_2019: Percent of population that is Native Hawaiian or other Pacific Islander alone (2015-2019).
other_single_race_2019: Percent of population that is some other race alone (2015-2019).
two_plus_races_2019: Percent of population that is two or more races (2015-2019).
hispanic_2019: Percent of population that identifies as Hispanic or Latino (2015-2019).
white_not_hispanic_2019: Percent of population that is white alone, not Hispanic or Latino (2015-2019).
median_age_2019: Median age (2015-2019).
age_under_5_2019: Percent of population under 5 (2015-2019).
age_over_85_2019: Percent of population 85 and over (2015-2019).
age_over_18_2019: Percent of population 18 and over (2015-2019).
age_over_65_2019: Percent of population 65 and over (2015-2019).
mean_work_travel_2019: Mean travel time to work (2015-2019).
persons_per_household_2019: Persons per household (2015-2019)
avg_family_size_2019: Average family size (2015-2019).
housing_one_unit_structures_2019: Percent of housing units in 1-unit structures (2015-2019).
housing_two_unit_structures_2019: Percent of housing units in multi-unit structures (2015-2019).
housing_mobile_homes_2019: Percent of housing units in mobile homes and other types of units (2015-2019).
median_individual_income_age_25plus_2019: Median individual income (2019 dollars, 2015-2019).
hs_grad_2019: Percent of population 25 and older that is a high school graduate (2015-2019).
bachelors_2019: Percent of population 25 and older that earned a Bachelor's degree or higher (2015-2019).
households_2019: Total households (2015-2019).
households_speak_spanish_2019: Percent of households speaking Spanish (2015-2019).
households_speak_other_indo_euro_lang_2019: Percent of households speaking other Indo-European language (2015-2019).
households_speak_asian_or_pac_isl_2019: Percent of households speaking Asian and Pacific Island language (2015-2019).
households_speak_other_2019: Percent of households speaking non European or Asian/Pacific Island language (2015-2019).
households_speak_limited_english_2019: Percent of limited English-speaking households (2015-2019).
poverty_2019: Percent of population below the poverty level (2015-2019).
poverty_under_18_2019: Percent of population under 18 below the poverty level (2015-2019).
poverty_65_and_over_2019: Percent of population 65 and over below the poverty level (2015-2019).
mean_household_income_2019: Mean household income (2019 dollars, 2015-2019).
per_capita_income_2019: Per capita money income in past 12 months (2019 dollars, 2015-2019).
median_household_income_2019: Median household income (2015-2019).
veterans_2019: Percent among civilian population 18 and over that are veterans (2015-2019).
unemployment_rate_2019: Unemployment rate among those ages 20-64 (2015-2019).
uninsured_2019: Percent of civilian noninstitutionalized population that is uninsured (2015-2019).
uninsured_under_6_2019: Percent of population under 6 years that is uninsured (2015-2019).
uninsured_under_19_2019: Percent of population under 19 that is uninsured (2015-2019).
uninsured_65_and_older_2019: Percent of population 65 and older that is uninsured (2015-2019).
household_has_computer_2019: Percent of households that have desktop or laptop computer (2015-2019).
household_has_smartphone_2019: Percent of households that have smartphone (2015-2019).
household_has_broadband_2019: Percent of households that have broadband internet subscription (2015-2019).

Source

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.

Downloaded via the tidycensus R package.
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 - Small Area Income and Poverty Estimates (SAIPE) data.
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 the contact for much of the new data incorporated into this data set.

Examples


library(dplyr)
library(ggplot2)

county_complete |>
  mutate(
    pop_change = 100 * ((pop2017 / pop2013) - 1),
    metro_area = if_else(metro_2013 == 1, TRUE, FALSE)
  ) |>
  ggplot(aes(
    x = poverty_2016,
    y = pop_change,
    color = metro_area,
    size = sqrt(pop2017) / 1e3
  )) +
  geom_point(alpha = 0.5) +
  scale_color_discrete(na.translate = FALSE) +
  guides(size = FALSE) +
  labs(
    x = "Percentage of population in poverty (2016)",
    y = "Percentage population change between 2013 to 2017",
    color = "Metropolitan area",
    title = "Population change and poverty"
  )

# Counties with high population change
county_complete |>
  mutate(pop_change = 100 * ((pop2017 / pop2013) - 1)) |>
  filter(pop_change < -10 | pop_change > 25) |>
  select(state, name, fips, pop_change)

# Population by metro area
county_complete |>
  mutate(metro_area = if_else(metro_2013 == 1, TRUE, FALSE)) |>
  filter(!is.na(metro_area)) |>
  ggplot(aes(x = metro_area, y = log(pop2017))) +
  geom_violin() +
  labs(
    x = "Metro area",
    y = "Log of population in 2017",
    title = "Population by metro area"
  )

# Poverty and median household income
county_complete |>
  mutate(metro_area = if_else(metro_2013 == 1, TRUE, FALSE)) |>
  ggplot(aes(
    x = poverty_2016,
    y = median_household_income_2016,
    color = metro_area,
    size = sqrt(pop2017) / 1e3
  )) +
  geom_point(alpha = 0.5) +
  scale_color_discrete(na.translate = FALSE) +
  guides(size = FALSE) +
  labs(
    x = "Percentage of population in poverty (2016)",
    y = "Median household income (2016)",
    color = "Metropolitan area",
    title = "Poverty and median household income"
  )

# Unemployment rate and poverty
county_complete |>
  mutate(metro_area = if_else(metro_2013 == 1, TRUE, FALSE)) |>
  ggplot(aes(
    x = unemployment_rate_2017,
    y = poverty_2016,
    color = metro_area,
    size = sqrt(pop2017) / 1e3
  )) +
  geom_point(alpha = 0.5) +
  scale_color_discrete(na.translate = FALSE) +
  guides(size = FALSE) +
  labs(
    x = "Unemployment rate (2017)",
    y = "Percentage of population in poverty (2016)",
    color = "Metropolitan area",
    title = "Unemployment rate and poverty"
  )