About this Dataset

LAPD NIBRS Offenses Dataset

Effective March 7, 2024, the Los Angeles Police Department (LAPD) implemented a new Records Management System aligning with the FBI's National Incident-Based Reporting System (NIBRS) requirements. This switch, part of a nationwide mandate, enhances the granularity and specificity of crime data. You can learn more about NIBRS on the FBI's website here: https://www.fbi.gov/how-we-can-help-you/more-fbi-services-and-information/ucr/nibrs

NIBRS is more comprehensive than the previous Summary Reporting System (SRS) used in the Uniform Crime Reporting (UCR) program. Unlike SRS, which grouped crimes into general categories, NIBRS collects detailed information for each incident, including multiple offenses, offenders, and victims when applicable. This detail-rich format may give the impression of increased crime levels due to its broader capture of criminal activity, but it actually provides a more accurate and nuanced view of crime in our community.

This change sets a new baseline for crime reporting, reflecting incidents in the City of Los Angeles starting from March 7, 2024.

With NIBRS, each criminal incident may reflect multiple offenses, resulting in more robust data than before. This may change the appearance of crime frequency, as multiple offenses per incident are reported individually.
Organization: City of Los Angeles
Last updated: 2024-12-13T20:56:34.734846
Tags: crime, crime-data, crimes, lapd, police, safe-city

Tables

Table 1

@usgov.city_of_los_angeles_lapd_nibrs_offenses_dataset.table_1

4.04 MB
132,248 rows
28 columns

CREATE TABLE table_1 (
  "caseno" VARCHAR,
  "uniquenibrno" VARCHAR,
  "date_rptd" VARCHAR,
  "date_occ" VARCHAR,
  "time_occ" BIGINT,
  "area" BIGINT,
  "area_name" VARCHAR,
  "rpt_dist_no" BIGINT,
  "totaloffensecount" BIGINT,
  "group" VARCHAR,
  "nibr_code" VARCHAR,
  "nibr_description" VARCHAR,
  "crime_against" VARCHAR,
  "premis_cd" VARCHAR,
  "premis_desc" VARCHAR,
  "weapon_used_cd" VARCHAR,
  "weapon_desc" VARCHAR,
  "status" BIGINT,
  "status_desc" VARCHAR,
  "totalvictimcount" BIGINT,
  "victim_shot" VARCHAR,
  "domestic_violence_crime" VARCHAR,
  "hate_crime" VARCHAR,
  "gang_related_crime" VARCHAR,
  "transit_related_crime" VARCHAR,
  "homeless_victim_crime" VARCHAR,
  "homeless_suspect_crime" VARCHAR,
  "homeless_arrestee_crime" VARCHAR
);