About this Dataset

Louisville Metro KY - Firearms Intake January 1st, 2010-February 22nd, 2017

Data provided is representative of firearms taken into evidence by LMPD. The data is pulled from January 1, 2010 to February 22, 2017.

Data Dictionary:

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 the other datasets

UCR_CATEGORY - the UCR based highest offense associated with the incident. For more information on UCR standards please visit https://ucr.fbi.gov/ucr

TYPE_OF_FIREARM - based on the Firearm type, eg “pistol, revolver” or “shotgun, pump action” this field is for general categorization of the Firearm.

FIREARMS_MANUFACTURE - the group, or company who manufactured the Firearm

FIREARMS_MODEL - secondary information used to identify the Firearm.

FIREARMS_CALIBER - the caliber associated with the Firearm, we use federally supplied caliber codes.

RECOVERY_DATE - the date the item was identified or taken into custody.

RECOVERY_BLOCK_ADRESS - the location the items was identified or taken into custody.

RECOVERY_ZIPCODE - the zip code associated to the recovery block location.

PERSON_RECOVERED_FROM RACE - the race associated with person who identified the item or was taken into custody from. The person listed may be the person who found the item, not the person associated with the firearm or offense.

PERSON_RECOVERED_FROM _SEX - the sex associated with person who identified the item or was taken into custody from. The person listed may be the person who found the item, not the person associated with the firearm or offense.

PERSON_RECOVERED_FROM AGE - the age associated with person who identified the item or was taken into custody from. The person listed may be the person who found the item, not the person associated with the firearm or offense.

YEAR - the year the incident happened, useful for times the data is masked.
Organization: Louisville Metro Government
Last updated: 2025-07-30T13:20:50.008575
Tags: firearms, firearms-intake, historical, 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_firear_c0c1a677.table_1

398.46 kB
14,851 rows
16 columns

CREATE TABLE table_1 (
  "incident_number" VARCHAR,
  "ucr_category" VARCHAR,
  "type_of_firearm" VARCHAR,
  "firearm_manufacturer" VARCHAR,
  "firearm_model" VARCHAR,
  "firearm_caliber" VARCHAR,
  "recovery_date" VARCHAR,
  "recovery_block_address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "recovery_zipcode" BIGINT,
  "person_recovered_from_race" VARCHAR,
  "person_recovered_from_sex" VARCHAR,
  "person_recovered_from_age" VARCHAR,
  "year" VARCHAR,
  "objectid" BIGINT
);