About this Dataset

2023 Crash Data On State Highway System

The Crash Data On California State Highways Report is produced annually by the California Department of Transportation (Caltrans) to provide high level summaries of road miles, travel, crashes and crash rates on the California State Highway System.

This table lists statewide vehicle travel expressed in Million Vehicle Miles (MVM), road miles, and one and three year crash rates and fatality rates based on lane types and population codes.

While crash rates for total crash and fatal + injury crashes are calculated per MVM, fatality rates are expressed per 100 MVM.
Organization: State of California
Last updated: 2025-07-23T19:48:50.128028
Tags: 2023, california-department-of-transportation, california-state-transportation-agency, calsta, caltrans, caopendata, crash, transportation

Tables

Basic Average Crash Rate Table For Highways

@usgov.ca_gov_2023_crash_data_on_state_highway_system.basic_average_crash_rate_table_for_highways

11.79 kB
67 rows
12 columns

CREATE TABLE basic_average_crash_rate_table_for_highways (
  "rate_group" VARCHAR,
  "base_rate" DOUBLE,
  "adt_factor" VARCHAR,
  "pct_fat" DOUBLE,
  "pct_inj" DOUBLE,
  "pct_fat_plus_inj" DOUBLE,
  "highway_type" VARCHAR,
  "terrain_or_adt" VARCHAR,
  "design_speed" VARCHAR,
  "area" VARCHAR,
  "crash_costs_fat_plus_inj" DOUBLE,
  "crash_costs_all" DOUBLE
);

Basic Average Crash Rate Table For Intersections

@usgov.ca_gov_2023_crash_data_on_state_highway_system.basic_average_crash_rate_table_for_intersections

9.7 kB
31 rows
11 columns

CREATE TABLE basic_average_crash_rate_table_for_intersections (
  "rate_group" VARCHAR,
  "base_rate" DOUBLE,
  "adt_factor" BIGINT,
  "pct_fat" DOUBLE,
  "pct_inj" DOUBLE,
  "pct_fat_plus_inj" DOUBLE,
  "intersection_type" VARCHAR,
  "control_type" VARCHAR,
  "area" VARCHAR,
  "crash_costs_fat_plus_inj" DOUBLE,
  "crash_costs_all" DOUBLE
);

Basic Average Crash Rate Table For Ramps

@usgov.ca_gov_2023_crash_data_on_state_highway_system.basic_average_crash_rate_table_for_ramps

11.63 kB
80 rows
12 columns

CREATE TABLE basic_average_crash_rate_table_for_ramps (
  "rate_group" VARCHAR,
  "base_rate" DOUBLE,
  "adt_factor" BIGINT,
  "pct_fat" DOUBLE,
  "pct_inj" DOUBLE,
  "pct_fat_plus_inj" DOUBLE,
  "ramp_type" VARCHAR,
  "ramp_areas" VARCHAR,
  "on_off" VARCHAR,
  "area" VARCHAR,
  "crash_costs_fat_plus_inj" DOUBLE,
  "crash_costs_all" DOUBLE
);

Bicycle Fatality And Injury Data By County

@usgov.ca_gov_2023_crash_data_on_state_highway_system.bicycle_fatality_and_injury_data_by_county

5.76 kB
290 rows
5 columns

CREATE TABLE bicycle_fatality_and_injury_data_by_county (
  "county" VARCHAR,
  "highway_type" VARCHAR,
  "total" BIGINT,
  "fatality" BIGINT,
  "injury" BIGINT
);

California State Highways Statewide 5-Year Freeway Trend

@usgov.ca_gov_2023_crash_data_on_state_highway_system.california_state_highways_statewide_5_year_freeway_trend

10.38 kB
18 rows
12 columns

