About this Dataset

Traffic Collision Data From 2010 To Present

***The Los Angeles Police Department (LAPD) has transitioned traffic collision reporting to our new Records Management System (RMS) as part of our ongoing efforts to modernize data collection and comply with the FBI’s National Incident-Based Reporting System (NIBRS). This transition will improve the accuracy and detail of reported traffic-related incidents. During this process, there will be a delay in the availability of new traffic collision datasets while they are being developed for the new system. In the meantime, users will continue to see only historical data from the retired system. We appreciate your patience as we complete this transition. *** 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.
Organization: City of Los Angeles
Last updated: 2020-11-10T17:52:18.237763
Tags: lapd, police, safe-city, traffic, traffic-collision, traffic-data

Tables

Table 1

@usgov.city_of_los_angeles_traffic_collision_data_from_2010_to_present.table_1

18.47 MB
621,677 rows
18 columns

CREATE TABLE table_1 (
  "dr_number" BIGINT,
  "date_reported" TIMESTAMP,
  "date_occurred" TIMESTAMP,
  "time_occurred" BIGINT,
  "area_id" BIGINT,
  "area_name" VARCHAR,
  "reporting_district" BIGINT,
  "crime_code" BIGINT,
  "crime_code_description" VARCHAR,
  "mo_codes" VARCHAR,
  "victim_age" DOUBLE,
  "victim_sex" VARCHAR,
  "victim_descent" VARCHAR,
  "premise_code" DOUBLE,
  "premise_description" VARCHAR,
  "address" VARCHAR,
  "cross_street" VARCHAR,
  "location" VARCHAR
);