Dataset: 2021 Crash Data On State Highway System

About this Dataset

2021 Crash Data On State Highway System

The Crash Data On California State Highways Report is produced 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: 2023-10-29T20:55:12.106205
Tags: 2021, california-department-of-transportation, california-state-transportation-agency, caopendata, crash, state-highway-system, transportation

Tables

Metadata Crash Data On State Highway System

@usgov.ca_gov_2021_crash_data_on_state_highway_system.metadata_crash_data_on_state_highway_system

43.14 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" VARCHAR,
  "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
);

Data Dictionary Crash Data On State Highway System

@usgov.ca_gov_2021_crash_data_on_state_highway_system.data_dictionary_crash_data_on_state_highway_system

18.47 KB
174 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_2021_crash_data_on_state_highway_system.list_of_values_crash_data_on_state_highway_system

12.14 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
);

Basic Average Crash Rate Table For Highways

@usgov.ca_gov_2021_crash_data_on_state_highway_system.basic_average_crash_rate_table_for_highways

14.19 KB
67 rows
17 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,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR
);

Basic Average Crash Rate Table For Intersections

@usgov.ca_gov_2021_crash_data_on_state_highway_system.basic_average_crash_rate_table_for_intersections

9.47 KB
31 rows
11 columns


CREATE TABLE basic_average_crash_rate_table_for_intersections (
  "rate_group" VARCHAR,
  "base_rate" DOUBLE,
  "adt_factor" DOUBLE,
  "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_2021_crash_data_on_state_highway_system.basic_average_crash_rate_table_for_ramps

11.9 KB
81 rows
13 columns


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

Bicycle Fatality And Injury Data By County

@usgov.ca_gov_2021_crash_data_on_state_highway_system.bicycle_fatality_and_injury_data_by_county

5.6 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_2021_crash_data_on_state_highway_system.california_state_highways_statewide_5_year_freeway_trend

16.4 KB
18 rows
24 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,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR
);

California State Highways Statewide Travel And Crash Rates

@usgov.ca_gov_2021_crash_data_on_state_highway_system.california_state_highways_statewide_travel_and_crash_rates

15.69 KB
54 rows
19 columns


CREATE TABLE california_state_highways_statewide_travel_and_crash_rates (
  "lane_type" VARCHAR,
  "area_type" VARCHAR,
  "n_2021_road_miles" DOUBLE,
  "n_2021_travel_mvm" DOUBLE,
  "n_2021_total_crash_rate" DOUBLE,
  "n_2021_fatal_plus_injury_rate" DOUBLE,
  "n_2021_fatality_rate" DOUBLE,
  "three_year_total_crash_rate" DOUBLE,
  "three_year_fatal_plus_injury_rate" DOUBLE,
  "three_year_fatality_rate" DOUBLE,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR
);

Pedestrian Fatality And Injury Data By County

@usgov.ca_gov_2021_crash_data_on_state_highway_system.pedestrian_fatality_and_injury_data_by_county

5.98 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_2021_crash_data_on_state_highway_system.statewide_travel_and_crash_summary

21.37 KB
74 rows
28 columns


CREATE TABLE statewide_travel_and_crash_summary (
  "lane_type" VARCHAR,
  "area_type" VARCHAR,
  "road_miles" DOUBLE,
  "travel_mvm" DOUBLE,
  "total_crashes" DOUBLE,
  "pdo_crashes" DOUBLE,
  "injury_crashes" DOUBLE,
  "fatal_crashes" DOUBLE,
  "victim_killed" DOUBLE,
  "victim_injured" DOUBLE,
  "total_crash_rate" DOUBLE,
  "fatal_plus_injury_crash_rate" DOUBLE,
  "fatality_rate" DOUBLE,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR
);

Travel And Crash Summary By District

@usgov.ca_gov_2021_crash_data_on_state_highway_system.travel_and_crash_summary_by_district

19.02 KB
39 rows
26 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,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR
);

Travel And Crash Summary For County

@usgov.ca_gov_2021_crash_data_on_state_highway_system.travel_and_crash_summary_for_county

49.29 KB
2331 rows
33 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" DOUBLE,
  "pdo_crashes" DOUBLE,
  "injury_crashes" DOUBLE,
  "fatal_crashes" DOUBLE,
  "victim_killed" DOUBLE,
  "victim_injured" DOUBLE,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR
);

Travel And Crash Summary For District

@usgov.ca_gov_2021_crash_data_on_state_highway_system.travel_and_crash_summary_for_district

37.9 KB
482 rows
39 columns


CREATE TABLE travel_and_crash_summary_for_district (
  "dist" DOUBLE,
  "lane_type" VARCHAR,
  "urban_rural" VARCHAR,
  "road_miles" DOUBLE,
  "travel_mvm" DOUBLE,
  "total_crashes" VARCHAR,
  "pdo_crashes" DOUBLE,
  "injury_crashes" DOUBLE,
  "fatal_crashes" DOUBLE,
  "victim_killed" DOUBLE,
  "victim_injured" DOUBLE,
  "total_crash_rate" DOUBLE,
  "fatal_plus_injury_crash_rate" DOUBLE,
  "fatality_rate" DOUBLE,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR,
  "unnamed_33" VARCHAR,
  "unnamed_34" VARCHAR,
  "unnamed_35" VARCHAR,
  "unnamed_36" VARCHAR,
  "unnamed_37" VARCHAR,
  "unnamed_38" VARCHAR
);