Attributes of Public Health related complaints reported by the public and investigated by Louisville Metro Department of Public Health and Wellness. Personal/identifying data has been removed. EstID column can be joined to the EstablishmentID column in the Establishments table to show attributes of the establishment when a regulated establishment is involved.
Data Dictionary:
RequestComplaintID-System ID
Rcode-Code for Type of Complaint or Request
RCodeDescription-Text of type of complaint or request
EHS-the license number of the technician investigating
section-complaint section
TakenBy-who took the complaint or service request
Method-how the complaint or service request was taken in
Duplicate-is this a duplicate request? System notation
EstID-Associated permitted facility if applicable
oss_id-associated onsite sewage file if applicable
RequestDate-date of request or complaint
ResolvedDate-date request or complaint was resolved
NextInspDate-scheduled next inspection date
IsCityorCounty-is this a city or county request?
Status-is the request open or resolved?
RequestType-request type
IsFollowUp-is this a folowo up entry to an already open request
OwnerType- Owner or agent? If applicable
PersonOrPremiseZip-zip code of subject person
ComplaintantZip-zip code of person making the complaint
OwnerZip-zip code of the owner of the premises if applicable

Contact:

Gerald Kaforski

gerald.kaforski@louisvilleky.gov

A list of permitted Public Facility Establishments (other than Food Service)Data Dictionary:facility_type - Code for facility typefacility_type_description - Code translation for facility typesubtype - Code for facility subtypesubtype_description - Code translation for facility subtypepermit_number - permit numberpremise_name - name of facilitypremise_address - address of facilitypremise_city - city of facilitypremise_state - state of facilitypremise_zip - zip of facilityInspection_Area - Inspector assigned geographical areaopening_date - date facility was permitted by current ownerHealth 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 Kaforskigerald.kaforski@louisvilleky.gov

Attributes of Public Health related complaints reported by the public and investigated by Louisville Metro Department of Public Health and Wellness. Personal/identifying data has been removed. EstID column can be joined to the EstablishmentID column in the Establishments table to show attributes of the establishment when a regulated establishment is involved. Data Dictionary: RequestComplaintID-System ID Rcode-Code for Type of Complaint or Request RCodeDescription-Text of type of complaint or request EHS-the license number of the technician investigating section-complaint section TakenBy-who took the complaint or service request Method-how the complaint or service request was taken in Duplicate-is this a duplicate request? System notation EstID-Associated permitted facility if applicable oss_id-associated onsite sewage file if applicable RequestDate-date of request or complaint ResolvedDate-date request or complaint was resolved NextInspDate-scheduled next inspection date IsCityorCounty-is this a city or county request? Status-is the request open or resolved? RequestType-request type IsFollowUp-is this a folowo up entry to an already open request OwnerType- Owner or agent? If applicable PersonOrPremiseZip-zip code of subject person ComplaintantZip-zip code of person making the complaint OwnerZip-zip code of the owner of the premises if applicable

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

Attributes of routine and complaint driven inspections performed by Louisville Metro Department of Public Health and Wellness. EstablishmentID column can be joined to the EstablishmentID column in the Establishments Table to show attributes of the Establishment when a regulated establishment is involvedData Dictionary:InspectionID-system idEstablishmentID-permit numberRequestID-associated request or complaint id if applicableEHSNumber-id number of inspectorCountyID-system idInspectionDate-date of inspectionInspectionType-type of inspectionIsFollowUpInsp-is inspection a follow up inspection?R_F_InspIDDesc-a designation of food or retail type for certain food establishments that require two types of inspections.req_section-not usedGradeID-letter grade for inspection if applicablescore-inspection scoreInspTimeHoursInspTimeMinssample_attendance-not usedSampleAttendance-not usedNextInspDateACTION_CODE_DESC-sytem code of action taken textIsComplaintResolved-if complaint related is the complaint resolved?Contact:Gerald Kaforskigerald.kaforski@louisvilleky.gov

