Finding Data and Joining Data

 

Census Data

https://www.census.gov/geo/maps-data/data/tiger-line.html

Counties in US shapefile.

 

American Fact Finder

https://factfinder.census.gov/faces/nav/jsf/pages/index.xhtml

go to Advanced Search tab

select Search items you are interested in mapping (Topics, Geographies, Industry Codes, etc.)

include all counties within United States)

 

CDC Cancer Data

https://www.cdc.gov/DataStatistics/

click on Cancer

click on Tools

click on U.S. County Cancer Incidence Dataset

 

Teacher salaries by state

https://articles.niche.com/teacher-salaries-in-america/

 

USDA ERS - County-level Data Sets

Socioeconomic indicators like poverty rates, population change, unemployment rates, and education levels vary geographically across U.S. States and counties.

https://www.ers.usda.gov/data-products/county-level-data-sets/

 

The Extreme Cities and Counties

http://www.mlive.com/news/index.ssf/2017/09/see_richest_poorest_us_cities.html

 

Religious Congregations and Membership

http://www.thearda.com/Archive/Files/Descriptions/RCMSCY.asp

 

Income inequality in the U.S. by state, metropolitan area, and county

http://www.epi.org/publication/income-inequality-in-the-us/

Rank (from highest to lowest ratio)

Metropolitan area

Average income of the top 1%

Average income of the bottom 99%

Top-to-bottom ratio

1

Jackson, WY-ID

$19,995,834

$93,891

213.0

2

Bridgeport-Stamford-Norwalk, CT

$6,061,230

$82,222

73.7

3

Naples-Immokalee-Marco Island, FL

$4,191,055

$57,258

73.2

4

Sebastian-Vero Beach, FL

$2,519,981

$39,710

63.5

5

Key West, FL

$3,193,353

$54,615

58.5

 

Gini Index of Income Inequality for U.S. Counties

http://blogs.lib.uconn.edu/outsidetheneatline/2014/01/28/gini-index-of-income-inequality-for-u-s-counties/

 

U.S. Suicide Rates by County

https://resources.wolframcloud.com/DataRepository/resources/U.S.%2BSuicide%2BRates%2Bby%2BCounty

 

Cigarette smoking prevalence in US counties: 1996-2012

https://doi.org/10.1186/1478-7954-12-5

Cigarette vector files:  http://all-free-download.com/free-vector/vector-cigarette-eps.html

 

County-Level Marriage & Divorce Data, 2000

https://www.bgsu.edu/ncfmr/resources/data/original-data.html

 

 

 

Getting the FIPS Codes Right in Excel

The county FIPS codes will be used to join attribute data to your county geometries.

 

FIPS code needs to be 5-digits

If needed, add two blank columns

Add 1000000 in one of the columns. This is to add zeros to the beginning if some are not 5 digits.

In other column, take the text characters of the 5 right-most in the string.

 

 

 

Joining tables in ArcMap

http://desktop.arcgis.com/en/arcmap/10.3/manage-data/tables/essentials-of-joining-tables.htm

 

Open ArcMap in Windows

Add counties

Join your chosen data table to county layer using FIPS code