{"main_topic":"immigration","sub_topic":"dhs_ohss","topic":"new_permanent_residents","key":"immigration/dhs_ohss/new_permanent_residents","version":"1.0.0","year_min":2007,"year_max":2024,"year_gaps":[],"update_frequency":"annual","detail_levels":["counties","states"],"default_detail":"states","path_template":"immigration/new_permanent_residents/year={year}/{detail}.parquet","grain":["year","county_fips","country_of_birth","class_of_admission"],"title":"New Lawful Permanent Residents","summary":"Georgians who became lawful permanent residents (green card) by fiscal year: state totals, and top counties by country and class.","description":"Number of people who obtained lawful permanent resident (LPR, green card) status while living in Georgia, by federal fiscal year, from the DHS Office of Homeland Security Statistics (OHSS). Statewide totals FY2015-FY2024 (Yearbook of Immigration Statistics 2024, Table 4) with a country-of-birth breakdown for FY2024 (Supplemental Table 1); and, for the 4-7 Georgia counties among the 200 U.S. counties with the most new LPRs each year, FY2007-FY2024 counts by country of birth and major class of admission (OHSS Top 200 Counties tables). OHSS publishes no county all-country/all-class total; the key metric num_new_lprs_estimated carries a platform estimate there and OHSS's figures (its cells, exact sums of them, or 0 where it lists none) everywhere else; num_new_lprs is the same series without the estimates.","source":"DHS Office of Homeland Security Statistics (OHSS) - New LPRs by State, County, Country of Birth, and Major Class of Admission (Top 200 Counties); Yearbook of Immigration Statistics 2024. County all-country/all-class totals estimated by Georgia Civic Data","source_url":"https://ohss.dhs.gov/topics/immigration/lawful-permanent-residents/lpr-state-county-country-birth-and-major-class","endpoint":"/api/v1/immigration/new_permanent_residents","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Federal fiscal year (October 1 - September 30) in which the people obtained lawful permanent resident status, as OHSS publishes it. County rows FY2007-FY2024; state totals FY2015-FY2024.","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":"5-digit county FIPS. NULL on Georgia statewide rows. Set only for the Georgia counties in OHSS's top 200 U.S. counties by new LPRs that year (4-7 a year: Chatham, Clayton, Cobb, DeKalb, Forsyth, Fulton, Gwinnett). A county-year with no rows was not in the top 200 (not zero).","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":"country_of_birth","type":"string","role":"categorical","nullable":false,"label":"Country of Birth","short_description":"Country of birth: 26 leading countries, other, unknown, or all.","description":"Country of birth as OHSS records it. 'all' = every country (the total). The 26 named countries are the union of Georgia's 20 leading countries of birth in three OHSS rankings (FY2024 new LPRs and naturalizations statewide, and new LPRs in Georgia's top-200 counties FY2007-FY2024). 'other' = every other country, including the country of Georgia, dissolved states, and OHSS's residual row. 'unknown' = unknown, stateless, or the FY2007 'Non-quota immigrant' code. State rows carry the breakdown for FY2024 only. 'china' is mainland China only (Hong Kong and Taiwan are in 'other') and 'united_kingdom' excludes the Crown Dependencies, unlike the census country-of-birth topic. Shared with the naturalizations topic.","valid_values":["all","afghanistan","bangladesh","brazil","burma","china","colombia","cuba","dominican_republic","el_salvador","ethiopia","ghana","guatemala","haiti","honduras","india","iran","jamaica","kenya","mexico","nigeria","pakistan","philippines","south_korea","united_kingdom","venezuela","vietnam","other","unknown"],"example":"all","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"class_of_admission","type":"string","role":"categorical","nullable":false,"label":"Class of Admission","short_description":"Legal channel of the green card (family, employment, diversity, refugee/asylee, other), or all.","description":"OHSS major class of admission: immediate relatives of U.S. citizens (spouse, parent, child), family preference 1st-4th, employment preference 1st-5th (3rd split skilled/unskilled), diversity visa program, refugee and asylee adjustments, and 'other' (OHSS's residual: special immigrants incl. Afghan and Iraqi SIVs, cancellation of removal, parolees, ...). 'all' = every class. County rows only; state rows are always 'all'.","valid_values":["all","immediate_relative_spouse","immediate_relative_parent","immediate_relative_child","family_preference_1st","family_preference_2nd","family_preference_3rd","family_preference_4th","employment_preference_1st","employment_preference_2nd","employment_preference_3rd_skilled","employment_preference_3rd_unskilled","employment_preference_4th","employment_preference_5th","diversity","refugee_asylee_adjustment","other"],"example":"all","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"num_new_lprs","type":"integer","role":"metric","nullable":true,"label":"New Lawful Permanent Residents (OHSS)","short_description":"OHSS's count of people who obtained lawful permanent resident status (its published cells or exact sums of them); NULL on county all-country/all-class totals.","description":"OHSS's published cells, or exact sums of them (0 where OHSS lists no admissions). num_new_lprs_estimated (the key metric) is identical except on the county all-country/all-class totals, which are NULL here in every county-year and estimated there. Number of people who obtained lawful permanent resident status while living in Georgia (or the county). County rows FY2007-FY2022 are exact counts: cells of 1-3 are withheld (NULL), and a combination OHSS does not list is 0. County rows FY2023-FY2024 and all state rows are rounded by OHSS to the nearest 10, so a 0 there means 0-4. A county 'all' total or 'other'/'unknown' bucket is the sum of the OHSS cells in it, published only when no constituent is withheld or, from FY2023, rounded to 0. A FY2023+ sum of several rounded cells carries OHSS's rounding (up to +/-5 per cell). State totals are Yearbook Table 4; the FY2024 state country rows are Supplemental Table 1 cells.","valid_values":null,"example":35100,"unit":"count","value_min":null,"value_max":null,"null_meaning":"County rows only; never NULL on state rows. Withheld by OHSS: the cell was published as 'D' (1-3 people, FY2007-FY2022). Or the value would be a sum of OHSS cells (an 'all' total or the 'other'/'unknown' bucket) that includes a withheld cell or, from FY2023, a cell rounded to 0 (0-4 people), so the true count is unknown and the sum of the published cells would understate it. That is the case for every county all-country/all-class total; num_new_lprs_estimated carries a platform estimate there.","key_metric_grain_contributor":false,"metric_component":null},{"name":"num_new_lprs_estimated","type":"integer","role":"metric","nullable":true,"label":"New Lawful Permanent Residents (county totals estimated)","short_description":"People who obtained lawful permanent resident status (a green card) in the fiscal year: OHSS's figures, except county all-country/all-class totals, which are platform estimates.","description":"Number of people who obtained lawful permanent resident status while living in Georgia (or the county): the headline series. It equals num_new_lprs (OHSS's published cells, or exact sums of them) on every row except a county's all-country/all-class total, which OHSS never publishes and which is a PLATFORM ESTIMATE here, rounded to a whole number. FY2007-FY2022: the county's published cells plus 1.55 per cell OHSS withheld as 'D' (1-3 people). FY2023-FY2024: each cell OHSS lists, rounded to the nearest 10, is replaced by its expected true count - the average of Georgia's exact FY2007-FY2022 cells that round to the same value, counting a withheld cell as 1.55 (1.81 for a 0, 7.85 for a 10) - then summed. Tested on held-out FY2015-FY2022 years, the estimate came within about 1% of the total the exact cells imply at the median and 5% at worst, larger for smaller counties; the true total may be about 6% lower to 14% higher (the published cells plus 1 to 3 per withheld cell; the hard bounds are wider from FY2023). Withheld cells and partial county subtotals are NULL, as in num_new_lprs; they are never estimated. State rows are Yearbook Table 4 and Supplemental Table 1 figures.","valid_values":null,"example":35100,"unit":"count","value_min":null,"value_max":null,"null_meaning":"County rows only, and never on a county's all-country/all-class total (a platform estimate there) or on state rows. Elsewhere NULL exactly where num_new_lprs is NULL: a cell OHSS withheld as 'D' (1-3 people, FY2007-FY2022), or a partial county subtotal (one country or the 'other'/'unknown' bucket across all classes, all countries in one class, or a bucket x class sum) that includes a withheld cell or, from FY2023, a cell rounded to 0 (0-4 people). These are never estimated, so OHSS's small-cell protection holds.","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"num_new_lprs_estimated","usage":"Star-schema fact table. num_new_lprs_estimated is the headline column; num_new_lprs is the same series without the estimates. State rows (county_fips NULL) are the complete statewide series - filter country_of_birth = 'all' and class_of_admission = 'all' for Georgia's total. County rows exist only for the Georgia counties in each year's top-200 list; their country x class cells are OHSS's own, and their all-country/all-class totals are platform estimates in num_new_lprs_estimated (NULL in num_new_lprs). Most partial county 'all' totals are NULL in both. Never add counties to get a state figure. Read directly with DuckDB over Parquet.","limitations":"num_new_lprs_estimated (the key metric) equals OHSS's num_new_lprs on every row except a county's all-country/all-class total. OHSS never publishes that total, so there it is a PLATFORM ESTIMATE: exact cells plus an expected size per withheld (1-3) cell, or from FY2023 each rounded cell's expected size. In held-out FY2015-FY2022 tests it was within about 1% (median; 5% at worst, larger for small counties) of the exact cells' implied total; the truth may be about 6% lower to 14% higher. year is the FEDERAL FISCAL YEAR (October 1 - September 30; FY2024 = 2023-10-01 to 2024-09-30), as OHSS publishes it; there is no month. These figures match OHSS's published fiscal-year tables, not calendar-year counts. Two grains from two OHSS products. STATE rows (county_fips NULL): Georgia's total new LPRs FY2015-FY2024 from the Yearbook of Immigration Statistics 2024, Table 4 (country_of_birth and class_of_admission = 'all'), plus a country-of-birth breakdown for FY2024 only, from Supplemental Table 1. OHSS publishes no state class-of-admission breakdown, so state rows never carry a class other than 'all'. Earlier state totals (FY2007-FY2014) are in older Yearbook editions that were not collected. COUNTY rows come from OHSS's 'Top 200 Counties' tables: only the 200 U.S. counties with the most new LPRs each year appear, recomputed every year, and Georgia has 4-7 of them. A Georgia county with no rows in a year was NOT AMONG THE 200 LARGEST U.S. COUNTIES THAT YEAR - it is not zero, and no row is emitted for it. The other 152 Georgia counties never appear. Georgia counties and their years: Chatham (13051): FY2007, FY2015-FY2024; Clayton (13063): FY2007-FY2010, FY2015-FY2016, FY2021; Cobb (13067): FY2007-FY2024; DeKalb (13089): FY2007-FY2024; Forsyth (13117): FY2020-FY2024; Fulton (13121): FY2007-FY2024; Gwinnett (13135): FY2007-FY2024. County lines therefore have gaps, and a county-level sum across counties is not a Georgia total. County breakdowns do not represent the state: in FY2024 the 6 counties' published cells put India first (2,080), while the statewide Supplemental Table 1 puts Mexico first (4,540), because the leading countries' new LPRs are spread differently across counties above and below the top-200 cut. Use the state rows for a statewide country breakdown. Disclosure, FY2007-FY2022 (county rows): OHSS withholds every cell of 1-3 people as 'D' (61%-65% of cells nationally) and publishes exact counts otherwise. A withheld cell is NULL. A country x class combination OHSS does not list had no admissions and is 0. Every 'all' total and every 'other'/'unknown' bucket is a sum of OHSS cells, and it is NULL when any of those cells is withheld, because the published cells would understate it. As a result num_new_lprs is NULL on the county all-country/all-class total in every one of these years; num_new_lprs_estimated carries a platform estimate there. Disclosure, FY2023-FY2024 (county rows): OHSS rounds every cell to the nearest 10 and withholds nothing, so a published 0 means 0-4 people (OHSS lists only combinations with at least one admission). A single cell is OHSS's rounded figure. A sum of two or more cells that includes a rounded 0 is NULL, because summing rounded county cells systematically understates the count: most county cells are 1-4 people rounded to 0. Applying the FY2023 rounding rule to the exact FY2022 Georgia cells gives county sums 3%-30% below the true totals. For the same reason num_new_lprs is NULL on every county all-country/all-class total in these years too (num_new_lprs_estimated estimates it), and on most partial 'all' totals, which are never estimated. A published sum of several rounded cells carries OHSS's rounding (up to +/-5 per cell). For example, the FY2024 cells of the 6 counties sum to 19,570, but that is not their count of new LPRs; their estimated totals sum to 21,330. State figures are OHSS's own, rounded to the nearest 10 (a 0 means 0-4). The FY2024 state country rows are Supplemental Table 1 cells; 'other' sums the non-served countries and OHSS's own residual row. Those rows sum to 35,190, against OHSS's published total of 35,100 ('Totals may not sum due to rounding'): the 'all' row is OHSS's total, never the sum. How the county totals in num_new_lprs_estimated are estimated (county rows with country_of_birth and class_of_admission = 'all' only; num_new_lprs is NULL there). The frequencies of Georgia's exact FY2007-FY2022 county cells of 4-20 people, fitted by a quadratic on the log-log scale and extrapolated to 1-3, put the average withheld cell at 1.55 people. FY2007-FY2022: the published cells plus 1.55 per 'D' cell; the true total lies between the published cells plus 1 and plus 3 per 'D' cell (about 6% below to 14% above the estimate at the median; from FY2023 the hard bounds are wider). FY2023-FY2024: each cell OHSS lists is replaced by its expected true count - the average of the exact calibration cells that round to the same value, counting a withheld cell as 1.55 (the midpoint where too few calibration cells share the value) - (1.81 for a 0, which is 1-4 people; 7.85 for a 10; 18.7 for a 20), and those are summed. Validation: each FY2015-FY2022 year was held out, its exact cells were rounded as OHSS rounds them from FY2023 (a 'D' to 0), and each county total was re-estimated from the rounded cells with a calibration on the other years. 46 of 46 estimates fell inside the range the withheld cells allow; the median error was 0.9% and the largest 5.1%, against that year's own published-plus-1.55-per-'D' total - itself an estimate, so this measures the reconstruction from rounded cells, not error against a known true total - while the raw sums of the rounded cells ran 6%-29% low. The estimated county totals stay below the state total in every year with one (61%-74% of it). They are this platform's estimates, not OHSS figures; cite them as estimates. Withheld cells and partial county subtotals are never estimated. country_of_birth serves 26 named countries: the union of Georgia's 20 leading countries of birth among FY2024 new LPRs statewide, FY2024 naturalizations statewide, and new LPRs in Georgia's top-200 counties FY2007-FY2024 (together 75-80% of each ranking). 'other' holds every other country, including the country of Georgia (the Caucasus nation), dissolved states recorded as they stood at birth (Soviet Union, Czechoslovakia, Serbia and Montenegro, Netherlands Antilles), and OHSS's residual row of countries with fewer than 100 new LPRs nationally. 'unknown' = an unknown country, stateless, or the FY2007 'Non-quota immigrant' code. The same vocabulary serves the naturalizations topic. 'china' is OHSS's \"China, People's Republic\" (mainland only): Hong Kong and Taiwan are separate OHSS countries in 'other'. Likewise 'united_kingdom' leaves out Guernsey, Jersey and the Isle of Man, which OHSS lists separately. The census foreign_born_by_country_of_birth topic's china and united_kingdom include them, so compare with care. class_of_admission is OHSS's 16 major classes. The skilled/unskilled split of the employment third preference is detail beyond Yearbook Table 6. 'other' is OHSS's residual (special immigrants including Afghan and Iraqi special immigrant visas, cancellation of removal, parolees, and others), not a class of its own. People are counted at their state and county of residence as recorded by OHSS when they obtained LPR status, whether they adjusted status inside the U.S. or were admitted from abroad. These are OHSS-published aggregates. This platform applies no suppression of its own: a NULL is OHSS's withholding, or a sum that would not be a count. Its only estimated values are the county all-country/all-class totals in num_new_lprs_estimated; it also sums OHSS cells into the 'all' totals and the 'other'/'unknown' buckets, and fills combinations OHSS does not list with 0. Source: U.S. Department of Homeland Security, Office of Homeland Security Statistics (OHSS), New LPRs by State, County, Country of Birth, and Major Class of Admission (Top 200 Counties), FY2007-FY2024 (https://ohss.dhs.gov/topics/immigration/lawful-permanent-residents/lpr-state-county-country-birth-and-major-class), and Yearbook of Immigration Statistics 2024, Table 4 and Supplemental Table 1 (https://ohss.dhs.gov/topics/immigration/yearbook/2024).","null_semantics":{"suppressed_to_null":true,"zero_is_real":false},"available_years":[2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024],"schema_hash":"5068624aa0a57f9ccf605de6c26c70cf6acdc8ac17d23d79938ed5b14208100e","tags":["immigration","dhs office of homeland security statistics","new_permanent_residents"],"granularity_description":"One row per year, county_fips, country_of_birth, class_of_admission (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2024), states detail","query":"SELECT * FROM new_permanent_residents WHERE year = 2024 LIMIT 100"},{"description":"Filter by country_of_birth = all","query":"SELECT * FROM new_permanent_residents WHERE country_of_birth = 'all' AND year = 2024 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":"country_of_birth","kind":"categorical","column":"country_of_birth","type":"string","multi_value":true,"enum_enforced":true,"values":["all","afghanistan","bangladesh","brazil","burma","china","colombia","cuba","dominican_republic","el_salvador","ethiopia","ghana","guatemala","haiti","honduras","india","iran","jamaica","kenya","mexico","nigeria","pakistan","philippines","south_korea","united_kingdom","venezuela","vietnam","other","unknown"],"has_total":true,"total_value":"all","requires_single_value":false,"nullable":false,"null_filter_token":null},{"param":"class_of_admission","kind":"categorical","column":"class_of_admission","type":"string","multi_value":true,"enum_enforced":true,"values":["all","immediate_relative_spouse","immediate_relative_parent","immediate_relative_child","family_preference_1st","family_preference_2nd","family_preference_3rd","family_preference_4th","employment_preference_1st","employment_preference_2nd","employment_preference_3rd_skilled","employment_preference_3rd_unskilled","employment_preference_4th","employment_preference_5th","diversity","refugee_asylee_adjustment","other"],"has_total":true,"total_value":"all","requires_single_value":false,"nullable":false,"null_filter_token":null}],"filter_hints":[],"values_endpoint":"/api/v1/immigration/new_permanent_residents/values"}