Louisville Metro KY - Environmental Health Bulk Data - Establishments

<span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>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.</span><br /><strong>Data Dictionary:</strong><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>EstablishmentID-Permit number</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>CountyID-System ID for Jefferson County = 255</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>Rcode-facility type code</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>RCodeDesc-facility type text desciption</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>EstType-sub facility type</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>PremiseName-Facility Name</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>PermiseStreetNo-Facility street number</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>PremiseStreet-facility street</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>PremiseExtraAddrLine</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>PremiseCity-facility city</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>PremiseState-facility state</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>PremiseZip-facility zip code</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>InspectionIntervalDays-how often does facility have a routine inspection?</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>IsPayFee-Does the facility pay a permit fee? Some government establishments like pools do not.</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>IsStateOwned-is the facility state owned?</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>Status-does the facility have an acive permit?</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>WaterProvider-water provider type</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>SewageProvider-sewage provider type</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>IsBonded- is the facility bonded?</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>RenewalStatus-system indicator</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>PermitPrinted-system indicator</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>Language-What language is spoken in facility?</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>RiskType-usually used to designate whether a facility is high risk like a day care center or one that serves seniors.</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>MenuType-Menu type if available</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>IsCaterer-is the facility a catering business?</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>IsDriveThru-Does the facility have a drive through?</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>IsTrucksOnly-is the business trucks only, no storefront.</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>Area-geographic area of inspectors</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>MailAppIDDesc-system indicator</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>MailPermitIDDesc-system indicator</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>HoursOfOperation-used by inspectors to denote special hours</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>DaysOfOperation-used by inspector to denote special days of operation</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>MonthsOfOperation-used by inspector to denote special months of operation</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>opening_date-date facility was permitted to current owner</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>renewal_sent_date-renewal system indicator</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>renewal_received_date-system indicator</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>permit_print_date-system indicator</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>permit_expiration_date-permit expiration date</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>next_inspection_date-next scheduled inspection date</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>bond_expiration_date-iff bonded bond expiration date.</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>Quantity1-number of units in unit field # 1</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>Quantity1Unit-units counted</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>Quantity2-number of units in unit field # 2</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>Quantity2Units-units counted</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>latitude-geo latitude of facility-this may be innacurate</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>longitude-geo longitute of facility-this may be innacurate</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>comments</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>TotalFeeAmt-total fee paid be facility</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>PermitFeeAmt-permit portion of fee amount</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>InspectionFeeAmt-inspection fee portion of fee amount</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>VarianceGranted-not used</span><br /><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'>FollowUpDate-next followup inspection date</span><div><span style='color:rgb(77, 77, 77); font-family:Lato; font-size:16px;'><br /></span></div><div><p style='margin-top:0px; margin-bottom:1.25em; font-size:16px; box-sizing:border-box; font-family:Lato;'><font color='#000080' style='font-family:inherit;'>Contact:</font></p><p style='margin-top:0px; margin-bottom:1.25em; font-size:16px; box-sizing:border-box; font-family:Lato;'><font color='#000080' style='font-family:inherit;'>Gerald Kaforski</font></p><p style='margin-top:0px; margin-bottom:1.25em; font-size:16px; box-sizing:border-box; font-family:Lato;'><a href='mailto:gerald.kaforski@louisvilleky.gov' style='color:rgb(0, 121, 193); text-decoration-line:none; font-family:inherit; box-sizing:border-box;' rel='nofollow ugc'><font color='#000080' style='font-family:inherit;'>gerald.kaforski@louisvilleky.gov</font></a></p></div>

Tags: environmental-health, establishment, health, inspections, jefferson-county, kentucky, louisville, louisville-metro, louisville-metro-ky, metro-health, public-health, public-health-and-wellness, sanitation
Organization: Louisville Metro Government