Vital Signs: Fatalities From Crashes – By Case (2022) DRAFT

VITAL 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).

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"bayareametro-gov/vital-signs-fatalities-from-crashes-by-case-2022-g4wv-gwue\".\"vital_signs_fatalities_from_crashes_by_case_2022\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.