_id Field Name Description 1 OFFENDER_STATE_ID_HASHED Hashed version of the Offender State ID 2 OFFENDER_STATE Offender State (Two letter abbreviated) 3 OFFENDER_AGE_GROUP Age group of the offender 4 OFFENDER_RACE Offender's race 5 OFFENDER_SEX Offender's gender 6 OFFENSE_DATE Date of Offense 7 OFFENSE_COUNTY_FIPS County FIPS code of the Booking or Arresting Agency 8 OFFENSE_COUNTY County of the Booking or Arresting Agency 9 OFFENSE_STATE_FIPS State FIPS code of the Booking or Arresting Agency 10 OFFENSE_STATE State of the Booking or Arresting Agency 11 ARREST_ID_HASHED Hashed Arrest ID 12 ARREST_YR Year of arrest 13 ARREST_MON Month of arrest 14 ARRESTING_AGENCY_TYPE Type of the Arresting Agency 15 ARRESTING_AGENCY_COUNTY County of the Arresting Agency 16 ARRESTING_AGENCY_STATE State of the Arresting Agency 17 BOOKING_AGENCY_TYPE Type of the Arresting Agency 18 BOOKING_AGENCY_COUNTY County of the Booking Agency 19 BOOKING_AGENCY_STATE State of the Booking Agency 20 CHARGE_NO Derived from num_charge_track 21 OFFENSE_ID_HASHED Hashed offense_id 22 OFFENSE_STAGE Stage of the offense 23 OFFENSE_STAGE_ORDER_IS_MAX Boolean indicating if the row pertains to the current maximum offense_stage_order 24 OFFENSE_CLASS Class of offense 25 OFFENSE_LEVEL Level of Offense 26 OFFENSE_STATUTE Statute of Offense 27 OFFENSE_IC_TITLE_DESC Title of offense description 28 OFFENSE_IC_ARTICLE_DESC Offense Article Description 29 OFFENSE_IC_CHAPTER_DESC Offense Indiana Code Chapter Description 30 OFFENSE_IC_SECTION_DESC Offense Indiana Code Section Description 31 OFFENSE Offense 32 CHARGE_TYPE Type of charge (MPH Generated) 33 DRUG_RELATED Drug related categorization (MPH Generated) 34 OFFENSE_CATEGORY_TYPE Field to indicate the primary or secondary category of the Offense (MPH Generated) 35 OFFENSE_CATEGORY_1 Primary categorization of the Offense (MPH Generated) 36 OFFENSE_CATEGORY_2 Secondary level categorization of the Offense (MPH Generated) 37 OFFENSE_CATEGORY_3 Third level categorization of the Offense (MPH Generated) 38 FIREARM MPH generated binary categorization flag 39 FRAUD MPH generated binary categorization flag 40 CHILD MPH generated binary categorization flag 41 OTHER MPH generated binary categorization flag 42 HOLD MPH generated binary categorization flag 43 PROCEDURAL MPH generated binary categorization flag 44 PROPERTY MPH generated binary categorization flag 45 SEX MPH generated binary categorization flag 46 TRAFFIC MPH generated binary categorization flag 47 VIOLENT MPH generated binary categorization flag 48 ALCOHOL MPH generated binary categorization flag 49 COCAINE MPH generated binary categorization flag 50 COMMON_NUISANCE MPH generated binary categorization flag 51 CONTROLLED_SUBSTANCE MPH generated binary categorization flag 52 DRUG_GENERAL MPH generated binary categorization flag 53 HEROIN MPH generated binary categorization flag 54 MARIJUANA MPH generated binary categorization flag 55 METH MPH generated binary categorization flag 56 NARCOTIC MPH generated binary categorization flag 57 OPIUM MPH generated binary categorization flag 58 PARAPHERNALIA MPH generated binary categorization flag 59 PRESCRIPTION MPH generated binary categorization flag 60 SNIFFING MPH generated binary categorization flag 61 DISPOSITION MPH generated binary categorization flag 62 DISMISSED_FLAG MPH generated binary categorization flag