Laquan, CPD, and Data

The last week in Chicago politics and law enforcement has been a lot. The Van Dyke trial was a difficult moment for the city. Conversations about the impact of the decision on young Black men, cops, families, the courts, the police department, activists, and politicians were running hot.

While I’ve had brief conversations with police and criminology experts, I’m no expert. In these situations I try to listen. After processing the verdict, I finally got around to reading the multi-part reporting done by the Invisible Institute for The Intercept. The Chicago Files is a series about the shooting of Laquan McDonald and the larger problems in the Chicago Police Department. What was exciting to me about this piece, and what I hadn’t realized, is that they were able to use the Freedom of Information Act (FOIA) to obtain a tremendous amount of data from the Chicago Police Department!

While I’ve got a couple of interesting points to make, the larger point that I want to make is that our city’s data is powerful. Part of the reason that I’m running for city council is so that I can spend more time and have more access to working with this kind of municipal data.

For example, in 2008 the city sold the parking meters for 75 years to a politically connected firm for $1b (billion). It turns out they’re worth closer to $10b. Then, there is the county’s property tax assessments have been done according to the whims of Cook County Assessor Joe Berrios and politically connected property tax attorneys. The tax burden has been passed from corporations and our wealthy neighbors to minority and low-income households. Another equally egregious example is the city’s lead poisoning prediction algorithm. It relies on private medical data to which only certain city employees have access. I suggested to the city’s chief data officer, Tom Schenk, that we could find out exactly how much impact water main replacements were having on children’s lead levels using readily available data. We’ve been performing an experiment on our children for the last 7 years. We’ve done this by randomly replacing children’s water mains and then giving the families no filters and little information. Doing this analysis would be ground-breaking research for the public health community. We’ve already done the experiment! And yet, the city is totally uninterested in doing the analysis. I suspect this is politically motivated.

That said, while huge sums of tax dollars and the health of our children deserve the public’s interest, policing is a life and death issue. So there may be no more important data set than the one I stumbled upon these last few days.


Last Friday, I watched as a jury convicted Jason Van Dyke of 2nd degree murder and 16 counts of aggravated battery for shooting Laquan McDonald. It was an emotional moment. A lot of people wanted to say something and a lot of people wanted to hear something.

Almost two decades ago I sat through a trial for a loved one that was killed in a hit and run homocide. The reading of the Van Dyke verdict unexpectedly brought back a lot of emotions, but it also reminded me of the emotional and intellectual maturity that one develops living through such an incident and the ensuing legal process. I decided that I wanted to hear what the family had to say. Mauricio Pena’s reporting provided that:

“All police are not bad,” he said. “I have police officers in my family, I have police officers that belong to this church.”

But “let us never forget,” he added, that Van Dyke had 20 excessive force complaints against him. A functioning system would not allow that officer to continue serving, he said urging for a change to the Fraternal Order of Police contract to ensure justice.

“Give the superintendent in the police department the power that he need to fire bad police officers,” he said.

“Before the payout for Laquan McDonald, [Van Dyke] had already cost the city of Chicago over $500,000, and they never thought it to be a red flag to get rid of him,” he said.

Coming from a family that’s been in Chicago for 4 generations, it shouldn’t come as a surprise that I also have Chicago police officers in my extended family. As I’ve gotten older, cops have become friends and neighbors. I know police are not all bad. But I also grew up sometimes-poor in an upper-middle class school district and played in a hippie jam band touring the Midwest for 15 years. Cops have not always been friendly.


Jamie Kalven and the Invisible Institute did a tremendous amount of work FOIA’ing the Chicago Police Department’s records. Despite the Fraternal Order of Police working very hard to keep those records under wraps, multiple judges ruled that these records belong to the public.

Some of their findings were:

It’s great to have this data and hopefully this makes CPD change. But none of this should come as a surprise to anyone that lives in the city or understands the social pressures for those in law enforcement.

Another great result of all of the Invisible Institute’s work is the Citizens Police Data Project (CPDP). If you go to that website you’ll find a Data link at the top.

