Louisville Metro KY - Pool Inspections
Louisville Metro Government
@usgov.louisville_metro_government_louisville_metro_ky_pool_i_704a712e
Louisville Metro Government
@usgov.louisville_metro_government_louisville_metro_ky_pool_i_704a712e
Routine reinspection of over 537 public pools and treated water aquatic facilities in the US State of Kentucky, totalling over 2,000 inspections per year. Inspections include spas (hot tubs), pools, wave pools, splash pads, theme park pools, and special purpose pools (such as dive pools) etc. Purpose of inspections is included in this data set.
For more information on Louisville Metro’s aquatic inspection program and policies, see:
https://louisvilleky.gov/government/health-wellness/swimming-pools
Data will be updated weekly. Each week the data will be posted as a rolling five year table. That is the new data will be a set that includes inspections from the day of posting minus five years.
Data Dictionary:
Field Name -Definition
InspectionID -Unique Identifier for the inspection
Facility ID -Unique Identifier for the Facility
Facility Name -Name of the Facility
Facility Address -Location of the Facility
Facility Address 2 -Location of the Facility
Facility City -Location of the Facility
Facility State -Location of the Facility
Facility Postal Code -Location of the Facility
Facility County -Location of the Facility
Venue Type -
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
LMPHWDataTeam@Louisvilleky.gov
Organization: Louisville Metro Government
Last updated: 2025-07-30T13:30:29.864735
Tags: anti-entrapment, anti-entrapment-devices, aquatic-facilities, aquatic-facility-inspection, bathing-load, bromine, chlorine, chlorine-residual, data-standard, disease, dive-pools, environmental-health, hot-tub, injury-prevention, interactive-water-feature, mahc, main-drain, model-aquatic-health-code, open-pool, ph, ph-levels, pool-closure, pool-disinfectant, pool-inspection, pool-lighting, pool-safety, pools, public-health, recreational-attraction, safe-data, safe-data-standard, safety-equipment, sanitary-facilities, spa, splash-pad, spray-pad, suction-outlets, swimming-pool, swimming-pools, theme-park, vgb, wading-pool, water-quality
CREATE TABLE table_1 (
"inspectionid" BIGINT,
"facility_id" BIGINT,
"facility_name" VARCHAR,
"facility_address" VARCHAR,
"facility_address_2" VARCHAR,
"facility_city" VARCHAR,
"facility_state" VARCHAR,
"facility_postal_code" BIGINT,
"facility_county" VARCHAR,
"venue_type" VARCHAR,
"inspection_date" VARCHAR,
"inspection_score" BIGINT,
"inspection_purpose" VARCHAR,
"inspection_passed" BOOLEAN,
"no_imminent_health_hazards" BOOLEAN,
"disinfectant" VARCHAR,
"free_chlorine" DOUBLE,
"free_bromine" DOUBLE,
"ph" DOUBLE,
"enclosure" BOOLEAN,
"main_drain_visible" BOOLEAN,
"safety_equipment" BOOLEAN,
"disinfectant_level" BOOLEAN,
"ph_balance" BOOLEAN,
"inspection_notes" VARCHAR,
"objectid" BIGINT
);Anyone who has the link will be able to view this.