{"main_topic":"education","sub_topic":"georgiainsights","topic":"ccrpi_content_mastery","key":"education/georgiainsights/ccrpi_content_mastery","version":"1.0.0","year_min":2012,"year_max":2025,"year_gaps":[2020],"update_frequency":"annual","detail_levels":["districts","schools","states"],"default_detail":"schools","path_template":"education/ccrpi_content_mastery/year={year}/{detail}.parquet","grain":["year","district_code","school_code","demographic","grade_cluster","assessment_type","subject"],"title":"CCRPI Content Mastery","summary":"Georgia student proficiency scores on state assessments (the CCRPI Content Mastery component) by subject, grade cluster, and demographic subgroup, 2012-2025.","description":"CCRPI Content Mastery measures student proficiency on Georgia state assessments in core academic subjects at the school, district, and (2014+) state level, broken out by demographic subgroup, grade cluster, and (2012-2017) assessment type. The primary `indicator_score` metric unifies four source labels across eras: Meets & Exceeds Rate (2012-2014, CRCT/EOCT), Weighted Proficiency Rate (2015-2017, EOG/EOC; exceeds 100 by design), Indicator Score (2018-2019, 2022-2025), and Achievement Rate (2021). 2021-2022 add four learner-band proportions with derived `_or_above` cumulatives; 2018-2019 and 2023-2025 add an improvement `indicator_target` and a color `ccrpi_flag`. 2020 is absent — Georgia paused CCRPI during COVID. This is the deep-dive into the Content Mastery component only (by demographic, subject, and assessment type); the overall CCRPI score and the side-by-side scorecard of all five rolled-up component scores live in the `ccrpi_scoring_by_component` topic (the CCRPI overview), which this topic does not duplicate.","source":"Georgia Insights (GaDOE)","source_url":"https://georgiainsights.gadoe.org/data-downloads/","endpoint":"/api/v1/education/ccrpi_content_mastery","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Ending calendar year of the school year (2025 = 2024-2025). Sourced from the bronze `School Year` column, cross-checked against the filename year. 2020 does not exist (COVID pause).","valid_values":null,"example":2025,"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; the allowlisted pseudo-district code `RTC` (Residential Treatment Center aggregate, 2015-2017 only). NULL for state-level rows. 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; bronze strips leading zeros from some codes). NULL for district- and state-level rows. FK to schools dimension (composite key with district_code).","valid_values":null,"example":"0182","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 (economically disadvantaged, English learners, students with disabilities).","description":"Canonical demographic code (FK to demographics dimension). `all` is the unfiltered total. Race uses the combined `asian_pacific_islander` bucket — the source publishes the explicit `Asian/Pacific Islander` label in every era and never separate Asian or Pacific Islander rows. Cross-era label spellings (`American Indian/Alaskan [Native]`, `Students With/with Disability`) fold into single canonical keys.","valid_values":["all","asian_pacific_islander","black","economically_disadvantaged","english_learners","hispanic","multiracial","native_american","students_with_disabilities","white"],"example":"black","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 cluster the row aggregates: `elementary`, `middle`, or `high` (bronze single-letter E/M/H expanded). A cluster of grades, not a single grade — distinct from `grade_level` per §16.","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":"assessment_type","type":"string","role":"categorical","nullable":true,"label":"Assessment Type","short_description":"Which state testing program the score came from (CRCT/EOCT or EOG/EOC); NULL for 2018 and later.","description":"Georgia state assessment program: `crct`/`eoct` (2012-2014) or `eog`/`eoc` (2015-2017). NULL for every 2018+ row — the source dropped the column when CCRPI consolidated to four broad indicators. Part of the row grain because 2012-2017 report the same subject under both programs.","valid_values":["crct","eoc","eoct","eog"],"example":"eog","unit":null,"value_min":null,"value_max":null,"null_meaning":"Row is from 2018+ where the source no longer reports an assessment program breakdown.","key_metric_grain_contributor":true,"metric_component":null},{"name":"subject","type":"string","role":"categorical","nullable":false,"label":"Subject","short_description":"Academic subject tested (e.g. mathematics, science); broad areas from 2018, more granular subjects before.","description":"Academic subject assessed, snake_case. 2018+ uses 4 broad areas (english_language_arts, mathematics, science, social_studies); 2012-2017 split into 12-13 granular subjects (CRCT `reading` is a distinct subject, not an ELA alias). The 2021-2022 label `English` folds into `english_language_arts`. Social studies has roughly half the rows of other subjects in 2021+ (assessed only in high school and part of middle).","valid_values":["9th_grade_literature_and_composition","algebra_i_coordinate_algebra","american_literature_and_composition","biology","economics_business_free_enterprise","english_language_arts","geometry_analytic_geometry","mathematics","mathematics_1","mathematics_2","physical_science","reading","science","social_studies","us_history"],"example":"mathematics","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"participation_rate","type":"number","role":"metric","nullable":true,"label":"Participation Rate","short_description":"","description":"Share of eligible students assessed, 0-1 decimal scale. Bronze ships 0-100 in 2012-2017 and 2021-2022 (divided by 100 here) and 0-1 in 2018-2019 and 2023-2025 (passed through). 94 rows (21 in 2012, 73 in 2013; max 1.059/1.084 after scaling) legitimately exceed 1.0 — transfers-in inflated the tested/enrolled ratio before GaDOE began capping in 2014. Preserved verbatim, hence unit `ratio`, not `proportion`. State-level participation collapses to ~0.65 in 2021 (COVID-year testing disruption) versus ~0.98-0.99 in every other year — faithful to bronze, not a scaling artifact.","valid_values":null,"example":0.987,"unit":"ratio","value_min":null,"value_max":null,"null_meaning":"Suppressed by GaDOE (`Too Few Students`/`TFS`, `No Data`, or `NA`).","key_metric_grain_contributor":false,"metric_component":null},{"name":"indicator_score","type":"number","role":"metric","nullable":true,"label":"Indicator Score","short_description":"Content-mastery proficiency score on a 0-100 scale (can exceed 100 in some years by design); NULL when suppressed.","description":"Primary content-mastery metric on its natural 0-100 SCORE scale (exempt from the 0-1 percentage convention). Unifies Meets & Exceeds Rate (2012-2014), Weighted Proficiency Rate (2015-2017 — exceeds 100 by design, max observed 146.154), Indicator Score (2018-2019, 2022-2025), and Achievement Rate (2021). No upper bound is declared because >100 is legitimate. The `100.00+` top-cap sentinel is repaired two ways: 2021 (1,772 rows) reconstructed from the learner bands as 0.5*developing + proficient + 1.5*distinguished (verified to rounding precision on all numeric 2021 rows; reconstructed values span [100.005, 150.0]); 2023 (2,683 rows) capped at 100.0 because no learner bands exist that year to reconstruct from.","valid_values":null,"example":74.3,"unit":"score","value_min":0,"value_max":null,"null_meaning":"Suppressed by GaDOE (`Too Few Students`/`TFS`, `No Data`, or `NA`).","key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_beginning_learner","type":"number","role":"metric","nullable":true,"label":"Percent Beginning Learner","short_description":"","description":"Share of students at the Beginning Learner band, 0-1 scale (bronze 0-100 divided by 100). Published only for 2021-2022; NULL every other year.","valid_values":null,"example":0.21,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Year outside 2021-2022 (bands not published), or suppressed by GaDOE (all four bands suppress together).","key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_developing_learner","type":"number","role":"metric","nullable":true,"label":"Percent Developing Learner","short_description":"","description":"Share at the Developing Learner band, 0-1 scale. Published only for 2021-2022; NULL every other year.","valid_values":null,"example":0.34,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Year outside 2021-2022 (bands not published), or suppressed by GaDOE (all four bands suppress together).","key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_proficient_learner","type":"number","role":"metric","nullable":true,"label":"Percent Proficient Learner","short_description":"","description":"Share at the Proficient Learner band, 0-1 scale. Published only for 2021-2022; NULL every other year.","valid_values":null,"example":0.29,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Year outside 2021-2022 (bands not published), or suppressed by GaDOE (all four bands suppress together).","key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_distinguished_learner","type":"number","role":"metric","nullable":true,"label":"Percent Distinguished Learner","short_description":"","description":"Share at the Distinguished Learner band, 0-1 scale. Published only for 2021-2022; NULL every other year. The four bands sum to 1.0 within rounding except for 146 defective 2021 source rows (worst sum 0.7646) — preserved as published.","valid_values":null,"example":0.16,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Year outside 2021-2022 (bands not published), or suppressed by GaDOE (all four bands suppress together).","key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_developing_learner_or_above","type":"number","role":"metric","nullable":true,"label":"Percent Developing Learner or Above","short_description":"","description":"Derived cumulative: developing + proficient + distinguished, 0-1 scale, clipped at 1.0 (independent rounding can overshoot by up to 0.0002). NULL when any summand is NULL. Only populated for 2021-2022.","valid_values":null,"example":0.79,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"NULL whenever the underlying bands are NULL (year outside 2021-2022, or suppressed).","key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_proficient_learner_or_above","type":"number","role":"metric","nullable":true,"label":"Percent Proficient Learner or Above","short_description":"","description":"Derived cumulative: proficient + distinguished, 0-1 scale, clipped at 1.0. NULL when any summand is NULL. Only populated for 2021-2022.","valid_values":null,"example":0.45,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"NULL whenever the underlying bands are NULL (year outside 2021-2022, or suppressed).","key_metric_grain_contributor":false,"metric_component":null},{"name":"indicator_target","type":"number","role":"metric","nullable":true,"label":"Indicator Target","short_description":"","description":"CCRPI improvement target on the same 0-100 scale as indicator_score (observed range [1.7, 95.0]; unlike indicator_score it is bounded at 100). Published only for 2018-2019 and 2023-2025. Every 2024 mathematics row is NULL by design — GaDOE computed no math targets during the new-math-standards rollout. NOT cross-topic comparable: each CCRPI topic's target inherits its companion metric's scale (§16).","valid_values":null,"example":82.5,"unit":"score","value_min":0,"value_max":100,"null_meaning":"Year outside 2018-2019/2023-2025, suppressed (`NA`/`TFS`), or a 2024 mathematics row (no math targets computed that year).","key_metric_grain_contributor":false,"metric_component":null},{"name":"ccrpi_flag","type":"string","role":"categorical","nullable":true,"label":"CCRPI Flag","short_description":"Performance color flag (green, green_star, yellow, red); published only 2018-2019 and 2023-2025.","description":"CCRPI performance color flag: `green`, `green_star` (green with caveat), `yellow`, or `red` (bronze G/G*/Y/R recoded per §16). Published only for 2018-2019 and 2023-2025; bronze `NA` becomes NULL. A derived performance attribute functionally determined by the rest of the row key, so it is excluded from the contract grain.","valid_values":["green","green_star","red","yellow"],"example":"green","unit":null,"value_min":null,"value_max":null,"null_meaning":"Year outside 2018-2019/2023-2025, bronze `NA` (not rated), or a 2024 mathematics row (no math flags that year).","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":[2012,2013,2014,2015,2016,2017,2018,2019,2021,2022,2023,2024,2025],"schema_hash":"b9a4d90cbf667cef22fb081ecadeb45268ddc5d84c0215eccb703bc134e5f37d","tags":["education","georgia insights","ccrpi_content_mastery"],"granularity_description":"One row per year, district_code, school_code, demographic, grade_cluster, assessment_type, subject (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2025), schools detail","query":"SELECT * FROM ccrpi_content_mastery WHERE year = 2025 LIMIT 100"},{"description":"District 601 in 2025","query":"SELECT * FROM ccrpi_content_mastery WHERE district_code = '601' AND year = 2025 LIMIT 100"},{"description":"Filter by grade_cluster = elementary","query":"SELECT * FROM ccrpi_content_mastery 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":"assessment_type","kind":"categorical","column":"assessment_type","type":"string","multi_value":true,"enum_enforced":true,"values":["crct","eoc","eoct","eog"],"has_total":false,"total_value":null,"requires_single_value":true},{"param":"subject","kind":"categorical","column":"subject","type":"string","multi_value":true,"enum_enforced":true,"values":["9th_grade_literature_and_composition","algebra_i_coordinate_algebra","american_literature_and_composition","biology","economics_business_free_enterprise","english_language_arts","geometry_analytic_geometry","mathematics","mathematics_1","mathematics_2","physical_science","reading","science","social_studies","us_history"],"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","green_star","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":[]}