SF Restaurant inspections SQL/GIS fun
The SF restaurant inspection data
As a SQLite database
SF restaurant inspection data as SQLite (with 3 tables: inspections, businesses, and violations): sf-restaurant-inspections.sqlite
As separate CSV
Background
Readings
- Did That Restaurant Pass Its Health Inspection? Now Yelp Will Tell You
- How Clean Are San Francisco Restaurants?
- SF Restaurants With Poor Health Ratings Can Now Buy Opportunity for New Scores
- San Francisco Restaurants That Have Recently Failed Health Inspections
More background
SF health inspection search page (official)
More background from a previous PADJO assignment
The SF health inspection data as a non-normalized single flattened table
Where to download the official data: https://extxfer.sfdph.org/food/
Documentation of official data: https://extxfer.sfdph.org/food/File%20Specifications.pdf