Traffic collisions - people and vehicles involved

Police Updated May 17, 2026

About this dataset

Traffic collision reports recorded by the San Diego Police Department with additional details on people and vehicles involved.

Get the data

Browse the table below for all files available for this dataset

Data Downloads

File name Download actions File Format File size
Traffic collisions details (2015 through year-to-date) Download

Copy URL

CSV

32.31 MB

person_veh_type dictionary Download

Copy URL

CSV

1.95 KB

View a data sample

Showing 1 transposed sample row. Download the full dataset or a view to get the data.

Data Sample

Data preview - first row of dataset transposed
Field Sample Value
date_time2020-09-23 01:43:00
person_rolePASSENGER
person_injury_lvlFATAL
person_veh_typePassenger Car, Station Wagon, Jeep
veh_typeAUTOMOBILE
veh_makeMERCEDES-BENZ
veh_model500 SERIES
police_beat437
address_no_primary6000
address_pd_primary
address_road_primaryPARADISE VALLEY
address_sfx_primaryROAD
address_pd_intersecting
address_name_intersecting
address_sfx_intersecting
violation_section23152(G)
violation_typeVC
charge_descDUI ALCOHOL/DRUG (M)
injured4
killed1
hit_run_lvlFELONY

Understand the data

Each field in the data is defined in the table below. Use this information to inform usage of the data.

Download dictionary

Data Dictionary

Data dictionary - field definitions for this dataset
fielddescriptionpossible_values
report_idCollision report number
date_timeDate/time of collision
person_roleDescription of person's role in the collisionBICYCLIST, DRIVER, OTHER, PARKED VEHICLE OCCUPANT, PASSENGER, PEDESTRIAN
person_injury_lvlDescription of person's level of injuryFATAL, NULL, PAIN, SEVERE, VISABLE
person_veh_typeDescription of type of vehicle (categories defined by CHP) **see list linked at https://data.sandiego.gov/datasets/police-collisions-details/
veh_typeDescription of type of vehicle **AUTOMOBILE, BICYCLE, FARM EQUIPMENT, LIGHT DUTY TRUCK, MOTORCYCLE, NULL, TRAILER, TRUCK, UNLISTED CONSTRUCTION EQUIPMENT
veh_makeMake of the vehicle
veh_modelModel of the vehicle
police_beatSan Diego Police beatsee list linked at https://data.sandiego.gov/datasets/police-beats/
address_no_primaryStreet number of collision location, abstracted to block level
address_pd_primaryDirection of street in location
address_road_primaryName of street
address_sfx_primaryStreet type
address_pd_intersectingDirection of cross street, if collision at intersection
address_name_intersectingStreet name, if collision at intersection
address_sfx_intersectingStreet type, if collision at intersection
violation_sectionViolation section for primary collision factor
violation_typeViolation type for primary collision factor
charge_descViolation section description for primary collision factor
injuredNumber of people injured in collision
killedNumber of people killed in collision
hit_run_lvlLevel of violation, if collision was a hit & runFelony or Misdemeanor (Null if not a hit & run)
  • PublisherPolice
  • Last Updated May 17, 2026
  • Update Frequency
  • Date Issued Aug 12, 2020
  • Available Formats .CSV
  • License View License

Data & Analytics

data@sandiego.gov