Attributes of animal bite incidents reported to and investigated by Louisville Metro Department of Public Health and Wellness. Personal/identifying data has been removed.Data Dictionary:id-system idbite_date-reported date of animal biteSpeciesIDDesc-animal speciesBreedIDDesc-animal breedbreed-secondat breed field for manual entryGenderIDDesc-animal gendercolor-animal colorvaccination_yrs-how long vaccination is effective forvaccination_date-date of last rabies vaccinationvictim_zip-zip code of victimAdvIssuedYNDesc-was an advisory ordered?WhereBittenIDDesc-Where was bite body or head?quarantine_date-quarrantine date if applicableDispositionIDDesc-disposition of animal if knownhead_sent_date-date head sent for testing if applicablerelease_date-date of release from quarrantine if knownResultsIDDesc-results of testing if applicableFollowupYNDesc-is this a followup entry?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 Kaforskigerald.kaforski@louisvilleky.gov

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 inspectionInspTypeSpecificViolID-violatio number for type of inspectionViolationDesc-description of the violationweight-points taken off for violationcritical_yn-is this a critical violation? If so means inspection failurecommentsrpt_area_id-facility type codedelete_mark_id-system indicatorid-violation system idContact:Gerald Kaforskigerald.kaforski@louisvilleky.gov

description:

Attributes of routine and complaint driven inspections performed by Louisville Metro Department of Public Health and Wellness. EstablishmentID column can be joined to the EstablishmentID column in the Establishments Table to show attributes of the Establishment when a regulated establishment is involved.

Attributes of routine and complaint driven inspections performed by Louisville Metro Department of Public Health and Wellness. EstablishmentID column can be joined to the EstablishmentID column in the Establishments Table to show attributes of the Establishment when a regulated establishment is involved.

This is a list of locations of which the following conditions apply:ACTIVITY TYPE ID 4 SURVEY – Surveillance was conducted on the business and no violations were found. Reviews conducted during routine inspections of permitted establishments from 1/21/21 on.LMPHW Narrative: Louisville Metro Public Health and Wellness (LMPHW) investigates and responds to reports of alleged violations related to COVID-19. LMPHW has provided an open dataset of businesses that were observed to not be following the covid requirements as prescribed by the Governor’s Office. The data does not distinguish between the type of enforcement action taken with the exception of the closure of a facility for operating when they were to be closed. The data shows that an order or citation was issued with or without a fine assessed. A minimum of one violation or multiple violations were observed on this day. Violations include but are not limited to failure to wear a face covering, lack of social distancing, failure to properly isolate or quarantine personnel, failure to conduct health checks, and other violations of the Governor’s Orders. Closure orders documented in the data portal where issued by either LMPHW, Shively Police or the Kentucky Labor Cabinet. Detail the Enforcement Process: The Environmental Division receives complaints of non-compliance on local businesses. Complaints are received from several sources including: Metro Call, Louisville Metro Public Health and Wellness’ Environmental call line, Facebook, email, and other sources. Complaints are investigated by inspectors in addition to surveillance of businesses to ensure compliance. Violations observed result in both compliance guidance being given to the business along with an enforcement notice which consists of either a Face Covering Citation and/or a Public Health Notice and Order depending on the type of violation. Citations result in fines being assessed. Violations are to be addressed immediately.Community members can report a complaint via Metro Call by calling 574-5000. For COVID 19 Guidance please visit Louisville Metro’s Covid Resource Center at https://louisvilleky.gov/government/louisville-covid-19-resource-center or calling the Covid Helpline at (502)912-8598.ACTIVITY TYPE ID 12 indicates an Enforcement Action has been taken against the establishment which include Notice to Correct, Citation which include financial penalties and/or Cease Operation. LMPHW Narrative Example: Louisville Metro Public Health and Wellness (LMPHW) investigates and responds to reports of alleged violations related to COVID-19. They also conduct surveillance of businesses to determine compliance. LMPHW has provided an open dataset of businesses that were observed to be following the covid requirements as prescribed by the Governor’s Office. ACTIVITY TYPE ID 4 SURVEY – Surveillance was conducted on the business and no violations were found. ACTIVITY TYPE ID 7 FIELD – A complaint was investigated on the business and no violations were found.ACTIVITY TYPE ID 12 Enforcement Action – Action has been taken against the establishment which could include Notice to Correct, Citation which include financial penalties and/or Cease Operation. ACTIVITY TYPE ID 12 Enforcement Action – Action Code Z – The establishment has been issued an order to cease operation.Data Set Explanation:Activity Type ID 4 Survey has two separate files: COVID_4_Surveillance_Open_Data – Surveillance conducted prior to 1/21/2021 in which were conducted as part of random survey of businessesCOVID_4_Compliance_Reviews_Open_Data – Reviews conducted during routine inspections of permitted establishments from 1/21/21 on. Data Dictionary: REQ ID-ID of RequestRequest Date-Date of Requestperson premiseaddress1zipActivity Date-Date Activity OccurredACTIVITY TYPE IDActivity Type Desc-Description of ActivityContact:Gerald Kaforskigerald.kaforski@louisvilleky.gov

