Saltar al contenido
← Todos los conjuntos de datos

March Enrollment by Race and Gender

Public school student headcounts by race/ethnicity and gender from the March FTE count, per school, district, and state, 2010-2025.

Cobertura de años
20102025
Actualización
annual
Versión
1.0.0
Hash del esquema
ed137f9d5a16

Niveles de detalle disponibles

EstadoDistritoEscuela · predeterminado

Resumen

Georgia Insights (GaDOE) FTE Enrollment by Race/Ethnicity and Gender — the March Cycle 3 FTE headcount of Georgia public school students, cross-classified by gender and by seven mutually exclusive race/ethnicity buckets (Hispanic, American Indian, Asian, Black, Pacific Islander, White, Two or more Races), for every school, district, and the state, fiscal years 2010-2025. This is the spring snapshot; the companion topic enrollment_october_gender_race_ethnicity reports the October Cycle 1 count. Source gender `Total` rows are dropped (redundant with Female + Male).

Granularidad de fila: Una fila por year, district_code, school_code, race, gender.

Métrica clave

num_studentsNumber Students (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
yearYearintegernoFiscal year of the March FTE count (2025 = March 2025, i.e. the 2024-2025 school year). Sourced from the bronze filename, cross-checked against each file's preamble.
Descripción completa
Fiscal year of the March FTE count (2025 = March 2025, i.e. the 2024-2025 school year). Sourced from the bronze filename, cross-checked against each file's preamble.
district_codeDistrict Codestringyes3-digit GOSA district code (zero-padded) for standard districts; 7-digit code for state charters. NULL for state-level rows. FK to districts dimension.
Descripción completa
3-digit GOSA district code (zero-padded) for standard districts; 7-digit code for state charters. NULL for state-level rows. FK to districts dimension.

Se une a districts; agrega sus columnas de etiqueta.

school_codeSchool Codestringyes4-digit GOSA school code, extracted from the bronze `School ID` (`NNNN-Name`) prefix. NULL for state- and district-level rows. FK to schools dimension (composite key with district_code).
Descripción completa
4-digit GOSA school code, extracted from the bronze `School ID` (`NNNN-Name`) prefix. NULL for state- and district-level rows. FK to schools dimension (composite key with district_code).

Se une a schools; agrega sus columnas de etiqueta.

raceRacestringnoOne of seven mutually exclusive race/ethnicity buckets; Hispanic is a separate bucket, not a race overlay.
Descripción completa
Race/ethnicity bucket (canonical race demographic keys, published as `race` because this topic is a race x gender cross-classification). Split Asian/Pacific Islander convention: `asian` and `pacific_islander` are separate buckets, never the combined rollup. `hispanic` is a non-overlapping ethnicity bucket — GaDOE FTE coding gives Hispanic ethnicity precedence over race, so a Hispanic student is counted ONLY under `hispanic` and the seven values partition total enrollment; do not treat `hispanic` as a Hispanic-of-any-race overlay.
7 valores permitidos
  • asian
  • black
  • hispanic
  • multiracial
  • native_american
  • pacific_islander
  • white
genderGenderstringnoStudent gender, female or male; the source's redundant Total rows are dropped.
Descripción completa
Student gender (`female` / `male`). The source's third value, `Total`, equals Female + Male on every fully published cell and is dropped during transform.
2 valores permitidos
  • female
  • male
num_studentsNumber StudentsintegercountyesFTE student headcount for the race x gender cell; NULL means suppressed (small cell), not zero.
Descripción completa
FTE student headcount for the (year, geography, race, gender) cell. Raw count, not scaled. NULL when suppressed in source; every non-null value is >= 15 (the observed suppression floor across all 32 bronze files). State-level cells are never suppressed.

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
detaildetaildistrictsschoolsstatesenum validado, predeterminado: schools
district_codeforeign_keycualquier valorvalores múltiples
school_codeforeign_keycualquier valorvalores múltiples
racecategorical
7 valores permitidos
  • asian
  • black
  • hispanic
  • multiracial
  • native_american
  • pacific_islander
  • white
valores múltiples, enum validado, elige uno
gendercategoricalfemalemalevalores múltiples, enum validado, elige uno
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), schools level

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

schools data for 2025

curl "https://georgiacivicdata.org/api/v1/education/enrollment_march_gender_race_ethnicity?year=2025"

Filtered to race = asian for 2025

curl "https://georgiacivicdata.org/api/v1/education/enrollment_march_gender_race_ethnicity?year=2025&race=asian"

One district (code 601), 2025

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

Download 2025 as CSV

curl "https://georgiacivicdata.org/api/v1/education/enrollment_march_gender_race_ethnicity?year=2025&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.