Enrollment Demographic Shares

Each demographic subgroup's share of enrollment by Georgia school, district, and statewide, 2004-2024.

Fuente: Governor's Office of Student Achievement (GOSA)
Cobertura de años: 2004–2024
Actualización: annual
Versión: 1.0.0
Hash del esquema: 4107571cf6b7

Niveles de detalle disponibles

EstadoDistritoEscuela · predeterminado

Resumen

Georgia Office of Student Achievement (GOSA) enrollment demographic shares. For every Georgia public school, school district, and the state as a whole, the share of enrollment in each of 12 demographic subgroups: six race/ethnicity buckets (Asian/Pacific Islander, Black, Hispanic, Native American, Multiracial, White), two sexes (male, female — published 2011 and 2018 onward), and four special populations (migrant — published 2011 onward, economically disadvantaged, students with disabilities, English learners). This topic is COMPUTED from the shared GOSA 'Enrollment by Subgroup Programs' bronze (FTE enrollment disaggregated by subgroup); the companion enrollment_program_participation topic exposes the program-participation side of the same files. enrollment_ratio is the share GOSA publishes for each subgroup: the subgroup's FTE count over the entity's total FTE enrollment (October snapshot denominator). Coverage spans school years 2003-04 through 2023-24. The 2004-2010 files also carry the NCLB-era Met AYP and Improvement Status indicators, denormalized across the 12 demographic rows per entity-year and NULL from 2011 on (AYP retired). Demographics whose column a source year does not publish (pre-2011 migrant/male/female; 2012-2017 male/female) are emitted with NULL enrollment_ratio so the 12-demographic grid is uniform across years.

Granularidad de fila: Una fila por year, district_code, school_code, demographic, met_ayp, improvement_status.

Métrica clave

enrollment_ratio — Enrollment Ratio (ratio)

El valor principal que la mayoría de las consultas busca.

