Louisville Metro KY - Environmental Health Bulk Data - Inspection Violations
收藏资源简介：
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
本数据集为路易斯维尔都会区公共健康与福祉部门（Louisville Metro Department of Public Health and Wellness）开展检查过程中记录的违规情况说明。其中Inspection_id列与Inspections表中的InspectionID列一一对应。Inspections表中的每一项检查均可关联0条或多条检查违规记录。 数据字典如下： 1. Inspection_id：检查的系统唯一标识编号 2. InspTypeSpecificViolID：对应特定检查类型的违规编号 3. ViolationDesc：违规情况详细描述 4. weight：该违规对应的扣减分值 5. critical_yn：是否为严重违规项，若是则本次检查判定为不合格 6. comments：备注信息 7. rpt_area_id：设施类型代码 8. delete_mark_id：系统删除标记编号 9. violation system id：违规项系统编号 联系方式：杰拉尔德·卡福尔斯基（Gerald Kaforski），电子邮箱：gerald.kaforski@louisvilleky.gov
