Enrollment Program Participation

Share of students enrolled in nine state instructional programs (gifted, special ed, ESOL, etc.) by Georgia school, district, and statewide, 2011-2024.

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

Niveles de detalle disponibles

EstadoDistritoEscuela · predeterminado

Resumen

Georgia Office of Student Achievement (GOSA) enrollment program participation. For every Georgia public school, school district, and the state as a whole, the count and share of students enrolled in each of nine state instructional programs: Remedial grades 6-8, Early Intervention Program (EIP) K-5, Remedial grades 9-12, Special Education K-12, ESOL, Special Education Pre-K, Vocational grades 9-12, Alternative Programs, and Gifted. This topic is COMPUTED from the shared GOSA 'Enrollment by Subgroup Programs' bronze (FTE enrollment disaggregated by subgroup); the companion enrollment_demographic_shares topic exposes the demographic-share side of the same files. participation_rate is the share GOSA publishes for each program: students in the program over the entity's total FTE enrollment in the grades the program serves (the denominator GOSA standardized on at the May 2013 CCRPI launch). Coverage spans school years 2010-11 through 2023-24 — the 2004-2010 bronze files predate the program-column schema expansion and publish no program data, so those years are excluded (the companion topic covers their demographic-share columns).

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

Métrica clave

participation_rate — Participation 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 calendar year of the school year (2024 = the 2023-24 school year). Sourced from LONG_SCHOOL_YEAR (cross-checked against the bronze filename). Coverage starts at 2011: the 2004-2010 bronze publishes no program columns and is excluded from this topic. Descripción completa▾ Ending calendar year of the school year (2024 = the 2023-24 school year). Sourced from LONG_SCHOOL_YEAR (cross-checked against the bronze filename). Coverage starts at 2011: the 2004-2010 bronze publishes no program columns and is excluded from this topic.
`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.
`program`Program	string	—	—	no	Which instructional program the row is for; one of nine codes (gifted, special ed, ESOL, EIP, remedial, etc.). Descripción completa▾ Canonical instructional-program code. Exactly nine values: remedial_gr_6_8, eip_k_5, remedial_gr_9_12, special_ed_k_12, esol, special_ed_pk, vocation_9_12, alt_programs, gifted. Derived from the bronze ENROLL_COUNT_<PROGRAM> column name (lowercased, with SPECIAL_ED_K12 regularized to special_ed_k_12). Every entity-year carries all nine program rows; programs the entity does not offer carry NULL metrics. 9 valores permitidos▾ `alt_programs` `eip_k_5` `esol` `gifted` `remedial_gr_6_8` `remedial_gr_9_12` `special_ed_k_12` `special_ed_pk` `vocation_9_12`
`num_students`Number Students	integer	count	—	yes	Number of students enrolled in the program at the entity. NULL when the program does not apply to the entity (e.g., grade 6-8 remediation at a high school) or when the bronze cell was TFS-suppressed (count columns from 2021). For alt_programs in 2011 and 2019 the count is additionally NULLed wherever the companion rate is < 0.95 or NULL — a GOSA publishing error in exactly those two years set the count to the entity's TOTAL enrollment (state row 1.53M/1.60M vs 10k-33k in every other year), not the alt-program subset; genuine all-alternative entities (rate >= 0.95, where count = enrollment is correct) keep their count, and the rate is always preserved. Descripción completa▾ Number of students enrolled in the program at the entity. NULL when the program does not apply to the entity (e.g., grade 6-8 remediation at a high school) or when the bronze cell was TFS-suppressed (count columns from 2021). For alt_programs in 2011 and 2019 the count is additionally NULLed wherever the companion rate is < 0.95 or NULL — a GOSA publishing error in exactly those two years set the count to the entity's TOTAL enrollment (state row 1.53M/1.60M vs 10k-33k in every other year), not the alt-program subset; genuine all-alternative entities (rate >= 0.95, where count = enrollment is correct) keep their count, and the rate is always preserved.
`participation_rate`Participation Rate	number	proportion	—	yes	Share of the entity's enrollment in this program, on a 0-1 scale; denominator is the grades the program serves. Descripción completa▾ Share of the entity's FTE enrollment (in the grades the program serves) enrolled in the program, on the 0-1 decimal scale (bronze 0-100 divided by 100) and bounded on [0, 1] — the published maximum is exactly 1.0. NULL when the program does not apply or the bronze cell was TFS-suppressed (percentage columns from 2023). special_ed_pk rates are NULL for 2011-2012: pre-2013 GOSA published the rate on a different, undocumented denominator (maxima of 644-759%, impossible as a share) that cannot be re-normalized; the values are masked per the known-source-defect policy rather than published, so the column stays genuinely bounded. The companion num_students for special_ed_pk is preserved in those years. Any 2013+ special_ed_pk rate > 1.0 would be defensively NULLed too (none exist today).

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
`program`	categorical	9 valores permitidos▾ `alt_programs` `eip_k_5` `esol` `gifted` `remedial_gr_6_8` `remedial_gr_9_12` `special_ed_k_12` `special_ed_pk` `vocation_9_12`	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

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_program_participation"

schools data for 2024

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

Filtered to program = alt_programs for 2024

curl "https://georgiacivicdata.org/api/v1/education/enrollment_program_participation?year=2024&program=alt_programs"

One district (code 601), 2024

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

Download 2024 as CSV

curl "https://georgiacivicdata.org/api/v1/education/enrollment_program_participation?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.