No. of Cases That Listed Officers as Defendants
No. of Cases
No 125
Yes 180
NA’s 5
No. of Cases That Listed Healthcare Professionals (Or Facilities) as Defendants
No. of Cases
No 155
Yes 149
NA’s 6 
## [1] 0.4108911
Case Outcomes.
No. of Cases
Defense Judgment 40
Defense Verdict 32
Plaintiff Verdict 21
Settlement 179
NA’s 38

Settlement and Plaintiff Verdicts Summaries

## $`Defense Judgment`
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max.    NA's 
##       0       0       0       0       0       0       2 
## 
## $`Defense Verdict`
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##       0       0       0       0       0       0 
## 
## $`Plaintiff Verdict`
##     Min.  1st Qu.   Median     Mean  3rd Qu.     Max.     NA's 
##        0   859914  1600000  3564219  5195000 11857344        2 
## 
## $Settlement
##     Min.  1st Qu.   Median     Mean  3rd Qu.     Max.     NA's 
##        0   196875   500000  1481579  1053750 12850000       91

Number of Cases by State and City

State of Incarceration
Alabama 4
Alaska 5
Arizona 4
Arkansas 1
California 32
Colorado 7
Florida 10
Georgia 6
Hawaii 1
Idaho 3
Illinois 31
Indiana 12
Iowa 3
Kansas 1
Kentucky 5
Louisiana 2
Maine 1
Maryland 1
Massachusetts 1
Michigan 9
Mississippi 9
Missouri 8
Nebraska 2
New Jersey 3
New Mexico 4
New York 10
North Carolina 4
North Dakota 1
NV 1
Ohio 15
Oklahoma 7
Oregon 9
Pennsylvania 17
South Carolina 7
Tennesee 1
Texas 20
Virginia 8
Washington 6
Wisconsin 6
NA’s 33
City or County of Incarceration
Cook County 14
Los Angeles County 9
Lake County 5
Monterey County 5
Allegheny County 4
Anchorage County 4
Orange County 4
Alameda County 3
Butler County 3
Delaware County 3
Franklin County 3
Maricopa County 3
Monroe County 3
Queens County 3
Bucks County 2
City of Chicago 2
City of Cottage Grove 2
City of Los Angeles 2
Cobb County 2
Cuyahoga County 2
DeKalb County 2
Hamilton County 2
Harris County 2
Lancaster County 2
Lane County 2
Lincoln County 2
Macomb County 2
Madison County 2
Marion County 2
Nassau County 2
Not Applicable 2
Oklahoma County 2
Santa Cruz County 2
Santa Fe County 2
Spartanburg County 2
St. Clair County 2
Union County 2
Warren County 2
Washington County 2
Wayne County 2
Woodbury County 2
York County 2
Adams County 1
Albemarle County 1
Benton County 1
Bernalillo County 1
Bexar County 1
Boundary County 1
Brazoria County 1
Bronx County 1
Broome County 1
Brown County 1
Caddo County 1
Calhoun County 1
Canyon County 1
Carbon County 1
Carter County 1
Cass County 1
City and County of Honolulu 1
City of Arlington 1
City of Baton Rouge 1
City of Bell 1
City of Cedar Rapids 1
City of El Centro 1
City of Eupora 1
City of Eureka; Humboldt County 1
City of Harvey 1
City of Indianola 1
City of La Habra 1
City of Newark 1
City of Portsmouth County 1
City of Tallahassee 1
City of Toledo 1
City of Tulsa 1
Cochise County 1
Columbia County 1
Conecuh County 1
Cook 1
Creek County 1
Cumberland County 1
Davidson County 1
Dawes County 1
Denver County 1
Dillman, Jeffrey 1
Durham County 1
Effingham County 1
Garfield 1
Georgetown County 1
Grand Forks County 1
Grundy County 1
Hamilton County, Ohio 1
Hansford County 1
Henderson County 1
Henrico County 1
Henry County 1
Hillsborough County 1
Hinds County 1
Houston County 1
(Other) 71
NA’s 61

Decendent Demographics:

Prexisting Conditions

Evidence of Mental Illiness Present

##   No  Yes NA's 
##  133  109   68

