Saltar al contenido
← Todos los conjuntos de datos

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.

Cobertura de años
2020–2024
Actualización
annual
Versión
1.0.0
Hash del esquema
be44c147f219

Niveles de detalle disponibles

EstadoCondado · predeterminadoDistrito

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.

Métrica clave

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.

ColumnaTipoUnidadRango¿Nulo?Descripción
yearYearinteger——noACS 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_fipsCounty FIPSstring——yes5-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.

Se une a counties; agrega sus columnas de etiqueta.

district_codeDistrict Codestring——yesGCD 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.

Se une a districts; agrega sus columnas de etiqueta.

tract_geoidTract GEOIDstring——yes11-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.

Se une a tracts; agrega sus columnas de etiqueta.

region_of_birthRegion of Birthstring——noWorld 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
  • all — total / agregado
  • europe
  • asia
  • africa
  • oceania
  • latin_america
  • northern_america
sub_region_of_birthSub Region of Birthstring——noCensus 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
  • all — total / agregado
  • northern_europe
  • western_europe
  • southern_europe
  • eastern_europe
  • eastern_asia
  • south_central_asia
  • south_eastern_asia
  • western_asia
  • eastern_africa
  • middle_africa
  • northern_africa
  • southern_africa
  • western_africa
  • australia_and_new_zealand
  • caribbean
  • central_america
  • south_america
country_of_birthCountry of Birthstring——noCountry 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
  • all — total / agregado
  • denmark
  • ireland
  • norway
  • sweden
  • united_kingdom
  • other_northern_europe
  • austria
  • belgium
  • france
  • germany
  • netherlands
  • switzerland
  • other_western_europe
  • greece
  • italy
  • portugal
  • spain
  • other_southern_europe
  • albania
  • belarus
  • bosnia_and_herzegovina
  • bulgaria
  • croatia
  • czechoslovakia
  • hungary
  • latvia
  • lithuania
  • moldova
  • north_macedonia
  • poland
  • romania
  • russia
  • serbia
  • ukraine
  • other_eastern_europe
  • europe_nec
  • china
  • japan
  • korea
  • other_eastern_asia
  • afghanistan
  • bangladesh
  • bhutan
  • india
  • iran
  • kazakhstan
  • nepal
  • pakistan
  • sri_lanka
  • uzbekistan
  • other_south_central_asia
  • burma_myanmar
  • cambodia
  • indonesia
  • laos
  • malaysia
  • philippines
  • singapore
  • thailand
  • vietnam
  • other_south_eastern_asia
  • armenia
  • azerbaijan
  • georgia_country
  • iraq
  • israel
  • jordan
  • kuwait
  • lebanon
  • saudi_arabia
  • syria
  • turkey
  • united_arab_emirates
  • yemen
  • other_western_asia
  • asia_nec
  • eritrea
  • ethiopia
  • kenya
  • somalia
  • tanzania
  • uganda
  • zimbabwe
  • other_eastern_africa
  • cameroon
  • congo
  • democratic_republic_of_congo
  • other_middle_africa
  • algeria
  • egypt
  • morocco
  • sudan
  • other_northern_africa
  • south_africa
  • other_southern_africa
  • cabo_verde
  • ghana
  • ivory_coast
  • liberia
  • nigeria
  • senegal
  • sierra_leone
  • togo
  • other_western_africa
  • africa_nec
  • australia
  • other_australia_and_new_zealand
  • fiji
  • marshall_islands
  • micronesia
  • oceania_nec
  • bahamas
  • barbados
  • cuba
  • dominica
  • dominican_republic
  • grenada
  • haiti
  • jamaica
  • st_lucia
  • st_vincent_and_the_grenadines
  • trinidad_and_tobago
  • west_indies
  • other_caribbean
  • belize
  • costa_rica
  • el_salvador
  • guatemala
  • honduras
  • mexico
  • nicaragua
  • panama
  • other_central_america
  • argentina
  • bolivia
  • brazil
  • chile
  • colombia
  • ecuador
  • guyana
  • peru
  • uruguay
  • venezuela
  • other_south_america
  • canada
  • other_northern_america
country_of_birth_detailCountry of Birth Detailstring——noParts 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
  • all — total / agregado
  • united_kingdom_excluding_england_and_scotland
  • england
  • scotland
  • azores_islands
  • china_excluding_hong_kong_and_taiwan
  • hong_kong
  • taiwan
