NYC Traffic Accidents

Navigating the Chaos: Understanding the Dynamics of NYC Traffic Accidents

@kaggle.amanaayush_nyc_traffic_accidents

Nyc Collisions Data Dictionary

@kaggle.amanaayush_nyc_traffic_accidents.nyc_collisions_data_dictionary

field Field	description Description
Collision ID	Unique record code generated by system
Date	Occurrence date of collision
Time	Occurrence time of collision
Borough	Borough where collision occurred
Street Name	Street on which the collision occurred
Cross Street	Nearest cross street to the collision
Latitude	Latitude coordinate for Global Coordinate System WGS 1984 decimal degrees (EPSG 4326)
Longitude	Longitude coordinate for Global Coordinate System WGS 1984 decimal degrees (EPSG 4326)
Contributing Factor	Factors contributing to the collision for designated vehicle
Vehicle Type	Type of vehicle


CREATE TABLE nyc_collisions_data_dictionary (
  "field" VARCHAR,
  "description" VARCHAR
);