Data Description

The data set consist of 174223 rows and 26 columns. For our analysis we have considered data set from 2015 to 2017. Below are the detailed description of the attributes: 

  1.  DR Number :  Division of Records Number: Official file number made up of a 2 digit year, area ID, and 5 digits.
  2. Date Reported : Date when crime was reported MM/DD/YYYY.
  3. Date Occurred : Date when crime occurred MM/DD/YYYY.
  4. Time Occurred: Time when crime occurred (In 24 hour military time.)
  5. Area ID: The LAPD has 21 Community Police Stations referred to as Geographic Areas within the department. These Geographic Areas are sequentially numbered from 1-21.
  6. Area Name: The 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.
  7. Reporting District: A four-digit code that represents a sub-area within a Geographic Area. All crime records reference the “RD” that it occurred in for statistical comparisons. Find LAPD Reporting Districts on the LA City GeoHub at http://geohub.lacity.org/datasets/c4f83909b81d4786aa8ba8a
  8. Crime Code : Indicates the crime committed. (Same as Crime Code 1)
  9. Crime Code Description :Defines the Crime Code provided.
  10. MO Codes: Modus Operandi – Activities associated with the suspect in commission of the crime. See attached PDF for list of MO Codes in numerical order. https://data.lacity.org/api/views/y8tr-7khq/files/3a967fbd-f210-4857-bc52-60230efe256c?download=true&filename=MO%20CODES%20(numerical%20o
  11. Victim Age:  Age of the victim (Two character numeric)
  12. Victim Sex : F – Female M – Male X – Unknown
  13. Victim Descent: Descent 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
  14. Premise Code: The type of structure, vehicle, or location where the crime took place.
  15. Premise Description: Defines the Premise Code provided.
  16. Weapon Used Code : The type of weapon used in the crime.
  17. Weapon Description: Defines the Weapon Used Code provided.
  18. Status Code : Status of the case. (IC is the default)
  19. Status Description : Defines the Status Code provided.
  20. Crime Code 1 : Indicates the crime committed. Crime Code 1 is the primary and most serious one. Crime Code 2, 3, and 4 are respectively less serious offenses. Lower crime class numbers are more serious.
  21. Crime Code 2 :May contain a code for an additional crime.
  22. Crime Code 3 : May contain a code for an additional crime.
  23. Crime Code 4 :May contain a code for an additional crime.
  24. Address :Street address of crime incident rounded to the nearest hundred block to maintain anonymity.
  25. Cross Street :Cross Street of rounded Address.
  26. Location: The location where the crime incident occurred. Actual address is omitted for confidentiality. XY coordinates reflect the nearest 100 block.