One thing that immediately stood out to me is the “Officers” section. The graphic puts a lot of officers in the red, which represents an officer with 13 or more complaints. As I poked around a bit more, I noticed that that spectrum of good and bad officers used only the number of complaints. This is a mistake. You can imagine a decent officer that serves for 26 years and gets a complaint every other year. This would make them a typical member of CPD. Moreover, law enforcement is a part of the service sector. (It’s right there! “To serve and protect.") So you can also imagine, if you’ve ever worked a service job, that you’re going to get occasional complaints.

This meme brought me back to my cashier days at UIC Hospital’s parking garages.

Police work is a service sector job that involves making people do things that they don’t want to do. You’re going to get some complaints. So I wanted to dig into this a little more.


Let me be clear: The pattern of violence used by CPD needs to be addressed. This analysis is not meant to let CPD off of the hook. This is only meant to provide a clearer analysis of how to go about addressing the problems in the department.

CPDP has made the data easily available to the public. Poking around a little bit, I found the data that I needed to be able to analyze individual officers' complaint rates.

As an example of the data that I used, let’s look at some of Jason Van Dyke’s data:

first_name middle_initial last_name birth_year race gender appointed_date resignation_date num.complaints num.sustained complaints.per.year sustained.per.year
JASONDVAN DYKE1978WHITEMALE2001-06-252018-10-122611.50.06
Clearly he didn't resign today, this data is just a little old and he hadn't been found guilty yet. For other officers still on the job, I have to put in today's date so I can calculate how long they've been working. I use that and his 26 complaints to calculate an average of 1.5 complaints per year. Also notice "num.sustained", that's the number of sustained complaints; or complaints found to be valid, typically resulting in a suspension.

To make my initial point, here are some veteran cops that have fewer than the average number of complaints (0.55 complaints per year), but have served for so long that they are in the CPDP’s red zone:

first_name last_name appointed_date resignation_date complaints.per.year sustained.per.year
Let's look at the distribution of complaints per year:0% 5% 10% 15% 20% 25% 30% 35% 40% 45% 50% 55% 60% 65% 70% 75% 80% 85% 90% 95% 100%
The median officer gets 0.39 complaints per year. The worst officer gets 12.94 complaints per year. An officer gets a complaint, on average, every 1.8 years.

To go the other way, here are some rookie cops that have only one or two complaints (putting them in CPDP’s green rating), but their complaint rate puts them in the top 5% of complainees:

first_name last_name appointed_date resignation_date complaints.per.year sustained.per.year
Their complaint rate is so high because they were let go shortly after the complaint was made. Certainly not model officers deserving of a green rating.

Let’s check out the distribution of sustained complaints per year:

0% 5% 10% 15% 20% 25% 30% 35% 40% 45% 50% 55% 60% 65% 70% 75% 80% 85% 90% 95% 100%
The median officer doesn't have a complaint. An officer gets a sustained complaint, on average, every 24 years.

Police Units and Districts

Part 5 of The Intercept series, Bad cops spread their misconduct like a disease, highlights disparities between clusters of cops.

Officers [linked to other officers with 100 or more complaints] show not only higher rates of complaints, but also participate in more uses of force and even more shootings. On its own, such a pattern could simply mean that these particular officers are more likely to be street cops or assigned to high-crime divisions. But these central officers are also more than five times as likely to figure in an incident that results in a civil payout by the city for misconduct, according to data on lawsuits involving police officers gathered by the Chicago Reporter.

This pointed me towards looking at the units cops are assigned to. The first thing I wanted to know is how many officers in this dataset are in each unit and see how different units compare on their average complaint rate.

UNIT Population Complaint.Mean

39Equipment and Supply Section10.08
22Special Events Unit30.13
80Recruit Training10510.13
40Telecommunications Unit40.14
42Reproduction and Graphic Arts Section20.15
89Detached Services - Miscellaneous Detail340.19
28Traffic Court Unit100.19
20Bureau of Organizational Development70.19
45Youth Investigation Section340.21
46Bureau of Organized Crime210.21
31General Support Division110.24
81Special Activities Section100.24
26Bureau of Patrol820.26
62Medical Services Section40.27
6Legal Affairs Section130.28
68OEMC-Detail Section380.29
41Forensic Services Division1110.29
93Helicopter Unit30.30
14Public Safety Information Technology (PSIT)260.30
5Office of the Superintendent90.32
17Professional Counseling Division90.32
33Records Inquiry Section20.32
36Police Documents Section120.33
94Arson Section770.33
12Human Resources Division620.34
24Office of the First Deputy Superintendent400.34
58Bureau of Patrol - Area North20.35
25Special Functions Division220.35
104Special Investigations Unit610.35
52Asset Forfeiture Investigations Section520.37
32Records Division10.37
34Field Services Section300.37
10Bureau of Administration120.38
18Management and Labor Affairs Section50.39
88Detached Services - Governmental Security Detail350.39
11Bureau of Internal Affairs1540.40
35Evidence and Recovered Property Section380.41
96Major Accident Investigation Unit590.41
44Bureau of Detectives330.42
16Research and Development Division190.42
87FOP Detail100.43
15Inspection Division200.45
64Troubled Buildings Section40.45
63District 244170.45
38Central Detention860.46
85Airport Law Enforcement Unit-North3780.46
8Deployment Operations Center440.46
91Marine Unit650.46
13Education and Training Division1900.46
66District Executive Officers Unit180.46
9District 125660.48
37District 173930.49
29District 155070.50
77Juvenile Intervention Support Center (JISC)750.50
54District 204010.51
69Forensic Services - Evidence Technician Section1130.52
99Bureau of Detectives - Area North5890.52
48District 196310.52
83District Reinstatement510.53
65District 255190.54
1District 15820.54
23District 143840.55
30District 164700.55
82Bomb Unit180.55
50Vice and Asset Forfeiture Division980.56
90Mounted Patrol Unit420.56
86Airport Law Enforcement Unit-South1310.56
102CTA Security Unit10.57
3Office of News Affairs50.57
101Public Transportation Section3460.57
53District 26140.58
43District 186040.58
61District 23720.58
19District 13820.59
97Bureau of Detectives - Area Central5790.59
4District 115650.59
2District 105100.59
27Traffic Section1120.60
55District 21890.61
70District 35890.61
67Court Section70.61
95Central Investigations Division570.62
100District 76300.63
56Bureau of Patrol - Area Central30.63
98Bureau of Detectives - Area South4670.65
106District 95140.65
75Special Weapons and Tactics (SWAT) Unit840.67
84District 55560.68
57Bureau of Patrol - Area South50.68
92District 65730.71
60District 224630.71
78Gang Enforcement Division280.73
49Intelligence Section560.73
74Canine Unit550.75
7Office of Crime Control Strategies120.76
79District 45510.77
103Transit Security Unit110.77
105District 86090.78
51Gang Investigation Division2281.01
47Narcotics Division4171.01
76Alternate Response Section231.02
73Gang Enforcement - Area North401.12
71Gang Enforcement - Area Central561.13
72Gang Enforcement - Area South591.29
21Chicago Alternative Policing Strategy (CAPS) Division31.42
59Office of Freedom of Information21.63
The 2 cops in the FOIA office have the highest complaint rate!? That's just too good! I wonder how many of those are from the Invisible Institute? LOL.

Not a lot of complaints for that one person in Equipment and Supply or those three people in the Special Events Unit. Recruit Training is the biggest unit and they have fewest complaints for a sizeable unit. That’s makes sense. There’s not a lot of civilian interaction and it’d be a bold recruit that files a complaint against the person responsible for giving them a job!

The 3 CAPS officers have the 2nd highest complaint rate? Surprising, but this reinforces the service nature of job! (and the small sample size.) Then the Gang Enforcement units come in. This is not surprising given the department’s reputation and, if I were in a gang, I’d know my rights… including my right to talk to the manager!

Next, let’s dig into the districts. This graph shows the median officer complaint rate compared to the 95th percentile officer complaint rate in each district. This will tell us how the average officer compares to the worst officers in each district:

I’m happy to see the 12 District that covers most of the 25th Ward is almost the best! Second only to District 24/Rogers Park. But Districts 8, 4, and 6 are not doing well! 5, 22, and 9 are also not doing super great. I had to look up where those are; courtesy of the SunTimes:

The worst district, District 8, is around Midway. Where was Van Dyke assigned? District 8.

4 is the southeast side, and 6 is around Englewood. 5 is Pullman/Roseland, 9 is Bridgeport/Back of the Yards/Brighton Park, and 22 is Beverly/Morgan Park… which is surprising. Because Beverly is famously full of cops.

Let me speak to the manager supervisor!

Those are complaints. What about sustained complaints? Let’s plot the median officer sustained complaint rate against the 95th percentile officer sustained complaint rate in each district:

So the only Districts where the median officer has a sustained complaint rate above zero are 18, 22, and 2. Where are those? Lincoln Park/Gold Coast, Beverly/Morgan Park, and Hyde Park.

So it would seem “The Manager” is willing to listen to and take seriously the elite in society; doctors, lawyers, cops, and professors. It’s unfortunate, but not surprising, that regular Chicagoans aren’t being heard.

Finally, I asked myself:

How did Van Dyke compare to the rest of the 8th district?

This was already the district with the most complaints. It turns out he was in the 87th percentile. That means that out of 100 hundred officers in the worst district, he’d have the 87th most complaints.

Van Dyke was a bad officer in a bad district, where complaints weren’t/aren’t being heard by leadership. You can see in the above plot, despite having the highest complaint rate, the 8th District doesn’t even rank in the top 7 of sustained complaint rates against it’s worst officers (in the 95th percentile).

As the Chicago Files series suggests, this is a culture problem! Part of that culture is leadership not responding to complaints coming from regular Chicagoans.

Police officers make mistakes, they’re human. The problems multiply when “mistakes” become procedure. Then that procedure is tolerated by leadership up until it becomes a lawsuit. That’s my takeaway anyway. I’m happy to hear differing opinions. Regardless, I’m glad this data is public, because we need more eyes on the problem… and now we have something to talk about at the next family party :|

If you’d like to check or reproduce my work, you can do so here.