About this Dataset

Crash Reporting - Drivers Data

This dataset provides information on motor vehicle operators (drivers) involved in traffic collisions occurring on county and local roadways. The dataset reports details of all traffic collisions occurring on county and local roadways within Montgomery County, as collected via the Automated Crash Reporting System (ACRS) of the Maryland State Police, and reported by the Montgomery County Police, Gaithersburg Police, Rockville Police, or the Maryland-National Capital Park Police. This dataset shows each collision data recorded and the drivers involved. Please note that these collision reports are based on preliminary information supplied to the Police Department by the reporting parties. Therefore, the collision data available on this web page may reflect: -Information not yet verified by further investigation -Information that may include verified and unverified collision data -Preliminary collision classifications may be changed at a later date based upon further investigation -Information may include mechanical or human error This dataset can be joined with the other 2 Crash Reporting datasets (see URLs below) by the State Report Number. * Crash Reporting - Incidents Data at https://data.montgomerycountymd.gov/Public-Safety/Crash-Reporting-Incidents-Data/bhju-22kf * Crash Reporting - Non-Motorists Data at https://data.montgomerycountymd.gov/Public-Safety/Crash-Reporting-Non-Motorists-Data/n7fk-dce5 Update Frequency : Weekly
Organization: Montgomery County of Maryland
Last updated: 2020-11-10T16:58:20.840660
Tags: accident, car, crash, driver, pedestrian, safety, traffic, visionzero

Tables

Table 1

@usgov.montgomery_county_of_maryland_crash_reporting_drivers_data.table_1

28.01 MB
195411 rows
39 columns


CREATE TABLE table_1 (
  "report_number" VARCHAR,
  "local_case_number" VARCHAR,
  "agency_name" VARCHAR,
  "acrs_report_type" VARCHAR,
  "crash_date_time" VARCHAR,
  "route_type" VARCHAR,
  "road_name" VARCHAR,
  "cross_street_name" VARCHAR,
  "off_road_description" VARCHAR,
  "municipality" VARCHAR,
  "related_non_motorist" VARCHAR,
  "collision_type" VARCHAR,
  "weather" VARCHAR,
  "surface_condition" VARCHAR,
  "light" VARCHAR,
  "traffic_control" VARCHAR,
  "driver_substance_abuse" VARCHAR,
  "non_motorist_substance_abuse" VARCHAR,
  "person_id" VARCHAR,
  "driver_at_fault" VARCHAR,
  "injury_severity" VARCHAR,
  "circumstance" VARCHAR,
  "driver_distracted_by" VARCHAR,
  "drivers_license_state" VARCHAR,
  "vehicle_id" VARCHAR,
  "vehicle_damage_extent" VARCHAR,
  "vehicle_first_impact_location" VARCHAR,
  "vehicle_body_type" VARCHAR,
  "vehicle_movement" VARCHAR,
  "vehicle_going_dir" VARCHAR,
  "speed_limit" BIGINT,
  "driverless_vehicle" VARCHAR,
  "parked_vehicle" VARCHAR,
  "vehicle_year" BIGINT,
  "vehicle_make" VARCHAR,
  "vehicle_model" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);