Chicago Crime Dataset - 2001 To Present

Reported incidents of crime in the City of Chicago from 2001 to present.

@kaggle.adelanseur_crimes_2001_to_present_chicago

Table List

1 table(488.75 MB)

Crimes 2001 To Present

@kaggle.adelanseur_crimes_2001_to_present_chicago.crimes_2001_to_present

488.75 MB
7842937 rows
22 columns

id ID	case_number Case Number	date Date	block Block	iucr IUCR	primary_type Primary Type	description Description	location_description Location Description	arrest Arrest	domestic Domestic	beat Beat	district District	ward Ward	community_area Community Area	fbi_code FBI Code	x_coordinate X Coordinate	y_coordinate Y Coordinate	year Year	updated_on Updated On	latitude Latitude	longitude Longitude	location Location
11646166	JC213529	09/01/2018 12:01:00 AM	082XX S INGLESIDE AVE	0810	THEFT	OVER $500	RESIDENCE		true	631	6	8	44	06			2018	04/06/2019 04:04:43 PM			nan
11645836	JC212333	05/01/2016 12:25:00 AM	055XX S ROCKWELL ST	1153	DECEPTIVE PRACTICE	FINANCIAL IDENTITY THEFT OVER $ 300	nan			824	8	15	63	11			2016	04/06/2019 04:04:43 PM			nan
11449702	JB373031	07/31/2018 01:30:00 PM	009XX E HYDE PARK BLVD	2024	NARCOTICS	POSS: HEROIN(WHITE)	STREET	true		233	2	5	41	18			2018	04/09/2019 04:24:58 PM			nan
11643334	JC209972	12/19/2018 04:30:00 PM	056XX W WELLINGTON AVE	1320	CRIMINAL DAMAGE	TO VEHICLE	STREET			2514	25	31	19	14			2018	04/04/2019 04:16:11 PM			nan
11645527	JC212744	02/02/2015 10:00:00 AM	069XX W ARCHER AVE	1153	DECEPTIVE PRACTICE	FINANCIAL IDENTITY THEFT OVER $ 300	OTHER			811	8	23	56	11			2015	04/06/2019 04:04:43 PM			nan
11034701	JA366925	01/01/2001 11:00:00 AM	016XX E 86TH PL	1153	DECEPTIVE PRACTICE	FINANCIAL IDENTITY THEFT OVER $ 300	RESIDENCE			412	4	8	45	11			2001	08/05/2017 03:50:08 PM			nan
10224881	HY411873	09/03/2015 06:00:00 PM	044XX S UNIVERSITY AVE	1310	CRIMINAL DAMAGE	TO PROPERTY	RESIDENCE			222	2	4	39	14	1184667	1875669	2015	02/10/2018 03:50:01 PM	41.81399924	-87.598137918	(41.81399924, -87.598137918)
11230640	JB152083	12/04/2017 12:00:00 AM	035XX S MICHIGAN AVE	4650	OTHER OFFENSE	SEX OFFENDER: FAIL TO REGISTER	GOVERNMENT BUILDING/PROPERTY	true		213	2	3	35	26			2017	04/12/2018 03:55:17 PM			nan
11645648	JC212959	01/01/2018 08:00:00 AM	024XX N MONITOR AVE	1153	DECEPTIVE PRACTICE	FINANCIAL IDENTITY THEFT OVER $ 300	RESIDENCE			2515	25	30	19	11			2018	04/06/2019 04:04:43 PM			nan
11645959	JC211511	12/20/2018 04:00:00 PM	045XX N ALBANY AVE	2820	OTHER OFFENSE	TELEPHONE THREAT	RESIDENCE			1724	17	33	14	08A			2018	04/06/2019 04:04:43 PM			nan


CREATE TABLE crimes_2001_to_present (
  "id" BIGINT,
  "case_number" VARCHAR,
  "date" VARCHAR,
  "block" VARCHAR,
  "iucr" VARCHAR,
  "primary_type" VARCHAR,
  "description" VARCHAR,
  "location_description" VARCHAR,
  "arrest" BOOLEAN,
  "domestic" BOOLEAN,
  "beat" BIGINT,
  "district" DOUBLE,
  "ward" DOUBLE,
  "community_area" DOUBLE,
  "fbi_code" VARCHAR,
  "x_coordinate" DOUBLE,
  "y_coordinate" DOUBLE,
  "year" BIGINT,
  "updated_on" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);