Louisville Metro KY - Environmental Health Bulk Data - Complaints

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 [e-mail]本数据集涵盖由公众举报、路易斯维尔都会区公共卫生与健康局（Louisville Metro Department of Public Health and Wellness）调查的公共卫生相关投诉的属性信息。已完成个人身份识别数据脱敏处理。当涉及受监管机构时，可通过EstID列与机构表（Establishments table）中的EstablishmentID列进行关联，以展示对应机构的属性信息。 数据字典： RequestComplaintID：投诉/请求系统编号（RequestComplaintID） Rcode：投诉或请求类型代码（Rcode） RCodeDescription：投诉或请求类型文本说明（RCodeDescription） EHS：负责调查的技术人员执照编号（EHS） section：投诉涉及的业务科室（section） TakenBy：接收投诉或服务请求的经办人（TakenBy） Method：投诉或服务请求的受理渠道（Method） Duplicate：是否为重复请求（系统标注）（Duplicate） EstID：关联获批机构（如适用）（EstID） oss_id：关联现场污水档案（如适用）（oss_id） RequestDate：请求或投诉提交日期（RequestDate） ResolvedDate：请求或投诉办结日期（ResolvedDate） NextInspDate：预定下次检查日期（NextInspDate） IsCityorCounty：是否为市/县级发起的请求（IsCityorCounty） Status：请求状态（开放/已办结）（Status） RequestType：请求类型（RequestType） IsFollowUp：是否为针对已在办请求的跟进条目（IsFollowUp） OwnerType：主体类型（所有者或代理人，如适用）（OwnerType） PersonOrPremiseZip：涉事人员或场所的邮政编码（PersonOrPremiseZip） ComplaintantZip：投诉人邮政编码（ComplaintantZip） OwnerZip：场所所有者的邮政编码（如适用）（OwnerZip） 本机构致力于保护并促进路易斯维尔地区民众的健康、环境与福祉，在全市范围内提供健康相关项目与健康办公网点。联系方式：杰拉尔德·卡福尔斯基（Gerald Kaforski），电子邮箱：[e-mail]