NYC Restaurant Inspection Results
NYC Department of Health and Mental Hygiene, via NYC Open Data
Every health violation cited at every active New York restaurant, from mice to cold-holding temperatures.
Inspection results for active New York City restaurants and college cafeterias over roughly the last three years, with each violation cited, critical flags, scores, and the letter grade posted in the window. Each row is one violation at one inspection (or an inspection with no violations). It is a favorite teaching data set and a window into food safety enforcement in a big city.
Access
- Cost
- FreeFree download and Socrata API.
- License
- Provider's own termsNYC Open Data terms of use
- Sign-up
- No sign-up
- How you get it
- API and Bulk downloadCSV, JSON, XML
What's in it
- One row is
- One row per violation per inspection
- Covers
- New York City, by restaurant address
- Years
- Rolling recent years (about three years of inspections)
- Updated
- Daily
- Size
- About 295,000 rows
Quality
Official, updated daily, and well documented, though it keeps only active restaurants and recent inspections.
- Closed restaurants drop out, creating survivorship bias
- Placeholder date 1900-01-01 marks new restaurants not yet inspected
- Grades follow re-inspection rules, not raw scores
Connects to
- Open-Meteo Historical Weather API: Test whether hot weather raises temperature-control violations
- American Community Survey (ACS) Public Use Microdata Sample: Compare violation rates with neighborhood income and demographics
Questions it could answer
- Which cuisines get the most critical violations per inspection?
- Do restaurants inspected later in the day receive higher scores?