Baselight

Crash Details Table

District of Columbia

@usgov.district_of_columbia_crash_details_table

Loading...
Loading...

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
  • 28.88 MB
  • 850947 rows
  • 15 columns
Loading...

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
);

Share link

Anyone who has the link will be able to view this.