Grade 7-12 Dropout Rates

Number and rate of grade 7-12 students who dropped out, by Georgia school, district, and demographic subgroup, 2011-2024.

Fuente: GOSA
Cobertura de años: 2011–2024
Actualización: annual
Versión: 1.0.0
Hash del esquema: c579db0c0fb8

Niveles de detalle disponibles

EstadoDistritoEscuela · predeterminado

Resumen

Number and rate of grade 7-12 dropouts for Georgia public schools, with official district and state rollups, by demographic subgroup (race/ethnicity, gender, economic status, English proficiency, migrant status, disability status). Published by GOSA for school years 2010-11 through 2023-24.

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

Métrica clave

dropout_rate — Dropout Rate (proportion)

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 (spring) calendar year of the school year (e.g. 2024 for 2023-24), parsed from the source's LONG_SCHOOL_YEAR and cross-checked against the filename. Descripción completa▾ Ending (spring) calendar year of the school year (e.g. 2024 for 2023-24), parsed from the source's LONG_SCHOOL_YEAR and cross-checked against the filename.
`district_code`District Code	string	—	—	yes	GOSA district code (FK to districts dimension): 3-digit zero-padded county/city codes or 7-digit state-charter codes. NULL on state-level rows. Descripción completa▾ GOSA district code (FK to districts dimension): 3-digit zero-padded county/city codes or 7-digit state-charter codes. NULL on state-level rows. Se une a districts; agrega sus columnas de etiqueta.
`school_code`School Code	string	—	—	yes	GOSA school code, zero-padded to 4 characters (composite FK to schools dimension with district_code; not globally unique on its own). NULL on district- and state-level rows. Descripción completa▾ GOSA school code, zero-padded to 4 characters (composite FK to schools dimension with district_code; not globally unique on its own). NULL on district- and state-level rows. Se une a schools; agrega sus columnas de etiqueta.
`demographic`Demographic	string	—	—	no	Student subgroup the row describes (race, gender, economic status, English learner, migrant, or disability); 'all' is every student. Descripción completa▾ Demographic subgroup (FK to the global demographics dimension). Race buckets use the combined asian_pacific_islander key (pre-1997 OMB convention): the source publishes a single 'Asian/Pacific Islander' label and its six race buckets sum exactly to the 'all' total at the state level in every year, so Pacific Islanders are folded in, never published separately. english_learners rows are absent in 2020-2022 (the source dropped the Limited English Proficient subgroup in those files). 'all' is the unfiltered total and overlaps every other value; subgroups are mutually exclusive only within their own category (race, gender, economic, special population). 15 valores permitidos▾ `all` `asian_pacific_islander` `black` `economically_disadvantaged` `english_learners` `female` `hispanic` `male` `migrant` `multiracial` `native_american` `not_economically_disadvantaged` `students_with_disabilities` `students_without_disabilities` `white` Se une a demographics; agrega sus columnas de etiqueta.
`num_dropouts`Number Dropouts	integer	count	—	yes	Number of students in grades 7-12 who dropped out during the school year. Published values are always >= 10 because GOSA suppresses smaller cells; ~78-83% of school-level rows are suppressed (NULL) in every year. Always co-suppressed with dropout_rate. Descripción completa▾ Number of students in grades 7-12 who dropped out during the school year. Published values are always >= 10 because GOSA suppresses smaller cells; ~78-83% of school-level rows are suppressed (NULL) in every year. Always co-suppressed with dropout_rate.
`dropout_rate`Dropout Rate	number	proportion	—	yes	Share of the subgroup's grade 7-12 students who dropped out during the school year, on a 0-1 scale; lower is better. Descripción completa▾ Grade 7-12 dropout rate as a proportion (0-1 scale): dropouts divided by the subgroup's grade 7-12 enrollment. The source publishes 0-100 percentages with one decimal place (observed 0.2-93.6 across all years); divided by 100. Always co-suppressed with num_dropouts.

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	15 valores permitidos▾ `all` `asian_pacific_islander` `black` `economically_disadvantaged` `english_learners` `female` `hispanic` `male` `migrant` `multiracial` `native_american` `not_economically_disadvantaged` `students_with_disabilities` `students_without_disabilities` `white`	valores múltiples, enum validado
`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/dropout_rate_7_12"

schools data for 2024

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

One district (code 601), 2024

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

Download 2024 as CSV

curl "https://georgiacivicdata.org/api/v1/education/dropout_rate_7_12?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): GOSA suppresses any cell below the n=10 reporting threshold, which blanks ~78-83% of school-level rows in every year — school-level analyses should expect sparse coverage, and summing only published subgroup counts undercounts true totals at school grain (use district or state rows for official aggregates). State rows have NULL district_code and school_code; district rows have NULL school_code. The race axis uses the combined asian_pacific_islander bucket — not comparable row-for-row with split-convention topics without aggregating those topics' asian + pacific_islander rows at query time. english_learners rows are absent in 2020-2022.