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 id bite_date-reported date of animal bite SpeciesIDDesc-animal species BreedIDDesc-animal breed breed-secondat breed field for manual entry GenderIDDesc-animal gender color-animal color vaccination_yrs-how long vaccination is effective for vaccination_date-date of last rabies vaccination victim_zip-zip code of victim AdvIssuedYNDesc-was an advisory ordered? WhereBittenIDDesc-Where was bite body or head? quarantine_date-quarrantine date if applicable DispositionIDDesc-disposition of animal if known head_sent_date-date head sent for testing if applicable release_date-date of release from quarrantine if known ResultsIDDesc-results of testing if applicable FollowupYNDesc-is this a followup entry?,

{{description}}

{{description}}

{{description}}

{{description}}

{{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 Data Dictionary: InspectionID-system id EstablishmentID-permit number RequestID-associated request or complaint id if applicable EHSNumber-id number of inspector CountyID-system id InspectionDate-date of inspection InspectionType-type of inspection IsFollowUpInsp-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 used GradeID-letter grade for inspection if applicable score-inspection score InspTimeHours InspTimeMins sample_attendance-not used SampleAttendance-not used NextInspDate ACTION_CODE_DESC-sytem code of action taken text IsComplaintResolved-if complaint related is the complaint resolved?,

{{description}}

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,

{{description}}