Louisville Metro KY - Environmental Health Bulk Data - Establishments

Description

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

Resources

Name Format Description Link
21 https://louisville-metro-opendata-lojic.hub.arcgis.com/maps/LOJIC::louisville-metro-ky-environmental-health-bulk-data-establishments
15 https://louisville-metro-opendata-lojic.hub.arcgis.com/datasets/LOJIC::louisville-metro-ky-environmental-health-bulk-data-establishments.geojson
3 https://services1.arcgis.com/79kfd2K6fskCAkyg/arcgis/rest/services/Louisville_Metro_KY_Environmental_Health_Bulk_Data_Establishments/FeatureServer/0
8 LOJIC::louisville-metro-ky-environmental-health-bulk-data-establishments.csv https://louisville-metro-opendata-lojic.hub.arcgis.com/datasets/LOJIC::louisville-metro-ky-environmental-health-bulk-data-establishments.csv
21 https://louisville-metro-opendata-lojic.hub.arcgis.com/datasets/LOJIC::louisville-metro-ky-environmental-health-bulk-data-establishments
8 https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/d64d4748d7074e3a88ec8d55ef797edc/csv?layers=0
57 https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/d64d4748d7074e3a88ec8d55ef797edc/shapefile?layers=0
25 https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/d64d4748d7074e3a88ec8d55ef797edc/kml?layers=0
57 https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/d64d4748d7074e3a88ec8d55ef797edc/filegdb?layers=0
47 https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/d64d4748d7074e3a88ec8d55ef797edc/featureCollection?layers=0
53 https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/d64d4748d7074e3a88ec8d55ef797edc/excel?layers=0
0 https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/d64d4748d7074e3a88ec8d55ef797edc/geoPackage?layers=0
15 https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/d64d4748d7074e3a88ec8d55ef797edc/geojson?layers=0
0 https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/d64d4748d7074e3a88ec8d55ef797edc/sqlite?layers=0

Tags

  • jefferson-county
  • kentucky
  • metro-health
  • inspections
  • louisville
  • public-health
  • sanitation
  • public-health-and-wellness
  • health
  • louisville-metro-ky
  • louisville-metro
  • establishment
  • environmental-health

Topics

  • Local Government

Categories