NYC Restaurant Inspections
Every sustained violation issued to every food establishment by the Department of Health and Mental Hygiene. One row per violation per inspection. The grade card in your favorite spot's window comes from this dataset.
data through 2026-09-03 · 294,391 violation rows
violation rows by cuisine · since 2024-01-01
Top cuisines by violation rows, 2024–present
Click a cuisine to drop into the SoQL playground filtered to that cuisine's recent
inspections. The mice-vs-roaches story uses the pestViolations view to parse violation_description text.
Stories using this data
article
Mice vs roaches
DOHMH doesn't track pest type as a column on its restaurant inspection data. But it's all there in the violation descriptions, parsed by the inspector. Mice, roaches, flies — the urban biome of NYC's kitchens, mapped per borough.
scrolly
What the inspectors heard
DOHMH's restaurant inspection data carries a cuisine_description column — one of the few structured cuisine fields on any city portal. Scroll through pizza, Chinese, Latin American, and Japanese density across NYC, and the neighborhoods name themselves.