About this Dataset

Louisville Metro KY - Inspection Results Pools

A list of permitted Pools with the last three inspection results.

Data Dictionary:
ScoreRecent - 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
permit_number - facility permit number
facility_type - facility type code
facility_type_description - text description of facility type
subtype - facility subtype code
subtype description - text description of faacility subtype
premise_name - facility name
premise_address - facility address
premise_city - facility city
premise_state - facility state
premise_zip - facility zip code
opening_date - date of permit of current owner

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:27:40.602496
Tags: environmental-health, health, inspections, jefferson-county, kentucky, louisville, louisville-metro, louisville-metro-ky, metro-health, pool, pool-inspection, pools, public-health, public-health-and-wellness, sanitation

Tables

Table 1

@usgov.louisville_metro_government_louisville_metro_ky_inspec_6e0d41ad.table_1

44.91 kB
538 rows
18 columns

CREATE TABLE table_1 (
  "scorerecent" BIGINT,
  "daterecent" VARCHAR,
  "score2" BIGINT,
  "date2" TIMESTAMP,
  "score3" BIGINT,
  "date3" TIMESTAMP,
  "permit_number" BIGINT,
  "facility_type" BIGINT,
  "facility_type_description" VARCHAR,
  "subtype" BIGINT,
  "subtype_description" VARCHAR,
  "premise_name" VARCHAR,
  "premise_address" VARCHAR,
  "premise_city" VARCHAR,
  "premise_state" VARCHAR,
  "premise_zip" BIGINT,
  "opening_date" TIMESTAMP,
  "objectid" BIGINT
);