US Restaurant Health Inspections (6 Cities)
Pricing
from $1.40 / 1,000 inspection records
Restaurant health inspections from NYC, Chicago, San Francisco, Austin, Seattle and Cincinnati open data: scores, grades, pass/fail and violations.
jurisdiction
Required
Jurisdiction id: nyc, chicago, san-francisco, austin, king-county or cincinnati.
jurisdictionName
Optional
Jurisdiction and health department.
recordId
Required
Stable unique id of this inspection: jurisdiction plus the department's inspection key.
establishmentId
Required
The department's id for the establishment (CAMIS, license, permit or business id).
name
Required
Business (DBA) name as published.
address
Optional
Street address.
city
Optional
City (NYC: borough, Manhattan shown as New York).
state
Required
Two-letter state.
zip
Optional
ZIP code; null in San Francisco, which does not publish one.
latitude
Optional
longitude
Optional
inspectionDate
Required
Inspection date, YYYY-MM-DD.
inspectionType
Optional
Inspection type as published (routine, re-inspection, complaint, license...).
scorePublished
Optional
Score as published. Direction differs: NYC and King County count points (lower is better), Austin scores out of 100 (higher is better).
gradePublished
Optional
Grade or rating as published (NYC letter grade, King County rating, Austin color band).
resultPublished
Optional
The department's own result or action text.
result
Optional
Normalized outcome (mapping in the README); null when the inspection has no assessable result.
violationCount
Optional
Number of violations; null where the dataset publishes no violation detail (Austin).
criticalViolationCount
Optional
Violations flagged critical by the department; null where no critical flag is published.
violations
Optional
Violations: code, description, critical (true/false/null as published), criticalPublished, points, comments.
details
Optional
Jurisdiction-specific extras (cuisine, risk level, facility type, permit type, neighborhood...).
sourceDatasetUrl
Required
The official dataset page.
sourceApiUrl
Optional
The SODA API query this record came from.
scrapedAt
Required
ISO 8601 time the record was saved.
