Restaurant Inspections - Public Health - Seattle and King County

Description | Contacts | Attribute Information | Constraints

Description

Layer name: RESTAURANT_INSPECTIONS
Subject category: pubsafe
Title: Restaurant Inspections - Public Health - Seattle and King County
Feature Count: 0
Feature Type: Point
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
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.
Status: Complete
Updated: Quarterly
Time period of content: (single date,as YYYYMMDD):: 20210301
Time period of content: (date range, as YYYYMMDD):: -
Spatial reference: WA State Plane North
FGDC Documentation: Classic or FAQ
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, health,
Lineage: Available
Supplemental Information: http://www5.kingcounty.gov/sdc/addl_doc/restaurantinspectionsupplementalinformation.htm

Contacts

Maintained by:
King County IT GIS Center/Client Services
Primary: Mike Leathers, Data Coordinator, 206-477-4403
(How to e-mail a County contact)
Secondary: KCGIS Center; giscenter@kingcounty.gov. This mailbox is monitored during business hours.

Attribute Information

Item

Description

Domain

_FEATURE_ID

_Unique identifier for each record

Range Min:	1
Range Max:	133827

_NAME

_Name of restaurant or other food facility

Uppercase alpha

_PROGRAM_IDENTIFIER

_Name of facility as program identifier

Uppercase alpha

_SEAT_CAP

_Size (seating capacity) when appropriate

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

_Risk category of facility when appropriate

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

_Full street address of facility

Address number and uppercase street name; non-standard abbreviations

_PHONE

_Area code and phone number of facility

NULL or form (###) ###-####

_LONGITUDE

_Longitude location of facility

Range Min:	-999.99999000
Range Max:	0.00000000

_LATITUDE

_Latitude location of facility

Range Min:	0.00000000
Range Max:	47.92691900

_ZIPCODE

_5 digit zipcode of facility

5 digits as string

_CITY

_City where facility is located

Mixed case full city name

_DATE_INSPECTION

_Date of inspection

Date/time as string in form 1/2/2006 12:00:00 AM

_BUS_NAME_INSPECTION

_Inspection record business name

Uppercase string

_TYPE_INSPECTION

_Type of inspection

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

_Inspection score

Number as string

_RESULT_INSPECTION

_Inspection result

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

_Was business closed as result of inspection

N	Business not closed
Y	Business closed

_VIOLATIONTYPE

_Violation type

(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

_Description of violation

String

_VIOLATIONPOINTS

_Violation points

Number as string

_RECORD_ID

_Record identifier if facility is a chain

Alpha numeric string

_FACILITY_NAME

_Facility name if a chain or housing a chain

Uppercase string; may be same as Chain Name or different

_CHAIN_NAME

_Name of chain if facility is a chain

Uppercase string; may be same as Facility Name or different

_CHAIN_ESTABLISHMENT

_Whether facility is chain or not

Either NULL (not a chain) or Y (Yes)

_SITE_ADDRESS

_Full street address of chain home location

Address number and uppercase name; non-standard abbreviations

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.