NYC 311 Response Times
How long NYC takes to close 2.59 million 311 requests, and whether it depends on what you ask for and where you live.
- When
- Oct 2026
- Status
- Live
- Role
- Solo
- SQL
- BigQuery
- pandas
- Tableau
- Looker Studio

Question
How long does New York City take to close a 311 service request, and does the answer depend on what you ask for and where you live? I analyzed all 2.59 million requests filed in 2020.
Key findings
- Most requests close within hours, but tree requests take months. A New Tree Request took a median of 369 days.
- Response times differ by borough. Manhattan closed fastest (median 1.4 hours, 67.1% within a day); Staten Island slowest (9.7 hours, 53.8%).
- The Bronx filed the most requests per resident: about 400 per 1,000 residents, versus 224 in Staten Island.
- 3.4% of requests had no usable close time, so they count toward volume but not response times.
Method
- SQL (BigQuery): cleaning rules in a view, aggregations, a join to borough population, and window functions (
RANKfor top complaint types per borough,LAGfor month-over-month change). - Python (pandas): audited every data problem before changing anything, charted results with Matplotlib and Seaborn.
- Validation: checked the join neither dropped nor duplicated rows, and that the notebook’s clean row count matched the SQL view.
- Dashboards: Tableau (ZIP code map, monthly trend) and Looker Studio connected directly to BigQuery.
Limitations
The close date is when the agency closed the ticket, not always when the problem was fixed, and 2020 was a pandemic year.