Data Quality Observations
Data Quality Issues
Outdated Ratings
Issue: 25% of "Excellent" ratings are 2+ years old
Data: 3,226 establishments with ratings from 2022-2023
Inspection Frequency Issues
Issue: 2-4 year gaps between inspections
Data: 6,332 Inspections in 2024
Data Distribution Problems
Recent Data Concentration
Issue: 69.6% of Rating 5s from 2024-2025 only
To Be Determined
Issue: Additional data quality issues to be identified
To Be Determined
Issue: Additional data quality issues to be identified
Statistical Impact Analysis
Rating Distribution (Total: 16,818 establishments)
| Rating | Count | Percentage | Status |
|---|---|---|---|
| 5 (Excellent) | 12,635 | 75.1% | Valid |
| 4 (Very Good) | 1,865 | 11.1% | Valid |
| 3 (Good) | 579 | 3.4% | Valid |
| 2 (Improvement) | 127 | 0.8% | Valid |
| 1 (Critical) | 55 | 0.3% | Valid |
| 0 (Urgent) | 1 | 0.0% | Valid |
| Exempt | 1,096 | 6.5% | Special |
| Awaiting Inspection | 459 | 2.7% | Special |
| Awaiting Publication | 1 | 0.0% | Special |
Data Quality Summary
Valid Regular Ratings (0-5)
90.7%
Invalid Special Status
9.3%
Outdated Ratings (2+ years)
~25%
Recent Data (2024-2025)
~70%