Spatial Data Catalog

Learn more by reading the GIS FAQ 🗺

Layer information

Layer Name	restaurant_inspections
Subject Category	Public Safety
Title	Restaurant Inspections - Public Health - Seattle and King County
Feature Count	0
Feature Type	Point
Published Date	Quarterly
Spatial reference	NAD 1983 HARN StatePlane Washington North FIPS 4601 Feet
Open Data Availability	Yes
Place Keywords	Pacific NW, WA, Washington State, King County
Theme Keywords	Health, Pubsafe, Restaurant Inspection, Food Safety, Food Facilities, Food Inspection, Restaurant
Supplemental Information	http://www5.kingcounty.gov/sdc/addl_doc/restaurantinspectionsupplementalinformation.htm

Attribute information

OBJECTID From ESRI	Description Internal feature number. Domain Sequential unique whole numbers that are automatically generated.
FEATURE_ID From King County	Description Unique identifier for each record Domain 1 to 133827 by 1
NAME From Public Health - King County and Seattle	Description Name of restaurant or other food facility Domain Uppercase alpha
PROGRAM_IDENTIFIER From Public Health - King County and Seattle	Description Name of facility as program identifier Domain Uppercase alpha
SEAT_CAP From Public Health - King County and Seattle	Description Size (seating capacity) when appropriate Domain Bakery - Bakery Bed and Breakfast - Bed and Breakfast Caterer - Caterer Charitable Org - Charitable Organization Commissary for Mobile FSE - Commissary for Mobile FSE Grocery - Grocery Limited Food Services - Limited Food Services Meat/Sea Food - Meat and Seafood Mobile FS - Mobile FS School Kitchen - School Kitchen Seating 0-12 - Seating capacity up to 12 Seating 13-50 - Seating capacity from 13 to 50 Seating 51-150 - Seating Capacity from 51 to 150 Seating 151-250 - Seating Capacity from 151 to 250 Seating > 250 - Seating > 250
RISK From Public Health - King County and Seattle	Description Risk category of facility when appropriate Domain No risk info - No Risk Information Risk Category I - Low Risk - Cold holding - Limited food preparation. Requires one routine inspection per year. Risk Category II - Medium Risk - No Cook Step Food Preparation. One routine inspection per year and either 2nd inspection or education visit Risk Category III - High Risk - Same day service or complex food preparation. Requires 2 routine inspections per year and one education visit Risk I - Miscoded Risk Category 1 Risk II&III - Combination Risk Category 1 and 3
ADDRESS From Public Health - King County and Seattle	Description Full street address of facility Domain Address number and uppercase street name; non-standard abbreviations
PHONE From Public Health - King County and Seattle	Description Area code and phone number of facility Domain NULL or form (###) ###-####
LONGITUDE From Public Health - King County and Seattle	Description Longitude location of facility Domain -999.99999000 to 0.00000000 by
LATITUDE From Public Health - King County and Seattle	Description Latitude location of facility Domain 0.00000000 to 47.92691900 by
ZIPCODE From Public Health - King County and Seattle	Description 5 digit zipcode of facility Domain 5 digits as string
CITY From Public Health - King County and Seattle	Description City where facility is located Domain Mixed case full city name
DATE_INSPECTION From Public Health - King County and Seattle	Description Date of inspection Domain Date/time as string in form 1/2/2006 12:00:00 AM
BUS_NAME_INSPECTION From Public Health - King County and Seattle	Description Inspection record business name Domain Uppercase string
TYPE_INSPECTION From Public Health - King County and Seattle	Description Type of inspection Domain Consultation/Education - Field - Discuss risk reduction while verifying proper food handling, food source, food storage, and general cleanliness Return Inspection - Return Inspection Routine Inspection/Field Review - Routine Inspection/Field Review
SCORE_INSPECTION From Public Health - King County and Seattle	Description Inspection score Domain Number as string
RESULT_INSPECTION From Public Health - King County and Seattle	Description Inspection result Domain Baseline Data - Baseline Data Catalog information - Catalog information Comparison data - Comparison data Complete - Complete Confirmed - Confirmed Exempt - Exempt Failed - Failed In Compliance - In Compliance Incomplete - Incomplete Limited Information - Limited Information Needs Assessment - Needs Assessment No Longer At Location - No Longer At Location Not Accessible - Not Accessible Not Applicable - Not Applicable Not Confirmed - Not Confirmed Not Permitted - Not Permitted Not Ready For Inspection - Not Ready For Inspection Out of Business - Out of Business Positive - Positive Satisfactory - Satisfactory Unsatisfactory - Unsatisfactory
CLOSE_BUS_INSPECTION From Public Health - King County and Seattle	Description Was business closed as result of inspection Domain N - Business not closed Y - Business closed
VIOLATIONTYPE From Public Health - King County and Seattle	Description Violation type Domain (no value) - no value BLUE - Primarily maintenance and sanitation issues that are not likely to be the cause of a food borne illness. RED - Those food handling practices that, when not done properly, are most likely to lead to food borne illnesses.
VIOLATIONDESCR From Public Health - King County and Seattle	Description Description of violation Domain String
VIOLATIONPOINTS From Public Health - King County and Seattle	Description Violation points Domain Number as string
Shape From ESRI	Description Feature geometry. Domain Coordinates defining the features.
RECORD_ID From Public Health - King County and Seattle	Description Record identifier if facility is a chain Domain Alpha numeric string
FACILITY_NAME From Public Health - King County and Seattle	Description Facility name if a chain or housing a chain Domain Uppercase string; may be same as Chain Name or different
CHAIN_NAME From Public Health - King County and Seattle	Description Name of chain if facility is a chain Domain Uppercase string; may be same as Facility Name or different
CHAIN_ESTABLISHMENT From Public Health - King County and Seattle	Description Whether facility is chain or not Domain Either NULL (not a chain) or Y (Yes)
SITE_ADDRESS From Public Health - King County and Seattle	Description Full street address of chain home location Domain Address number and uppercase name; non-standard abbreviations

Purpose

These inspections are made to assure that the food is being handled properly from preparation through serving.

Inspectors observe kitchen workers' food handling practices, assure equipment is working properly, take food temperatures, inspect refrigerators and storage areas, assure water temperatures, and correct level and use of sanitizers.

Any problem found is written up, and the manager is taught the correct procedure or method immediately.

Abstract

Food establishments that sell or serve food to the public must get an annual permit and be inspected by Public Health-Seattle and King County.

These establishments include restaurants, food and espresso carts, coffee places, delis, the fresh food sections in grocery stores, temporary events where food is sold, and more.

There are nearly 10,000 permitted food service establishments in Seattle and King County.

The majority of these establishments have two unannounced inspections per year.

While many of these food service establishments will automatically receive one special educational session on food safety annually, any restaurant may request a special educational session.

The data in this layer is built from records obtained from:http://info.kingcounty.gov/health/ehs/foodsafety/inspections/search.aspx.

Contact information

Maintained by	Department of Public Health
Primary	Daniel Casey dcasey@kingcounty.gov

Constraints

Access	None
Use	King County data are made available with the understanding that they shall be used exclusively by the obtainer or his/her authorized agents. Digital products may not be reproduced or redistributed in any form or by any means without the express written authorization of King County.

Change history

3/1/2021	(1) Total Count of all individual download files: 253087 (2) Total count of all individual files aggregated: 253087 (3) Number of records that successfully loaded into restaurant inspections table:252066 (4) Number of records that failed to load into restaurant inspections table: 1021 (5) Sum of successful and unsuccessful records: 253087 (6). Number of records in production featureclass (RESTAURANT_INSPECTIONS_POINT): 252066
10/7/2019	(1) Total Count of all individual download files: 269888 (2) Total count of all individual files aggregated: 269888 (3) Number of records that successfully loaded into restaurant inspections table:269289 (4) Number of records that failed to load into restaurant inspections table: 599 (5) Sum of successful and unsuccessful records: 269888 (6). Number of records in production featureclass (RESTAURANT_INSPECTIONS_POINT): 267522
12/5/2018	(1) Total Count of all individual download files: 265765 (2) Total count of all individual files aggregated: 265765 (3) Number of records that successfully loaded into restaurant inspections table:265192 (4) Number of records that failed to load into restaurant inspections table: 573 (5) Sum of successful and unsuccessful records: 265765 (6). Number of records in production featureclass (RESTAURANT_INSPECTIONS_POINT): 265192
8/22/2018	(1) Total Count of all individual download files: 262076 (2) Total count of all individual files aggregated: 262102 (3) Number of records that successfully loaded into restaurant inspections table:261515 (4) Number of records that failed to load into restaurant inspections table: 587 (5) Sum of successful and unsuccessful records: 262102 (6). Number of records in production featureclass (RESTAURANT_INSPECTIONS_POINT): 261515
2/1/2018	(1) Total Count of all individual download files: 262420 (2) Total count of all individual files aggregated: 262420 (3) Number of records that successfully loaded into restaurant inspections table:261718 (4) Number of records that failed to load into restaurant inspections table: 702 (5) Sum of successful and unsuccessful records: 262420 (6). Number of records in production featureclass (RESTAURANT_INSPECTIONS_POINT): 261718
12/1/2015	Change DATE_INSPECTION feld changed from a TEXT field to a Date field
11/29/2010	Data records where downloaded from http://info.kingcounty.gov/health/ehs/foodsafety/inspections/search.aspx Individual alpha record sets were appended and reformatted for delimiter conformance. Python scripts were used to assemble data tables, join information about restaurant chain, and create a spatial featureclass from tabular coordinate data.