CREATE TABLE california_state_highways_statewide_5_year_freeway_trend (
  "year" VARCHAR,
  "rural_urban" VARCHAR,
  "road_miles" DOUBLE,
  "travel_mvm" BIGINT,
  "total_crashes" BIGINT,
  "pdo_crashes" BIGINT,
  "injury_crashes" BIGINT,
  "fatal_crashes" BIGINT,
  "victim_killed" BIGINT,
  "total_crash_rate" DOUBLE,
  "fatal_plus_injury_crash_rate" DOUBLE,
  "fatality_rate" DOUBLE
);

California State Highways Statewide Travel And Crash Rates

@usgov.ca_gov_2023_crash_data_on_state_highway_system.california_state_highways_statewide_travel_and_crash_rates

11.18 kB
54 rows
10 columns

CREATE TABLE california_state_highways_statewide_travel_and_crash_rates (
  "lane_type" VARCHAR,
  "area_type" VARCHAR,
  "n_2023_road_miles" DOUBLE  -- 2023 ROAD MILES,
  "n_2023_travel_mvm" DOUBLE  -- 2023 TRAVEL MVM,
  "n_2023_total_crash_rate" DOUBLE  -- 2023 TOTAL CRASH RATE,
  "n_2023_fatal_plus_injury_rate" DOUBLE  -- 2023 FATAL PLUS INJURY RATE,
  "n_2023_fatality_rate" DOUBLE  -- 2023 FATALITY RATE,
  "three_year_total_crash_rate" DOUBLE,
  "three_year_fatal_plus_injury_rate" DOUBLE,
  "three_year_fatality_rate" DOUBLE
);

Data Dictionary Crash Data On State Highway System

@usgov.ca_gov_2023_crash_data_on_state_highway_system.data_dictionary_crash_data_on_state_highway_system

19.83 kB
118 rows
18 columns

CREATE TABLE data_dictionary_crash_data_on_state_highway_system (
  "table_name" VARCHAR,
  "field_name" VARCHAR,
  "field_alias" VARCHAR,
  "field_description" VARCHAR,
  "field_type" VARCHAR,
  "field_length" DOUBLE,
  "domain_type" VARCHAR,
  "confidential" VARCHAR,
  "sensitive" VARCHAR,
  "pii" VARCHAR,
  "pci" VARCHAR,
  "system_name" VARCHAR,
  "field_description_authority" VARCHAR,
  "field_precision" DOUBLE,
  "units" VARCHAR,
  "allowable_min_value" DOUBLE,
  "allowable_max_value" DOUBLE,
  "usage_notes" VARCHAR
);

List Of Values Crash Data On State Highway System

@usgov.ca_gov_2023_crash_data_on_state_highway_system.list_of_values_crash_data_on_state_highway_system

12.41 kB
318 rows
6 columns

CREATE TABLE list_of_values_crash_data_on_state_highway_system (
  "system" VARCHAR,
  "data_table" VARCHAR,
  "data_element" VARCHAR,
  "code" VARCHAR,
  "meaning" VARCHAR,
  "list_of_values_source" VARCHAR
);

Metadata Crash Data On State Highway System

@usgov.ca_gov_2023_crash_data_on_state_highway_system.metadata_crash_data_on_state_highway_system

45.72 kB
11 rows
33 columns

CREATE TABLE metadata_crash_data_on_state_highway_system (
  "dataset_name" VARCHAR,
  "tags" VARCHAR,
  "summary" VARCHAR,
  "description" VARCHAR,
  "public_access_level" VARCHAR,
  "access_constraints" VARCHAR,
  "topic" VARCHAR,
  "gis_theme" VARCHAR,
  "created_date" TIMESTAMP,
  "revised_date" TIMESTAMP,
  "publisher_organization" VARCHAR,
  "contact_name" VARCHAR,
  "contact_organization" VARCHAR,
  "contact_position" VARCHAR,
  "contact_email" VARCHAR,
  "status" VARCHAR,
  "frequency" VARCHAR,
  "data_life_span" VARCHAR,
  "use_constraints" VARCHAR,
  "methodology" VARCHAR,
  "data_dictionary" VARCHAR,
  "place" VARCHAR,
  "temporal_coverage_begin" TIMESTAMP,
  "temporal_coverage_end" TIMESTAMP,
  "next_update" VARCHAR,
  "source_link" VARCHAR,
  "data_dictionary_type" VARCHAR,
  "coordinate_system_epsg" VARCHAR,
  "vert_datum_epsg" VARCHAR,
  "horiz_accuracy" VARCHAR,
  "vert_accuracy" VARCHAR,
  "data_standard" VARCHAR,
  "notes" VARCHAR
);

