Traffic Crashes - Vehicles

City of Chicago

@usgov.city_of_chicago_traffic_crashes_vehicles

Table List

1 table(175.71 MB)

Table 1

@usgov.city_of_chicago_traffic_crashes_vehicles.table_1

175.71 MB
1919788 rows
71 columns

crash_unit_id CRASH UNIT ID	crash_record_id CRASH RECORD ID	crash_date CRASH DATE	unit_no UNIT NO	unit_type UNIT TYPE	num_passengers NUM PASSENGERS	vehicle_id VEHICLE ID	make MAKE	model MODEL	lic_plate_state LIC PLATE STATE	vehicle_year VEHICLE YEAR	vehicle_defect VEHICLE DEFECT	vehicle_type VEHICLE TYPE	vehicle_use VEHICLE USE	travel_direction TRAVEL DIRECTION	maneuver MANEUVER	towed_i TOWED I	occupant_cnt OCCUPANT CNT	towed_by TOWED BY	area_00_i AREA 00 I	area_01_i AREA 01 I	area_02_i AREA 02 I	area_03_i AREA 03 I	area_04_i AREA 04 I	area_05_i AREA 05 I	area_06_i AREA 06 I	area_07_i AREA 07 I	area_08_i AREA 08 I	area_09_i AREA 09 I	area_10_i AREA 10 I	area_11_i AREA 11 I	area_12_i AREA 12 I	area_99_i AREA 99 I	first_contact_point FIRST CONTACT POINT
10	2e31858c0e411f0bdcb337fb7c415aa93763cf2f23e02fb278e2ed4cf855d36c5a83f270e6f2e0e234ec48b4a0e55a2c51e37b0d40677392c25079c51727a57f	08/04/2015 12:40:00 PM	1	DRIVER		10	FORD	Focus	IL	2001	NONE	PASSENGER	PERSONAL	N	TURNING LEFT		1		N	Y	Y						Y						FRONT
100	e73b35bd7651b0c6693162bee0666db159b2890143700936741e9ad9cfc1b0d7f71c0f63dc0594ecdd6fd2183fa2dcd67dfa76a4799839a00a81bc45e3966bb1	07/31/2015 05:50:00 PM	1	DRIVER		96	NISSAN	Pathfinder	IL	1999	NONE	SPORT UTILITY VEHICLE (SUV)	PERSONAL	E	STRAIGHT AHEAD		1			Y													FRONT
1000	f2b1adeb85a15112e4fb7db74bff440d6ca53ff7a21e10490081685db85460a53c0f3d52dc0e181e69348053ef3198dccbc24e01df9179e42331bc4345e6f28d	09/02/2015 11:45:00 AM	1	DRIVER		954	FORD	F150	KS		UNKNOWN	VAN/MINI-VAN	UNKNOWN/NA	W	STRAIGHT AHEAD		1															Y	FRONT
10000	15a3e24fce3ce7cd2b02d44013d1a93ff2fbdca80632ecca87150673b21e819bd8649e309f867728fd25a9a9fcb6f0f2c00c42ab6733e4d6945262dbe6c90c0e	10/31/2015 09:30:00 PM	2	DRIVER		9561	HYUNDAI	SONATA		2011	NONE	PASSENGER	PERSONAL	E	SLOW/STOP IN TRAFFIC		1																REAR
100000	1d3c178880366c77deaf06b8c3198429112a1c8e8807ed95cea7b44e891a873df5b99852206a32d25fe2ede813c2149f25a43b7d2d3e1cc24b62fa437abd638f	11/16/2016 01:00:00 PM	2	PARKED		96745	TOYOTA MOTOR COMPANY, LTD.	RAV4 (sport utility)	IL	2001	UNKNOWN	SPORT UTILITY VEHICLE (SUV)	NOT IN USE	S	PARKED				N	Y				Y									UNKNOWN
1000001	57945047eb951f4152fde013708fa029caf5d33fc2a2c2ae6754a86c601c88afb88c5e16cbbbdb3e1d0b533c57ca81b420da284a20c1a05c86fa4c61ad779694	11/25/2020 05:46:00 PM	1	DRIVER		947651	DODGE	OTHER (EXPLAIN IN NARRATIVE)	XX		UNKNOWN	PICKUP	UNKNOWN/NA	N	SKIDDING/CONTROL LOSS		1															Y	FRONT-LEFT-CORNER
1000002	57945047eb951f4152fde013708fa029caf5d33fc2a2c2ae6754a86c601c88afb88c5e16cbbbdb3e1d0b533c57ca81b420da284a20c1a05c86fa4c61ad779694	11/25/2020 05:46:00 PM	2	DRIVER	1	947660	SUBARU	FORESTER	IL	2020	UNKNOWN	PASSENGER	PERSONAL	S	STRAIGHT AHEAD		2								Y	Y	Y	Y	Y	Y			SIDE-LEFT-FRONT
1000003	7cf1e0da7413f35c258ad67a3f0d08b10c9cf94a59bb4efd36bd9d10411e4434402b4fa40e718bdefc0da17b0d93b9f77b191d084cb6d884fbb0bccad8896a51	11/25/2020 06:39:00 PM	1	DRIVER		947657	HONDA	CIVIC	IL	2017	UNKNOWN	PASSENGER	UNKNOWN/NA	S	UNKNOWN/NA	Y	1			Y	Y	Y									Y		FRONT-RIGHT-CORNER
1000004	7cf1e0da7413f35c258ad67a3f0d08b10c9cf94a59bb4efd36bd9d10411e4434402b4fa40e718bdefc0da17b0d93b9f77b191d084cb6d884fbb0bccad8896a51	11/25/2020 06:39:00 PM	2	PARKED		947665	FORD	FOCUS	IL	2020	UNKNOWN	PASSENGER	PERSONAL	S	PARKED										Y	Y	Y	Y					SIDE-LEFT-REAR
1000005	7cf1e0da7413f35c258ad67a3f0d08b10c9cf94a59bb4efd36bd9d10411e4434402b4fa40e718bdefc0da17b0d93b9f77b191d084cb6d884fbb0bccad8896a51	11/25/2020 06:39:00 PM	3	DRIVER		947670	SUBARU	FORESTER	IL	2017	UNKNOWN	SPORT UTILITY VEHICLE (SUV)	PERSONAL	S	UNKNOWN/NA	Y	1	private tow					Y	Y	Y	Y			Y	Y	Y		REAR


