Financial Efficiency Star Rating (FESR)

0.5-5 star financial efficiency ratings — spending versus academic outcomes — for Georgia school districts and schools in FESR publication years (2016-2019, 2024).

Fuente: Governor's Office of Student Achievement (GOSA)
Cobertura de años: 2016–2024
Actualización: annual
Versión: 2.1.0
Hash del esquema: 388fc5498ebc

Niveles de detalle disponibles

DistritoEscuela · predeterminado

Resumen

Georgia Office of Student Achievement (GOSA) Financial Efficiency Star Rating (FESR) — the program's efficiency evaluation of each rolling window, rating how much a district spends per student against its CCRPI academic results on a 0.5-5.0 star scale (0.5 increments; more stars = better academic outcomes per dollar). Rows exist ONLY for the fiscal years an FESR publication evaluated: district rows FY2016-FY2019 and FY2024 (one per traditional Georgia system, with the three-year rolling per-pupil-expenditure average, the three-year CCRPI average, and the PPE percentile the rating is built from), and school rows FY2017-FY2019 and FY2024 (the rating plus, for the 2019 and 2024 reports only, the school's own three-year PPE average and three-year CCRPI average the rating was computed from — the publisher's inputs, which differ from what the per_pupil_expenditure and ccrpi_scoring_by_component topics would reproduce, see limitations; the 2017/2018 school files publish no rolling averages). GOSA paused the program FY2020-FY2023, so those years have no rows. The FY2024 report revived the rating with a non-contiguous FY19+FY23+FY24 window. The underlying annual spending panel (total/federal/state-local expenditures, FTE enrollment, per-pupil expenditure for every fiscal year) now lives in the sibling per_pupil_expenditure topic, from which each rating's rolling window is built.

Granularidad de fila: Una fila por year, district_code, school_code.

Métrica clave

fesr_star_rating — FESR Star Rating (rating, 0.5–5)

El valor principal que la mayoría de las consultas busca.

Esquema JSON →Contrato de datos (YAML) →

Variables

Todas las columnas de la tabla de hechos. El código es el nombre exacto del campo que devuelve la API.

