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

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

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

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

{{description}}

,Attributes of Public Health related complaints reported by the public and investigated by Louisville Metro Department of Public Health and Wellness. Personal/identifying data has been removed. EstID 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: RequestComplaintID-System ID Rcode-Code for Type of Complaint or Request RCodeDescription-Text of type of complaint or request EHS-the license number of the technician investigating section-complaint section TakenBy-who took the complaint or service request Method-how the complaint or service request was taken in Duplicate-is this a duplicate request? System notation EstID-Associated permitted facility if applicable oss_id-associated onsite sewage file if applicable RequestDate-date of request or complaint ResolvedDate-date request or complaint was resolved NextInspDate-scheduled next inspection date IsCityorCounty-is this a city or county request? Status-is the request open or resolved? RequestType-request type IsFollowUp-is this a folowo up entry to an already open request OwnerType- Owner or agent? If applicable PersonOrPremiseZip-zip code of subject person ComplaintantZip-zip code of person making the complaint OwnerZip-zip code of the owner of the premises if applicable,,Contact:,Gerald Kaforski,gerald.kaforski@louisvilleky.gov,

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,

{{description}}