About this Dataset

Louisville Metro KY - Gun Violence Data

This dataset consists of gun violence within Jefferson county that may fall within LMPDs radar, including non-fatal shootings, homicides, as well as shot-spotter data. The mapping data points where there are victims have been obfuscated to maintain privacy, while still being accurate enough to be placed in its correct boundaries, particularly around, neighborhoods, ZIP Codes, Council districts, and police divisions. The data also excludes any victim information that could be used to identify any individual. this data is used to make the public aware of what is going on in their communities. The data consists of only criminal incidents, excluding any cases that are deemed non-criminal.

Field Name	Field Description
Case number	Police report number. For ShotSpotter detections, it is the ShotSpotter ID.
DateTime	Date and time in which the original incident occurred. Time is rounded down.
Address	Address rounded down to the one hundred block of where the initial incident occured. Unless it is an intersection.
Neighborhood	Neighborhood in which the original incident occurred.
Council District	Council district in which the original incident occurred.
Latitude	Latitude coordinate used to map the incident
Longitude	Longitude coordinate used to map the incident
ZIP Code	ZIP Code in which the original incident occurred.
Crime Type	a distinction between incidents, whether it is a non-fatal shooting, homicide, or a ShotSpotter detection.
Cause	Used to differentiate on the cause of death for homicide victims.
Sex	Gender of the victim of the initial incident.
Race	Race/Ethnicity of the victim in a given incident.
Age Group	Categorized age groups used to anonymize victim information.
Division Name	Police division or department where the initial incident occurred.

Crime report data is provided for Louisville Metro Police Divisions only; crime data does not include smaller class cities, unless LMPD becomes involved in smaller agency incident.

The data provided in this dataset is preliminary in nature and may have not been investigated by a detective at the time of download. The data is therefore subject to change after a complete investigation. This data represents only calls for police service where a police incident report was taken. Due to the variations in local laws and ordinances involving crimes across the nation, whether another agency utilizes Uniform Crime Report (UCR) or National Incident Based Reporting System (NIBRS) guidelines, and the results learned after an official investigation, comparisons should not be made between the statistics generated with this dataset to any other official police reports. Totals in the database may vary considerably from official totals following the investigation and final categorization of a crime. Therefore, the data should not be used for comparisons with Uniform Crime Report or other summary statistics.

Contact:

Ivan Benitez, Ph.D.

Gun Violence Data Fellow

Office for Safe and Healthy Neighborhoods

ivan.benitez@louisvilleky.gov
Organization: Louisville Metro Government
Last updated: 2025-07-30T14:09:59.283369
Tags: gun, gun-violence, jefferson-county, kentucky, lmpd, louisville, louisville-metro, louisville-metro-ky, louisville-metro-police-department, metro-police, office-for-safe-healthy-neighborhoods, oshn, recent_odp

Tables

Table 1

@usgov.louisville_metro_government_louisville_metro_ky_gun_violence.table_1

3.42 MB
65631 rows
17 columns


CREATE TABLE table_1 (
  "case_number" VARCHAR,
  "datetime" VARCHAR,
  "address" VARCHAR,
  "neighborhood" VARCHAR,
  "council_district" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "zip_code" BIGINT,
  "crime_type" VARCHAR,
  "cause" VARCHAR,
  "sex" VARCHAR,
  "race" VARCHAR,
  "age_group" VARCHAR,
  "division_name" VARCHAR,
  "objectid" BIGINT,
  "x" DOUBLE,
  "y" DOUBLE
);