Icon for Socrata external plugin
Updated 1 day ago
Indexed 5 hours 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 12/06/2022 and is current from 1/1/2006 to 12/03/2022.

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