Icon for Socrata external plugin
Open repository in Console
Updated 6 days ago
Indexed 4 hours ago

Food Facility Handwash Violations

Hand wash violations tracking of food facilities in Marin County. For each food facility, data contains four year look backs (or less if not licensed that long) of the number of regular inspections, number of inspections with major hand wash violations, whether the facility had consecutive inspections with major hand wash violations, and geographic information. Handwashing educational visits are also tracked during these look backs. Data is updated every six months.

Environmental Health Services considers the following food facility inspection codes to be a major hand wash violation for purposes of this data set.

CHSC 113953.4

CHSC 113973.b-c

CHSC 113968

CHSC 113961

CHSC 113952

CHSC 113953.3

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"marincounty/food-facility-handwash-violations-7wjm-mn6w\".\"food_facility_handwash_violations\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • food_facility_handwash_violations
Upstream Metadata