Inspection History for a Facility

View all inspections for a specific facility by certificate number (e.g., 43-A-0001).

Custom SQL query (hide) 

SELECT i.inspection_date, i.inspection_type, i.critical_count, i.noncritical_count, i.direct_count, i.teachable_moment_count, f.legal_name, f.site_city, f.site_state FROM inspections i JOIN facilities f ON f.cert_number = i.cert_number WHERE i.cert_number = :cert_number ORDER BY i.inspection_date DESC

Query parameters

Edit SQL

0 results