Food Establishment Inspection Data — King County

Health Department inspection results for food service establishments in King County, 2021 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 Actor returns it as one flat JSON row per record, with 20 declared fields — typed, named and documented in the dataset schema, so a spreadsheet or an agent can use it without guessing.

What you get

Field	Type	Meaning
name	string	Name
program_identifier	string	Program Identifier
inspection_date	string	Inspection Date
classification	string	Classification
address	string	Address
city	string	City
zip_code	number	Zip Code
inspection_type	string	Inspection Type
inspection_score	number	Inspection Score
inspection_result	string	Inspection Result
inspection_closed_business	string	Inspection Closed Business
seating_range	string	Seating Range
risk_category	number	Risk Category
violation_type	string	Violation Type
violation_description	string	Violation Description
violation_points	number	Violation Points
grade	string	Grade
parcel_number	number	Parcel Number
business_id	string	Business_ID
inspection_serial_num	string	Inspection_Serial_Num

Every row also carries sourceRowId, sourceUpdatedAt and scrapedAt, so a pipeline can tell one record from another and know exactly when it was read.

{
  "name": "#807 TUTTA BELLA",
  "program_identifier": "text",
  "inspection_date": "2026-05-28T00:00:00.000",
  "classification": "General Food Services",
  "address": "2746 NE 45TH ST",
  "city": "SEATTLE",
  "zip_code": 98105,
  "inspection_type": "Routine Inspection/Field Review"
}

Inputs

Field	What it does
Filter (SoQL)	Applied at the source, so a narrow question fetches a narrow page instead of downloading everything.
Order	Empty keeps the publisher's own order; set a column to sort, for example amount DESC.
Maximum rows	Hard cap. The source is paged 1,000 rows at a time.
Time budget	Stops cleanly and reports how far it got.
Pause between pages	Keeps the run inside the publisher's rate limits.

Limitations

• This is one dataset, from one publisher. It is the Food Establishment Inspection Data dataset as Public Health - Seattle & King County publishes it — not a national or cross-city equivalent, and not a merge with other sources.
• The publisher can change it. Columns are added, renamed and retired upstream; the field list here is the schema the Actor was generated from. A renamed column arrives as a new field only after the Actor is updated.
• Fields are typed from live records. A column that was empty in the sample is declared as text; a value that does not fit the declared type comes back null rather than being coerced into a wrong number.
• Records are what the publisher publishes. No geocoding, no de-duplication across datasets, no enrichment.
• Freshness is the publisher's. The data was last changed upstream on 2026-10-25. Where the publisher supplies a row timestamp it appears as sourceUpdatedAt; scrapedAt records when this Actor read the row.

Why this is different

• Food Establishment Inspection Data — King County declares all 20 of its output fields in the dataset schema, each with a type, a description and an example.
• The Actor reads the Food Establishment Inspection Data dataset directly from King County Open Data; no key, login or account is needed.
• Filters run at the source with SoQL, so a narrow request returns a narrow page rather than a full download.
• Every row is flat JSON: nested location objects become latitude and longitude, and no field holds a nested object.
• The row id is stable, so the same request de-duplicates instead of returning the same record twice.

FAQ

Do I need an API key? No. King County Open Data publishes this dataset openly.

How fresh is it? The Actor reads the dataset live. scrapedAt records when each row was read, and sourceUpdatedAt carries the publisher's own row timestamp where it supplies one.

Can I filter by date or status? Yes — use the Filter field with SoQL, for example status = 'Active'.

What happens if my filter is wrong? The run stops with the portal's own message and the hint to check SoQL, rather than returning an empty dataset that looks like "no data".

Is this the whole dataset? Up to your row cap, paged 1,000 at a time. Raise the cap to read more.

What is sourceRowId? The publisher's own row id when it supplies one, otherwise a stable hash of the row. Either way it is what makes de-duplication and joins possible.

Pricing

Pay per result: $0.0005 per row. A run that matches nothing is not charged for rows.

Data source

King County Open Data — Food Establishment Inspection Data, published by Public Health - Seattle & King County. Public data under the portal's open-data terms.