Columna	Tipo	Unidad	Rango	¿Nulo?	Descripción
`year`Year	integer	—	—	no	Fiscal year the FESR publication treats as its newest (rated) year. Only publication years exist in this topic: 2016-2019 and 2024 for districts, 2017-2019 and 2024 for schools (the program paused FY2020-FY2023 — those years have no rows). Descripción completa▾ Fiscal year the FESR publication treats as its newest (rated) year. Only publication years exist in this topic: 2016-2019 and 2024 for districts, 2017-2019 and 2024 for schools (the program paused FY2020-FY2023 — those years have no rows).
`district_code`District Code	string	—	—	no	GOSA district/system code (FK to districts dimension), zero-padded to 3 digits (7-digit codes are charter authorizers, school rows only). District-detail rows cover the 180 traditional school systems (codes 601-793); school-detail rows additionally include charter authorizer codes. Populated on every row. Descripción completa▾ GOSA district/system code (FK to districts dimension), zero-padded to 3 digits (7-digit codes are charter authorizers, school rows only). District-detail rows cover the 180 traditional school systems (codes 601-793); school-detail rows additionally include charter authorizer codes. Populated on every row. Se une a districts; agrega sus columnas de etiqueta.
`school_code`School Code	string	—	—	yes	GOSA school code, zero-padded to 4 characters (composite FK to schools dimension with district_code; not globally unique on its own). Populated on school rows only — district aggregate rows carry NULL. Descripción completa▾ GOSA school code, zero-padded to 4 characters (composite FK to schools dimension with district_code; not globally unique on its own). Populated on school rows only — district aggregate rows carry NULL. Se une a schools; agrega sus columnas de etiqueta.
`per_pupil_expenditure_three_year_avg`Per Pupil Expenditure Three Year Average	number	currency	—	yes	Three-year rolling average per-pupil expenditure (nominal dollars) over the publication's window — a rating input. FY2024's window is non-contiguous (FY19+FY23+FY24). District rows every year; school rows 2019 and 2024 only (bronze PPE_Avg). The school values are the publisher's own rating inputs, NOT the mean of the per_pupil_expenditure topic's served yearly school values: the 2019 file computed them from restated FY2017/FY2018 figures the sibling's base-publication-wins merge deliberately does not serve, so 751 of 2,209 schools differ from the served three-year mean by more than $0.01 (max $2,613.60); the 2024 values equal the served FY19/FY23/FY24 mean (max difference $0.004). Extreme school values (up to $233,651) are tiny-enrollment schools, preserved as published. The yearly per-pupil values live in the sibling per_pupil_expenditure topic. Descripción completa▾ Three-year rolling average per-pupil expenditure (nominal dollars) over the publication's window — a rating input. FY2024's window is non-contiguous (FY19+FY23+FY24). District rows every year; school rows 2019 and 2024 only (bronze PPE_Avg). The school values are the publisher's own rating inputs, NOT the mean of the per_pupil_expenditure topic's served yearly school values: the 2019 file computed them from restated FY2017/FY2018 figures the sibling's base-publication-wins merge deliberately does not serve, so 751 of 2,209 schools differ from the served three-year mean by more than $0.01 (max $2,613.60); the 2024 values equal the served FY19/FY23/FY24 mean (max difference $0.004). Extreme school values (up to $233,651) are tiny-enrollment schools, preserved as published. The yearly per-pupil values live in the sibling per_pupil_expenditure topic.
`ccrpi_three_year_avg`CCRPI Three Year Average	number	score	≥ 0	yes	Three-year rolling average of the CCRPI Single Score (0-100 scale) over the publication's window — the academic-outcome input of the rating. District rows every year; school rows 2019 and 2024 only (bronze SS_Avg). The school values are the publisher's own inputs: the 2019 values rest on FY2017/FY2018 single scores that differ from ccrpi_scoring_by_component for 42 schools (61 school-year cells; max 25.3 points), and the 2024 values average FY2023/FY2024 school single scores no other served topic carries. Three 2019 school values overshoot 100 (100.2-101.1) because their FY2017 single score carried points-era bonus points (max 108.2, the same overshoot ccrpi_scoring_by_component serves); a quality check bounds the column to 0-100 everywhere else and to 110 on 2019 school rows. Descripción completa▾ Three-year rolling average of the CCRPI Single Score (0-100 scale) over the publication's window — the academic-outcome input of the rating. District rows every year; school rows 2019 and 2024 only (bronze SS_Avg). The school values are the publisher's own inputs: the 2019 values rest on FY2017/FY2018 single scores that differ from ccrpi_scoring_by_component for 42 schools (61 school-year cells; max 25.3 points), and the 2024 values average FY2023/FY2024 school single scores no other served topic carries. Three 2019 school values overshoot 100 (100.2-101.1) because their FY2017 single score carried points-era bonus points (max 108.2, the same overshoot ccrpi_scoring_by_component serves); a quality check bounds the column to 0-100 everywhere else and to 110 on 2019 school rows.
`per_pupil_expenditure_percentile`Per Pupil Expenditure Percentile	integer	percentile	—	yes	Percentile rank (1-100 integer) of the district's per_pupil_expenditure_three_year_avg among all 180 Georgia districts in the same publication — population-based, not a national percentile. Higher = more spending per pupil. District-detail rows only (enforced by a quality check); the only rolling metric never published at the school level. Descripción completa▾ Percentile rank (1-100 integer) of the district's per_pupil_expenditure_three_year_avg among all 180 Georgia districts in the same publication — population-based, not a national percentile. Higher = more spending per pupil. District-detail rows only (enforced by a quality check); the only rolling metric never published at the school level.
`fesr_star_rating`FESR Star Rating	number	rating	0.5–5	yes	Financial efficiency star rating, 0.5-5.0 in half-star steps — more stars mean better academic outcomes per dollar spent. Descripción completa▾ Financial Efficiency Star Rating in 0.5 increments. Districts: observed 1.0-5.0; schools: 0.5-5.0 (the value range spans both levels). Half-steps enforced by a quality check. Bronze stores it as Float64 in early files and as strings in later files; non-numeric publisher statuses (district 'Non-Compliant'; school '.', 'Non-Compliant[ in 20YY]') are NULLed here, with non-compliance preserved via is_non_compliant; the masked cells are ledgered per sentinel class in _transform_manifest.json masked_values (school: 103 '.' + 1 non-compliant in 2017, 127 '.' + 3 non-compliant in 2018; district: 1 non-compliant in 2018).
`is_non_compliant`Is Non Compliant	boolean	—	—	yes	True when the district or school was flagged non-compliant with financial reporting (no star rating issued); false otherwise — including rows the publisher listed without issuing a rating, so false does not guarantee a published rating. Descripción completa▾ FESR publication outcome: true when the source flags the entity non-compliant (no star rating exists, so fesr_star_rating is NULL — enforced by a quality check); false when the publisher processed the entity normally; NULL when no outcome was published. The false/NULL boundary is ERA-DEPENDENT, faithful to bronze (same behavior as the pre-split approved topic): the 2017/2018 school files publish an explicit status column, so rated rows AND the '.' listed-without-rating rows (103 in 2017, 127 in 2018) carry false; the 2019/2024 numeric school files publish no status, so rated rows carry NULL. A school's 2018-file 'Non-Compliant in 2017' sentinel is served on both the 2017 and 2018 rows (Cirrus Charter 7830611/0611), as the publisher restated it. Districts: the 2018 report's 'Non-Compliant' status (Talbot County 730). The FY2021 pause-year PPE-sentinel flag (7830629/0629) falls outside the publication years and is not carried (see limitations).

