About this Dataset

Health Inspections (2020-2023)

SUMMARY This dataset contains the results of health inspections conducted by the Department of Public Health from 2020 to 2023. 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. UPDATE PROCESS This dataset is historical and will not be updated RELATED DATASETS

Health Inspections (2016-2019)
Inspection lookup tool
Organization: City of San Francisco
Last updated: 2025-05-03T17:54:50.175365
Tags: food-inspection, health-inspection

Tables

Table 1

@usgov.city_of_san_francisco_health_inspections_2020_2023.table_1

850.59 kB
49,562 rows
14 columns

CREATE TABLE table_1 (
  "name" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "postal_code" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "inspection_id" BIGINT,
  "date" VARCHAR,
  "facility_status" VARCHAR,
  "inspection_type" VARCHAR,
  "violation_observed" VARCHAR,
  "description" VARCHAR,
  "the_geom" VARCHAR
);