We can applying the same logic to 3, 5, 10, and all time years window. For example, “felon_count_3_years” means the number of felonies this arrestee convicted within 3-year window from the arrest date. “felon_count_all” means the total number of felonies this arrestee convicted before the arrest date.
We also use the similar naming conventions for misdemeanors: - misd_count_1_year: number of misdemeanors this arrestee convicted within one-year window from the arrest date. - misd_a1_count_1_year: number of class a1 misdemeanors this arrestee convicted within one-year window from the arrest date. - misd_class1_count_1_year: number of class 1 misdemeanors this arrestee convicted within one-year window from the arrest date.
As before, we also consider different time windows.
violent_crimes_1_year: number of violent crimes this arrestee has convicted within one-year window from the arrest date. [Note this is counting violent crimes based on conviction history]
num_violent_arrest_1_year: number of violent arrests within one-year window from the arrest date. [Note this is count number of times the arrestee has been arrested due to violent crimes, which is based on past arrest records]
As before, we created additional features for 3, 5, 10, and all time years window.
Please let me know if you also need definitions of violent crimes. Jens and I basically manually defined those.
num_arrests_1_year: number of times this arrestee has been arrested within one-year window from the arrest date. As before, we also defined columns for 3, 5, 10, and all time years window.
num_ftas_since_2015: total number of times the arrestee failed to attend courts since 2015 (before the arrest date).
num_ftas_1_year: total number of times the arrestee failed to attend courts within one-year window from the arrest date.
num_ftas_3_years: total number of times the arrestee failed to attend courts within 3-year window from the arrest date. [note we can only define FTA features since for 3 year windows, since the court data only spans from 2015 to 2020]
prior_rcd_level: prior record level before the arrest date. NC has adopted a structured sententing system since 1994. Generally. – The prior record level of an offender is determined by calculating the sum of the points assigned to each of the offender’s prior convictions. More serious offenses will correspond to higher record level. You can find the details here
pending_case_flag: a flag indicating whether the defendant has a pending (open) case at the time they were arrested for the present crime.