Louisville Metro KY - Property Maintenance Inspection Violations
Louisville Metro Government
@usgov.louisville_metro_government_louisville_metro_ky_proper_b0cc0a16
Loading...
Loading...
Loading...
Loading...
About this Dataset
Louisville Metro KY - Property Maintenance Inspection Violations
Codes and Regulations inspects and enforces Property Maintenance Code (housing) , Land Development Code (zoning), and administers the Code Enforcement Board. The following data provides a list of property maintenance violations over the last 30 days.
Data Dictionary
| Field Name | Field Description |
|---|---|
| SERV_PROV_CODE | Field that is used for linking the data with Accela and identifies the agency |
| B1_PER_ID1 | Identifies the specific record for joining the data in Accela |
| B1_PER_ID2 | |
| B1_PER_ID3 | |
| B1_SPECIAL_TEXT | Identifies the inspection visit number |
| B1_ALT_ID | Record ID |
| FullAdress | Location of the site visit including city, state and zip |
| PartialAddress | Location of the site visit excluding the city, state and zip |
| Longitude | Point location of the site visit |
| Latitude | |
| EXT_ADDRESS_UID | Identifier for joining the address to LOJIC address data |
| PARCEL_ID | Parcel Identifier |
| CouncilDist | Council District |
| G6A_G6_COMPL_T1 | Identifies whether the inspection was completed AM or PM |
| G6A_G6_COMPL_T2 | Identifies the time of the inspection on a 12 hour clock |
| G6A_G6_COMPL_DD | Is the date/time of the inspection |
| G6A_G6_STATUS | Inspection result of the site visit |
| G6A_G6_STATUS_DD | The Date when the inspection result was issued |
| GA_USERID | Unique identifier of the inspector |
| GAFML | Full Name of the inspector |
| OccupancyStatus | Occupancy Status of the property observed by the inspector at the time of the inspection |
| GUIDE_ITEM_TEXT | Description of the violation |
| VIOLATION_CODE | Violation Code |
| GUIDE_ITEM_STATUS | Individual violation status |
| CitationAmount | The fine levied against the property owner for violations on that inspection |
| ColumnCounts | Sequential Number of violations on a site visit |
| Organization: Louisville Metro Government | |
| Last updated: 2025-07-30T14:10:20.739844 | |
| Tags: codes-and-regs, codes-and-regulations, inspection-violations, inspections, jefferson-county, kentucky, louisville, louisville-metro, louisville-metro-ky, maintenance, property-maintenance, recent_odp, updated-daily, violations |
Tables
Table 1
@usgov.louisville_metro_government_louisville_metro_ky_proper_b0cc0a16.table_1
- 1.12 MB
- 16,283 rows
- 29 columns
Loading...
Loading...
CREATE TABLE table_1 (
"serv_prov_code" VARCHAR,
"b1_per_id1" VARCHAR,
"b1_per_id2" BIGINT,
"b1_per_id3" VARCHAR,
"b1_special_text" VARCHAR,
"b1_alt_id" VARCHAR,
"fulladdress" VARCHAR,
"partialaddress" VARCHAR,
"longitude" DOUBLE,
"latitude" DOUBLE,
"ext_address_uid" VARCHAR,
"parcel_id" VARCHAR,
"councildist" DOUBLE,
"g6a_g6_compl_t1" VARCHAR,
"g6a_g6_compl_t2" VARCHAR,
"g6a_g6_compl_dd" VARCHAR,
"g6a_g6_status" VARCHAR,
"g6a_g6_status_dd" VARCHAR,
"ga_userid" VARCHAR,
"ga_fml" VARCHAR,
"occupancystatus" VARCHAR,
"guide_item_text" VARCHAR,
"violation_code" VARCHAR,
"guide_item_status" VARCHAR,
"citationamount" BIGINT,
"columncounts" BIGINT,
"objectid" BIGINT,
"x" DOUBLE,
"y" DOUBLE
);