Dataset: Arrest Data From 2020 To Present

About this Dataset

Arrest Data From 2020 To Present

***Starting on March 7th, 2024, the Los Angeles Police Department (LAPD) will adopt a new Records Management System for reporting crimes and arrests. This new system is being implemented to comply with the FBI's mandate to collect NIBRS-only data (NIBRS — FBI - https://www.fbi.gov/how-we-can-help-you/more-fbi-services-and-information/ucr/nibrs). During this transition, users will temporarily see only incidents reported in the retiring system. However, the LAPD is actively working on generating new NIBRS datasets to ensure a smoother and more efficient reporting system. *** This dataset reflects arrest incidents in the City of Los Angeles from 2020 to present. This data is transcribed from original arrest reports that are typed on paper and therefore there may be some inaccuracies within the data. Some location fields with missing data are noted as (0.0000°, 0.0000°). Address fields are only provided to the nearest hundred block in order to maintain privacy. This data is as accurate as the data in the database. Please note questions or concerns in the comments.
Organization: City of Los Angeles
Last updated: 2020-11-10T17:52:13.861974
Tags: arrest, arrest-data, arrests, lapd, police, safe-city

Tables

Table 1

@usgov.city_of_los_angeles_arrest_data_from_2020_to_present.table_1

12.54 MB
342734 rows
25 columns


CREATE TABLE table_1 (
  "report_id" BIGINT,
  "report_type" VARCHAR,
  "arrest_date" VARCHAR,
  "time" DOUBLE,
  "area_id" BIGINT,
  "area_name" VARCHAR,
  "reporting_district" BIGINT,
  "age" BIGINT,
  "sex_code" VARCHAR,
  "descent_code" VARCHAR,
  "charge_group_code" DOUBLE,
  "charge_group_description" VARCHAR,
  "arrest_type_code" VARCHAR,
  "charge" VARCHAR,
  "charge_description" VARCHAR,
  "disposition_description" VARCHAR,
  "address" VARCHAR,
  "cross_street" VARCHAR,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "location" VARCHAR,
  "booking_date" VARCHAR,
  "booking_time" DOUBLE,
  "booking_location" VARCHAR,
  "booking_location_code" DOUBLE
);