This is a list of locations of which the following conditions apply:ACTIVITY TYPE ID 7 FIELD – A complaint was investigated on the business and no violations were found.LMPHW Narrative: Louisville Metro Public Health and Wellness (LMPHW) investigates and responds to reports of alleged violations related to COVID-19. LMPHW has provided an open dataset of businesses that were observed to not be following the covid requirements as prescribed by the Governor’s Office. The data does not distinguish between the type of enforcement action taken with the exception of the closure of a facility for operating when they were to be closed. The data shows that an order or citation was issued with or without a fine assessed. A minimum of one violation or multiple violations were observed on this day. Violations include but are not limited to failure to wear a face covering, lack of social distancing, failure to properly isolate or quarantine personnel, failure to conduct health checks, and other violations of the Governor’s Orders. Closure orders documented in the data portal where issued by either LMPHW, Shively Police or the Kentucky Labor Cabinet. Detail the Enforcement Process: The Environmental Division receives complaints of non-compliance on local businesses. Complaints are received from several sources including: Metro Call, Louisville Metro Public Health and Wellness’ Environmental call line, Facebook, email, and other sources. Complaints are investigated by inspectors in addition to surveillance of businesses to ensure compliance. Violations observed result in both compliance guidance being given to the business along with an enforcement notice which consists of either a Face Covering Citation and/or a Public Health Notice and Order depending on the type of violation. Citations result in fines being assessed. Violations are to be addressed immediately.Community members can report a complaint via Metro Call by calling 574-5000. For COVID 19 Guidance please visit Louisville Metro’s Covid Resource Center at https://louisvilleky.gov/government/louisville-covid-19-resource-center or calling the Covid Helpline at (502)912-8598.ACTIVITY TYPE ID 12 indicates an Enforcement Action has been taken against the establishment which include Notice to Correct, Citation which include financial penalties and/or Cease Operation. LMPHW Narrative Example: Louisville Metro Public Health and Wellness (LMPHW) investigates and responds to reports of alleged violations related to COVID-19. They also conduct surveillance of businesses to determine compliance. LMPHW has provided an open dataset of businesses that were observed to be following the covid requirements as prescribed by the Governor’s Office. ACTIVITY TYPE ID 4 SURVEY – Surveillance was conducted on the business and no violations were found. ACTIVITY TYPE ID 7 FIELD – A complaint was investigated on the business and no violations were found.ACTIVITY TYPE ID 12 Enforcement Action – Action has been taken against the establishment which could include Notice to Correct, Citation which include financial penalties and/or Cease Operation. ACTIVITY TYPE ID 12 Enforcement Action – Action Code Z – The establishment has been issued an order to cease operation.Data Set Explanation:Activity Type ID 4 Survey has two separate files: COVID_4_Surveillance_Open_Data – Surveillance conducted prior to 1/21/2021 in which were conducted as part of random survey of businessesCOVID_4_Compliance_Reviews_Open_Data – Reviews conducted during routine inspections of permitted establishments from 1/21/21 on. Data Dictionary: REQ ID-ID of RequestRequest Date-Date of Requestperson premiseaddress1zipActivity Date-Date Activity OccurredACTIVITY TYPE IDActivity Type Desc-Description of ActivityContact:Gerald Kaforskigerald.kaforski@louisvilleky.gov

