Chicago Car Crash Dataset

Car Crash Data from Chicago

@kaggle.nathaniellybrand_chicago_car_crash_dataset

Table List

1 table(151.42 MB)

Traffic Crashes Crashes

@kaggle.nathaniellybrand_chicago_car_crash_dataset.traffic_crashes_crashes

151.42 MB
746498 rows
49 columns

crash_record_id CRASH RECORD ID	rd_no RD NO	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	beat_of_occurrence BEAT OF OCCURRENCE	photos_taken_i PHOTOS TAKEN I	statements_taken_i STATEMENTS TAKEN I	dooring_i DOORING I	work_zone_i WORK ZONE I	work_zone_type WORK ZONE TYPE	workers_present_i WORKERS PRESENT I	num_units NUM UNITS	most_severe_injury MOST SEVERE INJURY	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
012c5bfce715efb2f2b387d6dd86f9c13e9dc1809fb52ac71501da6110fbd95848a4f380e1b553f8dc03c70f782e85adb155ab97cbeabef83ba76d390c21f535	JG341943	nan	07/12/2023 03:05:00 PM	30	NO CONTROLS	NO CONTROLS	CLEAR	DAYLIGHT	TURNING	NOT DIVIDED	STRAIGHT AND LEVEL	UNKNOWN	NO DEFECTS	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	nan	nan	nan	OVER $1,500	07/15/2023 11:30:00 AM	IMPROPER TURNING/NO SIGNAL	UNABLE TO DETERMINE	4754	W	63RD ST	813	nan	nan	nan	nan	nan	nan	2	NO INDICATION OF INJURY	2	15	4	7	41.778541938	-87.742064741	POINT (-87.742064741348 41.778541938106)
01d457f032e23d935a0b8f6b4c88221375180ffd4cd959492eea49079953f5168d9dd08cba3d0061a8611e8c1115d2d7b83f39578025012b5f286671e7bcf4ec	JG338388	nan	07/12/2023 05:50:00 PM	30	NO CONTROLS	NO CONTROLS	CLEAR	DAYLIGHT	REAR END	NOT DIVIDED	STRAIGHT AND LEVEL	DRY	NO DEFECTS	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	nan	nan	nan	$501 - $1,500	07/12/2023 06:41:00 PM	FOLLOWING TOO CLOSELY	NOT APPLICABLE	8300	S	PULASKI RD	834	nan	nan	nan	nan	nan	nan	2	NO INDICATION OF INJURY	2	17	4	7	41.742130554	-87.7218241	POINT (-87.72182410033 41.742130554062)
02249b4747a4bf40b88a8357304a98dfeaef9c38eebbf00c3fbedb50b61241515d2d1f4461f23962841f95438429b5cd9e5c0cdacc1d224cad0b2876ce330d33	JG350008	nan	07/12/2023 02:00:00 PM	30	NO CONTROLS	NO CONTROLS	CLEAR	DAYLIGHT	OTHER OBJECT	NOT DIVIDED	STRAIGHT AND LEVEL	DRY	RUT, HOLES	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	nan	Y	nan	$501 - $1,500	07/21/2023 10:10:00 AM	NOT APPLICABLE	NOT APPLICABLE	9615	S	STONY ISLAND AVE	431	nan	nan	nan	nan	nan	nan	1	NO INDICATION OF INJURY	1	14	4	7	41.719844228	-87.584789975	POINT (-87.584789974824 41.719844228292)
03e3b6caad71b78ed9ae325648effa9512bfb2517aed3054e396c283dcfe869598b1a63db575c612fa4205c9b49f515c756cef13d72dcdcc3ef12993874c407a	JG338049	nan	07/12/2023 07:05:00 AM	30	TRAFFIC SIGNAL	UNKNOWN	FREEZING RAIN/DRIZZLE	DAYLIGHT	REAR END	NOT DIVIDED	STRAIGHT AND LEVEL	UNKNOWN	UNKNOWN	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	nan	nan	nan	$501 - $1,500	07/12/2023 02:18:00 PM	FOLLOWING TOO CLOSELY	UNABLE TO DETERMINE	2370	N	ASHLAND AVE	1811	nan	nan	nan	nan	nan	nan	2	NO INDICATION OF INJURY	2	7	4	7	41.925104953	-87.668291182	POINT (-87.668291181568 41.925104953308)
0481fc919b38f1572d4ba04b069766102d904a662ff0969f04266ebc48a9605d625c64356bd669d7bc1b778f5500a140812b58f19f2044372e50b31a01f030d4	JG338431	nan	07/12/2023 06:30:00 PM	30	NO CONTROLS	NO CONTROLS	CLEAR	DAYLIGHT	REAR END	NOT DIVIDED	STRAIGHT AND LEVEL	WET	NO DEFECTS	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	nan	nan	nan	OVER $1,500	07/12/2023 07:15:00 PM	FOLLOWING TOO CLOSELY	FOLLOWING TOO CLOSELY	5200	N	ELSTON AVE	1623	nan	nan	nan	nan	nan	nan	2	NO INDICATION OF INJURY	2	18	4	7	41.975258095	-87.751990557	POINT (-87.751990557158 41.97525809527)
0500576055e3d46b0ed507761bfeae64457b1b58871f42b70f71fc5a464b4bf6364d2d8364bc90d5c093de919ecb3826bc6f1be7864b07998f3df9179f069040	JF345041	nan	08/05/2022 09:25:00 AM	30	NO CONTROLS	NO CONTROLS	CLEAR	DAYLIGHT	TURNING	T-INTERSECTION	STRAIGHT AND LEVEL	DRY	NO DEFECTS	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	Y	nan	nan	OVER $1,500	08/05/2022 10:20:00 AM	IMPROPER TURNING/NO SIGNAL	FAILING TO REDUCE SPEED TO AVOID CRASH	1650	N	THROOP ST	1433	nan	nan	nan	nan	nan	nan	2	NO INDICATION OF INJURY	2	9	6	8	41.912215555	-87.661907974	POINT (-87.661907974376 41.912215555223)
067575f551ac7df5aa918f14e1fb63daa10dcb0790d2a17af577d0b1ac6606d8506608e1f7d48c4a34fced54bd0b93591cfdce6a0cae43d23d58fcf195b68ffb	JG337491	N	07/12/2023 02:45:00 AM	35	NO CONTROLS	NO CONTROLS	RAIN	DARKNESS, LIGHTED ROAD	SIDESWIPE SAME DIRECTION	DIVIDED - W/MEDIAN (NOT RAISED)	STRAIGHT AND LEVEL	WET	NO DEFECTS	ON SCENE	INJURY AND / OR TOW DUE TO CRASH	nan	nan	Y	OVER $1,500	07/12/2023 02:55:00 AM	UNABLE TO DETERMINE	UNABLE TO DETERMINE	1922	N	PULASKI RD	2534	nan	nan	nan	nan	nan	nan	2	NO INDICATION OF INJURY	3	2	4	7	41.916055791	-87.726673527	POINT (-87.726673526828 41.91605579143)
07acb1d484e4c78c22307e80ec0daa51cb4f40a049985638c185c765d516a666790f66a9ac4dee8b480c84eb9f0ec2b5486eb3f9897abdde0b411eadce9d41d0	JB443362	nan	09/20/2018 11:10:00 AM	25	NO CONTROLS	NO CONTROLS	CLEAR	DAYLIGHT	SIDESWIPE SAME DIRECTION	NOT DIVIDED	STRAIGHT AND LEVEL	DRY	NO DEFECTS	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	nan	nan	nan	$501 - $1,500	09/20/2018 12:10:00 PM	FAILING TO YIELD RIGHT-OF-WAY	FAILING TO YIELD RIGHT-OF-WAY	1632	N	THROOP ST	1433	nan	nan	nan	nan	nan	nan	2	NO INDICATION OF INJURY	2	11	5	9	41.911661913	-87.661513686	POINT (-87.66151368637 41.911661913381)
09205e5b5b761edc90dbd36ee25a883d1e18da617aa5b33dccc2e0680320df4cb00fed03a5c7a10ab87b13c8d2dbbc25d095f6d19d61bd53040f5969bd8a4636	JG338417	nan	07/12/2023 05:50:00 PM	30	STOP SIGN/FLASHER	FUNCTIONING PROPERLY	RAIN	DAYLIGHT	TURNING	NOT DIVIDED	STRAIGHT AND LEVEL	UNKNOWN	UNKNOWN	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	Y	nan	nan	$501 - $1,500	07/12/2023 06:55:00 PM	IMPROPER TURNING/NO SIGNAL	IMPROPER OVERTAKING/PASSING	2732	N	CANNON DR	1935	nan	nan	nan	nan	nan	nan	2	NO INDICATION OF INJURY	7	17	4	7	41.931852076	-87.638177074	POINT (-87.638177073552 41.931852075785)
093fc24cf0d63df8bb9858e38fa8316e57a9e03188a608fac5ab17efdc947f5630a33894fda4c5cd63d975afcea1667871b365458660c1007f9f1f11963550e5	JG337865	Y	07/12/2023 11:00:00 AM	30	NO CONTROLS	NO CONTROLS	RAIN	DAYLIGHT	ANGLE	NOT DIVIDED	STRAIGHT AND LEVEL	WET	NO DEFECTS	NOT ON SCENE (DESK REPORT)	NO INJURY / DRIVE AWAY	nan	nan	nan	OVER $1,500	07/12/2023 11:45:00 AM	FAILING TO YIELD RIGHT-OF-WAY	WEATHER	1649	W	JONQUIL TER	2422	nan	nan	nan	nan	nan	nan	2	NO INDICATION OF INJURY	2	11	4	7	42.021069763	-87.672691724	POINT (-87.672691723918 42.021069763335)


CREATE TABLE traffic_crashes_crashes (
  "crash_record_id" VARCHAR,
  "rd_no" 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
);