About this Dataset

Louisville Metro KY - Permitted Food Service Establishments

A list of permitted establishments.
Data Dictionary:
facility_type - Code for facility type
facility_type_description - Code translation for facility type
subtype - Code for facility subtype
subtype_description - Code translation for facility subtype
permit_number - permit number
premise_name - name of facility
premise_address - address of facility
premise_city - city of facility
premise_state - state of facility
premise_zip - zip of facility
EHS - Inspector assigned geographical area
opening_date - date facility was permitted by current owner

Contact:

Gerald Kaforski

gerald.kaforski@louisvilleky.gov
Organization: Louisville Metro Government
Last updated: 2023-04-13T13:31:47.696813
Tags: environmental-health, establishment, food-service, health, jefferson-county, kentucky, louisville, louisville-metro, louisville-metro-ky, metro-health, permitted, public-health-and-wellness

Tables

Table 1

@usgov.louisville_metro_government_louisville_metro_ky_permit_51d588ea.table_1

161.53 kB
3,375 rows
13 columns

CREATE TABLE table_1 (
  "facility_type" BIGINT,
  "facility_type_description" VARCHAR,
  "subtype" BIGINT,
  "subtype_description" VARCHAR,
  "permit_number" BIGINT,
  "premise_name" VARCHAR,
  "premise_address" VARCHAR,
  "premise_city" VARCHAR,
  "premise_state" VARCHAR,
  "premise_zip" BIGINT,
  "ehs" VARCHAR,
  "opening_date" TIMESTAMP,
  "objectid" BIGINT
);