DHS–ICE Facilities Statistics FY2019-22

Since its inception, the DHS has produced Fiscal Yearly ERO and detention statistics reports that provide information on detention and Alternatives to Detention (ATD) statistics. This dataset compiles the Ice Detention Data, Average in Custody Length of Stay (ICLOS) and Detainees, and Facilities tabs of the FY19, FY20, FY21, and FY22 DHS-ICE reports (referenced below), into a multi-year dataset. 

Data Clean-up Process: 

To assist in the analysis and clear understanding of the data, and fix inaccuracies and data silences in the original data, additional columns were added to the facilities tab. Additionally, columns that were not used in the analysis and where outside of the scope of work, were removed from the new dataset. Rationale for the additional columns and the columns removed is as follow:

1. New Operator Category column: In attempting to understand the type of DHS facilities and how they may have changed through the years, an Operator Category column was added, where every facility is categorized as A) Country or City Facility (public), B) Privately Operated Facility, and C) Unknown operator. 
2. New Gender Modified Column: Upon reviewing the total number of female and male detainees for each facility it was noted that the original Male/Female column, which categorized each facility by the gender of the detainees, was often not reflective of the detainee population. To fix this error, a new "Gender Modified" column was added and the facilities were categorized as A) Male, B) Female, and C) Female and Male depending on the Total Male and Total Female columns of the reports. The new Gender Modified column is based on the ADP numbers of female vs. male detainees. If there were 0 female detainees, the facility was categorized as Male. If there were 0 Male ADP detainees, the facility was categorized as Female. If there were 1 or more detainees for both the female and male totals, the facility was categorized as Female and Male. 
3. New FY19-22 Active columns and New Ice Facilities ACTIVE 19-22 tab: Since the project attempts to do a multi-year analysis, five new columns were added to indicate if a facility was active FY19-22, Active FY19, Active FY20, Active FY21, and Active FY22. A facility that was active in a particular year was marked as Y. A facility that was Active all four years was marked as Y in the Active FY19-22 column. Certain modeling and hypothesis testing methodologies required that only the statistics for the facilities that were active FY19-22 be used. For this purpose, a second Tab named “Ice Facilities ACTIVE 19-22” was created. 
4. Removal of second to last inspection columns: The original DHS reports included additional columns with second to last inspection type, standard, and date. For the scope of this project, these columns were removed from each year and only the Last Inspection type, standard, and date were left and used for this project. 
5. New Percentage of Criminality columns: To calculate the percentage of criminality among detainees new Percentage of Criminality columns were added for each fiscal year. The percentages were calculated by the formula: (ADP: Criminality: Male Crim + ADP: Criminality: Female Crim) / (ADP Total Male + FY: Total Female)
6. NA cells: to indicate that no information was provided by ICE in the original reports or to indicate that the particular facility was not active for a particular year, NA was added in the corresponding cells. Additional data analysis in R changed the NA to nulls.