{"main_topic":"immigration","sub_topic":"population_estimates","topic":"undocumented_population_characteristics","key":"immigration/population_estimates/undocumented_population_characteristics","version":"1.0.0","year_min":2024,"year_max":2024,"year_gaps":[],"update_frequency":"irregular","detail_levels":["states"],"default_detail":"states","path_template":"immigration/undocumented_population_characteristics/year={year}/{detail}.parquet","grain":["year","county_fips","demographic","estimator","region_of_birth","country_of_birth","years_in_us","age_bracket"],"title":"Undocumented Immigrant Population Characteristics","summary":"The Center for Migration Studies' 2024 profile of Georgia's undocumented population by sex, age, birthplace and years in the U.S.","description":"Characteristics of Georgia's undocumented immigrant population from the Center for Migration Studies of New York (CMS), data year 2024: CMS's modeled estimate of 502,000 broken down, one breakdown at a time, by sex, age bracket, world region of birth, country of birth (31 countries) and years in the United States. For the size of the population and how Pew, MPI, CMS and DHS compare, use undocumented_population_estimates.","source":"Center for Migration Studies of New York, State and National Data Tool (undocumented population, data year 2024)","source_url":"https://data.cmsny.org/","endpoint":"/api/v1/immigration/undocumented_population_characteristics","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"CMS's data year as labeled by its State and National Data Tool (2024); the underlying ACS vintage is not stated. Not a federal fiscal year.","valid_values":null,"example":2024,"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":"Always NULL: CMS publishes states only. Kept for the immigration domain's shared key shape.","valid_values":null,"example":null,"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":"Sex (female, male); 'all' = everyone.","description":"Sex as the ACS records it: female or male; 'all' = total. A margin: never crossed with another breakdown, so on these rows every other breakdown column is 'all'.","valid_values":["all","female","male"],"example":"female","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"estimator","type":"string","role":"categorical","nullable":false,"label":"Estimator","short_description":"Who produced the estimate (cms).","description":"The organization whose model produced the estimate: cms = Center for Migration Studies of New York, the only one of the four estimators in undocumented_population_estimates whose collected state file carries breakdowns. No 'all' total: estimators are never summed.","valid_values":["cms"],"example":"cms","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"region_of_birth","type":"string","role":"categorical","nullable":false,"label":"Region of Birth","short_description":"CMS world region of birth; 'all' = everyone.","description":"CMS's region of birth: africa, asia, caribbean, central_america, europe, north_america (Mexico and Canada), oceania, south_america; 'all' = total. Not the DHS OHSS or ACS regions. A margin: never crossed with another breakdown, so on these rows every other breakdown column is 'all'.","valid_values":["all","africa","asia","caribbean","central_america","europe","north_america","oceania","south_america"],"example":"central_america","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"country_of_birth","type":"string","role":"categorical","nullable":false,"label":"Country of Birth","short_description":"Country of birth (31 CMS-listed); 'all' = everyone.","description":"Country of birth, for the 31 countries CMS lists (not exhaustive; no 'other'); 'all' = total. korea is CMS's unsplit 'Korea'. A margin: never crossed with another breakdown, so on these rows every other breakdown column is 'all'.","valid_values":["all","afghanistan","argentina","bangladesh","brazil","canada","chile","china","colombia","dominican_republic","ecuador","el_salvador","ethiopia","ghana","guatemala","haiti","honduras","india","jamaica","korea","mexico","nepal","nicaragua","nigeria","pakistan","peru","philippines","poland","russia","ukraine","venezuela","vietnam"],"example":"mexico","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"years_in_us","type":"string","role":"categorical","nullable":false,"label":"Years in US","short_description":"Years lived in the U.S.; 'all' = everyone.","description":"Years since arrival in the United States: under_5, 5_9, 10_14, 15_19, 20_plus; 'all' = total. A margin: never crossed with another breakdown, so on these rows every other breakdown column is 'all'.","valid_values":["all","10_14","15_19","20_plus","5_9","under_5"],"example":"under_5","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"age_bracket","type":"string","role":"categorical","nullable":false,"label":"Age Bracket","short_description":"Age group; 'all' = everyone.","description":"Age: under_5, 5_17, 18_20, 21_24, 25_34, 35_44, 45_64, 65_plus; 'all' = total. A margin: never crossed with another breakdown, so on these rows every other breakdown column is 'all'.","valid_values":["all","18_20","21_24","25_34","35_44","45_64","5_17","65_plus","under_5"],"example":"25_34","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"estimated_population","type":"integer","role":"metric","nullable":true,"label":"Estimated Undocumented Population","short_description":"CMS's modeled estimate of undocumented Georgia residents in the group.","description":"CMS's estimate of the undocumented residents of Georgia in the row's group (every breakdown 'all' = the whole population), rounded to the nearest 1,000. A modeled stock, not a count.","valid_values":null,"example":168000,"unit":"count","value_min":null,"value_max":null,"null_meaning":"withheld by CMS ('--'): fewer than 1,000 people, not shown - birthplace rows only; none in the 2024 Georgia release","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"estimated_population","usage":"Star-schema fact table of Georgia statewide rows (county_fips always NULL). Keep every breakdown column at 'all' for the total; to break down, set ONE of demographic, age_bracket, region_of_birth, country_of_birth or years_in_us and keep the others at 'all' - never two at once. Sum only within one breakdown. Read directly with DuckDB over Parquet.","limitations":"A MODELED ESTIMATE, not a count of people: the Center for Migration Studies of New York (CMS) estimates the undocumented population from American Community Survey microdata (logical edits that remove likely legal residents, population controls by country, and an undercount adjustment; method: Robert Warren, Journal on Migration and Human Security, 2021). CMS labels the release data year 2024 and does not state the underlying ACS vintage. CMS publishes no margin of error; the figures are uncertain by an unquantified amount. The 'all' row (502,000) is the same CMS figure served as estimator = 'cms', year = 2024 in undocumented_population_estimates, which compares CMS with Pew, MPI and DHS. Of the four estimators' files collected here, only CMS's state file carries breakdowns, so this topic has CMS alone; MPI publishes state profiles with differently banded breakdowns on its website, which are not collected. For the size of Georgia's undocumented population, and how the estimators differ (340,000-502,000 for the latest years), use undocumented_population_estimates. BREAKDOWNS ARE NEVER CROSSED: CMS publishes each one separately (sex, age, region of birth, country of birth, years in the U.S.). A breakdown row carries 'all' in the other four columns, so filter one breakdown at a time, keep the rest at 'all', and never sum across two breakdowns (there is no 'women from Mexico' cell). Rounding: CMS rounds every cell to the nearest 1,000, so each value is within 500 of CMS's unrounded estimate, and a breakdown's parts need not add to the total: the age brackets sum to 501,000 against 502,000. On birthplace rows CMS also withholds values under 1,000 (below), and it does not say whether it applies that rule before or after rounding, so a published birthplace 1,000 means roughly 500-1,499 or 1,000-1,499. region_of_birth uses CMS's eight regions. CMS's north_america is Mexico and Canada, with central_america and caribbean as separate regions - unlike the DHS OHSS north_america in the naturalizations and new_permanent_residents topics (which includes Central America and the Caribbean) and the ACS regions in the census topics. country_of_birth lists the 31 countries CMS publishes, chosen by CMS nationally; it is NOT exhaustive: the listed countries sum to 472,000 of 502,000, and there is no 'other' row (a residual would carry up to +/-16,000 of rounding). 'korea' is CMS's unsplit 'Korea'; 'china' is CMS's 'China' (CMS does not say whether Hong Kong and Taiwan are included). CMS does not show a country or region with fewer than 1,000 undocumented residents in a state ('--' in its file, NULL here); no Georgia cell is withheld in the 2024 release. years_in_us is years since arrival in the United States at the data year: under_5 (184,000) matches CMS's own 'arrived 2020 onward' count. demographic carries sex (female, male) as the ACS records it; age_bracket follows CMS's eight age bands. Not included: CMS's race and Hispanic-origin breakdown (CMS does not say whether Pacific Islanders fall in 'Asian non-Hispanic' or 'Other non-Hispanic'); its liminal-status flags (DACA, TPS, parole, SIJS, U/T visa, pending asylum), whose categories overlap (Georgia's sum to 253,000 against 193,000 people with any liminal status) and so cannot be one breakdown; its period-of-entry table (an undefined smaller universe); its year-of-immigration table (the same information as years_in_us); and its socio-economic tables (marital status, English ability, language, school enrollment, education, computer access, health insurance, employment, occupation, poverty, family size, income). Georgia statewide only: CMS publishes states, not counties, and the other states and the national row are not included. Every value is CMS's published aggregate; this platform applies no suppression or adjustment. CMS's term is 'undocumented'.","null_semantics":{"suppressed_to_null":true,"zero_is_real":true},"available_years":[2024],"schema_hash":"8bef27a49d9fbd3708ec8dcf02d72163335f8e2c64cb2114fd347f5bd529d22d","tags":["immigration","center for migration studies of new york, state and national data tool","undocumented_population_characteristics"],"granularity_description":"One row per year, county_fips, demographic, estimator, region_of_birth, country_of_birth, years_in_us, age_bracket.","example_queries":[{"description":"Latest year (2024), states detail","query":"SELECT * FROM undocumented_population_characteristics WHERE year = 2024 LIMIT 100"},{"description":"Filter by estimator = cms","query":"SELECT * FROM undocumented_population_characteristics WHERE estimator = 'cms' AND year = 2024 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":["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":"estimator","kind":"categorical","column":"estimator","type":"string","multi_value":true,"enum_enforced":true,"values":["cms"],"has_total":false,"total_value":null,"requires_single_value":true,"nullable":false,"null_filter_token":null},{"param":"region_of_birth","kind":"categorical","column":"region_of_birth","type":"string","multi_value":true,"enum_enforced":true,"values":["all","africa","asia","caribbean","central_america","europe","north_america","oceania","south_america"],"has_total":true,"total_value":"all","requires_single_value":false,"nullable":false,"null_filter_token":null},{"param":"country_of_birth","kind":"categorical","column":"country_of_birth","type":"string","multi_value":true,"enum_enforced":true,"values":["all","afghanistan","argentina","bangladesh","brazil","canada","chile","china","colombia","dominican_republic","ecuador","el_salvador","ethiopia","ghana","guatemala","haiti","honduras","india","jamaica","korea","mexico","nepal","nicaragua","nigeria","pakistan","peru","philippines","poland","russia","ukraine","venezuela","vietnam"],"has_total":true,"total_value":"all","requires_single_value":false,"nullable":false,"null_filter_token":null},{"param":"years_in_us","kind":"categorical","column":"years_in_us","type":"string","multi_value":true,"enum_enforced":true,"values":["all","10_14","15_19","20_plus","5_9","under_5"],"has_total":true,"total_value":"all","requires_single_value":false,"nullable":false,"null_filter_token":null},{"param":"age_bracket","kind":"categorical","column":"age_bracket","type":"string","multi_value":true,"enum_enforced":true,"values":["all","18_20","21_24","25_34","35_44","45_64","5_17","65_plus","under_5"],"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/undocumented_population_characteristics/values"}