This is a list of locations of which the following conditions apply:Coded in our database as 12 - Enforcement Action was taken on a complaint investigation or surveillance of the business. The Action taken was that a Notice of Correction (Order) or Citation was issued to the business. LMPHW Narrative: Louisville Metro Public Health and Wellness (LMPHW) investigates and responds to reports of alleged violations related to COVID-19. LMPHW has provided an open dataset of businesses that were observed to not be following the covid requirements as prescribed by the Governor’s Office. The data does not distinguish between the type of enforcement action taken with the exception of the closure of a facility for operating when they were to be closed. The data shows that an order or citation was issued with or without a fine assessed. A minimum of one violation or multiple violations were observed on this day. Violations include but are not limited to failure to wear a face covering, lack of social distancing, failure to properly isolate or quarantine personnel, failure to conduct health checks, and other violations of the Governor’s Orders. Closure orders documented in the data portal where issued by either LMPHW, Shively Police or the Kentucky Labor Cabinet. Detail the Enforcement Process: The Environmental Division receives complaints of non-compliance on local businesses. Complaints are received from several sources including: Metro Call, Louisville Metro Public Health and Wellness’ Environmental call line, Facebook, email, and other sources. Complaints are investigated by inspectors in addition to surveillance of businesses to ensure compliance. Violations observed result in both compliance guidance being given to the business along with an enforcement notice which consists of either a Face Covering Citation and/or a Public Health Notice and Order depending on the type of violation. Citations result in fines being assessed. Violations are to be addressed immediately. Community members can report a complaint via Metro Call by calling 574-5000. For COVID 19 Guidance please visit Louisville Metro’s Covid Resource Center at https://louisvilleky.gov/government/louisville-covid-19-resource-center or calling the Covid Helpline at (502)912-8598. ACTIVITY TYPE ID 12 indicates an Enforcement Action has been taken against the establishment which include Notice to Correct, Citation which include financial penalties and/or Cease Operation. LMPHW Narrative Example: Louisville Metro Public Health and Wellness (LMPHW) investigates and responds to reports of alleged violations related to COVID-19. They also conduct surveillance of businesses to determine compliance. LMPHW has provided an open dataset of businesses that were observed to be following the covid requirements as prescribed by the Governor’s Office. ACTIVITY TYPE ID 4 SURVEY – Surveillance was conducted on the business and no violations were found. ACTIVITY TYPE ID 7 FIELD – A complaint was investigated on the business and no violations were found. ACTIVITY TYPE ID 12 Enforcement Action – Action has been taken against the establishment which could include Notice to Correct, Citation which include financial penalties and/or Cease Operation. ACTIVITY TYPE ID 12 Enforcement Action – Action Code Z – The establishment has been issued an order to cease operation. Data Set Explanation: Activity Type ID 4 Survey has two separate files: COVID_4_Surveillance_Open_Data – Surveillance conducted prior to 1/21/2021 in which were conducted as part of random survey of businesses COVID_4_Compliance_Reviews_Open_Data – Reviews conducted during routine inspections of permitted establishments from 1/21/21 on. Data Dictionary: REQ ID-ID of RequestRequest Date-Date of Requestperson premiseaddress1zipActivity Date-Date Activity OccurredACTIVITY TYPE IDActivity Type Desc-Description of ActivityContact:Gerald Kaforskigerald.kaforski@louisvilleky.gov

