Back to portfolio Read the notebook on GitHub

Napa County, California,

Napa County crashes

An analysis of crashes reported to the California Highway Patrol, looking at when crashes happen, how the yearly total has changed, and how often someone under the influence of alcohol or drugs was involved.

crashes in Napa County,

crashes, or , injured or killed at least one person

crashes, or , involved someone under the influence of alcohol or drugs

people killed, and injured

Time of day and day of week

On weekends, crashes are spread more evenly from late morning to nighttime.

Crashes by hour and day of week

The midnight hour is slightly inflated: some crashes with an unknown time are recorded as 12:00 a.m.

Show the data

Crashes involving someone under the influence

Share of crashes involving someone under the influence

  • Weekdays
  • Weekends
  • All crashes
Show the data

Crashes per year

Crashes per year

Show the data

Crash severity

Each crash is counted once, at its most severe outcome.

Crashes by most severe outcome

    About the data

    Records come from the California Crash Reporting System (CCRS), published by the California Highway Patrol on the California Open Data Portal. Statewide files for were loaded into PostgreSQL; filtered to Napa County; and cleaned and analyzed in SQL.

    "Under the influence" means at least one party in the crash, whether a driver, passenger, or cyclist, was recorded as under the influence of alcohol or drugs.

    Limitations

    • These are crash counts, not rates. The data has no traffic volumes.
    • Impairment is recorded by the officer at the scene, not confirmed by testing, and may be undercounted.
    • is a partial year, and recent records may still be revised.