Esquema JSON →Contrato de datos (YAML) →

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`Year	integer	—	—	no	Ending calendar year of the school year (2024 = the 2023-24 school year). Sourced from LONG_SCHOOL_YEAR for 2011+ (cross-checked against the filename); from the bronze filename for 2004-2010. Descripción completa▾ Ending calendar year of the school year (2024 = the 2023-24 school year). Sourced from LONG_SCHOOL_YEAR for 2011+ (cross-checked against the filename); from the bronze filename for 2004-2010.
`district_code`District Code	string	—	—	yes	GOSA district code (FK to districts dimension): 3-digit zero-padded for standard districts, 7-digit for charter districts. NULL on state-level aggregate rows. Descripción completa▾ GOSA district code (FK to districts dimension): 3-digit zero-padded for standard districts, 7-digit for charter districts. NULL on state-level aggregate rows. Se une a districts; agrega sus columnas de etiqueta.
`school_code`School Code	string	—	—	yes	4-digit zero-padded GOSA school code (composite FK to schools dimension with district_code). NULL on district- and state-level aggregate rows. Descripción completa▾ 4-digit zero-padded GOSA school code (composite FK to schools dimension with district_code). NULL on district- and state-level aggregate rows. Se une a schools; agrega sus columnas de etiqueta.
`demographic`Demographic	string	—	—	no	Which demographic subgroup the share is for; one of 12 race, sex, and special-population codes (no 'all' row). Descripción completa▾ Canonical demographic code (FK to demographics dimension). Exactly 12 values: asian_pacific_islander, black, hispanic, native_american, multiracial, white, migrant, economically_disadvantaged, students_with_disabilities, english_learners, male, female. The bronze 'Asian' bucket is GOSA's pre-1997 OMB combined Asian + Pacific Islander bucket (the source publishes only 6 race buckets and never a separate Pacific Islander column), so it maps to asian_pacific_islander per data-cleaning-standards section 5b. No 'all' row exists — GOSA publishes no category-total share in this report. 12 valores permitidos▾ `asian_pacific_islander` `black` `economically_disadvantaged` `english_learners` `female` `hispanic` `male` `migrant` `multiracial` `native_american` `students_with_disabilities` `white` Se une a demographics; agrega sus columnas de etiqueta.
`met_ayp`Met Ayp	string	—	—	yes	NCLB-era Adequate Yearly Progress flag (yes/no); populated 2004-2010 only, NULL afterward. Descripción completa▾ NCLB-era Adequate Yearly Progress indicator (yes/no), published 2004-2010 only. An entity-level value repeated (denormalized) across the 12 demographic rows of the same (year, district, school) tuple. Bronze sentinels blank/N/A are NULL. 2 valores permitidos▾ `no` `yes`
`improvement_status`Improvement Status	string	—	—	yes	NCLB-era school improvement-status code; populated 2004-2010 only, NULL afterward. Descripción completa▾ NCLB-era school improvement-status code (adeq, adeq_dnm, dist, ni, ni_ayp), published 2004-2010 only and denormalized across the 12 demographic rows per entity-year. Bronze sentinels '.' and blank are NULL. 5 valores permitidos▾ `adeq` `adeq_dnm` `dist` `ni` `ni_ayp`
`enrollment_ratio`Enrollment Ratio	number	ratio	—	yes	This subgroup's share of the entity's total FTE enrollment, on a 0-1 scale (may exceed 1.0 for ED/SWD at some special schools). Descripción completa▾ Share of the entity's total FTE enrollment in this demographic, on the 0-1 decimal scale (bronze 0-100 divided by 100). NULL when the bronze cell was suppressed (TFS — program-wide from 2023) or when the source year does not publish the demographic's column (pre-2011 migrant/male/female; 2012-2017 male/female; 2011 additionally suppresses English-learner shares on ~87% of school rows). Declared unit: ratio rather than proportion per section 4a: GOSA's published shares for economically_disadvantaged and students_with_disabilities legitimately exceed 1.0 at alternative/behavioral/early-childhood/state-special schools in 2004-2010 where the served count exceeds the October FTE snapshot denominator (verified maxima: 1.32 ED at 2008 Mountain Creek Academy, 1.17 SWD at 2004 Butler Early Childhood Center); all other demographics stay within [0, 1.02] (rounding artifacts). Values are preserved per section 4b (extreme-but-conceivable, not impossible). Note the statewide economically_disadvantaged share dips to 0.45 in 2022 between 0.56 (2021) and 0.59 (2023) — bronze-confirmed as published, likely a pandemic-era direct-certification artifact; treat the 2022 ED series with care.

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	`districtsschoolsstates`	enum validado, predeterminado: schools
`district_code`	foreign_key	cualquier valor	valores múltiples
`school_code`	foreign_key	cualquier valor	valores múltiples
`demographic`	foreign_key	12 valores permitidos▾ `asian_pacific_islander` `black` `economically_disadvantaged` `english_learners` `female` `hispanic` `male` `migrant` `multiracial` `native_american` `students_with_disabilities` `white`	valores múltiples, enum validado
`met_ayp`	categorical	`noyes`	valores múltiples, enum validado, elige uno
`improvement_status`	categorical	`adeqadeq_dnmdistnini_ayp`	valores múltiples, enum validado, elige uno
`district_type`	dimension_attribute	7 valores permitidos▾ `commission_charter` `resa` `standard` `state_agency` `state_charter` `state_school` `state_special`	valores múltiples, enum validado
`demographic_category`	dimension_attribute	12 valores permitidos▾ `aggregate` `disability` `economic_status` `esol` `foster_care` `gender` `grade` `homeless_status` `migrant_status` `military` `race` `sped`	valores múltiples, enum validado

Ejemplos de solicitudes

Ejecútalos contra la URL base: devuelven datos en vivo.

All rows (first page), schools level

curl "https://georgiacivicdata.org/api/v1/education/enrollment_demographic_shares"

schools data for 2024

curl "https://georgiacivicdata.org/api/v1/education/enrollment_demographic_shares?year=2024"

Filtered to met_ayp = no for 2024

curl "https://georgiacivicdata.org/api/v1/education/enrollment_demographic_shares?year=2024&met_ayp=no"

One district (code 601), 2024

curl "https://georgiacivicdata.org/api/v1/education/enrollment_demographic_shares?district_code=601&year=2024&detail=districts"

Download 2024 as CSV

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

Notas y limitaciones

Manejo de NULL

Las celdas suprimidas (muy pocos estudiantes para reportar) son NULL, nunca cero.
El cero es un valor real y reportado.

Limitaciones

Suppressed cells are NULL (not zero). State rows have NULL district_code and school_code. District rows have NULL school_code.