Student Attendance and Chronic Absenteeism

Student attendance tiers and chronic-absence rates by Georgia school, district, and demographic subgroup, 2004-2024.

Fuente: GOSA
Cobertura de años: 2004–2024
Actualización: annual
Versión: 1.0.0
Hash del esquema: 9033e13d86bf

Niveles de detalle disponibles

EstadoDistritoEscuela · predeterminado

Resumen

Distribution of Georgia public-school students across three absentee tiers (5 or fewer, 6-15, and more than 15 days absent during the school year), plus a chronic-absence rate (10% or more of enrolled days; published from 2018) and the student count in the denominator, for every school 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 2003-04 through 2023-24.

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

Métrica clave

chronically_absent_rate — Chronically Absent 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). 2011-2024 files carry a LONG_SCHOOL_YEAR cross-checked against the filename; 2004-2010 files carry no year column, so the filename year (verified as the ending year via year-over-year enrollment continuity) is authoritative. Descripción completa▾ Ending (spring) calendar year of the school year (e.g. 2024 for 2023-24). 2011-2024 files carry a LONG_SCHOOL_YEAR cross-checked against the filename; 2004-2010 files carry no year column, so the filename year (verified as the ending year via year-over-year enrollment continuity) is authoritative.
`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 (present from 2010). 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 (present from 2010). 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). 2004-2010 sources publish unpadded codes ('103'), zero-padded here to align with 2011-2024. 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). 2004-2010 sources publish unpadded codes ('103'), zero-padded here to align with 2011-2024. 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); 15 subgroups in every year. Race buckets use the combined asian_pacific_islander key (pre-1997 OMB convention): the source publishes six race buckets with a bare 'Asian' label and never a separate Pacific Islander row, and the six buckets' state-level student counts sum exactly to the 'all' total in every year except 2013 (where they fall short by exactly 8 of 1.84M students — an unallocated-records artifact, not a dropped-Pacific-Islander population). 'all' is the unfiltered total and overlaps every other value; subgroups are mutually exclusive only within their own category (race, gender, economic, English proficiency, disability, migrant). 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_students`Number Students	integer	count	—	yes	Number of students in the subgroup used as the denominator for the rate metrics. A real 0 means the subgroup has no students at that entity. §4b mask: in 2023 (5 rows) and 2024 (6 rows) the source published STUDENT_COUNT_FEMALE = 0 alongside non-zero published rates at tiny special-population schools (e.g. East DeKalb Special Education Center 2023: all=80, male=71, female reads 0) — a zero population cannot carry non-zero rates, so those counts are NULLed and the rates kept. Descripción completa▾ Number of students in the subgroup used as the denominator for the rate metrics. A real 0 means the subgroup has no students at that entity. §4b mask: in 2023 (5 rows) and 2024 (6 rows) the source published STUDENT_COUNT_FEMALE = 0 alongside non-zero published rates at tiny special-population schools (e.g. East DeKalb Special Education Center 2023: all=80, male=71, female reads 0) — a zero population cannot carry non-zero rates, so those counts are NULLed and the rates kept.
`five_or_fewer_days_absent_rate`Five or Fewer Days Absent Rate	number	proportion	—	yes	Proportion of the subgroup absent five or fewer days during the school year (0-1 scale; source publishes 0-100, divided by 100). Together with the 6-15 and over-15 tiers it partitions the subgroup population (sums to ~1.0). §4b mask: in 2005-2020 the source publishes 0 for all rate metrics when the subgroup has zero students; those placeholder zeros are NULLed (rates of an empty population are undefined; 2004 already publishes NULL there). Descripción completa▾ Proportion of the subgroup absent five or fewer days during the school year (0-1 scale; source publishes 0-100, divided by 100). Together with the 6-15 and over-15 tiers it partitions the subgroup population (sums to ~1.0). §4b mask: in 2005-2020 the source publishes 0 for all rate metrics when the subgroup has zero students; those placeholder zeros are NULLed (rates of an empty population are undefined; 2004 already publishes NULL there).
`six_to_fifteen_days_absent_rate`Six to Fifteen Days Absent Rate	number	proportion	—	yes	Proportion of the subgroup absent six to fifteen days during the school year (0-1 scale; source publishes 0-100, divided by 100). Middle tier of the three-tier partition. Zero-population placeholder zeros NULLed in 2005-2020 (see five_or_fewer_days_absent_rate). Descripción completa▾ Proportion of the subgroup absent six to fifteen days during the school year (0-1 scale; source publishes 0-100, divided by 100). Middle tier of the three-tier partition. Zero-population placeholder zeros NULLed in 2005-2020 (see five_or_fewer_days_absent_rate).
`over_15_days_absent_rate`Over 15 Days Absent Rate	number	proportion	—	yes	Proportion of the subgroup absent more than fifteen days during the school year (0-1 scale; source publishes 0-100, divided by 100). Top tier of the three-tier partition; often used as a chronic-absenteeism proxy but distinct from chronically_absent_rate (different cutoff definitions). Zero-population placeholder zeros NULLed in 2005-2020 (see five_or_fewer_days_absent_rate). Descripción completa▾ Proportion of the subgroup absent more than fifteen days during the school year (0-1 scale; source publishes 0-100, divided by 100). Top tier of the three-tier partition; often used as a chronic-absenteeism proxy but distinct from chronically_absent_rate (different cutoff definitions). Zero-population placeholder zeros NULLed in 2005-2020 (see five_or_fewer_days_absent_rate).
`chronically_absent_rate`Chronically Absent Rate	number	proportion	—	yes	Share of the subgroup chronically absent (missing 10% or more of enrolled days), on a 0-1 scale; published from 2018. Descripción completa▾ Proportion of the subgroup chronically absent — absent 10% or more of enrolled days, the federal definition (0-1 scale; source publishes 0-100, divided by 100). Published 2018-2024 only: the column does not exist in the 2004-2010 and 2012-2017 sources, and the 2011 column's only non-null values are zero-population placeholder zeros (masked to NULL), so 2004-2017 is entirely NULL. NOT equal to over_15_days_absent_rate — the cutoffs differ (10% of enrolled days vs a fixed 15-day count).

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/attendance"

schools data for 2024

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

One district (code 601), 2024

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

Download 2024 as CSV

curl "https://georgiacivicdata.org/api/v1/education/attendance?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): 2004 publishes blank cells for many subgroups (including some state-level rows); 2021-2022 use the TFS (too few students) literal; 2023-2024 mix TFS and blank cells per cell, so the tier metrics are not co-suppressed and small-population subgroups (notably native_american) are mostly NULL in 2021-2024. chronically_absent_rate is NULL for every year before 2018. Rate metrics are NULL (masked) where a subgroup has zero students. 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.