Louisville Metro KY - Environmental Health Bulk Data - Inspections

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?

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-inspections
3 https://services1.arcgis.com/79kfd2K6fskCAkyg/arcgis/rest/services/Louisville_Metro_KY_Environmental_Health_Bulk_Data_Inspections/FeatureServer/0
8 LOJIC::louisville-metro-ky-environmental-health-bulk-data-inspections.csv https://louisville-metro-opendata-lojic.hub.arcgis.com/datasets/LOJIC::louisville-metro-ky-environmental-health-bulk-data-inspections.csv
15 https://louisville-metro-opendata-lojic.hub.arcgis.com/datasets/LOJIC::louisville-metro-ky-environmental-health-bulk-data-inspections.geojson
21 https://louisville-metro-opendata-lojic.hub.arcgis.com/datasets/LOJIC::louisville-metro-ky-environmental-health-bulk-data-inspections
8 https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/6b7d648876784f4db1392ed6b6a9bfc4/csv?layers=0
57 https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/6b7d648876784f4db1392ed6b6a9bfc4/shapefile?layers=0
15 https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/6b7d648876784f4db1392ed6b6a9bfc4/geojson?layers=0
25 https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/6b7d648876784f4db1392ed6b6a9bfc4/kml?layers=0
57 https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/6b7d648876784f4db1392ed6b6a9bfc4/filegdb?layers=0
47 https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/6b7d648876784f4db1392ed6b6a9bfc4/featureCollection?layers=0
53 https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/6b7d648876784f4db1392ed6b6a9bfc4/excel?layers=0
0 https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/6b7d648876784f4db1392ed6b6a9bfc4/geoPackage?layers=0
0 https://louisville-metro-opendata-lojic.hub.arcgis.com/api/download/v1/items/6b7d648876784f4db1392ed6b6a9bfc4/sqlite?layers=0

Tags

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

Topics

  • Local Government

Categories