Crimes - 2001 To Present

City of Chicago

@usgov.city_of_chicago_crimes_2001_to_present

Table List

1 table(567.41 MB)

Table 1

@usgov.city_of_chicago_crimes_2001_to_present.table_1

567.41 MB
8299555 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	beat Beat	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
13311263	JG503434	07/29/2022 03:39:00 AM	023XX S TROY ST	1582	OFFENSE INVOLVING CHILDREN	CHILD PORNOGRAPHY	RESIDENCE	true	1033	25	30	17			2022	04/18/2024 03:40:59 PM
13053066	JG103252	01/03/2023 04:44:00 PM	039XX W WASHINGTON BLVD	2017	NARCOTICS	MANUFACTURE / DELIVER - CRACK	SIDEWALK	true	1122	28	26	18			2023	01/20/2024 03:41:12 PM
11227634	JB147599	08/26/2017 10:00:00 AM	001XX W RANDOLPH ST	0281	CRIM SEXUAL ASSAULT	NON-AGGRAVATED	HOTEL/MOTEL		122	42	32	02			2017	02/11/2018 03:57:41 PM
13203321	JG415333	09/06/2023 05:00:00 PM	002XX N Wells st	1320	CRIMINAL DAMAGE	TO VEHICLE	PARKING LOT / GARAGE (NON RESIDENTIAL)		122	42	32	14	1174694	1901831	2023	11/04/2023 03:40:18 PM	41.886018055	-87.633937881	(41.886018055, -87.633937881)
13204489	JG416325	09/06/2023 11:00:00 AM	0000X E 8TH ST	0810	THEFT	OVER $500	PARKING LOT / GARAGE (NON RESIDENTIAL)		123	4	32	06	1176857	1896680	2023	11/04/2023 03:40:18 PM	41.871834768	-87.62615082	(41.871834768, -87.62615082)
11695116	JC272771	05/21/2019 08:20:00 AM	018XX S CALIFORNIA AVE	0620	BURGLARY	UNLAWFUL ENTRY	RESIDENCE		1023	25	29	05	1157982	1890961	2019	01/19/2024 03:40:50 PM	41.856547057	-87.695604526	(41.856547057, -87.695604526)
12419690	JE295655	07/07/2021 10:30:00 AM	132XX S GREENWOOD AVE	1544	SEX OFFENSE	SEXUAL EXPLOITATION OF A CHILD	RESIDENCE		533	10	54	17	1186051	1817781	2021	01/19/2024 03:40:50 PM	41.65511579	-87.594883198	(41.65511579, -87.594883198)
12729745	JF279458	06/14/2022 02:47:00 PM	035XX N CENTRAL AVE	0340	ROBBERY	ATTEMPT STRONG ARM - NO WEAPON	BANK	true	1633	30	15	03	1138391	1923142	2022	01/19/2024 03:40:50 PM	41.945232412	-87.766734668	(41.945232412, -87.766734668)
12835559	JF406130	09/21/2022 10:00:00 PM	004XX E 69TH ST	0910	MOTOR VEHICLE THEFT	AUTOMOBILE	OTHER (SPECIFY)	true	322	6	69	07	1180204	1859359	2022	01/19/2024 03:40:50 PM	41.769346711	-87.615008288	(41.769346711, -87.615008288)
13003649	JG177593	02/22/2023 01:50:00 PM	070XX S CLYDE AVE	0610	BURGLARY	FORCIBLE ENTRY	RESIDENCE - PORCH / HALLWAY	true	331	5	43	05	1191427	1858753	2023	01/19/2024 03:40:50 PM	41.767419224	-87.573890196	(41.767419224, -87.573890196)


CREATE TABLE table_1 (
  "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
);