cityoftacoma/collisions-in-tacoma-a332-kmh3
Icon for Socrata external plugin
 
Readme
Updated over 2 years ago
Indexed 2 hours ago

Collisions in Tacoma

All collisions within the City boundaries from 2010-Q42018. Data is from WSDOT.

Federal highway safety laws require the state to create this crash database for use in obtaining federal safety improvement funds. Under Section 409 of Title 23 of the United States Code, crash data is prohibited from use in any litigation against state, tribal or local government that involves the location(s) mentioned in the crash data.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Day_of_Weekday_of_weekday_of_weekNumberDay of the week displayed as number Monday=1, Sunday= 7
Hour_of_Dayhour_of_dayhour_of_dayNumberShows time just as the hour.
TOTAL SERIOUS INJURIEStotal_serious_injuriestotal_serious_injuriesNumber
TOTAL FATALITIEStotal_fatalitiestotal_fatalitiesNumber
Zip Codes:@computed_region_29ft_c7g5:@computed_region_29ft_c7g5Number
24 HR TIME_24_hr_time_24_hr_timeText
DATEdatedateCalendar date
Ped_Bike Age 5_18ped_bike_age_5_18ped_bike_age_5_18CheckboxIndicates if the pedestrian or bicyclist involved was between the ages of 5 and 18.
REPORT NUMBERreport_numberreport_numberTextUnique identifier for all collisions
Tacoma Police Sector Shape Map:@computed_region_vdmk_m8s5:@computed_region_vdmk_m8s5Number
Tacoma Neighborhood Council District Shape Map:@computed_region_rrmn_rvi4:@computed_region_rrmn_rvi4Number
IncidentincidentincidentNumberIndicates every row is one incident.
TOTAL PEDESTRIANS INVOLVEDtotal_pedestrians_involvedtotal_pedestrians_involvedNumber
School_Hoursschool_hoursschool_hoursCheckboxSchool hours are interpreted as occurring between 7am and 5pm.
HIT & RUNhit_runhit_runCheckbox
TOTAL BICYCLISTS INVOLVEDtotal_bicyclists_involvedtotal_bicyclists_involvedNumber
ROAD SURFACE CONDITIONSroad_surface_conditionsroad_surface_conditionsText
LIGHTING CONDITIONSlighting_conditionslighting_conditionsText
MOST SEVERE SOBRIETY TYPEmost_severe_sobriety_typemost_severe_sobriety_typeTextIndicates the state of sobriety for the driver.
TOTAL EVIDENT INJURIEStotal_evident_injuriestotal_evident_injuriesNumber
Vehicle 1 Actionvehicle1_actionvehicle1_actionTextAction of Vehicle 1
unit 3 bike actionunit3_bike_actionunit3_bike_actionTextAction of bicyclist 3
Collision Involving School-Aged Pedestrian or Bicyclistcollision_involving_schoolcollision_involving_schoolCheckbox
Collision Involving Pedestrian or Bicyclistcollision_involving_pedestriancollision_involving_pedestrianCheckbox
YEARyearyearTextYear of collision
Junction relationshipjunction_relationshipjunction_relationshipTextCollision relationship to junction
TOTAL PEDESTRIANS AND BICYCLISTS INVOLVEDtotal_pedestrians_andtotal_pedestrians_andNumber
MOST SEVERE INJURY TYPEmost_severe_injury_typemost_severe_injury_typeText
WEATHERweatherweatherText
TOTAL POSSIBLE INJURIEStotal_possible_injuriestotal_possible_injuriesNumber
unit 2 bike actionunit2_bike_actionunit2_bike_actionTextAction of bicyclist 2
Unit 1 bike actionunit1_bike_actionunit1_bike_actionTextAction of bicyclist 1
unit 3 ped actionunit3_ped_actionunit3_ped_actionTextaction of ped 3
Unit 2 Ped Actionunit2_ped_actionunit2_ped_actionTextAction of Pedestrian 2
Vehicle 3 Actionvehicle_3_actionvehicle_3_actionTextAction of vehicle 3
Vehicle 2 Actionvehicle_2_actionvehicle_2_actionTextAction of vehicle 2
LocationlocationlocationPoint
 
Preview
  • collisions_in_tacoma
     
Upstream Metadata