usdata (version 0.1.0)

county_complete: United States Counties

Description

Data for 3143 counties in the United States.

Usage

county_complete

Format

A data frame with 3143 observations on the following 111 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.

See Also

county

Examples

# NOT RUN {
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"
  )
# }

Run the code above in your browser using DataCamp Workspace