{"main_topic":"education","sub_topic":"georgiainsights","topic":"enrollment_march_gender_race_ethnicity","key":"education/georgiainsights/enrollment_march_gender_race_ethnicity","version":"1.0.0","year_min":2010,"year_max":2025,"year_gaps":[],"update_frequency":"annual","detail_levels":["districts","schools","states"],"default_detail":"schools","path_template":"education/enrollment_march_gender_race_ethnicity/year={year}/{detail}.parquet","grain":["year","district_code","school_code","race","gender"],"title":"March Enrollment by Race and Gender","summary":"Public school student headcounts by race/ethnicity and gender from the March FTE count, per school, district, and state, 2010-2025.","description":"Georgia Insights (GaDOE) FTE Enrollment by Race/Ethnicity and Gender — the March Cycle 3 FTE headcount of Georgia public school students, cross-classified by gender and by seven mutually exclusive race/ethnicity buckets (Hispanic, American Indian, Asian, Black, Pacific Islander, White, Two or more Races), for every school, district, and the state, fiscal years 2010-2025. This is the spring snapshot; the companion topic enrollment_october_gender_race_ethnicity reports the October Cycle 1 count. Source gender `Total` rows are dropped (redundant with Female + Male).","source":"Georgia Insights (GaDOE)","source_url":"https://georgiainsights.gadoe.org/data-downloads/","endpoint":"/api/v1/education/enrollment_march_gender_race_ethnicity","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Fiscal year of the March FTE count (2025 = March 2025, i.e. the 2024-2025 school year). Sourced from the bronze filename, cross-checked against each file's preamble.","valid_values":null,"example":2025,"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 code (zero-padded) for standard districts; 7-digit code for state charters. NULL for state-level rows. FK to districts dimension.","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, extracted from the bronze `School ID` (`NNNN-Name`) prefix. NULL for state- and district-level rows. FK to schools dimension (composite key with district_code).","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":"race","type":"string","role":"categorical","nullable":false,"label":"Race","short_description":"One of seven mutually exclusive race/ethnicity buckets; Hispanic is a separate bucket, not a race overlay.","description":"Race/ethnicity bucket (canonical race demographic keys, published as `race` because this topic is a race x gender cross-classification). Split Asian/Pacific Islander convention: `asian` and `pacific_islander` are separate buckets, never the combined rollup. `hispanic` is a non-overlapping ethnicity bucket — GaDOE FTE coding gives Hispanic ethnicity precedence over race, so a Hispanic student is counted ONLY under `hispanic` and the seven values partition total enrollment; do not treat `hispanic` as a Hispanic-of-any-race overlay.","valid_values":["asian","black","hispanic","multiracial","native_american","pacific_islander","white"],"example":"black","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"gender","type":"string","role":"categorical","nullable":false,"label":"Gender","short_description":"Student gender, female or male; the source's redundant Total rows are dropped.","description":"Student gender (`female` / `male`). The source's third value, `Total`, equals Female + Male on every fully published cell and is dropped during transform.","valid_values":["female","male"],"example":"female","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"num_students","type":"integer","role":"metric","nullable":true,"label":"Number Students","short_description":"FTE student headcount for the race x gender cell; NULL means suppressed (small cell), not zero.","description":"FTE student headcount for the (year, geography, race, gender) cell. Raw count, not scaled. NULL when suppressed in source; every non-null value is >= 15 (the observed suppression floor across all 32 bronze files). State-level cells are never suppressed.","valid_values":null,"example":309028,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Suppressed by GaDOE (bronze `*` marker) — small cells below the 15-student floor. Suppression is per race/ethnicity cell, not per row.","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"num_students","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":[2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025],"schema_hash":"ed137f9d5a165e37f018c7a89234153a59494127b5d164105adc5cf4ce6628f2","tags":["education","georgia insights","enrollment_march_gender_race_ethnicity"],"granularity_description":"One row per year, district_code, school_code, race, gender (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2025), schools detail","query":"SELECT * FROM enrollment_march_gender_race_ethnicity WHERE year = 2025 LIMIT 100"},{"description":"District 601 in 2025","query":"SELECT * FROM enrollment_march_gender_race_ethnicity WHERE district_code = '601' AND year = 2025 LIMIT 100"},{"description":"Filter by race = black","query":"SELECT * FROM enrollment_march_gender_race_ethnicity WHERE race = 'black' 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":"race","kind":"categorical","column":"race","type":"string","multi_value":true,"enum_enforced":true,"values":["asian","black","hispanic","multiracial","native_american","pacific_islander","white"],"has_total":false,"total_value":null,"requires_single_value":true},{"param":"gender","kind":"categorical","column":"gender","type":"string","multi_value":true,"enum_enforced":true,"values":["female","male"],"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":[]}