{"main_topic":"education","sub_topic":"georgiainsights","topic":"enrollment_october_disability","key":"education/georgiainsights/enrollment_october_disability","version":"1.0.0","year_min":2014,"year_max":2026,"year_gaps":[],"update_frequency":"annual","detail_levels":["districts"],"default_detail":"districts","path_template":"education/enrollment_october_disability/year={year}/{detail}.parquet","grain":["year","district_code","school_code","demographic"],"title":"Special Education Enrollment by Disability","summary":"District-level headcounts of students in special education by the 17 IDEA disability categories, from the October FTE count, 2014-2026.","description":"Georgia Insights (GaDOE) FTE Enrollment by Disability — the October Cycle 1 FTE headcount of Georgia public school students receiving special-education services, broken out by the 17 GaDOE/IDEA disability categories (autism, specific learning disability, speech-language impairment, etc.) at the school-district level, fiscal years 2014-2026. District-only: the source publishes no state aggregate and no school-level rows. Counts below 10 are suppressed to NULL by the source's small-cell rule.","source":"Georgia Insights (GaDOE)","source_url":"https://georgiainsights.gadoe.org/data-downloads/","endpoint":"/api/v1/education/enrollment_october_disability","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Fiscal year of the October FTE count (2026 = October 2025, i.e. the 2025-2026 school year). Sourced from the bronze filename, cross-checked against each file's preamble.","valid_values":null,"example":2026,"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":false,"label":"District Code","short_description":"","description":"3-digit GOSA district code (zero-padded) for standard districts; 7-digit code for state charters and specialty schools, including the 2014-2019 pseudo-districts 7991893/7991894/7991895 for the three state schools (published with blank names by the source; named in the districts dimension). Never NULL — this topic has no state-level rows. FK to districts dimension.","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":"Always NULL — GaDOE publishes this disability breakdown at the district level only. The column is kept so every education fact table shares the same key-column shape.","valid_values":null,"example":null,"unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"demographic","type":"string","role":"fk_demographic","nullable":false,"label":"Demographic","short_description":"One of 17 IDEA disability categories (e.g. autism, specific learning disability); no `all` total row.","description":"Primary exceptionality — the GaDOE/IDEA disability category (FK to the global demographics dimension's 'disability' demographic_category). One of 17 snake_case values mapped 1:1 from the bronze code columns (AUT -> autism, SLD -> specific_learning_disability, ...). Every row's population is students receiving special-education services, split by their single primary disability. This topic publishes only the 17 disability categories at the district level — there is no 'all' total row (the source publishes none).","valid_values":["autism","blind_low_vision","deaf","deaf_blind","emotional_behavioral_disorder","hospital_homebound","mild_intellectual_disability","moderate_intellectual_disability","orthopedic_impairment","other_health_impairment","profound_intellectual_disability","severe_intellectual_disability","significant_developmental_delay","specific_learning_disability","speech_language_impairment","traumatic_brain_injury","visual_impairment"],"example":"specific_learning_disability","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":"Count of special-education students in the disability category; NULL means suppressed (count 1-9), not zero.","description":"FTE headcount of students served in the disability category for the (year, district) cell. Raw count, not scaled. NULL means the source suppressed the cell ('*': true count 1-9); every published value is >= 10 (verified in every column of every year).","valid_values":null,"example":247,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Suppressed by the source's small-cell rule: the true count is non-zero but below 10.","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"num_students","usage":"Star-schema fact table. Join the districts dimension on district_code; the schools dimension on district_code + school_code; the demographics dimension on demographic. Read directly with DuckDB over Parquet.","limitations":"Suppressed cells are NULL (not zero). District rows have NULL school_code.","null_semantics":{"suppressed_to_null":true,"zero_is_real":true},"available_years":[2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026],"schema_hash":"f18a070951364f075ff0a83cea6d7e796bd28e87c0de70a697671fa9ae891a49","tags":["education","georgia insights","enrollment_october_disability"],"granularity_description":"One row per year, district_code, school_code, demographic.","example_queries":[{"description":"Latest year (2026), districts detail","query":"SELECT * FROM enrollment_october_disability WHERE year = 2026 LIMIT 100"},{"description":"District 601 in 2026","query":"SELECT * FROM enrollment_october_disability WHERE district_code = '601' AND year = 2026 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"},{"column":"demographic","target_object":"demographics","target_columns":["demographic"],"attribute_columns_added":["demographic_label","demographic_category"],"scope":"global"}],"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"],"default":"districts"},{"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":"demographic","kind":"foreign_key","column":"demographic","type":"string","multi_value":true,"enum_enforced":true,"values":["autism","blind_low_vision","deaf","deaf_blind","emotional_behavioral_disorder","hospital_homebound","mild_intellectual_disability","moderate_intellectual_disability","orthopedic_impairment","other_health_impairment","profound_intellectual_disability","severe_intellectual_disability","significant_developmental_delay","specific_learning_disability","speech_language_impairment","traumatic_brain_injury","visual_impairment"]},{"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"]},{"param":"demographic_category","kind":"dimension_attribute","dimension":"demographics","column":"demographic_category","type":"string","multi_value":true,"enum_enforced":true,"values":["aggregate","disability","economic_status","esol","foster_care","gender","grade","homeless_status","migrant_status","military","race","sped"]}],"filter_hints":[]}