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

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

{{description}}

{{description}}

Descriptions of violations recorded during inspections by Louisville Metro Department of Public Health and Wellness. The Inspection_id column corresponds to the InspectionID column in the Inspections table. There are 0 to many inspection violations associated with each inspection in the Inspections table. Data Dictionary: inspection_id-system id of inspection InspTypeSpecificViolID-violatio number for type of inspection ViolationDesc-description of the violation weight-points taken off for violation critical_yn-is this a critical violation? If so means inspection failure comments rpt_area_id-facility type code delete_mark_id-system indicator id-violation system id,

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,

A reference list of types and sub-types of establishments,

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,