Select Page

Parsing NYPD in 311 data

  Number of service requests to NYC’s 311 from 2004 to 2016: 24.54 million
In one of my earlier posts, I wrote that I was trying to explain correlation vs. causation to a friend. At the same time, and ongoing, there is an ice-cream truck parked outside my window, under a “No Standing Anytime” sign no less. In an intersection to boot.  Loud engine running constantly, of course.  Complaints of this type to 311 get forwarded to NYPD. That night  NYPD closed out the complaint saying they investigated and had “determined that police action was not necessary.”Which was different from the close-out note for other of my complaints which said the party responsible was gone by the time they got there. It started a train of thought – how lax or non- enforcement would play out under (the Giuliani administration’s) broken-windows theory of policing which postulates that apathy (like not fixing a broken window in an unoccupied building) and not tackling petty crimes only leads to more serious crime. You notice and think a little more about trucks parked illegally than most people when you live in the shadow of the World Trade Center, like I do. That would be an outlier concern as correlation and causation goes, but how much of an outlier is it?

I wondered how often NYPD “took action to fix the condition” versus all the other options. And, was there any correlation between the ratio of action-taken and action-could-not-be-taken to overall quality of life markers, crime etc? Only one way to find out – keep digging.

Of the 24.54 million complaints to 311 since 2004,  4.02 million got forwarded to NYPD for action.  How many complaints per year? The distribution over time? And on and on down an endless list of questions.

Turns out there is some disagreement on the web about the hex code for “NYPD blue.” At any rate, here are the service requests to 311 sent on to NYPD over the years:

SRs to NYPD over time

Looks like there was a sharp jump from 2009 to 2010 and a steady and steep rise starting in 2012. Why? Maybe the issues involved in the 311 complaints got worse, maybe complaints that went to a different department now started going to NYPD, maybe a case of “when it works, it works” –  people who didn’t complain before start complaining because they think there is a positive outcome from complaining. I will be focusing more on questions that can be answered by the data. Stay tuned.


311 data from NYC Open Data downloaded at various times. As of Feb 19, 2017, 24.5 million rows, 52 variables till 2009, 53 variables from 2010. Parsed using R v3.3.1 in RStudio v1.0.136

About The Author

Leave a reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.