docs/us_health/health_mortality_violence_county_year

health_mortality_violence_county_year

Violence and injury mortality time series. NHTSA FARS county-year crash fatalities (spine) joined with CHR 2025 firearm death rate (snapshot). Crash count and fatality count both exposed; crude rate requires population join.

tier aadmin_record

grain

county-year

years

2014 – 2025

cadence

Annual (FARS ~12-18 months after year end; CHR annual)

overview

2,836 county-year rows. NHTSA FARS captures all crash fatalities; CHR firearm covers all counties (subject to suppression).

current vintage — FARS 2023; CHR 2025

history — FARS: 1975-present; CHR firearm: 2010-present

provenance

source & licensing

authority

U.S. Department of Transportation|UWPHI

dataset

NHTSA FARS + County Health Rankings 2025

source url

https://www.nhtsa.gov/research-data/fatality-analysis-reporting-system-fars

methodology

https://www-fars.nhtsa.dot.gov/Help/HelpAuxiliary.aspx%20+%20https://www.countyhealthrankings.org/health-data/methodology-and-sources

license

Public domain (NHTSA); Creative Commons Attribution 4.0 (CHR)

citation

U.S. Department of Transportation, NHTSA. Fatality Analysis Reporting System (FARS), 2014-2023; County Health Rankings 2025.

schema

fields

name	type	definition
_ingested_at	timestamp	Timestamp when this record was written to BigQuery.Pipeline metadata field.
country_id	string	ISO alpha-2 country code (always 'US' for domestic tables).
county_idkey	string	5-character FIPS code identifying the county.Joins dim.counties on county_id.
crash_count	int64 · count	Total number of motor vehicle crashes recorded in the county during the year. Higher values indicate greater crash incidence.
crash_fatalities	int64 · count	Number of deaths resulting from motor vehicle crashes in the county during the year. Higher values indicate greater crash-related mortality burden.
firearm_deaths_per_100k	float64 · rate per 100k	Age-adjusted rate of firearm-related deaths per 100,000 residents in the county during the year, encompassing homicides, suicides, and unintentional firearm deaths. Higher values indicate greater firearm mortality burden.
state_id	string	2-character FIPS code identifying the state.Joins dim.states on state_id.
yearkey	int64	Reference year of the observation.

relationships

joins

primary key

county_id, year

common joins

dim.geographies on county_id

demographics_population_county_year on (county_id, year)

health_mortality_overall_county_year on (county_id, year)

usage

how to use this table

method

FARS is a complete administrative census of fatal motor-vehicle crashes. CHR firearm death rate from CDC WONDER. Crash count and crude rate exposed; per-capita requires population join.

do not use for

Non-fatal crashes (FARS is fatal only); intent decomposition for firearms (CHR aggregates suicide + homicide + accident); current year (lag).

known issues

Crude rates only - for age-adjusted use CDC WONDER directly. FARS county based on crash location (not victim residence).

← previousus_health.health_mortality_overall_county_year next →us_health.health_substance_use_county_year

last updated · May 5, 2026