Readme
Updated over 1 year ago
‧ Indexed 2 hours ago
Tacoma Traffic Collision Data 2010-
All collisions within the City boundaries from 2010-Q22019. 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
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| TOTAL PEDESTRIANS INVOLVED | total_pedestrians_involved | total_pedestrians_involved | Number | |
| Report Number | report_number | report_number | Text | Unique identifier for all collisions |
| TOTAL BICYCLISTS INVOLVED | total_bicyclists_involved | total_bicyclists_involved | Number | |
| Bicyclist 2 action | bicyclist2_action | bicyclist2_action | Text | Action of bicyclist 2 |
| Bicyclist 1 action | bicyclist1_action | bicyclist1_action | Text | Action of bicyclist 1 |
| New Georeferenced Column | geocoded_column | geocoded_column | Point | |
| Hit and Run | hit_and_run | hit_and_run | Checkbox | |
| DATE | date | date | Calendar date | |
| 24 Hr Time | _24_hr_time | _24_hr_time | Text | |
| Total Evident Injuries | total_evident_injuries | total_evident_injuries | Number | |
| TOTAL PEDESTRIANS AND BICYCLISTS INVOLVED | total_pedestrians_and_bicyclists_involved | total_pedestrians_and_bicyclists_involved | Number | |
| Hour of Day | hour_of_day | hour_of_day | Number | Shows time just as the hour. |
| Total Serious Injuries | total_serious_injuries | total_serious_injuries | Number | |
| Collision Involving School-Aged Pedestrian or Bicyclist | collision_involving_school_aged_pedestrian_or_bicycalist | collision_involving_school_aged_pedestrian_or_bicycalist | Text | |
| ROAD SURFACE CONDITIONS | road_surface_conditions | road_surface_conditions | Text | |
| LIGHTING CONDITIONS | lighting_conditions | lighting_conditions | Text | |
| Day of Week | day_of_week | day_of_week | Point | Day of the week displayed as number Monday=1, Sunday= 7 |
| School Hours | school_hours | school_hours | Checkbox | School hours are interpreted as occurring between 7am and 5pm. |
| Most Severe sobriety type | most_severe_sobriety_type | most_severe_sobriety_type | Text | Indicates the state of sobriety for the driver. |
| Bicyclist 3 action | bicyclist3_action | bicyclist3_action | Text | Action of bicyclist 3 |
| Zip Codes | :@computed_region_29ft_c7g5 | :@computed_region_29ft_c7g5 | Number | |
| New Georeferenced Column_1 | geocoded_column_1 | geocoded_column_1 | Point | |
| TOTAL FATALITIES | total_fatalities | total_fatalities | Number | |
| Collision Involving Pedestrian or Bicyclist | collision_involving_pedestrian_or_bicyclist | collision_involving_pedestrian_or_bicyclist | Checkbox | |
| Pedestrian 2 action | pedestrian2_action | pedestrian2_action | Text | Action of pedestrian 2 |
| Pedestrian 1 action | pedestrian1_action | pedestrian1_action | Text | action of pedestrian 1 |
| vehicle 3 action | vehicle_3_action | vehicle_3_action | Text | action of vehicle 3 |
| vehicle 2 action | vehicle2_action | vehicle2_action | Text | Action of vehicle 2 |
| vehicle 1 action | vehicle_1_action | vehicle_1_action | Text | action of vehicle 1 |
| Junction Relationship | junction_relationship | junction_relationship | Text | Collision relationship to junction. |
| MOST SEVERE INJURY TYPE | most_severe_injury_type | most_severe_injury_type | Text | |
| Incident | incident_ | incident_ | Number | Each row represents 1 incident. |
| WEATHER | weather | weather | Text | |
| Age Between 5 and 18 | age_between_5_and_18 | age_between_5_and_18 | Checkbox | Indicates if the pedestrian or bicyclist involved was between the ages of 5 and 18. |
| Year | year | year | Text | Year of collision |
| Total Possible Injuries | total_possible_injuries | total_possible_injuries | Number |
Upstream Metadata