Louisville Metro KY - Inspection Violations of Failed Restaurants

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

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- * POOL-Any natural or artificial body or basin of water which is modified, improved, constructed or installed for the purpose of public swimming or bathing under the control or any person and includes but is not limited to the following: beaches, swimming pools, wave pools, competition swimming pools, diving pools, water slides and spray pools. * HOT TUB/SPA-A special facility designed for recreational and therapeutic use, and which is not drained, cleaned, or refilled after each individual use. It may include, but not limited to, units designed for hydrojet circulation, hot water, cold water, mineral bath, air induction bubbles, or any combination thereof. Common terminology for a spa includes but not limited to, therapeutic pool, hydrotherapy pool, whirlpool, hot spa * WADING POOL-A pool intended only for small children. The maximum depth is less than twenty-four (24) inches. * OTHER-Any other swimming facility not specifically defined Inspection Date-Date the inspection was performed Inspection Score-"value between 0-100%, 86% without critical issue is a passing facility. A facility facility may have a score of 0 if the purpose of the inspection was ""Other""" Inspection Purpose- * ROUTINE: Used to record routine inspection on an establishment and other facilities. * FOLLOW-UP: Used to record all follow-up inspections as a result of a previous inspection. * COMPLAINT: Used to record the investigation of a complaint received by the agency for regulated establishments, nuisances and the initial investigation for an animal bite. * OTHER: The inspections are not given a numerical score. This inspection type used to record monitoring inspections for swimming pools. " Inspection Passed-TRUE: Inspection Score >= 86% without any critical violations. No Imminent Health Hazards-TRUE: no conditions are present that required of immediate closure of facility. Disinfectant-Type of disinfectant used at the facility, either BROMINE or CHLORINE Free Chlorine-measured in parts per million (PPM), the amount of free Chlorine in the body of water. Free Bromine-measured in parts per million (PPM), the amount of free Bromine in the body of water. pH-The amount of acidity measured in the body of water. Enclosure-TRUE: Facility Enclosure: adequate, self closing gate, good repair or locked if no lifeguard on duty. Main Drain Visible-TRUE: Turbidity: the water is clear enough to see the main drain at the bottom of the body of water. Safety Equipment"-TRUE: First Aid, Safety Equipment, Spa Timer Switch, Telephone: readily accessible, adequate, maintained, good repair POOLS and/or SPAS could include elevated lifeguard chair, ring buoy, life pole/shepherds crook, backboard with straps, first aid kit. " Disinfectant Level-TRUE: CHLORINE disinfectant levels maintained between 1.0 and 2.5ppm for pools or slides, 2.0 and 3.0ppm for spas. BROMINE disinfectant levels maintained between 1.0 and 2.5ppm for pools or slides, 3.0ppm for spas. Anything outside this range is considered a violation. When only a shallow end reading is taken or shallow and deep end reading the shallow end value is used. If only a deep end reading is taken that value is used. pH Balance-TRUE: pH value tested between 7.2 and 7.8, anything outside this range is considered a violation. Inspection Notes-Description of violations noted at the facility. 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

The data provided in this dataset is preliminary in nature and may have not been investigated by a detective at the time of download. The data is therefore subject to change after a complete investigation. This data represents only calls for police service where a police incident report was taken. Due to the variations in local laws and ordinances involving crimes across the nation, whether another agency utilizes Uniform Crime Report (UCR) or National Incident Based Reporting System (NIBRS) guidelines, and the results learned after an official investigation, comparisons should not be made between the statistics generated with this dataset to any other official police reports. Totals in the database may vary considerably from official totals following the investigation and final categorization of a crime. Therefore, the data should not be used for comparisons with Uniform Crime Report or other summary statistics.   Data is broken out by year into separate CSV files. Note the file grouping by year is based on the crime's Date Reported (not the Date Occurred). Older cases found in the 2003 data are indicative of cold case research. Older cases are entered into the Police database system and tracked but dates and times of the original case are maintained. Data may also be viewed off-site in map form for just the last 6 months on communitycrimemap.com Data Dictionary: Field Name Field Description Incident Number the number associated with either the incident or used as reference to store the items in our evidence rooms Date Reported the date the incident was reported to LMPD Date Occurred the date the incident actually occurred Badge ID Badge ID of responding Officer Offense Classification NIBRS Reporting category for the criminal act committed Offense Code Name NIBRS Reporting code for the criminal act committed NIBRS_CODE the code that follows the guidelines of the National Incident Based Reporting System. For more details visit https://ucr.fbi.gov/nibrs/2011/resources/nibrs-offense-codes/view NIBRS Group hierarchy that follows the guidelines of the FBI National Incident Based Reporting System Was Offense Completed Status indicating whether the incident was an attempted crime or a completed crime. LMPD Division the LMPD division in which the incident actually occurred LMPD Beat the LMPD beat in which the incident actually occurred Location Category the type of location in which the incident occurred (e.g. Restaurant) Block Address the location the incident occurred City the city associated to the incident block location Zip Code the zip code associated to the incident block location Contact: LMPD Open Records    lmpdopenrecords@louisvilleky.gov

The location of water tanks for public water systems in the Commonwealth of Kentucky. A water tank is a feature that is used for water storage in a distribution system or at a water treatment plant.

The purpose of this feature class is to illustrate the location of water pumps in public water systems in the Commonwealth of Kentucky as collected by Kentucky’s Area Development Districts and provided by the Kentucky Division of Water. The locations of water pumps, along with the basic attribute data concerning those features, are used by the Kentucky Infrastructure Authority, Area Development Districts, public water systems, and other state/local agencies for the purpose of water infrastructure planning and management, project development, asset inventories, capital improvement plans, data analysis, and for any other purpose that will improve the potable water infrastructure and service in the Commonwealth of Kentucky.

This dataset shows the list of operating health facilities. Attributes included: Name,Nature of Facility, Activities, Lat, Long