{"main_topic":"education","sub_topic":"gosa","topic":"english_learner_exit_rate","key":"education/gosa/english_learner_exit_rate","version":"1.0.0","year_min":2019,"year_max":2024,"year_gaps":[],"update_frequency":"annual","detail_levels":["districts","states"],"default_detail":"districts","path_template":"education/english_learner_exit_rate/year={year}/{detail}.parquet","grain":["year","district_code","school_code"],"title":"English Learner Program Exit Rate","summary":"Rate at which Georgia English Learner students exit EL services by district and statewide, fiscal years 2019-2024.","description":"Governor's Office of Student Achievement (GOSA) annual English Learner (EL) program exit activity. For every Georgia LEA — standard county/city districts, state and commission charter schools, State Schools, and state-agency systems — plus a single statewide aggregate row, reports the number of EL students who exited EL services, the total EL enrollment used as the denominator, and the resulting exit rate per fiscal year. Coverage is fiscal years 2019-2024 (FY2024 = the 2023-24 school year) at the district and state detail levels; no school-level detail is published. District cells below the privacy threshold are suppressed in bronze as TFS and are NULL in gold; state totals are never suppressed. This topic is the merged successor to three legacy GOSA source topics (english_learners_el_exit_rate_district_level, _state_level, and _3yr_for_report_card) that published the same metric set; the report-card edition duplicated the district/state values exactly and was dropped during the merge.","source":"GOSA","source_url":"https://gosa.georgia.gov/dashboards-data-report-card/downloadable-data","endpoint":"/api/v1/education/english_learner_exit_rate","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Georgia fiscal year, equal to the ending (spring) calendar year of the school year (FY2024 = 2023-24). Read from the bronze FISCAL_YEAR column and cross-checked against the filename year.","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/system code (FK to districts dimension), zero-padded to 3 digits; 7-digit charter and state-school codes are preserved unchanged. NULL on the statewide aggregate rows. Beyond the standard county/city districts the series includes 782xxxx/783xxxx charter LEAs, the combined State Schools row (799, FY2021+; individual State Schools rows 7991893-7991895 in FY2019 only — none in FY2020), and the Dept. of Corrections (890).","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":"GOSA school code (composite FK to schools dimension with district_code). Always NULL in this topic (enforced by a quality check) — no school-level detail is published for this metric.","valid_values":null,"example":null,"unit":null,"value_min":null,"value_max":null,"null_meaning":"Always NULL — EL exit activity is published at the district and state levels only; the column exists so every education fact table shares the same key shape.","key_metric_grain_contributor":false,"metric_component":null},{"name":"num_el_exits","type":"integer","role":"metric","nullable":true,"label":"Number EL Exits","short_description":"","description":"Number of English Learner students who exited the EL program during the fiscal year. NULL when the bronze source suppressed the cell as TFS (too few students); published values are always 10 or more. State rows are never suppressed.","valid_values":null,"example":46,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":"numerator"},{"name":"num_el_students","type":"integer","role":"metric","nullable":true,"label":"Number EL Students","short_description":"","description":"Total English Learner enrollment for the fiscal year — the denominator of el_exit_rate. NULL when suppressed as TFS; suppressed only when num_el_exits is also suppressed (enforced by a quality check). State rows are never suppressed.","valid_values":null,"example":715,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":"denominator"},{"name":"el_exit_rate","type":"number","role":"metric","nullable":true,"label":"EL Exit Rate","short_description":"Share of English Learner students who exited EL services during the year, on a 0-1 scale.","description":"EL program exit rate on the 0-1 scale (0.064 = 6.4%; bronze publishes 0-100 and is divided by 100 per data-cleaning-standards §4). NULL whenever either num_el_exits or num_el_students is suppressed: in FY2019-2023 the bronze co-suppresses all three cells, and in FY2024 GOSA published numeric rates even for the 130 district rows with suppressed counts — those rates are unverifiable and are NULLed by the transform (recorded in the manifest). Where published, the rate reconciles with num_el_exits / num_el_students within 0.0006 (enforced by a quality check).","valid_values":null,"example":0.064,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"el_exit_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":"District and state detail only: school_code is always NULL — no school-level data is published for this metric. Suppressed cells are NULL (not zero): district rows below the privacy threshold are suppressed in bronze as TFS; published counts are always >= 10. A row may carry num_el_students while num_el_exits and el_exit_rate are NULL (the exit cohort is below the threshold even though total EL enrollment is not). State totals are never suppressed. el_exit_rate is NULL whenever either count is suppressed — including 130 FY2024 district rows where GOSA published unverifiable numeric rates alongside suppressed counts (treated as suppressed). The State Schools representation changes across years: individual 7-digit rows (7991893-7991895) in FY2019 only, no State Schools rows at all in FY2020, one combined 799 row from FY2021 — a long-run State Schools series requires handling both representations and the FY2020 gap.","null_semantics":{"suppressed_to_null":true,"zero_is_real":true},"available_years":[2019,2020,2021,2022,2023,2024],"schema_hash":"09953e17f7ba66a2dc6e9ad65f7f151fbc12a1dadc687360baf4367d394d135c","tags":["education","gosa","english_learner_exit_rate"],"granularity_description":"One row per year, district_code, school_code (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2024), districts detail","query":"SELECT * FROM english_learner_exit_rate WHERE year = 2024 LIMIT 100"},{"description":"District 601 in 2024","query":"SELECT * FROM english_learner_exit_rate WHERE district_code = '601' 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","states"],"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":"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":[]}