The Deportation Data Project makes several deportation-related datasets available at: https://deportationdata.org/data.html. This R code will download the “Arrests” data from the Explore Latest Processed Ice Data page, import it into an R data frame, and summarize the data frame’s content. The other datasets on the page could be easily be downloaded and imported using similar code.
# Install required package if needed
# install.packages("arrow")
# install.packages("tidyverse)
library(arrow)
library(tidyverse)
# URL of the Feather dataset
url <- "https://github.com/deportationdata/ice/raw/refs/heads/main/data/arrests-latest.feather"
# Download to a temporary file
tmp <- tempfile(fileext = ".feather")
download.file(url, tmp, mode = "wb")
# Read into an R data frame
arrests_df <- read_feather(tmp)
# Inspect the data
glimpse(arrests_df)The result is:
## Rows: 377,067
## Columns: 23
## $ apprehension_date <date> 2023-09-01, 2023-09-01, 2023-09-01, 2023-0…
## $ apprehension_state <chr> "CALIFORNIA", "SOUTH CAROLINA", NA, NA, NA,…
## $ apprehension_aor <chr> "San Francisco Area of Responsibility", "At…
## $ final_program <chr> "ERO Criminal Alien Program", "ERO Criminal…
## $ final_program_group <chr> "ICE", "ICE", "ICE", "ICE", "ICE", "ICE", "…
## $ apprehension_method <chr> "CAP Federal Incarceration", "CAP Local Inc…
## $ apprehension_criminality <chr> "1 Convicted Criminal", "2 Pending Criminal…
## $ case_status <chr> "6-Deported/Removed - Deportability", "8-Ex…
## $ case_category <chr> "[16] Reinstated Final Order", "[8C] Exclud…
## $ departed_date <date> 2023-09-02, 2024-01-17, NA, NA, NA, NA, NA…
## $ departure_country <chr> "MEXICO", "HONDURAS", NA, NA, NA, NA, NA, N…
## $ final_order_yes_no <chr> "YES", "YES", "NO", "NO", "NO", "NO", "NO",…
## $ final_order_date <date> 2001-04-09, 2023-11-21, NA, NA, NA, NA, NA…
## $ birth_year <int> 1972, 1994, 1966, 1966, 1999, 1997, 1993, 1…
## $ citizenship_country <chr> "MEXICO", "HONDURAS", "ECUADOR", "ECUADOR",…
## $ gender <chr> "Male", "Male", "Male", "Male", "Female", "…
## $ apprehension_site_landmark <chr> "FRE GENERAL AREA, NON-SPECIFIC", "RICHLAND…
## $ unique_identifier <chr> "318f563c52ac3db183b7c613b695e5c836c2942d",…
## $ apprehension_date_time <dttm> 2023-09-01 00:00:00, 2023-09-01 00:00:00, …
## $ duplicate_likely <lgl> FALSE, FALSE, TRUE, TRUE, FALSE, FALSE, FAL…
## $ file_original <chr> "ERO Admin Arrests_LESA-STU-FINAL Release_r…
## $ sheet_original <chr> "Admin Arrests", "Admin Arrests", "Admin Ar…
## $ row_original <int> 71951, 194383, 312924, 312925, 289496, 2273…