kingcounty-gov/food-establishment-inspection-data-f29f-zza5
Icon for Socrata external plugin
Open repository in Console
 
Readme
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 https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"kingcounty-gov/food-establishment-inspection-data-f29f-zza5\".\"food_establishment_inspection_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • food_establishment_inspection_data