Name: NYC Motor Vehicle Collisions To Person
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

NYC Motor Vehicle Collisions To Person

Context

It is data of a collision accident between a person and a motor vehicle that occurred in New York in 2021. Only cases of injury or death over $1,000 were filtered out. The date and time of the incident, the location of the injury, and the police description of the incident are summarized.

Content

CRASH_DATE
CRASH_TIME
PERSON_INJURY : Injured, killed, unspecified
PERSON_AGE : Automatically calculated based on date of birth
BODILY_INJURY : Injured body area (i.e. head, face, neck, etc.)
SAFETY_EQUIPMENT : Safety equipment being used (i.e. lap belt, harness, child restraint, air bag, etc.)
PERSON_SEX
PERSON_TYPE : Bicyclist, Motor Vehicle Occupant, Pedestrian
PED_LOCATION : Location of the pedestrian (i.e. at intersection, not at intersection)
CONTRIBUTING_FACTOR_2 : Factors contributing to the collision for designated vehicle
EJECTION : Indicates the following: Not ejected, partially ejected, or ejected from the vehicle
COMPLAINT : Type of physical complaint (ex. Concussion, severe burn, severe bleeding, etc.)
EMOTIONAL_STATUS : Apparent death, unconscious, semiconscious, etc.
VEHICLE_ID : Unique vehicle record associated with person. Foreign Key to the vehicle table
PERSON_ID : Person identification code assigned by system
CONTRIBUTING_FACTOR_1 : Factors contributing to the collision for designated vehicle
POSITION_IN_VEHICLE : Seating position #1-#8 (i.e. driver, front passenger, etc.)
PED_ROLE : Pedestrian, witness, in-line skater, other, etc.
UNIQUE_ID : Unique record code generated by system. Primary Key for Person table.
PED_ACTION : What the pedestrian was doing at time of crash (i.e., walking with the signal, against the signal, etc.)
COLLISION_ID : Crash identification code. Foreign Key, matches unique_id from the Crash table.

Inspiration

Through EDA, you can check the characteristics of each traffic incident by date and by type of incident.

Source

https://data.cityofnewyork.us/

Tables

Nyc Motor Vehicle Collisions To Person

@kaggle.kukuroo3_nyc_motor_vehicle_collisions_to_person.nyc_motor_vehicle_collisions_to_person

2.66 MB
45669 rows
21 columns


CREATE TABLE nyc_motor_vehicle_collisions_to_person (
  "crash_date" TIMESTAMP,
  "crash_time" VARCHAR,
  "person_injury" VARCHAR,
  "person_age" DOUBLE,
  "bodily_injury" VARCHAR,
  "safety_equipment" VARCHAR,
  "person_sex" VARCHAR,
  "person_type" VARCHAR,
  "ped_location" VARCHAR,
  "contributing_factor_2" VARCHAR,
  "ejection" VARCHAR,
  "complaint" VARCHAR,
  "emotional_status" VARCHAR,
  "vehicle_id" DOUBLE,
  "person_id" VARCHAR,
  "contributing_factor_1" VARCHAR,
  "position_in_vehicle" VARCHAR,
  "ped_role" VARCHAR,
  "unique_id" BIGINT,
  "ped_action" VARCHAR,
  "collision_id" BIGINT
);