Data Description: This dataset contains all food facility inspections conducted by the Cincinnati Health Department from 2012 to present. This dataset contains license information, inspections and violations of the Ohio Uniform Food Safety Code. For more information, visit: https://www.cincinnati-oh.gov/health/cincinnati-health-department-divisions1/food-safety-program/ Data Creation: Data is created when the Cincinnati Health Department records a license, inspection, or food safety violation Data Created By: Cincinnati Health Department Refresh Frequency: Daily CincyInsights: The City of Cincinnati maintains an interactive dashboard portal, CincyInsights in addition to our Open Data in an effort to increase access and usage of city data. This data set has an associated dashboard available here: https://insights.cincinnati-oh.gov/stories/s/jp6g-pp8g/ Data Dictionary: A data dictionary providing definitions of columns and attributes is available as an attachment to this dataset. Processing: The City of Cincinnati is committed to providing the most granular and accurate data possible. In that pursuit the Office of Performance and Data Analytics facilitates standard processing to most raw data prior to publication. Processing includes but is not limited: address verification, geocoding, decoding attributes, and addition of administrative areas (i.e. Census, neighborhoods, police districts, etc.). Data Usage: For directions on downloading and using open data please visit our How-to Guide: https://data.cincinnati-oh.gov/dataset/Open-Data-How-To-Guide/gdr9-g3ad
This dataset has the following 24 columns:
Column Name | API Column Name | Data Type | Sample Values |
---|---|---|---|
RECORDNUM_LICENSE | recordnum_license | text | H200800731 H200802229 H200801219 H200900250 H200800442 view top 100 |
LICENSE_NO | license_no | text | FSO-006425-C4S FSO-016936-C4S FSO-010015-C4S FSO-017744-C4S FSO-004171-C3S view top 100 |
BUSINESS_NAME | business_name | text | "GREAT AMERICAN BALL PARK" "GOLD STAR CHILI" "IZZY'S" "MCDONALD'S" "HOOK FISH & CHICKEN" view top 100 |
ADDRESS | address | text | 1801 RACE ST 100 JOE NUXHALL WY 3400 VINE ST 5 PAUL BROWN STADIUM 580 WALNUT ST view top 100 |
CITY | city | text | CINCINNATI COLU FAIR view top 100 |
STATE | state | text | OH view top 100 |
POSTAL_CODE | postal_code | number | 45202 45219 45209 45208 45238 view top 100 |
LATITUDE | latitude | number | 39.09492024362707 39.11540392874998 39.097473412721264 39.13736528244302 39.102423186842074 view top 100 |
LONGITUDE | longitude | number | -84.5150567976107 -84.5184463268576 -84.5065654905927 -84.5034722007898 -84.5112676493989 view top 100 |
PHONE_NUMBER | phone_number | text | 5134554900 513-455-4900 5137657626 513 254-6345 513-765-7626 view top 100 |
LICENSE_STATUS | license_status | text | LICENSE PAID RENEWAL DELINQ APPLIED view top 100 |
RECORDNUM_INSP | recordnum_insp | text | CFSI212663 CFSI213258 CFSI210405 CFSI211903 CFSI211652 view top 100 |
INSP_TYPE | insp_type | text | ROUTINE COMPLAINT INITIAL view top 100 |
INSP_SUBTYPE | insp_subtype | text | STANDARD INSPECTION CRITICAL CONTROL POINT COMPLAINT PROCESS REVIEW INITIAL view top 100 |
ACTION_DATE | action_date | calendar_date | 2022-02-24T00:00:00.000 2015-03-05T00:00:00.000 2022-02-26T00:00:00.000 2013-06-27T00:00:00.000 2013-08-21T00:00:00.000 view top 100 |
ACTION_SEQUENCE | action_sequence | text | A028317383 A017327598 A022238194 A026093629 A022812247 view top 100 |
ACTION_STATUS | action_status | text | Not Abated Abated Abated On-Site CLOS-NO - No Violations Found view top 100 |
CODE | code | text | 3717-1-06.4(B)(1) 3717-1-03.4(F)(1)(b) 3717-1-04.5(A)(3) 3717-1-04.4(A)(1) 3717-1-04.5(A)(1)(2) view top 100 |
VIOLATION_DESCRIPTION | violation_description | text | "3717-1-04.4(A)(1) - Violation - Equipment-good repair and proper adjustment. Equipment and/or components were not maintained in good working order." "3717-1-04.5(A)(3) - Violation - Equipment cleanliness-Nonfood-contact Non-food contact surfaces are dirty." "3717-1-03.4(F)(1)(b) - Violation - TCS-cold holding TCS foods were being held at temperatures >41° F." "3717-1-06.4(B)(1) - Violation - Facilities: Cleaning: Frequency The physical facilities are not cleaned as often as necessary to keep them clean." "3717-1-04.5(A)(1)(2) - Violation - Equipment cleanliness-food contact Food-contact surfaces were dirty." view top 100 |
VIOLATION_COMMENTS | violation_comments | text | "Violation has been abated" "PIC-Level 2 Certification No manager has level 2 certification in food protection." "" "PIC Duties -response plan for vomiting/diarrhea No/inadequate written procedures for response to vomiting/diarrheal events." "Wiping cloths-use limitation Wet wiping cloth was not maintained in a sanitizer solution between uses." view top 100 |
VIOLATION_KEY | violation_key | text | HF18161460 HLEC14006V HF18622585 HF18220815 HLE131465V view top 100 |
LAST_TABLE_UPDATE | last_table_update | calendar_date | 2015-03-05T00:00:00.000 2022-02-28T00:00:00.000 2017-05-04T00:00:00.000 2019-12-13T00:00:00.000 2016-06-29T00:00:00.000 view top 100 |
NEIGHBORHOOD | neighborhood | text | DOWNTOWN OAKLEY CUF OVER-THE-RHINE WESTWOOD view top 100 |
COMMUNITY_COUNCIL_NEIGHBORHOOD | community_council_neighborhood | text | view top 100 |