Baselight

Los Angeles Crime Dataset (2020 -- Present)

Los Angeles Crime Records From 2020 - Present Day

@kaggle.nathaniellybrand_los_angeles_crime_dataset_2020_present

Loading...
Loading...

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
Loading...

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
);

Share link

Anyone who has the link will be able to view this.