NYC Traffic Accidents

CREATE TABLE nyc_collisions (
  "collision_id" BIGINT,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "borough" VARCHAR,
  "street_name" VARCHAR,
  "cross_street" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "contributing_factor" VARCHAR,
  "vehicle_type" VARCHAR,
  "persons_injured" DOUBLE,
  "persons_killed" BIGINT,
  "pedestrians_injured" BIGINT,
  "pedestrians_killed" BIGINT,
  "cyclists_injured" BIGINT,
  "cyclists_killed" BIGINT,
  "motorists_injured" BIGINT,
  "motorists_killed" BIGINT
);