Name: Crime Dataset
Creator: Kaggle
License: https://www.apache.org/licenses/

About this Dataset

Crime Dataset

In a world of increasing crime, many organizations are interested in examining incident details to learn from and prevent future crime. Our client, based in Los Angeles County, was interested in this exact thing. They asked us to examine the data to answer several questions; among them,
1 .what was the rate of increase or decrease in crime from 2020 to 2023,
2. which ethnicity or group of people were targeted the most

Tables

Crime Data From 2020 To Present

@kaggle.haseefalam_crime_dataset.crime_data_from_2020_to_present

41.6 MB
955,339 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
);