Dataset: USCrimesDataset

About this Dataset

USCrimesDataset

USA crime from 2016-07-01 to 2022-08-08
Information about all crimes that happened in the USA, when they happened, what crime was commited, a general description about it and the number of victims.

Tables

Crime

@kaggle.jgiigii_uscrimesdataset.crime

18.58 MB
306094 rows
30 columns


CREATE TABLE crime (
  "incident_id" BIGINT,
  "offence_code" VARCHAR,
  "cr_number" BIGINT,
  "dispatch_date_time" VARCHAR,
  "nibrs_code" VARCHAR,
  "victims" BIGINT,
  "crime_name1" VARCHAR,
  "crime_name2" VARCHAR,
  "crime_name3" VARCHAR,
  "police_district_name" VARCHAR,
  "block_address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" DOUBLE,
  "agency" VARCHAR,
  "place" VARCHAR,
  "sector" VARCHAR,
  "beat" VARCHAR,
  "pra" VARCHAR,
  "address_number" DOUBLE,
  "street_prefix" VARCHAR,
  "street_name" VARCHAR,
  "street_suffix" VARCHAR,
  "street_type" VARCHAR,
  "start_date_time" VARCHAR,
  "end_date_time" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "police_district_number" VARCHAR,
  "location" VARCHAR
);

Crimes With Dates Cleaned

@kaggle.jgiigii_uscrimesdataset.crimes_with_dates_cleaned

21.1 MB
306094 rows
36 columns


CREATE TABLE crimes_with_dates_cleaned (
  "unnamed_0" BIGINT,
  "incident_id" BIGINT,
  "offence_code" VARCHAR,
  "cr_number" BIGINT,
  "dispatch_date_time" VARCHAR,
  "nibrs_code" VARCHAR,
  "victims" BIGINT,
  "crime_name1" VARCHAR,
  "crime_name2" VARCHAR,
  "crime_name3" VARCHAR,
  "police_district_name" VARCHAR,
  "block_address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" DOUBLE,
  "agency" VARCHAR,
  "place" VARCHAR,
  "sector" VARCHAR,
  "beat" VARCHAR,
  "pra" VARCHAR,
  "address_number" DOUBLE,
  "street_prefix" VARCHAR,
  "street_name" VARCHAR,
  "street_suffix" VARCHAR,
  "street_type" VARCHAR,
  "start_date_time" VARCHAR,
  "end_date_time" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "police_district_number" VARCHAR,
  "location" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "year_month" VARCHAR,
  "day" BIGINT,
  "committed_at_morning" BOOLEAN
);