Restaurant Inspection Scores in San Francisco

$179 / year

This dataset provides restaurant scores for inspections performed by LIVES (Local Inspector Value-Entry Specification). It also provides the name of the restaurant as well as the location and address of the restaurants.

Complexity

In 2012, Yelp partnered with the City of San Francisco and City of New York to develop the Local Inspector Value-Entry Specification (LIVES). LIVES is an open data standard which allows municipalities to publish restaurant inspection information to Yelp.

The Health Department has developed an inspection report and scoring system. After conducting an inspection of the facility, the Health Inspector calculates a score based on the violations observed. Violations can fall into “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 and “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

Date Created

2015-10-28

Last Modified

2019-11-15

Version

2019-11-15

Update Frequency

Quarterly

Temporal Coverage

2019

Spatial Coverage

San Francisco

Source

John Snow Labs; San Francisco Department of Public Health;

Source License URL

Source License Requirements

N/A

Source Citation

N/A

Keywords

Restaurant Inspection Scores, Restaurant Geodata, Food and Health, FDhealth, Restaurant Inspections

Other Titles

LIVES Restaurant Inspection Scores, San Francisco LIVES Restaurant Inspection Scores

NameDescriptionTypeConstraints
Business_IdBusiness Id assigned to the restaurantintegerlevel : Nominal
Business_NameName of the restaurantstring-
Business_AddressAddress of the restaurantstring-
CityCity where the restaurant is locatedstring-
StateState in which the restaurant is locatedstring-
Postal_CodeRestaurant postal codestring-
LatitudeGeo location latitude of the restaurantnumber-
LongitudeGeo location longitude of the restaurantnumber-
Business_Phone_NumberRestaurant's phone numberintegerlevel : Nominal
Inspection_IdInspection id assigned to the inspectionstring-
Inspection_DateDate of inspectiondatetime-
Inspection_ScoreScore assigned after the inspectionintegerlevel : Ratio
Inspection_TypeType of inspection performedstring-
Violation_IdViolation Idstring-
Violation_DescriptionDescription of the violation Idstring-
Risk_CategoryCategory of the violationstring-
Business IdBusiness NameBusiness AddressCityStatePostal CodeLatitudeLongitudeBusiness Phone NumberInspection IdInspection DateInspection ScoreInspection TypeViolation IdViolation DescriptionRisk Category
69618Fancy Wheatfield Bakery1362 Stockton StSan FranciscoCA9413369618_201903042019-03-04T00:00:00Complaint69618_20190304_103130Inadequate sewage or wastewater disposalModerate Risk
97975BREADBELLY1408 Clement StSan FranciscoCA9411814157240859.097975_201907252019-07-25T00:00:0096.0Routine - Unscheduled97975_20190725_103124Inadequately cleaned or sanitized food contact surfacesModerate Risk
69487Hakkasan San Francisco1 Kearny StSan FranciscoCA9410869487_201804182018-04-18T00:00:0088.0Routine - Unscheduled69487_20180418_103119Inadequate and inaccessible handwashing facilitiesModerate Risk
91044Chopsticks Restaurant4615 Mission StSan FranciscoCA9411291044_201708182017-08-18T00:00:00Non-inspection site visit
85987Tselogs552 Jones StSan FranciscoCA9410285987_201804122018-04-12T00:00:0094.0Routine - Unscheduled85987_20180412_103132Improper thawing methodsModerate Risk
96024Fig & Thistle Market691 14th StSan FranciscoCA9411496024_201811082018-11-08T00:00:00New Ownership - Followup
97503Moscone South Main Kitchen747 Howard StSan FranciscoCA9410397503_201809112018-09-11T00:00:00New Ownership
97748FISTFUL OF TACOS201 Harrison St Unit C-2San FranciscoCA9410514150459694.097748_201808212018-08-21T00:00:00Reinspection/Followup
77901The Estate Kitchen, LLC799 Bryant StSan FranciscoCA9410777901_201804162018-04-16T00:00:0086.0Routine - Unscheduled77901_20180416_103139Improper food storageLow Risk
87782Beloved Cafe3338 24th StSan FranciscoCA9411014155540477.087782_201805022018-05-02T00:00:0096.0Routine - Unscheduled87782_20180502_103161Low risk vermin infestationLow Risk