Name: Los Angeles Crime Data 2020-2023
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Los Angeles Crime Data 2020-2023

This dataset contains official crime records reported in Los Angeles City from January 2020 to December 2023.

The data provides valuable information about reported crimes, including the date, area, crime details, victim information, premises, weapons used, and status.

If you find this dataset valuable, don't forget to hit the upvote button! 😊💝

Checkout my top datasets

Interesting Task Ideas:

Analyze the temporal patterns of crimes in different areas of Los Angeles City.
Identify the most common crimes.
Explore the correlation between victim age and crime types.
Investigate the crime rates in different areas of the city.
Examine the relationship between premises and specific crime codes.
Visualize the distribution of crimes on a map of Los Angeles City.
Analyze the relationship between crime status and occurrence location.
Use machine learning techniques to predict crime categories based on available features.

Tables

Crime Data From 2020 To Present

@kaggle.asaniczka_crimes_in_los_angeles_2020_2023.crime_data_from_2020_to_present

39.54 MB
852,950 rows
27 columns

CREATE TABLE crime_data_from_2020_to_present (
  "division_number" BIGINT,
  "date_reported" TIMESTAMP,
  "date_occurred" TIMESTAMP,
  "area" BIGINT,
  "area_name" VARCHAR,
  "reporting_district" BIGINT,
  "part" BIGINT,
  "crime_code" BIGINT,
  "crime_description" VARCHAR,
  "modus_operandi" VARCHAR,
  "victim_age" BIGINT,
  "victim_sex" VARCHAR,
  "victim_descent" VARCHAR,
  "premise_code" DOUBLE,
  "premise_description" VARCHAR,
  "weapon_code" DOUBLE,
  "weapon_description" VARCHAR,
  "status" VARCHAR,
  "status_description" VARCHAR,
  "crime_code_1" DOUBLE,
  "crime_code_2" DOUBLE,
  "crime_code_3" DOUBLE,
  "crime_code_4" DOUBLE,
  "location" VARCHAR,
  "cross_street" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);