Motor Vehicle Collisions

New York City Vehicle Crash Data

@kaggle.utkarshx27_motor_vehicle_collisions

Table List

1 table(68.27 MB)

Motor Vehicle Collisions Crashes

@kaggle.utkarshx27_motor_vehicle_collisions.motor_vehicle_collisions_crashes

68.27 MB
1987321 rows
29 columns

crash_date CRASH DATE	crash_time CRASH TIME	borough BOROUGH	zip_code ZIP CODE	latitude LATITUDE	longitude LONGITUDE	location LOCATION	on_street_name ON STREET NAME	cross_street_name CROSS STREET NAME	off_street_name OFF STREET NAME	number_of_persons_injured NUMBER OF PERSONS INJURED	number_of_motorist_injured NUMBER OF MOTORIST INJURED	contributing_factor_vehicle_1 CONTRIBUTING FACTOR VEHICLE 1	contributing_factor_vehicle_2 CONTRIBUTING FACTOR VEHICLE 2	contributing_factor_vehicle_3 CONTRIBUTING FACTOR VEHICLE 3	contributing_factor_vehicle_4 CONTRIBUTING FACTOR VEHICLE 4	contributing_factor_vehicle_5 CONTRIBUTING FACTOR VEHICLE 5	collision_id COLLISION ID	vehicle_type_code_1 VEHICLE TYPE CODE 1	vehicle_type_code_2 VEHICLE TYPE CODE 2	vehicle_type_code_3 VEHICLE TYPE CODE 3	vehicle_type_code_4 VEHICLE TYPE CODE 4	vehicle_type_code_5 VEHICLE TYPE CODE 5
Sat Sep 11 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2:39	nan	nan			nan	WHITESTONE EXPRESSWAY	20 AVENUE	nan	2	2	Aggressive Driving/Road Rage	Unspecified	nan	nan	nan	4455765	Sedan	Sedan	nan	nan	nan
Sat Mar 26 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	11:45	nan	nan			nan	QUEENSBORO BRIDGE UPPER	nan	nan	1	1	Pavement Slippery	nan	nan	nan	nan	4513547	Sedan	nan	nan	nan	nan
Wed Jun 29 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	6:55	nan	nan			nan	THROGS NECK BRIDGE	nan	nan			Following Too Closely	Unspecified	nan	nan	nan	4541903	Sedan	Pick-up Truck	nan	nan	nan
Sat Sep 11 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	9:35	BROOKLYN	11208	40.667202	-73.8665	(40.667202, -73.8665)	nan	nan	1211 LORING AVENUE			Unspecified	nan	nan	nan	nan	4456314	Sedan	nan	nan	nan	nan
Tue Dec 14 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	8:13	BROOKLYN	11233	40.683304	-73.917274	(40.683304, -73.917274)	SARATOGA AVENUE	DECATUR STREET	nan			nan	nan	nan	nan	nan	4486609	nan	nan	nan	nan	nan
Wed Apr 14 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	12:47	nan	nan			nan	MAJOR DEEGAN EXPRESSWAY RAMP	nan	nan			Unspecified	Unspecified	nan	nan	nan	4407458	Dump	Sedan	nan	nan	nan
Tue Dec 14 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	17:05	nan	nan	40.709183	-73.956825	(40.709183, -73.956825)	BROOKLYN QUEENS EXPRESSWAY	nan	nan			Passing Too Closely	Unspecified	nan	nan	nan	4486555	Sedan	Tractor Truck Diesel	nan	nan	nan
Tue Dec 14 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	8:17	BRONX	10475	40.86816	-73.83148	(40.86816, -73.83148)	nan	nan	344 BAYCHESTER AVENUE	2	2	Unspecified	Unspecified	nan	nan	nan	4486660	Sedan	Sedan	nan	nan	nan
Tue Dec 14 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	21:10	BROOKLYN	11207	40.67172	-73.8971	(40.67172, -73.8971)	nan	nan	2047 PITKIN AVENUE			Driver Inexperience	Unspecified	nan	nan	nan	4487074	Sedan	nan	nan	nan	nan
Tue Dec 14 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	14:58	MANHATTAN	10017	40.75144	-73.97397	(40.75144, -73.97397)	3 AVENUE	EAST 43 STREET	nan			Passing Too Closely	Unspecified	nan	nan	nan	4486519	Sedan	Station Wagon/Sport Utility Vehicle	nan	nan	nan


CREATE TABLE motor_vehicle_collisions_crashes (
  "crash_date" TIMESTAMP,
  "crash_time" VARCHAR,
  "borough" VARCHAR,
  "zip_code" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR,
  "on_street_name" VARCHAR,
  "cross_street_name" VARCHAR,
  "off_street_name" VARCHAR,
  "number_of_persons_injured" DOUBLE,
  "number_of_persons_killed" DOUBLE,
  "number_of_pedestrians_injured" BIGINT,
  "number_of_pedestrians_killed" BIGINT,
  "number_of_cyclist_injured" BIGINT,
  "number_of_cyclist_killed" BIGINT,
  "number_of_motorist_injured" BIGINT,
  "number_of_motorist_killed" BIGINT,
  "contributing_factor_vehicle_1" VARCHAR,
  "contributing_factor_vehicle_2" VARCHAR,
  "contributing_factor_vehicle_3" VARCHAR,
  "contributing_factor_vehicle_4" VARCHAR,
  "contributing_factor_vehicle_5" VARCHAR,
  "collision_id" BIGINT,
  "vehicle_type_code_1" VARCHAR,
  "vehicle_type_code_2" VARCHAR,
  "vehicle_type_code_3" VARCHAR,
  "vehicle_type_code_4" VARCHAR,
  "vehicle_type_code_5" VARCHAR
);