San Francisco Data

Close
Author
Josh
Description
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.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. San Francisco's LIVES restaurant inspection data leverages the LIVES Flattened Schema (https://goo.gl/c3nNvr), which is based on LIVES version 2.0, cited on Yelp's website (http://www.yelp.com/healthscores).
Category
Health and Social Services
Tags
lives, san francisco, environmental health, department of public health, dph, sfdph, restaurant scores, sanitary scores, inspections
Rating
Current value: 0 out of 5
Data Provided By
Department of Public Health
Source Link
http://www.sfdph.org/dph/EH/Food/score/default.asp
License
Public Domain Dedication and License
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

business_id
business_id
business_name
business_name
business_address
business_address
business_city
business_city
business_state
business_state
business_postal_code
business_postal_code
business_latitude
business_latitude
business_longitude
business_longitude
business_location
business_location
business_phone_number
business_phone_number
inspection_id
inspection_id
inspection_date
inspection_date
inspection_score
inspection_score
inspection_type
inspection_type
violation_id
violation_id
violation_description
violation_description
risk_category
risk_category

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.