About this Dataset

Louisville Metro KY - Firearm Data Normalized Addresses January 1st, 2010-February 22nd, 2017

A subset of FIREARM DATA.csv, this file contains geocoded addresses, utilizing Open Addresses. This data does NOT include street intersections, it contains only block level addresses, and null (redacted) entries._
_

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:57:01.453673
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_270d10b9.table_1

435.36 kB
11,742 rows
21 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,
  "address_geocode_type" VARCHAR,
  "recovery_address" VARCHAR  -- RECOVERY, ADDRESS,
  "city" VARCHAR,
  "state" VARCHAR,
  "recovery_zipcode" DOUBLE,
  "person_recovered_from_race" VARCHAR,
  "person_recovered_from_sex" VARCHAR,
  "person_recovered_from_age" VARCHAR,
  "address_concat" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "confidence" DOUBLE,
  "source" VARCHAR,
  "objectid" BIGINT
);