NYC 311 service requests

Loading data...

Rolling window of requests from NYC Open Data (erm2-nwe9), loaded incrementally into DuckDB and modeled with dbt. Source: github.com/adleraaa/nyc311-pipeline.

Requests created per day, by borough

The most recent created day is partial (the source publishes once a day with a lag) and is omitted.

Top complaint types in the window

Resolution time by agency (hours)

All requests created at least 14 days before the latest request (agencies with at least 30). Requests still open count as not resolved yet, so a median is shown only when at least half are closed, and a p90 only when at least 90% are.

Open backlog by age

Open requests created in the window, aged at the latest created timestamp in the data.

Data quality

CheckStatusDetail