cityofchicago/food-inspections-4ijn-s7e5
 
Readme
Updated 1 day ago
Indexed 2 hours ago

Food Inspections

This information is derived from inspections of restaurants and other food establishments in Chicago from January 1, 2010 to the present. Inspections are performed by staff from the Chicago Department of Public Health’s Food Protection Program using a standardized procedure. The results of the inspection are inputted into a database, then reviewed and approved by a State of Illinois Licensed Environmental Health Practitioner (LEHP). For descriptions of the data elements included in this set, go to http://bit.ly/tS9IE8

Note about 7/1/2018 change to food inspection procedures that affects the data in this dataset: http://bit.ly/2yWd2JB

Disclaimer: Attempts have been made to minimize any and all duplicate inspection reports. However, the dataset may still contain such duplicates and the appropriate precautions should be exercised when viewing or analyzing these data. The result of the inspections (pass, pass with conditions or fail) as well as the violations noted are based on the findings identified and reported by the inspector at the time of the inspection, and may not reflect the findings noted at other times. For more information about Food Inspections, go to https://www.cityofchicago.org/city/en/depts/cdph/provdrs/healthy_restaurants/svcs/food-protection-services.html.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Inspection IDinspection_idinspection_idNumber
DBA Namedba_namedba_nameTextDoing Business As
AKA Nameaka_nameaka_nameTextAlso Known As
License #license_license_Number
Facility Typefacility_typefacility_typeText
RiskriskriskText
AddressaddressaddressText
CitycitycityText
StatestatestateText
ZipzipzipNumber
Inspection Dateinspection_dateinspection_dateCalendar date
Inspection Typeinspection_typeinspection_typeText
ResultsresultsresultsText
ViolationsviolationsviolationsText
LatitudelatitudelatitudeNumber
LongitudelongitudelongitudeNumber
LocationlocationlocationPoint
Location (address)location_addresslocation_addressText
Location (city)location_citylocation_cityText
Location (state)location_statelocation_stateText
Location (zip)location_ziplocation_zipText
Historical Wards 2003-2015:@computed_region_awaf_s7ux:@computed_region_awaf_s7uxNumber
Zip Codes:@computed_region_6mkv_f3dw:@computed_region_6mkv_f3dwNumber
Community Areas:@computed_region_vrxf_vc4k:@computed_region_vrxf_vc4kNumber
Census Tracts:@computed_region_bdys_3d7i:@computed_region_bdys_3d7iNumber
Wards:@computed_region_43wa_7qmu:@computed_region_43wa_7qmuNumber
Upstream Metadata