Traffic Crashes - Crashes

City of Chicago

@usgov.city_of_chicago_traffic_crashes_crashes

Table List

1 table(165.27 MB)

Table 1

@usgov.city_of_chicago_traffic_crashes_crashes.table_1

165.27 MB
937552 rows
48 columns

crash_record_id CRASH RECORD ID	crash_date_est_i CRASH DATE EST I	crash_date CRASH DATE	posted_speed_limit POSTED SPEED LIMIT	traffic_control_device TRAFFIC CONTROL DEVICE	device_condition DEVICE CONDITION	weather_condition WEATHER CONDITION	lighting_condition LIGHTING CONDITION	first_crash_type FIRST CRASH TYPE	trafficway_type TRAFFICWAY TYPE	alignment ALIGNMENT	roadway_surface_cond ROADWAY SURFACE COND	road_defect ROAD DEFECT	report_type REPORT TYPE	crash_type CRASH TYPE	intersection_related_i INTERSECTION RELATED I	not_right_of_way_i NOT RIGHT OF WAY I	hit_and_run_i HIT AND RUN I	damage DAMAGE	date_police_notified DATE POLICE NOTIFIED	prim_contributory_cause PRIM CONTRIBUTORY CAUSE	sec_contributory_cause SEC CONTRIBUTORY CAUSE	street_no STREET NO	street_direction STREET DIRECTION	street_name STREET NAME	photos_taken_i PHOTOS TAKEN I	statements_taken_i STATEMENTS TAKEN I	num_units NUM UNITS	most_severe_injury MOST SEVERE INJURY	injuries_total INJURIES TOTAL	injuries_reported_not_evident INJURIES REPORTED NOT EVIDENT	injuries_no_indication INJURIES NO INDICATION	crash_hour CRASH HOUR	crash_day_of_week CRASH DAY OF WEEK	crash_month CRASH MONTH	latitude LATITUDE	longitude LONGITUDE	location LOCATION
01184614b08579d6befa7734427e750d0f10e79dc0aa429c1dc1aec682233bb24e4f4ea23ec56b14fd679bed127cd606b2bc2d6ce979cff1cf078690cee952c5		04/04/2025 01:57:00 AM	15	NO CONTROLS	NO CONTROLS	CLEAR	DARKNESS, LIGHTED ROAD	ANGLE	PARKING LOT	STRAIGHT AND LEVEL	SAND, MUD, DIRT	WORN SURFACE	ON SCENE	NO INJURY / DRIVE AWAY				OVER $1,500	04/04/2025 01:57:00 AM	UNABLE TO DETERMINE	UNABLE TO DETERMINE	7103	S	MERRILL AVE			2	NO INDICATION OF INJURY			2	1	6	4	41.7660206951	-87.5724421966	POINT (-87.572442196614 41.766020695126)
00a530520c84927490b597a6220ff3f2a3347472ef3086ef96b91ee2d70fdbae5cbd9eddad123c5ce1517b97c0740b0962926515bbbf0c6b06b30ef5f5578054		01/15/2025 01:50:00 PM	30	NO CONTROLS	NO CONTROLS	CLEAR	DAYLIGHT	FIXED OBJECT	RAMP	STRAIGHT AND LEVEL	DRY	NO DEFECTS	ON SCENE	NO INJURY / DRIVE AWAY		Y		OVER $1,500	01/15/2025 01:52:00 PM	UNABLE TO DETERMINE	NOT APPLICABLE	1234	W	43RD ST			1	NO INDICATION OF INJURY			1	13	4	1	41.8160734755	-87.6567426999	POINT (-87.656742699936 41.816073475493)
019d84ab0f03ace0b07075b0a7d83ba867b7dadad30410c289e3cd0b57f08853586bcc0fcf3a32cccd6012284bade23c9d50a540ece58087fe74947fb2077e31	Y	03/29/2025 06:10:00 PM	35	STOP SIGN/FLASHER	NO CONTROLS	RAIN	DAYLIGHT	ANGLE	NOT DIVIDED	STRAIGHT AND LEVEL	WET	NO DEFECTS		INJURY AND / OR TOW DUE TO CRASH	Y			OVER $1,500	03/29/2025 06:13:00 PM	FAILING TO YIELD RIGHT-OF-WAY	FAILING TO YIELD RIGHT-OF-WAY	2922	W	55TH ST	N	Y	2	REPORTED, NOT EVIDENT	1	1	4	18	7	3	41.7937388975	-87.697311324	POINT (-87.697311324011 41.793738897511)
03a3b86d3b62c8948e25623db7ccf326fed99eaa297b59d94f22a342477fdf3d4855d2d93f6803618d9e5635c1b0a8a6f2bf0c653bd09eafe52b9321bb1dc555		03/15/2025 12:01:00 AM	30	NO CONTROLS	NO CONTROLS	RAIN	DARKNESS, LIGHTED ROAD	PARKED MOTOR VEHICLE	DIVIDED - W/MEDIAN (NOT RAISED)	STRAIGHT AND LEVEL	WET	UNKNOWN		NO INJURY / DRIVE AWAY			Y	OVER $1,500	03/15/2025 12:40:00 PM	UNABLE TO DETERMINE	UNABLE TO DETERMINE	3943	W	31ST ST			2	NO INDICATION OF INJURY			1		7	3	41.8367840347	-87.7236102766	POINT (-87.723610276569 41.836784034697)
088061d9b7e5ab5b1353517ebefcadca065c20de8ca860e36ec91082e55a873f599c5d8832612471300158af10e54df03ef05130f27de119b792d50c16367972	N	03/15/2025 02:12:00 PM	30	TRAFFIC SIGNAL	FUNCTIONING PROPERLY	UNKNOWN	UNKNOWN	PEDALCYCLIST	FOUR WAY	STRAIGHT AND LEVEL	UNKNOWN	UNKNOWN	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY			Y	$500 OR LESS	03/27/2025 06:27:00 PM	DISREGARDING TRAFFIC SIGNALS	NOT APPLICABLE	801	S	WABASH AVE			2	NO INDICATION OF INJURY			2	14	7	3	41.8717783327	-87.6257891244	POINT (-87.625789124419 41.871778332743)
098ff346c933f2cab3b7fadac8201bd6b6e6c4d175f501d35f2f4153578dbd17eae3d229e6c75cdac8e3e6e0d3950973e06a484541d6df822c785d5a6fe01ee4		03/15/2025 04:45:00 PM	30	UNKNOWN	UNKNOWN	CLEAR	DAYLIGHT	REAR TO FRONT	NOT DIVIDED	STRAIGHT AND LEVEL	UNKNOWN	NO DEFECTS	ON SCENE	INJURY AND / OR TOW DUE TO CRASH			Y	$500 OR LESS	03/15/2025 04:55:00 PM	UNABLE TO DETERMINE	NOT APPLICABLE	1104	W	18TH ST			2	NO INDICATION OF INJURY			2	16	7	3	41.8581045309	-87.6536089701	POINT (-87.653608970058 41.858104530861)
0d8fa665a92265ea66c3ae2bad6a1cdecd876885bf0148f76f6d270a0715c157cd9689af86b312f8dd58d2e0c2b00913a82f44ee6cebc4c30f1e27a0f758b5a9		03/15/2025 01:20:00 PM	25	STOP SIGN/FLASHER	FUNCTIONING PROPERLY	CLEAR	DAYLIGHT	REAR TO FRONT	FOUR WAY	STRAIGHT AND LEVEL	UNKNOWN	UNKNOWN	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	Y			OVER $1,500	03/15/2025 01:40:00 PM	IMPROPER BACKING	NOT APPLICABLE	2383	W	GLENLAKE AVE			2	NO INDICATION OF INJURY			2	13	7	3	41.9921642629	-87.689641847	POINT (-87.689641847043 41.99216426286)
204c3ca48ff3cdf0737e7f10b54ef5f8c49fbe30b5e53e53f11755039efb71f965386bae115439bdf7458b55ed9243e8ed673a46843038ef32b79a4a95ba7de6		12/04/2024 05:39:00 PM	30	UNKNOWN	UNKNOWN	RAIN	DARKNESS, LIGHTED ROAD	TURNING	NOT DIVIDED	STRAIGHT AND LEVEL	WET	UNKNOWN	ON SCENE	NO INJURY / DRIVE AWAY				OVER $1,500	12/04/2024 05:55:00 PM	FOLLOWING TOO CLOSELY	FAILING TO YIELD RIGHT-OF-WAY	199	E	BELLEVUE PL			2	NO INDICATION OF INJURY			2	17	4	12
05a9c5c6ab19f092cd1477140875cf33cc6f157c7611688eaae62e993c522ff619ea5d71c967b86b8db36145b7be667da4b1297fcd2965d65ab388274fbdd6d2		03/28/2025 09:59:00 AM	30	TRAFFIC SIGNAL	FUNCTIONING PROPERLY	CLEAR	DAYLIGHT	TURNING	NOT DIVIDED	STRAIGHT AND LEVEL	DRY	NO DEFECTS		NO INJURY / DRIVE AWAY	Y			OVER $1,500	03/28/2025 11:00:00 AM	IMPROPER TURNING/NO SIGNAL	UNABLE TO DETERMINE	4401	S	PULASKI RD			2	NO INDICATION OF INJURY			5	9	6	3	41.8132779289	-87.7236418817	POINT (-87.723641881733 41.813277928858)
0235f4b4460f50115c7f6cb0d2bedeea7ce92b9b0f594301c68796ed9f588b036a5a373d90c24d5e8f2dd83f5c9ff477d78599bc02e81625ce5550bda4c885bc		01/15/2025 06:40:00 PM	25	TRAFFIC SIGNAL	FUNCTIONING PROPERLY	CLEAR	DARKNESS, LIGHTED ROAD	ANGLE	FOUR WAY	STRAIGHT AND LEVEL	DRY	NO DEFECTS	ON SCENE	NO INJURY / DRIVE AWAY	Y			OVER $1,500	01/15/2025 06:42:00 PM	DISREGARDING TRAFFIC SIGNALS	UNABLE TO DETERMINE	2500	S	PULASKI RD			2	NO INDICATION OF INJURY			2	18	4	1	41.846037569	-87.7247613705	POINT (-87.724761370522 41.846037568964)


