{"main_topic":"education","sub_topic":"georgiainsights","topic":"ccrpi_climate_star_rating","key":"education/georgiainsights/ccrpi_climate_star_rating","version":"2.0.0","year_min":2014,"year_max":2024,"year_gaps":[2020,2021,2022,2023],"update_frequency":"annual","detail_levels":["schools"],"default_detail":"schools","path_template":"education/ccrpi_climate_star_rating/year={year}/{detail}.parquet","grain":["year","district_code","school_code"],"title":"CCRPI Climate Star Rating","summary":"Georgia public schools' 1-5 School Climate Star Rating (a CCRPI component), school-level, 2014-2019 and 2024.","description":"Georgia public schools' School Climate Star Rating (CCRPI) from Georgia Insights / GaDOE: an ordinal 1-5 whole-star rating built from four equally weighted components (climate surveys, student discipline, safe & substance-free environment, school-wide attendance), published 2014-2019 and 2024. School-level only — the source publishes no district or state aggregate rows — with no demographic breakdowns. Years 2020-2023 are absent (Georgia paused CCRPI during COVID). The CCRPI Single Score that GaDOE paired with this rating is not carried here; it lives in the `ccrpi_scoring_by_component` topic.","source":"Georgia Insights (GaDOE)","source_url":"https://georgiainsights.gadoe.org/data-downloads/","endpoint":"/api/v1/education/ccrpi_climate_star_rating","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Ending calendar year of the school year (e.g., 2018 = 2017-2018). Sourced from the in-file Year / School Year column, not the filename — the 2014 data ships in a file named with its 04.14.15 publication date. Coverage: 2014-2019 and 2024 (2020-2023 absent; COVID CCRPI pause).","valid_values":null,"example":2018,"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":false,"label":"District Code","short_description":"","description":"GOSA district code (FK to districts dimension): standard 3-digit codes zero-padded; 7-digit state-charter / state-school operator codes (e.g., '7820108') preserved in full. Non-NULL on every row — this topic is school-level only.","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":false,"label":"School Code","short_description":"","description":"4-digit GOSA school code, zero-padded (FK to schools dimension; composite key with district_code). The 2024 file ships bare integer codes ('100'), padded to align with prior years ('0100'). Non-NULL on every row.","valid_values":null,"example":"0103","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"school_climate_star_rating","type":"number","role":"metric","nullable":true,"label":"School Climate Star Rating","short_description":"Overall school climate rating from 1 (most in need of improvement) to 5 (excellent); NULL if not rated.","description":"School Climate Star Rating, ordinal 1-5 — a diagnostic measure of school climate from four equally weighted (25% each) components: (1) student/teacher/parent climate surveys, (2) student discipline (weighted suspension rate), (3) safe & substance-free learning environment, (4) school-wide attendance. 5 = excellent, 1 = most in need of improvement. Whole stars only — no half-steps in any bronze year (enforced as a quality check) — but stored Float64 for cross-topic consistency with the half-step FESR star ratings, so the API exposes one star-rating type. NOT scaled to 0-1.","valid_values":null,"example":4.0,"unit":"rating","value_min":1,"value_max":5,"null_meaning":"School did not receive a climate rating — a literal `NA` text marker in bronze (typically new schools, special-purpose facilities such as youth detention centers, and very small enrollments); 11-60 NULLs per year, every one tracing to an `NA` marker, never a blank cell.","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"school_climate_star_rating","usage":"Star-schema fact table. Join the districts dimension on district_code; the schools dimension on district_code + school_code. Read directly with DuckDB over Parquet.","limitations":"Suppressed cells are NULL (not zero).","null_semantics":{"suppressed_to_null":true,"zero_is_real":true},"available_years":[2014,2015,2016,2017,2018,2019,2024],"schema_hash":"6688f79cce941b9180fa824ee3d2cccc4fba2c44eeb61e785b8dbd3549d5879d","tags":["education","georgia insights","ccrpi_climate_star_rating"],"granularity_description":"One row per year, district_code, school_code.","example_queries":[{"description":"Latest year (2024), schools detail","query":"SELECT * FROM ccrpi_climate_star_rating WHERE year = 2024 LIMIT 100"},{"description":"District 601 in 2024","query":"SELECT * FROM ccrpi_climate_star_rating WHERE district_code = '601' AND year = 2024 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"}],"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":["schools"],"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":"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"]}],"filter_hints":[]}