{{description}}

A list of permitted food service establishments with their last three inspection results. Here is a visual search engine. You can make it full screen by clicking on the button on the lower right of the graphic.,

A list of permitted Public Facilities establishments (non food) with their last three inspection results. Data Dictionary: Facilty_Number - permit number Facility_Name - facility name Address - facility address Zip - facility zip code Area_Number - Geographic area number Program_Code - Establishment Type Code Establishment_Type - Establishment Type Text Status - Indicates whether facility is active or inactive in system Score_Recent - Most recent inspection score DateRecent - Most recent inspection date Score2 - 2nd most recent inspection score Date2 - 2nd most recent inspection date Score3 - 3rd most recent inspection score Date3 - 3rd most recent inspection date,

{{description}}

{{description}}

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,

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?,

A list of the violations recorded against permitted restaurants that failed inspection. Data Dictionary: EstablishmentID - Permit Number InspectionDate - date of inspection InspectionID - system inspection id EstTypeDesc - desciption of facility type premise_name - facility name premise_adr1_num - facility street number premise_adr1_street - facility street premise_city - facility city premise_state - facility state premise_zip - facility zip code InspectionType - description of inspection type score - inspection score InspTypeSpecificViolID - Violation ID for specific type of facility ViolationDesc - text description of violation critical_yn - Is the violation critical? Insp_Viol_Comments - violation comments rpt_area_id - Establishment Type Code,

,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,

{{description}}