Minneapolis Police use of force data, downloaded June 17, 2020

Data license: CC BY-SA 4.0 · Data source: Minneapolis Open Data Portal

90,387 rows sorted by ForceReportNumber

View and edit SQL

Link rowid X Y PoliceUseOfForceID CaseNumber ResponseDate Problem Is911Call PrimaryOffense SubjectInjury ForceReportNumber ▼ SubjectRole SubjectRoleNumber ForceType ForceTypeAction Race Sex EventAge TypeOfResistance Precinct Neighborhood TotalCityCallsForYear TotalPrecinctCallsForYear TotalNeighborhoodCallsForYear CenterGBSID CenterLatitude CenterLongitude CenterX CenterY DateAdded OBJECTID
29099 0.0 0.0 11704787 13-Windom Park 2013/01/01 00:00:00+00         0   0   0           Windom Park 351659   2944 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29099
29100 0.0 0.0 11704788 20-Northrop 2020/01/01 00:00:00+00         0   0   0           Northrop 122931   528 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29100
29101 0.0 0.0 11704789 19-Seward 2019/01/01 00:00:00+00         0   0   0           Seward 301999   5392 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29101
29102 0.0 0.0 11704790 15-Waite Park 2015/01/01 00:00:00+00         0   0   0           Waite Park 359611   1796 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29102
29103 0.0 0.0 11704791 20-Lowry Hill 2020/01/01 00:00:00+00         0   0   0           Lowry Hill 122931   641 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29103
29104 0.0 0.0 11704792 13-Elliot Park 2013/01/01 00:00:00+00         0   0   0           Elliot Park 351659   7349 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29104
29105 0.0 0.0 11704793 20-Downtown West 2020/01/01 00:00:00+00         0   0   0           Downtown West 122931   10461 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29105
29106 0.0 0.0 11704794 12-Midtown Phillips 2012/01/01 00:00:00+00         0   0   0           Midtown Phillips 324520   6154 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29106
29107 0.0 0.0 11704795 17-Minnehaha 2017/01/01 00:00:00+00         0   0   0           Minnehaha 380794   1173 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29107
29108 0.0 0.0 11704796 11-Lowry Hill East 2011/01/01 00:00:00+00         0   0   0           Lowry Hill East 313095   6070 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29108
29109 0.0 0.0 11704797 16-Armatage 2016/01/01 00:00:00+00         0   0   0           Armatage 347093   825 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29109
29110 0.0 0.0 11704798 19-Regina 2019/01/01 00:00:00+00         0   0   0           Regina 301999   789 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29110
29111 0.0 0.0 11704799 17-Page 2017/01/01 00:00:00+00         0   0   0           Page 380794   273 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29111
29112 0.0 0.0 11704800 12-Ventura Village 2012/01/01 00:00:00+00         0   0   0           Ventura Village 324520   10923 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29112
29113 0.0 0.0 11704801 15-Ventura Village 2015/01/01 00:00:00+00         0   0   0           Ventura Village 359611   8351 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29113
29114 0.0 0.0 11704802 12-East Phillips 2012/01/01 00:00:00+00         0   0   0           East Phillips 324520   6887 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29114
29115 0.0 0.0 11704803 18-Beltrami 2018/01/01 00:00:00+00         0   0   0           Beltrami 344333   1047 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29115
29116 0.0 0.0 11704804 09-Keewaydin 2009/01/01 00:00:00+00         0   0   0           Keewaydin 316150   727 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29116
29117 0.0 0.0 11704805 13-Holland 2013/01/01 00:00:00+00         0   0   0           Holland 351659   5517 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29117
29118 0.0 0.0 11704806 14-Columbia Park 2014/01/01 00:00:00+00         0   0   0           Columbia Park 355617   720 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29118
29119 0.0 0.0 11704807 11-Armatage 2011/01/01 00:00:00+00         0   0   0           Armatage 313095   1003 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29119
29120 0.0 0.0 11704808 10-Waite Park 2010/01/01 00:00:00+00         0   0   0           Waite Park 314926   1805 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29120
29121 0.0 0.0 11704809 20-Downtown East 2020/01/01 00:00:00+00         0   0   0           Downtown East 122931   886 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29121
29122 0.0 0.0 11704810 08-Bryant 2008/01/01 00:00:00+00         0   0   0           Bryant 322402   1869 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29122
29123 0.0 0.0 11704811 09-North Loop 2009/01/01 00:00:00+00         0   0   0           North Loop 316150   5140 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29123
29124 0.0 0.0 11704812 08-Cedar - Isles - Dean 2008/01/01 00:00:00+00         0   0   0           Cedar - Isles - Dean 322402   924 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29124
29125 0.0 0.0 11704813 14-Hawthorne 2014/01/01 00:00:00+00         0   0   0           Hawthorne 355617   13526 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29125
29126 0.0 0.0 11704814 14-Downtown West 2014/01/01 00:00:00+00         0   0   0           Downtown West 355617   32502 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29126
29127 0.0 0.0 11704815 08-Columbia Park 2008/01/01 00:00:00+00         0   0   0           Columbia Park 322402   947 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29127
29128 0.0 0.0 11704816 09-Cedar Riverside 2009/01/01 00:00:00+00         0   0   0           Cedar Riverside 316150   5702 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29128
29129 0.0 0.0 11704817 18-Nicollet Island - East Bank 2018/01/01 00:00:00+00         0   0   0           Nicollet Island - East Bank 344333   3646 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29129
29130 0.0 0.0 11704818 11-Cedar Riverside 2011/01/01 00:00:00+00         0   0   0           Cedar Riverside 313095   5982 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29130
29131 0.0 0.0 11704819 16-Regina 2016/01/01 00:00:00+00         0   0   0           Regina 347093   880 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29131
29132 0.0 0.0 11704820 14-Harrison 2014/01/01 00:00:00+00         0   0   0           Harrison 355617   2807 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29132
29133 0.0 0.0 11704821 13-Victory 2013/01/01 00:00:00+00         0   0   0           Victory 351659   2574 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29133
29134 0.0 0.0 11704822 19-Linden Hills 2019/01/01 00:00:00+00         0   0   0           Linden Hills 301999   1641 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29134
29135 0.0 0.0 11704823 13-Midtown Phillips 2013/01/01 00:00:00+00         0   0   0           Midtown Phillips 351659   5962 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29135
29136 0.0 0.0 11704824 12-Jordan 2012/01/01 00:00:00+00         0   0   0           Jordan 324520   12342 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29136
29137 0.0 0.0 11704825 17-Victory 2017/01/01 00:00:00+00         0   0   0           Victory 380794   2804 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29137
29138 0.0 0.0 11704826 19-Midtown Phillips 2019/01/01 00:00:00+00         0   0   0           Midtown Phillips 301999   5444 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29138
29139 0.0 0.0 11704827 15-Cleveland 2015/01/01 00:00:00+00         0   0   0           Cleveland 359611   2481 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29139
29140 0.0 0.0 11704828 18-Mid - City Industrial 2018/01/01 00:00:00+00         0   0   0           Mid - City Industrial 344333   2644 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29140
29141 0.0 0.0 11704829 14-Near - North 2014/01/01 00:00:00+00         0   0   0           Near - North 355617   11700 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29141
29142 0.0 0.0 11704830 10-West Calhoun 2010/01/01 00:00:00+00         0   0   0           West Calhoun 314926   625 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29142
29143 0.0 0.0 11704831 16-Cedar - Isles - Dean 2016/01/01 00:00:00+00         0   0   0           Cedar - Isles - Dean 347093   1002 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29143
29144 0.0 0.0 11704832 18-Camden Industrial 2018/01/01 00:00:00+00         0   0   0           Camden Industrial 344333   230 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29144
29145 0.0 0.0 11704833 14-Seward 2014/01/01 00:00:00+00         0   0   0           Seward 355617   5279 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29145
29146 0.0 0.0 11704834 20-Willard - Hay 2020/01/01 00:00:00+00         0   0   0           Willard - Hay 122931   3378 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29146
29147 0.0 0.0 11704835 10-Sumner - Glenwood 2010/01/01 00:00:00+00         0   0   0           Sumner - Glenwood 314926   1084 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29147
29148 0.0 0.0 11704836 08-Whittier 2008/01/01 00:00:00+00         0   0   0           Whittier 322402   13263 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29148
29149 0.0 0.0 11704837 12-East Isles 2012/01/01 00:00:00+00         0   0   0           East Isles 324520   2953 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29149
29150 0.0 0.0 11704838 11-Midtown Phillips 2011/01/01 00:00:00+00         0   0   0           Midtown Phillips 313095   4923 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29150
29151 0.0 0.0 11704839 14-Folwell 2014/01/01 00:00:00+00         0   0   0           Folwell 355617   9214 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29151
29152 0.0 0.0 11704840 12-Bancroft 2012/01/01 00:00:00+00         0   0   0           Bancroft 324520   1069 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29152
29153 0.0 0.0 11704841 19-Loring Park 2019/01/01 00:00:00+00         0   0   0           Loring Park 301999   7621 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29153
29154 0.0 0.0 11704842 13-Wenonah 2013/01/01 00:00:00+00         0   0   0           Wenonah 351659   2122 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29154
29155 0.0 0.0 11704843 08-Hiawatha 2008/01/01 00:00:00+00         0   0   0           Hiawatha 322402   1887 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29155
29156 0.0 0.0 11704844 20-Bancroft 2020/01/01 00:00:00+00         0   0   0           Bancroft 122931   421 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29156
29157 0.0 0.0 11704845 08-Near - North 2008/01/01 00:00:00+00         0   0   0           Near - North 322402   10077 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29157
29158 0.0 0.0 11704846 10-Longfellow 2010/01/01 00:00:00+00         0   0   0           Longfellow 314926   5654 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29158
29159 0.0 0.0 11704847 20-Longfellow 2020/01/01 00:00:00+00         0   0   0           Longfellow 122931   2580 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29159
29160 0.0 0.0 11704848 13-Cedar Riverside 2013/01/01 00:00:00+00         0   0   0           Cedar Riverside 351659   7596 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29160
29161 0.0 0.0 11704849 10-Lyndale 2010/01/01 00:00:00+00         0   0   0           Lyndale 314926   6727 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29161
29162 0.0 0.0 11704850 15-McKinley 2015/01/01 00:00:00+00         0   0   0           McKinley 359611   5757 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29162
29163 0.0 0.0 11704851 19-Armatage 2019/01/01 00:00:00+00         0   0   0           Armatage 301999   846 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29163
29164 0.0 0.0 11704852 19-St. Anthony East 2019/01/01 00:00:00+00         0   0   0           St. Anthony East 301999   1008 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29164
29165 0.0 0.0 11704853 18-Columbia Park 2018/01/01 00:00:00+00         0   0   0           Columbia Park 344333   1300 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29165
29166 0.0 0.0 11704854 17-Columbia Park 2017/01/01 00:00:00+00         0   0   0           Columbia Park 380794   807 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29166
29167 0.0 0.0 11704855 11-Columbia Park 2011/01/01 00:00:00+00         0   0   0           Columbia Park 313095   730 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29167
29168 0.0 0.0 11704856 14-Standish 2014/01/01 00:00:00+00         0   0   0           Standish 355617   1949 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29168
29169 0.0 0.0 11704857 14-Cedar - Isles - Dean 2014/01/01 00:00:00+00         0   0   0           Cedar - Isles - Dean 355617   1212 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29169
29170 0.0 0.0 11704858 16-Cooper 2016/01/01 00:00:00+00         0   0   0           Cooper 347093   1183 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29170
29171 0.0 0.0 11704859 08-University of Minnesota 2008/01/01 00:00:00+00         0   0   0           University of Minnesota 322402   452 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29171
29172 0.0 0.0 11704860 18-Logan Park 2018/01/01 00:00:00+00         0   0   0           Logan Park 344333   1843 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29172
29173 0.0 0.0 11704861 20-Audubon Park 2020/01/01 00:00:00+00         0   0   0           Audubon Park 122931   1015 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29173
29174 0.0 0.0 11704862 08-Sumner - Glenwood 2008/01/01 00:00:00+00         0   0   0           Sumner - Glenwood 322402   1123 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29174
29175 0.0 0.0 11704863 13-ECCO 2013/01/01 00:00:00+00         0   0   0           ECCO 351659   2018 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29175
29176 0.0 0.0 11704864 18-Victory 2018/01/01 00:00:00+00         0   0   0           Victory 344333   2209 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29176
29177 0.0 0.0 11704865 19-Harrison 2019/01/01 00:00:00+00         0   0   0           Harrison 301999   2228 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29177
29178 0.0 0.0 11704866 08-Como 2008/01/01 00:00:00+00         0   0   0           Como 322402   2877 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29178
29179 0.0 0.0 11704867 13-Armatage 2013/01/01 00:00:00+00         0   0   0           Armatage 351659   978 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29179
29180 0.0 0.0 11704868 11-Bottineau 2011/01/01 00:00:00+00         0   0   0           Bottineau 313095   1158 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29180
29181 0.0 0.0 11704869 09-Ericsson 2009/01/01 00:00:00+00         0   0   0           Ericsson 316150   1191 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29181
29182 0.0 0.0 11704870 10-Diamond Lake 2010/01/01 00:00:00+00         0   0   0           Diamond Lake 314926   1534 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29182
29183 0.0 0.0 11704871 17-Logan Park 2017/01/01 00:00:00+00         0   0   0           Logan Park 380794   1820 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29183
29184 0.0 0.0 11704872 14-Mid - City Industrial 2014/01/01 00:00:00+00         0   0   0           Mid - City Industrial 355617   1604 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29184
29185 0.0 0.0 11704873 11-Northeast Park 2011/01/01 00:00:00+00         0   0   0           Northeast Park 313095   1524 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29185
29186 0.0 0.0 11704874 17-East Phillips 2017/01/01 00:00:00+00         0   0   0           East Phillips 380794   9897 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29186
29187 0.0 0.0 11704875 15-Sumner - Glenwood 2015/01/01 00:00:00+00         0   0   0           Sumner - Glenwood 359611   1200 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29187
29188 0.0 0.0 11704876 10-Prospect Park - East River Road 2010/01/01 00:00:00+00         0   0   0           Prospect Park - East River Road 314926   3861 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29188
29189 0.0 0.0 11704877 10-Standish 2010/01/01 00:00:00+00         0   0   0           Standish 314926   2275 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29189
29190 0.0 0.0 11704878 14-Whittier 2014/01/01 00:00:00+00         0   0   0           Whittier 355617   16565 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29190
29191 0.0 0.0 11704879 14-Willard - Hay 2014/01/01 00:00:00+00         0   0   0           Willard - Hay 355617   9611 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29191
29192 0.0 0.0 11704880 14-Armatage 2014/01/01 00:00:00+00         0   0   0           Armatage 355617   939 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29192
29193 0.0 0.0 11704881 17-King Field 2017/01/01 00:00:00+00         0   0   0           King Field 380794   3380 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29193
29194 0.0 0.0 11704882 08-Victory 2008/01/01 00:00:00+00         0   0   0           Victory 322402   2497 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29194
29195 0.0 0.0 11704883 15-Marcy Holmes 2015/01/01 00:00:00+00         0   0   0           Marcy Holmes 359611   11118 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29195
29196 0.0 0.0 11704884 18-Field 2018/01/01 00:00:00+00         0   0   0           Field 344333   678 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29196
29197 0.0 0.0 11704885 11-Holland 2011/01/01 00:00:00+00         0   0   0           Holland 313095   4642 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29197
29198 0.0 0.0 11704886 20-Hiawatha 2020/01/01 00:00:00+00         0   0   0           Hiawatha 122931   842 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29198

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Police_Use_of_Force" (
"X" REAL,
  "Y" REAL,
  "PoliceUseOfForceID" INTEGER,
  "CaseNumber" TEXT,
  "ResponseDate" TEXT,
  "Problem" TEXT,
  "Is911Call" TEXT,
  "PrimaryOffense" TEXT,
  "SubjectInjury" TEXT,
  "ForceReportNumber" INTEGER,
  "SubjectRole" TEXT,
  "SubjectRoleNumber" INTEGER,
  "ForceType" TEXT,
  "ForceTypeAction" TEXT,
  "Race" TEXT,
  "Sex" TEXT,
  "EventAge" INTEGER,
  "TypeOfResistance" TEXT,
  "Precinct" TEXT,
  "Neighborhood" TEXT,
  "TotalCityCallsForYear" INTEGER,
  "TotalPrecinctCallsForYear" INTEGER,
  "TotalNeighborhoodCallsForYear" INTEGER,
  "CenterGBSID" INTEGER,
  "CenterLatitude" REAL,
  "CenterLongitude" REAL,
  "CenterX" REAL,
  "CenterY" REAL,
  "DateAdded" TEXT,
  "OBJECTID" INTEGER
);