Traffic collisions - people and vehicles involved
About this dataset
Traffic collision reports recorded by the San Diego Police Department with additional details on people and vehicles involved.
Generally a report is not taken for property damage-only collisions that do not involve hit & run or DUI. The California Highway Patrol is responsible for handling collisions occurring on the freeway.
A single collision may involve multiple people and/or vehicles. This dataset contains one row per person involved in a collision. Each collision is uniquely identified in the report_id field.
Throughout 2018 and 2019, a new collision reporting process was introduced that resulted in more detailed data collection. Data fields listed in the Data Dictionary that include ** in the description may have incomplete data values for history records.
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 |
CSV |
33.63 MB |
View a data sample
Showing 1 transposed sample row. Download the full dataset or a view to get the data.
Data Sample
| Field | Sample Value |
|---|---|
| REPORT_ID | 20205526 |
| DATE_TIME | 2020-09-26 12:58:00.000 |
| PERSON_ROLE | DRIVER |
| PERSON_INJURY_LVL | PAIN |
| PERSON_VEH_TYPE | Passenger Car, Station Wagon, Jeep |
| VEH_TYPE | AUTOMOBILE |
| VEH_MAKE | CHEVROLET |
| VEH_MODEL | CAMARO |
| POLICE_BEAT | 123 |
| ADDRESS_NO_PRIMARY | 2300 |
| ADDRESS_PD_PRIMARY | |
| ADDRESS_ROAD_PRIMARY | WEST MISSION BAY |
| ADDRESS_SFX_PRIMARY | DRIVE |
| ADDRESS_PD_INTERSECTING | |
| ADDRESS_NAME_INTERSECTING | |
| ADDRESS_SFX_INTERSECTING | |
| VIOLATION_SECTION | 22350 |
| VIOLATION_TYPE | VC |
| CHARGE_DESC | UNSAFE SPEED (BASIC SPEED LAW) (I) |
| INJURED | 2 |
| KILLED | 0 |
| HIT_RUN_LVL | MISDEMEANOR |
Understand the data
Each field in the data is defined in the table below. Use this information to inform usage of the data.
Download dictionaryData Dictionary
| Field | Data_type | Description | Possible_values |
|---|---|---|---|
| report_id | Collision report number | ||
| date_time | Date/time of collision | ||
| police_beat | San Diego Police beat | ||
| address_no_primary | Street number of collision location, abstracted to block level | ||
| address_pd_primary | Direction of street in location | ||
| address_road_primary | Name of street | ||
| address_sfx_primary | Street type | ||
| address_pd_intersecting | Direction of cross street, if collision at intersection | ||
| address_name_intersecting | Street name, if collision at intersection | ||
| address_sfx_intersecting | Street type, if collision at intersection | ||
| violation_section | Violation section for primary collision factor | ||
| violation_type | Violation type for primary collision factor | ||
| charge_desc | Violation section description for primary collision factor | ||
| injured | Number of people injured in collision | ||
| killed | Number of people killed in collision | ||
| hit_run_lvl | Level of violation, if collision was a hit & run |
- PublisherPolice
- Last Updated Oct 1, 2026
- Update Frequency
- Date Issued Aug 12, 2020
- Available Formats .CSV
- License View License
Data & Analytics
data@sandiego.gov