{"main_topic":"education","sub_topic":"gosa","topic":"georgia_milestones_end_of_course_by_grade_level","key":"education/gosa/georgia_milestones_end_of_course_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_course_by_grade_level/year={year}/{detail}.parquet","grain":["year","district_code","school_code","demographic","grade_level","subject"],"title":"Georgia Milestones End-of-Course (EOC) Results by Grade","summary":"Georgia Milestones high school course achievement results broken out by test-taker grade, course, and subgroup, 2015-2024.","description":"Georgia Milestones End-of-Course (EOC) assessment results disaggregated by the grade level of the test-taker, published by the Governor's Office of Student Achievement (GOSA). Each row is one (entity x grade x demographic subgroup x course) combination reporting the number of students tested plus the count and percentage at each of four achievement levels (Beginning, Developing, Proficient, Distinguished Learner) and two derived cumulative shares. Covers school years 2014-15 through 2023-24 (2019-20 absent — EOC testing suspended due to COVID-19) at state, district, and school detail levels.","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_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). Derived from the filename and cross-checked against the source's LONG_SCHOOL_YEAR. 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":"0386","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":"Demographic subgroup the row reports; 'all' is the overall figure (subgroups are non-additive).","description":"Canonical demographic subgroup code (FK to the global demographics dimension), normalized from bronze SUBGROUP_NAME. This topic uses the SPLIT race convention — separate asian and pacific_islander rows in every year (no combined asian_pacific_islander bucket). Coverage grew over time: the stable 18-key core (2015+), plus active_duty and homeless from 2021, with active_duty renamed at the source to military_connected from 2022 alongside new foster_care rows. NON-ADDITIVE MILITARY KEYS: active_duty (dependents of currently-serving active-duty members) is a subset of military_connected (any DoD-connected family) — never sum the two.","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 level of the test-takers, 07-12; grade 7 is rare and grade 12 includes retakes.","description":"Grade level of the test-takers this row represents, as a 2-char zero-padded string. Bronze ACDMC_LVL is unpadded (7..12) in 2015-2019 and zero-padded (07..12) in 2021-2024; gold normalizes both to 07-12. Grade 7 is rare (the small set of 7th graders taking EOC courses early); grade 12 includes retake/make-up administrations.","valid_values":["07","08","09","10","11","12"],"example":"09","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":"EOC course assessed (e.g. biology, algebra_i, us_history); the value set tracks curriculum changes over time.","description":"EOC course assessed, snake_case canonical. The value set tracks real curriculum changes: 9th_grade_literature_and_composition, analytic_geometry, economics_business_free_enterprise, geometry, and physical_science were retired after 2021; algebra_i and geometry first administered 2016; algebra_concepts_and_connections added 2024 (replacing coordinate_algebra over time). Historical course identities are preserved — algebra_i, coordinate_algebra, and algebra_concepts_and_connections are distinct courses, not aliases.","valid_values":["9th_grade_literature_and_composition","algebra_concepts_and_connections","algebra_i","american_literature_and_composition","analytic_geometry","biology","coordinate_algebra","economics_business_free_enterprise","geometry","physical_science","us_history"],"example":"biology","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 in this grade tested on this EOC course in this (entity x demographic) cell. Includes test-takers without a valid achievement-level score, so it can exceed the sum of the four num_*_learner counts (observed in 2023-2024; the sum never exceeds num_tested). Suppressed (NULL) in every year, most heavily in 2024 (~55% of rows) where the pct_* columns still carry the rounded distribution.","valid_values":null,"example":33,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA (TFS, 'Too Few Students'). Affects every year: ~7-8% of rows in 2015-2019, ~5-8% in 2021-2023, and ~55% in 2024 when GOSA broadened suppression of this column.","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 scoring Beginning Learner (lowest of the four achievement levels). Bronze BEGIN_CNT; NULL when suppressed (TFS string, or — on the fully-suppressed rows of every 2015-2019 file — genuine empty CSV fields).","valid_values":null,"example":30,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA (TFS, 'Too Few Students').","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 scoring Developing Learner. Bronze DEVELOPING_CNT. 2017 ANOMALY: the 2017 source file is the only year/column where suppression was ENTIRELY absent (zero TFS markers) — it carries 3,001 literal 0 values and a ~7% null rate vs 43-75% in every other year, conflating true zeros with small counts the publisher should have suppressed. Two sibling columns show the same published-zero irregularity in single years (num_distinguished_learner 2015: 4,940 zeros; num_proficient_learner 2017: 824 zeros — see those columns); no other year/column pair has any literal zeros. Bronze-faithful pass-through; do not compare 2017 values for this column directly against other years.","valid_values":null,"example":15,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA (TFS) — except 2017, where the source failed to suppress this column.","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 scoring Proficient Learner. Bronze PROFICIENT_CNT; NULL when suppressed. 2017 CAVEAT: the 2017 source published 824 literal 0 values for this column (TFS suppression was still applied to 47,937 other cells) — no other year has any. The zeros conflate true zeros with small counts that would normally be suppressed; bronze-faithful pass-through.","valid_values":null,"example":12,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA (TFS, 'Too Few Students').","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 scoring Distinguished Learner (highest level). The most heavily suppressed metric (~80% NULL in 2023, ~88% in 2024) — few cells have enough distinguished scorers to clear the threshold. 2015 CAVEAT: the 2015 source published 4,940 literal 0 values for this column (TFS suppression was still applied to 48,267 other cells), depressing the 2015 null rate to ~52% vs 75-79% in 2016-2019 (2015 min is 0 vs 10 elsewhere); no other year has any. The zeros conflate true zeros with small counts that would normally be suppressed — do not compare 2015 values for this column directly against later years; bronze-faithful pass-through.","valid_values":null,"example":5,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA (TFS, 'Too Few Students').","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 scoring Beginning Learner, 0-1 scale (bronze 0-100 divided by 100). In 2015-2023 NULL exactly when num_tested is NULL (fully suppressed cell); in 2024 always reported — GOSA publishes the rounded distribution even when every count is suppressed. The four pct_*_learner shares are computed against num_tested and can sum to less than 1.0 when some test-takers lack a valid achievement-level score (pronounced in 2023-2024); they never sum above ~1.002 (rounding).","valid_values":null,"example":0.909,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA — in 2015-2023 exactly when num_tested is suppressed; 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 scoring Developing Learner, 0-1 scale. Same suppression and partition behavior as pct_beginning_learner.","valid_values":null,"example":0.091,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA — in 2015-2023 exactly when num_tested is suppressed; 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 scoring Proficient Learner, 0-1 scale. Same suppression and partition behavior as pct_beginning_learner.","valid_values":null,"example":0.25,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA — in 2015-2023 exactly when num_tested is suppressed; 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 scoring Distinguished Learner, 0-1 scale. Same suppression and partition behavior as pct_beginning_learner.","valid_values":null,"example":0.104,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA — in 2015-2023 exactly when num_tested is suppressed; 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":"Cumulative share at Developing Learner or higher, derived at transform time as pct_developing_learner + pct_proficient_learner + pct_distinguished_learner (0-1 scale). Sums of publisher-rounded shares landing within 0.005 above 1.0 are capped to 1.0. NULL whenever any summand is NULL.","valid_values":null,"example":0.605,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"NULL whenever any of the three summand shares is NULL (suppression propagates).","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 Learner or higher, on a 0-1 scale (the headline EOC proficiency rate).","description":"Cumulative share at Proficient Learner or higher (the headline 'proficiency rate'), derived at transform time as pct_proficient_learner + pct_distinguished_learner (0-1 scale). Sums of publisher-rounded shares landing within 0.005 above 1.0 are capped to 1.0. NULL whenever either summand is NULL.","valid_values":null,"example":0.354,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"NULL whenever either summand share is NULL (suppression propagates).","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.","null_semantics":{"suppressed_to_null":true,"zero_is_real":true},"available_years":[2015,2016,2017,2018,2019,2021,2022,2023,2024],"schema_hash":"742035feecb442bade1cc132f06e55618033e24126147e6eb327bcaeb8f666e1","tags":["education","governor's office of student achievement","georgia_milestones_end_of_course_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_course_by_grade_level WHERE year = 2024 LIMIT 100"},{"description":"District 601 in 2024","query":"SELECT * FROM georgia_milestones_end_of_course_by_grade_level WHERE district_code = '601' AND year = 2024 LIMIT 100"},{"description":"Filter by grade_level = 09","query":"SELECT * FROM georgia_milestones_end_of_course_by_grade_level WHERE grade_level = '09' 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":["07","08","09","10","11","12"],"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":["9th_grade_literature_and_composition","algebra_concepts_and_connections","algebra_i","american_literature_and_composition","analytic_geometry","biology","coordinate_algebra","economics_business_free_enterprise","geometry","physical_science","us_history"],"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":[]}