Louisville Metro KY - Environmental Health Bulk Data - Establishments

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

Contact:

Gerald Kaforski

gerald.kaforski@louisvilleky.gov