About this Dataset

Louisville Metro KY - Property Maintenance Case Inspections Through June 2019

Codes and Regulations issues and inspects Development Permits (building, electrical, HVAC), enforces Property Maintenance Code (housing) and Land Development Code (zoning), issues ABC, taxi cab, vendor and other licenses and administers the Code Enforcement Board.
Organization: Louisville Metro Government
Last updated: 2023-04-13T13:37:49.887213
Tags: case-inspections, codes-and-regs, codes-and-regulations, historical, inspections, jefferson-county, kentucky, louisville, louisville-metro, louisville-metro-ky, maintenance, property-maintenance

Tables

Table 1

@usgov.louisville_metro_government_louisville_metro_ky_proper_a8f81ee5.table_1

20.27 MB
299,368 rows
19 columns

CREATE TABLE table_1 (
  "id" BIGINT,
  "casenumber" VARCHAR,
  "casestatus" VARCHAR,
  "fullstreetaddress" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "gpsx" BIGINT,
  "gpsy" BIGINT,
  "inspectionnumber" BIGINT,
  "inspectiondate" VARCHAR,
  "inspectionresult" VARCHAR,
  "occupancystatus" VARCHAR,
  "district" DOUBLE,
  "neighborhood" VARCHAR,
  "zoning" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "objectid" BIGINT
);