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

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

A list of permitted swimming areas. 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 Inspection_Area - Inspector assigned geographical area opening_date - date facility was permitted by current owner,

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

This is a list of locations of which the following conditions apply: ACTIVITY TYPE ID 4 SURVEY – Surveillance was conducted on the business and no violations were found. Reviews conducted during routine inspections of permitted establishments from 1/21/21 on.,

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,

The Office of Construction Review is responsible for oversight of new construction in Louisville Metro through a review process that includes review of construction plans and issuance of permits and inspections. This process is in place to ensure the safety of citizens and compliance with the Kentucky Building Code and associated codes and ordinances.