Louisville Metro KY - Environmental Health Bulk Data - Establishments by US Government | Healthcare

About this Dataset

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
Organization: Louisville Metro Government
Last updated: 2023-04-13T13:32:12.506387
Tags: environmental-health, establishment, health, inspections, jefferson-county, kentucky, louisville, louisville-metro, louisville-metro-ky, metro-health, public-health, public-health-and-wellness, sanitation

Tables

Table 1

@usgov.louisville_metro_government_louisville_metro_ky_enviro_c08a7a29.table_1

746.71 KB
8118 rows
53 columns


CREATE TABLE table_1 (
  "establishmentid" BIGINT,
  "countyid" BIGINT,
  "rcode" BIGINT,
  "rcodedesc" VARCHAR,
  "esttype" VARCHAR,
  "premisename" VARCHAR,
  "permisestreetno" VARCHAR,
  "premisestreet" VARCHAR,
  "premiseextraaddrline" VARCHAR,
  "premisecity" VARCHAR,
  "premisestate" VARCHAR,
  "premisezip" VARCHAR,
  "inspectionintervaldays" BIGINT,
  "ispayfee" VARCHAR,
  "isstateowned" VARCHAR,
  "status" VARCHAR,
  "waterprovider" VARCHAR,
  "sewageprovider" VARCHAR,
  "isbonded" VARCHAR,
  "renewalstatus" VARCHAR,
  "permitprinted" VARCHAR,
  "language" VARCHAR,
  "risktype" VARCHAR,
  "menutype" VARCHAR,
  "iscaterer" VARCHAR,
  "isdrivethru" VARCHAR,
  "istrucksonly" VARCHAR,
  "area" VARCHAR,
  "mailappiddesc" VARCHAR,
  "mailpermitiddesc" VARCHAR,
  "hoursofoperation" VARCHAR,
  "daysofoperation" VARCHAR,
  "monthsofoperation" VARCHAR,
  "opening_date" TIMESTAMP,
  "renewal_sent_date" TIMESTAMP,
  "renewal_received_date" TIMESTAMP,
  "permit_print_date" TIMESTAMP,
  "permit_expiration_date" TIMESTAMP,
  "next_inspection_date" TIMESTAMP,
  "bond_expiration_date" TIMESTAMP,
  "quantity1" BIGINT,
  "quantity1unit" VARCHAR,
  "quantity2" BIGINT,
  "quantity2units" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "comments" VARCHAR,
  "totalfeeamt" DOUBLE,
  "permitfeeamt" DOUBLE,
  "inspectionfeeamt" DOUBLE,
  "variancegranted" VARCHAR,
  "followupdate" VARCHAR,
  "objectid" BIGINT
);