Dataset: Minneapolis Police Stops And Police Violence

About this Dataset

Minneapolis Police Stops And Police Violence

Context

Minneapolis was the location of a famous incident of police violence: https://en.wikipedia.org/wiki/Killing_of_George_Floyd.

Content

Minneapolis Police Stop Data

callDisposition   
citationIssued   
gender   
lastUpdateDate 
lat   
long 
masterIncidentNumber 
neighborhood 
OBJECTID 
personSearch   
policePrecinct   
preRace   
problem   
race   
reason   
responseDate 
vehicleSearch   
x   
y

Minneapolis Police Use of Force Data

CaseNumber   
CenterGBSID   
CenterLatitude   
CenterLongitude   
CenterX   
CenterY   
DateAdded 
EventAge   
ForceReportNumber   
ForceType 
ForceTypeAction   
Is911Call 
Neighborhood 
OBJECTID 
PoliceUseOfForceID   
Precinct 
PrimaryOffense 
Problem   
Race   
ResponseDate 
Sex   
SubjectInjury 
SubjectRole   
SubjectRoleNumber   
TotalCityCallsForYear   
TotalNeighborhoodCallsForYear   
TotalPrecinctCallsForYear   
TypeOfResistance

Acknowledgements

Data from http://opendata.minneapolismn.gov/datasets/police-stop-data and http://opendata.minneapolismn.gov/datasets/police-use-of-force.

Minneapolis Data by City of Minneapolis is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License

Banner Photo by Steijn Leijzer on Unsplash

Tables

Police Stop Data

@kaggle.paultimothymooney_minneapolis_police_stops_and_police_violence.police_stop_data

8.04 MB
230172 rows
19 columns


CREATE TABLE police_stop_data (
  "objectid" BIGINT,
  "masterincidentnumber" VARCHAR,
  "responsedate" VARCHAR,
  "reason" VARCHAR,
  "problem" VARCHAR,
  "calldisposition" VARCHAR,
  "citationissued" VARCHAR,
  "personsearch" VARCHAR,
  "vehiclesearch" VARCHAR,
  "prerace" VARCHAR,
  "race" VARCHAR,
  "gender" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "x" DOUBLE,
  "y" DOUBLE,
  "policeprecinct" DOUBLE,
  "neighborhood" VARCHAR,
  "lastupdatedate" VARCHAR
);

Police Use Of Force

@kaggle.paultimothymooney_minneapolis_police_stops_and_police_violence.police_use_of_force

1.97 MB
41416 rows
30 columns


CREATE TABLE police_use_of_force (
  "x" DOUBLE,
  "y" DOUBLE,
  "policeuseofforceid" BIGINT,
  "casenumber" VARCHAR,
  "responsedate" VARCHAR,
  "problem" VARCHAR,
  "is911call" VARCHAR,
  "primaryoffense" VARCHAR,
  "subjectinjury" VARCHAR,
  "forcereportnumber" BIGINT,
  "subjectrole" VARCHAR,
  "subjectrolenumber" DOUBLE,
  "forcetype" VARCHAR,
  "forcetypeaction" VARCHAR,
  "race" VARCHAR,
  "sex" VARCHAR,
  "eventage" DOUBLE,
  "typeofresistance" VARCHAR,
  "precinct" VARCHAR,
  "neighborhood" VARCHAR,
  "totalcitycallsforyear" BIGINT,
  "totalprecinctcallsforyear" DOUBLE,
  "totalneighborhoodcallsforyear" BIGINT,
  "centergbsid" BIGINT,
  "centerlatitude" DOUBLE,
  "centerlongitude" DOUBLE,
  "centerx" DOUBLE,
  "centery" DOUBLE,
  "dateadded" VARCHAR,
  "objectid" BIGINT
);