What 13 Million 311 Complaints Reveal About New York City's Quality of Life
NYC Open Data Week – March 25, 2026
VIDEO | AUDIO | RECAP EN / ES / FR | INFO | INDEX
Speakers: David Tussey - Former Tech Executive, NYC
Moderator: Aleksandr Finkel - NYC OTI
Introduction to the 311 Quality of Life Analysis
David Tussey opened the session by explaining that the presentation examined whether New York City’s massive 311 complaint database could be used to identify broader trends related to urban quality of life. Tussey, a former technology executive for New York City government and former leader within what was then DoITT, explained that he had participated in a major modernization of the city’s 311 software platform in 2020.
He described 311 as the city’s non-emergency service and complaint system, contrasting it with 911 emergency services. Approximately 3 million 311 complaints are filed annually through:
Phone calls
Online submissions
Mobile applications
Other digital channels
Tussey framed the central research question as:
Can 311 complaints function as a proxy or “barometer” for understanding changes in New York City residents’ quality of life?
He noted that while crime statistics often dominate public discussion about urban conditions, many non-criminal issues — such as sanitation, noise, graffiti, or infrastructure maintenance — also strongly shape everyday urban experience.
Initial Research Design and Unexpected Data Challenges
Tussey originally planned a relatively simple longitudinal comparison using 2021 complaint data as a baseline and comparing subsequent years during Mayor Eric Adams’ administration.
However, the project quickly became more complicated because the 2020–2021 data proved highly unstable.
Problems included:
Missing records
Large unexplained spikes
COVID-era distortions
System transition effects from the new 311 platform
Tussey explained that many complaint categories collapsed during COVID lockdowns while others surged dramatically, making the data unsuitable for establishing a stable baseline.
As a result, he shifted the baseline year to 2022 and ultimately analyzed trends across 2023–2025 using a seasonally adjusted index system.
The seasonally adjusted approach normalized complaint volumes relative to expected complaint levels for each month. For example:
A score of 1.5 in December meant complaints were 1.5 times higher than typical December complaint levels
A score of 2.0 meant complaints doubled expected seasonal norms
Tussey emphasized that seasonal normalization was necessary because many complaint categories vary dramatically by weather and time of year.
Technical Workflow and Use of Open Data
Tussey described the project’s technical architecture in detail.
He downloaded approximately four years of 311 data directly from NYC Open Data as a flat CSV file containing:
Approximately 13.5 million complaint records
Roughly 1 gigabyte of data
The analysis pipeline was built in R, and Tussey noted that he used Anthropic’s Claude AI system extensively to accelerate software development and automate coding tasks.
Key preprocessing steps included:
Converting text date fields into actual date formats
Normalizing inconsistent capitalization
Standardizing column naming conventions
Converting the data into RDS format for more efficient processing
Tussey stressed that data cleaning consumed a substantial portion of the project effort and described dirty or inconsistent data as one of the largest challenges in any large-scale open data analysis project.
Creating “Quality of Life Indicators”
The original 311 dataset contained approximately 241 complaint categories. Tussey manually selected about 60 categories that he believed reflected quality-of-life conditions.
Example categories included:
Graffiti
Homeless assistance
Standing water
Rodent sightings
Drug activity
Broken parking meters
Illegal dumping
Unsanitary conditions
Because 60 indicators proved too unwieldy, he grouped related complaint types into “families,” reducing the number to 36 broader groupings.
Examples included:
Animal-related complaints
Unsanitary conditions
Street safety issues
Sanitation complaints
He then grouped the families into even larger “bundles,” creating 11 executive-level heat maps intended to summarize broad categories of urban quality-of-life conditions.
Tussey repeatedly emphasized that these groupings were subjective and open to revision.
Standing Water and Seasonal Complaint Cycles
Tussey used standing water complaints to demonstrate how seasonal trend analysis worked.
Standing water complaints — typically involving blocked drains or roadway flooding — showed strong seasonal patterns:
Very high complaint volumes during spring and summer
Near-zero complaints during winter months
Charts displayed recurring annual “sawtooth” cycles corresponding to seasonal weather changes. Tussey highlighted that understanding these recurring cycles was essential before attempting to identify abnormal trends.
Graffiti Complaints and Urban Blight
Graffiti complaints were presented as an example of a worsening quality-of-life indicator.
Tussey showed that:
Graffiti complaints followed a recurring spring/summer increase
Overall complaint trends were rising substantially over time
The analysis estimated graffiti complaints were:
Up approximately 58% compared with the 2022 baseline
Associated with nearly 60,000 complaints across the four-year period
Tussey interpreted this as evidence of worsening urban blight conditions.
Discussion on Bias and Interpretation
During the session, audience member Sherry questioned whether categories such as “homeless assistance” reflected a bias toward the concerns of housed residents rather than unhoused populations themselves.
Tussey acknowledged the criticism and agreed that the selection of quality-of-life indicators was inherently subjective. He stated that the project should be understood as exploratory and open to alternative interpretations and categorization systems.
Positive Trend Indicators
Tussey then shifted to several complaint categories showing improvement.
Consumer Complaints
Consumer complaints — including complaints against:
Retail stores
Bodegas
Dry cleaners
Towing companies
Parking garages
showed a substantial decline after a spike in 2022.
The analysis estimated:
Consumer complaints declined approximately 21%
over the observed period.
Streetlight Condition Complaints
Streetlight and traffic signal complaints also declined substantially:
Down approximately 40%
Tussey interpreted this as evidence of improved infrastructure maintenance.
Rodent Complaints and the “Rat Czar”
One of the session’s most discussed examples involved rodent complaints.
Tussey showed that citizen-reported rodent sightings declined approximately 25% over the study period.
Audience members suggested several explanations:
The city’s new sealed trash bin program
Increased sanitation enforcement
The appointment of the city’s “rat czar”
Expanded rodent mitigation efforts
Tussey credited Department of Sanitation leadership under Jessica Tisch and argued that the data appeared to demonstrate measurable policy success.
Broken Parking Meters
Complaints about broken parking meters declined approximately 40%.
Participants attributed this largely to the transition away from:
Mechanical coin-operated meters
Toward app-based digital parking systems
Tussey cited this as an example where technological modernization directly altered complaint patterns.
Neutral or Stable Trends
Several complaint categories remained relatively stable.
Street Sweeping Complaints
Alternate-side parking and street sweeping complaints showed little overall change from 2022 levels.
Abandoned Vehicles
Abandoned vehicle complaints displayed dramatic seasonal spikes every January but no clear long-term upward or downward trend.
Participants speculated that seasonal travel patterns and “snowbird” migration might contribute to the annual January spikes.
Trash Disposal Complaints
Trash disposal complaints fluctuated heavily but ultimately showed almost no net change overall.
Tussey noted that explaining the causes of these spikes would require a much deeper second-order analysis.
Worsening Trends and Emerging Concerns
Tussey then reviewed complaint categories showing significant deterioration.
Illegal Posting and Dumping
Complaints involving illegal posting and dumping rose approximately 43%.
Tussey suggested that these trends reflected worsening neighborhood disorder conditions.
Unsanitary Conditions
A family of complaints involving:
Bad smells
Dirty conditions
Trash accumulation
General sanitation problems
increased approximately 26%.
Drug Activity Complaints
Drug activity complaints represented one of the most dramatic increases.
Tussey displayed trend points reaching:
8–9 times expected seasonal norms during parts of 2025
Overall:
Drug activity complaints increased more than 300%
during the study period.
Tussey noted that these reports reflected citizen complaints rather than verified police incidents.
Audience discussion considered several possible factors:
Cannabis legalization
Changes in drug enforcement policy
Shifting public attitudes toward reporting
Tussey stressed that the dataset alone could identify trends but not definitively explain causation.
Lead Complaints
Tussey identified lead-related complaints as especially troubling.
The category combined:
Housing Preservation and Development (HPD) complaints
Department of Buildings complaints
related to:
Lead paint
Lead pipes
Lead hazards
The trend analysis suggested:
Lead complaints increased nearly 120%
Approximately 55,000 reports were recorded
Tussey noted that two extreme spikes exceeded the chart’s vertical scale entirely.
Audience members pointed out that expanded mandatory lead testing laws may partly explain the increase.
Executive-Level “Heat Maps”
Tussey introduced a series of executive-style heat maps designed to summarize broad issue categories visually.
Categories included:
Public health
Street safety
Blight and nuisance
Sanitation
Transportation
Each heat map color-coded trends as:
Improved
Neutral
Slightly worse
Much worse
Examples included:
Strong improvements in rodent complaints and parking meters
Significant deterioration in drug activity and illegal dumping
Tussey suggested that such visualizations could potentially support:
Budget prioritization
Policy development
Executive decision-making
Community planning
Overall Findings
Tussey summarized the full set of quality-of-life indicators:
Approximately 32% showed improvement or stability
Approximately 27% showed slight deterioration
Approximately 41% showed substantial worsening
He concluded that a large share of the analyzed quality-of-life indicators appeared to be deteriorating and “needed attention.”
Audience Discussion on Data Interpretation and Policy Use
The discussion section became one of the session’s most substantive components.
Audience members raised questions involving:
Statistical methodology
Mean versus median normalization
Seasonal adjustment
Repeat complainants
“Complaint fatigue”
Free-text parsing
Geographic mapping
Tussey acknowledged many methodological limitations, including:
Reliance on a single baseline year
Subjective category selection
Incomplete causal analysis
He emphasized that the project should be viewed as exploratory rather than definitive.
Geographic and Agency-Level Analysis
Tussey explained that the underlying 311 data include:
Street addresses
Latitude/longitude coordinates
Responsible city agencies
This makes it possible to perform:
Borough-level comparisons
Community board analysis
Agency performance comparisons
Geospatial mapping
He briefly displayed borough-level complaint trends showing:
Manhattan complaints up roughly 24%
Queens up roughly 17%
Staten Island mostly unchanged
Bronx slightly down
Tussey cautioned that complaint counts become statistically sparse at smaller geographic scales.
Discussion on Tenant Harassment and Hidden Patterns
One of the most important audience exchanges involved Virginia Crawford, who discussed difficulties tracking landlord harassment against rent-stabilized tenants.
Crawford explained that:
311 does not explicitly classify harassment complaints
Harassment cases must often be reconstructed from housing court data
Many individual complaints (rodents, broken locks, mail theft, construction issues) may collectively indicate systematic tenant harassment
She proposed grouping seemingly unrelated complaints into “families” representing broader structural housing harassment patterns.
Tussey strongly supported the idea and argued that this was precisely the type of higher-order policy analysis the city should pursue using integrated datasets.
The Role of 311 as Civic Infrastructure
Sherry emphasized that residents are constantly encouraged by community boards and city officials to submit 311 complaints as a way of documenting neighborhood problems and attracting government attention.
Tussey agreed and argued that because residents increasingly use 311 as a civic reporting mechanism, the city has a responsibility not only to collect the data but also to analyze and operationalize it effectively.
He stressed that without meaningful analysis:
“We’re just collecting data.”
Historical Origins of NYC 311
Toward the end of the session, Tussey discussed the origins of NYC 311 under Mayor Michael Bloomberg.
He explained that Bloomberg’s administration consolidated numerous fragmented agency hotlines into a centralized service system inspired partly by Bloomberg LP’s centralized global support model.
Tussey also noted that the major 2019–2020 software modernization was the first large-scale platform replacement since the original 2003 implementation.
Final Reflections on Open Data and Civic Analysis
Tussey concluded by arguing that the true value of open data lies not simply in publication, but in interpretation and civic use.
He advocated for:
Dedicated city analytical teams
Better integration of datasets
Executive dashboards
Community-level report cards
More active use of data in policy formation
Tussey repeatedly emphasized that the 311 system contains an extraordinarily rich civic dataset capable of revealing:
Infrastructure failures
Social stress
Neighborhood decline
Policy success
Emerging urban issues
if properly analyzed and integrated into decision-making processes.
RESOURCES
What 13 Million 311 Complaints Reveal About NYC’s Quality of Life — the NYC Open Data Week 2026 event page, with full description and event materials
Principles for Open Data Curation: A Case Study with the NYC 311 Service Request Data — the peer-reviewed paper by David Tussey and Jun Yan underpinning this analysis
311 Service Requests from 2020 to Present — the NYC Open Data dataset of ~13 million complaint records analyzed in the talk
NYC Open Data — the City’s open data portal where the 311 four-year export was obtained
NYC Office of Technology and Innovation — Open Data — OTI (formerly DoITT) runs 311 and the Open Data program
University of Connecticut Department of Statistics — academic home of Dr. Jun Yan, who mentored the statistical methodology
The R Project for Statistical Computing — the language used to build the data pipeline, indexing, and trend charts
DSNY Waste Containerization — the trash bin program credited in the session for the drop in rodent complaints
BetaNYC — civic-tech organization referenced for neighborhood report cards and open data advocacy