Dataset: Chicago Car Crash Dataset

About this Dataset

Chicago Car Crash Dataset

This data, released on Data.gov contains all car crash data from 2001+ which happened in Chicago. The dataset contains the date of crash, the speed limit, the weather conditions, and much more.

Tables

Traffic Crashes Crashes

@kaggle.nathaniellybrand_chicago_car_crash_dataset.traffic_crashes_crashes

151.42 MB
746498 rows
49 columns


CREATE TABLE traffic_crashes_crashes (
  "crash_record_id" VARCHAR,
  "rd_no" VARCHAR,
  "crash_date_est_i" VARCHAR,
  "crash_date" VARCHAR,
  "posted_speed_limit" BIGINT,
  "traffic_control_device" VARCHAR,
  "device_condition" VARCHAR,
  "weather_condition" VARCHAR,
  "lighting_condition" VARCHAR,
  "first_crash_type" VARCHAR,
  "trafficway_type" VARCHAR,
  "lane_cnt" DOUBLE,
  "alignment" VARCHAR,
  "roadway_surface_cond" VARCHAR,
  "road_defect" VARCHAR,
  "report_type" VARCHAR,
  "crash_type" VARCHAR,
  "intersection_related_i" VARCHAR,
  "not_right_of_way_i" VARCHAR,
  "hit_and_run_i" VARCHAR,
  "damage" VARCHAR,
  "date_police_notified" VARCHAR,
  "prim_contributory_cause" VARCHAR,
  "sec_contributory_cause" VARCHAR,
  "street_no" BIGINT,
  "street_direction" VARCHAR,
  "street_name" VARCHAR,
  "beat_of_occurrence" DOUBLE,
  "photos_taken_i" VARCHAR,
  "statements_taken_i" VARCHAR,
  "dooring_i" VARCHAR,
  "work_zone_i" VARCHAR,
  "work_zone_type" VARCHAR,
  "workers_present_i" VARCHAR,
  "num_units" BIGINT,
  "most_severe_injury" VARCHAR,
  "injuries_total" DOUBLE,
  "injuries_fatal" DOUBLE,
  "injuries_incapacitating" DOUBLE,
  "injuries_non_incapacitating" DOUBLE,
  "injuries_reported_not_evident" DOUBLE,
  "injuries_no_indication" DOUBLE,
  "injuries_unknown" DOUBLE,
  "crash_hour" BIGINT,
  "crash_day_of_week" BIGINT,
  "crash_month" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);