About this Dataset

Louisville Metro KY - Environmental Health Bulk Data - Inspections

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

gerald.kaforski@louisvilleky.gov
Organization: Louisville Metro Government
Last updated: 2025-07-30T13:19:03.287222
Tags: environmental-health, health, inspections, jefferson-county, kentucky, louisville, louisville-metro, louisville-metro-ky, metro-health, public-health, public-health-and-wellness, sanitation

Tables

Table 1

@usgov.louisville_metro_government_louisville_metro_ky_enviro_ea1a9d69.table_1

2.05 MB
91,451 rows
20 columns

CREATE TABLE table_1 (
  "inspectionid" BIGINT,
  "establishmentid" BIGINT,
  "requestid" BIGINT,
  "ehsnumber" VARCHAR,
  "countyid" BIGINT,
  "inspectiondate" VARCHAR,
  "inspectiontype" VARCHAR,
  "isfollowupinsp" VARCHAR,
  "r_f_inspiddesc" VARCHAR,
  "req_section" VARCHAR,
  "gradeid" VARCHAR,
  "score" BIGINT,
  "insptimehours" BIGINT,
  "insptimemins" BIGINT,
  "sample_attendance" VARCHAR,
  "sampleattendance" VARCHAR,
  "nextinspdate" TIMESTAMP,
  "action_code_desc" VARCHAR,
  "iscomplaintresolved" VARCHAR,
  "objectid" BIGINT
);