{"main_topic":"education","sub_topic":"gosa","topic":"enrollment_program_participation","key":"education/gosa/enrollment_program_participation","version":"1.0.0","year_min":2011,"year_max":2024,"year_gaps":[],"update_frequency":"annual","detail_levels":["districts","schools","states"],"default_detail":"schools","path_template":"education/enrollment_program_participation/year={year}/{detail}.parquet","grain":["year","district_code","school_code","program"],"title":"Enrollment Program Participation","summary":"Share of students enrolled in nine state instructional programs (gifted, special ed, ESOL, etc.) by Georgia school, district, and statewide, 2011-2024.","description":"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).","source":"Governor's Office of Student Achievement (GOSA)","source_url":"https://gosa.georgia.gov/dashboards-data-report-card/downloadable-data","endpoint":"/api/v1/education/enrollment_program_participation","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","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.","valid_values":null,"example":2024,"unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"district_code","type":"string","role":"fk_district","nullable":true,"label":"District Code","short_description":"","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.","valid_values":null,"example":"601","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"school_code","type":"string","role":"fk_school","nullable":true,"label":"School Code","short_description":"","description":"4-digit zero-padded GOSA school code (composite FK to schools dimension with district_code). NULL on district- and state-level aggregate rows.","valid_values":null,"example":"0103","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"program","type":"string","role":"categorical","nullable":false,"label":"Program","short_description":"Which instructional program the row is for; one of nine codes (gifted, special ed, ESOL, EIP, remedial, etc.).","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.","valid_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"],"example":"gifted","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"num_students","type":"integer","role":"metric","nullable":true,"label":"Number Students","short_description":"","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.","valid_values":null,"example":42,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Several causes share the same NULL: (a) the program does not apply to the entity — preserved as NULL, never coerced to 0; (b) TFS small-cell suppression in the program count columns (2021 onward); (c) for alt_programs in 2011/2019, the publisher-error mask (bronze count equalled total enrollment). NULL is NOT a real zero.","key_metric_grain_contributor":false,"metric_component":"numerator"},{"name":"participation_rate","type":"number","role":"metric","nullable":true,"label":"Participation Rate","short_description":"Share of the entity's enrollment in this program, on a 0-1 scale; denominator is the grades the program serves.","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).","valid_values":null,"example":0.12,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Multiple causes share the same NULL: the program does not apply to the entity; TFS small-cell suppression (percentage columns 2023 onward); or the pre-2013 special_ed_pk denominator-drift mask (2011-2012). NULL is NOT a real zero participation rate.","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"participation_rate","usage":"Star-schema fact table. Join the districts dimension on district_code; the schools dimension on district_code + school_code. Read directly with DuckDB over Parquet.","limitations":"Suppressed cells are NULL (not zero). State rows have NULL district_code and school_code. District rows have NULL school_code.","null_semantics":{"suppressed_to_null":true,"zero_is_real":true},"available_years":[2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024],"schema_hash":"0c3a1c756de1011f75889dced2a657ce3a06e5f308d031414aa3674f1d31b4da","tags":["education","governor's office of student achievement","enrollment_program_participation"],"granularity_description":"One row per year, district_code, school_code, program (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2024), schools detail","query":"SELECT * FROM enrollment_program_participation WHERE year = 2024 LIMIT 100"},{"description":"District 601 in 2024","query":"SELECT * FROM enrollment_program_participation WHERE district_code = '601' AND year = 2024 LIMIT 100"},{"description":"Filter by program = gifted","query":"SELECT * FROM enrollment_program_participation WHERE program = 'gifted' AND year = 2024 LIMIT 100"}],"foreign_keys":[{"column":"district_code","target_object":"districts","target_columns":["district_code"],"attribute_columns_added":["district_name","district_census_id","district_type"],"scope":"domain"},{"column":"school_code","target_object":"schools","target_columns":["district_code","school_code"],"attribute_columns_added":["school_name"],"scope":"domain"}],"filters":[{"param":"year","kind":"year_exact","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"year_min","kind":"year_range","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"year_max","kind":"year_range","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"detail","kind":"detail","type":"string","multi_value":false,"enum_enforced":true,"values":["districts","schools","states"],"default":"schools"},{"param":"district_code","kind":"foreign_key","column":"district_code","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"school_code","kind":"foreign_key","column":"school_code","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"program","kind":"categorical","column":"program","type":"string","multi_value":true,"enum_enforced":true,"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"],"has_total":false,"total_value":null,"requires_single_value":true},{"param":"district_type","kind":"dimension_attribute","dimension":"districts","column":"district_type","type":"string","multi_value":true,"enum_enforced":true,"values":["commission_charter","resa","standard","state_agency","state_charter","state_school","state_special"]}],"filter_hints":[]}