{"main_topic":"education","sub_topic":"georgiainsights","topic":"ccrpi_graduation_rate","key":"education/georgiainsights/ccrpi_graduation_rate","version":"1.0.0","year_min":2012,"year_max":2025,"year_gaps":[],"update_frequency":"annual","detail_levels":["districts","schools","states"],"default_detail":"schools","path_template":"education/ccrpi_graduation_rate/year={year}/{detail}.parquet","grain":["year","district_code","school_code","demographic","rate_type"],"title":"High School Graduation Rates","summary":"Georgia high school graduation rates by school, district, and demographic subgroup, 2012-2025.","description":"Georgia high school graduation rates at the school, district, and state level by demographic subgroup, 2012-2025. A single `graduation_rate` column (0-1 scale) carries three distinct methodologies discriminated by `rate_type`: the federal adjusted 4-year cohort rate (2012-2025), the 5-year cohort variant (2018-2024), and the Senate Bill 431 on-time rate (2021-2024, school-level only). `num_cohort` and `num_graduates` carry the published denominator/numerator where a source ships them; CCRPI accountability years add an improvement `indicator_target` and color `ccrpi_flag`. Sources span six release families (CCRPI workbooks, legacy 2012-2014 releases, standalone 4-year and 5-year cohort releases, SB 431 on-time releases, and a GOSA-portal CSV that fills the 2023 4-year count gap), merged by source precedence. This topic publishes the underlying graduation rates by methodology and demographic; the CCRPI Graduation Rate component score as it feeds the accountability index (a distinct benchmarked value, not equal to the raw 4-year rate) — alongside the overall CCRPI score and the other four component scores — lives in the `ccrpi_scoring_by_component` topic (the CCRPI overview).","source":"Georgia Insights (GaDOE) / GOSA","source_url":"https://georgiainsights.gadoe.org/data-downloads/","endpoint":"/api/v1/education/ccrpi_graduation_rate","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Graduation (cohort end) calendar year. For `4_year` rows, the spring the cohort was due to graduate; for `5_year` rows, the cohort's 4-year year + 1 had already passed (the rate is published one year later but keyed to the cohort year measured); for `on_time` rows, the SB 431 graduation year. Sourced from the bronze year column where one exists (CCRPI/legacy/on-time files; cross-checked against the filename) and from the filename for the standalone cohort releases. The February 2018 standalone release carries 2017-cohort data and lands in 2017.","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":"3-digit GOSA district code (zero-padded) for standard districts; 7-digit code for state-charter/state-school operators; the allowlisted pseudo-district code `RTC` (Residential Treatment Center aggregate, data years 2015-2018 only). NULL for state-level rows. FK to the 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 (zero-padded; later bronze years strip leading zeros). NULL for district- and state-level rows. FK to the 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":"demographic","type":"string","role":"fk_demographic","nullable":false,"label":"Demographic","short_description":"Student subgroup the row reports — race, gender, economic status, disability, and more; 'all' is the total.","description":"Canonical demographic code (FK to demographics dimension). 10 subgroups are reported across every era (all, asian_pacific_islander, black, hispanic, white, multiracial, native_american, economically_disadvantaged, english_learners, students_with_disabilities); 8 more (active_duty, female, male, foster_care, homeless, migrant, not_economically_disadvantaged, students_without_disabilities) appear ONLY in 2023 via the GOSA 4-year cohort CSV's wider breakdown. Race uses the combined `asian_pacific_islander` bucket — no source file publishes separate Asian or Pacific Islander rows. `American Indian/Alaskan [Native]` label drift folds to `native_american`; the GOSA CSV's `Limited English Proficient` folds to `english_learners`.","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":"black","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"rate_type","type":"string","role":"categorical","nullable":false,"label":"Rate Type","short_description":"Which graduation-rate methodology the row uses: 4-year cohort, 5-year cohort, or the SB 431 on-time rate.","description":"Graduation-rate methodology: `4_year` (federal adjusted 4-year cohort rate, 2012-2025), `5_year` (5-year cohort variant, 2018-2024), or `on_time` (SB 431 statutory measure — continuous enrollment from Oct 1 of 9th grade — 2021-2024, school-level rows only). Denominator semantics differ per type (see num_cohort).","valid_values":["4_year","5_year","on_time"],"example":"4_year","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"graduation_rate","type":"number","role":"metric","nullable":true,"label":"Graduation Rate","short_description":"Share of the cohort that graduated, on a 0-1 scale; which methodology applies is set by rate_type.","description":"Graduation rate on the 0-1 decimal scale (bronze ships 0-100; divided by 100). Interpretation follows rate_type. For overlapping 4-year keys the CCRPI accountability value wins by source precedence; standalone cohort releases fill years CCRPI does not cover, and ~200 small-cell 2023 keys carry the GOSA CSV rate that the CCRPI workbook suppressed. CAVEAT: the rate and the count pair can come from releases published at different cutoffs — do NOT assume num_graduates / num_cohort equals graduation_rate for `4_year` rows (it reconciles only to ~0.4pp even within one release). For `on_time` rows the identity holds to published rounding and is enforced as a quality check.","valid_values":null,"example":0.8544,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Suppressed by GaDOE/GOSA (`TFS`/`Too Few Students`, `No Data`, `No Data Found`) or not published for this key by any source.","key_metric_grain_contributor":false,"metric_component":null},{"name":"num_cohort","type":"integer","role":"metric","nullable":true,"label":"Number Cohort","short_description":"","description":"Published cohort denominator. For `4_year` rows: the federal adjusted cohort (first-time 9th graders four years prior, adjusted for transfers) from the standalone cohort releases — ALL-Students demographic only in 2015-2022/2024-2025, all 18 demographics in 2023 via the GOSA CSV. For `on_time` rows: `Total Enrolled` per SB 431 (continuous enrollment from Oct 1). Never published for `5_year` rows or the 2012-2014 legacy years.","valid_values":null,"example":134822,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Source published no denominator for this key: all 2012-2014 and `5_year` rows, non-`all` demographics in standalone 4-year years (counts ship for ALL Students only, except 2023's GOSA CSV), or suppressed (TFS).","key_metric_grain_contributor":false,"metric_component":"denominator"},{"name":"num_graduates","type":"integer","role":"metric","nullable":true,"label":"Number Graduates","short_description":"","description":"Published count of graduates (cohort numerator). Same source coverage as num_cohort. Never exceeds num_cohort (0 violations source-wide; enforced as a quality check). CAVEAT: published at a different cutoff than the CCRPI graduation_rate for 4-year rows — see graduation_rate.","valid_values":null,"example":113735,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Source published no numerator for this key (same coverage as num_cohort) or suppressed (TFS).","key_metric_grain_contributor":false,"metric_component":"numerator"},{"name":"indicator_target","type":"number","role":"metric","nullable":true,"label":"Indicator Target","short_description":"","description":"CCRPI improvement target on the same 0-1 scale as graduation_rate (observed range [0.022, 0.9]). Published for 4-year and 5-year rows in 2018-2019 and 2023-2025 releases: years 2018, 2019, 2023, 2024 carry both rate types, 2022 carries 5-year only (the 2023 workbook's prior-year slice; the 2022 release itself omitted the column), 2025 carries 4-year only (its 5-year slice lands in 2024). 2020 is all NULL (COVID CCRPI suspension). NOT cross-topic comparable: each CCRPI topic's target inherits its companion metric's scale (§16).","valid_values":null,"example":0.8454,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Row outside CCRPI flag-bearing coverage (see description), suppressed (`TFS`), or the 2020 COVID suspension (all `NA` at source).","key_metric_grain_contributor":false,"metric_component":null},{"name":"ccrpi_flag","type":"string","role":"categorical","nullable":true,"label":"CCRPI Flag","short_description":"CCRPI performance color (green/yellow/red) for whether the school met its graduation improvement target.","description":"CCRPI performance color flag: `green` (met the improvement target), `yellow` (improved but short of target), or `red` (did not improve); bronze G/Y/R recoded per §16. The graduation indicator never awards `green_star` in any bronze year (2018-2025, verified). Same publication coverage as indicator_target. A derived performance attribute functionally determined by the rest of the row key, so it is excluded from the contract grain.","valid_values":["green","red","yellow"],"example":"green","unit":null,"value_min":null,"value_max":null,"null_meaning":"Row outside CCRPI flag-bearing coverage (same years as indicator_target), bronze `NA` (no indicator_target to compare), or a non-CCRPI rate_type (`on_time`).","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":"Suppressed cells are NULL (not zero). 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":[2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025],"schema_hash":"cf373e5d8659c44afb7259a01d4ee2a163cca28d3b0665bc3675780b73b39e37","tags":["education","georgia insights","ccrpi_graduation_rate"],"granularity_description":"One row per year, district_code, school_code, demographic, rate_type (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2025), schools detail","query":"SELECT * FROM ccrpi_graduation_rate WHERE year = 2025 LIMIT 100"},{"description":"District 601 in 2025","query":"SELECT * FROM ccrpi_graduation_rate WHERE district_code = '601' AND year = 2025 LIMIT 100"},{"description":"Filter by rate_type = 4_year","query":"SELECT * FROM ccrpi_graduation_rate WHERE rate_type = '4_year' AND year = 2025 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":"rate_type","kind":"categorical","column":"rate_type","type":"string","multi_value":true,"enum_enforced":true,"values":["4_year","5_year","on_time"],"has_total":false,"total_value":null,"requires_single_value":true},{"param":"ccrpi_flag","kind":"categorical","column":"ccrpi_flag","type":"string","multi_value":true,"enum_enforced":true,"values":["green","red","yellow"],"has_total":false,"total_value":null,"requires_single_value":false},{"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":[]}