CREATE TABLE table_1 (
  "crash_record_id" VARCHAR,
  "crash_date_est_i" VARCHAR,
  "crash_date" VARCHAR,
  "posted_speed_limit" BIGINT,
  "traffic_control_device" VARCHAR,
  "device_condition" VARCHAR,
  "weather_condition" VARCHAR,
  "lighting_condition" VARCHAR,
  "first_crash_type" VARCHAR,
  "trafficway_type" VARCHAR,
  "lane_cnt" DOUBLE,
  "alignment" VARCHAR,
  "roadway_surface_cond" VARCHAR,
  "road_defect" VARCHAR,
  "report_type" VARCHAR,
  "crash_type" VARCHAR,
  "intersection_related_i" VARCHAR,
  "not_right_of_way_i" VARCHAR,
  "hit_and_run_i" VARCHAR,
  "damage" VARCHAR,
  "date_police_notified" VARCHAR,
  "prim_contributory_cause" VARCHAR,
  "sec_contributory_cause" VARCHAR,
  "street_no" BIGINT,
  "street_direction" VARCHAR,
  "street_name" VARCHAR,
  "beat_of_occurrence" DOUBLE,
  "photos_taken_i" VARCHAR,
  "statements_taken_i" VARCHAR,
  "dooring_i" VARCHAR,
  "work_zone_i" VARCHAR,
  "work_zone_type" VARCHAR,
  "workers_present_i" VARCHAR,
  "num_units" BIGINT,
  "most_severe_injury" VARCHAR,
  "injuries_total" DOUBLE,
  "injuries_fatal" DOUBLE,
  "injuries_incapacitating" DOUBLE,
  "injuries_non_incapacitating" DOUBLE,
  "injuries_reported_not_evident" DOUBLE,
  "injuries_no_indication" DOUBLE,
  "injuries_unknown" DOUBLE,
  "crash_hour" BIGINT,
  "crash_day_of_week" BIGINT,
  "crash_month" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);