CREATE TABLE table_1 (
  "crash_unit_id" BIGINT,
  "crash_record_id" VARCHAR,
  "crash_date" VARCHAR,
  "unit_no" BIGINT,
  "unit_type" VARCHAR,
  "num_passengers" DOUBLE,
  "vehicle_id" DOUBLE,
  "cmrc_veh_i" VARCHAR,
  "make" VARCHAR,
  "model" VARCHAR,
  "lic_plate_state" VARCHAR,
  "vehicle_year" DOUBLE,
  "vehicle_defect" VARCHAR,
  "vehicle_type" VARCHAR,
  "vehicle_use" VARCHAR,
  "travel_direction" VARCHAR,
  "maneuver" VARCHAR,
  "towed_i" VARCHAR,
  "fire_i" VARCHAR,
  "occupant_cnt" DOUBLE,
  "exceed_speed_limit_i" VARCHAR,
  "towed_by" VARCHAR,
  "towed_to" VARCHAR,
  "area_00_i" VARCHAR,
  "area_01_i" VARCHAR,
  "area_02_i" VARCHAR,
  "area_03_i" VARCHAR,
  "area_04_i" VARCHAR,
  "area_05_i" VARCHAR,
  "area_06_i" VARCHAR,
  "area_07_i" VARCHAR,
  "area_08_i" VARCHAR,
  "area_09_i" VARCHAR,
  "area_10_i" VARCHAR,
  "area_11_i" VARCHAR,
  "area_12_i" VARCHAR,
  "area_99_i" VARCHAR,
  "first_contact_point" VARCHAR,
  "cmv_id" DOUBLE,
  "usdot_no" VARCHAR,
  "ccmc_no" VARCHAR,
  "ilcc_no" VARCHAR,
  "commercial_src" VARCHAR,
  "gvwr" VARCHAR,
  "carrier_name" VARCHAR,
  "carrier_state" VARCHAR,
  "carrier_city" VARCHAR,
  "hazmat_placards_i" VARCHAR,
  "hazmat_name" VARCHAR,
  "un_no" VARCHAR,
  "hazmat_present_i" VARCHAR,
  "hazmat_report_i" VARCHAR,
  "hazmat_report_no" VARCHAR,
  "mcs_report_i" VARCHAR,
  "mcs_report_no" VARCHAR,
  "hazmat_vio_cause_crash_i" VARCHAR,
  "mcs_vio_cause_crash_i" VARCHAR,
  "idot_permit_no" VARCHAR,
  "wide_load_i" VARCHAR,
  "trailer1_width" VARCHAR,
  "trailer2_width" VARCHAR,
  "trailer1_length" DOUBLE,
  "trailer2_length" DOUBLE,
  "total_vehicle_length" DOUBLE,
  "axle_cnt" DOUBLE,
  "vehicle_config" VARCHAR,
  "cargo_body_type" VARCHAR,
  "load_type" VARCHAR,
  "hazmat_out_of_service_i" VARCHAR,
  "mcs_out_of_service_i" VARCHAR,
  "hazmat_class" VARCHAR
);