Skip to the content.

Data Sources — dui-by-state

All data used in this project is from official U.S. government sources or hand-curated from those same sources. No data is sourced from Wikipedia or other crowd-edited references.


State Reference Data

State FIPS Codes & Abbreviations

State Geographic Reference (lat/lng centroids, land area, Census region/division)

State Population Estimates


DUI / Traffic Safety Data

NHTSA FARS — Fatality Analysis Reporting System (2015–2024)

NHTSA Traffic Safety Facts — State Alcohol-Impaired-Driving Estimates


DUI Laws & Penalties

NCSL — Per Se DUI/DWI Laws

roadlawguide.com — DUI Penalties by State

ailawyer.pro — DUI Penalties by State


DUI Arrests

FBI UCR — Arrests by Age, Sex, and Race, Summarized Yearly, 2023


Alcohol Consumption

NIAAA — Apparent Per Capita Alcohol Consumption by State (2022)


NHTSA Imputed Alcohol Fatality Estimates

NHTSA Traffic Safety Facts — State Alcohol-Impaired-Driving Estimates 2024


DUI Enforcement & Procedures

Sobriety Checkpoint Legality

NCSL — State Ignition Interlock Laws (All-Offender)

Open Container Laws

BAC Limits


Notes on Data Quality & Verification

Methodology & definitions — the law-snapshot sources

Most of the law/penalty/enforcement tables below (NCSL per se laws, NCSL IID laws, roadlawguide, ailawyer, IIHS speed limits, NASID enforcement, checkpoint legality, implied-consent, open-container, body-cam, vehicle impound) share the same profile, so their required fields are captured once here rather than repeated:

Series breaks that matter most for comparisons (quick reference)


Structural Controls (added for analysis depth)

FARS 2024 — Prior DWI Convictions & Crash Speed Limits

IIHS — Maximum Posted Speed Limits

FHWA — Vehicle Miles Traveled by State (2022)


BAC Testing Rates & Laws

FARS 2024 — BAC Testing Rates by State

State Mandatory BAC Testing Laws


DUI Enforcement Procedures (NASID)

NASID — State DUI Enforcement Laws Database


Source Provenance in DuckDB

Every table in data/project.duckdb has a corresponding entry in the _sources metadata table:

SELECT duckdb_table, source_name, methodology, series_breaks FROM _sources;

This table records, for every dataset loaded into the database: duckdb_table, source_name, url, license, notes, retrieved, and — so methodology travels with the data — methodology (how the source collects and defines the data) and series_breaks (boundaries across which the numbers are NOT comparable). The two most important flags recorded there: FARS raw DRUNK_DR vs the NHTSA imputed BAC≥0.08 series (different measures), and the FBI UCR SRS→NIBRS break at Jan 1, 2021. Keep these in sync with the per-source sections above.


Body-Worn Camera Laws

NCSL Body-Worn Camera Laws Database


Vehicle Impound / Seizure / Forfeiture Laws

Vehicle Sanctions by State