Baselight
Sign In

Crime Dataset

crime dataset u can analyze that

@kaggle.haseefalam_crime_dataset

Loading...

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
  • 39.67 MB
  • 955339 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
);