{"main_topic":"education","sub_topic":"gosa","topic":"financial_efficiency_star_rating","key":"education/gosa/financial_efficiency_star_rating","version":"1.0.0","year_min":2014,"year_max":2024,"year_gaps":[],"update_frequency":"annual","detail_levels":["districts","schools"],"default_detail":"schools","path_template":"education/financial_efficiency_star_rating/year={year}/{detail}.parquet","grain":["year","district_code","school_code"],"title":"Financial Efficiency Star Rating (FESR)","summary":"Per-pupil spending, CCRPI scores, and 0.5-5 financial efficiency star ratings for Georgia school districts and schools, 2014-2024.","description":"Georgia Office of Student Achievement (GOSA) Financial Efficiency Star Rating (FESR) dataset at two detail levels in one fact table: district (one row per traditional Georgia school system, FY2014-FY2024) and school (one row per school, FY2017-FY2024). Reports per-pupil expenditure (PPE) inputs — total, federal, and state/local — full-time-equivalent K-12 enrollment, a CCRPI-derived annual Single Score, and the FESR star rating (0.5-5.0 in 0.5 increments). District rows additionally carry the federal vs state/local split of total expenditures, three-year rolling PPE and Single Score averages, and a PPE percentile rank; school rows additionally carry the pre-allocation included/excluded expenditure split and the school's share of district enrollment. Coverage in tidy long form, one row per (district[, school], fiscal year). FESR and the rolling metrics are populated only on the fiscal year each publishing report treats as its newest year (FY2016-FY2019, FY2024 for districts; FY2017-FY2019, FY2024 for schools); GOSA paused the program 2020-2023. Merges the formerly separate financial_efficiency_star_rating_fesr_district and financial_efficiency_star_rating_fesr_school topics.","source":"Governor's Office of Student Achievement (GOSA)","source_url":"https://gosa.georgia.gov/dashboards-data-report-card/downloadable-data","endpoint":"/api/v1/education/financial_efficiency_star_rating","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Fiscal year the row's PPE inputs refer to (e.g. FY2024 = 2023-24 school year). Differs from the bronze filename year for back-window rows: each rolling report covers up to 3 fiscal years, but gold keys every row by the actual fiscal 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":false,"label":"District Code","short_description":"","description":"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.","valid_values":null,"example":"657","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":"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.","valid_values":null,"example":"0103","unit":null,"value_min":null,"value_max":null,"null_meaning":"Populated only on school-detail rows; NULL on every district-detail row (the district level has no school code). The geography-key NULL pattern is how detail level is read from the unioned table.","key_metric_grain_contributor":false,"metric_component":null},{"name":"total_expenditures","type":"number","role":"metric","nullable":true,"label":"Total Expenditures","short_description":"","description":"Total expenditures for the fiscal year (nominal dollars, not inflation-adjusted). For DISTRICT rows this is the district's total included expenditures (= federal_expenditures + state_local_expenditures within $1, enforced by a quality check). For SCHOOL rows this is the per-school total — included expenditures plus the school's allocated share of district central costs (= total_federal_expenditures + total_state_local_expenditures within $10; from FY22 also folds in Allocated CCA and Alternative Program costs, so FY22+ school totals are not strictly comparable to FY17-FY21). per_pupil_expenditure = total_expenditures / fte_enrollment at both levels.","valid_values":null,"example":8125000.0,"unit":"currency","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"fte_enrollment","type":"integer","role":"metric","nullable":true,"label":"FTE Enrollment","short_description":"","description":"Full-time-equivalent K-12 enrollment, the denominator of per_pupil_expenditure (per_pupil_expenditure = total_expenditures / fte_enrollment within rounding at both detail levels, enforced by a quality check).","valid_values":null,"example":984,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":"denominator"},{"name":"per_pupil_expenditure","type":"number","role":"metric","nullable":true,"label":"Per-Pupil Expenditure","short_description":"Total dollars spent per student for the fiscal year (nominal, not inflation-adjusted).","description":"Per-pupil expenditure for the fiscal year (nominal dollars) = total_expenditures / fte_enrollment, as published (rounded to cents by the source). A few Atlanta (district 660) school rows in FY21/FY22 are negative — faithful GOSA restatements preserved per §4b, not errors.","valid_values":null,"example":9349.52,"unit":"currency","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"federal_per_pupil_expenditure","type":"number","role":"metric","nullable":true,"label":"Federal per Pupil Expenditure","short_description":"","description":"Federal portion of per_pupil_expenditure (nominal dollars). federal_per_pupil_expenditure + state_local_per_pupil_expenditure = per_pupil_expenditure within rounding (enforced by a quality check). NULL for district FY2014.","valid_values":null,"example":578.3,"unit":"currency","value_min":null,"value_max":null,"null_meaning":"NULL for district FY2014 (the 2016 workbook, the only source covering FY14, published no federal/state-local breakdown).","key_metric_grain_contributor":false,"metric_component":null},{"name":"state_local_per_pupil_expenditure","type":"number","role":"metric","nullable":true,"label":"State Local per Pupil Expenditure","short_description":"","description":"State + local portion of per_pupil_expenditure (nominal dollars). NULL for district FY2014.","valid_values":null,"example":8771.22,"unit":"currency","value_min":null,"value_max":null,"null_meaning":"NULL for district FY2014 (no breakdown published).","key_metric_grain_contributor":false,"metric_component":null},{"name":"federal_expenditures","type":"number","role":"metric","nullable":true,"label":"Federal Expenditures","short_description":"","description":"Federal portion of the district's total_expenditures (nominal dollars). District-detail rows only. The school-level analogue of this quantity is total_federal_expenditures (both split the shared total_expenditures column); they are kept as separate columns because the school download names them differently and additionally publishes the pre-allocation included_* split, which districts do not.","valid_values":null,"example":5542000.0,"unit":"currency","value_min":null,"value_max":null,"null_meaning":"Populated on DISTRICT rows only (NULL on every school row — schools instead publish total_federal_expenditures, the same federal share of total_expenditures, plus the distinct included_federal_expenditures pre-allocation split). Also NULL for district FY2014, whose only source published totals without a breakdown.","key_metric_grain_contributor":false,"metric_component":null},{"name":"state_local_expenditures","type":"number","role":"metric","nullable":true,"label":"State Local Expenditures","short_description":"","description":"State + local portion of the district's total_expenditures (nominal dollars). District-detail rows only; the school-level analogue is total_state_local_expenditures.","valid_values":null,"example":79501000.0,"unit":"currency","value_min":null,"value_max":null,"null_meaning":"Populated on DISTRICT rows only (NULL on every school row — schools publish total_state_local_expenditures instead). Also NULL for district FY2014 (no breakdown).","key_metric_grain_contributor":false,"metric_component":null},{"name":"included_expenditures","type":"number","role":"metric","nullable":true,"label":"Included Expenditures","short_description":"","description":"Total included expenditures for the school (nominal dollars), BEFORE allocation of district central costs — the school's total_expenditures equals included_expenditures plus its allocated central-cost share. School-detail rows only. Placeholder $0 values on unreported/non-compliant FY17-FY18 rows are NULLed per §4b (see limitations).","valid_values":null,"example":7413403.4,"unit":"currency","value_min":null,"value_max":null,"null_meaning":"Populated on SCHOOL rows only (NULL on every district row — the district download has no pre-allocation included split; a district's total_expenditures IS its included total).","key_metric_grain_contributor":false,"metric_component":null},{"name":"included_federal_expenditures","type":"number","role":"metric","nullable":true,"label":"Included Federal Expenditures","short_description":"","description":"Federal portion of the school's included_expenditures (nominal dollars). included_federal_expenditures + included_state_local_expenditures = included_expenditures (exact in the canonical bronze blocks; enforced by a quality check). School-detail rows only. FY17-FY18 placeholder $0 values NULLed per §4b.","valid_values":null,"example":456789.0,"unit":"currency","value_min":null,"value_max":null,"null_meaning":"Populated on SCHOOL rows only (NULL on district rows).","key_metric_grain_contributor":false,"metric_component":null},{"name":"included_state_local_expenditures","type":"number","role":"metric","nullable":true,"label":"Included State Local Expenditures","short_description":"","description":"State + local portion of the school's included_expenditures (nominal dollars). School-detail rows only. FY17-FY18 placeholder $0 values NULLed per §4b.","valid_values":null,"example":6956614.4,"unit":"currency","value_min":null,"value_max":null,"null_meaning":"Populated on SCHOOL rows only (NULL on district rows).","key_metric_grain_contributor":false,"metric_component":null},{"name":"excluded_expenditures","type":"number","role":"metric","nullable":true,"label":"Excluded Expenditures","short_description":"","description":"Expenditures excluded from the PPE computation (nominal dollars) per the FESR methodology. NOT a component of total_expenditures (totals = included + allocated central costs). School-detail rows only. A few rows per year carry negative values — faithful GOSA restatements preserved per §4b. FY17-FY18 placeholder $0 values NULLed per §4b.","valid_values":null,"example":120000.0,"unit":"currency","value_min":null,"value_max":null,"null_meaning":"Populated on SCHOOL rows only (NULL on district rows).","key_metric_grain_contributor":false,"metric_component":null},{"name":"total_federal_expenditures","type":"number","role":"metric","nullable":true,"label":"Total Federal Expenditures","short_description":"","description":"Federal portion of the school's total_expenditures (post-allocation; nominal dollars). The school-level analogue of the district's federal_expenditures (both split the shared total_expenditures). School-detail rows only. FY17-FY18 placeholder $0 values NULLed per §4b.","valid_values":null,"example":500000.0,"unit":"currency","value_min":null,"value_max":null,"null_meaning":"Populated on SCHOOL rows only (NULL on district rows — the district analogue is federal_expenditures).","key_metric_grain_contributor":false,"metric_component":null},{"name":"total_state_local_expenditures","type":"number","role":"metric","nullable":true,"label":"Total State Local Expenditures","short_description":"","description":"State + local portion of the school's total_expenditures (post-allocation; nominal dollars). School-detail rows only; the district analogue is state_local_expenditures. FY17-FY18 placeholder $0 values NULLed per §4b.","valid_values":null,"example":7625000.0,"unit":"currency","value_min":null,"value_max":null,"null_meaning":"Populated on SCHOOL rows only (NULL on district rows — the district analogue is state_local_expenditures).","key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_of_district_enrollment","type":"number","role":"metric","nullable":true,"label":"Percent of District Enrollment","short_description":"","description":"The school's share of its district's total enrollment, 0-1 decimal (0.2912 = 29.12%), used by the FESR methodology to allocate district central costs. School-detail rows only. Caveat: within-district sums are not a strict partition — they exceed 1.0 in 55 district-years (up to 1.82), faithful to bronze.","valid_values":null,"example":0.2912,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Populated on SCHOOL rows only (NULL on district rows). Also NULL for charter/excluded schools outside the district rollup.","key_metric_grain_contributor":false,"metric_component":null},{"name":"ccrpi_single_score","type":"number","role":"metric","nullable":true,"label":"CCRPI Single Score","short_description":"","description":"CCRPI-derived annual Single Score, preserved as published (a GOSA score, not a rate). Typically a 0-100 scale; FY17 school scores may exceed 100 due to early-CCRPI challenge-point scoring (29 rows reach ~108.2), so no upper bound is enforced (a negative score is impossible — enforced). NULL for FY2020-FY2022 (program pause).","valid_values":null,"example":76.2,"unit":"score","value_min":null,"value_max":null,"null_meaning":"NULL for FY2020-FY2022 (CCRPI paused). For schools, also NULL for FY17/FY18 schools absent from the 2019 file (the only file carrying their score). For districts, populated on every fiscal year a workbook covers except the pause.","key_metric_grain_contributor":false,"metric_component":null},{"name":"per_pupil_expenditure_three_year_avg","type":"number","role":"metric","nullable":true,"label":"Per Pupil Expenditure Three Year Average","short_description":"","description":"Three-year rolling average of per_pupil_expenditure (nominal dollars), attributed to the publishing district report's newest fiscal year (FY2016, FY2017, FY2018, FY2019, FY2024) and NULL elsewhere. FY2024's window is non-contiguous (FY19+FY23+FY24). District-detail rows only. C-1 rename of the former ppe_three_year_avg.","valid_values":null,"example":9024.04,"unit":"currency","value_min":null,"value_max":null,"null_meaning":"Populated on DISTRICT report-year rows only (FY2016-FY2019, FY2024); NULL on every school row and on non-report-year district rows. Schools do not publish rolling averages (derivable from yearly values).","key_metric_grain_contributor":false,"metric_component":null},{"name":"ccrpi_three_year_avg","type":"number","role":"metric","nullable":true,"label":"CCRPI Three Year Average","short_description":"","description":"Three-year rolling average of ccrpi_single_score (0-100 scale), attributed to district report-year rows only (see per_pupil_expenditure_three_year_avg). District-detail rows only.","valid_values":null,"example":71.2,"unit":"score","value_min":0,"value_max":100,"null_meaning":"Populated on DISTRICT report-year rows only (FY2016-FY2019, FY2024); NULL on every school row and on non-report-year district rows.","key_metric_grain_contributor":false,"metric_component":null},{"name":"per_pupil_expenditure_percentile","type":"integer","role":"metric","nullable":true,"label":"Per Pupil Expenditure Percentile","short_description":"","description":"Percentile rank (1-100 integer) of the district's per_pupil_expenditure_three_year_avg among all 180 Georgia districts in the same report — population-based, not a national percentile. Higher = more spending per pupil. District report-year rows only. C-1 rename of the former ppe_percentile.","valid_values":null,"example":76,"unit":"percentile","value_min":null,"value_max":null,"null_meaning":"Populated on DISTRICT report-year rows only (FY2016-FY2019, FY2024); NULL on every school row and on non-report-year district rows.","key_metric_grain_contributor":false,"metric_component":null},{"name":"fesr_star_rating","type":"number","role":"metric","nullable":true,"label":"FESR Star Rating","short_description":"","description":"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). Populated only on report-year rows; 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.","valid_values":null,"example":3.5,"unit":"rating","value_min":0.5,"value_max":5,"null_meaning":"Populated only on the fiscal year each publishing report treats as its newest year (district: FY2016-FY2019, FY2024; school: FY2017-FY2019, FY2024); NULL during the FY2020-FY2023 program pause, off report years, and where the publisher issued a 'Non-Compliant' status or no rating instead (is_non_compliant=true or, for schools, the `.` sentinel).","key_metric_grain_contributor":false,"metric_component":null},{"name":"is_non_compliant","type":"boolean","role":"categorical","nullable":true,"label":"Is Non Compliant","short_description":"True when the district or school was flagged non-compliant with financial reporting (no star rating issued); false when a rating was published.","description":"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 a numeric rating was published; NULL when no FESR outcome was published. Districts: the 2018 report's 'Non-Compliant' status (Talbot County 730). Schools: FY17/FY18 string sentinels, the FY19 note (Cirrus Charter, 7830611/0611), and the FY21 PPE sentinel (7830629/0629).","valid_values":null,"example":false,"unit":null,"value_min":null,"value_max":null,"null_meaning":"NULL wherever no FESR compliance outcome was published — all non-report-year rows, the FY2020-FY2023 pause, and the numeric-FESR school files (2019/2024) that publish ratings without a flag.","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"per_pupil_expenditure","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":"Two detail levels (district, school) in one fact table, split by parquet filename; school_code is NULL on district rows. Detail level is read from the geography-key NULL pattern. The district level covers FY2014-FY2024 (180 traditional systems, codes 601-793, no charters/RESAs/state agencies); the school level covers FY2017-FY2024 (all schools, including charter authorizers). School-level and district-level rows come from two independent GOSA downloads whose K-12 bases need not reconcile, so school rows are NOT guaranteed to sum to their district row. Level-specific columns are NULL on the other level: federal_expenditures / state_local_expenditures and the three rolling/percentile metrics are district-only; included_* / excluded_expenditures / total_federal_expenditures / total_state_local_expenditures / pct_of_district_enrollment are school-only. The district federal_expenditures and the school total_federal_expenditures are the same federal share of total_expenditures but are kept as separate columns (different source naming; schools also publish the distinct pre-allocation included_* split). fesr_star_rating and the rolling/percentile metrics are populated only on the report-year row of each rolling-window publication; GOSA paused the program FY2020-FY2023 (those years carry only PPE inputs), and ccrpi_single_score is additionally NULL for FY2020-FY2022 (CCRPI paused). District federal/state-local breakdowns are NULL for FY2014 (the only source covering FY14 published totals only). FY2022 methodology change: from FY22 school total_expenditures (and per_pupil_expenditure) additionally include Allocated CCA and Alternative Program costs, so FY22+ school totals are not strictly comparable to FY17-FY21. Placeholder $0 school expenditure amounts on unreported/non-compliant FY17-FY18 rows are NULLed per §4b (see _transform_manifest.json masked_values). A small number of district 660 (Atlanta) school rows carry negative expenditure / per-pupil values — faithful GOSA restatements preserved as-is. Currency is nominal dollars (not inflation-adjusted). No cell-level small-cell suppression exists in this source; NULLs are structural or §4b masks, never suppression.","null_semantics":{"suppressed_to_null":false,"zero_is_real":true},"available_years":[2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024],"schema_hash":"96d511f347d1505c43c50ae6e91e75eec709ff0156989aa08ea36de219267f3d","tags":["education","governor's office of student achievement","financial_efficiency_star_rating"],"granularity_description":"One row per year, district_code, school_code (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2024), schools detail","query":"SELECT * FROM financial_efficiency_star_rating WHERE year = 2024 LIMIT 100"},{"description":"District 657 in 2024","query":"SELECT * FROM financial_efficiency_star_rating WHERE district_code = '657' AND year = 2024 LIMIT 100"},{"description":"Filter by is_non_compliant = False","query":"SELECT * FROM financial_efficiency_star_rating WHERE is_non_compliant = 'False' 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":["districts","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":"is_non_compliant","kind":"categorical","column":"is_non_compliant","type":"boolean","multi_value":true,"enum_enforced":false,"values":null,"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"]}],"filter_hints":[]}