Saltar al contenido
← Todos los conjuntos de datos

Children of Immigrants (ACS)

How many children in each Georgia community live with at least one foreign-born parent, and how many were themselves born abroad - 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
0514724f6547

Niveles de detalle disponibles

EstadoCondado · predeterminadoDistrito

Resumen

Own children under 18 living in families and subfamilies by the nativity of their parents and their own nativity, from the American Community Survey 5-year estimates (detailed table B05009, Age and Nativity of Own Children Under 18 Years in Families and Subfamilies by Number and Nativity of Parents), for Georgia at state, county, school district, and census tract geography, vintages 2020-2024: children by age band (under 6 / 6 to 17), living arrangement (two parents / one parent), whether at least one co-resident parent is foreign-born, and whether the child is native or foreign-born, each with its 90 percent margin of error.

Granularidad de fila: Una fila por year, county_fips, district_code, tract_geoid, age_band, living_arrangement, parent_nativity, child_nativity.

Métrica clave

children_count — Children 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.

age_bandAge Bandstring——noUnder 6 or 6 to 17; 'all' is every own child under 18.
Descripción completa
Age of the child: under_6 (under 6 years) or 6_17 (6 to 17 years); 'all' is all own children under 18. A partition: under_6 + 6_17 = all on every row combination. The 'all' row at living_arrangement 'all' with both nativity axes at 'all' is the published B05009 total (cell 001); under_6 and 6_17 at that pin are the published subtotals 002 and 020; every other age_band 'all' row is the derived exact sum of its under_6 and 6_17 cells.
3 valores permitidos
  • all — total / agregado
  • under_6
  • 6_17
living_arrangementLiving Arrangementstring——noLives with two parents or with one parent.
Descripción completa
Whether the child lives with two parents or one parent (the Census family / subfamily structure); 'all' is both together. A partition: two_parents + one_parent = all on every row combination. Rows at 'all' with either nativity axis away from 'all' are derived exact sums of the two arrangement cells.
3 valores permitidos
  • all — total / agregado
  • two_parents
  • one_parent
parent_nativityParent Nativitystring——noWhether at least one co-resident parent was born abroad; pin to any_foreign_born_parent for children of immigrants.
Descripción completa
Nativity of the child's co-resident parent(s), collapsed to the pair defined in both living arrangements: any_foreign_born_parent (two parents: both foreign-born or one native and one foreign-born, B05009 cells 007 + 010; one parent: foreign-born parent, cell 017) vs no_foreign_born_parent (both parents native, cell 006; native parent, cell 016), and their 6-17 counterparts. 'all' is the arrangement subtotal. A partition: any + no = all at child_nativity 'all'. any_foreign_born_parent is the headline 'children of immigrants' measure; foreign-born includes naturalized citizens. The two-parent detail (both foreign-born vs one of each) is not served separately. Under no_foreign_born_parent the only child_nativity row is 'all'.
3 valores permitidos
  • all — total / agregado
  • any_foreign_born_parent
  • no_foreign_born_parent
child_nativityChild Nativitystring——noWhether the child was born in the U.S. or abroad.
Descripción completa
The child's own nativity: native (born in the U.S., Puerto Rico, a U.S. Island Area, or abroad to a U.S.-citizen parent) or foreign_born; 'all' is the subtotal. A partition where published: native + foreign_born = all under parent_nativity 'all' and 'any_foreign_born_parent'. The source has no child-nativity split for children with no foreign-born parent, so under no_foreign_born_parent only 'all' exists (nothing is derived). Most children of immigrants are native: pin parent_nativity to any_foreign_born_parent and read the native / foreign_born rows.
3 valores permitidos
  • all — total / agregado
  • native
  • foreign_born
children_countChildren Countintegercount—yesEstimated own children under 18 in the age / arrangement / parent-nativity / child-nativity category.
Descripción completa
ACS 5-year estimate of the number of own children under 18 in families and subfamilies in the (age_band, living_arrangement, parent_nativity, child_nativity) cell: the published B05009 cell where one exists (the three subtotals and the finest age x arrangement rows), else the exact sum of the published member cells (two-parent any_foreign_born_parent rows and every other rollup to an 'all' age band or arrangement). Survey estimate, not a full count - see children_count_moe.
children_count_moeChildren Count Moenumbercount—yes90 percent margin of error for children_count. Published margins are served as-is (cast to float, never rounded); derived rows carry the Census sqrt-sum-of-squares approximation over the published member-cell margins under the zero-estimate rule (of member cells whose estimate is 0 only the largest margin enters; non-integer). Never the headline metric.
Descripción completa
90 percent margin of error for children_count. Published margins are served as-is (cast to float, never rounded); derived rows carry the Census sqrt-sum-of-squares approximation over the published member-cell margins under the zero-estimate rule (of member cells whose estimate is 0 only the largest margin enters; non-integer). 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
age_bandcategoricalallunder_66_17valores múltiples, enum validado
living_arrangementcategoricalalltwo_parentsone_parentvalores múltiples, enum validado
parent_nativitycategoricalallany_foreign_born_parentno_foreign_born_parentvalores múltiples, enum validado
child_nativitycategoricalallnativeforeign_bornvalores 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/children_of_immigrants"

counties data for 2024

curl "https://georgiacivicdata.org/api/v1/census/children_of_immigrants?year=2024"

Filtered to age_band = under_6 for 2024

curl "https://georgiacivicdata.org/api/v1/census/children_of_immigrants?year=2024&age_band=under_6"

One district (code 667), 2024

curl "https://georgiacivicdata.org/api/v1/census/children_of_immigrants?district_code=667&year=2024&detail=districts"

One county (FIPS 13135), 2024

curl "https://georgiacivicdata.org/api/v1/census/children_of_immigrants?county_fips=13135&year=2024&detail=counties"

Download 2024 as CSV

curl "https://georgiacivicdata.org/api/v1/census/children_of_immigrants?year=2024&format=csv"

Notas y limitaciones

Manejo de NULL

  • El cero es un valor real y reportado.

Limitaciones

Universe: OWN children under 18 living in families and subfamilies - excludes children living with non-parent relatives (e.g. with grandparents and no parent present), foster and other unrelated children, and children in group quarters; parents' nativity refers to the co-resident parent(s) only, and a foreign-born parent may be a naturalized citizen. parent_nativity and child_nativity are two overlapping partitions of the same children: each is a complete breakdown when the other is pinned to 'all', and adding across both double-counts. The child_nativity split exists only under parent_nativity 'all' and 'any_foreign_born_parent'; under 'no_foreign_born_parent' the only row is child_nativity 'all' (the source has no such cell and none is derived). The three published subtotals (all ages / all arrangements, and each age band at all arrangements) carry published margins; every other age_band 'all' or living_arrangement 'all' row, and every any_foreign_born_parent row under two_parents, is derived as the exact sum of published B05009 cells with a Census sqrt-sum-of-squares margin under the zero-estimate rule (non-integer, served as a float) - including the headline all-ages, all-arrangements count of children with at least one foreign-born parent. The two-parent detail (both parents foreign-born vs one native and one foreign-born parent) is collapsed into any_foreign_born_parent and not served separately. B05009 publishes no annotation sentinels in vintages 2020-2024, so no margin is NULL. 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.