{"main_topic":"education","sub_topic":"gosa","topic":"georgia_milestones_end_of_grade_lexile","key":"education/gosa/georgia_milestones_end_of_grade_lexile","version":"1.0.0","year_min":2015,"year_max":2024,"year_gaps":[2020],"update_frequency":"annual","detail_levels":["districts","schools","states"],"default_detail":"schools","path_template":"education/georgia_milestones_end_of_grade_lexile/year={year}/{detail}.parquet","grain":["year","district_code","school_code","grade_level","subject"],"title":"Georgia Milestones End-of-Grade Lexile Reading Scores","summary":"Lexile reading-measure distributions by grade at school, district, and state level, 2015-2024.","description":"Lexile reading-score outcomes for Georgia public-school students taking the Georgia Milestones End-of-Grade (EOG) English Language Arts assessment in grades 3-8. Each row is one (entity x grade) cell reporting students tested, students who received a Lexile measure, students whose Lexile met or exceeded the grade-band stretch midpoint (a national reading-level benchmark), students without a Lexile score, and the average Lexile measure. State, district, and school detail levels; no demographic breakdown (every row is implicitly All Students). School years 2014-15 through 2023-24; 2019-20 is absent (EOG testing suspended, COVID-19).","source":"Governor's Office of Student Achievement (GOSA)","source_url":"https://gosa.georgia.gov/dashboards-data-report-card/downloadable-data","endpoint":"/api/v1/education/georgia_milestones_end_of_grade_lexile","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Ending calendar year of the school year (e.g., 2024 = 2023-24), from the filename and cross-checked against the file's SCHOOL_YEAR column. 2020 has no rows (EOG testing suspended during COVID-19 closures).","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 standard codes or 7-digit state-charter codes. NULL on state-level 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":"GOSA school code, zero-padded to 4 characters (composite FK to schools dimension with district_code; not globally unique on its own). NULL on district- and state-level rows.","valid_values":null,"example":"0200","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"grade_level","type":"string","role":"categorical","nullable":false,"label":"Grade Level","short_description":"Grade the EOG ELA assessment was given to, as a 2-char code (03-08; EOG covers grades 3-8).","description":"Grade the EOG ELA assessment was administered to, as a canonical 2-char zero-padded string (03-08; EOG covers grades 3-8 only). Bronze ACDMC_LVL_CD is already zero-padded in every year.","valid_values":["03","04","05","06","07","08"],"example":"04","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"subject","type":"string","role":"categorical","nullable":false,"label":"Subject","short_description":"Academic subject; always english_language_arts (Lexile measures exist only for the EOG ELA test).","description":"Academic subject. Fixed constant english_language_arts: every Lexile measure derives from the EOG English Language Arts assessment (bronze has no subject column). Included for canonical-vocabulary parity with sibling Milestones assessment topics so API consumers can filter by subject uniformly.","valid_values":["english_language_arts"],"example":"english_language_arts","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"num_tested","type":"integer","role":"metric","nullable":true,"label":"Number Tested","short_description":"","description":"Count of students who took the EOG ELA assessment in this cell. Bronze TOTAL_STUDENTS_TESTED. NULL when suppressed (TFS, 2021+) or genuinely empty in the source (every 2015-2019 file, 126-141 cells per year).","valid_values":null,"example":132,"unit":"count","value_min":null,"value_max":null,"null_meaning":"2015-2019: genuinely empty source cell; 2021+: GOSA TFS (too few students) suppression.","key_metric_grain_contributor":false,"metric_component":null},{"name":"num_with_lexile","type":"integer","role":"metric","nullable":true,"label":"Number with Lexile","short_description":"","description":"Count of tested students who received a usable Lexile measure; never exceeds num_tested (verified, authored as a quality check). Bronze STUDENTS_WITH_LEXILE. NULL when suppressed.","valid_values":null,"example":132,"unit":"count","value_min":null,"value_max":null,"null_meaning":"2015-2019: genuinely empty source cell; 2021+: GOSA TFS (too few students) suppression.","key_metric_grain_contributor":false,"metric_component":"denominator"},{"name":"num_at_or_above_lexile_midpoint","type":"integer","role":"metric","nullable":true,"label":"Number at or Above Lexile Midpoint","short_description":"","description":"Count of students whose Lexile measure was at or above the grade-band stretch midpoint (GOSA's on-track-reader threshold). A raw COUNT, not a percentage — to derive the share, divide by num_with_lexile (the population with a valid Lexile), not num_tested. Never exceeds num_with_lexile (verified, authored as a quality check). Bronze LEXILE_ON_OR_ABOVE_MIDPOINT. NULL when suppressed.","valid_values":null,"example":19,"unit":"count","value_min":null,"value_max":null,"null_meaning":"2015-2019: genuinely empty source cell; 2021+: GOSA TFS (too few students) suppression.","key_metric_grain_contributor":false,"metric_component":null},{"name":"num_without_lexile","type":"integer","role":"metric","nullable":true,"label":"Number Without Lexile","short_description":"","description":"Count of tested students who did not receive a Lexile measure. Bronze NO_LEXILE_SCORE. From 2021 onward ~99% of cells are TFS-suppressed (few students at any school lack a Lexile), so the column is ~99% NULL post-COVID; retained for pre-2020 comparability. CAVEAT: num_with_lexile + num_without_lexile does NOT reliably equal num_tested — small +/- discrepancies exist in every year, and 2023/2024 state- and district-level rows fall short by thousands (the published aggregate does not reconcile); published values are preserved exactly.","valid_values":null,"example":3,"unit":"count","value_min":null,"value_max":null,"null_meaning":"2015-2019: genuinely empty source cell; 2021+: GOSA TFS suppression (~99%% of rows from 2021 onward).","key_metric_grain_contributor":false,"metric_component":null},{"name":"avg_lexile_score","type":"number","role":"metric","nullable":true,"label":"Average Lexile Score","short_description":"Average Lexile reading measure among students who got one, on the natural Lexile scale; not a percentage.","description":"Average Lexile reading measure among students who received one, to one decimal place on the natural Lexile scale (observed 300.0-1435.0 across all years; the contract enforces 0-2000 — a Beginning-Reader BR floor below 0 is unreachable by a school/grade average). NOT a percentage; never rescaled. Bronze AVG_LEXILE_SCORE. NULL when suppressed.","valid_values":null,"example":607.0,"unit":"score","value_min":0,"value_max":2000,"null_meaning":"2015-2019: genuinely empty source cell; 2021+: GOSA TFS (too few students) suppression.","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"avg_lexile_score","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":[2015,2016,2017,2018,2019,2021,2022,2023,2024],"schema_hash":"971f8f1c82d6b245c78083940fd83a5c5f13c30c86c1051d6cc24a1426f20420","tags":["education","governor's office of student achievement","georgia_milestones_end_of_grade_lexile"],"granularity_description":"One row per year, district_code, school_code, grade_level, subject (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2024), schools detail","query":"SELECT * FROM georgia_milestones_end_of_grade_lexile WHERE year = 2024 LIMIT 100"},{"description":"District 601 in 2024","query":"SELECT * FROM georgia_milestones_end_of_grade_lexile WHERE district_code = '601' AND year = 2024 LIMIT 100"},{"description":"Filter by grade_level = 04","query":"SELECT * FROM georgia_milestones_end_of_grade_lexile WHERE grade_level = '04' 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":"grade_level","kind":"categorical","column":"grade_level","type":"string","multi_value":true,"enum_enforced":true,"values":["03","04","05","06","07","08"],"has_total":false,"total_value":null,"requires_single_value":true},{"param":"subject","kind":"categorical","column":"subject","type":"string","multi_value":true,"enum_enforced":true,"values":["english_language_arts"],"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":[]}