About this Dataset

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 08/08/2025 and is current from 1/1/2006 to 08/05/2025.
Organization: King County, Washington
Last updated: 2020-11-10T16:58:37.244514
Tags: closures, food-safety, government, health, restaurant-inspections, violations

Tables

Table 1

@usgov.king_county_washington_food_establishment_inspection_data.table_1

7.01 MB
276,343 rows
22 columns

CREATE TABLE table_1 (
  "name" VARCHAR,
  "program_identifier" VARCHAR,
  "inspection_date" TIMESTAMP,
  "description" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "zip_code" VARCHAR,
  "phone" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "inspection_business_name" VARCHAR,
  "inspection_type" VARCHAR,
  "inspection_score" DOUBLE,
  "inspection_result" VARCHAR,
  "inspection_closed_business" VARCHAR,
  "violation_type" VARCHAR,
  "violation_description" VARCHAR,
  "violation_points" BIGINT,
  "business_id" VARCHAR,
  "inspection_serial_num" VARCHAR,
  "violation_record_id" VARCHAR,
  "grade" DOUBLE
);