This is a list of locations of which the following conditions apply:ACTIVITY TYPE ID 4 SURVEY – Surveillance was conducted on the business and no violations were found. Surveillance conducted prior to 1/21/2021 in which were conducted as part of random survey of businesses. This file is not updated as it has an end date.LMPHW Narrative: Louisville Metro Public Health and Wellness (LMPHW) investigates and responds to reports of alleged violations related to COVID-19. LMPHW has provided an open dataset of businesses that were observed to not be following the covid requirements as prescribed by the Governor’s Office. The data does not distinguish between the type of enforcement action taken with the exception of the closure of a facility for operating when they were to be closed. The data shows that an order or citation was issued with or without a fine assessed. A minimum of one violation or multiple violations were observed on this day. Violations include but are not limited to failure to wear a face covering, lack of social distancing, failure to properly isolate or quarantine personnel, failure to conduct health checks, and other violations of the Governor’s Orders. Closure orders documented in the data portal where issued by either LMPHW, Shively Police or the Kentucky Labor Cabinet. Detail the Enforcement Process: The Environmental Division receives complaints of non-compliance on local businesses. Complaints are received from several sources including: Metro Call, Louisville Metro Public Health and Wellness’ Environmental call line, Facebook, email, and other sources. Complaints are investigated by inspectors in addition to surveillance of businesses to ensure compliance. Violations observed result in both compliance guidance being given to the business along with an enforcement notice which consists of either a Face Covering Citation and/or a Public Health Notice and Order depending on the type of violation. Citations result in fines being assessed. Violations are to be addressed immediately.Community members can report a complaint via Metro Call by calling 574-5000. For COVID 19 Guidance please visit Louisville Metro’s Covid Resource Center at https://louisvilleky.gov/government/louisville-covid-19-resource-center or calling the Covid Helpline at (502)912-8598.ACTIVITY TYPE ID 12 indicates an Enforcement Action has been taken against the establishment which include Notice to Correct, Citation which include financial penalties and/or Cease Operation. LMPHW Narrative Example: Louisville Metro Public Health and Wellness (LMPHW) investigates and responds to reports of alleged violations related to COVID-19. They also conduct surveillance of businesses to determine compliance. LMPHW has provided an open dataset of businesses that were observed to be following the covid requirements as prescribed by the Governor’s Office. ACTIVITY TYPE ID 4 SURVEY – Surveillance was conducted on the business and no violations were found. ACTIVITY TYPE ID 7 FIELD – A complaint was investigated on the business and no violations were found.ACTIVITY TYPE ID 12 Enforcement Action – Action has been taken against the establishment which could include Notice to Correct, Citation which include financial penalties and/or Cease Operation. ACTIVITY TYPE ID 12 Enforcement Action – Action Code Z – The establishment has been issued an order to cease operation.Data Set Explanation:Activity Type ID 4 Survey has two separate files: COVID_4_Surveillance_Open_Data – Surveillance conducted prior to 1/21/2021 in which were conducted as part of random survey of businessesCOVID_4_Compliance_Reviews_Open_Data – Reviews conducted during routine inspections of permitted establishments from 1/21/21 on. Data Dictionary: REQ ID-ID of RequestRequest Date-Date of Requestperson premiseaddress1zipActivity Date-Date Activity OccurredACTIVITY TYPE IDActivity Type Desc-Description of ActivityContact:Gerald Kaforskigerald.kaforski@louisvilleky.gov

