R at the ACLU Joining tables to to reunite families
summary
ACLU analytics joins scattered agency spreadsheets to locate and reunify over 2,500 separated children, finding dozens of impossible dates and 22 cases where a child appears reunified with themselves. Workflows join and deduplicate 2,500+ family records and validate messy Excel drops with tidyverse, janitor, assertthat, fs, ggplot, and leaflet. Pipeline produces one tidy rectangle of list-columns, flags inconsistencies for legal follow‑up, and maps facility locations — but missing reunification dates prevent reliable separation-duration estimates.
AI-written summary · about
chapters (4)
- 0:00Start
- 1:30Timeline of family separation March 2018
- 3:40The role of Analytics in Ms. L vs. ICE
- 9:04Solution: assertions + filters
related talks
19mData Wrangling for Advocacy: Tidy Data to Support the Affordable Connectivity Program
05mTemplated Analyses within R Packages for Collaborative, Reproducible Research
01h 02mData Cleansing With SQL And R
32mdata- and analytics-driven migration approach
24mData science, apps and civic responsibility
30mEnhancing Civics Data with Elasticsearch, pandas and Eland
39mRecord linkage: Join for real life
15mAdvocating for Automation: Adapting Current Tools in Environmental Science with R