Citizen questions or requests for service are tracked via our 311 system. Requests are made by phone, text, email or web.

Contains the Inspection Violations for a Food Establishment Business during the current or previous year.

Food Establishment Businesses data set contains the Last Inspected date. If this date for the Business is newer than the most recent Inspection date in the Food Establishment Inspections data set, then the Business has a perfect score of 100.

It is possible to see a business with score of 100 where the Last Inspected Date matches the Inspection Date in the Food Establishment Inspections data set. However, the violation resulted in 0 points deducted from the score. Violations can result in a deduction of 0 to 5 points from a max score of 100.

Food Establishment Inspection data is contained in three data sets:

Food Establishment Businesses
Food Establishment Inspections
Food Establishment Violations

Data set relationships

Business: one to many -> Inspections (key: License Number)
Inspections: one to many -> Violations (key: License Number, Inspection Date)

Contains all business that have had food inspections during the current or previous year.

This data set contains the Last Inspected date. If this date for the Business is newer than the most recent Inspection date in the Food Establishment Inspections data set, then the Business has a perfect score of 100.

Food Establishment Inspection data is contained in three data sets:

Food Establishment Businesses
Food Establishment Inspections
Food Establishment Violations

Data set relationships

Business: one to many -> Inspections (key: License Number)
Inspections: one to many -> Violations (key: License Number, Inspection Date)

Annual Report on open data activities at the City of Evanston

Arrests in Evanston

Data shows the number adult and juvenile suspects, arrestees, and contact cards from the first quarter of 2017. Information is divided by race and ethnicity and percentage of the total number for each category.

Data shows the number adult and juvenile suspects, arrestees, and contact cards from the first quarter of 2017. Information is categorized by race and ethnicity and percentage of the total number for each category.

Citations January through May 2017 for traffic and city ordinance violations. This does not include parking citations.

Contains the list of Food Establishment Businesses and the current inspection score.

Food Establishment Inspection data is contained in four data sets:

Food Establishment Businesses
Food Establishment Inspections
Food Establishment Violations
Food Establishment List with Current Inspection Score

Data set relationships

Business: one to many -> Inspections (key: License Number)
Inspections: one to many -> Violations (key: License Number, Inspection Date)