Dataset: Crash Reporting - Incidents Data

About this Dataset

Crash Reporting - Incidents Data

This dataset provides general information about each collision and 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. 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 - Drivers Data at https://data.montgomerycountymd.gov/Public-Safety/Crash-Reporting-Drivers-Data/mmzv-x632 * 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:11.082082
Tags: accident, car, crash, driver, pedestrian, safety, traffic, visionzero

Tables

Table 1

@usgov.montgomery_county_of_maryland_crash_reporting_incidents_data.table_1

8.72 MB
110769 rows
37 columns


CREATE TABLE table_1 (
  "report_number" VARCHAR,
  "local_case_number" VARCHAR,
  "agency_name" VARCHAR,
  "acrs_report_type" VARCHAR,
  "crash_date_time" VARCHAR,
  "hit_run" VARCHAR,
  "route_type" VARCHAR,
  "lane_direction" VARCHAR,
  "lane_type" VARCHAR,
  "number_of_lanes" VARCHAR,
  "direction" VARCHAR,
  "distance" DOUBLE,
  "distance_unit" VARCHAR,
  "road_grade" VARCHAR,
  "road_name" VARCHAR,
  "cross_street_name" VARCHAR,
  "off_road_description" VARCHAR,
  "municipality" VARCHAR,
  "related_non_motorist" VARCHAR,
  "at_fault" VARCHAR,
  "collision_type" VARCHAR,
  "weather" VARCHAR,
  "surface_condition" VARCHAR,
  "light" VARCHAR,
  "traffic_control" VARCHAR,
  "driver_substance_abuse" VARCHAR,
  "non_motorist_substance_abuse" VARCHAR,
  "first_harmful_event" VARCHAR,
  "second_harmful_event" VARCHAR,
  "junction" VARCHAR,
  "intersection_type" VARCHAR,
  "road_alignment" VARCHAR,
  "road_condition" VARCHAR,
  "road_division" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);