About this Dataset

Crashes In DC

Crashes on the roadway blocks network of Washington, DC maintained by the District Department of Transportation (DDOT). In addition to locations, a related table consisting of crash details is available for each crash. This table provides some anonymized information about each of the persons involved in the crash (linked by CRASHID). These crash data are derived from the Metropolitan Police Department's (MPD) crash data management system (COBALT) and represent DDOT's attempt to summarize some of the most requested elements of the crash data. Further, DDOT has attempted to enhance this summary by locating each crash location along the DDOT roadway block line, providing a number of location references for each crash. In the event that location data is missing or incomplete for a crash, it is unable to be published within this dataset.

Location points with some basic summary statistics,

The DC ward the crash occurred
Summary totals for: injuries (minor, major, fatal) by type (pedestrian, bicycle, car), mode of travel involved (pedestrian, bicycle, car), impaired participants (pedestrian, bicyclist, car passengers)
If speeding was involved
Nearest intersecting street name
Distance from nearest intersection
Cardinal direction from the intersection

Read more at https://ddotwiki.atlassian.net/wiki/spaces/GIS0225/pages/2053603429/Crash+Data. Questions on the contents of these layers should be emailed to Metropolitan Police Department or the DDOT Traffic Safety Division. Questions regarding the Open Data DC can be sent to @OpenDataDC

Organization: District of Columbia
Last updated: 2024-04-30T17:43:28.073794
Tags: accidents, bike, crash, dc, ddot, district-of-columbia, fatality, injuries, pedestrian, vehicle, vision-zero, washington-dc

Tables

Table 1

@usgov.district_of_columbia_crashes_in_dc.table_1

53.34 MB
329,669 rows
66 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "crimeid" BIGINT,
  "ccn" VARCHAR,
  "reportdate" TIMESTAMP,
  "routeid" VARCHAR,
  "measure" DOUBLE,
  "offset" DOUBLE,
  "streetsegid" DOUBLE,
  "roadwaysegid" DOUBLE,
  "fromdate" TIMESTAMP,
  "todate" VARCHAR,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "ward" VARCHAR,
  "eventid" VARCHAR,
  "mar_address" VARCHAR,
  "mar_score" DOUBLE,
  "majorinjuries_bicyclist" BIGINT,
  "minorinjuries_bicyclist" BIGINT,
  "unknowninjuries_bicyclist" BIGINT,
  "fatal_bicyclist" BIGINT,
  "majorinjuries_driver" BIGINT,
  "minorinjuries_driver" BIGINT,
  "unknowninjuries_driver" BIGINT,
  "fatal_driver" BIGINT,
  "majorinjuries_pedestrian" BIGINT,
  "minorinjuries_pedestrian" BIGINT,
  "unknowninjuries_pedestrian" BIGINT,
  "fatal_pedestrian" BIGINT,
  "total_vehicles" BIGINT,
  "total_bicycles" BIGINT,
  "total_pedestrians" BIGINT,
  "pedestriansimpaired" BIGINT,
  "bicyclistsimpaired" BIGINT,
  "driversimpaired" BIGINT,
  "total_taxis" BIGINT,
  "total_government" BIGINT,
  "speeding_involved" BIGINT,
  "nearestintrouteid" VARCHAR,
  "nearestintstreetname" VARCHAR,
  "offintersection" DOUBLE,
  "intapproachdirection" VARCHAR,
  "locationerror" VARCHAR,
  "lastupdatedate" TIMESTAMP,
  "mpdlatitude" DOUBLE,
  "mpdlongitude" DOUBLE,
  "mpdgeox" DOUBLE,
  "mpdgeoy" DOUBLE,
  "fatalpassenger" BIGINT,
  "majorinjuriespassenger" BIGINT,
  "minorinjuriespassenger" BIGINT,
  "unknowninjuriespassenger" BIGINT,
  "mar_id" BIGINT,
  "blockkey" VARCHAR,
  "subblockkey" VARCHAR,
  "corridorid" VARCHAR,
  "nearestintkey" VARCHAR,
  "majorinjuriesother" DOUBLE,
  "minorinjuriesother" DOUBLE,
  "unknowninjuriesother" DOUBLE,
  "fatalother" DOUBLE,
  "objectid" BIGINT
);