{"main_topic":"education","sub_topic":"georgiainsights","topic":"ccrpi_scoring_by_component","key":"education/georgiainsights/ccrpi_scoring_by_component","version":"1.0.0","year_min":2012,"year_max":2025,"year_gaps":[2020,2021],"update_frequency":"annual","detail_levels":["districts","schools","states"],"default_detail":"schools","path_template":"education/ccrpi_scoring_by_component/year={year}/{detail}.parquet","grain":["year","district_code","school_code","grade_cluster"],"title":"CCRPI Scores and Components","summary":"Georgia's overall CCRPI accountability score plus its component scores, by school, district, and state and grade cluster, 2012-2025.","description":"Components of Georgia's College and Career Ready Performance Index (CCRPI) accountability score at the school, district, and state level by grade cluster (elementary / middle / high), 2012-2025 (no 2020-2021 — COVID pause). The metric set evolves across four source eras: 2012-2017 publish CCRPI component POINTS on per-component scales (achievement, progress, achievement gap, ED/EL/SWD performance, ETB and challenge bonus points); 2018+ publish five component SCORES on a 0-100 scale (content mastery, progress, closing gaps, readiness, graduation rate). The aggregated ccrpi_score and ccrpi_single_score accompany 2012-2019 (suppressed for 2022, dropped at source from 2023). Points-era and score-era metrics are different measurements on different scales — each column is populated only in its source era and the two families are NOT comparable. No demographic breakdown. This is the CCRPI OVERVIEW / SCORECARD topic — the most important CCRPI entry point and the only single-query view of a school's accountability picture: the SOLE source of the overall ccrpi_single_score and the per-cluster ccrpi_score, the only topic presenting all five component scores side by side, and the only home of the 2012-2017 points-era breakdown. It differs from the per-component topics (ccrpi_content_mastery, ccrpi_progress, ccrpi_readiness, ccrpi_graduation_rate) by being WIDE and SHALLOW — one rolled-up score per component at the all-student / grade-cluster grain, with no demographic, subject, indicator, or sub-indicator axis. Those topics are the complementary NARROW and DEEP view, each drilling a single component down by demographic and sub-measure but publishing neither the overall score nor the cross-component scorecard. Use this topic for the headline score and the component scorecard; use a component topic for within-component detail.","source":"Georgia Insights (GaDOE)","source_url":"https://georgiainsights.gadoe.org/data-downloads/","endpoint":"/api/v1/education/ccrpi_scoring_by_component","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Ending calendar year of the school year (e.g., 2024 = 2023-2024). 2020 and 2021 are absent: Georgia paused CCRPI calculation during the COVID pandemic. Verified against each file's in-file School Year column.","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, 2015-2017 only, district-level rows). 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; 2017 and 2024 bronze ship un-padded values that zfill repairs). 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":"grade_cluster","type":"string","role":"categorical","nullable":false,"label":"Grade Cluster","short_description":"Grade band the row covers: elementary, middle, or high (a K-12 school appears in up to three rows per year).","description":"CCRPI grade cluster: `elementary`, `middle`, or `high` (bronze single letters E/M/H recoded). Every entity is reported once per cluster it serves; a K-12 school appears in up to three rows per year.","valid_values":["elementary","high","middle"],"example":"elementary","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"achievement_points","type":"number","role":"metric","nullable":true,"label":"Achievement Points","short_description":"","description":"CCRPI Achievement points (points era 2012-2017 only; observed range 2.6-59.9, max ~60 by design). NULL for all 2018+ rows. Co-null with etb_points and challenge_points on every points-era row (enforced as a quality check).","valid_values":null,"example":45.3,"unit":"score","value_min":null,"value_max":null,"null_meaning":"Suppressed at source (`NA`), or a score-era row (2018+) where this points metric no longer exists.","key_metric_grain_contributor":false,"metric_component":null},{"name":"progress_points","type":"number","role":"metric","nullable":true,"label":"Progress Points","short_description":"","description":"CCRPI Progress points (points era 2012-2017 only). CAVEAT: the Progress component was redesigned for 2015 — max ~22 in 2012-2014 vs max 40 in 2015-2017 — under the same bronze column; values are preserved verbatim, so period-over-period comparisons must stay within one sub-era. NULL for all 2018+ rows.","valid_values":null,"example":17.3,"unit":"score","value_min":null,"value_max":null,"null_meaning":"Suppressed at source (`NA`) or true-null (entities without measurable progress, e.g. new schools), or a score-era row (2018+).","key_metric_grain_contributor":false,"metric_component":null},{"name":"achievement_gap_points","type":"number","role":"metric","nullable":true,"label":"Achievement Gap Points","short_description":"","description":"CCRPI Achievement Gap points (points era 2012-2017 only). Cap changed mid-era: max 15 in 2012-2014, max 10 in 2015-2017 (verified per year in bronze). NULL for all 2018+ rows.","valid_values":null,"example":11.3,"unit":"score","value_min":null,"value_max":null,"null_meaning":"Suppressed at source (`NA`) or true-null, or a score-era row (2018+).","key_metric_grain_contributor":false,"metric_component":null},{"name":"ed_el_swd_performance","type":"number","role":"metric","nullable":true,"label":"Ed EL Swd Performance","short_description":"","description":"Economically Disadvantaged / English Learner / Students With Disabilities subgroup performance points (points era 2012-2017 only; range 0-10). The points-era predecessor of the score-era closing_gaps subgroup component — measured on a different scale and NOT comparable to it. NULL for all 2018+ rows.","valid_values":null,"example":3.5,"unit":"score","value_min":null,"value_max":null,"null_meaning":"Suppressed at source (`NA`) or true-null (2013 ships 82 blank cells), or a score-era row (2018+).","key_metric_grain_contributor":false,"metric_component":null},{"name":"etb_points","type":"number","role":"metric","nullable":true,"label":"Etb Points","short_description":"","description":"Exceeding the Bar bonus points (points era 2012-2017 only). Cap drifts by framework: max 2.0 in 2012-2013, 3.0 in 2014, 2.5 in 2015-2017. NULL for all 2018+ rows.","valid_values":null,"example":1.0,"unit":"score","value_min":null,"value_max":null,"null_meaning":"Suppressed at source (`NA`), or a score-era row (2018+).","key_metric_grain_contributor":false,"metric_component":null},{"name":"challenge_points","type":"number","role":"metric","nullable":true,"label":"Challenge Points","short_description":"","description":"Challenge bonus points (points era 2012-2017 only; range 0-10): the bonus bucket added on top of the three base components, predominantly ED/EL/SWD performance + ETB points. Participates in the exact identity achievement_points + progress_points + achievement_gap_points + challenge_points = ccrpi_score (0 violations source-wide; enforced as a quality check). NULL for all 2018+ rows.","valid_values":null,"example":3.5,"unit":"score","value_min":null,"value_max":null,"null_meaning":"Suppressed at source (`NA`), or a score-era row (2018+).","key_metric_grain_contributor":false,"metric_component":null},{"name":"content_mastery","type":"number","role":"metric","nullable":true,"label":"Content Mastery","short_description":"","description":"CCRPI Content Mastery component score, 0-100 scale (score columns are exempt from the 0-1 percentage convention; components are capped at 100 by GaDOE rules — verified [0, 100] in every year). Score era (2018+) only; NULL for all 2012-2017 rows.","valid_values":null,"example":68.4,"unit":"score","value_min":0,"value_max":100,"null_meaning":"Suppressed at source (`NA`, `TFS`, `Too Few Students`), or a points-era row (2012-2017).","key_metric_grain_contributor":false,"metric_component":null},{"name":"progress","type":"number","role":"metric","nullable":true,"label":"Progress","short_description":"","description":"CCRPI Progress component score, 0-100 scale. Score era (2018+) only; NULL for all 2012-2017 rows and 100% NULL in 2022 (federally-approved one-year COVID modification suspended the component; bronze ships blanket `NA`).","valid_values":null,"example":72.5,"unit":"score","value_min":0,"value_max":100,"null_meaning":"Suppressed at source (`NA`, `TFS`), the 2022 component-wide COVID suspension, or a points-era row (2012-2017).","key_metric_grain_contributor":false,"metric_component":null},{"name":"closing_gaps","type":"number","role":"metric","nullable":true,"label":"Closing Gaps","short_description":"","description":"CCRPI Closing Gaps component score, 0-100 scale — the score-era successor of the points-era ed_el_swd_performance subgroup metric (different scale, not comparable). Score era (2018+) only; NULL for all 2012-2017 rows and 100% NULL in 2022 (COVID modification).","valid_values":null,"example":54.1,"unit":"score","value_min":0,"value_max":100,"null_meaning":"Suppressed at source (literal `NA` markers — 196/228/207 cells in 2023/2024/2025, zero blank cells), the 2022 component-wide COVID suspension, or a points-era row (2012-2017).","key_metric_grain_contributor":false,"metric_component":null},{"name":"readiness","type":"number","role":"metric","nullable":true,"label":"Readiness","short_description":"","description":"CCRPI Readiness component score, 0-100 scale. Score era (2018+) only; NULL for all 2012-2017 rows. The only score component published for every cluster in 2022.","valid_values":null,"example":77.0,"unit":"score","value_min":0,"value_max":100,"null_meaning":"Suppressed at source (`NA`, `TFS`, `Too Few Students`), or a points-era row (2012-2017).","key_metric_grain_contributor":false,"metric_component":null},{"name":"graduation_rate","type":"number","role":"metric","nullable":true,"label":"Graduation Rate","short_description":"","description":"CCRPI Graduation Rate component on the 0-1 decimal scale (bronze ships 0-100; divided by 100 per the rate-column standard — the only rescaled column in this topic). Score era (2018+) only, and non-NULL exclusively on `high` grade-cluster rows in every year (verified; enforced as a quality check).","valid_values":null,"example":0.813,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Not a high-cluster row (elementary / middle have no graduation rate), suppressed at source (`NA`, `TFS`, `Too Few Students`), or a points-era row (2012-2017).","key_metric_grain_contributor":false,"metric_component":null},{"name":"ccrpi_score","type":"number","role":"metric","nullable":true,"label":"CCRPI Score","short_description":"","description":"Aggregated per-cluster CCRPI score on a 0-100 scale. Legitimately exceeds 100 in the points era via ETB / Challenge bonus points (observed max 110.3 in 2016; by design, not capped — hence no contract bounds). In the points era it equals achievement_points + progress_points + achievement_gap_points + challenge_points exactly (quality-checked). Published 2012-2019; 100% NULL for 2022 (COVID modification) and 2023+ (column dropped at source).","valid_values":null,"example":74.2,"unit":"score","value_min":null,"value_max":null,"null_meaning":"Suppressed at source (`NA`), the 2022 COVID suppression, or a 2023+ row where the source dropped the column.","key_metric_grain_contributor":false,"metric_component":null},{"name":"ccrpi_single_score","type":"number","role":"metric","nullable":true,"label":"CCRPI Single Score","short_description":"The entity's overall CCRPI accountability score on a 0-100 scale; published 2012-2019, NULL from 2022 on.","description":"Single (overall) CCRPI score of the entity — the cross-cluster rollup, so an entity spanning multiple clusters repeats one value across its rows while ccrpi_score varies per cluster. 0-100 scale with points-era bonus overshoot (observed max 110.3 in 2016). Published 2012-2019; 100% NULL for 2022 and 2023+ (same coverage as ccrpi_score).","valid_values":null,"example":74.2,"unit":"score","value_min":null,"value_max":null,"null_meaning":"Suppressed at source (`NA`), the 2022 COVID suppression, or a 2023+ row where the source dropped the column.","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"ccrpi_single_score","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.","null_semantics":{"suppressed_to_null":true,"zero_is_real":true},"available_years":[2012,2013,2014,2015,2016,2017,2018,2019,2022,2023,2024,2025],"schema_hash":"f645754de4375353548b0277aa3d05a986ea906620d6d72ded655ddfe07739f0","tags":["education","georgia insights","ccrpi_scoring_by_component"],"granularity_description":"One row per year, district_code, school_code, grade_cluster (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2025), schools detail","query":"SELECT * FROM ccrpi_scoring_by_component WHERE year = 2025 LIMIT 100"},{"description":"District 601 in 2025","query":"SELECT * FROM ccrpi_scoring_by_component WHERE district_code = '601' AND year = 2025 LIMIT 100"},{"description":"Filter by grade_cluster = elementary","query":"SELECT * FROM ccrpi_scoring_by_component WHERE grade_cluster = 'elementary' 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"}],"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":"grade_cluster","kind":"categorical","column":"grade_cluster","type":"string","multi_value":true,"enum_enforced":true,"values":["elementary","high","middle"],"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":[]}