Evidence of Substance Use Issue Present

##   No  Yes NA's 
##  159   79   72

Evidence of Physical Health Issue Present

##   No  Yes NA's 
##  165   75   70

Causes of Death

## Gun Shot Wounds       INM Force Lack Treat Phys       OFC Force        Overdose 
##               1               9              67              27              17 
##         Suicide        Withdraw            NA's 
##              93              36              60

Number of Days from Incarceration to Death

##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max.    NA's 
##     0.0     1.0     4.0    42.4    15.5  1569.0     128

Run average days by cause of death

Average settlement number by state

relationship between metnal health and substance use issues and excessive use of force

settlement by COD

####NEW ANALYSIS– 1/27/21

##Average Award by State
x
Alabama c(Min. = 0, 1st Qu. = 0, Median = 0, Mean = 0, 3rd Qu. = 0, Max. = 0, NA's = 2)
Alaska c(Min. = 0, 1st Qu. = 0, Median = 0, Mean = 0, 3rd Qu. = 0, Max. = 0, NA's = 4)
Arizona c(Min. = 0, 1st Qu. = 0, Median = 204018, Mean = 602009, 3rd Qu. = 806027, Max. = 2e+06)
Arkansas c(Min. = 350000, 1st Qu. = 350000, Median = 350000, Mean = 350000, 3rd Qu. = 350000, Max. = 350000)
California c(Min. = 0, 1st Qu. = 365000, Median = 999995, Mean = 1627982.24137931, 3rd Qu. = 1750000, Max. = 9300000, NA's = 3)
Colorado c(Min. = 0, 1st Qu. = 0, Median = 0, Mean = 1162500, 3rd Qu. = 1162500, Max. = 4650000, NA's = 3)
Florida c(Min. = 0, 1st Qu. = 0, Median = 0, Mean = 68333.3333333333, 3rd Qu. = 153000, Max. = 206000, NA's = 4)
Georgia c(Min. = 0, 1st Qu. = 0, Median = 0, Mean = 0, 3rd Qu. = 0, Max. = 0, NA's = 3)
Hawaii c(Min. = 0, 1st Qu. = 0, Median = 0, Mean = 0, 3rd Qu. = 0, Max. = 0)
Idaho c(Min. = 0, 1st Qu. = 0, Median = 0, Mean = 31666.6666666667, 3rd Qu. = 47500, Max. = 95000)
Illinois c(Min. = 0, 1st Qu. = 0, Median = 1e+05, Mean = 240800, 3rd Qu. = 250000, Max. = 1700000, NA's = 6)
Indiana c(Min. = 68972, 1st Qu. = 68972, Median = 68972, Mean = 68972, 3rd Qu. = 68972, Max. = 68972, NA's = 11)
Iowa c(Min. = 0, 1st Qu. = 0, Median = 0, Mean = 0, 3rd Qu. = 0, Max. = 0, NA's = 1)
Kansas c(Min. = NA, 1st Qu. = NA, Median = NA, Mean = NaN, 3rd Qu. = NA, Max. = NA, NA's = 1)
Kentucky c(Min. = 0, 1st Qu. = 0, Median = 0, Mean = 5e+06, 3rd Qu. = 7500000, Max. = 1.5e+07, NA's = 2)
Louisiana c(Min. = 163000, 1st Qu. = 163000, Median = 163000, Mean = 163000, 3rd Qu. = 163000, Max. = 163000, NA's = 1)
Maine c(Min. = NA, 1st Qu. = NA, Median = NA, Mean = NaN, 3rd Qu. = NA, Max. = NA, NA's = 1)
Maryland c(Min. = NA, 1st Qu. = NA, Median = NA, Mean = NaN, 3rd Qu. = NA, Max. = NA, NA's = 1)
Massachusetts c(Min. = NA, 1st Qu. = NA, Median = NA, Mean = NaN, 3rd Qu. = NA, Max. = NA, NA's = 1)
Michigan c(Min. = 0, 1st Qu. = 0, Median = 0, Mean = 201250, 3rd Qu. = 245000, Max. = 950000, NA's = 1)
Mississippi c(Min. = 0, 1st Qu. = 0, Median = 0, Mean = 2500000, 3rd Qu. = 2500000, Max. = 1e+07, NA's = 5)
Missouri c(Min. = 0, 1st Qu. = 65000, Median = 275000, Mean = 500358.6, 3rd Qu. = 850000, Max. = 1311793, NA's = 3)
Nebraska c(Min. = 0, 1st Qu. = 0, Median = 0, Mean = 0, 3rd Qu. = 0, Max. = 0)
New Jersey c(Min. = 650000, 1st Qu. = 875000, Median = 1100000, Mean = 1100000, 3rd Qu. = 1325000, Max. = 1550000, NA's = 1)
New Mexico c(Min. = 0, 1st Qu. = 0, Median = 0, Mean = 0, 3rd Qu. = 0, Max. = 0, NA's = 2)
New York c(Min. = 3002000, 1st Qu. = 4224000, Median = 5446000, Mean = 5446000, 3rd Qu. = 6668000, Max. = 7890000, NA's = 8)
North Carolina c(Min. = 650000, 1st Qu. = 987500, Median = 1325000, Mean = 1325000, 3rd Qu. = 1662500, Max. = 2e+06, NA's = 2)
North Dakota c(Min. = NA, 1st Qu. = NA, Median = NA, Mean = NaN, 3rd Qu. = NA, Max. = NA, NA's = 1)
NV c(Min. = 15000, 1st Qu. = 15000, Median = 15000, Mean = 15000, 3rd Qu. = 15000, Max. = 15000)
Ohio c(Min. = 0, 1st Qu. = 0, Median = 0, Mean = 223500, 3rd Qu. = 213750, Max. = 1e+06, NA's = 5)
Oklahoma c(Min. = 0, 1st Qu. = 0, Median = 0, Mean = 2e+06, 3rd Qu. = 0, Max. = 1e+07, NA's = 2)
Oregon c(Min. = 0, 1st Qu. = 450000, Median = 5e+05, Mean = 2218750, 3rd Qu. = 1887500, Max. = 1e+07, NA's = 1)
Pennsylvania c(Min. = 0, 1st Qu. = 0, Median = 5928672, Mean = 5928672, 3rd Qu. = 11857344, Max. = 11857344, NA's = 13)
South Carolina c(Min. = 0, 1st Qu. = 111250, Median = 187500, Mean = 239285.714285714, 3rd Qu. = 257500, Max. = 750000)
Tennesee c(Min. = 5e+06, 1st Qu. = 5e+06, Median = 5e+06, Mean = 5e+06, 3rd Qu. = 5e+06, Max. = 5e+06)
Texas c(Min. = 0, 1st Qu. = 0, Median = 0, Mean = 472220.833333333, 3rd Qu. = 508750, Max. = 2421650, NA's = 8)
Virginia c(Min. = 0, 1st Qu. = 262500, Median = 8e+05, Mean = 3612500, 3rd Qu. = 4150000, Max. = 12850000, NA's = 4)
Washington c(Min. = 160000, 1st Qu. = 175000, Median = 6e+05, Mean = 2027000, 3rd Qu. = 1200000, Max. = 8e+06, NA's = 1)
Wisconsin c(Min. = 0, 1st Qu. = 0, Median = 0, Mean = 245500, 3rd Qu. = 490000, Max. = 737500, NA's = 1)
#Max Award by state
x
Alabama 0
Alaska 0
Arizona 2000000
Arkansas 350000
California 9300000
Colorado 4650000
Florida 206000
Georgia 0
Hawaii 0
Idaho 95000
Illinois 1700000
Indiana 68972
Iowa 0
Kansas -Inf
Kentucky 15000000
Louisiana 163000
Maine -Inf
Maryland -Inf
Massachusetts -Inf
Michigan 950000
Mississippi 10000000
Missouri 1311793
Nebraska 0
New Jersey 1550000
New Mexico 0
New York 7890000
North Carolina 2000000
North Dakota -Inf
NV 15000
Ohio 1000000
Oklahoma 10000000
Oregon 10000000
Pennsylvania 11857344
South Carolina 750000
Tennesee 5000000
Texas 2421650
Virginia 12850000
Washington 8000000
Wisconsin 737500