Health Inspections (2020-2023)

City of San Francisco

@usgov.city_of_san_francisco_health_inspections_2020_2023

Table List

1 table(830.66 KB)

Table 1

@usgov.city_of_san_francisco_health_inspections_2020_2023.table_1

830.66 KB
49562 rows
14 columns

name Name	address Address	city City	state State	postal_code Postal Code	latitude Latitude	longitude Longitude	inspection_id Inspection Id	date Date	facility_status Facility Status	inspection_type Inspection Type	violation_observed Violation Observed	description Description	the_geom The Geom
NORMAN'S ICE CREAM AND FREEZES	2801 LEAVENWORTH ST	San Francisco	CA	94133	37.807155	-122.419004	3120210708	07/08/2021 12:00:00 AM	PASS	routine	OUT (Not in Compliance)	Plumbing; proper backflow devices	POINT (-122.419004 37.807155)
CHARLIE'S DELI CAFE	3202 FOLSOM ST	San Francisco	CA	94110	37.747114	-122.413641	4520220630	06/30/2022 12:00:00 AM	CLOSURE	routine	Major	Food contact surfaces: clean and sanitized [ date violation corrected: 7/1/2022 ]	POINT (-122.413641 37.747114)
CHARLIE'S DELI CAFE	3202 FOLSOM ST	San Francisco	CA	94110	37.747114	-122.413641	4520220630	06/30/2022 12:00:00 AM	CLOSURE	routine	Major	No insects, rodents, birds or nonservice animals [ date violation corrected: 7/1/2022 ]	POINT (-122.413641 37.747114)
CHARLIE'S DELI CAFE	3202 FOLSOM ST	San Francisco	CA	94110	37.747114	-122.413641	4520220630	06/30/2022 12:00:00 AM	CLOSURE	routine	Major - Corrected on Site	Proper hot and cold holding temperatures [ date violation corrected: 7/1/2022 ]	POINT (-122.413641 37.747114)
CHARLIE'S DELI CAFE	3202 FOLSOM ST	San Francisco	CA	94110	37.747114	-122.413641	4520220630	06/30/2022 12:00:00 AM	CLOSURE	routine	OUT (Not in Compliance)	Equipment approved; clean; installed, good repair; capacity [ date violation corrected: 7/1/2022 ]	POINT (-122.413641 37.747114)
CHARLIE'S DELI CAFE	3202 FOLSOM ST	San Francisco	CA	94110	37.747114	-122.413641	4520220630	06/30/2022 12:00:00 AM	CLOSURE	routine	OUT (Not in Compliance)	Equipment, utensils and linens; storage and use	POINT (-122.413641 37.747114)
CHARLIE'S DELI CAFE	3202 FOLSOM ST	San Francisco	CA	94110	37.747114	-122.413641	4520220630	06/30/2022 12:00:00 AM	CLOSURE	routine	OUT (Not in Compliance)	Floors, walls and ceiling: build, maintianed & clean	POINT (-122.413641 37.747114)
CHARLIE'S DELI CAFE	3202 FOLSOM ST	San Francisco	CA	94110	37.747114	-122.413641	4520220630	06/30/2022 12:00:00 AM	CLOSURE	routine	OUT (Not in Compliance)	Food separated and protected [ date violation corrected: 7/1/2022 ]	POINT (-122.413641 37.747114)
CHARLIE'S DELI CAFE	3202 FOLSOM ST	San Francisco	CA	94110	37.747114	-122.413641	4520220630	06/30/2022 12:00:00 AM	CLOSURE	routine	OUT (Not in Compliance)	Thermometers provided and accurate	POINT (-122.413641 37.747114)
CHARLIE'S DELI CAFE	3202 FOLSOM ST	San Francisco	CA	94110	37.747114	-122.413641	4520210211	02/11/2021 12:00:00 AM	PASS	routine	Minor - Corrected on Site	Food contact surfaces: clean and sanitized [ date violation corrected: 6/30/2022 ]	POINT (-122.413641 37.747114)


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
);