Vital Signs: Fatalities From Crashes – By Case (2022) DRAFT
data.bayareametro.gov | Last Updated 11 Dec 2022VITAL SIGNS INDICATOR Fatalities From Crashes (EN4-6) FULL MEASURE NAME Fatalities from crashes (traffic collisions) LAST UPDATED May 2022 DESCRIPTION Fatalities from crashes refers to deaths as a result of injuries sustained in collisions. The California Highway Patrol includes deaths within 30 days of the collision that are a result of injuries sustained as part of this metric. This total fatalities dataset includes fatality counts for the region and counties, as well as individual collision data and metropolitan area data. DATA SOURCE National Highway Safety Administration: Fatality Analysis Reporting System CONTACT INFORMATION vitalsigns.info@bayareametro.gov METHODOLOGY NOTES (across all datasets for this indicator) The data is reported by the California Highway Patrol (CHP) to the Statewide Integrated Traffic Records System (SWITRS), which was accessed via SafeTREC’s Transportation Injury Mapping System (TIMS). The data was tabulated using provided categories specifying injury level, individuals involved, causes of collision, and location/jurisdiction of collision (for more: http://tims.berkeley.edu/help/files/switrs_codebook.doc). For more regarding reporting procedures and injury classification, see the California Highway Patrol Manual (https://one.nhtsa.gov/nhtsa/stateCatalog/states/ca/docs/CA_CHP555_Manual_2_2003_ch1-13.pdf).
This dataset has the following 64 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| objectid | objectid | number | 0 1 2 3 5678 view top 100 | |
| Case_Id | case_id | text | Case Id | 2010-0000000000004392052 2010-0000000000004392133 2010-0000000000004392143 2010-0000000000004392207 2010-0000000000004392277 view top 100 |
| Accident_Year | accident_year | number | Accident Year | 2020 2015 2019 2018 2016 view top 100 |
| Alcohol_Involved | alcohol_involved | text | Alcohol Involved | Y view top 100 |
| Bicycle_Accident | bicycle_accident | text | Bicycle Accident | Y view top 100 |
| Collision_Date | collision_date | text | Collision Date | 2021-04-17 2020-02-21 2018-10-30 2017-05-22 2018-11-24 view top 100 |
| Collision_Severity | collision_severity | number | Collision Severity | 1 view top 100 |
| Collision_Time | collision_time | number | Collision Time | 2500 1500 150 1730 2130 view top 100 |
| Control_Device | control_device | text | Control Device | D A - B C view top 100 |
| Count_Bicyclist_Injured | count_bicyclist_injured | number | Count Bicyclist Injured | 0 1 3 view top 100 |
| Count_Bicyclist_Killed | count_bicyclist_killed | number | Count Bicyclist Killed | 0 1 2 view top 100 |
| Count_Complaint_Pain | count_complaint_pain | number | Count Complaint Pain | 0 1 2 3 4 view top 100 |
| Count_Mc_Injured | count_mc_injured | text | Count Mc Injured | 0 1 2 view top 100 |
| Count_Mc_Killed | count_mc_killed | number | Count Mc Killed | 0 1 2 view top 100 |
| Count_Ped_Injured | count_ped_injured | number | Count Ped Injured | 0 1 2 3 5 view top 100 |
| Count_Ped_Killed | count_ped_killed | number | Count Ped Killed | 0 1 2 view top 100 |
| Count_Severe_Inj | count_severe_inj | number | Count Severe Injuries | 0 1 2 3 4 view top 100 |
| Count_Visible_Inj | count_visible_inj | number | Count Visible Injuries | 0 1 2 3 4 view top 100 |
| count_passenger_killed | count_passenger_killed | number | Count of passengers killed | 1.0 2.0 0.0 3.0 4.0 view top 100 |
| count_other_killed | count_other_killed | number | Count of other persons killed | 0.0 1.0 view top 100 |
| Accidentdisplaycolor | accidentdisplaycolor | text | Accidentdisplaycolor | Motorist Injury Pedestrian Injury Bicyclist Injury view top 100 |
| Day_Of_Week | day_of_week | number | Day Of Week | 6 7 5 3 4 view top 100 |
| Direction | direction | text | Direction | S N E W view top 100 |
| Distance | distance | number | Distance | 0.0 1056.0 1584.0 2640.0 2112.0 view top 100 |
| Hit_And_Run | hit_and_run | text | Hit And Run | N F M view top 100 |
| Intersection | intersection | text | Intersection | N Y - view top 100 |
| Lighting | lighting | text | Lighting | A C D B E view top 100 |
| Location_Type | location_type | text | Location Type | H R I view top 100 |
| Motorcycle_Accident | motorcycle_accident | text | Motorcycle Accident | Y view top 100 |
| Mviw | mviw | text | Mviw | C B I G A view top 100 |
| Number_Injured | number_injured | number | Number Injured | 0.0 1.0 2.0 3.0 4.0 view top 100 |
| Number_Killed | number_killed | number | Number Killed | 1.0 2.0 3.0 4.0 5.0 view top 100 |
| Number_Of_Records | number_of_records | number | Number Of Records | 1 view top 100 |
| Party_Count | party_count | text | Party Count | 2 1 3 4 5 view top 100 |
| Pcf_Code_Of_Viol | pcf_code_of_viol | text | Pcf Code Of Viol | - I view top 100 |
| Pcf_Violation | pcf_violation | text | Pcf Violation | 23152.0 22107.0 22350.0 21954.0 21950.0 view top 100 |
| Pcf_Viol_Category | pcf_viol_category | text | Pcf Viol Category | 01 08 03 11 10 view top 100 |
| Pcf_Viol_Subsection | pcf_viol_subsection | text | Pcf Viol Subsection | A B F C G view top 100 |
| Pedestrian_Accident | pedestrian_accident | text | Pedestrian Accident | Y view top 100 |
| Ped_Action | ped_action | text | Ped Action | A E D B F view top 100 |
| Postmile | postmile | text | Postmile | 5.044 1.91 2.57 6.94 3.206 view top 100 |
| Postmile_Prefix | postmile_prefix | text | Postmile Prefix | - R M T D view top 100 |
| Primary_Coll_Factor | primary_coll_factor | text | Primary Coll Factor | A D C - B view top 100 |
| Primary_Rd | primary_rd | text | Primary Rd | RT 101 RT 80 US-101 N/B I-80 E/B RT 880 view top 100 |
| Ramp_Intersection | ramp_intersection | text | Ramp Intersection | - 5 2 4 6 view top 100 |
| Road_Cond_1 | road_cond_1 | text | Road Condition 1 | H D - G C view top 100 |
| Road_Cond_2 | road_cond_2 | text | Road Condition 2 | - H E G D view top 100 |
| Road_Surface | road_surface | text | Road Surface | A B - D view top 100 |
| Route_Suffix | route_suffix | text | Route Suffix | - view top 100 |
| Secondary_Rd | secondary_rd | text | Seconditionary Rd | 7TH ST MIDWAY RD MARKET ST 1ST ST OAK ST view top 100 |
| Side_Of_Hwy | side_of_hwy | text | Side Of Hwy | S N E W view top 100 |
| State_Hwy_Ind | state_hwy_ind | text | State Hwy Ind | N Y view top 100 |
| State_Route | state_route | text | State Route | 101.0 80.0 880.0 580.0 680.0 view top 100 |
| Stwd_Vehtype_At_Fault | stwd_vehtype_at_fault | text | Stwd Vehtype At Fault | A N - C D view top 100 |
| Tow_Away | tow_away | text | Tow Away | Y N view top 100 |
| Truck_Accident | truck_accident | text | Truck Accident | Y view top 100 |
| Type_Of_Collision | type_of_collision | text | Type Of Collision | E G D C A view top 100 |
| Weather_1 | weather_1 | text | Weather 1 | A B C E - view top 100 |
| Weather_2 | weather_2 | text | Weather 2 | - C G F B view top 100 |
| County | county | text | County | Santa Clara Alameda Contra Costa Sonoma Solano view top 100 |
| Longitudefixed | longitudefixed | number | Longitudefixed | -122.25627136230467 -122.18744659423828 -122.50009 -122.29368 -122.24757 view top 100 |
| Latitude | latitude | number | Latitude | 38.137428283691406 37.606060028076165 36.92852 37.29778001 37.4258 view top 100 |
| City | city | text | City | Unincorporated San Jose San Francisco Oakland Fremont view top 100 |
| geometry | geometry | point | view top 100 |