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

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