Name:

Description:

Data for 3143 counties in the United States.

Variables:

• state - State.
• name - County name.
• FIPS - FIPS code.
• pop2000 - 2000 population.
• pop2010 - 2010 population.
• pop2011 - 2011 population.
• 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_18_2010 - Percent of population under 18 (2010).
• age_over_65_2010 - Percent of population over 65 (2010).
• 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).
• native_2010 - Percent of population that is a Native American (2010).
• asian_2010 - Percent of population that is a Asian (2010).
• pac_isl_2010 - Percent of population that is Hawaii or Pacific Islander (2010).
• two_plus_races_2010 - Percent of population that identifies as two or more races (2010).
• hispanic_2010 - Percent of population that is Hispanic (2010).
• white_not_hispanic_2010 - Percent of population that is white and not Hispanic (2010).
• 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).
• 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).
• some_college_2016 - Percent of population with some college education (2012-2016).
• 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).
• veterans_2010 - Percent of population that are veterans (2006-2010).
• mean_work_travel_2010 - Mean travel time to work (2006-2010).
• housing_units_2010 - Number of housing units (2010).
• homeownership_2010 - Homeownership 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).
• persons_per_household_2010 - Persons per household (2006-2010).
• per_capita_income_2010 - Per capita money income in past 12 months (2010 dollars, 2006-2010)
• 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).
• 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 - Merchange 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).
• 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.
• 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.

Link To Google Sheets:

Rows:

Columns:

Files:

License Type:

References/Notes/Attributions:

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.

• 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!

R Dataset Upload:

Use the following R code to directly access this dataset in R.

R Coding Interface: