About this Dataset

NYC Traffic Accidents

Motor vehicle collisions reported by the New York City Police Department from January-August 2020. Each record represents an individual collision, including the date, time and location of the accident (borough, zip code, street name, latitude/longitude), vehicles and victims involved, and contributing factors.

Recommended Analysis

Compare the % of total accidents by month. Do you notice any seasonal patterns?

Break down accident frequency by day of week and hour of day. Based on this data, when do accidents occur most frequently?

On which particular street were the most accidents reported? What does that represent as a % of all reported accidents?

What was the most common contributing factor for the accidents reported in this sample (based on Vehicle 1)? What about for fatal accidents specifically?

Tables

Nyc Accidents 2020

@kaggle.mysarahmadbhat_nyc_traffic_accidents.nyc_accidents_2020

2.8 MB
74881 rows
29 columns


CREATE TABLE nyc_accidents_2020 (
  "crash_date" TIMESTAMP,
  "crash_time" VARCHAR,
  "borough" VARCHAR,
  "zip_code" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR,
  "on_street_name" VARCHAR,
  "cross_street_name" VARCHAR,
  "off_street_name" VARCHAR,
  "number_of_persons_injured" BIGINT,
  "number_of_persons_killed" BIGINT,
  "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
);