Skip to content
← All datasets

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.

Year coverage
20112024
Updated
annual
Version
1.0.0
Schema hash
0c3a1c756de1

Detail levels available

StateDistrictSchool · default

Overview

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).

Row grain: One row per year, district_code, school_code, program.

Key metric

participation_rateParticipation Rate (proportion)

The single headline value most answers want.

Variables

Every column in the fact table. The code is the exact field name the API returns.

ColumnTypeUnitRangeNull?Description
yearYearintegernoEnding 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.
Full description
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_codeDistrict CodestringyesGOSA district code (FK to districts dimension): 3-digit zero-padded for standard districts, 7-digit for charter districts. NULL on state-level aggregate rows.
Full description
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.

Joins districts; adds its label columns.

school_codeSchool Codestringyes4-digit zero-padded GOSA school code (composite FK to schools dimension with district_code). NULL on district- and state-level aggregate rows.
Full description
4-digit zero-padded GOSA school code (composite FK to schools dimension with district_code). NULL on district- and state-level aggregate rows.

Joins schools; adds its label columns.

programProgramstringnoWhich instructional program the row is for; one of nine codes (gifted, special ed, ESOL, EIP, remedial, etc.).
Full description
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 allowed values
  • 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_studentsNumber StudentsintegercountyesNumber 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.
Full description
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_rateParticipation RatenumberproportionyesShare of the entity's enrollment in this program, on a 0-1 scale; denominator is the grades the program serves.
Full description
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).

Filters

Query parameters the fact endpoint accepts. Comma-separated values are OR within a parameter; multiple parameters AND together.

ParameterKindAllowed valuesNotes
yearyear_exactany value
year_minyear_rangeany value
year_maxyear_rangeany value
detaildetaildistrictsschoolsstatesenum-enforced, default: schools
district_codeforeign_keyany valuemulti-value
school_codeforeign_keyany valuemulti-value
programcategorical
9 allowed values
  • 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
multi-value, enum-enforced, pick one
district_typedimension_attribute
7 allowed values
  • commission_charter
  • resa
  • standard
  • state_agency
  • state_charter
  • state_school
  • state_special
multi-value, enum-enforced

Example requests

Run these against the base URL — they return live data.

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"

Notes & limitations

NULL handling

  • Suppressed cells (too few students to report) are NULL, never zero.
  • Zero is a real, reported value.

Limitations

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