About this Dataset

Louisville Metro KY - Inspection Violations Of Failed Restaurants

A list of the violations recorded against permitted restaurants that failed inspection.
**
**

Data Dictionary:
EstablishmentID - Permit Number
InspectionDate - date of inspection
InspectionID - system inspection id
EstTypeDesc - desciption of facility type
premise_name - facility name
premise_adr1_num - facility street number
premise_adr1_street - facility street
premise_city - facility city
premise_state - facility state
premise_zip - facility zip code
InspectionType - description of inspection type
score - inspection score
InspTypeSpecificViolID - Violation ID for specific type of facility
ViolationDesc - text description of violation
critical_yn - Is the violation critical?
Insp_Viol_Comments - violation comments
rpt_area_id - Establishment Type Code

Health and Wellness Protects and promotes the health, environment and well being of the people of Louisville, providing health-related programs and health office locations community wide.

Contact:

Gerald Kaforski

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

Tables

Table 1

@usgov.louisville_metro_government_louisville_metro_ky_inspec_6bc54cef.table_1

248.67 kB
3,810 rows
18 columns

CREATE TABLE table_1 (
  "establishmentid" BIGINT,
  "inspectiondate" VARCHAR,
  "inspectionid" BIGINT,
  "esttypedesc" VARCHAR,
  "premise_name" VARCHAR,
  "premise_adr1_num" VARCHAR,
  "premise_adr1_street" VARCHAR,
  "premise_city" VARCHAR,
  "premise_state" VARCHAR,
  "premise_zip" BIGINT,
  "inspectiontype" VARCHAR,
  "score" BIGINT,
  "insptypespecificviolid" BIGINT,
  "violationdesc" VARCHAR,
  "critical_yn" VARCHAR,
  "insp_viol_comments" VARCHAR,
  "rpt_area_id" VARCHAR,
  "objectid" BIGINT
);