CCRPI Progress

Georgia student year-over-year growth scores (the CCRPI Progress component) by indicator, grade cluster, and demographic subgroup, 2018-2025.

Fuente: Georgia Insights (GaDOE)
Cobertura de años: 2018–2025
Actualización: annual
Versión: 1.0.0
Hash del esquema: b319ac004bb3

Niveles de detalle disponibles

EstadoDistritoEscuela · predeterminado

Resumen

Georgia Insights (GaDOE) CCRPI Progress component. Measures the rate at which students improve year-over-year on Georgia Milestones assessments (English Language Arts and Mathematics) and the rate at which English Learners progress toward English Language Proficiency (ELP), for every Georgia public school, school district, and the state. Reports a 0-100 `indicator_score` plus, where published, a 0-100 improvement `indicator_target` and a green/yellow/red `ccrpi_flag`, per grade cluster (elementary/middle/high), demographic subgroup, and indicator. 2020 is ELP-only (the only component GaDOE published that year). For 2021 and 2022 GaDOE published only the ELP component in a band-movement schema: four Era-B-only `pct_*` proportion columns partition English Learners by ELP band movement, and the composite ELP rate continues the `indicator_score` series. Coverage: 2018-2025, 8 files, no gap years. This is the deep-dive into the CCRPI Progress component only (by demographic and indicator); the overall CCRPI score and the side-by-side scorecard of all five rolled-up component scores — including the rolled-up Progress component score — live in the `ccrpi_scoring_by_component` topic (the CCRPI overview).

Granularidad de fila: Una fila por year, district_code, school_code, demographic, grade_cluster, indicator.

Métrica clave

indicator_score — Indicator Score (score, 0–100)

El valor principal que la mayoría de las consultas busca.

