{"main_topic":"education","sub_topic":"gosa","topic":"high_school_completers","key":"education/gosa/high_school_completers","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/high_school_completers/year={year}/{detail}.parquet","grain":["year","district_code","school_code","demographic","completer_type","credential_type"],"title":"High School Completers","summary":"Counts of Georgia high school completers by diploma or certificate type, by school, district, and state and demographic subgroup, 2011-2024.","description":"Number of Georgia public high-school completers by credential type (General Education Diplomas, Diplomas with College Prep Endorsements, Diplomas with Vocational Endorsements, Diplomas with Both College Prep and Vocational Endorsements, Special Education Diplomas, Certificates of Attendance) and completer type (graduates vs. other completers), broken out by 9 demographic subgroups (gender, race/ethnicity, and the all-students total), with each demographic's share of the credential's completers. School, district, and state levels, school years 2010-11 through 2023-24, published by GOSA.","source":"GOSA","source_url":"https://gosa.georgia.gov/dashboards-data-report-card/downloadable-data","endpoint":"/api/v1/education/high_school_completers","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). The 2011, 2018, 2019, and 2020 source files mix 3- and 4-character codes; the transform normalizes all years to 4 characters. NULL on district- and state-level rows.","valid_values":null,"example":"0390","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":"Demographic subgroup: all students, gender, or one of six race/ethnicity buckets (Asian is combined Asian/Pacific Islander).","description":"Demographic subgroup (FK to the global demographics dimension): the all-students total, gender (male, female), and six race/ethnicity buckets. Race uses the combined asian_pacific_islander key (pre-1997 OMB convention): the source publishes a bare 'Asian' label with no separate Pacific Islander row, and the six race buckets sum exactly to the Total in every fully published group, so Pacific Islanders are folded in, never dropped. 'all' is the unfiltered total and overlaps every other value; subgroups are mutually exclusive only within their own category (race, gender).","valid_values":["all","asian_pacific_islander","black","female","hispanic","male","multiracial","native_american","white"],"example":"all","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"completer_type","type":"string","role":"categorical","nullable":false,"label":"Completer Type","short_description":"High-level cohort: graduates (the four diploma credentials) vs. other_completers (special-ed diplomas and certificates of attendance).","description":"High-level completer cohort: 'graduates' covers the four diploma credentials (general education, college prep, vocational, both); 'other_completers' covers Special Education Diplomas and Certificates of Attendance (students who did not meet the full diploma course/assessment criteria). Functionally determined by credential_type (each credential belongs to exactly one completer_type; enforced by a quality check). NOT the denominator of pct_of_credential_type — that metric's denominator is the single credential's total.","valid_values":["graduates","other_completers"],"example":"graduates","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"credential_type","type":"string","role":"categorical","nullable":false,"label":"Credential Type","short_description":"Specific credential earned: general-education, college-prep, vocational, or both diplomas, special-ed diplomas, or certificates of attendance.","description":"Specific credential earned. Six values from 2012 onward; the 2010-11 school year (year=2011) predates 'general_education_diplomas' and carries only the other five. From 2012 onward Georgia phased out endorsement diplomas, so general_education_diplomas dominates Graduates counts in later years.","valid_values":["certificates_of_attendance","diplomas_college_prep","diplomas_college_prep_and_vocational","diplomas_vocational","general_education_diplomas","special_education_diplomas"],"example":"general_education_diplomas","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"num_completers","type":"integer","role":"metric","nullable":true,"label":"Number Completers","short_description":"Number of completers in this demographic who earned this credential during the school year; NULL means GOSA suppressed a small cell, not zero.","description":"Number of completers in this demographic who earned this credential during the school year at this school/district/state. Literal 0 is a real published value (appears only in 2012-2017 and 2021-2022); NULL is suppression. In 2023-2024 every published count is >= 10; earlier years publish smaller values.","valid_values":null,"example":114359,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA (small cell). Blank cells in the 2011-2021 sources and/or 'TFS' (Too Few Students) literals in 2011, 2018-2020, and 2022-2024 — all become NULL.","key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_of_credential_type","type":"number","role":"metric","nullable":true,"label":"Percent of Credential Type","short_description":"","description":"Share of the credential's completers who belong to this demographic — a demographic-within-credential share on the 0-1 scale (source publishes 0-100 with one decimal; divided by 100). The denominator is the credential's own demographic='all' total at the same geography, NOT the completer_type cohort total: rows with demographic='all' are always exactly 1.0 where published, gender pairs sum to ~1, and the six race buckets sum to ~1 within a credential (all pinned as quality checks). Credentials do NOT sum to 1 within a completer_type.","valid_values":null,"example":0.488,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA. In 2011, 2018-2020, and 2023-2024 the source publishes this share for some rows whose num_completers is suppressed, so it can be non-NULL while num_completers is NULL — never the reverse.","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"num_completers","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 small cells, blanking ~65-90% of num_completers values depending on the year (suppression tightened over time), and even some state-level cells (e.g. the phased-out endorsement-diploma credentials in recent years) — school-level analyses should expect sparse coverage, and summing only published subgroup counts undercounts true totals. pct_of_credential_type is a demographic composition share (demographic within credential), not a credential-mix share — do not sum it across credentials. 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. year=2011 lacks the general_education_diplomas credential (it did not exist yet).","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":"eaad9877ebafbad56cb0001268d4a0ef14cea222bcc9270c439aae86f6ecc975","tags":["education","gosa","high_school_completers"],"granularity_description":"One row per year, district_code, school_code, demographic, completer_type, credential_type (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2024), schools detail","query":"SELECT * FROM high_school_completers WHERE year = 2024 LIMIT 100"},{"description":"District 601 in 2024","query":"SELECT * FROM high_school_completers WHERE district_code = '601' AND year = 2024 LIMIT 100"},{"description":"Filter by completer_type = graduates","query":"SELECT * FROM high_school_completers WHERE completer_type = 'graduates' 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","female","hispanic","male","multiracial","native_american","white"]},{"param":"completer_type","kind":"categorical","column":"completer_type","type":"string","multi_value":true,"enum_enforced":true,"values":["graduates","other_completers"],"has_total":false,"total_value":null,"requires_single_value":true},{"param":"credential_type","kind":"categorical","column":"credential_type","type":"string","multi_value":true,"enum_enforced":true,"values":["certificates_of_attendance","diplomas_college_prep","diplomas_college_prep_and_vocational","diplomas_vocational","general_education_diplomas","special_education_diplomas"],"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":[]}