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 numberCountyID-System ID for Jefferson County = 255Rcode-facility type codeRCodeDesc-facility type text desciptionEstType-sub facility typePremiseName-Facility NamePermiseStreetNo-Facility street numberPremiseStreet-facility streetPremiseExtraAddrLinePremiseCity-facility cityPremiseState-facility statePremiseZip-facility zip codeInspectionIntervalDays-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 typeSewageProvider-sewage provider typeIsBonded- is the facility bonded?RenewalStatus-system indicatorPermitPrinted-system indicatorLanguage-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 availableIsCaterer-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 inspectorsMailAppIDDesc-system indicatorMailPermitIDDesc-system indicatorHoursOfOperation-used by inspectors to denote special hoursDaysOfOperation-used by inspector to denote special days of operationMonthsOfOperation-used by inspector to denote special months of operationopening_date-date facility was permitted to current ownerrenewal_sent_date-renewal system indicatorrenewal_received_date-system indicatorpermit_print_date-system indicatorpermit_expiration_date-permit expiration datenext_inspection_date-next scheduled inspection datebond_expiration_date-iff bonded bond expiration date.Quantity1-number of units in unit field # 1Quantity1Unit-units countedQuantity2-number of units in unit field # 2Quantity2Units-units countedlatitude-geo latitude of facility-this may be innacuratelongitude-geo longitute of facility-this may be innacuratecommentsTotalFeeAmt-total fee paid be facilityPermitFeeAmt-permit portion of fee amountInspectionFeeAmt-inspection fee portion of fee amountVarianceGranted-not usedFollowUpDate-next followup inspection dateContact:Gerald Kaforskigerald.kaforski@louisvilleky.gov
Complete Metadata
| @type | dcat:Dataset |
|---|---|
| accessLevel | public |
| bureauCode |
[
"010:04",
"010:86"
]
|
| contactPoint |
{
"fn": "LouisvilleMetro",
"@type": "vcard:Contact",
"hasEmail": "mailto:opendata@louisvilleky.gov"
}
|
| culture | en-us |
| description | <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> |
| distribution |
[
{
"@type": "dcat:Distribution",
"title": "CSV",
"format": "CSV",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/d64d4748d7074e3a88ec8d55ef797edc/csv?layers=0",
"mediaType": "text/csv"
},
{
"@type": "dcat:Distribution",
"title": "Excel",
"format": "XLSX",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/d64d4748d7074e3a88ec8d55ef797edc/excel?layers=0",
"mediaType": "application/vnd.ms-excel"
},
{
"@type": "dcat:Distribution",
"title": "Feature Collection",
"format": "TXT",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/d64d4748d7074e3a88ec8d55ef797edc/featureCollection?layers=0",
"mediaType": "text/plain"
},
{
"@type": "dcat:Distribution",
"title": "File Geodatabase",
"format": "ZIP",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/d64d4748d7074e3a88ec8d55ef797edc/filegdb?layers=0",
"mediaType": "application/zip"
},
{
"@type": "dcat:Distribution",
"title": "GeoPackage",
"format": "GPKG",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/d64d4748d7074e3a88ec8d55ef797edc/geoPackage?layers=0",
"mediaType": "application/geopackage+sqlite3"
},
{
"@type": "dcat:Distribution",
"title": "GeoJSON",
"format": "GeoJSON",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/d64d4748d7074e3a88ec8d55ef797edc/geojson?layers=0",
"mediaType": "application/vnd.geo+json"
},
{
"@type": "dcat:Distribution",
"title": "KML",
"format": "KML",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/d64d4748d7074e3a88ec8d55ef797edc/kml?layers=0",
"mediaType": "application/vnd.google-earth.kml+xml"
},
{
"@type": "dcat:Distribution",
"title": "Shapefile",
"format": "ZIP",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/d64d4748d7074e3a88ec8d55ef797edc/shapefile?layers=0",
"mediaType": "application/zip"
},
{
"@type": "dcat:Distribution",
"title": "SQLite Geodatabase",
"format": "GDB",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/d64d4748d7074e3a88ec8d55ef797edc/sqlite?layers=0",
"mediaType": "application/geopackage+sqlite3"
},
{
"@type": "dcat:Distribution",
"title": "ArcGIS Hub Dataset",
"format": "Web Page",
"accessURL": "https://louisville-metro-opendata-lojic.hub.arcgis.com/datasets/LOJIC::louisville-metro-ky-environmental-health-bulk-data-establishments",
"mediaType": "text/html"
},
{
"@type": "dcat:Distribution",
"title": "ArcGIS GeoService",
"format": "ArcGIS GeoServices REST API",
"accessURL": "https://services1.arcgis.com/79kfd2K6fskCAkyg/arcgis/rest/services/Louisville_Metro_KY_Environmental_Health_Bulk_Data_Establishments/FeatureServer/0",
"mediaType": "application/json"
}
]
|
| identifier | https://www.arcgis.com/home/item.html?id=d64d4748d7074e3a88ec8d55ef797edc&sublayer=0 |
| issued | 2022-05-20T12:05:32.000Z |
| keyword |
[
"Environmental Health",
"Establishment",
"Health",
"Inspections",
"Jefferson County",
"Kentucky",
"Louisville",
"Louisville Metro",
"Louisville Metro KY",
"Metro Health",
"Public Health and Wellness",
"Sanitation",
"public health"
]
|
| landingPage | https://louisville-metro-opendata-lojic.hub.arcgis.com/datasets/LOJIC::louisville-metro-ky-environmental-health-bulk-data-establishments |
| license | https://louisville-metro-opendata-lojic.hub.arcgis.com/pages/terms-of-use-and-license |
| modified | 2026-01-29T13:39:34.272Z |
| platform | ArcGIS Hub |
| programCode |
[
"015:001",
"015:002"
]
|
| publisher |
{
"name": "Louisville/Jefferson County Information Consortium"
}
|
| spatial | {{extent:computeSpatialProperty}} |
| summary | Health and Wellness Protects and promotes the health, environment and well being of the people of Louisville, providing health-related programs and health office locations community wide. |
| theme |
[
"geospatial"
]
|
| title | Louisville Metro KY - Environmental Health Bulk Data - Establishments |
