{"main_topic":"education","sub_topic":"georgiainsights","topic":"ccrpi_progress","key":"education/georgiainsights/ccrpi_progress","version":"1.0.0","year_min":2018,"year_max":2025,"year_gaps":[],"update_frequency":"annual","detail_levels":["districts","schools","states"],"default_detail":"schools","path_template":"education/ccrpi_progress/year={year}/{detail}.parquet","grain":["year","district_code","school_code","demographic","grade_cluster","indicator"],"title":"CCRPI Progress","summary":"Georgia student year-over-year growth scores (the CCRPI Progress component) by indicator, grade cluster, and demographic subgroup, 2018-2025.","description":"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).","source":"Georgia Insights (GaDOE)","source_url":"https://georgiainsights.gadoe.org/data-downloads/","endpoint":"/api/v1/education/ccrpi_progress","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Ending calendar year of the school year (2024 = 2023-2024). Sourced from the bronze `School Year` column, cross-checked against the filename year.","valid_values":null,"example":2024,"unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"district_code","type":"string","role":"fk_district","nullable":true,"label":"District Code","short_description":"","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.","valid_values":null,"example":"601","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"school_code","type":"string","role":"fk_school","nullable":true,"label":"School Code","short_description":"","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).","valid_values":null,"example":"0194","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"demographic","type":"string","role":"fk_demographic","nullable":false,"label":"Demographic","short_description":"Which student group the row covers - `all`, a race, or a special population; ELP rows are English-learners-only from 2019 on.","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.","valid_values":["all","asian_pacific_islander","black","economically_disadvantaged","english_learners","hispanic","multiracial","native_american","students_with_disabilities","white"],"example":"english_learners","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"grade_cluster","type":"string","role":"categorical","nullable":false,"label":"Grade Cluster","short_description":"Grade band the row covers: elementary, middle, or high.","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.","valid_values":["elementary","high","middle"],"example":"elementary","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"indicator","type":"string","role":"categorical","nullable":false,"label":"Indicator","short_description":"Which growth measure the row reports: ELA growth, math growth, or progress toward English language proficiency.","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.","valid_values":["english_language_arts_growth","mathematics_growth","progress_towards_elp"],"example":"progress_towards_elp","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"ccrpi_flag","type":"string","role":"categorical","nullable":true,"label":"CCRPI Flag","short_description":"Improvement-target flag (green = met, yellow, red); set only on English-learner ELP-progress rows.","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.","valid_values":["green","red","yellow"],"example":"green","unit":null,"value_min":null,"value_max":null,"null_meaning":"No flag published: bronze `NA` (target not applicable or suppressed), all ELA/Math rows, all non-EL rows, and all of 2020-2022.","key_metric_grain_contributor":false,"metric_component":null},{"name":"indicator_score","type":"number","role":"metric","nullable":true,"label":"Indicator Score","short_description":"Progress (growth) score on a 0-100 scale; NULL when suppressed or not applicable.","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).","valid_values":null,"example":82.72,"unit":"score","value_min":0,"value_max":100,"null_meaning":"Suppressed by GaDOE (`TFS` — Too Few Students) or not applicable/not published (`NA`).","key_metric_grain_contributor":false,"metric_component":null},{"name":"indicator_target","type":"number","role":"metric","nullable":true,"label":"Indicator Target","short_description":"","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.","valid_values":null,"example":75.0,"unit":"score","value_min":0,"value_max":100,"null_meaning":"Bronze `NA` (no target applies — all ELA/Math rows, all non-EL rows, all of 2020-2022) or `TFS` (target suppressed for small N).","key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_no_positive_movement","type":"number","role":"metric","nullable":true,"label":"Percent No Positive Movement","short_description":"","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).","valid_values":null,"example":0.1963,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Era A row (column exists only in the 2021-2022 schema), or suppressed (`TFS`) — Era B suppression is all-or-nothing across the four band columns and the composite rate.","key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_moved_less_than_one_band","type":"number","role":"metric","nullable":true,"label":"Percent Moved Less Than One Band","short_description":"","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.","valid_values":null,"example":0.1586,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Era A row (column exists only in the 2021-2022 schema), or suppressed (`TFS`).","key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_moved_one_band","type":"number","role":"metric","nullable":true,"label":"Percent Moved One Band","short_description":"","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.","valid_values":null,"example":0.2487,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Era A row (column exists only in the 2021-2022 schema), or suppressed (`TFS`).","key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_moved_more_than_one_band","type":"number","role":"metric","nullable":true,"label":"Percent Moved More Than One Band","short_description":"","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.","valid_values":null,"example":0.3964,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Era A row (column exists only in the 2021-2022 schema), or suppressed (`TFS`).","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"indicator_score","usage":"Star-schema fact table. Join the districts dimension on district_code; the schools dimension on district_code + school_code; the demographics dimension on demographic. Read directly with DuckDB over Parquet.","limitations":"Suppressed cells are NULL (not zero). State rows have NULL district_code and school_code. District rows have NULL school_code.","null_semantics":{"suppressed_to_null":true,"zero_is_real":true},"available_years":[2018,2019,2020,2021,2022,2023,2024,2025],"schema_hash":"b319ac004bb30ea44d0fa6225397ebe585293af5eae3d8abaa5afd7e09d645e8","tags":["education","georgia insights","ccrpi_progress"],"granularity_description":"One row per year, district_code, school_code, demographic, grade_cluster, indicator (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2025), schools detail","query":"SELECT * FROM ccrpi_progress WHERE year = 2025 LIMIT 100"},{"description":"District 601 in 2025","query":"SELECT * FROM ccrpi_progress WHERE district_code = '601' AND year = 2025 LIMIT 100"},{"description":"Filter by grade_cluster = elementary","query":"SELECT * FROM ccrpi_progress WHERE grade_cluster = 'elementary' AND year = 2025 LIMIT 100"}],"foreign_keys":[{"column":"district_code","target_object":"districts","target_columns":["district_code"],"attribute_columns_added":["district_name","district_census_id","district_type"],"scope":"domain"},{"column":"school_code","target_object":"schools","target_columns":["district_code","school_code"],"attribute_columns_added":["school_name"],"scope":"domain"},{"column":"demographic","target_object":"demographics","target_columns":["demographic"],"attribute_columns_added":["demographic_label","demographic_category"],"scope":"global"}],"filters":[{"param":"year","kind":"year_exact","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"year_min","kind":"year_range","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"year_max","kind":"year_range","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"detail","kind":"detail","type":"string","multi_value":false,"enum_enforced":true,"values":["districts","schools","states"],"default":"schools"},{"param":"district_code","kind":"foreign_key","column":"district_code","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"school_code","kind":"foreign_key","column":"school_code","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"demographic","kind":"foreign_key","column":"demographic","type":"string","multi_value":true,"enum_enforced":true,"values":["all","asian_pacific_islander","black","economically_disadvantaged","english_learners","hispanic","multiracial","native_american","students_with_disabilities","white"]},{"param":"grade_cluster","kind":"categorical","column":"grade_cluster","type":"string","multi_value":true,"enum_enforced":true,"values":["elementary","high","middle"],"has_total":false,"total_value":null,"requires_single_value":true},{"param":"indicator","kind":"categorical","column":"indicator","type":"string","multi_value":true,"enum_enforced":true,"values":["english_language_arts_growth","mathematics_growth","progress_towards_elp"],"has_total":false,"total_value":null,"requires_single_value":true},{"param":"ccrpi_flag","kind":"categorical","column":"ccrpi_flag","type":"string","multi_value":true,"enum_enforced":true,"values":["green","red","yellow"],"has_total":false,"total_value":null,"requires_single_value":false},{"param":"district_type","kind":"dimension_attribute","dimension":"districts","column":"district_type","type":"string","multi_value":true,"enum_enforced":true,"values":["commission_charter","resa","standard","state_agency","state_charter","state_school","state_special"]},{"param":"demographic_category","kind":"dimension_attribute","dimension":"demographics","column":"demographic_category","type":"string","multi_value":true,"enum_enforced":true,"values":["aggregate","disability","economic_status","esol","foster_care","gender","grade","homeless_status","migrant_status","military","race","sped"]}],"filter_hints":[]}