Icon for Socrata external plugin
Open repository in Console
Updated 16 hours ago
Indexed 43 minutes ago

Food Establishment Inspection Data

Health Department inspection results for food service establishments in King County, 2006 to the present. This data is organized by Business / Inspection Date / Violation. Each row in this dataset is an inspection, and if an inspection at a particular buiness results in multiple violations there will be multiple rows for that business with the same Inspection_Serial_Num. This dataset was last updated on 04/17/2024 and is current from 1/1/2006 to 04/12/2024.

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 \"kingcounty-gov/food-establishment-inspection-data-f29f-zza5\".\"food_establishment_inspection_data\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • food_establishment_inspection_data