This is a list of locations of which the following conditions apply:ACTIVITY TYPE ID 12 Enforcement Action – Action Code Z – The establishment has been issued an order to cease operation.These are infrequent. File will only be renewed if there is a new order.LMPHW Narrative: Louisville Metro Public Health and Wellness (LMPHW) investigates and responds to reports of alleged violations related to COVID-19. LMPHW has provided an open dataset of businesses that were observed to not be following the covid requirements as prescribed by the Governor’s Office. The data does not distinguish between the type of enforcement action taken with the exception of the closure of a facility for operating when they were to be closed. The data shows that an order or citation was issued with or without a fine assessed. A minimum of one violation or multiple violations were observed on this day. Violations include but are not limited to failure to wear a face covering, lack of social distancing, failure to properly isolate or quarantine personnel, failure to conduct health checks, and other violations of the Governor’s Orders. Closure orders documented in the data portal where issued by either LMPHW, Shively Police or the Kentucky Labor Cabinet. Detail the Enforcement Process: The Environmental Division receives complaints of non-compliance on local businesses. Complaints are received from several sources including: Metro Call, Louisville Metro Public Health and Wellness’ Environmental call line, Facebook, email, and other sources. Complaints are investigated by inspectors in addition to surveillance of businesses to ensure compliance. Violations observed result in both compliance guidance being given to the business along with an enforcement notice which consists of either a Face Covering Citation and/or a Public Health Notice and Order depending on the type of violation. Citations result in fines being assessed. Violations are to be addressed immediately.Community members can report a complaint via Metro Call by calling 574-5000. For COVID 19 Guidance please visit Louisville Metro’s Covid Resource Center at https://louisvilleky.gov/government/louisville-covid-19-resource-center or calling the Covid Helpline at (502)912-8598.ACTIVITY TYPE ID 12 indicates an Enforcement Action has been taken against the establishment which include Notice to Correct, Citation which include financial penalties and/or Cease Operation. LMPHW Narrative Example: Louisville Metro Public Health and Wellness (LMPHW) investigates and responds to reports of alleged violations related to COVID-19. They also conduct surveillance of businesses to determine compliance. LMPHW has provided an open dataset of businesses that were observed to be following the covid requirements as prescribed by the Governor’s Office. ACTIVITY TYPE ID 4 SURVEY – Surveillance was conducted on the business and no violations were found. ACTIVITY TYPE ID 7 FIELD – A complaint was investigated on the business and no violations were found.ACTIVITY TYPE ID 12 Enforcement Action – Action has been taken against the establishment which could include Notice to Correct, Citation which include financial penalties and/or Cease Operation. ACTIVITY TYPE ID 12 Enforcement Action – Action Code Z – The establishment has been issued an order to cease operation.Data Set Explanation:Activity Type ID 4 Survey has two separate files: COVID_4_Surveillance_Open_Data – Surveillance conducted prior to 1/21/2021 in which were conducted as part of random survey of businessesCOVID_4_Compliance_Reviews_Open_Data – Reviews conducted during routine inspections of permitted establishments from 1/21/21 on. Data Dictionary: REQ ID-ID of RequestRequest Date-Date of Requestperson premiseaddress1zipActivity Date-Date Activity OccurredACTIVITY TYPE IDActivity Type Desc-Description of ActivityContact:Gerald Kaforskigerald.kaforski@louisvilleky.gov

A list of permitted food service establishments.Data Dictionary:facility_type - Code for facility typefacility_type_description - Code translation for facility typesubtype - Code for facility subtypesubtype_description - Code translation for facility subtypepermit_number - permit numberpremise_name - name of facilitypremise_address - address of facilitypremise_city - city of facilitypremise_state - state of facilitypremise_zip - zip of facilityEHS - Inspector assigned geographical areaopening_date - date facility was permitted by current ownerHealth 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 Kaforskigerald.kaforski@louisvilleky.gov

This is a running list of transactions of issuance of new syringes and receipt of used syringes for the Louisville Metro Department of Public Health and Wellness Syringe Exchange Program. Identifying information has been removed. This set is most useful for tallying issuance and receipt of syringes in a time period at each SEP site _location.Data Dictionary:VisitDate-date of visit for ActivityProper disposal of used needles-True indicates that this education or service was providedIDU risk reduction, safe use and wound care-True indicates that this education or service was providedViral hepatitis and prevention-True indicates that this education or service was providedHIV/AIDS transmission and prevention-True indicates that this education or service was providedSTD counseling and testing-True indicates that this education or service was providedSexual risk reduction and condom use-True indicates that this education or service was providedOverdose prevention and naloxone-True indicates that this education or service was providedMedical insurance options-True indicates that this education or service was providedHuman trafficking risk-True indicates that this education or service was providedLocation-Clinic Location where education and services were providedDrugHxDate-Date Drug use history was takenHeroin-True inicates history of use of this drugOtherOpioid-True indicates use of an opiod not listedOtherOpioid_txt-text that identifies the opioid not listedMethamphetamine-True inicates history of use of this drugCocaine-True inicates history of use of this drugMethadone-True inicates history of use of this drugSuboxone-True inicates history of use of this drugOtherDrug-True inicates history of use of another drug not listed that is not an opiodOtherDrug_txt-text that identifies the other drug that is not an opioidVisitDate-date of visit for syringe exchangeSyringeCollect-number of used syringes collected this visitSyringeProvide-number of new syringes provided this visitSite-clinic _location where syringe exchange performedDrugFreq-daily drug injection frequencyContact:Gerald Kaforskigerald.kaforski@louisvilleky.gov

