{"main_topic":"education","sub_topic":"gosa","topic":"georgia_milestones_end_of_course_lexile","key":"education/gosa/georgia_milestones_end_of_course_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_course_lexile/year={year}/{detail}.parquet","grain":["year","district_code","school_code","subject"],"title":"Georgia Milestones EOC Lexile Reading Scores","summary":"Lexile reading-measure distributions from Georgia's two ELA End-of-Course exams by school, district, and state, 2015-2024.","description":"Governor's Office of Student Achievement (GOSA) Georgia Milestones End-of-Course (EOC) Lexile assessment dataset. Reports Lexile reading-measure distributions derived from Georgia's two English Language Arts EOC courses (9th Grade Literature and Composition, American Literature and Composition). Each row is one (entity x subject) combination with five measures: total students tested, students with a Lexile measure, students without a Lexile score, students with Lexile at or above the grade-level midpoint (the 'on-track reader' threshold), and the average Lexile measure. Coverage is school years 2014-15 through 2023-24 (2019-20 absent — EOC testing suspended due to COVID-19) at state, district, and school detail levels. No demographic breakdown — every row is implicitly 'All Students'.","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_course_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). Derived from the filename and cross-checked against the bronze SCHOOL_YEAR column. 2020 is absent (EOC 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 county/city 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":"0100","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"subject","type":"string","role":"categorical","nullable":false,"label":"Subject","short_description":"Which ELA End-of-Course exam the row covers: 9th Grade Literature (through 2021) or American Literature.","description":"ELA EOC course this row measures, snake_case canonical. 9th_grade_literature_and_composition is present 2015-2021 (only 84 rows in 2021) and retired after 2021 — a real curriculum change (GOSA moved 9th-grade ELA off the EOC program), not a relabeling. american_literature_and_composition is present every year and is the sole subject from 2022.","valid_values":["9th_grade_literature_and_composition","american_literature_and_composition"],"example":"american_literature_and_composition","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 subject's EOC. Bronze TOTAL_STUDENTS_TESTED. NULL when the source cell is blank (2015-2019 — those files contain no TFS) or TFS-suppressed (2021-2024); 4-18% of rows depending on year.","valid_values":null,"example":287,"unit":"count","value_min":null,"value_max":null,"null_meaning":"2015-2019: genuinely blank source cell; 2021-2024: 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 whose EOC produced a usable Lexile measure — equal to or slightly below num_tested, never above it (enforced). Reported exactly when avg_lexile_score is reported (enforced biconditional). Bronze STUDENTS_WITH_LEXILE; NULL when blank (2015-2019) or TFS-suppressed (2021-2024). In all years only 2 rows have num_tested reported with this column missing (2015 Polk County school 0207; 2016 Bleckley County school 0115 — blank cells, not TFS).","valid_values":null,"example":287,"unit":"count","value_min":null,"value_max":null,"null_meaning":"2015-2019: genuinely blank source cell; 2021-2024: GOSA TFS suppression.","key_metric_grain_contributor":false,"metric_component":"denominator"},{"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 usable Lexile measure, as published by GOSA (bronze NO_LEXILE_SCORE). This is an independently reported source count, NOT the arithmetic complement num_tested - num_with_lexile: of the 140 rows (all years) where all three counts are numeric, 45 disagree with that derivation (by up to 99 students), so the published column is retained rather than derived and no with+without=tested check is enforced. Heavily suppressed (~94-99% NULL).","valid_values":null,"example":30,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Blank source cell (2015-2019) or GOSA TFS suppression (2021-2024) — ~94-99%% of rows in every year; only 1-37 rows per year carry a numeric value.","key_metric_grain_contributor":false,"metric_component":null},{"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 midpoint of the course's Lexile range (GOSA's 'on-track reader' / grade-level threshold: 1050L for 9th Grade Literature, 1185L for American Literature). A raw COUNT, not a percentage (2024 state row: 69,660 of 132,835 students with a Lexile = 52.4%) — derive a share by dividing by num_with_lexile (the population with a valid Lexile), not num_tested. Never exceeds num_with_lexile (enforced). Bronze LEXILE_ON_OR_ABOVE_MIDPOINT; NULL when suppressed.","valid_values":null,"example":65,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Blank source cell (2015-2019) or GOSA TFS suppression (2021-2024) — the most-missing count after num_without_lexile (~10-29%% of rows by year).","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 (on the natural Lexile scale, not a percentage) among students who received one.","description":"Average Lexile reading measure among students who received one, reported to one decimal place. The Lexile reader scale runs from below 0L (BR / Beginning Reader) to above 2000L; the contract enforces 0-2000 for these entity-level averages (observed range 707.0-1679.3 across all years and detail levels — a below-0 BR average is unreachable for an EOC cohort). NOT a percentage — no 0-1 rescaling; the natural Lexile scale is preserved. Reported exactly when num_with_lexile is reported (enforced biconditional). Bronze AVG_LEXILE_SCORE; NULL when suppressed.","valid_values":null,"example":1119.9,"unit":"score","value_min":0,"value_max":2000,"null_meaning":"Blank source cell (2015-2019) or GOSA TFS suppression (2021-2024) — exactly when num_with_lexile is missing.","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":"91988a21c74436d9a28b26a926ea0b21fb149ac023b7482cdca1d4d78790f691","tags":["education","governor's office of student achievement","georgia_milestones_end_of_course_lexile"],"granularity_description":"One row per year, district_code, school_code, subject (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2024), schools detail","query":"SELECT * FROM georgia_milestones_end_of_course_lexile WHERE year = 2024 LIMIT 100"},{"description":"District 601 in 2024","query":"SELECT * FROM georgia_milestones_end_of_course_lexile WHERE district_code = '601' AND year = 2024 LIMIT 100"},{"description":"Filter by subject = american_literature_and_composition","query":"SELECT * FROM georgia_milestones_end_of_course_lexile WHERE subject = 'american_literature_and_composition' 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":"subject","kind":"categorical","column":"subject","type":"string","multi_value":true,"enum_enforced":true,"values":["9th_grade_literature_and_composition","american_literature_and_composition"],"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":[]}