About this Dataset

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

A subset of parent FIREARM DATA.csv, this file contains only intersections of seized firearms, with limited success in geocoding from Lojic ArcGIS geocoder. This file contains X and Y coordinates in Kentucky State Plane North coordinate system, in addition to converted Latitude and Longitude coordinates._
_

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:44.114824
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_f2b186c8.table_1

158.84 kB
2,746 rows
23 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_block_address" VARCHAR,
  "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,
  "x" DOUBLE,
  "y" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "confidence" VARCHAR,
  "source" VARCHAR,
  "objectid" BIGINT
);