Restaurant inspections
New York's restaurant inspection results in Python: letter grades and scores, violations, closures, pests by neighbourhood, and the placeholder dates, per-violation rows and zero coordinates in the data.
New York's health department inspects every restaurant at least once a year, scores what it finds and posts a letter grade in the window, and the results are open data: one row per violation, 296,514 rows for 31,531 restaurants in the October 2026 file. It is a detailed record of kitchen conditions across the city, and a snapshot that keeps only restaurants still open.
The guides here read the file, explain how scores become grades, rank violations, find closures, and map scores and pests by neighbourhood. Three pages deal with the traps: rows that are violations rather than inspections, a placeholder date of 1 January 1900, and restaurants placed at latitude and longitude zero.
🧭 Start with the concepts
The ideas the how-to guides below assume you already have.
⚙️ Then do the task
Step-by-step walkthroughs with code you can copy and adapt.
🔧 When it breaks
The errors this topic produces, with the cause explained rather than just the command.
Related topics
Subjects that keep coming up alongside this one, most overlap first.