Louisville Metro KY - Inspection Results Public Facility Establishments by US Government | Healthcare

About this Dataset

Louisville Metro KY - Inspection Results Public Facility Establishments

A list of permitted Public Facilities establishments (non food) with their last three inspection results.
Data Dictionary:
Facilty_Number - permit number
Facility_Name - facility name
Address - facility address
Zip - facility zip code
Area_Number - Geographic area number
Program_Code - Establishment Type Code
Establishment_Type - Establishment Type Text
Status - Indicates whether facility is active or inactive in system
Score_Recent - Most recent inspection score
DateRecent - Most recent inspection date
Score2 - 2nd most recent inspection score
Date2 - 2nd most recent inspection date
Score3 - 3rd most recent inspection score
Date3 - 3rd most recent inspection date

Contact:

Gerald Kaforski

gerald.kaforski@louisvilleky.gov
Organization: Louisville Metro Government
Last updated: 2023-04-13T13:32:05.240983
Tags: environmental-health, facility, 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_inspec_981f53f0.table_1

39.26 KB
505 rows
15 columns


CREATE TABLE table_1 (
  "facilty_number" BIGINT,
  "facility_name" VARCHAR,
  "address" VARCHAR,
  "zip" BIGINT,
  "area_number" BIGINT,
  "program_code" BIGINT,
  "establishment_type" VARCHAR,
  "status" VARCHAR,
  "score_recent" BIGINT,
  "daterecent" VARCHAR,
  "score2" BIGINT,
  "date2" TIMESTAMP,
  "score3" BIGINT,
  "date3" TIMESTAMP,
  "objectid" BIGINT
);