Collisions on 78th and Hoover | Last Updated 11 Sep 2018

This dataset reflects traffic collision incidents in the City of Los Angeles dating back to 2010. This data is transcribed from original traffic reports that are typed on paper and therefore there may be some inaccuracies within the data. Some location fields with missing data are noted as (0°, 0°). Address fields are only provided to the nearest hundred block in order to maintain privacy. This data is as accurate as the data in the database. Please note questions or concerns in the comments. MO codes description can be found here:

Tags: lapd, traffic, traffic data, police, safe city, traffic collision

This dataset has the following 18 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
DR Numberdr_notextDivision of Records Number: Official file number made up of a 2 digit year, area ID, and 5 digits.
Date Reporteddate_rptdcalendar_dateMM/DD/YYYY
Date Occurreddate_occcalendar_dateMM/DD/YYYY
Time Occurredtime_occtextIn 24 hour military time.
Area IDareatextThe LAPD has 21 Community Police Stations referred to as Geographic Areas within the department. These Geographic Areas are sequentially numbered from 1-21.
Area Namearea_nametextThe 21 Geographic Areas or Patrol Divisions are also given a name designation that references a landmark or the surrounding community that it is responsible for. For example 77th Street Division is located at the intersection of South Broadway and 77th Street, serving neighborhoods in South Los Angeles.
Reporting Districtrpt_dist_notextA code used in producing reports to group data into geographic sub-areas within an area. Find LAPD Reporting Districts on the LA City GeoHub at
Crime Codecrm_cdtextIndicates the crime committed. For this dataset - all Crime Code 997.
Crime Code Descriptioncrm_cd_desctextDefines the Crime Code provided. For this dataset - all Traffic Collision.
MO CodesmocodestextModus Operandi: Activities associated with the suspect in commission of the crime. See attached PDF for list of MO Codes in numerical order.
Victim Agevict_agetextTwo character numeric.
Victim Sexvict_sextextF - Female M - Male X - Unknown
Victim Descentvict_descenttextDescent Code: A - Other Asian B - Black C - Chinese D - Cambodian F - Filipino G - Guamanian H - Hispanic/Latin/Mexican I - American Indian/Alaskan Native J - Japanese K - Korean L - Laotian O - Other P - Pacific Islander S - Samoan U - Hawaiian V - Vietnamese W - White X - Unknown Z - Asian Indian
Premise Codepremis_cdtextThe type of structure or location where the incident took place.
Premise Descriptionpremis_desctextDefines the Premise Code provided.
AddresslocationtextStreet address of crime incident rounded to the nearest hundred block to maintain anonymity.
Cross Streetcross_streettextCross Street of rounded Address.
Locationlocation_1locationThe location where the crime incident occurred. Actual address is omitted for confidentiality. XY coordinates reflect the nearest 100 block.