About this Dataset

Louisville Metro KY - Inspection Results School Food Service

A list of permitted school food service establishments and their last three inspection results.
**
**

Data Dictionary:
ScoreRecent - Most recent inspection score
GradeRecent - Most recent inspection grade
DateRecent - Most recent inspection date
Score2 - 2nd most recent inspection score
Grade2 - 2nd most recent inspection grade
Date2 - 2nd most recent inspection date
Score3 - 3rd most recent inspection score
Grade3 - 3rd most recent inspection grade
Date3 - 3rd most recent inspection date
permit_number - facility permit number
facility_type - facility type code
facility_type_description - text description of facility type
subtype - facility subtype code
subtype_description - text description of facility subtype
premise_name - facility name
premise_address - facility address
premise_city - facility city
premise_state - facility state
premise_zip - facility zip code
opening_date - date current owner was first permitted

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.

Contact:

Gerald Kaforski

gerald.kaforski@louisvilleky.gov
Organization: Louisville Metro Government
Last updated: 2025-07-30T13:23:03.967397
Tags: environmental-health, food, food-service, 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_inspec_5ca7621a.table_1

27.73 kB
204 rows
21 columns

CREATE TABLE table_1 (
  "scorerecent" BIGINT,
  "graderecent" VARCHAR,
  "daterecent" VARCHAR,
  "score2" BIGINT,
  "grade2" VARCHAR,
  "date2" TIMESTAMP,
  "score3" BIGINT,
  "grade3" VARCHAR,
  "date3" TIMESTAMP,
  "permit_number" BIGINT,
  "facility_type" BIGINT,
  "facility_type_description" VARCHAR,
  "subtype" BIGINT,
  "subtype_description" VARCHAR,
  "premise_name" VARCHAR,
  "premise_address" VARCHAR,
  "premise_city" VARCHAR,
  "premise_state" VARCHAR,
  "premise_zip" BIGINT,
  "opening_date" VARCHAR,
  "objectid" BIGINT
);