{"main_topic":"education","sub_topic":"gosa","topic":"georgia_milestones_end_of_grade_by_grade_level","key":"education/gosa/georgia_milestones_end_of_grade_by_grade_level","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_by_grade_level/year={year}/{detail}.parquet","grain":["year","district_code","school_code","demographic","grade_level","subject"],"title":"Georgia Milestones End-of-Grade Assessment by Grade","summary":"Georgia Milestones End-of-Grade achievement levels by grade, subject, and demographic for schools, districts, and the state, 2015-2024.","description":"Georgia Milestones End-of-Grade (EOG) assessment results for Georgia public-school students in grades 3-8, disaggregated by individual grade level. Each row is one (entity x grade x demographic subgroup x subject) cell reporting the number of students tested plus the count and percentage of test-takers at each of four achievement levels (Beginning, Developing, Proficient, Distinguished), with derived cumulative developing-or-above and proficient-or-above shares. State, district, and school detail levels. School years 2014-15 through 2023-24; 2019-20 is absent (EOG administration cancelled, 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_by_grade_level","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 LONG_SCHOOL_YEAR. 2020 has no rows (EOG cancelled 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 / commission-charter / state-school 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":"0103","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":"Student subgroup the row covers (race, gender, economic, disability, English-learner, etc.); 'all' is all students.","description":"Canonical demographic subgroup (FK to the global demographics dimension), normalized from bronze SUBGROUP_NAME. This topic uses the split race convention: asian and pacific_islander are separate, mutually exclusive rows (the source publishes both labels in every year). 18 core subgroups in 2015-2019; active_duty and homeless added in 2021; foster_care and military_connected (renaming active_duty) added in 2022. NON-ADDITIVE MILITARY KEYS: active_duty (2021) and military_connected (2022+) never co-occur in a year, but conceptually active-duty dependents are a subset of military-connected students — do not sum the two keys across years as if disjoint.","valid_values":["active_duty","all","asian","black","economically_disadvantaged","english_learners","female","foster_care","hispanic","homeless","male","migrant","military_connected","multiracial","native_american","not_economically_disadvantaged","not_english_learners","not_migrant","pacific_islander","students_with_disabilities","students_without_disabilities","white"],"example":"all","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"grade_level","type":"string","role":"categorical","nullable":false,"label":"Grade Level","short_description":"Grade tested, 03-08; this is the grade-by-grade breakout that distinguishes this topic from the all-grades rollup.","description":"Grade of the test-takers in this row, as a canonical 2-char zero-padded string. Bronze ACDMC_LVL is unpadded (3-8) in 2015 and 2019 and zero-padded (03-08) in all other years; gold normalizes both to 03-08. This column is the grain difference vs the all-grades rollup sibling topic.","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":"EOG content area tested (ELA, mathematics, science, social studies, physical science); coverage varies by grade and year.","description":"EOG academic subject. english_language_arts and mathematics span grades 3-8 in every year; science and social_studies are restricted to grades 5 and 8 from 2017 (social_studies to grade 8 only from 2021); physical_science (2022+) is an 8th-grade accelerated option. The natural grade x subject sparsity is preserved — untested combinations have no rows; rare out-of-pattern audit/retest cells are retained.","valid_values":["english_language_arts","mathematics","physical_science","science","social_studies"],"example":"mathematics","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 tested in this (entity x grade x subgroup x subject) cell. NULL when GOSA suppressed the cell (TFS); in 2024 GOSA extended suppression to this column (~30% of rows) while still publishing the rounded percentage distribution.","valid_values":null,"example":144,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA (TFS, too few students). Rare before 2024; ~30%% of 2024 rows.","key_metric_grain_contributor":false,"metric_component":"denominator"},{"name":"num_beginning_learner","type":"integer","role":"metric","nullable":true,"label":"Number Beginning Learner","short_description":"","description":"Count of students at the lowest achievement level (Beginning Learner). Bronze BEGIN_CNT; NULL when suppressed.","valid_values":null,"example":11,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA (TFS or empty source field).","key_metric_grain_contributor":false,"metric_component":null},{"name":"num_developing_learner","type":"integer","role":"metric","nullable":true,"label":"Number Developing Learner","short_description":"","description":"Count of students at the second achievement level (Developing Learner). Bronze DEVELOPING_CNT; NULL when suppressed.","valid_values":null,"example":35,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA (TFS or empty source field).","key_metric_grain_contributor":false,"metric_component":null},{"name":"num_proficient_learner","type":"integer","role":"metric","nullable":true,"label":"Number Proficient Learner","short_description":"","description":"Count of students at the third achievement level (Proficient Learner). Bronze PROFICIENT_CNT; NULL when suppressed.","valid_values":null,"example":70,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA (TFS or empty source field).","key_metric_grain_contributor":false,"metric_component":null},{"name":"num_distinguished_learner","type":"integer","role":"metric","nullable":true,"label":"Number Distinguished Learner","short_description":"","description":"Count of students at the highest achievement level (Distinguished Learner). Bronze DISTINGUISHED_CNT; the most-suppressed metric (~70-76% of rows in recent years — few cells have enough distinguished scorers to clear the threshold).","valid_values":null,"example":28,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA (TFS or empty source field).","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 level, 0-1 scale (bronze 0-100 divided by 100). Published shares are exact to one decimal on the 0-100 scale against num_tested. CAVEAT: on foster_care rows from 2022 onward the four level shares can sum below 1 (students tested but not assigned a level, plus all-zero placeholder rows on fully-suppressed cells) — published GOSA values are preserved exactly.","valid_values":null,"example":0.157,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA (whole-cell suppression; never NULL in 2024).","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 of tested students at the Developing level, 0-1 scale. See pct_beginning_learner for the foster_care caveat.","valid_values":null,"example":0.549,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA (whole-cell suppression; never NULL in 2024).","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 of tested students at the Proficient level, 0-1 scale. See pct_beginning_learner for the foster_care caveat.","valid_values":null,"example":0.255,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA (whole-cell suppression; never NULL in 2024).","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 of tested students at the Distinguished level, 0-1 scale. See pct_beginning_learner for the foster_care caveat.","valid_values":null,"example":0.039,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA (whole-cell suppression; never NULL in 2024).","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":"Derived cumulative share at Developing or above (developing + proficient + distinguished), 0-1 scale. Computed at transform time from the published per-level shares; sums of publisher-rounded shares that land within 0.005 above 1.0 are snapped to 1.0 (a share cannot exceed 1).","valid_values":null,"example":0.843,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"NULL whenever any of its three summands is 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":"Share of tested students scoring Proficient or Distinguished (proficient-or-above), on a 0-1 scale; the headline achievement measure.","description":"Derived cumulative share at Proficient or above (proficient + distinguished), 0-1 scale. Computed at transform time from the published per-level shares; rounding overshoot above 1.0 within 0.005 is snapped to 1.0.","valid_values":null,"example":0.294,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"NULL whenever either summand is NULL.","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"pct_proficient_learner_or_above","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). State rows have NULL district_code and school_code; district rows have NULL school_code. 2020 has no rows (EOG cancelled during COVID-19). Grade x subject coverage is naturally sparse and changes over time (science/social_studies grades 5+8 only from 2017, social_studies grade 8 only from 2021, physical_science grade 8 only). Foster Care caveat (2022-2024): the foster_care rows are the only rows whose four per-level shares can fail to sum to 1 — 28 fully-unsuppressed state-level rows carry level counts summing below num_tested (students tested but not assigned a performance level at publication), and partially- or fully-suppressed foster_care cells publish shares covering only the unsuppressed levels, including an all-four-zeros placeholder pattern. The published GOSA values are preserved exactly rather than reconciled.","null_semantics":{"suppressed_to_null":true,"zero_is_real":true},"available_years":[2015,2016,2017,2018,2019,2021,2022,2023,2024],"schema_hash":"692af1c294d3905d0aeceba72f51ac9e4ab6c34b14fd9c9eb4fff20a69a28c7f","tags":["education","governor's office of student achievement","georgia_milestones_end_of_grade_by_grade_level"],"granularity_description":"One row per year, district_code, school_code, demographic, 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_by_grade_level WHERE year = 2024 LIMIT 100"},{"description":"District 601 in 2024","query":"SELECT * FROM georgia_milestones_end_of_grade_by_grade_level WHERE district_code = '601' AND year = 2024 LIMIT 100"},{"description":"Filter by grade_level = 05","query":"SELECT * FROM georgia_milestones_end_of_grade_by_grade_level WHERE grade_level = '05' 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"},{"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","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":"demographic","kind":"foreign_key","column":"demographic","type":"string","multi_value":true,"enum_enforced":true,"values":["active_duty","all","asian","black","economically_disadvantaged","english_learners","female","foster_care","hispanic","homeless","male","migrant","military_connected","multiracial","native_american","not_economically_disadvantaged","not_english_learners","not_migrant","pacific_islander","students_with_disabilities","students_without_disabilities","white"]},{"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","physical_science","science","social_studies"],"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"]},{"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":[]}