About this Dataset

Louisville Metro KY - PM Workorders - OPEN

For a list of resolved Property Maintenance Workorders, you can visit: Louisville Metro KY- PM Workorders - Resolved

The Department of Codes and Regulations issues and inspects Development Permits (building, electrical, HVAC), enforces Property Maintenance Code (housing) and Land Development Code (zoning), and administers the Code Enforcement Board.

**
**

Data Dictionary

Field Name	Field Description
RECORD_ID	Unique identifier for the record in Accela
RECORD_STATUS	Current state of the record
RECORD_TYPE	The type of record
WORK_DESCRIPTION	Description of work requested
DATE_OPENED	The date the record was opened
ASSIGNED_STAFF	Staff member assigned to record, typically first initial and last name.
HOUSE_NUMBER	The location of the property where the work order has been scheduled
HOUSE_FRACTION_NUMBER
STREET_DIRECTION
STREET_NAME
STREET_SUFFIX
UNIT_NUMBER
ZIPCODE
LATITUDE
LONGITUDE
CENSUS_BLOCK_GROUP	The census block group where the property is located in.
COUNCIL_DISTRICT	The council district where the property is located in.
CENSUS_TRACT	The census tract where the property is located in.
METRO_PAGE	Map Sheet Index for METRO MAP, a base map of Jefferson County with a 6000 ft grid overlay
METRO_PAGE_NAME	Name of the grid on the METRO MAP, a base map of Jefferson County with a 6000 ft grid overlay
Organization: Louisville Metro Government
Last updated: 2025-07-30T14:10:06.216659
Tags: codes-and-regs, data-dictionary, jefferson-county, kentucky, louisville, louisville-metro, louisville-metro-ky, maintenance, property-maintenance, recent_opd, updated-daily, work-orders

Tables

Table 1

@usgov.louisville_metro_government_louisville_metro_ky_pm_wor_db2c9234.table_1

162.59 kB
1,999 rows
23 columns

CREATE TABLE table_1 (
  "record_id" VARCHAR,
  "record_status" VARCHAR,
  "record_type" VARCHAR,
  "work_description" VARCHAR,
  "date_opened" TIMESTAMP,
  "assigned_staff" VARCHAR,
  "house_number" DOUBLE,
  "house_fraction_number" VARCHAR,
  "street_direction" VARCHAR,
  "street_name" VARCHAR,
  "street_suffix" VARCHAR,
  "unit_number" VARCHAR,
  "zipcode" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "census_block_group" VARCHAR,
  "council_district" DOUBLE,
  "census_tract" DOUBLE,
  "metro_page" VARCHAR,
  "metro_page_name" VARCHAR,
  "objectid" BIGINT,
  "x" DOUBLE,
  "y" DOUBLE
);