Dataset: Motor Vehicle Collisions

About this Dataset

Motor Vehicle Collisions

The Motor Vehicle Collisions crash table contains details on the crash event. Each row represents a crash event. The Motor Vehicle Collisions data tables contain information from all police reported motor vehicle collisions in NYC. The police report (MV104-AN) is required to be filled out for collisions where someone is injured or killed, or where there is at least $1000 worth of damage.

Tables

Motor Vehicle Collisions Crashes

@kaggle.utkarshx27_motor_vehicle_collisions.motor_vehicle_collisions_crashes

68.27 MB
1987321 rows
29 columns


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
);