NYC Open Data ↗ 50.0K rows 4.2 MB Apr 6, 2026

NYC 311 Service Requests

Real 311 service request data from New York City. Every row is a complaint or request — noise, heat, potholes, rodents, parking, and more. Great for learning GROUP BY, date functions, and geographic analysis.

Open in Data Lab

Schema

11 columns in this dataset

Column	Type	Description
`unique_key`	INTEGER
`created_date`	TIMESTAMP
`agency`	VARCHAR
`complaint_type`	VARCHAR
`descriptor`	VARCHAR
`borough`	VARCHAR
`zip_code`	VARCHAR
`latitude`	DOUBLE
`longitude`	DOUBLE
`status`	VARCHAR
`resolution_days`	DOUBLE

Example Queries

Try these queries to start exploring the data

Top complaint types

Run in Data Lab

SELECT complaint_type, COUNT(*) as total FROM nyc_311 GROUP BY complaint_type ORDER BY total DESC LIMIT 15

Complaints by borough

Run in Data Lab

SELECT borough, COUNT(*) as complaints, ROUND(AVG(resolution_days), 1) as avg_resolution FROM nyc_311 GROUP BY borough ORDER BY complaints DESC

Monthly trends

Run in Data Lab

SELECT DATE_TRUNC('month', created_date) as month, COUNT(*) as complaints FROM nyc_311 GROUP BY month ORDER BY month