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,

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,

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

Lists the various types and sub-types of food service establishments.,

{{description}}

A list of permitted Pools with the last three inspection results. Data Dictionary: ScoreRecent - 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 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 faacility 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 of permit of current owner,

,Listing of geocoded businesses, inspections for those businesses, and health violations for those businesses, used as a feed to Yelp. All files are csv files.,Data Dictionary Type,Contact:,Gerald Kaforski,gerald.kaforski@louisvilleky.gov,

{{description}}