---
title: "Georgia public schools' School Climate Star Rating (CCRPI) from Georgia Insights / GaDOE: an ordinal 1-5 whole-star rati"
method: GET
path: "/api/v1/education/ccrpi_climate_star_rating"
tags: ["education"]
---

# Georgia public schools' School Climate Star Rating (CCRPI) from Georgia Insights / GaDOE: an ordinal 1-5 whole-star rati

`GET /api/v1/education/ccrpi_climate_star_rating`

## Request

- Base URL: `https://georgiacivicdata.org`
- URL: `https://georgiacivicdata.org/api/v1/education/ccrpi_climate_star_rating`
- Auth: none declared

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.

**Filterable categorical columns:** none

**Detail levels available:** schools (default: `schools`)

**Year coverage:** 2014–2024 (no data for: 2020, 2021, 2022, 2023)

**NULL handling:** suppressed cells are NULL (not zero); zero is a real value.

**Source:** Georgia Insights (GaDOE)

## Query parameters

- `year` integer, nullable: Exact year
- `year_min` integer, nullable: Inclusive lower bound
- `year_max` integer, nullable: Inclusive upper bound
- `district_code` string, nullable: Comma-separated list of GOSA district codes (e.g. `601,602`)
- `school_code` string, nullable: Comma-separated list of GOSA school codes. Combine with `district_code` for unique school keys.
- `county_fips` string, nullable: Comma-separated list of 5-digit county FIPS codes (e.g. `13121,13067`)
- `tract_geoid` string, nullable: Comma-separated list of 11-digit census tract GEOIDs (e.g. `13121011100`)
- `block_group_geoid` string, nullable: Comma-separated list of 12-digit census block group GEOIDs (e.g. `131210111001`)
- `demographic` string, nullable: Comma-separated demographic codes (e.g. `all,black,hispanic`)
- `detail` string, nullable: Detail level (whatever the topic publishes — e.g. schools, districts, counties, or states).
- `limit` integer, nullable: Page size
- `offset` integer: Page offset
- `columns` string, nullable: Comma-separated output columns to return (fact columns plus joined dimension attributes). Defaults to all.
- `format` 'json' | 'csv' | 'parquet': Response format: json | csv | parquet

## Response `200`

Paginated rows. JSON returns an envelope with `data` and `pagination`; CSV/Parquet return raw bytes with `X-Total-Count` header.

- unknown

## Other responses

- `422`: Validation Error

---

[API](https://skmtc.dev/georgiacivicdata/apis/georgia-civic-data-api.md) · [All operations](https://skmtc.dev/georgiacivicdata/apis/georgia-civic-data-api/llms.txt) · [OpenAPI document](https://skmtc.dev/georgiacivicdata/apis/georgia-civic-data-api/revisions/dcfdf19662d2?raw)