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
Resumen
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.
Granularidad de fila: Una fila por year, district_code, school_code, grade_cluster.
ccrpi_single_score — CCRPI Single Score (score)
El valor principal que la mayoría de las consultas busca.
Variables
Todas las columnas de la tabla de hechos. El código es el nombre exacto del campo que devuelve la API.
| Columna | Tipo | Unidad | Rango | ¿Nulo? | Descripción |
|---|---|---|---|---|---|
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.Descripción completa▾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.Descripción completa▾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).Descripción completa▾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).Descripción completa▾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 valores permitidos▾
|
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).Descripción completa▾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.Descripción completa▾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.Descripción completa▾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.Descripción completa▾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.Descripción completa▾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.Descripción completa▾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.Descripción completa▾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`).Descripción completa▾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).Descripción completa▾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.Descripción completa▾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).Descripción completa▾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).Descripción completa▾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.Descripción completa▾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). |
Filtros
Parámetros de consulta que acepta el endpoint de hechos. Los valores separados por comas son OR dentro de un parámetro; varios parámetros se combinan con AND.
| Parámetro | Tipo | Valores permitidos | Notas |
|---|---|---|---|
year | year_exact | cualquier valor | — |
year_min | year_range | cualquier valor | — |
year_max | year_range | cualquier valor | — |
detail | detail | districtsschoolsstates | enum validado, predeterminado: schools |
district_code | foreign_key | cualquier valor | valores múltiples |
school_code | foreign_key | cualquier valor | valores múltiples |
grade_cluster | categorical | elementaryhighmiddle | valores múltiples, enum validado, elige uno |
district_type | dimension_attribute | 7 valores permitidos▾
| valores múltiples, enum validado |
Ejemplos de solicitudes
Ejecútalos contra la URL base: devuelven datos en vivo.
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"Notas y limitaciones
Manejo de NULL
- Las celdas suprimidas (muy pocos estudiantes para reportar) son NULL, nunca cero.
- El cero es un valor real y reportado.
Limitaciones
Suppressed cells are NULL (not zero). State rows have NULL district_code and school_code. District rows have NULL school_code.