{"main_topic":"education","sub_topic":"gosa","topic":"enrollment_demographic_shares","key":"education/gosa/enrollment_demographic_shares","version":"1.0.0","year_min":2004,"year_max":2024,"year_gaps":[],"update_frequency":"annual","detail_levels":["districts","schools","states"],"default_detail":"schools","path_template":"education/enrollment_demographic_shares/year={year}/{detail}.parquet","grain":["year","district_code","school_code","demographic","met_ayp","improvement_status"],"title":"Enrollment Demographic Shares","summary":"Each demographic subgroup's share of enrollment by Georgia school, district, and statewide, 2004-2024.","description":"Georgia Office of Student Achievement (GOSA) enrollment demographic shares. For every Georgia public school, school district, and the state as a whole, the share of enrollment in each of 12 demographic subgroups: six race/ethnicity buckets (Asian/Pacific Islander, Black, Hispanic, Native American, Multiracial, White), two sexes (male, female — published 2011 and 2018 onward), and four special populations (migrant — published 2011 onward, economically disadvantaged, students with disabilities, English learners). This topic is COMPUTED from the shared GOSA 'Enrollment by Subgroup Programs' bronze (FTE enrollment disaggregated by subgroup); the companion enrollment_program_participation topic exposes the program-participation side of the same files. enrollment_ratio is the share GOSA publishes for each subgroup: the subgroup's FTE count over the entity's total FTE enrollment (October snapshot denominator). Coverage spans school years 2003-04 through 2023-24. The 2004-2010 files also carry the NCLB-era Met AYP and Improvement Status indicators, denormalized across the 12 demographic rows per entity-year and NULL from 2011 on (AYP retired). Demographics whose column a source year does not publish (pre-2011 migrant/male/female; 2012-2017 male/female) are emitted with NULL enrollment_ratio so the 12-demographic grid is uniform across years.","source":"Governor's Office of Student Achievement (GOSA)","source_url":"https://gosa.georgia.gov/dashboards-data-report-card/downloadable-data","endpoint":"/api/v1/education/enrollment_demographic_shares","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Ending calendar year of the school year (2024 = the 2023-24 school year). Sourced from LONG_SCHOOL_YEAR for 2011+ (cross-checked against the filename); from the bronze filename for 2004-2010.","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 for standard districts, 7-digit for charter districts. 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 (composite FK to schools dimension with district_code). NULL on district- and state-level aggregate 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":"Which demographic subgroup the share is for; one of 12 race, sex, and special-population codes (no 'all' row).","description":"Canonical demographic code (FK to demographics dimension). Exactly 12 values: asian_pacific_islander, black, hispanic, native_american, multiracial, white, migrant, economically_disadvantaged, students_with_disabilities, english_learners, male, female. The bronze 'Asian' bucket is GOSA's pre-1997 OMB combined Asian + Pacific Islander bucket (the source publishes only 6 race buckets and never a separate Pacific Islander column), so it maps to asian_pacific_islander per data-cleaning-standards section 5b. No 'all' row exists — GOSA publishes no category-total share in this report.","valid_values":["asian_pacific_islander","black","economically_disadvantaged","english_learners","female","hispanic","male","migrant","multiracial","native_american","students_with_disabilities","white"],"example":"black","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"met_ayp","type":"string","role":"categorical","nullable":true,"label":"Met Ayp","short_description":"NCLB-era Adequate Yearly Progress flag (yes/no); populated 2004-2010 only, NULL afterward.","description":"NCLB-era Adequate Yearly Progress indicator (yes/no), published 2004-2010 only. An entity-level value repeated (denormalized) across the 12 demographic rows of the same (year, district, school) tuple. Bronze sentinels blank/N/A are NULL.","valid_values":["no","yes"],"example":"yes","unit":null,"value_min":null,"value_max":null,"null_meaning":"NULL for 2011+ (AYP retired) and for 2004-2010 rows whose bronze value was blank or N/A.","key_metric_grain_contributor":true,"metric_component":null},{"name":"improvement_status","type":"string","role":"categorical","nullable":true,"label":"Improvement Status","short_description":"NCLB-era school improvement-status code; populated 2004-2010 only, NULL afterward.","description":"NCLB-era school improvement-status code (adeq, adeq_dnm, dist, ni, ni_ayp), published 2004-2010 only and denormalized across the 12 demographic rows per entity-year. Bronze sentinels '.' and blank are NULL.","valid_values":["adeq","adeq_dnm","dist","ni","ni_ayp"],"example":"adeq","unit":null,"value_min":null,"value_max":null,"null_meaning":"NULL for 2011+ (AYP retired) and for 2004-2010 rows whose bronze value was blank or '.'.","key_metric_grain_contributor":true,"metric_component":null},{"name":"enrollment_ratio","type":"number","role":"metric","nullable":true,"label":"Enrollment Ratio","short_description":"This subgroup's share of the entity's total FTE enrollment, on a 0-1 scale (may exceed 1.0 for ED/SWD at some special schools).","description":"Share of the entity's total FTE enrollment in this demographic, on the 0-1 decimal scale (bronze 0-100 divided by 100). NULL when the bronze cell was suppressed (TFS — program-wide from 2023) or when the source year does not publish the demographic's column (pre-2011 migrant/male/female; 2012-2017 male/female; 2011 additionally suppresses English-learner shares on ~87% of school rows). Declared unit: ratio rather than proportion per section 4a: GOSA's published shares for economically_disadvantaged and students_with_disabilities legitimately exceed 1.0 at alternative/behavioral/early-childhood/state-special schools in 2004-2010 where the served count exceeds the October FTE snapshot denominator (verified maxima: 1.32 ED at 2008 Mountain Creek Academy, 1.17 SWD at 2004 Butler Early Childhood Center); all other demographics stay within [0, 1.02] (rounding artifacts). Values are preserved per section 4b (extreme-but-conceivable, not impossible). Note the statewide economically_disadvantaged share dips to 0.45 in 2022 between 0.56 (2021) and 0.59 (2023) — bronze-confirmed as published, likely a pandemic-era direct-certification artifact; treat the 2022 ED series with care.","valid_values":null,"example":0.25,"unit":"ratio","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"enrollment_ratio","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,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024],"schema_hash":"4107571cf6b78fdacc380e34603d38c4436725d9a07e8eb515db5ebf115ee367","tags":["education","governor's office of student achievement","enrollment_demographic_shares"],"granularity_description":"One row per year, district_code, school_code, demographic, met_ayp, improvement_status (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2024), schools detail","query":"SELECT * FROM enrollment_demographic_shares WHERE year = 2024 LIMIT 100"},{"description":"Economically disadvantaged share in 2024","query":"SELECT * FROM enrollment_demographic_shares WHERE demographic = 'economically_disadvantaged' AND year = 2024 LIMIT 100"},{"description":"AYP-era slice: met_ayp = 'yes' in 2010 (met_ayp / improvement_status are only populated 2004-2010)","query":"SELECT * FROM enrollment_demographic_shares WHERE met_ayp = 'yes' AND year = 2010 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":["asian_pacific_islander","black","economically_disadvantaged","english_learners","female","hispanic","male","migrant","multiracial","native_american","students_with_disabilities","white"]},{"param":"met_ayp","kind":"categorical","column":"met_ayp","type":"string","multi_value":true,"enum_enforced":true,"values":["no","yes"],"has_total":false,"total_value":null,"requires_single_value":true},{"param":"improvement_status","kind":"categorical","column":"improvement_status","type":"string","multi_value":true,"enum_enforced":true,"values":["adeq","adeq_dnm","dist","ni","ni_ayp"],"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":[]}