About this Dataset

Health Inspection Scores (2016-2019)

**As of 2021, the LIVES standard is no longer being used to evaluate restaurants. For that reason, this dataset is no longer being updated but will remain on the open data portal. For new inspection data please visit this website or download the new data here (Health Inspections (2023-Present)). ** SUMMARY This dataset contains the results of health inspections conducted by the Department of Public Health from 2016-2019. It includes the name and location of each facility inspected, the inspection score, and any violations observed. HOW THIS DATASET IS CREATED After inspecting a facility, a Health Inspector assigns a score based on observed violations. Violations are categorized by risk level: High risk category: records specific violations that directly relate to the transmission of food borne illnesses, the adulteration of food products and the contamination of food-contact surfaces. Moderate risk category: records specific violations that are of a moderate risk to the public health and safety. Low risk category: records violations that are low risk or have no immediate risk to the public health and safety.
The score card that will be issued by the inspector is maintained at the food establishment and is available to the public in this dataset. UPDATE PROCESS This dataset is historical and will not be updated RELATED DATASETS

Health Inspections (2023-Present)
Health Inspections (2020-2023)
Health Inspections (2016-2019)
Inspection lookup tool
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:49.485965
Tags: department-of-public-health, dph, environmental-health, inspections, lives, restaurant-scores, san-francisco, sanitary-scores, sfdph

Tables

Table 1

@usgov.city_of_san_francisco_restaurant_scores_lives_standard.table_1

1.85 MB
53973 rows
22 columns


CREATE TABLE table_1 (
  "business_id" BIGINT,
  "business_name" VARCHAR,
  "business_address" VARCHAR,
  "business_city" VARCHAR,
  "business_state" VARCHAR,
  "business_postal_code" VARCHAR,
  "business_latitude" DOUBLE,
  "business_longitude" DOUBLE,
  "business_location" VARCHAR,
  "business_phone_number" DOUBLE,
  "inspection_id" VARCHAR,
  "inspection_date" VARCHAR,
  "inspection_score" DOUBLE,
  "inspection_type" VARCHAR,
  "violation_id" VARCHAR,
  "violation_description" VARCHAR,
  "risk_category" VARCHAR,
  "neighborhoods" DOUBLE,
  "sf_find_neighborhoods" DOUBLE,
  "current_police_districts" DOUBLE,
  "current_supervisor_districts" DOUBLE,
  "analysis_neighborhoods" DOUBLE
);