King County

Close
Author
rickets100
Description
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/24/2017 and is current from 1/1/2006 to 04/21/2017.
Category
Health
Tags
government, health, restaurant inspections, violations, closures, food safety
Rating
Current value: 0 out of 5
Data Provided By
Public Health - Seattle & King County
Source Link
http://www.kingcounty.gov/healthservices/health/ehs/foodsafety/inspections.aspx
License
Public Domain
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

Name
name
Program Identifier
program_identifier
Inspection Date
inspection_date
Description
description
Address
address
City
city
Zip Code
zip_code
Phone
phone
Longitude
longitude
Latitude
latitude
Inspection Business Name
inspection_business_name
Inspection Type
inspection_type
Inspection Score
inspection_score
Inspection Result
inspection_result
Inspection Closed Business
inspection_closed_business
Violation Type
violation_type
Violation Description
violation_description
Violation Points
violation_points
Business_ID
business_id
Inspection_Serial_Num
inspection_serial_num
Violation_Record_ID
violation_record_id
Grade
grade

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.