{"main_topic":"education","sub_topic":"gosa","topic":"graduation_rate_4_year_cohort","key":"education/gosa/graduation_rate_4_year_cohort","version":"1.0.0","year_min":2004,"year_max":2024,"year_gaps":[],"update_frequency":"annual","detail_levels":["districts","schools","states"],"default_detail":"schools","path_template":"education/graduation_rate_4_year_cohort/year={year}/{detail}.parquet","grain":["year","district_code","school_code","demographic"],"title":"Four-Year Cohort Graduation Rate","summary":"Share of the four-year high school cohort that graduated, by school, district, and state and demographic subgroup, 2004-2024.","description":"Four-year high-school graduation rate for Georgia public schools, with official district and state rollups, by demographic subgroup (race/ethnicity, gender, disability status, English proficiency, economic status, and special populations). Reports the graduation rate, the number of graduates, and the cohort size. Published by GOSA for school years 2003-04 through 2023-24. 2011 onward is the federal four-year adjusted-cohort graduation rate (ACGR); 2004-2010 predate Georgia's ACGR adoption and use the state's earlier leaver-based methodology — the two halves are not trend-comparable (see limitations). This is the long historical 4-year series with demographic breakdowns; the sibling ccrpi_graduation_rate topic carries the GaDOE CCRPI release (2012 onward, 4- and 5-year rates with CCRPI target/flag context).","source":"Governor's Office of Student Achievement (GOSA)","source_url":"https://gosa.georgia.gov/dashboards-data-report-card/downloadable-data","endpoint":"/api/v1/education/graduation_rate_4_year_cohort","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Ending (spring) calendar year of the cohort's graduating school year (2024 = the 2023-24 cohort). Parsed from the source's LONG_SCHOOL_YEAR and cross-checked against the filename for 2011-2024; from the filename for 2004-2010 (no year column in those eras).","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. Code 799 is the state-school virtual district ('State Schools'), published as a district-level aggregate in 2004-2010. 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":"0103","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 reports (race/ethnicity, gender, disability, economic status, special population); 'all' is the total.","description":"Demographic subgroup (FK to the global demographics dimension). Race buckets use the combined asian_pacific_islander key (pre-1997 OMB convention) in every year: 2011+ bronze publishes the explicit 'Asian/Pacific Islander' label, and the bare 'Asian' label of 2004-2010 is the same combined bucket — the six race-bucket counts sum exactly to the All Students totals at the state level in every year, so Pacific Islanders are folded in, never published separately. 2004-2017 publish 15 subgroups; active_duty, foster_care, and homeless appear from 2018; english_learners is absent in 2021 only. 'all' is the unfiltered total and overlaps every other value; subgroups are mutually exclusive only within their own category (race, gender, disability, economic, special population).","valid_values":["active_duty","all","asian_pacific_islander","black","economically_disadvantaged","english_learners","female","foster_care","hispanic","homeless","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_graduates","type":"integer","role":"metric","nullable":true,"label":"Number Graduates","short_description":"","description":"Number of students in the subgroup's cohort who graduated with a regular diploma within four years of first entering 9th grade (from 2011 the federal adjusted-cohort numerator; 2004-2010 use the state's earlier leaver-based accounting). Published values are >= 10 from 2011 onward (GOSA's n=10 reporting threshold). 2004-2009 use literal zeros for suppressed cells — a zero in those years may be real or suppressed and the two cannot be distinguished in source. The three non-suppressed 2010 migrant rows are internally inconsistent in bronze (num_graduates = num_cohort yet graduation_rate != 1.0; graduation_rate is the authoritative figure) and are preserved as published.","valid_values":null,"example":225,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA ('Too few Students' literals in 2010, blank cells 2011-2020, TFS literals 2021-2024). 2004-2009 have no suppression NULLs — those sources publish literal zeros instead. Always co-suppressed with graduation_rate.","key_metric_grain_contributor":false,"metric_component":"numerator"},{"name":"num_cohort","type":"integer","role":"metric","nullable":true,"label":"Number Cohort","short_description":"","description":"Cohort size — the denominator of the graduation rate. From 2011 this is the federal adjusted four-year cohort (first-time 9th-graders four years prior, plus transfers in, minus transfers out); the 2004-2010 denominator is the source's 'Approximate Class Size' (pre-ACGR leaver-based methodology). NULL for ALL rows in 2012-2016 (the source does not publish TOTAL_COUNT in those years; consumers may estimate round(num_graduates / graduation_rate) at their own rounding risk). In 2023-2024 some rows — mostly school-level (295 school / 74 district in 2023, 271 / 68 in 2024) — publish num_cohort while num_graduates and graduation_rate are suppressed (partial suppression). Published values are >= 10 from 2011 onward. 2004-2009 zeros may be real or suppressed (see num_graduates).","valid_values":null,"example":240,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA, or unpublished: the source has no cohort denominator at all for 2012-2016.","key_metric_grain_contributor":false,"metric_component":"denominator"},{"name":"graduation_rate","type":"number","role":"metric","nullable":true,"label":"Graduation Rate","short_description":"Share of the four-year cohort that graduated, on a 0-1 scale; 2011+ is the federal ACGR, 2004-2010 a non-comparable older method.","description":"Four-year graduation rate as a proportion (0-1 scale): num_graduates divided by num_cohort. From 2011 this is the federal adjusted-cohort rate (ACGR); 2004-2010 use Georgia's earlier leaver-based methodology and are NOT trend-comparable with 2011+ (state rate breaks 0.808 -> 0.675 at the 2010->2011 boundary). The source publishes 0-100 percentages (1-2 decimal places); divided by 100. Reconciles with num_graduates / num_cohort within 0.001 everywhere except the three documented 2010 migrant defect rows. Zeros in 2004-2009 may be real or suppressed (see num_graduates).","valid_values":null,"example":0.9375,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Suppressed by GOSA ('Too few Students' literals in 2010, blank cells 2011-2020, TFS literals 2021-2024). 2004-2009 have no suppression NULLs — those sources publish literal zeros instead. Always co-suppressed with num_graduates.","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"graduation_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":"2004-2010 figures predate Georgia's adoption of the federal four-year adjusted-cohort methodology (ACGR, first reported 2011) and use the state's earlier leaver-based rate; the 2010->2011 state rate drop (~81% to ~67%) is a methodology break, not a real decline — do not trend across it. Suppressed cells are NULL (not zero) from 2010 onward, but 2004-2009 sources use literal ZEROS for suppressed cells — a zero rate/count in those years may be real or suppressed and cannot be distinguished; treat very small cohorts in 2004-2009 with caution. num_cohort is NULL for every row in 2012-2016 (the source publishes no denominator in those years). School rows do not always sum to the published district row (49 of ~3,850 district-years publish a district num_graduates below the visible school sum, source-published, e.g. 2016 Whitfield 709 vs 810) — use the official district/state rows for rollups rather than summing school rows. 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. 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":[2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024],"schema_hash":"d58fde7781dfaec406fb52e58bc8fafc339d6eaac0cb222f1d580e3a1010e568","tags":["education","governor's office of student achievement","graduation_rate_4_year_cohort"],"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 graduation_rate_4_year_cohort WHERE year = 2024 LIMIT 100"},{"description":"District 601 in 2024","query":"SELECT * FROM graduation_rate_4_year_cohort 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":["active_duty","all","asian_pacific_islander","black","economically_disadvantaged","english_learners","female","foster_care","hispanic","homeless","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":[]}