CCRPI Scores and Components
Georgia's overall CCRPI accountability score plus its component scores, by school, district, and state and grade cluster, 2012-2025.
- 2012–2025
- annual
- 1.0.0
- f645754de437
Overview
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.
Row grain: One row per year, district_code, school_code, grade_cluster.
ccrpi_single_score — CCRPI Single Score (score)
The single headline value most answers want.
Variables
Every column in the fact table. The code is the exact field name the API returns.
| Column | Type | Unit | Range | Null? | Description |
|---|---|---|---|---|---|
year | integer | — | — | no | 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.Full 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. |
district_code | string | — | — | yes | 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.Full 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. |
school_code | string | — | — | yes | 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).Full 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). |
grade_cluster | string | — | — | no | Grade band the row covers: elementary, middle, or high (a K-12 school appears in up to three rows per year).Full 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. 3 allowed values▾
|
achievement_points | number | — | yes | 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).Full 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). | |
progress_points | number | — | yes | 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.Full 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. | |
achievement_gap_points | number | — | yes | 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.Full 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. | |
ed_el_swd_performance | number | — | yes | 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.Full 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. | |
etb_points | number | — | yes | 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.Full 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. | |
challenge_points | number | — | yes | 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.Full 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. | |
content_mastery | number | 0–100 | yes | 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.Full 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. | |
progress | number | 0–100 | yes | 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`).Full 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`). | |
closing_gaps | number | 0–100 | yes | 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).Full 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). | |
readiness | number | 0–100 | yes | 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.Full 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. | |
graduation_rate | number | — | yes | 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).Full 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). | |
ccrpi_score | number | — | yes | 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).Full 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). | |
ccrpi_single_score | number | — | yes | The entity's overall CCRPI accountability score on a 0-100 scale; published 2012-2019, NULL from 2022 on.Full 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). |
Filters
Query parameters the fact endpoint accepts. Comma-separated values are OR within a parameter; multiple parameters AND together.
| Parameter | Kind | Allowed values | Notes |
|---|---|---|---|
year | year_exact | any value | — |
year_min | year_range | any value | — |
year_max | year_range | any value | — |
detail | detail | districtsschoolsstates | enum-enforced, default: schools |
district_code | foreign_key | any value | multi-value |
school_code | foreign_key | any value | multi-value |
grade_cluster | categorical | elementaryhighmiddle | multi-value, enum-enforced, pick one |
district_type | dimension_attribute | 7 allowed values▾
| multi-value, enum-enforced |
Example requests
Run these against the base URL — they return live data.
All rows (first page), schools level
curl "https://georgiacivicdata.org/api/v1/education/ccrpi_scoring_by_component"schools data for 2025
curl "https://georgiacivicdata.org/api/v1/education/ccrpi_scoring_by_component?year=2025"Filtered to grade_cluster = elementary for 2025
curl "https://georgiacivicdata.org/api/v1/education/ccrpi_scoring_by_component?year=2025&grade_cluster=elementary"One district (code 601), 2025
curl "https://georgiacivicdata.org/api/v1/education/ccrpi_scoring_by_component?district_code=601&year=2025&detail=districts"Download 2025 as CSV
curl "https://georgiacivicdata.org/api/v1/education/ccrpi_scoring_by_component?year=2025&format=csv"Notes & limitations
NULL handling
- Suppressed cells (too few students to report) are NULL, never zero.
- Zero is a real, reported value.
Limitations
Suppressed cells are NULL (not zero). State rows have NULL district_code and school_code. District rows have NULL school_code.