Filtros

Parámetros de consulta que acepta el endpoint de hechos. Los valores separados por comas son OR dentro de un parámetro; varios parámetros se combinan con AND.

Parámetro	Tipo	Valores permitidos	Notas
`year`	year_exact	cualquier valor	—
`year_min`	year_range	cualquier valor	—
`year_max`	year_range	cualquier valor	—
`detail`	detail	`districtsschools`	enum validado, predeterminado: schools
`district_code`	foreign_key	cualquier valor	valores múltiples
`school_code`	foreign_key	cualquier valor	valores múltiples
`is_non_compliant`	categorical	cualquier valor	valores múltiples
`district_type`	dimension_attribute	7 valores permitidos▾ `commission_charter` `resa` `standard` `state_agency` `state_charter` `state_school` `state_special`	valores múltiples, enum validado
`school_level`	dimension_attribute	`elementarymiddlehighk12other`	valores múltiples, enum validado
`locale`	dimension_attribute	`citysuburbtownrural`	valores múltiples, enum validado

Ejemplos de solicitudes

Ejecútalos contra la URL base: devuelven datos en vivo.

All rows (first page), schools level

curl "https://georgiacivicdata.org/api/v1/education/financial_efficiency_star_rating"

schools data for 2024

curl "https://georgiacivicdata.org/api/v1/education/financial_efficiency_star_rating?year=2024"

One district (code 657), 2024

curl "https://georgiacivicdata.org/api/v1/education/financial_efficiency_star_rating?district_code=657&year=2024&detail=districts"

Download 2024 as CSV

curl "https://georgiacivicdata.org/api/v1/education/financial_efficiency_star_rating?year=2024&format=csv"

Notas y limitaciones

Manejo de NULL

El cero es un valor real y reportado.

Limitaciones

Rows exist only for FESR publication years — district rows FY2016-FY2019 and FY2024, school rows FY2017-FY2019 and FY2024. GOSA paused the program FY2020-FY2023: those years have NO rows (they are not NULL-padded), and year-over-year comparisons across the pause span a five-year gap and a methodology revision (the FY2024 rating uses a non-contiguous FY19+FY23+FY24 window). Two detail levels (district, school) in one fact table, split by parquet filename; school_code is NULL on district rows. The rolling-window metrics are carried on district rows in every publication year; on school rows, per_pupil_expenditure_three_year_avg and ccrpi_three_year_avg are populated for the 2019 and 2024 reports only (the 2017/2018 school files publish no rolling averages) and per_pupil_expenditure_percentile never (district-only). The school averages are the publisher's own rating inputs and differ from what the sibling topics would reproduce — do not rebuild them from per_pupil_expenditure or ccrpi_scoring_by_component: the 2019 workbook computed both from its own restated FY2017/FY2018 school values, which the per_pupil_expenditure topic's base-publication-wins merge deliberately does not serve, so 751 of 2,209 schools' PPE averages differ from the served three-year mean by more than $0.01 (483 by more than $1, 38 by more than $100, 6 by more than $1,000; max $2,613.60), and 42 schools' CCRPI averages use single scores that differ from ccrpi_scoring_by_component (61 school-year cells; max 25.3 points); the 2024 workbook's PPE average does equal the served FY19/FY23/FY24 mean (max difference $0.004), but its CCRPI average rests on FY2023/FY2024 school single scores that no other served topic carries (this topic is their only served form). The state-local/federal split of the school PPE average is not carried (no rating input; it does not reconcile to the average). Report-year school rows with no rating-family fact at all are omitted (32 in 2019, 84 in 2024; their spending facts live in the per_pupil_expenditure topic), while schools listed with a three-year PPE average but no rating are kept (100 in 2019, 22 in 2024; fesr_star_rating and ccrpi_three_year_avg NULL). The single FY2021 pause-year non-compliance flag (school 7830629/0629) is not carried — it falls outside the publication-year row structure. The annual spending panel behind the ratings (expenditures, FTE enrollment, per-pupil expenditure, FY2014-FY2024) lives in the sibling per_pupil_expenditure topic; the former merged topic's ccrpi_single_score column was dropped from both derived topics in the v2 split (annual CCRPI scores are served by the ccrpi_* topics). FESR methodology evolved across publications; cross-year comparisons should account for GOSA-documented methodology drift. No cell-level small-cell suppression exists in this source; NULLs are structural, never suppression.