{{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}}

{{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?,

Attributes of establishments that are currently inspected by and/or regulated by Louisville Metro Government. Personal/identifying data has been removed. EstablishmentID column can be joined to the EstablishmentID column in the Inspections table to show attributes of any inspections of the establishment. Data Dictionary: EstablishmentID-Permit number CountyID-System ID for Jefferson County = 255 Rcode-facility type code RCodeDesc-facility type text desciption EstType-sub facility type PremiseName-Facility Name PermiseStreetNo-Facility street number PremiseStreet-facility street PremiseExtraAddrLine PremiseCity-facility city PremiseState-facility state PremiseZip-facility zip code InspectionIntervalDays-how often does facility have a routine inspection? IsPayFee-Does the facility pay a permit fee? Some government establishments like pools do not. IsStateOwned-is the facility state owned? Status-does the facility have an acive permit? WaterProvider-water provider type SewageProvider-sewage provider type IsBonded- is the facility bonded? RenewalStatus-system indicator PermitPrinted-system indicator Language-What language is spoken in facility? RiskType-usually used to designate whether a facility is high risk like a day care center or one that serves seniors. MenuType-Menu type if available IsCaterer-is the facility a catering business? IsDriveThru-Does the facility have a drive through? IsTrucksOnly-is the business trucks only, no storefront. Area-geographic area of inspectors MailAppIDDesc-system indicator MailPermitIDDesc-system indicator HoursOfOperation-used by inspectors to denote special hours DaysOfOperation-used by inspector to denote special days of operation MonthsOfOperation-used by inspector to denote special months of operation opening_date-date facility was permitted to current owner renewal_sent_date-renewal system indicator renewal_received_date-system indicator permit_print_date-system indicator permit_expiration_date-permit expiration date next_inspection_date-next scheduled inspection date bond_expiration_date-iff bonded bond expiration date. Quantity1-number of units in unit field # 1 Quantity1Unit-units counted Quantity2-number of units in unit field # 2 Quantity2Units-units counted latitude-geo latitude of facility-this may be innacurate longitude-geo longitute of facility-this may be innacurate comments TotalFeeAmt-total fee paid be facility PermitFeeAmt-permit portion of fee amount InspectionFeeAmt-inspection fee portion of fee amount VarianceGranted-not used FollowUpDate-next followup inspection date,

{{description}}

{{description}}