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 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)

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)

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)

Number of total households in Evanston compared to the percentage of households meeting/exceeding the living wage. Threshold living wage income for Evanston calculated to be $50,000.

A comparison of GINI Coefficients between Evanston and the national average.
The GINI index, a measure of statistical dispersion intended to represent income distribution, is used to assess income inequality. This number, which ranges between 0 and 1, is based on residents' net income and helps define the gap between the rich and the poor, with 0 representing perfect equality and 1 representing perfect inequality.

Amount collected quarterly in real estate transfer taxes

A comparison of Evanston's employment rates for various demographics and the percent of labor force participation for each demographic.