Louisville Metro KY - Environmental Health Bulk Data - Inspections

<span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>Attributes of routine and complaint driven inspections performed by Louisville Metro Department of Public Health and Wellness. EstablishmentID column can be joined to the EstablishmentID column in the Establishments Table to show attributes of the Establishment when a regulated establishment is involved</span><br /><strong>Data Dictionary:</strong><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>InspectionID-system id</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>EstablishmentID-permit number</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>RequestID-associated request or complaint id if applicable</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>EHSNumber-id number of inspector</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>CountyID-system id</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>InspectionDate-date of inspection</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>InspectionType-type of inspection</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>IsFollowUpInsp-is inspection a follow up inspection?</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>R_F_InspIDDesc-a designation of food or retail type for certain food establishments that require two types of inspections.</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>req_section-not used</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>GradeID-letter grade for inspection if applicable</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>score-inspection score</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>InspTimeHours</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>InspTimeMins</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>sample_attendance-not used</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>SampleAttendance-not used</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>NextInspDate</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>ACTION_CODE_DESC-sytem code of action taken text</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>IsComplaintResolved-if complaint related is the complaint resolved?</span><div><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'><br /></span></div><div><p style='margin-top:0px; margin-bottom:1.25em; font-size:16px; box-sizing:border-box; font-family:Lato;'><font color='#000080' style='font-family:inherit;'>Contact:</font></p><p style='margin-top:0px; margin-bottom:1.25em; font-size:16px; box-sizing:border-box; font-family:Lato;'><font color='#000080' style='font-family:inherit;'>Gerald Kaforski</font></p><p style='margin-top:0px; margin-bottom:1.25em; font-size:16px; box-sizing:border-box; font-family:Lato;'><a href='mailto:gerald.kaforski@louisvilleky.gov' style='color:rgb(0, 121, 193); text-decoration-line:none; font-family:inherit; box-sizing:border-box;' rel='nofollow ugc'><font color='#000080' style='font-family:inherit;'>gerald.kaforski@louisvilleky.gov</font></a></p></div>

Tags: environmental-health, health, inspections, jefferson-county, kentucky, louisville, louisville-metro, louisville-metro-ky, metro-health, public-health, public-health-and-wellness, sanitation
Organization: Louisville Metro Government