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 SubjectRole

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
19121 -93.28461788766529 44.999132072465706 11694809 20-144264 2020/05/28 23:14:14+00 Burglary Biz - In Progress Yes BURGB   2     Chemical Irritant Crowd Control Mace not recorded not recorded   Commission of a Crime 04 Near - North 122931 30055 3943 17353 44.999132 -93.28461800000001 -10384396.1621 5621384.8498 2020/06/17 08:19:17+00 19121
20178 -93.25030406829029 44.970168443937 11695866 20-117652 2020/05/03 22:50:33+00 Traffic Law Enforcement No FLEEFT Yes 2     Bodily Force Body Weight Pin not recorded not recorded   Fled in a Vehicle 01 Cedar Riverside 122931 22064 2253 20124 44.970168 -93.250304 -10380576.3652 5616826.3402 2020/06/17 08:19:17+00 20178
20649 -93.2477418593009 44.977486779916 11696337 20-109510 2020/04/26 01:39:30+00 Suspicious Person No FLEEFT No 2     Bodily Force Takedown not recorded not recorded   Fled on Foot 01 Downtown East 122931 22064 886 25756 44.977486999999996 -93.247742 -10380291.1414 5617977.9365 2020/06/17 08:19:17+00 20649
21822 -93.2477418593009 44.977486779916 11697510 20-109510 2020/04/26 01:39:30+00 Suspicious Person No FLEEFT No 2     Bodily Force Body Weight Pin not recorded not recorded   Fled on Foot 01 Downtown East 122931 22064 886 25756 44.977486999999996 -93.247742 -10380291.1414 5617977.9365 2020/06/17 08:19:17+00 21822
21983 -93.27719766507792 44.9591939788805 11697671 20-066800 2020/03/12 17:14:38+00 Fight Yes ASLT5   1     Taser Red Dot not recorded not recorded     05 Whittier 122931 22988 4840 17960 44.959194000000004 -93.277198 -10383570.1467 5615099.6993 2020/06/17 08:19:17+00 21983
22939 -93.2603017882948 44.973563881688996 11698627 20-147686 2020/05/31 15:16:45+00 Miscellaneous No ASLT3   4     Chemical Irritant Crowd Control Mace not recorded not recorded   Other 01 Elliot Park 122931 22064 2477 18598 44.973564 -93.260302 -10381689.3063 5617360.6201 2020/06/17 08:19:17+00 22939
23568 -93.23327765372 44.9470244618666 11699256 20-141909 2020/05/26 22:29:11+00 Police Event No FORCE   1     Less Lethal Bean Bag Round not recorded not recorded   Other 03 Longfellow 122931 29136 2580 25951 44.947024 -93.233278 -10378680.9934 5613185.4239 2020/06/17 08:19:17+00 23568
23676 -93.28184224435431 44.999110933160104 11699364 20-159675 2020/06/14 01:56:29+00 ShotSpotter Activation Yes ASLT2   1     Chemical Irritant Crowd Control Mace not recorded not recorded   Other 04 Hawthorne 122931 30055 5409 25492 44.999111 -93.281842 -10384087.1789 5621381.5219 2020/06/17 08:19:17+00 23676
24817 -93.2779287275309 44.9439412100435 11700505 20-093698 2020/04/09 21:25:42+00 Check the Welfare No DASLT3   2     Bodily Force Body Weight Pin not recorded not recorded   Assaulted Officer 05 Lyndale 122931 22988 2518 11375 44.943940999999995 -93.277929 -10383651.5282 5612700.4902 2020/06/17 08:19:17+00 24817
24818 -93.2477418593009 44.977486779916 11700506 20-109510 2020/04/26 01:39:30+00 Suspicious Person No FLEEFT No 2     Bodily Force Punch not recorded not recorded   Fled on Foot 01 Downtown East 122931 22064 886 25756 44.977486999999996 -93.247742 -10380291.1414 5617977.9365 2020/06/17 08:19:17+00 24818
25876 -93.2603017882948 44.973563881688996 11701564 20-147686 2020/05/31 15:16:45+00 Miscellaneous No ASLT3   3     Chemical Irritant Crowd Control Mace not recorded not recorded   Other 01 Elliot Park 122931 22064 2477 18598 44.973564 -93.260302 -10381689.3063 5617360.6201 2020/06/17 08:19:17+00 25876
25982 -93.2322631054213 44.9573692212659 11701670 20-149600 2020/06/01 23:20:15+00 Suspicious Vehicle No WEAP Yes 2     Less Lethal Bean Bag Round not recorded not recorded   Assaulted Officer 03 Seward 122931 29136 2130 17458 44.957369 -93.232263 -10378568.0544 5614812.6375 2020/06/17 08:19:17+00 25982
26284 -93.24740736352008 44.94922115003221 11701972 20-118581 2020/05/04 21:13:21+00 Audible Business Alarm No BURGB   1     Bodily Force Takedown not recorded not recorded   Fled on Foot 03 East Phillips 122931 29136 3241 21417 44.949221 -93.247407 -10380253.9055 5613530.9348 2020/06/17 08:19:17+00 26284
26984 -93.27781609586219 44.96938053279321 11702672 20-079897 2020/03/26 16:56:35+00 Emotionally Disturb Person Yes CIC   1     Bodily Force Body Weight Pin not recorded not recorded   Verbal Non-Compliance 01 Loring Park 122931 22064 3621 16712 44.969381 -93.277816 -10383638.9901 5616702.3651 2020/06/17 08:19:17+00 26984
27198 -93.3169166762636 44.897985328007096 11702886 20-133740 2020/05/19 18:20:16+00 Stabbing Yes DASLT2   1     Bodily Force Push Away not recorded not recorded   Other 05 Armatage 122931 22988 322 13548 44.897985 -93.316917 -10387991.6468 5605475.636 2020/06/17 08:19:17+00 27198
27616 -93.23327765372 44.9470244618666 11703304 20-142257 2020/05/27 11:36:02+00 Miscellaneous Yes ASLT4   1         not recorded not recorded     03 Longfellow 122931 29136 2580 25951 44.947024 -93.233278 -10378680.9934 5613185.4239 2020/06/17 08:19:17+00 27616
27620 -93.2631495681197 44.9789002748219 11703308 20-151727 2020/06/03 23:09:35+00 Suspicious Person No FLEEFT   2     Less Lethal Bean Bag Round not recorded not recorded   Fled on Foot 01 Downtown West 122931 22064 10461 16801 44.9789 -93.26315 -10382006.3197 5618200.3777 2020/06/17 08:19:17+00 27620
28058 -93.24231926712321 44.945651218298295 11703746 20-143334 2020/05/28 03:50:21+00 Chase on Foot No ASLT2   1     Less Lethal Bean Bag Round not recorded not recorded   Assaulted Officer 03 Corcoran 122931 29136 1090 11584 44.945651 -93.242319 -10379687.5012 5612969.437000001 2020/06/17 08:19:17+00 28058
28990 0.0 0.0 11704678 12-Cedar Riverside 2012/01/01 00:00:00+00         0   0   0           Cedar Riverside 324520   5124 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 28990
28991 0.0 0.0 11704679 10-Elliot Park 2010/01/01 00:00:00+00         0   0   0           Elliot Park 314926   7099 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 28991
28992 0.0 0.0 11704680 08-Longfellow 2008/01/01 00:00:00+00         0   0   0           Longfellow 322402   5577 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 28992
28993 0.0 0.0 11704681 09-Bottineau 2009/01/01 00:00:00+00         0   0   0           Bottineau 316150   1246 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 28993
28994 0.0 0.0 11704682 10-Holland 2010/01/01 00:00:00+00         0   0   0           Holland 314926   4178 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 28994
28995 0.0 0.0 11704683 12-Hawthorne 2012/01/01 00:00:00+00         0   0   0           Hawthorne 324520   12652 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 28995
28996 0.0 0.0 11704684 11-St. Anthony West 2011/01/01 00:00:00+00         0   0   0           St. Anthony West 313095   1272 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 28996
28997 0.0 0.0 11704685 15-University of Minnesota 2015/01/01 00:00:00+00         0   0   0           University of Minnesota 359611   856 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 28997
28998 0.0 0.0 11704686 15-Near - North 2015/01/01 00:00:00+00         0   0   0           Near - North 359611   11755 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 28998
28999 0.0 0.0 11704687 13-Powderhorn Park 2013/01/01 00:00:00+00         0   0   0           Powderhorn Park 351659   8374 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 28999
29000 0.0 0.0 11704688 10-CARAG 2010/01/01 00:00:00+00         0   0   0           CARAG 314926   2763 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29000
29001 0.0 0.0 11704689 16-Bottineau 2016/01/01 00:00:00+00         0   0   0           Bottineau 347093   1563 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29001
29002 0.0 0.0 11704690 08-Downtown East 2008/01/01 00:00:00+00         0   0   0           Downtown East 322402   1271 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29002
29003 0.0 0.0 11704691 12-Cooper 2012/01/01 00:00:00+00         0   0   0           Cooper 324520   926 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29003
29004 0.0 0.0 11704692 15-Keewaydin 2015/01/01 00:00:00+00         0   0   0           Keewaydin 359611   870 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29004
29005 0.0 0.0 11704693 20-Morris Park 2020/01/01 00:00:00+00         0   0   0           Morris Park 122931   268 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29005
29006 0.0 0.0 11704694 15-Beltrami 2015/01/01 00:00:00+00         0   0   0           Beltrami 359611   1091 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29006
29007 0.0 0.0 11704695 18-Cedar - Isles - Dean 2018/01/01 00:00:00+00         0   0   0           Cedar - Isles - Dean 344333   927 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29007
29008 0.0 0.0 11704696 19-Kenny 2019/01/01 00:00:00+00         0   0   0           Kenny 301999   610 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29008
29009 0.0 0.0 11704697 11-King Field 2011/01/01 00:00:00+00         0   0   0           King Field 313095   3760 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29009
29010 0.0 0.0 11704698 14-Lind - Bohanon 2014/01/01 00:00:00+00         0   0   0           Lind - Bohanon 355617   3435 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29010
29011 0.0 0.0 11704699 20-McKinley 2020/01/01 00:00:00+00         0   0   0           McKinley 122931   1850 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29011
29012 0.0 0.0 11704700 14-Sumner - Glenwood 2014/01/01 00:00:00+00         0   0   0           Sumner - Glenwood 355617   1183 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29012
29013 0.0 0.0 11704701 18-Kenwood 2018/01/01 00:00:00+00         0   0   0           Kenwood 344333   452 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29013
29014 0.0 0.0 11704702 08-Marcy Holmes 2008/01/01 00:00:00+00         0   0   0           Marcy Holmes 322402   7209 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29014
29015 0.0 0.0 11704703 12-Harrison 2012/01/01 00:00:00+00         0   0   0           Harrison 324520   2511 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29015
29016 0.0 0.0 11704704 18-Morris Park 2018/01/01 00:00:00+00         0   0   0           Morris Park 344333   748 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29016
29017 0.0 0.0 11704705 12-Regina 2012/01/01 00:00:00+00         0   0   0           Regina 324520   1146 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29017
29018 0.0 0.0 11704706 11-Logan Park 2011/01/01 00:00:00+00         0   0   0           Logan Park 313095   1880 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29018
29019 0.0 0.0 11704707 14-North Loop 2014/01/01 00:00:00+00         0   0   0           North Loop 355617   5786 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29019
29020 0.0 0.0 11704708 11-Minnehaha 2011/01/01 00:00:00+00         0   0   0           Minnehaha 313095   1184 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29020
29021 0.0 0.0 11704709 15-St. Anthony East 2015/01/01 00:00:00+00         0   0   0           St. Anthony East 359611   1433 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29021
29022 0.0 0.0 11704710 13-Morris Park 2013/01/01 00:00:00+00         0   0   0           Morris Park 351659   752 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29022
29023 0.0 0.0 11704711 08-Folwell 2008/01/01 00:00:00+00         0   0   0           Folwell 322402   7483 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29023
29024 0.0 0.0 11704712 08-Northrop 2008/01/01 00:00:00+00         0   0   0           Northrop 322402   1453 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29024
29025 0.0 0.0 11704713 09-Downtown East 2009/01/01 00:00:00+00         0   0   0           Downtown East 316150   1603 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29025
29026 0.0 0.0 11704714 12-Windom Park 2012/01/01 00:00:00+00         0   0   0           Windom Park 324520   2815 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29026
29027 0.0 0.0 11704715 13-Cooper 2013/01/01 00:00:00+00         0   0   0           Cooper 351659   963 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29027
29028 0.0 0.0 11704716 08-Webber - Camden 2008/01/01 00:00:00+00         0   0   0           Webber - Camden 322402   5409 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29028
29029 0.0 0.0 11704717 14-Keewaydin 2014/01/01 00:00:00+00         0   0   0           Keewaydin 355617   908 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29029
29030 0.0 0.0 11704718 16-Whittier 2016/01/01 00:00:00+00         0   0   0           Whittier 347093   13400 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29030
29031 0.0 0.0 11704719 09-Howe 2009/01/01 00:00:00+00         0   0   0           Howe 316150   2374 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29031
29032 0.0 0.0 11704720 11-Webber - Camden 2011/01/01 00:00:00+00         0   0   0           Webber - Camden 313095   5255 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29032
29033 0.0 0.0 11704721 12-Marshall Terrace 2012/01/01 00:00:00+00         0   0   0           Marshall Terrace 324520   971 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29033
29034 0.0 0.0 11704722 11-Lyndale 2011/01/01 00:00:00+00         0   0   0           Lyndale 313095   8501 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29034
29035 0.0 0.0 11704723 11-Downtown West 2011/01/01 00:00:00+00         0   0   0           Downtown West 313095   25433 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29035
29036 0.0 0.0 11704724 10-Armatage 2010/01/01 00:00:00+00         0   0   0           Armatage 314926   1047 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29036
29037 0.0 0.0 11704725 08-Fulton 2008/01/01 00:00:00+00         0   0   0           Fulton 322402   988 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29037
29038 0.0 0.0 11704726 18-Jordan 2018/01/01 00:00:00+00         0   0   0           Jordan 344333   10365 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29038
29039 0.0 0.0 11704727 13-Como 2013/01/01 00:00:00+00         0   0   0           Como 351659   3312 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29039
29040 0.0 0.0 11704728 16-Kenwood 2016/01/01 00:00:00+00         0   0   0           Kenwood 347093   604 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29040
29041 0.0 0.0 11704729 09-Cleveland 2009/01/01 00:00:00+00         0   0   0           Cleveland 316150   2593 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29041
29042 0.0 0.0 11704730 20-Sumner - Glenwood 2020/01/01 00:00:00+00         0   0   0           Sumner - Glenwood 122931   521 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29042
29043 0.0 0.0 11704731 17-Field 2017/01/01 00:00:00+00         0   0   0           Field 380794   748 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29043
29044 0.0 0.0 11704732 09-CARAG 2009/01/01 00:00:00+00         0   0   0           CARAG 316150   2680 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29044
29045 0.0 0.0 11704733 09-Harrison 2009/01/01 00:00:00+00         0   0   0           Harrison 316150   2455 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29045
29046 0.0 0.0 11704734 15-Northeast Park 2015/01/01 00:00:00+00         0   0   0           Northeast Park 359611   2143 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29046
29047 0.0 0.0 11704735 09-Longfellow 2009/01/01 00:00:00+00         0   0   0           Longfellow 316150   5298 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29047
29048 0.0 0.0 11704736 10-Folwell 2010/01/01 00:00:00+00         0   0   0           Folwell 314926   7845 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29048
29049 0.0 0.0 11704737 14-Linden Hills 2014/01/01 00:00:00+00         0   0   0           Linden Hills 355617   2045 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29049
29050 0.0 0.0 11704738 12-Standish 2012/01/01 00:00:00+00         0   0   0           Standish 324520   2084 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29050
29051 0.0 0.0 11704739 16-Mid - City Industrial 2016/01/01 00:00:00+00         0   0   0           Mid - City Industrial 347093   2635 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29051
29052 0.0 0.0 11704740 10-Windom 2010/01/01 00:00:00+00         0   0   0           Windom 314926   2737 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29052
29053 0.0 0.0 11704741 16-Hiawatha 2016/01/01 00:00:00+00         0   0   0           Hiawatha 347093   2148 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29053
29054 0.0 0.0 11704742 13-Downtown East 2013/01/01 00:00:00+00         0   0   0           Downtown East 351659   1977 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29054
29055 0.0 0.0 11704743 11-Audubon Park 2011/01/01 00:00:00+00         0   0   0           Audubon Park 313095   3045 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29055
29056 0.0 0.0 11704744 09-Northrop 2009/01/01 00:00:00+00         0   0   0           Northrop 316150   1376 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29056
29057 0.0 0.0 11704745 11-Tangletown 2011/01/01 00:00:00+00         0   0   0           Tangletown 313095   1819 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29057
29058 0.0 0.0 11704746 11-Kenwood 2011/01/01 00:00:00+00         0   0   0           Kenwood 313095   416 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29058
29059 0.0 0.0 11704747 12-Willard - Hay 2012/01/01 00:00:00+00         0   0   0           Willard - Hay 324520   9216 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29059
29060 0.0 0.0 11704748 12-Near - North 2012/01/01 00:00:00+00         0   0   0           Near - North 324520   11920 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29060
29061 0.0 0.0 11704749 16-Windom 2016/01/01 00:00:00+00         0   0   0           Windom 347093   3485 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29061
29062 0.0 0.0 11704750 18-Longfellow 2018/01/01 00:00:00+00         0   0   0           Longfellow 344333   5587 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29062
29063 0.0 0.0 11704751 14-Marshall Terrace 2014/01/01 00:00:00+00         0   0   0           Marshall Terrace 355617   1162 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29063
29064 0.0 0.0 11704752 10-Willard - Hay 2010/01/01 00:00:00+00         0   0   0           Willard - Hay 314926   9493 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29064
29065 0.0 0.0 11704753 09-University of Minnesota 2009/01/01 00:00:00+00         0   0   0           University of Minnesota 316150   789 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29065
29066 0.0 0.0 11704754 08-Prospect Park - East River Road 2008/01/01 00:00:00+00         0   0   0           Prospect Park - East River Road 322402   3645 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29066
29067 0.0 0.0 11704755 20-Corcoran 2020/01/01 00:00:00+00         0   0   0           Corcoran 122931   1090 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29067
29068 0.0 0.0 11704756 20-Central 2020/01/01 00:00:00+00         0   0   0           Central 122931   2016 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29068
29069 0.0 0.0 11704757 15-Whittier 2015/01/01 00:00:00+00         0   0   0           Whittier 359611   18247 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29069
29070 0.0 0.0 11704758 08-Mid - City Industrial 2008/01/01 00:00:00+00         0   0   0           Mid - City Industrial 322402   1058 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29070
29071 0.0 0.0 11704759 10-Corcoran 2010/01/01 00:00:00+00         0   0   0           Corcoran 314926   2476 0 0.0 0.0 0.0 0.0 2020/06/17 08:35:04+00 29071

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