California Car Crashes
This table is for all the non-weather columns in the California dataset.
This sample crash data comes from the California and has all personal data removed.
Helpful links:
UC Berkley - Safe Transportation Research and Education Center
UC Berkley - Crash Data Tools and Resources
| column_name | data_type | desciption |
|---|---|---|
| case_id | bigint | desciption |
| jurisdiction | integer | desciption |
| officer_id | text | desciption |
| reporting_district | text | desciption |
| chp_shift | text | desciption |
| population | text | desciption |
| county_city_location | integer | desciption |
| county_location | text | desciption |
| special_condition | integer | desciption |
| beat_type | text | desciption |
| chp_beat_type | text | desciption |
| city_division_lapd | text | desciption |
| chp_beat_class | text | desciption |
| beat_number | text | desciption |
| primary_road | text | desciption |
| secondary_road | text | desciption |
| distance | numeric | desciption |
| direction | text | desciption |
| intersection | integer | desciption |
| weather_1 | text | desciption |
| weather_2 | text | desciption |
| state_highway_indicator | integer | desciption |
| caltrans_county | text | desciption |
| caltrans_district | integer | desciption |
| state_route | integer | desciption |
| route_suffix | text | desciption |
| postmile_prefix | text | desciption |
| postmile | numeric | desciption |
| location_type | text | desciption |
| ramp_intersection | text | desciption |
| side_of_highway | text | desciption |
| tow_away | integer | desciption |
| collision_severity | text | desciption |
| killed_victims | integer | desciption |
| injured_victims | integer | desciption |
| party_count | integer | desciption |
| primary_collision_factor | text | desciption |
| pcf_violation_code | text | desciption |
| pcf_violation_category | text | desciption |
| pcf_violation | integer | desciption |
| pcf_violation_subsection | text | desciption |
| hit_and_run | text | desciption |
| type_of_collision | text | desciption |
| motor_vehicle_involved_with | text | desciption |
| pedestrian_action | text | desciption |
| road_surface | text | desciption |
| road_condition_1 | text | desciption |
| road_condition_2 | text | desciption |
| lighting | text | desciption |
| control_device | text | desciption |
| chp_road_type | text | desciption |
| pedestrian_collision | integer | desciption |
| bicycle_collision | integer | desciption |
| motorcycle_collision | integer | desciption |
| truck_collision | integer | desciption |
| not_private_property | integer | desciption |
| alcohol_involved | integer | desciption |
| statewide_vehicle_type_at_fault | text | desciption |
| chp_vehicle_type_at_fault | text | desciption |
| severe_injury_count | integer | desciption |
| other_visible_injury_count | integer | desciption |
| complaint_of_pain_injury_count | integer | desciption |
| pedestrian_killed_count | integer | desciption |
| pedestrian_injured_count | integer | desciption |
| bicyclist_killed_count | integer | desciption |
| bicyclist_injured_count | integer | desciption |
| motorcyclist_killed_count | integer | desciption |
| motorcyclist_injured_count | integer | desciption |
| primary_ramp | text | desciption |
| secondary_ramp | text | desciption |
| process_date | timestamp without time zone | desciption |
| ls_id | integer | desciption |
| crash_time | time without time zone | desciption |
| crash_date | date | desciption |
| crash_timestamp | timestamp without time zone | desciption |
| lat | numeric | desciption |
| long | numeric | desciption |