Datasets on American Cities

Here are four datasets that contain city-level data on crime, income, poverty, education, race, and mayoral party affiliation of U.S. cities. These datasets draw on data from the Census’s American Communities Survey (ACS) and the FBI’s Uniform Crime Report (UCR).

The first dataset contains 2014 data on ~300 U.S. cities with the following variables: city name, total population, percent of 24-35 year olds with a high school diploma or Bachelor’s degree, median income, poverty rate, racial makeup, and violent crime rate.

Download: allData2014

The second dataset contains 2006 data on ~230 U.S. cities with the same variables as the first.

Download: allData2006

The third dataset contains 2014 data on the U.S.’s 76 largest cities (over 250,000) with all the same variables as the first two, but with the party affiliation of that city’s mayor (Dem.=1, Rep.=0)

Download: mayorData

And the last dataset is the difference between a city’s characteristics in 2014 and its characteristics in 2006 (So a value of -0.02 in percentWhite means that the percentWhite values was smaller by 0.02 in 2012 than it was in 2006 for that city).

Download: changeData

Methods:

First, data on race, poverty, income, and education was gathered from the American Community Survey at:

http://factfinder.census.gov/faces/nav/jsf/pages/searchresults.xhtml?refresh=t

“Geographies” was set to “All places within the United States”

The topics/variables selected were:

– S1501 Educational Attainmen
– Aged 24-35 Percent with high school graduate of higher
– Aged 24-35 Percent bachelor’s degree of higher

– S1903 Median income in the past 12 months (in 2014 inflation-adjusted dollars)
– Households

– S1701 Poverty status in the past 12 months
– Percent below poverty level by Population for whom poverty status is determined

– B03002 Hispanic or Lation origin by race
– Not Hispanic or Latino: White alone
– Not Hispanic or Latino: Black or African American alone
– Not Hispanic or Latino: Asian alone
– Hispanic or Latin

Second, data on violent crime was obtained from table 8 of the 2006 and 2014 Uniform Crime Report:
https://www2.fbi.gov/ucr/cius2006/data/table_08.html
https://www.fbi.gov/about-us/cjis/ucr/crime-in-the-u.s/2014/crime-in-the-u.s.-2014/tables/table-8/Table_8_Offenses_Known_to_Law_Enforcement_by_State_by_City_2014.xls/view

From these tables total population and number of violent crime was used.

Since the UCR and ACS city-level data do not have data for all the same cities the datasets were merged on a city-by-city basis.

Third, data on the party affiliations of 2014 mayors of cities with a population over 250,000 was coded by hand using wikipedia and other means to determine party affiliation.

Crime rates were obtained by dividing the total number of violent crimes by the UCR’s total population variable.

Proportional racial makeup was obtained by dividing the total number of people of each race by the ACS total population variable.

In the datasets, the variable “total” is the population figure from the ACS and “population” is the figure from the UCR.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s