Pedestrian Fatality And Injury Data By County

@usgov.ca_gov_2023_crash_data_on_state_highway_system.pedestrian_fatality_and_injury_data_by_county

6.17 kB
290 rows
5 columns

CREATE TABLE pedestrian_fatality_and_injury_data_by_county (
  "county" VARCHAR,
  "highway_type" VARCHAR,
  "total" BIGINT,
  "fatality" BIGINT,
  "injury" BIGINT
);

Statewide Travel And Crash Summary

@usgov.ca_gov_2023_crash_data_on_state_highway_system.statewide_travel_and_crash_summary

13.52 kB
54 rows
13 columns

CREATE TABLE statewide_travel_and_crash_summary (
  "lane_type" VARCHAR,
  "area_type" VARCHAR,
  "road_miles" DOUBLE,
  "travel" DOUBLE,
  "total_crashes" BIGINT,
  "pdo_crashes" BIGINT,
  "injury_crashes" BIGINT,
  "fatal_crashes" BIGINT,
  "victim_killed" BIGINT,
  "victim_injured" BIGINT,
  "total_crash_rate" DOUBLE,
  "fatal_plus_injury_crash_rate" DOUBLE,
  "fatality_rate" DOUBLE
);

Travel And Crash Summary By District

@usgov.ca_gov_2023_crash_data_on_state_highway_system.travel_and_crash_summary_by_district

12.5 kB
39 rows
13 columns

CREATE TABLE travel_and_crash_summary_by_district (
  "dist" VARCHAR,
  "rural_urban" VARCHAR,
  "road_miles" DOUBLE,
  "travel_mvm" DOUBLE,
  "total_crashes" BIGINT,
  "pdo_crashes" BIGINT,
  "injury_crashes" BIGINT,
  "fatal_crashes" BIGINT,
  "victim_killed" BIGINT,
  "victim_injured" BIGINT,
  "total_crash_rate" DOUBLE,
  "fatal_plus_injury_crash_rate" DOUBLE,
  "fatality_rate" DOUBLE
);

Travel And Crash Summary For County

@usgov.ca_gov_2023_crash_data_on_state_highway_system.travel_and_crash_summary_for_county

37.42 kB
1,566 rows
11 columns

CREATE TABLE travel_and_crash_summary_for_county (
  "county" VARCHAR,
  "lane_type" VARCHAR,
  "rural_urban" VARCHAR,
  "road_miles" DOUBLE,
  "travel_mvm" DOUBLE,
  "total_crashes" BIGINT,
  "pdo_crashes" BIGINT,
  "injury_crashes" BIGINT,
  "fatal_crashes" BIGINT,
  "victim_killed" BIGINT,
  "victim_injured" BIGINT
);

Travel And Crash Summary For District

@usgov.ca_gov_2023_crash_data_on_state_highway_system.travel_and_crash_summary_for_district

24.21 kB
324 rows
14 columns

CREATE TABLE travel_and_crash_summary_for_district (
  "dist" BIGINT,
  "lane_type" VARCHAR,
  "urban_rural" VARCHAR,
  "road_miles" DOUBLE,
  "travel_mvm" DOUBLE,
  "total_crashes" BIGINT,
  "pdo_crashes" BIGINT,
  "injury_crashes" BIGINT,
  "fatal_crashes" BIGINT,
  "victim_killed" BIGINT,
  "victim_injured" BIGINT,
  "total_crash_rate" DOUBLE,
  "fatal_plus_injury_crash_rate" DOUBLE,
  "fatality_rate" DOUBLE
);