kingcounty-gov/food-establishment-inspection-data-f29f-zza5
 
Readme
Updated 18 hours ago
Indexed 3 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 01/19/2022 and is current from 1/1/2006 to 01/14/2022.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
DescriptiondescriptiondescriptionText
LatitudelatitudelatitudeNumber
Inspection_Serial_Numinspection_serial_numinspection_serial_numText
Inspection Typeinspection_typeinspection_typeText
Violation Pointsviolation_pointsviolation_pointsNumber
CitycitycityText
Zip Codezip_codezip_codeText
Inspection Business Nameinspection_business_nameinspection_business_nameText
Violation Descriptionviolation_descriptionviolation_descriptionText
Violation_Record_IDviolation_record_idviolation_record_idText
NamenamenameText
LongitudelongitudelongitudeNumber
Inspection Dateinspection_dateinspection_dateCalendar date
AddressaddressaddressText
Inspection Scoreinspection_scoreinspection_scoreNumber
Business_IDbusiness_idbusiness_idText
Inspection Closed Businessinspection_closed_businessinspection_closed_businessCheckbox
PhonephonephoneText
Program Identifierprogram_identifierprogram_identifierText
Violation Typeviolation_typeviolation_typeText
Inspection Resultinspection_resultinspection_resultText
GradegradegradeTextFood establishment grade