Number of service requests to NYC’s 311 from 2004 to 2017: 26.99 million

When a city agency closes out a 311 service request,  it is accompanied by a brief description of the action the agency took to dispose off the complaint. Of all noise complaints directed from 311 to the NYPD for resolution between 2004 and 2017, a total of 720,790 service requests were closed out but without any indication of what action was taken. One assumption is that no action was taken on these service requests, but they needed to be closed out. The breakdown by year is:

NAs as percent of total action-taken notes made by NYPD, by year
Year NAs Percentage
2004 118009 16.4
2005 106904 14.8
2006 100726 14.0
2007 93888 13.0
2008 88573 12.3
2009 77781 10.8
2010 129959 18.0
2011 4950 0.7
*No NAs after 2011

This option to close out a complaint without assigning a ‘how’, seems to have been removed in 2011 and there are no NAs thereafter.  All noise complaints are further subdivided by type/source of noise. The following table gives a summary of the various types of noise complaints that were closed out without indicating action taken for the period 2004 to 2011.

Breakdown of NAs in ‘action taken’, by noise subtype, 2004 to 2011
Noise subtype Number
N/A 236905
Loud Music/Party 233112
Loud Talking 87114
Car/Truck Music 61512
Loud Music 45317
Banging/Pounding 27814
Car/Truck Horn 17934
Engine Idling 8915
Loud Television 2167
*No NAs after 2011

2010 appears to have had the highest rate of closing out with no notes about action taken. So I took a closer look to see if there was also a difference in the types of noise that got closed out without notes. There wasn’t.

Breakdown of NAs in ‘action taken’, by noise subtype, 2010
Noise subtype Number
Loud Music/Party 78909
Banging/Pounding 23363
Loud Talking 14321
Car/Truck Music 7220
Engine Idling 2991
Loud Television 1878
Car/Truck Horn 1277

311 data from NYC Open Data downloaded at various times. As of Feb 5, 2018, 27 million rows, 52 variables till 2009, 53 variables from 2010. Parsed using R v3.4.3 in RStudio v1..1.423