Restaurant Health Inspections

Inspection results are available online 14 days after the inspector's visit. To file a complaint about a food facility in San Mateo County call (650) 372-6200, email EnvHealth@smcgov.org, or use our Online Complaint Form and submit your complaint online: http://www.smchealth.org/ehcomplaint

Some addresses for inspection results are located outside of San Mateo County. In these cases, this is likely the business address for a company that has provided food services within the County. In many cases, this is a caterer or other service provider for an event or similarly temporary location.

Code definitions for violations and inspection results are attached to this metadata. Many thanks to Tom Cox of OpenSMC for creating this glossary.

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 https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"datahub-smcgov/restaurant-health-inspections-pjzf-pe8z\".\"restaurant_health_inspections\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.