{"main_topic":"education","sub_topic":"georgiainsights","topic":"georgia_milestones_end_of_grade","key":"education/georgiainsights/georgia_milestones_end_of_grade","version":"1.0.0","year_min":2015,"year_max":2025,"year_gaps":[2020],"update_frequency":"annual","detail_levels":["districts","schools","states"],"default_detail":"schools","path_template":"education/georgia_milestones_end_of_grade/year={year}/{detail}.parquet","grain":["year","district_code","school_code","grade_level","subject","assessment_type"],"title":"Georgia Milestones End-of-Grade (EOG) Results","summary":"Georgia Milestones grades 3-8 test results by school, district, grade, and subject, 2015-2025.","description":"Georgia Milestones End-of-Grade (EOG) assessment results for grades 3-8 — published annually (except 2020, cancelled due to COVID) at the state, district/system, and school level. The primary metrics are the count of students tested, the mean scale score, and the share of students at each of the four achievement levels (Beginning / Developing / Proficient / Distinguished Learner) plus the two cumulative shares. English Language Arts rows additionally carry Reading Status metrics (pct_below_grade_level_lexile / pct_grade_level_or_above_lexile) from 2018 onward, anchored to grade-specific Lexile thresholds (520L for grade 3, 740L for grade 4, 830L for grade 5, 925L for grade 6, 970L for grade 7, 1010L for grade 8). 2016-2021 grade 6-8 rows split affected subjects into EOG / EOC / Combined variants to represent middle-schoolers taking end-of-course exams early (captured in the assessment_type column). 2022+ drops the EOC variants (moved to the georgia_milestones_end_of_course topic), adds a Standard Deviation metric per subject, and adds Physical Science for grade 8. 2024-2025 adds Student Growth Percentile (SGP) metrics — num_sgp_received, sgp_median, pct_sgp_low_growth, pct_sgp_typical_growth, pct_sgp_high_growth — reported on the parent ELA / Mathematics rows for grades 4-8.","source":"Georgia Insights (GaDOE) — Georgia Milestones End-of-Grade Assessment","source_url":"https://georgiainsights.gadoe.org/data-downloads/","endpoint":"/api/v1/education/georgia_milestones_end_of_grade","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Ending calendar year of the school year (e.g., 2025 = school year 2024-2025). 2020 is absent — the COVID-19 pandemic cancelled the administration.","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":"3-digit GOSA district/system code (FK to districts dimension). 7-digit charter / state-school campus codes are preserved in full; 2015 school-level rows published under the bare charter SYSTEM codes 782/783 are promoted to the 7-digit campus code (system + school code), and the 2015 shared state-school code 799 is remapped to the unique 7991893/7991894/7991895 codes used from 2016. NULL for 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":"4-digit GOSA school code (FK to schools dimension, composite with district_code). NULL for district- and state-level rows.","valid_values":null,"example":"0177","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":"Tested grade, 03 through 08 (Milestones EOG covers only grades 3-8).","description":"Grade level, zero-padded 2-char string ('03'..'08'). Georgia Milestones EOG is administered only to grades 3-8. Same encoding as the other per-grade education topics.","valid_values":["03","04","05","06","07","08"],"example":"05","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":"The content area tested (english_language_arts, mathematics, science, social_studies, physical_science).","description":"Snake-case academic content area: english_language_arts, mathematics, science, social_studies, physical_science (grade 8 only, from 2022 — 8th-graders taking the high-school Physical Science course early; bronze labels it 'HS Physical Science'). Bronze ships Reading Status and Student Growth Percentile (SGP) as parallel \"subject\" blocks, but those are metric families computed on the ELA / Mathematics test-taker population — the transform folds their metric columns onto the parent ELA / Mathematics row (pct_below_grade_level_lexile, pct_grade_level_or_above_lexile, num_sgp_received, sgp_median, pct_sgp_*) and drops the parallel rows.","valid_values":["english_language_arts","mathematics","science","social_studies","physical_science"],"example":"mathematics","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"assessment_type","type":"string","role":"categorical","nullable":false,"label":"Assessment Type","short_description":"Marks regular EOG vs the 2016-2021 early end-of-course variants; use eog for year-over-year comparisons.","description":"Differentiates regular EOG from the middle-school EOG / EOC / Combined triples that existed in 2016-2021 (middle-schoolers taking End-of-Course exams early: Mathematics 2016-2019, Science 2016-2021, English Language Arts 2018-2019 — never Social Studies). 2015 and 2022+ data is always `eog`. Filter assessment_type = 'eog' for the canonical comparison-safe year-over-year EOG-only time series.","valid_values":["eog","eoc","eog_and_eoc_combined"],"example":"eog","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":"Number of students who took the test. NULL when the source suppresses the cell ('--') for small populations.","valid_values":null,"example":271,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":"denominator"},{"name":"avg_scale_score","type":"number","role":"metric","nullable":true,"label":"Average Scale Score","short_description":"Average end-of-grade scale score (140-830 scale); higher means stronger performance.","description":"Mean scale score on the EOG scale. Georgia Milestones EOG scale scores span 140-830 across grades/subjects (per-grade min/max differ; the envelope runs from the grade-6 ELA floor of 140 to the grade-3 ELA ceiling of 830, per the GaDOE EOG Score Interpretation Guide); the contract enforces that range. NOT converted to 0-1 — scale scores are preserved as-is per education CLAUDE.md. Never published for eoc / eog_and_eoc_combined rows (the bronze EOC blocks ship no Mean Scale Score column).","valid_values":null,"example":502.8,"unit":"score","value_min":140,"value_max":830,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"scale_score_std_dev","type":"number","role":"metric","nullable":true,"label":"Scale Score Std Dev","short_description":"","description":"Standard deviation of the scale scores — a dispersion measure, NOT a bounded score. Units are scale-score points; the value is always >= 0. Exempt from unit/range checks (it has no fixed upper bound). Published from 2022 onward; NULL for all earlier years.","valid_values":null,"example":64.0,"unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_beginning_learner","type":"number","role":"metric","nullable":true,"label":"Percent Beginning Learner","short_description":"","description":"Share of tested students at the Beginning Learner level (0-1 decimal scale; bronze 0-100 divided by 100).","valid_values":null,"example":0.369,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_developing_learner","type":"number","role":"metric","nullable":true,"label":"Percent Developing Learner","short_description":"","description":"Share at Developing Learner (0-1 scale).","valid_values":null,"example":0.302,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_proficient_learner","type":"number","role":"metric","nullable":true,"label":"Percent Proficient Learner","short_description":"","description":"Share at Proficient Learner (0-1 scale).","valid_values":null,"example":0.233,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_distinguished_learner","type":"number","role":"metric","nullable":true,"label":"Percent Distinguished Learner","short_description":"","description":"Share at Distinguished Learner (0-1 scale).","valid_values":null,"example":0.095,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_developing_learner_or_above","type":"number","role":"metric","nullable":true,"label":"Percent Developing Learner or Above","short_description":"","description":"Share at Developing Learner or higher (= developing + proficient + distinguished). Published by the source and preserved verbatim rather than re-derived.","valid_values":null,"example":0.631,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_proficient_learner_or_above","type":"number","role":"metric","nullable":true,"label":"Percent Proficient Learner or Above","short_description":"","description":"Share at Proficient Learner or higher (= proficient + distinguished). Published by the source and preserved verbatim.","valid_values":null,"example":0.328,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_below_grade_level_lexile","type":"number","role":"metric","nullable":true,"label":"Percent Below Grade Level Lexile","short_description":"","description":"Reading Status: share of ELA test takers reading BELOW the grade-specific Lexile threshold (2018 onward). Populated only on english_language_arts rows. The threshold is 520L / 740L / 830L / 925L / 970L / 1010L for grades 3 / 4 / 5 / 6 / 7 / 8 — documented here rather than encoded in the column name so the schema stays grade-agnostic.","valid_values":null,"example":0.354,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_grade_level_or_above_lexile","type":"number","role":"metric","nullable":true,"label":"Percent Grade Level or Above Lexile","short_description":"","description":"Reading Status: share of ELA test takers reading at or above the grade-specific Lexile threshold; complement of pct_below_grade_level_lexile. Populated only on english_language_arts rows (2018 onward).","valid_values":null,"example":0.646,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"enrolled_tested_rate","type":"number","role":"metric","nullable":true,"label":"Enrolled Tested Rate","short_description":"","description":"Share of enrolled students who actually tested. Published ONLY by the 2021 files (testing was optional during COVID, so participation is essential context); NULL for every other year. The 2021 grade-8 system file leaves this sub-header blank in the ELA-EOG block (a merged-cell artifact); the transform repairs the header so the published participation rates are preserved.","valid_values":null,"example":0.793,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"num_sgp_received","type":"integer","role":"metric","nullable":true,"label":"Number SGP Received","short_description":"","description":"Number of students with a Student Growth Percentile. Populated only on english_language_arts / mathematics rows at grades 4-8 from 2024 onward. Counted on the SGP-scored subset of test takers — distinct from num_tested. NULL elsewhere.","valid_values":null,"example":139,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"sgp_median","type":"number","role":"metric","nullable":true,"label":"SGP Median","short_description":"","description":"Median Student Growth Percentile (1-99 percentile rank, preserved on its natural scale per data-cleaning-standards §4). Float64 because even-population groups yield half-integer medians.","valid_values":null,"example":51.5,"unit":"percentile","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_sgp_low_growth","type":"number","role":"metric","nullable":true,"label":"Percent SGP Low Growth","short_description":"","description":"Share of SGP-scored students in the Low Growth band (0-1 scale).","valid_values":null,"example":0.33,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_sgp_typical_growth","type":"number","role":"metric","nullable":true,"label":"Percent SGP Typical Growth","short_description":"","description":"Share in the Typical Growth band (0-1 scale).","valid_values":null,"example":0.34,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_sgp_high_growth","type":"number","role":"metric","nullable":true,"label":"Percent SGP High Growth","short_description":"","description":"Share in the High Growth band (0-1 scale).","valid_values":null,"example":0.33,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"avg_scale_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,2025],"schema_hash":"809585caadc31c223e2d1014c4f7c664c242540eb5dbd005b88f02aad2a1c0c7","tags":["education","georgia insights","georgia_milestones_end_of_grade"],"granularity_description":"One row per year, district_code, school_code, grade_level, subject, assessment_type (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2025), schools detail","query":"SELECT * FROM georgia_milestones_end_of_grade WHERE year = 2025 LIMIT 100"},{"description":"District 601 in 2025","query":"SELECT * FROM georgia_milestones_end_of_grade WHERE district_code = '601' AND year = 2025 LIMIT 100"},{"description":"Filter by grade_level = 05","query":"SELECT * FROM georgia_milestones_end_of_grade WHERE grade_level = '05' AND year = 2025 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","mathematics","science","social_studies","physical_science"],"has_total":false,"total_value":null,"requires_single_value":true},{"param":"assessment_type","kind":"categorical","column":"assessment_type","type":"string","multi_value":true,"enum_enforced":true,"values":["eog","eoc","eog_and_eoc_combined"],"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":[]}