Sheriff Part 1 and 2 Crimes (Historical)

Part 1 crimes, as defined by the Federal Bureau of Investigation (FBI), are: * Criminal Homicide * Forcible Rape * Robbery * Aggravated Assault * Burglary * Larceny Theft * Grand Theft Auto * Arson Part 2 crimes, as defined by the Federal Bureau of Investigation (FBI), are: * Forgery * Fraud And NSF Checks * Sex Offenses Felonies * Sex Offenses Misdemeanors * Non-Aggravated Assaults * Weapon Laws * Offenses Against Family * Narcotics * Liquor Laws * Drunk / Alcohol / Drugs * Disorderly Conduct * Vagrancy * Gambling * Drunk Driving Vehicle / Boat * Vehicle / Boating Laws * Vandalism * Warrants * Receiving Stolen Property * Federal Offenses without Money * Federal Offenses with Money * Felonies Miscellaneous * Misdemeanors Miscellaneous Note About Date Fields: By default, the cloud database assumes all date fields are provided in UTC time zone. As a result, the system attempts to convert to the local time zone in your browser resulting in dates that appear differently than the source file. For example, a user viewing the data in PST will see times that are 8 hours behind. For an example of how dates are displayed, see the example below: ─────────────────────────┬─────────────────────────┬──────────────────────────────────── Source & Download File │Online Database │Table Display (Example for PST User) ─────────────────────────┼─────────────────────────┼──────────────────────────────────── 3/18/2023 8:07:00 AM PST│3/18/2023 8:07:00 AM UTC│3/18/2023 12:07:00 AM ─────────────────────────┴─────────────────────────┴──────────────────────────────────── DATA DICTIONARY: ────────────────────────┬───────────────────────────────────────────────────────────────────────────────────────────────────────────── Field Name │Field Description ────────────────────────┼───────────────────────────────────────────────────────────────────────────────────────────────────────────── LURN_SAK │System assigned number for the case ────────────────────────┼───────────────────────────────────────────────────────────────────────────────────────────────────────────── Incident Date │Date the crime incident occurred ────────────────────────┼───────────────────────────────────────────────────────────────────────────────────────────────────────────── Incident Reported Date │Date the crime was reported to LASD ────────────────────────┼───────────────────────────────────────────────────────────────────────────────────────────────────────────── Category │Incident crime category ────────────────────────┼───────────────────────────────────────────────────────────────────────────────────────────────────────────── Stat Code │A three digit numerical coding system to identify the primary crime category for an incident ────────────────────────┼───────────────────────────────────────────────────────────────────────────────────────────────────────────── Stat Code Desc │The definition of the statistical code number ────────────────────────┼───────────────────────────────────────────────────────────────────────────────────────────────────────────── Address │The street number, street name, state and zip where the incident occurred ────────────────────────┼───────────────────────────────────────────────────────────────────────────────────────────────────────────── Street │The street number and street name where the incident occurred ────────────────────────┼───────────────────────────────────────────────────────────────────────────────────────────────────────────── City │The city where the incident occurred ────────────────────────┼───────────────────────────────────────────────────────────────────────────────────────────────────────────── Zip │The zip code of the location where the incident occurred ────────────────────────┼───────────────────────────────────────────────────────────────────────────────────────────────────────────── Incident ID │The URN #, or Uniform Report Number, is a unique # assigned to every criminal and noncriminal incident ────────────────────────┼───────────────────────────────────────────────────────────────────────────────────────────────────────────── Reporting District │A geographical area defined by LASD which is within a city or unincorporated area where the incident occurred ────────────────────────┼───────────────────────────────────────────────────────────────────────────────────────────────────────────── Sequential (per Station)│Each incident for each station is issued a unique sequence # within a given year ────────────────────────┼───────────────────────────────────────────────────────────────────────────────────────────────────────────── Gang Related │Indicates if the crime incident was gang related ────────────────────────┼───────────────────────────────────────────────────────────────────────────────────────────────────────────── Unit ID │ORI # is a number issued by the FBI for every law enforcement agency ────────────────────────┼───────────────────────────────────────────────────────────────────────────────────────────────────────────── Unit Name │Station Name ────────────────────────┼───────────────────────────────────────────────────────────────────────────────────────────────────────────── Longitude │Longitude (as plotted on the nearest half block street segment) ────────────────────────┼───────────────────────────────────────────────────────────────────────────────────────────────────────────── Latitude │Latitude (as plotted on the nearest half block street segment) ────────────────────────┼───────────────────────────────────────────────────────────────────────────────────────────────────────────── Part Category │Part I Crime or Part II Crime indicator ────────────────────────┴─────────────────────────────────────────────────────────────────────────────────────────────────────────────