{"main_topic":"education","sub_topic":"georgiainsights","topic":"ccrpi_readiness","key":"education/georgiainsights/ccrpi_readiness","version":"1.0.0","year_min":2018,"year_max":2025,"year_gaps":[2020],"update_frequency":"annual","detail_levels":["districts","schools","states"],"default_detail":"schools","path_template":"education/ccrpi_readiness/year={year}/{detail}.parquet","grain":["year","district_code","school_code","demographic","grade_cluster","indicator","sub_indicator"],"title":"CCRPI Readiness","summary":"Georgia school readiness scores (the CCRPI Readiness component) by indicator, sub-indicator, grade cluster, and demographic subgroup, 2018-2025.","description":"Georgia Insights (GaDOE) CCRPI Readiness component. Reports each Georgia public school's (and aggregated district / state) 0-100 score on the CCRPI Readiness indicators, per grade cluster (elementary/middle/high) and demographic subgroup. Six indicators vary by grade cluster: Literacy / At or Above Grade-Level Reading (E/M/H), Student Attendance / Attendance (E/M/H), Beyond the Core (E/M enrichment-course enrollment), Accelerated Enrollment (H college-level credit: AP, Dual Enrollment, IB, Advanced Academic, Cambridge), Pathway Completion (H), and College and Career Readiness (H). From 2021 the source adds a sub-indicator axis breaking each indicator into its components, plus an unbenchmarked participation rate for Accelerated Enrollment. Coverage: 2018-2019 and 2021-2025 (no 2020 — CCRPI was not calculated under the COVID federal waiver). This is the deep-dive into the CCRPI Readiness component only (by demographic, indicator, and sub-indicator); the overall CCRPI score and the side-by-side scorecard of all five rolled-up component scores — including the rolled-up Readiness 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_readiness","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. No 2020 partition exists — CCRPI was waived that 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 (preserved in full, never truncated). NULL for state-level aggregate rows — the bronze `ALL` sentinel 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). NULL for district- and state-level aggregate rows — the bronze `ALL` sentinel becomes NULL. 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; all 10 groups appear every year.","description":"Canonical demographic code (FK to demographics dimension). All 10 groups are reported in every year. `all` is the unfiltered total. Race uses the combined `asian_pacific_islander` bucket — the source publishes the explicit `Asian/Pacific Islander` label and never separate Asian or Pacific Islander rows in any year. The `American Indian/Alaskan` (2018-2021) vs `American Indian/Alaskan Native` (2022+) label rename 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 (some indicators exist only at certain bands).","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. Indicator availability is cluster-bound: Accelerated Enrollment, Pathway Completion, and College and Career Readiness exist only at `high`; Beyond the Core only at `elementary`/`middle` (verified in every year).","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 readiness measure the row reports (e.g. literacy, attendance, accelerated enrollment, pathway completion).","description":"Readiness indicator measured, snake_case. `Beyond The Core` (2018-2019 casing) unifies with `Beyond the Core` (2021+). `literacy` / `student_attendance` (2018-2022) are kept DISTINCT from their 2023+ successors `at_or_above_grade_level_reading` / `attendance` — GaDOE revised the underlying methodology with the 2023 rename, so the two series must not be concatenated. 2022 published only 4 indicators (no Student Attendance, no College and Career Readiness) per the DOE pandemic disclaimer in that file.","valid_values":["accelerated_enrollment","at_or_above_grade_level_reading","attendance","beyond_the_core","college_and_career_readiness","literacy","pathway_completion","student_attendance"],"example":"beyond_the_core","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"sub_indicator","type":"string","role":"categorical","nullable":true,"label":"Sub Indicator","short_description":"Component within the parent indicator (2021 on); `all` is the rolled-up indicator score; NULL before 2021.","description":"Component within the parent indicator (2021-2025 only), snake_case. `all` is the rolled-up parent-indicator score — it unifies bronze `All` (indicators WITH sub-breakdowns) and bronze `NA` (2021-2022; indicators with no sub-breakdown at all, i.e. Literacy and Student Attendance). 16 sub-component values nest strictly under their parent indicator (verified in every Era 2 year); `fine_arts` and `world_language` appear under BOTH `beyond_the_core` and `pathway_completion`, and `international_baccalaureate` under both `accelerated_enrollment` and (2022-2023 only) `pathway_completion`. Label drift collapses: casing variants (`Fine arts`, `Advanced academic`), the 2021 verbose College and Career Readiness labels (`Readiness score on the ACT, SAT, AP or IB`, `End of pathway assessment (EOPA)`, `Entering TCSG/USG without needing remediation`), and the ACT/SAT/AP/IB -> ACT/SAT/AP/IB/Cambridge evolution all unify (`act_sat_ap_ib_cambridge`, `eopa`, `tcsg_usg`). NOTE: Cambridge exams qualify only from 2025 — `act_sat_ap_ib_cambridge` rows in 2021-2024 measured ACT/SAT/AP/IB only; this is one continuous series whose qualifying-assessment list widened in 2025.","valid_values":["act_sat_ap_ib_cambridge","advanced_academic","advanced_placement","all","asvab","cambridge","career_exploratory","computer_science","ctae","dual_enrollment","eopa","fine_arts","international_baccalaureate","physical_education_health","tcsg_usg","work_based_learning","world_language"],"example":"fine_arts","unit":null,"value_min":null,"value_max":null,"null_meaning":"Era 1 row (2018-2019): bronze had no Sub-Indicator column, so no sub-breakdown was collected. NULL is deliberately distinct from `all` (Era 2's explicit rolled-up-score marker).","key_metric_grain_contributor":true,"metric_component":null},{"name":"indicator_score","type":"number","role":"metric","nullable":true,"label":"Indicator Score","short_description":"Benchmarked readiness score on a 0-100 scale; NULL when suppressed or not applicable.","description":"Benchmarked CCRPI Readiness score on the 0-100 CCRPI score scale (NOT a percentage — score columns are exempt from the 0-1 convention per education CLAUDE.md, matching ccrpi_content_mastery and ccrpi_progress). Observed range is exactly [0, 100] in every year; CCRPI caps component scores at 100.","valid_values":null,"example":78.52,"unit":"score","value_min":0,"value_max":100,"null_meaning":"Suppressed by GaDOE (`TFS` / `Too Few Students` — too few students in the subgroup) or not applicable / not reported (`NA`).","key_metric_grain_contributor":false,"metric_component":null},{"name":"unbenchmarked_rate","type":"number","role":"metric","nullable":true,"label":"Unbenchmarked Rate","short_description":"","description":"Raw Accelerated Enrollment participation rate before CCRPI benchmark scaling, on the 0-1 decimal scale (bronze 0-100, divided by 100). Population pattern shifts mid-era (verified per year): 2021-2023 populate it ONLY on `accelerated_enrollment` rows; 2024-2025 populate every row, where non-AE values are a cell-identical redundant copy of `indicator_score` (divided by 100). Only `accelerated_enrollment` rows carry independent information; on AE rows the rate and the score are always co-published (co-null).","valid_values":null,"example":0.4217,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Era 1 row (2018-2019: column absent from bronze); a 2021-2023 non-Accelerated-Enrollment row (bronze `NA` — rate published only for Accelerated Enrollment in those years); or suppressed (`TFS` / `Too Few Students`).","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,2021,2022,2023,2024,2025],"schema_hash":"2341973aebcc7a2615c1f0438e40a389301d20edc5271389cbb0d093e7503d6d","tags":["education","georgia insights","ccrpi_readiness"],"granularity_description":"One row per year, district_code, school_code, demographic, grade_cluster, indicator, sub_indicator (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2025), schools detail","query":"SELECT * FROM ccrpi_readiness WHERE year = 2025 LIMIT 100"},{"description":"District 601 in 2025","query":"SELECT * FROM ccrpi_readiness WHERE district_code = '601' AND year = 2025 LIMIT 100"},{"description":"Filter by grade_cluster = elementary","query":"SELECT * FROM ccrpi_readiness 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":["accelerated_enrollment","at_or_above_grade_level_reading","attendance","beyond_the_core","college_and_career_readiness","literacy","pathway_completion","student_attendance"],"has_total":false,"total_value":null,"requires_single_value":true},{"param":"sub_indicator","kind":"categorical","column":"sub_indicator","type":"string","multi_value":true,"enum_enforced":true,"values":["act_sat_ap_ib_cambridge","advanced_academic","advanced_placement","all","asvab","cambridge","career_exploratory","computer_science","ctae","dual_enrollment","eopa","fine_arts","international_baccalaureate","physical_education_health","tcsg_usg","work_based_learning","world_language"],"has_total":true,"total_value":"all","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":[]}