About this Dataset

Louisville Metro KY - LMPD Hate Crimes

The Louisville Metro Police Department (LMPD) began operations on January 6, 2003, as part of the creation of the consolidated city-county government in Louisville, Kentucky. It was formed by the merger of the Jefferson County Police Department and the Louisville Division of Police. The Louisville Metro Police Department is headed by Acting Chief Paul Humphrey. LMPD divides Jefferson County into eight patrol divisions and operates a number of special investigative and support units.

Data Dictionary

Field Names	Field Descriptions
Incident Number	Number associated with either the incident or used as reference to store the items in our evidence rooms and can be used to connect the dataset to other LMPD datasets.
Date Reported	Date and time the incident was reported to LMPD
Date Occurred	Date and time the incident occurred
Crime Type	Crime type as well as the Kentucky Revised Statute identifier that can be referenced here https://apps.legislature.ky.gov/law/statutes/
Bias Group	Victim group that was targeted by the criminal act
NIBRS Code Name	Common language name for 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
NIBRS Code	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
NIBRS Group	NIBRS Group the crime belongs to - For more details visit https://ucr.fbi.gov/nibrs/2011/resources/nibrs-offense-codes/view
Was Offense Completed	Was the crime completed, Yes or No?
LMPD Division	LMPD division in which the incident actually occurred
LMPD Beat	LMPD beat in which the incident actually occurred
Location Category	Type of location in which the incident occurred (e.g. Restaurant)
Block Address	Block address in which the incident occurred
City	City associated to the incident location
State	State associated to the incident location
Zip Code	Postal code associated to the incident location
Organization: Louisville Metro Government
Last updated: 2025-07-30T14:11:53.181508
Tags: crime, data-dictionary, hate, hate-crimes, lmpd, louisville-metro, louisville-metro-ky, louisville-metro-police-department, updated-weekly

Tables

Table 1

@usgov.louisville_metro_government_louisville_metro_ky_lmpd_h_ea558fab.table_1

36.02 kB
377 rows
17 columns

CREATE TABLE table_1 (
  "incident_number" VARCHAR,
  "date_reported" VARCHAR,
  "date_occurred" VARCHAR,
  "crime_type" VARCHAR,
  "bias_group" VARCHAR,
  "nibrs_code_name" VARCHAR,
  "nibrs_code" VARCHAR,
  "nibrs_group_name" VARCHAR,
  "was_offense_completed" VARCHAR,
  "lmpd_division" VARCHAR,
  "lmpd_beat" VARCHAR,
  "location_category" VARCHAR,
  "block_address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT,
  "objectid" BIGINT
);