CCRPI Progress

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

Source: Georgia Insights (GaDOE)
Year coverage: 2018–2025
Updated: annual
Version: 1.0.0
Schema hash: b319ac004bb3

Detail levels available

StateDistrictSchool · default

Overview

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

Row grain: One row per year, district_code, school_code, demographic, grade_cluster, indicator.

Key metric

indicator_score — Indicator Score (score, 0–100)

The single headline value most answers want.

JSON schema →Data contract (YAML) →

Variables

Every column in the fact table. The code is the exact field name the API returns.

Column	Type	Unit	Range	Null?	Description
`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. Full description▾ 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. Full description▾ 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. Joins districts; adds its label columns.
`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). Full description▾ 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). Joins schools; adds its label columns.
`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. Full description▾ 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 allowed values▾ `all` `asian_pacific_islander` `black` `economically_disadvantaged` `english_learners` `hispanic` `multiracial` `native_american` `students_with_disabilities` `white` Joins demographics; adds its label columns.
`grade_cluster`Grade Cluster	string	—	—	no	Grade band the row covers: elementary, middle, or high. Full description▾ 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 allowed values▾ `elementary` `high` `middle`
`indicator`Indicator	string	—	—	no	Which growth measure the row reports: ELA growth, math growth, or progress toward English language proficiency. Full description▾ 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 allowed values▾ `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. Full description▾ 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 allowed values▾ `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. Full description▾ 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. Full description▾ 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). Full description▾ 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. Full description▾ 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. Full description▾ 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. Full description▾ 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.

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
`demographic`	foreign_key	10 allowed values▾ `all` `asian_pacific_islander` `black` `economically_disadvantaged` `english_learners` `hispanic` `multiracial` `native_american` `students_with_disabilities` `white`	multi-value, enum-enforced
`grade_cluster`	categorical	`elementaryhighmiddle`	multi-value, enum-enforced, pick one
`indicator`	categorical	`english_language_arts_growthmathematics_growthprogress_towards_elp`	multi-value, enum-enforced, pick one
`ccrpi_flag`	categorical	`greenredyellow`	multi-value, enum-enforced
`district_type`	dimension_attribute	7 allowed values▾ `commission_charter` `resa` `standard` `state_agency` `state_charter` `state_school` `state_special`	multi-value, enum-enforced
`demographic_category`	dimension_attribute	12 allowed values▾ `aggregate` `disability` `economic_status` `esol` `foster_care` `gender` `grade` `homeless_status` `migrant_status` `military` `race` `sped`	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_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"

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.