QA Dashboard

Constraint, derivation, and volume checks for admin validation.

Duplicate Business Natural Keys
0
Rows beyond unique natural key pairs in business
Duplicate Inspection Natural Keys
0
Rows beyond unique natural key pairs in inspection
Duplicate Violation Natural Keys
0
Rows beyond unique natural key pairs in violation
Inspections Without Violations
14
Inspections currently with no violations
Rating Mismatch Count
0
Inspections where derived rating disagrees with violation flags
Unmatched Closure Report Rows
0
Closure report rows that did not map to a facility
Follow-up Outstanding Mismatch
0
VCH follow-up inspections marked excellent/0 obs but near a closure event
Risk v1 vs v2 Differences
0
Businesses whose preferred risk changed under enforcement-aware risk_v2
Businesses Missing Coordinates
1
Businesses still missing latitude or longitude

Inspection Volume by Source

Source Inspections
vch_food_inspections 25

Coordinate Coverage by Source

Coverage of `business.latitude` / `business.longitude` plus geocode attempt status counts.

Source Businesses With Coordinates Missing Coverage Success No Match Insufficient Address Error Unattempted Geocode
vch_food_inspections
vch_food_inspections
 3 2 1 66.7% 0 0 0 0 3

Unmatched Closure Report Rows

Rows from closure reports that were not linked to a facility and require manual assignment.

No unmatched closure rows.

Follow-up Outstanding Mismatch

Potential VCH undercounts where an excellent follow-up with 0 observations occurs near a closure event.

No anomalies detected.

Risk Model Deltas

Businesses whose derived risk changed between additive `risk_v1` and enforcement-aware `risk_v2`.

No differences detected between `risk_v1` and `risk_v2`.