About this Dataset

Louisville Metro KY - LMPD Hate Crimes

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 within 30 days of the system migration, on or around April 13th, 2023

Data is subset of the Incident data provided by the open data portal. This data specifically identifies crimes that meet the elements outlined under the FBI Hate crimes program since 2010. For more information on the FBI hate crime overview please visit
https://www.fbi.gov/about-us/investigate/civilrights/hate_crimes

Data Dictionary:

**
**

ID - the row number

INCIDENT_NUMBER - the 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 - the date the incident was reported to LMPD

DATE_OCCURED - the date the incident actually occurred

CRIME_TYPE - the crime type category

BIAS_MOTIVATION_GROUP - Victim group that was targeted by the criminal act

BIAS_TARGETED_AGAINST - Criminal act was against a person or property

UOR_DESC - Uniform Offense Reporting code for the criminal act committed

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

CITY - the city associated to the incident block location

ZIP_CODE - the zip code associated to the incident block location
Organization: Louisville Metro Government
Last updated: 2023-04-13T13:10:45.728429
Tags: crimes, hate, hate-crimes, lmpd, louisville, louisville-metro, louisville-metro-ky, louisville-metro-police-department, metro-police

Tables

Table 1

@usgov.louisville_metro_government_louisville_metro_ky_lmpd_h_939f1cee.table_1

35.46 kB
374 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
);