Total compensation for City of Evanston employees

Dataset contains 2015, 2016, and 2017 Amended Budgets and 2018 Adopted Budgets.

The number of traffic crashes officers handle during their tour of duty, including not only roadway crashes, but also private property crashes where reports are taken

Crashes in Evanston from October 1, 2016 to present.

Data of percentage of Evanston's population below the poverty line over time and the percentage of Evanston's families below the poverty line over time

Citations issued by officers during their tour of duty, excluding parking citations.

This dataset only reflects usage data for the 6 City-owned electric vehicle charging stations that utilize the Chargepoint platform. Information about other charging stations in Evanston can be found by visiting https://www.cityofevanston.org/about-evanston/sustainability/sustainable-infrastructure/electric-vehicle-charging-stations.

This dataset includes the monthly summary of the unique drivers, number of sessions used, number of stations and ports and the energy consumed.

Contains the Inspections 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)

Total number of sewer structures cleaned in the years 2008 through 2014.