{"main_topic":"education","sub_topic":"gosa","topic":"georgia_alternate_assessment","key":"education/gosa/georgia_alternate_assessment","version":"1.0.0","year_min":2004,"year_max":2024,"year_gaps":[2008,2009,2010,2020,2021],"update_frequency":"annual","detail_levels":["districts","schools","states"],"default_detail":"schools","path_template":"education/georgia_alternate_assessment/year={year}/{detail}.parquet","grain":["year","district_code","school_code","demographic","subject"],"title":"Georgia Alternate Assessment (GAA)","summary":"Achievement results on the alternate assessment for Georgia students with significant cognitive disabilities, by subject and subgroup, 2004-2024.","description":"Georgia Alternate Assessment (GAA) participation and achievement-level results for Georgia public school students with significant cognitive disabilities, published by the Governor's Office of Student Achievement (GOSA). The GAA is a separate assessment from Georgia Milestones, taken by students whose IEP team determines they cannot access the general assessment. Two measure regimes share one schema: 2004-2007 is a participation summary (enrollment in AYP-applicable grades plus the count of students taking the GAA per school/district/state, no demographics, no subject), while 2011-2024 is a tidy achievement-level fact per (entity x demographic subgroup x subject) with counts and percentages at up to four achievement levels plus two derived cumulative shares. 2011-2018 is the portfolio-based 3-tier GAA 1.0 (no distinguished tier — those metrics are NULL, not 0); the Milestones-aligned 4-tier GAA 2.0 begins in 2019. Coverage: 2004-2007, 2011-2019, 2022-2024 (2008-2010 are GOSA archive gaps; 2020-2021 COVID testing suspensions).","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_alternate_assessment","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; for 2011-2024 cross-checked against the source's LONG_SCHOOL_YEAR. 2008-2010 and 2020-2021 are absent from the source.","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 code or 7-digit state-charter code. NULL on state-level aggregate 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 zero-padded GOSA school code (FK to schools dimension as the composite (district_code, school_code) key). NULL on district- and state-level aggregate rows. The 2019 source file ships codes unpadded; zfill(4) restores the dimension's 4-char format.","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":"Demographic subgroup the row reports; 'all' for every 2004-2007 row and for the overall figure thereafter.","description":"Canonical demographic subgroup (FK to the global demographics dimension). 'all' for every 2004-2007 row (no demographic breakdown published in those years); 2011-2024 rows carry the full subgroup set (race, gender, economic status, special populations). This topic uses the SPLIT race convention — separate `asian` and `pacific_islander` rows, never the combined rollup. NON-ADDITIVE MILITARY KEYS: `active_duty` (dependents of currently-serving members) is a SUBSET of `military_connected` (any DoD-connected family); both appear from 2022 on — do not sum them across the demographic axis.","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":"subject","type":"string","role":"categorical","nullable":true,"label":"Subject","short_description":"Content area assessed (ELA, math, science, or social studies); NULL for 2004-2007 participation-only rows.","description":"GAA content area being assessed — one of the four GAA subjects (english_language_arts, mathematics, science, social_studies). NULL for 2004-2007 rows, which report only overall participation with no subject detail.","valid_values":["english_language_arts","mathematics","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_enrolled_ayp_grades","type":"integer","role":"metric","nullable":true,"label":"Number Enrolled Ayp Grades","short_description":"","description":"Total enrollment in AYP-applicable grades (grades 1-8 and 11). Published ONLY for 2004-2007; NULL for every 2011-2024 row (GOSA stopped publishing the column). Note: num_tested can legitimately exceed this value (e.g., DeKalb school 644:3058 in 2004-2005) because the GAA is also administered in non-AYP grades while this denominator counts AYP grades only.","valid_values":null,"example":540,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"num_tested","type":"integer","role":"metric","nullable":true,"label":"Number Tested","short_description":"","description":"Count of students taking the GAA in this cell. Always reported 2004(*)-2023; in 2024 GOSA suppressed it (TFS) on ~84% of rows while still publishing the level percentages, so most 2024 rows have NULL num_tested with non-NULL pct_*_learner values. (*) A handful of 2004 rows have NULL metrics as published.","valid_values":null,"example":22,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"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 scoring at the lowest achievement tier. Unifies the era namings LIMITED (2011-2018, 2022-2023), Level1 (2019), and BEGIN (2024). NULL for 2004-2007 (no achievement detail) and for suppressed cells.","valid_values":null,"example":3,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"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 scoring at the second tier (PARTIAL / Level2 / DEVELOPING across eras). NULL for 2004-2007 and for suppressed cells.","valid_values":null,"example":8,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"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 scoring at the third tier (ADEQUATE / Level3 / PROFICIENT across eras). NULL for 2004-2007 and for suppressed cells.","valid_values":null,"example":11,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"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 scoring at the highest (4th) achievement tier (Level4 / THOROUGH / DISTINGUISHED across eras). NULL for 2004-2007 AND for all of 2011-2018: the GAA used 3-tier scoring then and the tier did not exist (the source's reserved THUROUGH column, always 0/empty, is dropped rather than served as a phantom all-zero metric). Also NULL for suppressed cells.","valid_values":null,"example":4,"unit":"count","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 lowest tier, 0-1 scale (bronze publishes 0-100; divided by 100). NULL for 2004-2007 and suppressed cells.","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","type":"number","role":"metric","nullable":true,"label":"Percent Developing Learner","short_description":"","description":"Share at the second tier, 0-1 scale. NULL for 2004-2007 and suppressed cells.","valid_values":null,"example":0.25,"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 the third tier, 0-1 scale. NULL for 2004-2007 and suppressed cells.","valid_values":null,"example":0.381,"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 the highest tier, 0-1 scale. NULL for 2004-2007, for ALL of 2011-2018 (3-tier era — tier did not exist), and for suppressed cells.","valid_values":null,"example":0.524,"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":"Derived cumulative share at Developing or higher, 0-1 scale. For 4-tier years (2019+): developing + proficient + distinguished (NULL when any summand is suppressed). For the 3-tier 2011-2018 era the absent distinguished tier is omitted from the sum (developing + proficient), so those years ARE populated. Publisher-rounded summands can overshoot 1.0 by up to 0.001; overshoot within 0.005 is capped to 1.0. NULL for 2004-2007.","valid_values":null,"example":0.905,"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":"Share of tested students scoring Proficient Learner or higher, on a 0-1 scale (the headline GAA proficiency rate).","description":"Derived cumulative share at Proficient or higher, 0-1 scale. For 4-tier years (2019+): proficient + distinguished; for 3-tier 2011-2018 it equals pct_proficient_learner. Rounding overshoot within 0.005 is capped to 1.0. NULL for 2004-2007 and when a summand is suppressed.","valid_values":null,"example":0.655,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":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.","null_semantics":{"suppressed_to_null":true,"zero_is_real":true},"available_years":[2004,2005,2006,2007,2011,2012,2013,2014,2015,2016,2017,2018,2019,2022,2023,2024],"schema_hash":"0b1b7d2b72d576ce4142de6037d3d262dbb2f3b7c260d5a00673bfc58c6c6861","tags":["education","governor's office of student achievement","georgia_alternate_assessment"],"granularity_description":"One row per year, district_code, school_code, demographic, subject (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2024), schools detail","query":"SELECT * FROM georgia_alternate_assessment WHERE year = 2024 LIMIT 100"},{"description":"District 601 in 2024","query":"SELECT * FROM georgia_alternate_assessment WHERE district_code = '601' AND year = 2024 LIMIT 100"},{"description":"Filter by subject = mathematics","query":"SELECT * FROM georgia_alternate_assessment WHERE subject = 'mathematics' 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":"subject","kind":"categorical","column":"subject","type":"string","multi_value":true,"enum_enforced":true,"values":["english_language_arts","mathematics","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":[]}