{"main_topic":"education","sub_topic":"gosa","topic":"dropout_rate_9_12","key":"education/gosa/dropout_rate_9_12","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/dropout_rate_9_12/year={year}/{detail}.parquet","grain":["year","district_code","school_code","demographic"],"title":"Grades 9-12 Dropout Rates","summary":"Georgia grade 9-12 dropout counts and rates by school, district, and demographic subgroup, 2011-2024.","description":"Number and rate of grade 9-12 dropouts for Georgia public schools, with official district and state rollups, by demographic subgroup (race/ethnicity, gender, economic status, English proficiency, migrant status, disability status). Published by GOSA for school years 2010-11 through 2023-24.","source":"GOSA","source_url":"https://gosa.georgia.gov/dashboards-data-report-card/downloadable-data","endpoint":"/api/v1/education/dropout_rate_9_12","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Ending (spring) calendar year of the school year (e.g. 2024 for 2023-24), parsed from the source's LONG_SCHOOL_YEAR and cross-checked against the filename.","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 county/city codes or 7-digit state-charter codes. NULL on state-level 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":"GOSA school code, zero-padded to 4 characters (composite FK to schools dimension with district_code; not globally unique on its own). NULL on district- and state-level rows.","valid_values":null,"example":"0105","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":"Student subgroup the row counts: 'all' plus race, gender, economic, English-proficiency, migrant, and disability categories; mutually exclusive within a category.","description":"Demographic subgroup (FK to the global demographics dimension). Race buckets use the combined asian_pacific_islander key (pre-1997 OMB convention): the source publishes a single 'Asian/Pacific Islander' label and its six race buckets sum exactly to the 'all' total at the state level in every year, so Pacific Islanders are folded in, never published separately. english_learners rows are absent in 2020-2022 (the source dropped the Limited English Proficient subgroup in those files). 'all' is the unfiltered total and overlaps every other value; subgroups are mutually exclusive only within their own category (race, gender, economic, special population).","valid_values":["all","asian_pacific_islander","black","economically_disadvantaged","english_learners","female","hispanic","male","migrant","multiracial","native_american","not_economically_disadvantaged","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":"num_dropouts","type":"integer","role":"metric","nullable":true,"label":"Number Dropouts","short_description":"","description":"Number of students in grades 9-12 who dropped out during the school year. Published values are always >= 10 because GOSA suppresses smaller cells; ~64-75% of school-level rows are suppressed (NULL) in every year. Always co-suppressed with dropout_rate.","valid_values":null,"example":27,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA (cell below the n=10 reporting threshold; blank cells in 2011-2020 sources, TFS literals in 2021-2024).","key_metric_grain_contributor":false,"metric_component":"numerator"},{"name":"dropout_rate","type":"number","role":"metric","nullable":true,"label":"Dropout Rate","short_description":"Share of grade 9-12 students who dropped out during the school year, on a 0-1 scale.","description":"Grade 9-12 dropout rate as a proportion (0-1 scale): dropouts divided by the subgroup's grade 9-12 enrollment. The source publishes 0-100 percentages with one decimal place (observed 0.2-93.6 across all years); divided by 100. Always co-suppressed with num_dropouts.","valid_values":null,"example":0.028,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA (cell below the n=10 reporting threshold; always co-suppressed with num_dropouts).","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"dropout_rate","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): GOSA suppresses any cell below the n=10 reporting threshold, which blanks ~64-75% of school-level rows in every year — school-level analyses should expect sparse coverage, and summing only published subgroup counts undercounts true totals at school grain (use district or state rows for official aggregates). State rows have NULL district_code and school_code; district rows have NULL school_code. The race axis uses the combined asian_pacific_islander bucket — not comparable row-for-row with split-convention topics without aggregating those topics' asian + pacific_islander rows at query time. english_learners rows are absent in 2020-2022.","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":"c579db0c0fb89ce1b3438bfe3381aa7ed0de2af6f694e1cd84aedf59c3122c16","tags":["education","gosa","dropout_rate_9_12"],"granularity_description":"One row per year, district_code, school_code, demographic (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2024), schools detail","query":"SELECT * FROM dropout_rate_9_12 WHERE year = 2024 LIMIT 100"},{"description":"District 601 in 2024","query":"SELECT * FROM dropout_rate_9_12 WHERE district_code = '601' 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":["all","asian_pacific_islander","black","economically_disadvantaged","english_learners","female","hispanic","male","migrant","multiracial","native_american","not_economically_disadvantaged","students_with_disabilities","students_without_disabilities","white"]},{"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":[]}