Saltar al contenido
← Todos los conjuntos de datos

CCRPI Scores and Components

Georgia's overall CCRPI accountability score plus its component scores, by school, district, and state and grade cluster, 2012-2025.

Cobertura de años
20122025
Actualización
annual
Versión
1.0.0
Hash del esquema
f645754de437

Niveles de detalle disponibles

EstadoDistritoEscuela · predeterminado

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.

Métrica clave

ccrpi_single_scoreCCRPI 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.

ColumnaTipoUnidadRango¿Nulo?Descripción
yearYearintegernoEnding 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_codeDistrict Codestringyes3-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.

Se une a districts; agrega sus columnas de etiqueta.

school_codeSchool Codestringyes4-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).

Se une a schools; agrega sus columnas de etiqueta.

grade_clusterGrade ClusterstringnoGrade 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
  • elementary
  • high
  • middle
achievement_pointsAchievement PointsnumberscoreyesCCRPI 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_pointsProgress PointsnumberscoreyesCCRPI 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_pointsAchievement Gap PointsnumberscoreyesCCRPI 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_performanceEd EL Swd PerformancenumberscoreyesEconomically 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_pointsEtb PointsnumberscoreyesExceeding 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_pointsChallenge PointsnumberscoreyesChallenge 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_masteryContent Masterynumberscore0–100yesCCRPI 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.
progressProgressnumberscore0–100yesCCRPI 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_gapsClosing Gapsnumberscore0–100yesCCRPI 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).
readinessReadinessnumberscore0–100yesCCRPI 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_rateGraduation RatenumberproportionyesCCRPI 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_scoreCCRPI ScorenumberscoreyesAggregated 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_scoreCCRPI Single ScorenumberscoreyesThe 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ámetroTipoValores permitidosNotas
yearyear_exactcualquier valor
year_minyear_rangecualquier valor
year_maxyear_rangecualquier valor
detaildetaildistrictsschoolsstatesenum validado, predeterminado: schools
district_codeforeign_keycualquier valorvalores múltiples
school_codeforeign_keycualquier valorvalores múltiples
grade_clustercategoricalelementaryhighmiddlevalores múltiples, enum validado, elige uno
district_typedimension_attribute
7 valores permitidos
  • commission_charter
  • resa
  • standard
  • state_agency
  • state_charter
  • state_school
  • state_special
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.