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)