{"main_topic":"immigration","sub_topic":"deportation_data","topic":"ice_287g_agreements","key":"immigration/deportation_data/ice_287g_agreements","version":"1.0.0","year_min":2002,"year_max":2026,"year_gaps":[],"update_frequency":"irregular","detail_levels":["counties","states"],"default_detail":"states","path_template":"immigration/ice_287g_agreements/year={year}/{detail}.parquet","grain":["year","county_fips","agreement_type"],"title":"ICE 287(g) Agreements with Georgia Agencies","summary":"287(g) agreements Georgia sheriffs, police and state agencies signed with ICE each year, and how many were in force, by model and county.","description":"287(g) agreements between U.S. Immigration and Customs Enforcement and Georgia law-enforcement agencies - the memoranda of agreement under INA section 287(g) that deputize state and local officers to perform immigration-enforcement functions. Counts of agreements signed in each calendar year and of agreements in force at year end, by support model (jail enforcement, task force, warrant service officer, and the 2008-2013 combined jail & task force MOA), statewide and by the signing agency's county, from the Deportation Data Project's reconstruction of every ICE participating-agencies list since 2008 plus ICE and DHS records back to 2002.","source":"U.S. Immigration and Customs Enforcement, via the Deportation Data Project (ice-287g): every archived ICE 287(g) participating-agencies list, resolved into agreement records","source_url":"https://github.com/deportationdata/ice-287g","endpoint":"/api/v1/immigration/ice_287g_agreements","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Calendar year (NOT the federal fiscal year): the signing year for num_agreements_signed; for num_agreements_active, the year on whose 31 December the in-force stock is taken (2026-09-18 for 2026). 2002-2026; 2026 runs through 2026-09-18.","valid_values":null,"example":2025,"unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"county_fips","type":"string","role":"fk_county","nullable":true,"label":"County FIPS","short_description":"","description":"5-digit FIPS of the signing agency's county (a municipal police department's county). NULL on state rows. Statewide and multi-county agencies (Department of Corrections, Department of Public Safety, the Northern Judicial Circuit Probation Office) appear in state rows only.","valid_values":null,"example":"13139","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"agreement_type","type":"string","role":"categorical","nullable":false,"label":"Agreement Type","short_description":"287(g) model: jail, task force or warrant service.","description":"The 287(g) support model: 'jail_enforcement_model' (officers screen people booked into the jail), 'task_force_model' (officers enforce immigration law during routine policing), 'warrant_service_officer' (officers serve ICE administrative warrants in the jail), 'jail_and_task_force' (the 2008-2013 combined MOA - Hall County's in Georgia - kept distinct, not split); 'all' = total. Historical spellings are merged.","valid_values":["all","jail_and_task_force","jail_enforcement_model","task_force_model","warrant_service_officer"],"example":"task_force_model","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"num_agreements_signed","type":"integer","role":"metric","nullable":true,"label":"Number Agreements Signed","short_description":"287(g) agreements signed in the year.","description":"Number of 287(g) agreements (memoranda of agreement between ICE and a state or local agency, one per support model) signed in the calendar year. A renewal or re-signing is a new agreement; ICE's 2013 relabel of Hall County's 2008 MOA counts once under each label in 2008. Complete in every year - a 0 is a real zero.","valid_values":null,"example":37,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"num_agreements_active","type":"integer","role":"metric","nullable":true,"label":"Number Agreements Active","short_description":"Agreements in force at year end.","description":"Number of agreements on ICE's participating-agencies list on 31 December of the year - on 2026-09-18 (the release's as-of date) for 2026 - from the listing window: first listed on or before the date and not yet dropped. Same event as the signed count, taken as a stock. Listing lags signing (days since March 2025; weeks to months earlier, when lists are dated by Wayback capture). NULL for 2007, when Georgia agreements were in force before the first dated agreement listing (2008-04-29): the rule would return a false 0. Earlier years precede every Georgia signing and are real zeros.","valid_values":null,"example":125,"unit":"count","value_min":null,"value_max":null,"null_meaning":"not derivable: Georgia agreements were already signed but the year ends before the first dated agreement listing (2008-04-29), so the in-force stock cannot be read from listing dates","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"num_agreements_signed","usage":"Star-schema fact table. Join the counties dimension on county_fips. Read directly with DuckDB over Parquet.","limitations":"Calendar years, not federal fiscal years (an enforcement-program topic): `year` is the calendar year the agreement was SIGNED for `num_agreements_signed`, and the calendar year on whose 31 December the in-force stock is taken for `num_agreements_active`, so a figure here will not match a count reported for a federal fiscal year (October 1 - September 30). Coverage runs from 2002 (the program's first signing, 2002-07-02) to 2026; Georgia's first agreements were signed in 2007, so earlier years are real zeros. 2026 is partial: this release is current to 2026-09-18 (the latest ICE list the Deportation Data Project absorbed), and its active count is taken on that date instead of 31 December. ICE's own list of 2026-09-21 already shows 1 Georgia signing(s) after that date, which the next release will carry. `num_agreements_active` counts agreements on ICE's list on 31 December, derived from the listing window (first list showing the agreement on or before the date, and no later list without it). Listing lags signing: since March 2025 ICE dates its own lists and the lag is days; before that the lists are undated and dated here by their Wayback Machine capture, weeks to months late (Gwinnett's October 2009 MOA was first captured in April 2010, so it is not active on 31 December 2009), and an agreement's end is the first capture without it. The Deportation Data Project's agreement listing windows begin with the first archived ICE list it dates (2008-04-29); ICE's undated 2007-08 lists attest agencies, not agreement windows. The active count is therefore NULL (not derivable) for 2007, when Georgia agreements were already in force; 2002-2006 precede every Georgia signing and are real zeros, and the signed count is complete in every year. These are agreements, not agencies: one agency may hold up to three at once (one per model), and every renewal or re-signing ICE listed is a new agreement in the year it was signed. The count of distinct agencies is not published here. ICE relabeled Hall County's 2008 Jail & Task Force MOA as a Jail Enforcement Model MOA in 2013 (same signing date); the source keeps both labels as agreements, so 2008 counts that one signing once under each model. `agreement_type` merges the historical spellings (`JAIL ENFORCEMENT`, `Jail Enforcement` -> jail enforcement model; `TASK FORCE` -> task force model) and keeps the 2008-2013 combined jail & task force MOA distinct. Geography is the signing agency's county: a municipal police department counts in the county it sits in. Statewide and multi-county agencies - Georgia Department of Corrections (2); Georgia Department of Public Safety (2); Northern Judicial Circuit Probation Office (1) - have no single county and appear in state rows only, so county rows sum to at most the state row. No suppression: rows are agreements between ICE and an agency, not people, so the domain's county small-cell rule does not apply and every published zero is real. The agency behind each agreement (its FBI ORI) is not published yet. Signing dates are ICE's printed dates after the Deportation Data Project's corrections.","null_semantics":{"suppressed_to_null":false,"zero_is_real":true},"available_years":[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":"2dc5d992aadfda3ef2baf62117b67631aebb07fe23939737f10c2dc01f38f2b6","tags":["immigration","u.s. immigration and customs enforcement, via the deportation data project","ice_287g_agreements"],"granularity_description":"One row per year, county_fips, agreement_type (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2026), states detail","query":"SELECT * FROM ice_287g_agreements WHERE year = 2026 LIMIT 100"},{"description":"Filter by agreement_type = task_force_model","query":"SELECT * FROM ice_287g_agreements WHERE agreement_type = 'task_force_model' AND year = 2026 LIMIT 100"}],"foreign_keys":[{"column":"county_fips","target_object":"counties","target_columns":["county_fips"],"attribute_columns_added":["county_name"],"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":"agreement_type","kind":"categorical","column":"agreement_type","type":"string","multi_value":true,"enum_enforced":true,"values":["all","jail_and_task_force","jail_enforcement_model","task_force_model","warrant_service_officer"],"has_total":true,"total_value":"all","requires_single_value":false,"nullable":false,"null_filter_token":null}],"filter_hints":[],"values_endpoint":"/api/v1/immigration/ice_287g_agreements/values"}