Police Killings: police_killings.csv

This directory contains the data behind the story Where Police Have Killed Americans In 2015.

We linked entries from the Guardian's database on police killings to census data from the American Community Survey. The Guardian data was downloaded on June 2, 2015. More information about its database is available here.

Census data was calculated at the tract level from the 2015 5-year American Community Survey using the tables S0601 (demographics), S1901 (tract-level income and poverty), S1701 (employment and education) and DP03 (county-level income). Census tracts were determined by geocoding addresses to latitude/longitude using the Bing Maps and Google Maps APIs and then overlaying points onto 2014 census tracts. GEOIDs are census-standard and should be easily joinable to other ACS tables -- let us know if you find anything interesting.

Field descriptions:

Header Description Source
name Name of deceased Guardian
age Age of deceased Guardian
gender Gender of deceased Guardian
raceethnicity Race/ethnicity of deceased Guardian
month Month of killing Guardian
day Day of incident Guardian
year Year of incident Guardian
streetaddress Address/intersection where incident occurred Guardian
city City where incident occurred Guardian
state State where incident occurred Guardian
latitude Latitude, geocoded from address
longitude Longitude, geocoded from address
state_fp State FIPS code Census
county_fp County FIPS code Census
tract_ce Tract ID code Census
geo_id Combined tract ID code
county_id Combined county ID code
namelsad Tract description Census
lawenforcementagency Agency involved in incident Guardian
cause Cause of death Guardian
armed How/whether deceased was armed Guardian
pop Tract population Census
share_white Share of pop that is non-Hispanic white Census
share_bloack Share of pop that is black (alone, not in combination) Census
share_hispanic Share of pop that is Hispanic/Latino (any race) Census
p_income Tract-level median personal income Census
h_income Tract-level median household income Census
county_income County-level median household income Census
comp_income h_income / county_income Calculated from Census
county_bucket Household income, quintile within county Calculated from Census
nat_bucket Household income, quintile nationally Calculated from Census
pov Tract-level poverty rate (official) Census
urate Tract-level unemployment rate Calculated from Census
college Share of 25+ pop with BA or higher Calculated from Census

Note regarding income calculations:

All income fields are in inflation-adjusted 2013 dollars.

comp_income is simply tract-level median household income as a share of county-level median household income.

county_bucket provides where the tract's median household income falls in the distribution (by quintile) of all tracts in the county. (1 indicates a tract falls in the poorest 20% of tracts within the county.) Distribution is not weighted by population.

nat_bucket is the same but for all U.S. counties.

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

2 rows where month = "June" sorted by county_fp

View and edit SQL


  • June · 2
Link rowid name age gender raceethnicity month day year streetaddress city state latitude longitude state_fp county_fp ▼ tract_ce geo_id county_id namelsad lawenforcementagency cause armed pop p_income h_income county_income comp_income county_bucket nat_bucket pov urate college
198 James Bushey 47 Male White June 1 2015 2225 Texas Hwy 256 Loop Palestine TX 31.774196999999997 -95.6519569 48 1 950500 48001950500 48001 Census Tract 9505 Palestine Police Department Gunshot No 4447 18238 31815 40653 0.78259907   1 34.8 0.097790055 0.162665563
453 Unknown Unknown Male White June 1 2015 271 Greece Ridge Center Dr Rochester NY 32.407138800000006 -96.0738907 48 467 951000 48467951000 48467 Census Tract 9510 New York State Police, Monroe County Sheriff's Department and Gates Police Department Gunshot Firearm 6852 22969 50280 43439 1.157485209 5 3 17.9 0.058573297999999996 0.100249066

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "police-killings/police_killings" (
"name" TEXT,
  "age" TEXT,
  "gender" TEXT,
  "raceethnicity" TEXT,
  "month" TEXT,
  "day" INTEGER,
  "year" INTEGER,
  "streetaddress" TEXT,
  "city" TEXT,
  "state" TEXT,
  "latitude" REAL,
  "longitude" REAL,
  "state_fp" INTEGER,
  "county_fp" INTEGER,
  "tract_ce" INTEGER,
  "geo_id" INTEGER,
  "county_id" INTEGER,
  "namelsad" TEXT,
  "lawenforcementagency" TEXT,
  "cause" TEXT,
  "armed" TEXT,
  "pop" INTEGER,
  "share_white" TEXT,
  "share_black" TEXT,
  "share_hispanic" TEXT,
  "p_income" TEXT,
  "h_income" INTEGER,
  "county_income" INTEGER,
  "comp_income" REAL,
  "county_bucket" INTEGER,
  "nat_bucket" INTEGER,
  "pov" TEXT,
  "urate" REAL,
  "college" REAL
Powered by Datasette · Query took 108.613ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub