Foreign-Born Population by Country of Birth (ACS)
Where Georgia's foreign-born residents were born - world region, sub-region, and about 150 countries - ACS 5-year estimates down to the census tract.
- 2020–2024
- annual
- 1.0.0
- be44c147f219
Resumen
The foreign-born population by place of birth from the American Community Survey 5-year estimates (detailed table B05006, Place of Birth for the Foreign-Born Population in the United States), for Georgia at state, county, school district, and census tract geography, vintages 2020-2024: the total, six world regions, 17 sub-regions, and every country or residual area of birth the Census tabulates (146 from 2022, 136 before), with the United Kingdom, China, and Portugal detail, each with its 90 percent margin of error.
Granularidad de fila: Una fila por year, county_fips, district_code, tract_geoid, region_of_birth, sub_region_of_birth, country_of_birth, country_of_birth_detail.
population_count — Population Count (count)
El valor principal que la mayoría de las consultas busca.
Variables
Todas las columnas de la tabla de hechos. El código es el nombre exacto del campo que devuelve la API.
| Columna | Tipo | Unidad | Rango | ¿Nulo? | Descripción |
|---|---|---|---|---|---|
year | integer | — | — | no | ACS 5-year vintage END year: 2024 covers the pooled 2020-2024 survey period. Consecutive vintages overlap.Descripción completa▾ACS 5-year vintage END year: 2024 covers the pooled 2020-2024 survey period. Consecutive vintages overlap. |
county_fips | string | — | — | yes | 5-digit county FIPS code (state 13 + county). Populated only on county-level rows.Descripción completa▾5-digit county FIPS code (state 13 + county). Populated only on county-level rows. |
district_code | string | — | — | yes | GCD school district code (FK to the education districts dimension). Populated only on district-level rows - Census unified-school-district estimates mapped onto the ~180 standard districts via the dimension's district_census_id.Descripción completa▾GCD school district code (FK to the education districts dimension). Populated only on district-level rows - Census unified-school-district estimates mapped onto the ~180 standard districts via the dimension's district_census_id. |
tract_geoid | string | — | — | yes | 11-digit census tract GEOID (2020 boundaries). Populated only on tract-level rows.Descripción completa▾11-digit census tract GEOID (2020 boundaries). Populated only on tract-level rows. |
region_of_birth | string | — | — | no | World region the foreign born were born in; pin it to reach its sub-regions and countries.Descripción completa▾World region of birth, with the same six values as foreign_born_population's region_of_birth: europe, asia, africa, oceania, latin_america (the Caribbean, Central America including Mexico, and South America), northern_america (Canada and other Northern America). 'all' is the whole foreign-born population (excluding people born at sea). With the other three columns at 'all' the six regions partition the total exactly. B05006 groups latin_america and northern_america under an Americas subtotal, which is not served (it is exactly their sum). Every sub-region and country row carries its region here, so pin region_of_birth before breaking down by sub_region_of_birth or country_of_birth. 7 valores permitidos▾
|
sub_region_of_birth | string | — | — | no | Census sub-region subtotal; served only with country_of_birth = 'all'.Descripción completa▾Census sub-region subtotal within region_of_birth (e.g. northern_europe, eastern_asia, western_africa, caribbean, central_america - which includes Mexico - and south_america). Served only with country_of_birth = 'all': the countries of a sub-region are served at sub_region_of_birth = 'all' under their region, so a country row does not name its sub-region. The sub-regions do not always cover their region: europe_nec, asia_nec, africa_nec, fiji, marshall_islands, micronesia, and oceania_nec sit directly under their region, and northern_america has no sub-regions, so the sub-regions of a region sum to at most the region (exactly, for latin_america). 18 valores permitidos▾
|
country_of_birth | string | — | — | no | Country of birth (or residual bucket); pin region_of_birth to the country's region first.Descripción completa▾Country of birth, or a Census residual bucket, exactly as B05006 lists them (146 values from vintage 2022, 136 before). Each value appears only under its own region_of_birth with sub_region_of_birth = 'all'; with country_of_birth_detail = 'all' the values of one region partition it exactly. Residual buckets are not countries: other_<sub-region> (the rest of a sub-region), <region>_nec (not elsewhere classified), and west_indies (West Indies, country not specified). Naming: georgia_country is the nation of Georgia (Western Asia), never the U.S. state; micronesia is the Federated States of Micronesia, a country; burma_myanmar is labeled Burma before 2022; korea is undivided (North and South); czechoslovakia includes the Czech Republic and Slovakia; congo is the Republic of the Congo, distinct from democratic_republic_of_congo (formerly Zaire); united_kingdom includes the Crown Dependencies and china includes Hong Kong and Taiwan (their parts are on country_of_birth_detail). First tabulated in vintage 2022, absent before: bhutan, azerbaijan, georgia_country, united_arab_emirates, tanzania, algeria, ivory_coast, togo, marshall_islands, st_lucia. Not comparable across 2021-2022 (they held those countries before): other_south_central_asia, other_western_asia, other_eastern_africa, other_northern_africa, other_western_africa, oceania_nec, other_caribbean. 147 valores permitidos▾
|
country_of_birth_detail | string | — | — | no | Parts of united_kingdom and china, and portugal's Azores.Descripción completa▾Finer place of birth the Census publishes inside three country_of_birth entries, served only under that country ('all' everywhere else): united_kingdom = united_kingdom_excluding_england_and_scotland + england + scotland, and china = china_excluding_hong_kong_and_taiwan + hong_kong + taiwan (exact partitions); portugal's only detail is azores_islands, a SUBSET of portugal (the Census publishes no 'rest of Portugal' cell), so the portugal details never sum to portugal. 8 valores permitidos▾
|
population_count | integer | — | yes | Estimated foreign-born residents born in the region, sub-region, or country.Descripción completa▾ACS 5-year estimate of the number of foreign-born residents (excluding people born at sea) in the (region_of_birth, sub_region_of_birth, country_of_birth, country_of_birth_detail) cell - always one published B05006 cell, never derived. A survey estimate, not a full count: most country cells are 0 at tract and small-county grain - see population_count_moe. | |
population_count_moe | integer | — | yes | 90 percent margin of error for population_count, as published by the Census for the same cell (never recomputed). Zero-estimate cells carry the standard small-cell margin, often larger than nearby non-zero estimates. Never the headline metric.Descripción completa▾90 percent margin of error for population_count, as published by the Census for the same cell (never recomputed). Zero-estimate cells carry the standard small-cell margin, often larger than nearby non-zero estimates. Never the headline metric. |
Filtros
Parámetros de consulta que acepta el endpoint de hechos. Los valores separados por comas son OR dentro de un parámetro; varios parámetros se combinan con AND.
| Parámetro | Tipo | Valores permitidos | Notas |
|---|---|---|---|
year | year_exact | cualquier valor | — |
year_min | year_range | cualquier valor | — |
year_max | year_range | cualquier valor | — |
detail | detail | countiesdistrictsstatestracts | enum validado, predeterminado: counties |
district_code | foreign_key | cualquier valor | valores múltiples |
county_fips | foreign_key | cualquier valor | valores múltiples |
tract_geoid | foreign_key | cualquier valor | valores múltiples |
region_of_birth | categorical | 7 valores permitidos▾
| valores múltiples, enum validado |
sub_region_of_birth | categorical | 18 valores permitidos▾
| valores múltiples, enum validado |
country_of_birth | categorical | 147 valores permitidos▾
| valores múltiples, enum validado |
country_of_birth_detail | categorical | 8 valores permitidos▾
| valores múltiples, enum validado |
district_type | dimension_attribute | 7 valores permitidos▾
| valores múltiples, enum validado |
Ejemplos de solicitudes
Ejecútalos contra la URL base: devuelven datos en vivo.
All rows (first page), counties level
curl "https://georgiacivicdata.org/api/v1/census/foreign_born_by_country_of_birth"counties data for 2024
curl "https://georgiacivicdata.org/api/v1/census/foreign_born_by_country_of_birth?year=2024"Filtered to region_of_birth = europe for 2024
curl "https://georgiacivicdata.org/api/v1/census/foreign_born_by_country_of_birth?year=2024®ion_of_birth=europe"One district (code 667), 2024
curl "https://georgiacivicdata.org/api/v1/census/foreign_born_by_country_of_birth?district_code=667&year=2024&detail=districts"One county (FIPS 13135), 2024
curl "https://georgiacivicdata.org/api/v1/census/foreign_born_by_country_of_birth?county_fips=13135&year=2024&detail=counties"Download 2024 as CSV
curl "https://georgiacivicdata.org/api/v1/census/foreign_born_by_country_of_birth?year=2024&format=csv"Notas y limitaciones
Manejo de NULL
- El cero es un valor real y reportado.
Limitaciones
Place of birth is a hierarchy on four categoricals and only 'all' rows overlap, so never sum across more than one axis: region_of_birth partitions the total; country_of_birth values exist only under their own region (with sub_region_of_birth = 'all') and partition it; sub_region_of_birth subtotals exist only with country_of_birth = 'all'; country_of_birth_detail splits united_kingdom and china exactly, while portugal's only detail, azores_islands, is a subset of portugal. The sub-regions of a region do not always cover it: europe_nec, asia_nec, africa_nec, fiji, marshall_islands, micronesia, and oceania_nec are published directly under their region, and northern_america (canada, other_northern_america) has no sub-regions. Ten countries were first tabulated in vintage 2022 (bhutan, azerbaijan, georgia_country, united_arab_emirates, tanzania, algeria, ivory_coast, togo, marshall_islands, st_lucia); before that they were counted inside other_south_central_asia, other_western_asia, other_eastern_africa, other_northern_africa, other_western_africa, oceania_nec, other_caribbean, so those residual buckets are not comparable across 2021-2022 and must never be summed with a later split-out country to rebuild the old bucket. Region and sub-region subtotals are unaffected. The universe excludes people born at sea: the total equals the foreign-born count of foreign_born_population through 2022 and is 32 (2023) or 29 (2024) people lower from 2023 (one Cobb County tract and its county and school-district parents), so compare the two topics with <=, not equality. B05006's Americas subtotal is not served; it equals latin_america + northern_america, which are served as regions to match foreign_born_population. Names: georgia_country is the nation of Georgia in Western Asia, not the U.S. state; korea is undivided; czechoslovakia includes the Czech Republic and Slovakia; united_kingdom includes the Crown Dependencies; china includes Hong Kong and Taiwan; west_indies and the other_* and *_nec values are residual buckets, not countries. Most country cells are 0 at tract and small-county grain, with margins far larger than the estimate. ACS 5-year period estimates: the year column is the vintage END year and each estimate pools five years of survey responses (2024 = 2020-2024). Consecutive vintages share about 80% of their sample, so the series is heavily smoothed - never difference overlapping vintages as if they were annual change. Estimates are survey-based and carry 90% margins of error (the *_moe columns); tract-level margins can be large relative to the estimate. All levels serve vintages 2020-2024 only, on 2020-vintage tract boundaries. State rows have NULL county_fips, district_code, and tract_geoid; county rows carry only county_fips, district rows only district_code, tract rows only tract_geoid. District rows cover the ~180 standard (city/county) districts only: the Census publishes school-district estimates at unified school district geography, which has no codes for charter schools, RESAs, or state agencies, and its few Census-only districts (e.g. the Fort Stewart military district) have no GCD district code and are dropped.