{"main_topic":"education","sub_topic":"gosa","topic":"enrollment_by_grade_level","key":"education/gosa/enrollment_by_grade_level","version":"1.0.0","year_min":2011,"year_max":2024,"year_gaps":[],"update_frequency":"annual","detail_levels":["districts","schools","states"],"default_detail":"schools","path_template":"education/enrollment_by_grade_level/year={year}/{detail}.parquet","grain":["year","district_code","school_code","enrollment_period","grade_level"],"title":"Enrollment by Grade Level","summary":"Student enrollment counts by grade (K-12) for each Georgia school, district, and the state, per Fall/Spring snapshot, 2011-2024.","description":"Student enrollment counts by grade level for every Georgia public school, school district, and the state, published by GOSA for school years 2010-11 through 2023-24. Each row is the total number of students enrolled in one grade (K through 12) at one entity in one enrollment-snapshot period — GaDOE counts enrollment twice per school year (Fall and Spring collection cycles), and both snapshots are preserved as distinct rows. There is no demographic breakdown: every row is a total count for its (year, geography, period, grade) cell.","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_by_grade_level","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Ending calendar year of the school year (2024 = 2023-24). Parsed from the bronze LONG_SCHOOL_YEAR and cross-checked against the filename year.","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-character zero-padded code for standard county/city districts, or 7-character code for state-charter (782 prefix), commission-charter (783 prefix), and state school (799 prefix) entities — 7-character codes appear in every year 2011-2024. NULL on state-level aggregate rows (bronze sentinel 'ALL').","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-character zero-padded GOSA school code (composite FK to schools dimension with district_code; school codes are not globally unique on their own). NULL on district- and state-level aggregate rows (bronze sentinel 'ALL').","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' (October collection) or 'spring' (March collection). 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 of the students counted: 'k' for kindergarten, '01'-'12' for grades 1-12; no pre-K or all-grades row.","description":"Grade level of the students counted: 'k' for kindergarten, '01' through '12' for grades 1-12 (canonical zero-padded codes per the shared grade vocabulary). This source publishes no pre-K row and no cross-grade aggregate row, so 'pk' and 'all' never appear. Bronze spellings were K and 1st..12th.","valid_values":["01","02","03","04","05","06","07","08","09","10","11","12","k"],"example":"03","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":"Number of students enrolled in this grade and period at this entity.","description":"Number of students enrolled in this grade and period at this entity. Three source regimes govern 0 vs NULL: (1) 2011-2020 — no suppression; an explicit 0 is a true zero (grade not served) and is preserved; (2) 2021-2022 — the source replaces both true zeros and counts 1-9 with 'TFS' (Too Few Students), stored as NULL here; (3) 2023-2024 — TFS suppression continues AND rows for non-applicable grade x entity combinations are no longer emitted, roughly halving the row count per year.","valid_values":null,"example":80,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Varies by year: never NULL in 2011-2020 (zeros are real and preserved); in 2021-2022 NULL is a TFS suppression that conflates true zeros with counts 1-9; in 2023-2024 NULL means a suppressed <10 cell (and non-applicable grade x entity cells are absent rows, not NULLs).","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. State and district rows are independently published GOSA aggregates and may differ from the sum of their component rows by up to ~0.02% (e.g., students enrolled in more than one district during a collection period); do not treat component sums as exact reconciliations.","null_semantics":{"suppressed_to_null":true,"zero_is_real":true},"available_years":[2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024],"schema_hash":"0a3f9211501ce48472feaa33d39f66a4b455fa176383ce0fc966e4da86e19b6b","tags":["education","governor's office of student achievement","enrollment_by_grade_level"],"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 (2024), schools detail","query":"SELECT * FROM enrollment_by_grade_level WHERE year = 2024 LIMIT 100"},{"description":"District 601 in 2024","query":"SELECT * FROM enrollment_by_grade_level WHERE district_code = '601' AND year = 2024 LIMIT 100"},{"description":"Filter by enrollment_period = fall","query":"SELECT * FROM enrollment_by_grade_level WHERE enrollment_period = 'fall' 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"}],"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},{"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","k"],"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":[]}