Louisville Metro Public Health and Wellness has a Testing Taskforce (now combined with the Vaccine Taskforce) pulling together labs and healthcare systems in Jefferson County to coordinate COVID-19 testing efforts and response across the country.Data Dictionary Field Name Field Type Field Description ID Integer Unique identifier Date Date Data the tests were reported. Centers Text Center the tests were conducted. No of Tests Integer No of test as the reported date Address Text address of the testing center Council District Integer council district where the testing center belong to Zip Code Text Zip code of the testing center

This is a running list of transactions of issuance of new syringes and receipt of used syringes for the Louisville Metro Department of Public Health and Wellness Syringe Exchange Program. Identifying information has been removed. This set is most useful for tallying issuance and receipt of syringes in a time period at each SEP site location.Data Dictionary:VisitDate-date of visit for ActivityProper disposal of used needles-True indicates that this education or service was providedIDU risk reduction, safe use and wound care-True indicates that this education or service was providedViral hepatitis and prevention-True indicates that this education or service was providedHIV/AIDS transmission and prevention-True indicates that this education or service was providedSTD counseling and testing-True indicates that this education or service was providedSexual risk reduction and condom use-True indicates that this education or service was providedOverdose prevention and naloxone-True indicates that this education or service was providedMedical insurance options-True indicates that this education or service was providedHuman trafficking risk-True indicates that this education or service was providedLocation-Clinic Location where education and services were providedDrugHxDate-Date Drug use history was takenHeroin-True inicates history of use of this drugOtherOpioid-True indicates use of an opiod not listedOtherOpioid_txt-text that identifies the opioid not listedMethamphetamine-True inicates history of use of this drugCocaine-True inicates history of use of this drugMethadone-True inicates history of use of this drugSuboxone-True inicates history of use of this drugOtherDrug-True inicates history of use of another drug not listed that is not an opiodOtherDrug_txt-text that identifies the other drug that is not an opioidVisitDate-date of visit for syringe exchangeSyringeCollect-number of used syringes collected this visitSyringeProvide-number of new syringes provided this visitSite-clinic location where syringe exchange performedDrugFreq-daily drug injection frequency 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 Kaforskigerald.kaforski@louisvilleky.gov

The data spans from December 2020 through October 2022, and is no longer being updated as of October 10, 2022.The Louisville Metro Department of Public Health and Wellness (LMPHW) is an independent, academic health department under the leadership of Connie Mendel. The department is organized under four divisions: Administration; Environmental; Health Services and the Center for Health Equity. The Administration division includes human resources, information technology, budget and logistics.Data Dictionary

Field Name

Description

WEEKENDINGDATE

The end date of the 7-day reporting period (typically a Friday)

DOSE_

Number of individuals who received their first dose of a COVID-19 vaccine during the week

DOSE_

Number of individuals who received their second dose (completing a 2-dose series) during the week.

BOOSTER

Number of individuals who received a booster dose during the week.

LOADED

The timestamp indicating when the data was loaded into the system.

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-poolsData 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-DefinitionInspectionID-Unique Identifier for the inspectionFacility ID-Unique Identifier for the FacilityFacility Name-Name of the FacilityFacility Address-Location of the FacilityFacility Address 2-Location of the FacilityFacility City-Location of the FacilityFacility State-Location of the FacilityFacility Postal Code-Location of the FacilityFacility County-Location of the FacilityVenue 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 definedInspection Date-Date the inspection was performedInspection 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 CHLORINEFree 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 repairPOOLS 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 KaforskiLMPHWDataTeam@Louisvilleky.gov