About Crime Data

Crime data in this tool was obtained from the Los Angeles Police Department through the city’s Open Data portal here:
https://data.lacity.org/A-Safe-City/Crime-Data-from-2010-to-Present/y8tr-7khq

Geocoding
Location coordinates were provided in the original dataset.

Support Documents
Find MO code descriptions in this document: MO CODES (Numerical) Updated 7/18/2018.

Dataset Modifications
We did not alter any of the over 1.8m records in this dataset. However, we did add some columns to help us communicate this information more clearly. This includes a columns that hold:

  1. a ‘time_occ_full’ to store a complete timestamp (merging the provided ‘Occurred Date’ and ‘Time’ column data)
  2. a column storing the ‘location_1’ data separated into ‘lat’ and ‘lon’ columns
  3. a ‘geom’ column to help with geospatial identification
  4. a ‘prem_council’ column to store existing council district number (joined with district polygons)
  5. a ‘prem_neighborhood_council’ to store the existing Los Angeles Neighborhood Council name (joined with district polygons)
  6. a ‘census_2010’ column to store CENSUS Tract (2010) polygon information for reported crimes

Questions?
Please use our Customer Care system for help. This helps us answer your questions on a timely basis as well as support future users.