About this Dataset

Louisville Metro KY - Assaulted Officers

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

_
_

Incidents of Officers assaulted by individuals since 2010.

Data Dictionary:

ID - the row number

DATE_REPORTED - the date the incident was reported to LMPD

DATE_OCCURED - the date the incident actually occurred

CRIME_TYPE - the crime type category (assault or homicide)

NIBRS_CODE - the code that follows the guidelines of the National Incident Based Reporting System. For more details visit https://ucr.fbi.gov/nibrs/2011/resources/nibrs-offense-codes/view

UCR_HIERARCHY - hierarchy that follows the guidelines of the FBI Uniform Crime Reporting. For more details visit https://ucr.fbi.gov/

ATT_COMP - Status indicating whether the incident was an attempted crime or a completed crime.

LMPD_DIVISION - the LMPD division in which the incident actually occurred

LMPD_BEAT - the LMPD beat in which the incident actually occurred

PREMISE_TYPE - the type of location in which the incident occurred (e.g. Restaurant)

BLOCK_ADDRESS - the location the incident occurred

UOR_DESC - Uniform Offense Reporting code for the criminal act committed

LEOKA_APPLIES - whether or not the incident is reported to the Center for the Study of Law Enforcement Officers Killed and Assaulted (LEOKA). For more information visit https://leoka.org/

OFFICER_KILLED - whether or not an officer was killed due to the incident

TYPE_OF_ASSIGNMENT - how the officer was assigned at the time of the incident (e.g. ONE-MAN VEHICLE ALONE (UNIFORMED OFFICER))

TYPE_OF_ACTIVITY - the type of activity the officer was doing at the time of the incident (e.g. RESPONDING TO DISTURBANCE CALLS)

OFFENSE_CITY - the city associated to the incident block location

OFFENSE_ZIP - the zip code associated to the incident block location
Organization: Louisville Metro Government
Last updated: 2025-07-30T13:25:44.627350
Tags: assaulted, assaulted-officers, jefferson-county, kentucky, lmpd, louisville, louisville-metro, louisville-metro-ky, louisville-metro-police-department, metro-police

Tables

Table 1

@usgov.louisville_metro_government_louisville_metro_ky_assaul_b1cb781e.table_1

285.39 kB
6,455 rows
19 columns

CREATE TABLE table_1 (
  "incident_number" VARCHAR,
  "date_reported" VARCHAR,
  "date_occured" VARCHAR,
  "crime_type" VARCHAR,
  "uor_desc" VARCHAR,
  "leoka_applies" VARCHAR,
  "officer_killed" VARCHAR,
  "type_of_assignment" VARCHAR,
  "type_of_activity" VARCHAR,
  "nibrs_code" VARCHAR,
  "ucr_hierarchy" VARCHAR,
  "att_comp" VARCHAR,
  "lmpd_division" VARCHAR,
  "lmpd_beat" VARCHAR,
  "premise_type" VARCHAR,
  "block_address" VARCHAR,
  "offense_city" VARCHAR,
  "offense_zip" BIGINT,
  "objectid" BIGINT
);