About this Dataset

Crash Details Table

A companion table for the Crashes in DC layer. This is a related table linked by field attribution, 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.

Crash details related table,

Type of participant (driver, occupant, bicyclist, pedestrian)
Age of participants
If injured, severity (minor, major, fatal)
Type of vehicle (passenger car, large truck, taxi, government, bicycle, pedestrian, etc)
If persons issued a ticket
If a vehicle, the state (jurisdiction) license plate was issued (not license plate number)
Are any persons deemed ‘impaired’
Was person in vehicle where speeding was indicated

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:15.711671
Tags: accidents, bike, crash, crashes, dc, ddot, district-of-columbia, fatality, injuries, pedestrian, vehicle, vision-zero, washington-dc

Tables

Table 1

@usgov.district_of_columbia_crash_details_table.table_1

30.29 MB
850,947 rows
15 columns

CREATE TABLE table_1 (
  "crimeid" BIGINT,
  "ccn" VARCHAR,
  "personid" BIGINT,
  "persontype" VARCHAR,
  "age" DOUBLE,
  "fatal" VARCHAR,
  "majorinjury" VARCHAR,
  "minorinjury" VARCHAR,
  "vehicleid" VARCHAR,
  "invehicletype" VARCHAR,
  "ticketissued" VARCHAR,
  "licenseplatestate" VARCHAR,
  "impaired" VARCHAR,
  "speeding" VARCHAR,
  "objectid" BIGINT
);