population_countPopulation Countintegercount—yesEstimated 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_moePopulation Count Moeintegercount—yes90 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ámetroTipoValores permitidosNotas
yearyear_exactcualquier valor—
year_minyear_rangecualquier valor—
year_maxyear_rangecualquier valor—
detaildetailcountiesdistrictsstatestractsenum validado, predeterminado: counties
district_codeforeign_keycualquier valorvalores múltiples
county_fipsforeign_keycualquier valorvalores múltiples
tract_geoidforeign_keycualquier valorvalores múltiples
region_of_birthcategorical
7 valores permitidos
  • all
  • europe
  • asia
  • africa
  • oceania
  • latin_america
  • northern_america
valores múltiples, enum validado
sub_region_of_birthcategorical
18 valores permitidos
  • all
  • northern_europe
  • western_europe
  • southern_europe
  • eastern_europe
  • eastern_asia
  • south_central_asia
  • south_eastern_asia
  • western_asia
  • eastern_africa
  • middle_africa
  • northern_africa
  • southern_africa
  • western_africa
  • australia_and_new_zealand
  • caribbean
  • central_america
  • south_america
valores múltiples, enum validado
country_of_birthcategorical
147 valores permitidos
  • all
  • denmark
  • ireland
  • norway
  • sweden
  • united_kingdom
  • other_northern_europe
  • austria
  • belgium
  • france
  • germany
  • netherlands
  • switzerland
  • other_western_europe
  • greece
  • italy
  • portugal
  • spain
  • other_southern_europe
  • albania
  • belarus
  • bosnia_and_herzegovina
  • bulgaria
  • croatia
  • czechoslovakia
  • hungary
  • latvia
  • lithuania
  • moldova
  • north_macedonia
  • poland
  • romania
  • russia
  • serbia
  • ukraine
  • other_eastern_europe
  • europe_nec
  • china
  • japan
  • korea
  • other_eastern_asia
  • afghanistan
  • bangladesh
  • bhutan
  • india
  • iran
  • kazakhstan
  • nepal
  • pakistan
  • sri_lanka
  • uzbekistan
  • other_south_central_asia
  • burma_myanmar
  • cambodia
  • indonesia
  • laos
  • malaysia
  • philippines
  • singapore
  • thailand
  • vietnam
  • other_south_eastern_asia
  • armenia
  • azerbaijan
  • georgia_country
  • iraq
  • israel
  • jordan
  • kuwait
  • lebanon
  • saudi_arabia
  • syria
  • turkey
  • united_arab_emirates
  • yemen
  • other_western_asia
  • asia_nec
  • eritrea
  • ethiopia
  • kenya
  • somalia
  • tanzania
  • uganda
  • zimbabwe
  • other_eastern_africa
  • cameroon
  • congo
  • democratic_republic_of_congo
  • other_middle_africa
  • algeria
  • egypt
  • morocco
  • sudan
  • other_northern_africa
  • south_africa
  • other_southern_africa
  • cabo_verde
  • ghana
  • ivory_coast
  • liberia
  • nigeria
  • senegal
  • sierra_leone
  • togo
  • other_western_africa
  • africa_nec
  • australia
  • other_australia_and_new_zealand
  • fiji
  • marshall_islands
  • micronesia
  • oceania_nec
  • bahamas
  • barbados
  • cuba
  • dominica
  • dominican_republic
  • grenada
  • haiti
  • jamaica
  • st_lucia
  • st_vincent_and_the_grenadines
  • trinidad_and_tobago
  • west_indies
  • other_caribbean
  • belize
  • costa_rica
  • el_salvador
  • guatemala
  • honduras
  • mexico
  • nicaragua
  • panama
  • other_central_america
  • argentina
  • bolivia
  • brazil
  • chile
  • colombia
  • ecuador
  • guyana
  • peru
  • uruguay
  • venezuela
  • other_south_america
  • canada
  • other_northern_america
valores múltiples, enum validado
country_of_birth_detailcategorical
8 valores permitidos
  • all
  • united_kingdom_excluding_england_and_scotland
  • england
  • scotland
  • azores_islands
  • china_excluding_hong_kong_and_taiwan
  • hong_kong
  • taiwan
valores múltiples, enum validado
district_typedimension_attribute
7 valores permitidos
  • commission_charter
  • resa
  • standard
  • state_agency
  • state_charter
  • state_school
  • state_special
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&region_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.