Esquema JSON →Contrato de datos (YAML) →

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`Year	integer	—	—	no	Ending calendar year of the school year (2024 = 2023-2024). Sourced from the bronze `School Year` column, cross-checked against the filename year. Descripción completa▾ Ending calendar year of the school year (2024 = 2023-2024). Sourced from the bronze `School Year` column, cross-checked against the filename year.
`district_code`District Code	string	—	—	yes	3-digit GOSA district code (zero-padded) for standard districts; 7-digit code for state-charter systems. NULL for state-level aggregate rows. The bronze `ALL` sentinel (2021 state rows) becomes NULL. FK to districts dimension. Descripción completa▾ 3-digit GOSA district code (zero-padded) for standard districts; 7-digit code for state-charter systems. NULL for state-level aggregate rows. The bronze `ALL` sentinel (2021 state rows) becomes NULL. FK to districts dimension. Se une a districts; agrega sus columnas de etiqueta.
`school_code`School Code	string	—	—	yes	4-digit GOSA school code (zero-padded; some bronze years strip the leading zero, others pre-pad). NULL for district- and state-level aggregate rows (bronze encodes these as the literal `ALL` or a true null depending on year). FK to schools dimension (composite key with district_code). Descripción completa▾ 4-digit GOSA school code (zero-padded; some bronze years strip the leading zero, others pre-pad). NULL for district- and state-level aggregate rows (bronze encodes these as the literal `ALL` or a true null depending on year). FK to schools dimension (composite key with district_code). Se une a schools; agrega sus columnas de etiqueta.
`demographic`Demographic	string	—	—	no	Which student group the row covers - `all`, a race, or a special population; ELP rows are English-learners-only from 2019 on. Descripción completa▾ Canonical demographic code (FK to demographics dimension). `all` is the unfiltered total. Race uses the combined `asian_pacific_islander` bucket — the source never publishes separate Asian or Pacific Islander rows in any year. Era A ELA/Math rows cover all 10 groups; ELP rows cover all 10 groups in 2018 but only `english_learners` from 2019 on; the ELP-only releases (2020-2022) contain only `english_learners`. Bronze label spelling drift (American Indian variants, Asian/Pacific spacing, Disability casing) resolves via the shared demographic aliases. 10 valores permitidos▾ `all` `asian_pacific_islander` `black` `economically_disadvantaged` `english_learners` `hispanic` `multiracial` `native_american` `students_with_disabilities` `white` Se une a demographics; agrega sus columnas de etiqueta.
`grade_cluster`Grade Cluster	string	—	—	no	Grade band the row covers: elementary, middle, or high. Descripción completa▾ Grade band the row measures: `elementary`, `middle`, or `high` (bronze single letters E/M/H). A school spanning multiple bands has one row per band. 3 valores permitidos▾ `elementary` `high` `middle`
`indicator`Indicator	string	—	—	no	Which growth measure the row reports: ELA growth, math growth, or progress toward English language proficiency. Descripción completa▾ Progress indicator measured. Source labels drift (2018: `ELA Growth` / `Mathematics Growth` / `ELP Progress`; 2019-2020: `English Language Arts` / `Mathematics` / `Progress Towards Language Proficiency`; 2023+: spelled-out `...English Language Proficiency`) and collapse to three canonical values so each forms a continuous time series. Every Era B (2021-2022) row is `progress_towards_elp` — that era's sheet has no indicator column because it reports only the ELP component. 3 valores permitidos▾ `english_language_arts_growth` `mathematics_growth` `progress_towards_elp`
`ccrpi_flag`CCRPI Flag	string	—	—	yes	Improvement-target flag (green = met, yellow, red); set only on English-learner ELP-progress rows. Descripción completa▾ CCRPI improvement-target flag: `green` (met target), `yellow`, `red`. `green_star` exists in the §16 CCRPI vocabulary but never appears in this topic's bronze (verified 2018-2025). Populated ONLY on `progress_towards_elp` rows for the `english_learners` demographic in 2018, 2019, 2023, 2024, 2025 — ELA/Math growth rows and the 2020-2022 releases never carry a flag. Derived performance attribute functionally determined by the rest of the row key, so excluded from the contract grain. 3 valores permitidos▾ `green` `red` `yellow`
`indicator_score`Indicator Score	number	score	0–100	yes	Progress (growth) score on a 0-100 scale; NULL when suppressed or not applicable. Descripción completa▾ Progress score on the 0-100 CCRPI score scale (NOT a percentage — score columns are exempt from the 0-1 convention). Era A: the bronze `Indicator Score`. Era B (2021-2022): the composite `Progress Towards ELP Rate`, the same ELP-progress concept, so the ELP time series is continuous across eras. The `100.00+` overage marker (2023: 4,131 cells; 2021: 202; 2022: 466) means progress exceeded 100% and is mapped to exactly 100 before the numeric cast. Observed range 0-100 (the minimum 0.0 is a genuine 2021 Era B composite rate — 100% of that school's English Learners had no positive band movement; the Era A minimum is 3.13).
`indicator_target`Indicator Target	number	score	0–100	yes	ELP improvement target on the same 0-100 score scale as indicator_score. Populated ONLY on `progress_towards_elp` rows for the `english_learners` demographic in 2018, 2019, 2023, 2024, 2025 (Era B bronze has no target column; 2020 published none). Observed range 5.74-90. Descripción completa▾ ELP improvement target on the same 0-100 score scale as indicator_score. Populated ONLY on `progress_towards_elp` rows for the `english_learners` demographic in 2018, 2019, 2023, 2024, 2025 (Era B bronze has no target column; 2020 published none). Observed range 5.74-90.
`pct_no_positive_movement`Percent No Positive Movement	number	proportion	—	yes	Share of English Learners with no positive ELP band movement. 0-1 decimal scale (bronze 0-100, divided by 100). Era B (2021-2022) only; 100% NULL in every Era A year. The four band columns partition the EL population (sum = 1.0 within rounding). Descripción completa▾ Share of English Learners with no positive ELP band movement. 0-1 decimal scale (bronze 0-100, divided by 100). Era B (2021-2022) only; 100% NULL in every Era A year. The four band columns partition the EL population (sum = 1.0 within rounding).
`pct_moved_less_than_one_band`Percent Moved Less Than One Band	number	proportion	—	yes	Share of English Learners whose ELP growth was positive but less than one band. 0-1 decimal scale (bronze 0-100, divided by 100). Era B (2021-2022) only; 100% NULL in every Era A year. Descripción completa▾ Share of English Learners whose ELP growth was positive but less than one band. 0-1 decimal scale (bronze 0-100, divided by 100). Era B (2021-2022) only; 100% NULL in every Era A year.
`pct_moved_one_band`Percent Moved One Band	number	proportion	—	yes	Share of English Learners who moved up exactly one ELP band. 0-1 decimal scale (bronze 0-100, divided by 100). Era B (2021-2022) only; 100% NULL in every Era A year. Descripción completa▾ Share of English Learners who moved up exactly one ELP band. 0-1 decimal scale (bronze 0-100, divided by 100). Era B (2021-2022) only; 100% NULL in every Era A year.
`pct_moved_more_than_one_band`Percent Moved More Than One Band	number	proportion	—	yes	Share of English Learners who moved up more than one ELP band. 0-1 decimal scale (bronze 0-100, divided by 100). Era B (2021-2022) only; 100% NULL in every Era A year. Descripción completa▾ Share of English Learners who moved up more than one ELP band. 0-1 decimal scale (bronze 0-100, divided by 100). Era B (2021-2022) only; 100% NULL in every Era A year.

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
`demographic`	foreign_key	10 valores permitidos▾ `all` `asian_pacific_islander` `black` `economically_disadvantaged` `english_learners` `hispanic` `multiracial` `native_american` `students_with_disabilities` `white`	valores múltiples, enum validado
`grade_cluster`	categorical	`elementaryhighmiddle`	valores múltiples, enum validado, elige uno
`indicator`	categorical	`english_language_arts_growthmathematics_growthprogress_towards_elp`	valores múltiples, enum validado, elige uno
`ccrpi_flag`	categorical	`greenredyellow`	valores múltiples, enum validado
`district_type`	dimension_attribute	7 valores permitidos▾ `commission_charter` `resa` `standard` `state_agency` `state_charter` `state_school` `state_special`	valores múltiples, enum validado
`demographic_category`	dimension_attribute	12 valores permitidos▾ `aggregate` `disability` `economic_status` `esol` `foster_care` `gender` `grade` `homeless_status` `migrant_status` `military` `race` `sped`	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_progress"

schools data for 2025

curl "https://georgiacivicdata.org/api/v1/education/ccrpi_progress?year=2025"

Filtered to grade_cluster = elementary for 2025

curl "https://georgiacivicdata.org/api/v1/education/ccrpi_progress?year=2025&grade_cluster=elementary"

One district (code 601), 2025

curl "https://georgiacivicdata.org/api/v1/education/ccrpi_progress?district_code=601&year=2025&detail=districts"

Download 2025 as CSV

curl "https://georgiacivicdata.org/api/v1/education/ccrpi_progress?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.