{"main_topic":"education","sub_topic":"georgiainsights","topic":"enrollment_by_grade","key":"education/georgiainsights/enrollment_by_grade","version":"1.1.0","year_min":2010,"year_max":2026,"year_gaps":[],"update_frequency":"annual","detail_levels":["districts","schools","states"],"default_detail":"schools","path_template":"education/enrollment_by_grade/year={year}/{detail}.parquet","grain":["year","district_code","school_code","enrollment_period","grade_level"],"title":"Enrollment by Grade Level (Fall and Spring)","summary":"Public school student headcounts by grade level (PK-12) from the October (fall) and March (spring) FTE counts, per school, district, and state, 2010-2026.","description":"Georgia Insights (GaDOE) FTE Enrollment by Grade Level(PK-12) — the FTE headcount of Georgia public school students broken out by grade level (pre-kindergarten, kindergarten, grades 1-12, plus an 'all' total row) for every school, district, and the state. GaDOE counts enrollment twice per school year: the October Cycle 1 (fall) snapshot and the March Cycle 3 (spring) snapshot; both are preserved as distinct rows via the enrollment_period column. The fall half spans fiscal years 2010-2026 and the spring half 2010-2025. Grade is the row axis and lives in grade_level — there are no demographic breakouts in this topic.","source":"Georgia Insights (GaDOE)","source_url":"https://georgiainsights.gadoe.org/data-downloads/","endpoint":"/api/v1/education/enrollment_by_grade","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Fiscal year of the FTE count (school year ending in this year; e.g. 2026 = the 2025-2026 school year). Sourced from the bronze filename, cross-checked against each file's preamble. The spring (March) snapshot is present through 2025; the fall (October) snapshot through 2026.","valid_values":null,"example":2026,"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 and specialty schools, including the pseudo-districts 7991893/7991894/7991895 for the three state schools (reported under district 799 in other years). 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 Name` (`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":"enrollment_period","type":"string","role":"categorical","nullable":false,"label":"Enrollment Period","short_description":"Enrollment snapshot within the school year: fall (October) or spring (March); never sum across them.","description":"Enrollment-count snapshot within the school year: 'fall' (GaDOE October Cycle 1 count, first Tuesday of October) or 'spring' (March Cycle 3 count, third Tuesday of March). Both snapshots exist for nearly every entity — queries wanting one headline count per year must filter to a single period, never sum across them.","valid_values":["fall","spring"],"example":"fall","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: `pk`, `k`, `01`-`12`, or `all` for the entity total (sum of the 14 grade rows).","description":"Canonical grade code per data-cleaning-standards section 16: 'pk' (pre-kindergarten), 'k' (kindergarten), zero-padded '01'..'12', and 'all' for the entity's pre-aggregated total row (the bronze `Total` column, which equals the sum of the 14 grade rows bit-exact).","valid_values":["01","02","03","04","05","06","07","08","09","10","11","12","all","k","pk"],"example":"01","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":false,"label":"Number Students","short_description":"FTE student headcount for the grade cell; never suppressed, so a 0 means the grade is not offered.","description":"FTE student headcount for the (year, geography, period, grade) cell. Raw count, not scaled. Never NULL — this source publishes no suppression markers — and a 0 is a real reported value (the grade is not offered at the entity). For grade_level='all', equals the sum of the entity's 14 grade rows in that period.","valid_values":null,"example":247,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"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":"This source has no suppression; a 0 is a real reported value. State rows have NULL district_code and school_code. District rows have NULL school_code.","null_semantics":{"suppressed_to_null":false,"zero_is_real":true},"available_years":[2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026],"schema_hash":"78fcbea4c8f1e76a69318a2e5fa50e3cfbecd810b2122e50c025fe4a36f267fe","tags":["education","georgia insights","enrollment_by_grade"],"granularity_description":"One row per year, district_code, school_code, enrollment_period, grade_level (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2026), schools detail","query":"SELECT * FROM enrollment_by_grade WHERE year = 2026 LIMIT 100"},{"description":"District 601 in 2026","query":"SELECT * FROM enrollment_by_grade WHERE district_code = '601' AND year = 2026 LIMIT 100"},{"description":"Filter by enrollment_period = fall","query":"SELECT * FROM enrollment_by_grade WHERE enrollment_period = 'fall' AND year = 2026 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":"enrollment_period","kind":"categorical","column":"enrollment_period","type":"string","multi_value":true,"enum_enforced":true,"values":["fall","spring"],"has_total":false,"total_value":null,"requires_single_value":true,"nullable":false,"null_filter_token":null},{"param":"grade_level","kind":"categorical","column":"grade_level","type":"string","multi_value":true,"enum_enforced":true,"values":["01","02","03","04","05","06","07","08","09","10","11","12","all","k","pk"],"has_total":true,"total_value":"all","requires_single_value":false,"nullable":false,"null_filter_token":null},{"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":"school_level","kind":"dimension_attribute","dimension":"schools","column":"school_level","type":"string","multi_value":true,"enum_enforced":true,"values":["elementary","middle","high","k12","other"]},{"param":"locale","kind":"dimension_attribute","dimension":"schools","column":"locale","type":"string","multi_value":true,"enum_enforced":true,"values":["city","suburb","town","rural"]}],"filter_hints":[],"values_endpoint":"/api/v1/education/enrollment_by_grade/values"}