About this Dataset

Louisville Metro KY - LMPD Employee Characteristics

Note:****Due to a system migration, this data will cease to update on March 14 th, 2023. The current projection is to restart the updates on or around July 17th, 2024.

_
_

LMPD employee characteristic data including Race, Gender, Current Age, Date Hired, Education Level, Job Title and Assigned Division.
LMPD characteristics CSV file is updated on daily frequency.

Data Dictionary:

AOC_CODE - the badge number of the employee
RANK_TITLE - the sworn rank of the employee
OFFICER_SEX - the gender of the employee
OFFICER_RACE - the race of the employee
OFFICER_AGE_RANGE - the range of ages that the employee's current age falls into
OFFICER_DIVISION - the division where the employee is currently assigned
OFFICER_ASSIGNMENT - the employee's job assignment in the division
OFFICER_YEARS_SWORN - the number of years that the employee has been a sworn employee
Organization: Louisville Metro Government
Last updated: 2025-07-30T13:25:38.477529
Tags: characteristics, employee, lmpd, louisville, louisville-metro, louisville-metro-ky, louisville-metro-police-department, metro-police

Tables

Table 1

@usgov.louisville_metro_government_louisville_metro_ky_lmpd_e_5ce2934a.table_1

35.84 kB
1,700 rows
10 columns

CREATE TABLE table_1 (
  "aoc_code" BIGINT,
  "rank_title" VARCHAR,
  "officer_sex" VARCHAR,
  "officer_race" VARCHAR,
  "officer_age_range" VARCHAR,
  "officer_age" BIGINT,
  "officer_division" VARCHAR,
  "officer_assignment" VARCHAR,
  "officer_years_sworn" BIGINT,
  "objectid" BIGINT
);