{"main_topic":"immigration","sub_topic":"deportation_data","topic":"eoir_case_outcomes","key":"immigration/deportation_data/eoir_case_outcomes","version":"1.0.0","year_min":1997,"year_max":2026,"year_gaps":[],"update_frequency":"monthly","detail_levels":["counties","states"],"default_detail":"states","path_template":"immigration/eoir_case_outcomes/year={year}/{detail}.parquet","grain":["year","month","county_fips","demographic","custody","in_absentia","citizenship_country"],"title":"Immigration Court Case Outcomes in Georgia","summary":"Immigration-court cases filed by Georgia respondents each month, how many ended in a removal order, and how long decisions took; annual county totals by custody status.","description":"Immigration-court cases with a Georgia address of record, filed October 1997 through 1 August 2026, from the case database the Executive Office for Immigration Review posts monthly and the Deportation Data Project processes to one row per case. Counts of cases filed, cases decided, and decided cases that ended in a removal order, the share of decided cases ordered removed, and the average days from filing to decision, by calendar month of filing, EOIR's recorded sex, custody status, whether the latest hearing was in absentia, and nationality at state level; annual totals by county of record and custody status. The county of record of a detained respondent is the detention center's county.","source":"Executive Office for Immigration Review — Case database (posted monthly to EOIR's FOIA Library), processed by the Deportation Data Project (CC-0)","source_url":"https://deportationdata.org/data/processed/eoir.html","endpoint":"/api/v1/immigration/eoir_case_outcomes","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Calendar year the case was FILED - the date of the Notice to Appear (nta_date) that opened it - NOT the year it was decided and NOT the federal fiscal year EOIR reports by. 1997 covers October-December only; 2026 runs through 1 August. Recent filing years mix decided and still-pending cases.","valid_values":null,"example":2023,"unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"month","type":"string","role":"categorical","nullable":false,"label":"Month","short_description":"Calendar month the case was filed, or 'all' for the year.","description":"Calendar month of the Notice to Appear, '01'-'12', or 'all' for the calendar-year total. County rows carry 'all' only (monthly counts are published at state grain).","valid_values":["all","01","02","03","04","05","06","07","08","09","10","11","12"],"example":"all","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"county_fips","type":"string","role":"fk_county","nullable":true,"label":"County FIPS","short_description":"","description":"5-digit FIPS of the county of the respondent's ADDRESS OF RECORD, as the Deportation Data Project derived it from the ZIP code on the case. For a detained respondent that address is the detention center: Stewart (13259, Stewart Detention Center), Charlton (13049, the Folkston processing centers) and Irwin (13155) hold almost entirely detained cases and are NOT places those respondents live - filter custody = 'never_detained' for a residence-like reading. NULL on state rows.","valid_values":null,"example":"13135","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"demographic","type":"string","role":"fk_demographic","nullable":false,"label":"Demographic","short_description":"","description":"EOIR's recorded sex of the respondent (agency-recorded, not self-reported): 'male', 'female', or 'all'. Missing on a large share of cases, which count toward 'all' only, so male + female is well below 'all'. County rows carry 'all' only.","valid_values":["all","female","male"],"example":"all","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"custody","type":"string","role":"categorical","nullable":false,"label":"Custody","short_description":"Custody status over the life of the case.","description":"EOIR's custody status for the case: 'detained_throughout', 'released' (detained at some point, then released), 'never_detained', or 'all' = total. Broken out at BOTH grains - the one categorical published at county grain - because a detained respondent's county of record is the detention center's county. The 3 Georgia cases with no recorded status count toward the state 'all' rows only. At county grain the 'all' total is withheld whenever any custody part is withheld, so a published county total always equals the sum of its published parts and a withheld total says nothing about the parts; the parts themselves are withheld only when below 5.","valid_values":["all","detained_throughout","never_detained","released"],"example":"never_detained","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"in_absentia","type":"string","role":"categorical","nullable":false,"label":"In Absentia","short_description":"Whether the latest proceeding was heard in absentia.","description":"'yes' if the case's most recent proceeding was heard in absentia (the respondent did not appear), 'no' otherwise, 'all' = total. The source flag has no missing values, so yes + no equals all. County rows carry 'all' only.","valid_values":["all","no","yes"],"example":"no","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"citizenship_country","type":"string","role":"categorical","nullable":false,"label":"Citizenship Country","short_description":"Nationality (22 named countries, else 'other').","description":"The respondent's nationality as EOIR records it (the source field is `nationality`; the gold column keeps the sub_topic's shared name so the ICE and EOIR topics agree), mapped to the shared vocabulary: the 22 countries most frequent among Georgia records across the ICE and EOIR sources, 'other' for every other country, 'unknown' for stateless / unknown / missing; 'all' = total. Published at state grain only - county rows carry 'all'.","valid_values":["all","brazil","china","colombia","cuba","dominican_republic","ecuador","el_salvador","guatemala","haiti","honduras","india","jamaica","mauritania","mexico","nicaragua","nigeria","peru","russia","senegal","south_korea","venezuela","vietnam","other","unknown"],"example":"mexico","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"num_cases","type":"integer","role":"metric","nullable":true,"label":"Number Cases","short_description":"Immigration-court cases filed in the cell.","description":"Number of immigration-court cases (one row per case in the source, unique case id) whose Notice to Appear falls in the cell's month/year and whose address of record is in Georgia (or the county). Includes cases still pending. State rows are complete (a 0 is a real zero); county counts below 5, zero included, are withheld as NULL.","valid_values":null,"example":61971,"unit":"count","value_min":null,"value_max":null,"null_meaning":"withheld: fewer than 5, including zero - county rows only; state rows are complete","key_metric_grain_contributor":false,"metric_component":null},{"name":"num_cases_decided","type":"integer","role":"metric","nullable":true,"label":"Number Cases Decided","short_description":"Cases in the cell with a recorded outcome by 1 August 2026.","description":"Cases in the cell with a recorded case_outcome (equivalently, an immigration-judge or BIA completion date) by the coverage end (2026-08-01) - the denominator of removal_order_rate. avg_days_to_decision is taken over the decided cases with a VALID duration, so its effective N can be slightly smaller: four Georgia cases with an impossible negative duration are masked (§4b) but still count as decided. num_cases - num_cases_decided is the number still pending; recent filing years have many. County counts below 5, zero included, are withheld as NULL.","valid_values":null,"example":31082,"unit":"count","value_min":null,"value_max":null,"null_meaning":"withheld: fewer than 5, including zero - county rows only; state rows are complete","key_metric_grain_contributor":false,"metric_component":"denominator"},{"name":"num_removal_orders","type":"integer","role":"metric","nullable":true,"label":"Number Removal Orders","short_description":"Decided cases that ended in a removal order.","description":"Decided cases whose outcome is a removal order: 'Remove', 'Remove-INA Withholding Granted', 'Remove-CAT Withholding Granted' or 'Remove-CAT Deferral Granted'. The withholding / deferral variants are removal orders whose execution to a particular country is barred; the respondent is still ordered removed. Voluntary departure, termination, dismissal, relief and administrative closure are NOT removal orders. County counts below 5, zero included, are withheld, plus complementary suppression when the non-removal remainder would be below 5.","valid_values":null,"example":20105,"unit":"count","value_min":null,"value_max":null,"null_meaning":"withheld: fewer than 5 including zero, OR the non-removal remainder (decided minus removal orders) was 1-4 - county rows only; state rows are complete","key_metric_grain_contributor":false,"metric_component":"numerator"},{"name":"removal_order_rate","type":"number","role":"metric","nullable":true,"label":"Removal Order Rate","short_description":"Share of decided cases that ended in a removal order","description":"num_removal_orders / num_cases_decided (0-1): the share of the cell's DECIDED cases that ended in a removal order. Pending cases are excluded, so for recent filing years the rate is over the early-resolving subset and will drift as pending cases resolve. NULL where no case has been decided or, on county rows, where a component is withheld.","valid_values":null,"example":0.6468,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"state rows: no case in the cell has been decided yet (num_cases_decided = 0); county rows: withheld because a component count was withheld","key_metric_grain_contributor":false,"metric_component":null},{"name":"avg_days_to_decision","type":"number","role":"metric","nullable":true,"label":"Average Days to Decision","short_description":"Average days from filing to decision, decided cases only.","description":"Mean nta_date_to_ij_or_bia_completion_date_last_days - days from the Notice to Appear to the latest immigration-judge or BIA completion - over the cell's DECIDED cases, published only where at least 5 cases have been decided (an average over fewer is those people's own durations). Right-censored: pending cases contribute nothing, so recent filing years average only their fastest-resolving cases and look fast. No unit (days). §4b: a negative duration (a decision dated before its filing; 4 Georgia cases, -70 to -1 days) or one longer than the coverage window (10531 days; none) is NULLed before averaging - the case still counts as decided but contributes no duration.","valid_values":null,"example":557.5,"unit":null,"value_min":null,"value_max":null,"null_meaning":"fewer than 5 decided cases in the cell (including none) - an average over one to four people is withheld at every grain; on county rows also whenever num_cases_decided is withheld","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"removal_order_rate","usage":"Star-schema fact table. Join the counties dimension on county_fips; the demographics dimension on demographic. Read directly with DuckDB over Parquet.","limitations":"GEOGRAPHY IS THE ADDRESS OF RECORD, AND FOR DETAINED RESPONDENTS THAT IS THE DETENTION CENTER. `county_fips` is the county the Deportation Data Project derived from the ZIP code on the case; a detained respondent's address of record is the facility holding them. Stewart County's rows are 99.3% custody = 'detained_throughout' (Stewart Detention Center, Lumpkin), Charlton's 98.6% (the Folkston processing centers) and Irwin's 98.3% (Irwin County Detention Center) - these are not places those respondents live (Stewart County has under 6,000 residents). Use custody = 'never_detained' for a residence-like county map, and never read the custody = 'all' row of a facility county as residents; Fulton's 'all' row also mixes the Atlanta detention population with residents. `year` is the calendar year the case was FILED (the Notice to Appear date), not the year it was decided: recent filing years mix decided and pending cases (58% of 2026 filings and 26% of all Georgia filings in the window were still pending on 2026-08-01). `removal_order_rate` is over DECIDED cases only and will drift as pending cases resolve, and `avg_days_to_decision` is right-censored - only finished cases count, so the most recent years look fast; an apparent speed-up near the end of the window is a censoring artifact before it is a change in practice. Calendar years, not federal fiscal years: figures here will NOT match EOIR's own or DDP's published FY totals (federal FY runs October 1 - September 30). Coverage is the release window 1997-10-01 through 2026-08-01: calendar 1997 is October-December only and 2026 stops on 1 August, so both end years are partial and a year-over-year chart dips at both ends. 0 Georgia case(s) fell outside the window. The 29-year span is not a uniform series: filings swing from a 2020 trough (court closures) to a 2023 peak; EOIR's recording practice changed over the period and several fields are sparse in the early years; and the 2019-2026 surge is dominated by never-detained respondents whose cases are largely still open. Disclosure control (the platform's own rule; the source has none): county rows are annual (`month` is published at state grain only) with `demographic`, `in_absentia` and `citizenship_country` pinned to `all` and only `custody` broken out, on a complete 159-county x 30-year x 4-custody-value grid; any county count below 5 - ZERO INCLUDED - is withheld as NULL, with complementary suppression: across the custody partition the county `all` TOTAL is withheld whenever any custody part is withheld, so a published county total always equals the sum of its published parts and a withheld total reveals nothing about them (a facility county can show its never_detained residents while its misleading total is blank); across counties within a year; and of the removal count when the non-removal remainder would be 1-4. The still-pending remainder num_cases - num_cases_decided is NOT treated as a disclosive complement (a pending count is a property of the docket, not of a person; the same decision as the detention topics). A county NULL therefore means 'fewer than five, possibly none', never a real zero; state rows are complete and a state 0 is a real zero. avg_days_to_decision is additionally withheld, at EVERY grain, wherever fewer than 5 cases in the cell have been decided - an average over one to four people is those people's own durations. The 3 Georgia cases with no recorded custody status are counted in state rows only, so every county `all` total is exactly the sum of its custody parts. 143 of 4,770 county-year custody = 'all' cells and 1,650 custody = 'never_detained' cells publish num_cases. `demographic` is EOIR's recorded sex (agency-recorded, not self-reported), missing on 39.7% of Georgia cases, which count toward `all` only, so male + female is well below `all` - and the gap is an ERA effect, not random: sex is recorded on 3% of cases filed through 2012, 40% of 2013-2015 filings and 87% from 2016 on, so a male/female series is only meaningful from about 2016. 1,482 Georgia cases are 'Withholding Only' proceedings (case_type), which decide relief on an existing removal order and therefore can never produce a new removal order; they are counted in num_cases and num_cases_decided (their outcomes are 'Deny' / 'Grant' rather than 'Remove'), which lowers removal_order_rate very slightly. `citizenship_country` is EOIR's `nationality` field mapped onto the sub_topic's shared 22-country vocabulary (the gold column keeps the shared name so the ICE and EOIR topics agree); 5.2% of Georgia cases fall in `other`. Removal orders include the INA-withholding, CAT-withholding and CAT-deferral variants of `Remove`: each is a removal order whose execution to a particular country is barred, and the respondent is still ordered removed. Voluntary departure, termination, dismissal, relief granted and administrative closure are decided but not removal orders. Overall, 68.0% of decided Georgia cases in the window ended in a removal order. Judge, court, hearing-location and place fields are never published: EOIR names individual immigration judges, and outcome rates by named judge would be a statement about a person, not about Georgia. This topic is family 1 of the four measure families in the EOIR case database; representation (`eoir_representation`), bond decisions (`eoir_bond_decisions`) and relief applications (`eoir_asylum_decisions`) are separate topics built on the same source.","null_semantics":{"suppressed_to_null":true,"zero_is_real":true},"available_years":[1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026],"schema_hash":"40d07515cd534e6c5a1f6563c36a7a41e1b39af4e3c3057effb473bc77cd2c4e","tags":["immigration","executive office for immigration review — case database","eoir_case_outcomes"],"granularity_description":"One row per year, month, county_fips, demographic, custody, in_absentia, citizenship_country (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2026), states detail","query":"SELECT * FROM eoir_case_outcomes WHERE year = 2026 LIMIT 100"},{"description":"Filter by month = all","query":"SELECT * FROM eoir_case_outcomes WHERE month = 'all' AND year = 2026 LIMIT 100"}],"foreign_keys":[{"column":"county_fips","target_object":"counties","target_columns":["county_fips"],"attribute_columns_added":["county_name"],"scope":"global"},{"column":"demographic","target_object":"demographics","target_columns":["demographic"],"attribute_columns_added":["demographic_label","demographic_category"],"scope":"global"}],"filters":[{"param":"year","kind":"year_exact","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"year_min","kind":"year_range","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"year_max","kind":"year_range","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"detail","kind":"detail","type":"string","multi_value":false,"enum_enforced":true,"values":["counties","states"],"default":"states"},{"param":"county_fips","kind":"foreign_key","column":"county_fips","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"demographic","kind":"foreign_key","column":"demographic","type":"string","multi_value":true,"enum_enforced":true,"values":["all","female","male"]},{"param":"month","kind":"categorical","column":"month","type":"string","multi_value":true,"enum_enforced":true,"values":["all","01","02","03","04","05","06","07","08","09","10","11","12"],"has_total":true,"total_value":"all","requires_single_value":false,"nullable":false,"null_filter_token":null},{"param":"custody","kind":"categorical","column":"custody","type":"string","multi_value":true,"enum_enforced":true,"values":["all","detained_throughout","never_detained","released"],"has_total":true,"total_value":"all","requires_single_value":false,"nullable":false,"null_filter_token":null},{"param":"in_absentia","kind":"categorical","column":"in_absentia","type":"string","multi_value":true,"enum_enforced":true,"values":["all","no","yes"],"has_total":true,"total_value":"all","requires_single_value":false,"nullable":false,"null_filter_token":null},{"param":"citizenship_country","kind":"categorical","column":"citizenship_country","type":"string","multi_value":true,"enum_enforced":true,"values":["all","brazil","china","colombia","cuba","dominican_republic","ecuador","el_salvador","guatemala","haiti","honduras","india","jamaica","mauritania","mexico","nicaragua","nigeria","peru","russia","senegal","south_korea","venezuela","vietnam","other","unknown"],"has_total":true,"total_value":"all","requires_single_value":false,"nullable":false,"null_filter_token":null},{"param":"demographic_category","kind":"dimension_attribute","dimension":"demographics","column":"demographic_category","type":"string","multi_value":true,"enum_enforced":true,"values":["aggregate","disability","economic_status","esol","foster_care","gender","grade","homeless_status","migrant_status","military","race","sped"]}],"filter_hints":[],"values_endpoint":"/api/v1/immigration/eoir_case_outcomes/values"}