About this Dataset

Louisville Metro KY - Restaurant Inspection Scores

Restaurant inspection dates, grades, scores and locations for the past year for all establishments.

Data Dictionary:

EstablishmentID -permit number
InspectionID -System ID
EstablishmentName -Name of facility
PlaceName -blank
Address -Address
Address2 -Address second line
City -facility city
State -facility state
Zip -facility zip
TypeDescription -facility type
Latitude -geo latititude-may be inaccurate
Longitude -go longitute-may be inaccurate
InspectionDate -Date of inspection
Score -inspection score
Grade -inspection grade
NameSearch -facility name
Intersection -blank

Contact:

Gerald Kaforski

gerald.kaforski@louisvilleky.gov
Organization: Louisville Metro Government
Last updated: 2023-04-13T13:35:12.725036
Tags: cleanliness, food, health, inspection-scores, inspections, louisville, louisville-metro, louisville-metro-ky, metro-health, public-health, public-health-and-wellness, restaurant, sanitation, scores

Tables

Table 1

@usgov.louisville_metro_government_louisville_metro_ky_restau_e964feed.table_1

447.18 kB
11,274 rows
17 columns

CREATE TABLE table_1 (
  "establishmentid" BIGINT,
  "inspectionid" BIGINT,
  "ins_typedesc" VARCHAR,
  "establishmentname" VARCHAR,
  "placename" VARCHAR,
  "address" VARCHAR,
  "address2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "typedescription" VARCHAR,
  "inspectiondate" TIMESTAMP,
  "score" BIGINT,
  "grade" VARCHAR,
  "namesearch" VARCHAR,
  "intersection" VARCHAR,
  "objectid" BIGINT
);