Dataset Overview This research paper and its associated interactive dashboard provide a comprehensive analysis of the Unaccompanied Alien Children (UAC) Program's capacity to care for children in the U. S. Department of Health and Human Services (HHS) system. The work addresses a critical gap: although daily operational data is collected, HHS lacked a centralized analytical framework to monitor total care load, net intake pressure, and identify periods of capacity strain. Background & Context The UAC Program, managed by HHS's Office of Refugee Resettlement (ORR), provides temporary shelter, medical screening, and placement services for children, known as unaccompanied alien children, who are apprehended by the U. S. Department of Homeland Security (DHS) and referred to ORR for care. From a healthcare systems perspective, this program functions as a dynamic care pipeline. Effective management of this pipeline is critical during sudden influxes to prevent overcrowding and ensure timely care for children. This project translates raw intake and placement counts into structured, actionable capacity insights to empower stakeholders. Data Source & Variables The primary data source is daily HHS administrative data covering December 2023 to December 2025. The dataset includes the following variables: Date: The reporting date. Children Apprehended: The number of UACs apprehended and placed in CBP custody that day. Children in CBP Custody: The number of children currently in CBP care. Children Transferred out of CBP Custody: The number of children moved from CBP to HHS on a given day. Children in HHS Care: The number of children actively in HHS care. Children Discharged from HHS Care: The number of children successfully placed with a sponsor. Methodology To derive operational insights, the daily data was used to compute the following core metrics: Total System Load: The sum of children in CBP and HHS custody. Net Daily Intake Pressure: The difference between transfers to HHS and discharges. Care Load Growth Rate: The day-over-day percentage change in the total load. Discharge Offset Ratio: The ratio of discharges to transfers (a key indicator of the system's ability to relieve load). Backlog & Strain Indicators: Sustained periods of positive net intake and prolonged strain windows, analyzed using 7-day rolling averages and variability metrics. Data quality and validation checks were also performed, including verifying logical constraints (e. g. , ensuring transfers did not exceed CBP custody) and identifying missing dates to ensure analytical transparency. Associated Interactive Dashboard This analysis is complemented by an open-source, interactive dashboard built with Python and Streamlit (https: //uac-dashboard-3qvqqrmpkgndq9n78er3jz. streamlit. app/), providing a live analytics environment for monitoring the UAC care system. The dashboard allows users to: Explore total system load and net intake trends between CBP and HHS. Track key KPIs through a dynamic summary panel. Identify and review periods of capacity strain based on rolling averages. Select and filter data by date range and time granularity. The dashboard’s code is available within a companion GitHub repository. How to Use This Material This research paper can be cited in academic work, used for policy-making, or to support operational planning. The associated dashboard can be used by HHS stakeholders and policymakers for real-time monitoring, proactive resource allocation, and to improve the delivery of federally mandated child care services. Data Availability Statement The primary dataset used in this analysis is the HHSUnaccompaniedAlienChildrenProgram. csv file, which is included in this deposit. The code for the dashboard is available in a public GitHub repository.
Surender Singh (Thu,) studied this question.