Minneapolis Police Stops And Police Violence

Updated weekly (with automatic updates)

@kaggle.paultimothymooney_minneapolis_police_stops_and_police_violence

Table List

2 tables(10.01 MB)

Police Stop Data

@kaggle.paultimothymooney_minneapolis_police_stops_and_police_violence.police_stop_data

8.04 MB
230172 rows
19 columns

objectid OBJECTID	masterincidentnumber MasterIncidentNumber	responsedate ResponseDate	reason Reason	problem Problem	calldisposition CallDisposition	citationissued CitationIssued	personsearch PersonSearch	vehiclesearch VehicleSearch	prerace PreRace	race Race	gender Gender	lat Lat	long Long	x X	y Y	policeprecinct PolicePrecinct	neighborhood Neighborhood	lastupdatedate LastUpdateDate
1	16-395258	2016/10/31 22:40:47+00	nan	Suspicious Person (P)	BKG-Booking	nan	YES	NO	Black	Black	Male	44.97957	-93.27257	-10383055.27	5618306.33	1	Downtown West	2017/08/08 10:25:31+00
2	16-395296	2016/10/31 23:06:36+00	nan	Traffic Law Enforcement (P)	TAG-Tagged	nan	NO	NO	Unknown	Black	Male	44.96268936	-93.27592097	-10383428.0252	5615649.6003	5	Steven's Square - Loring Heights	2017/08/08 10:26:13+00
3	16-395326	2016/10/31 23:20:54+00	nan	Attempt Pick-Up (P)	RFD-Refused	nan	NO	NO	Unknown	Unknown	Unknown	45.02483565	-93.28806913	-10384780.3529	5625432.1991	4	Webber - Camden	2017/08/08 10:24:35+00
4	16-395328	2016/10/31 23:23:20+00	nan	Suspicious Person (P)	BKG-Booking	nan	YES	NO	Black	Black	Male	44.94656	-93.24741	-10380254.21	5613112.002	3	Corcoran	2017/08/08 10:25:31+00
5	16-395333	2016/10/31 23:26:05+00	nan	Suspicious Vehicle (P)	GOA-Gone on Arrival	nan	NO	NO	Other	Unknown	Male	44.90617005	-93.25500968	-10381100.1911	5606761.956	3	Hale	2017/08/08 10:25:03+00
6	16-395364	2016/10/31 23:45:31+00	nan	Traffic Law Enforcement (P)	ADV-Advised	nan	nan	nan	nan	nan	nan	44.93954	-93.27791	-10383649.91	5612008.003	5	Lyndale	2017/08/08 10:25:31+00
7	16-395369	2016/10/31 23:46:42+00	nan	Suspicious Person (P)	ADV-Advised	nan	NO	NO	Unknown	Unknown	Unknown	44.98157013	-93.29687049	-10385760.1153	5618620.5475	4	Sumner - Glenwood	2017/08/08 10:26:13+00
8	16-395387	2016/11/01 00:01:55+00	nan	Suspicious Vehicle (P)	SNT-Sent	nan	nan	nan	nan	nan	nan	44.97121931	-93.23522925	-10378898.2444	5616991.6928	2	University of Minnesota	2017/08/08 10:24:30+00
9	16-395389	2016/11/01 00:02:45+00	nan	Traffic Law Enforcement (P)	ADV-Advised	nan	NO	NO	Unknown	East African	Male	44.96179868	-93.28125485	-10384021.7901	5615509.4733	5	Whittier	2017/08/08 10:26:13+00
10	16-395397	2016/11/01 00:06:54+00	nan	Suspicious Vehicle (P)	ADV-Advised	nan	NO	NO	Unknown	Black	Male	45.03607888	-93.29010369	-10385006.8383	5627203.1574	4	Lind - Bohanon	2017/08/08 10:24:35+00


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
);