6.2 Data Set: Chicago Food Establishment Inspections

This data set is provided as a resource for instructors to use for in-class demonstrations as well as for students to explore using SQL. These data report details of the inspections of food establishments and have been extracted form the city of Chicago's open data portal (https://data.cityofchicago.org/Health-Human-Services/Food-Inspections/4ijn-s7e5/data). The city of Chicago does not publish which employee conducted each inspection, so fictitious values have been generated for that data to provide a richer querying experience. Data about fines charged for violations are not published either so informatoin about fines is also ficticious. However, the information about the food establishments, inspections, and violations are real data.

Use the query box below to explore the data set or use the avanced query editor, using the "Food Inspection" credentials.

SELECT * from inspection_point

Shown below is the data model for the Chicago Food Establishment Inspection data.