Dataset: Los Angeles Crime Data

About this Dataset

Los Angeles Crime Data

Content

This data is collected on the basis of LAPD radio comms and Investigation done by them after the crime is reported. It contains crime data from 2020 to present(March 2024). In order to protect the privacy of crime victims, addresses are shown at the block level only and specific locations are not identified.

The Dataset includes 20 columns which includes information on areas such as -

Record Number
Date and time at which crime was reported/occurred
Victim Age,Sex, Ethnicity
Location where the crime took place
Weapon of crime
Status of the case

Acknowledgements

The data was provided by https://data.lacity.org/, y'all can find the original dataset being updated here

banner photo by Jake Blucker

Inspiration

EDA and Visulisation of the cases
Crime rate prediction and analysis
Where and when is mostly the crime commited?
What is the most common timing/date for most crimes to occur
Most common type of crime
In which Los Angeles Patrol Division(Area) does most crime reported?

Tables

Crime In La

@kaggle.hemil26_crime_in_los_angeles.crime_in_la

35.72 MB
963006 rows
20 columns


CREATE TABLE crime_in_la (
  "dr_no" BIGINT,
  "date_occ" TIMESTAMP,
  "time_occ" VARCHAR,
  "area" BIGINT,
  "area_name" VARCHAR,
  "rpt_dist_no" BIGINT,
  "crm_cd" BIGINT,
  "crm_cd_desc" VARCHAR,
  "mocodes" VARCHAR,
  "vict_age" BIGINT,
  "vict_sex" VARCHAR,
  "vict_descent" VARCHAR,
  "premis_desc" VARCHAR,
  "weapon_used_cd" DOUBLE,
  "weapon_desc" VARCHAR,
  "status" VARCHAR,
  "status_desc" VARCHAR,
  "location" VARCHAR,
  "lat" DOUBLE,
  "lon" DOUBLE
);