Dataset: Los Angeles Crime Dataset (2020 -- Present)

About this Dataset

Los Angeles Crime Dataset (2020 -- Present)

This Dataset contains all of the recorded crime data in the city of Los Angeles between the years of 2020 to the Present Day(2023). The dataset contains everything from the time the crime was reported, the type of crime committed, as well as the longitude and latitude which the crime was committed.

Tables

Crime Data From 2020 To Present

@kaggle.nathaniellybrand_los_angeles_crime_dataset_2020_present.crime_data_from_2020_to_present

30.73 MB
752911 rows
28 columns


CREATE TABLE crime_data_from_2020_to_present (
  "dr_no" BIGINT,
  "date_rptd" VARCHAR,
  "date_occ" VARCHAR,
  "time_occ" BIGINT,
  "area" BIGINT,
  "area_name" VARCHAR,
  "rpt_dist_no" BIGINT,
  "part_1_2" BIGINT,
  "crm_cd" BIGINT,
  "crm_cd_desc" VARCHAR,
  "mocodes" VARCHAR,
  "vict_age" BIGINT,
  "vict_sex" VARCHAR,
  "vict_descent" VARCHAR,
  "premis_cd" DOUBLE,
  "premis_desc" VARCHAR,
  "weapon_used_cd" DOUBLE,
  "weapon_desc" VARCHAR,
  "status" VARCHAR,
  "status_desc" VARCHAR,
  "crm_cd_1" DOUBLE,
  "crm_cd_2" DOUBLE,
  "crm_cd_3" DOUBLE,
  "crm_cd_4" DOUBLE,
  "location" VARCHAR,
  "cross_street" VARCHAR,
  "lat" DOUBLE,
  "lon" DOUBLE
);