data . willkara
dataset · NYC Open Data via Socrata

NYC 311 service requests

Live snapshot of the City of New York's 311 service requests, queried directly against data.cityofnewyork.us through our Cloudflare worker proxy. Twenty-four million rows from 2010 to today.

data through 2026-09-04 · 22,355,568 rows

About this dataset

The City of New York's 311 service requests, hosted on the NYC Open Data portal as Socrata dataset erm2-nwe9 — the catalog name is "311 Service Requests from 2020 to Present". Each row is one resident-filed request — noise, illegal parking, heat/hot water, missed sanitation pickups, rodent reports — with timestamps, status, agency assignment, borough, community board, and (for most rows) a geocoded location. Pre-2020 records live in a sister dataset; the bulk of contemporary analysis happens here.

Source

  • Catalog page: NYC Open Data
  • Endpoint (SODA v3): POST https://data.cityofnewyork.us/api/v3/views/erm2-nwe9/query.json
  • Rows: 22,355,568 (grows daily; ~3M new records per year)

How we query it

All requests go through our Cloudflare Worker proxy at /api/socrata/[domain]/[dataset]. The proxy hashes the SoQL into a KV cache key and serves repeats from KV (TTL: 24h for metadata, 1h for aggregates, 5min for raw rows). On a fresh deploy or a cache miss the proxy POSTs the SoQL body to the SODA v3 endpoint and writes the response back. NYC Open Data credentials (App Key + App Secret) are attached as X-App-Token and HTTP Basic auth headers when configured as Cloudflare Pages secrets.

Caveats

  • Crowdsourced. Volume reflects who is calling 311 as much as what is actually happening — it tracks complaints, not events. A neighborhood that calls 311 at half the rate of another isn't necessarily quieter; it may just be less likely to call.
  • Less than 2% of all 311 calls are "social disorder" categories (drinking, graffiti, homelessness). Drug activity and disorderly youth combined are under 0.2%. The dominant categories are noise (residential + street) and infrastructure (heat, water, parking).
  • closed_date is sometimes blank for rows the city marks "Closed" administratively without timestamping the resolution.
  • Borough strings are uppercase (MANHATTAN, BROOKLYN, etc.) per Socrata convention. Some rows are Unspecified when the agency couldn't geocode.

Citation

City of New York (2026). 311 Service Requests from 2010 to Present. Retrieved 2026-09-04 via NYC Open Data SODA v3.