Primary tabs

Inspections Bulk Data

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?

Data Preview: Note that by default the preview only displays up to 100 records. Use the pager to flip through more records or adjust the start and end fields to display the number of records you wish to see.

Additional Information

FieldValue
mimetypetext/csv
filesize13.41 MB
resource typefile upload
timestampOct 07, 2019