About this Dataset

Louisville Metro KY - Environmental Health Bulk Data - Inspection Violations

Descriptions of violations recorded during inspections by Louisville Metro Department of Public Health and Wellness. The Inspection_id column corresponds to the InspectionID column in the Inspections table. There are 0 to many inspection violations associated with each inspection in the Inspections table.
Data Dictionary:
inspection_id-system id of inspection
InspTypeSpecificViolID-violatio number for type of inspection
ViolationDesc-description of the violation
weight-points taken off for violation
critical_yn-is this a critical violation? If so means inspection failure
comments
rpt_area_id-facility type code
delete_mark_id-system indicator
id-violation system id

Contact:

Gerald Kaforski

gerald.kaforski@louisvilleky.gov
Organization: Louisville Metro Government
Last updated: 2023-04-13T13:32:00.035712
Tags: environmental-health, health, inspection-violations, inspections, jefferson-county, kentucky, louisville, louisville-metro, louisville-metro-ky, metro-health, public-health, public-health-and-wellness, sanitation, violations

Tables

Table 1

@usgov.louisville_metro_government_louisville_metro_ky_enviro_c417d8dc.table_1

4.73 MB
102,644 rows
10 columns

CREATE TABLE table_1 (
  "inspection_id" BIGINT,
  "insptypespecificviolid" BIGINT,
  "violationdesc" VARCHAR,
  "weight" BIGINT,
  "critical_yn" VARCHAR,
  "comments" VARCHAR,
  "rpt_area_id" VARCHAR,
  "delete_mark_id" VARCHAR,
  "id" VARCHAR,
  "objectid" BIGINT
);