Description
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
Data Dictionary:
InspectionID-system id
EstablishmentID-permit number
RequestID-associated request or complaint id if applicable
EHSNumber-id number of inspector
CountyID-system id
InspectionDate-date of inspection
InspectionType-type of inspection
IsFollowUpInsp-is inspection a follow up inspection?
R_F_InspIDDesc-a designation of food or retail type for certain food establishments that require two types of inspections.
req_section-not used
GradeID-letter grade for inspection if applicable
score-inspection score
InspTimeHours
InspTimeMins
sample_attendance-not used
SampleAttendance-not used
NextInspDate
ACTION_CODE_DESC-sytem code of action taken text
IsComplaintResolved-if complaint related is the complaint resolved?
Contact:
Gerald Kaforski
Resources
| Name | Format | Description | Link |
|---|---|---|---|
| CSV | CSV | Open resource | |
| Excel | XLS | Open resource | |
| Feature Collection | Text | Open resource | |
| File Geodatabase | ZIP | Open resource | |
| GeoJSON | GeoJSON | Open resource | |
| GeoPackage | Unknown | Open resource | |
| KML | KML | Open resource | |
| Shapefile | ZIP | Open resource | |
| SQLite Geodatabase | Unknown | Open resource | |
| ArcGIS Hub Dataset | HTML | Open resource | |
| CSV | CSV | LOJIC::louisville-metro-ky-environmental-health-bulk-data-inspections.csv | Open resource |
| GeoJSON | GeoJSON | Open resource | |
| ArcGIS Hub Dataset | HTML | Open resource | |
| ArcGIS GeoService | ArcGIS GeoServices REST API | Open resource |