District Salaries and Benefits

What Georgia school districts spend on salaries and benefits by staff category, with that spending as a share of district revenue and expenditures, 2011-2024.

Fuente: GOSA
Cobertura de años: 2011–2024
Actualización: annual
Versión: 1.1.0
Hash del esquema: ffaac60d83b2

Niveles de detalle disponibles

EstadoDistrito · predeterminado

Resumen

Salary and benefit expenditures for Georgia public school districts (with RESA service-agency aggregates and the official state rollup) by staff category — teachers and paraprofessionals, school administration, and general administration — plus those salary+benefit totals as a share of four district revenue and expenditure bases. The underlying district revenue and expenditure ledgers those shares are computed against are published in the `k12_revenues` (revenue by funding source) and `k12_expenditures` (expenditure by function) topics. Published by GOSA for school years 2010-11 through 2023-24.

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

Métrica clave

salaries_and_benefits — Salaries and Benefits (currency)

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	Ending (spring) calendar year of the school year (e.g. 2024 for 2023-24), parsed from the source's LONG_SCHOOL_YEAR and cross-checked against the filename. Descripción completa▾ Ending (spring) calendar year of the school year (e.g. 2024 for 2023-24), parsed from the source's LONG_SCHOOL_YEAR and cross-checked against the filename.
`district_code`District Code	string	—	—	yes	GOSA district code (FK to districts dimension): 3-digit zero-padded county/city codes or 7-digit state-charter codes. Codes 850-888 are the 16 Regional Education Service Agencies (RESAs) — service-agency aggregates kept at district detail (the dimension types them 'resa'); exclude them when analyzing traditional LEAs. NULL on state-level rows. Descripción completa▾ GOSA district code (FK to districts dimension): 3-digit zero-padded county/city codes or 7-digit state-charter codes. Codes 850-888 are the 16 Regional Education Service Agencies (RESAs) — service-agency aggregates kept at district detail (the dimension types them 'resa'); exclude them when analyzing traditional LEAs. NULL on state-level rows. Se une a districts; agrega sus columnas de etiqueta.
`school_code`School Code	string	—	—	yes	GOSA school code (composite FK to schools dimension with district_code). Always NULL in this district-only topic — the source reports no school-level detail (enforced by a quality check). Descripción completa▾ GOSA school code (composite FK to schools dimension with district_code). Always NULL in this district-only topic — the source reports no school-level detail (enforced by a quality check). Se une a schools; agrega sus columnas de etiqueta.
`staff_category`Staff Category	string	—	—	no	Which staff the dollars cover: teachers_and_paraprofessionals, school_administration, or general_administration (one row per category). Descripción completa▾ Staff category the row's salary and benefit dollars cover: teachers_and_paraprofessionals, school_administration (principals and school-level administrators), or general_administration (district-office administration). Every entity carries exactly one row per category per year. 3 valores permitidos▾ `general_administration` `school_administration` `teachers_and_paraprofessionals`
`salaries`Salaries	number	currency	—	yes	Total salary dollars paid for the staff category. Rare small negatives are real refunds/restatements published by the source and preserved (one 2024 row at -2,000.00); no range check applies. Descripción completa▾ Total salary dollars paid for the staff category. Rare small negatives are real refunds/restatements published by the source and preserved (one 2024 row at -2,000.00); no range check applies.
`benefits`Benefits	number	currency	—	yes	Total benefit dollars paid for the staff category. Rare small negatives are real refunds/restatements published by the source and preserved (one row each in 2011, 2012, and 2022; minimum -191,629.60); no range check applies. Descripción completa▾ Total benefit dollars paid for the staff category. Rare small negatives are real refunds/restatements published by the source and preserved (one row each in 2011, 2012, and 2022; minimum -191,629.60); no range check applies.
`salaries_and_benefits`Salaries and Benefits	number	currency	—	yes	Total salary plus benefit dollars the district spent on this staff category in the year. Descripción completa▾ Total salary plus benefit dollars for the staff category. Equals salaries + benefits within $1 in every row (source-published total; enforced by a quality check).
`pct_revenue_gf_title_lottery`Percent Revenue Gf Title Lottery	number	ratio	—	yes	Salaries+benefits for the category as a share of district revenue from General Fund / Title / Lottery sources (0-1 decimal scale; source publishes 0-100 and is divided by 100). A ratio, not a bounded proportion: the 2021 file (school year 2020-21, the COVID year) systematically publishes values above 1.0 — including the state rollup — with a maximum of 1.2346 (2021 values run ~2x adjacent years across all metrics; likely a two-year-cumulative publication); preserved as published. Descripción completa▾ Salaries+benefits for the category as a share of district revenue from General Fund / Title / Lottery sources (0-1 decimal scale; source publishes 0-100 and is divided by 100). A ratio, not a bounded proportion: the 2021 file (school year 2020-21, the COVID year) systematically publishes values above 1.0 — including the state rollup — with a maximum of 1.2346 (2021 values run ~2x adjacent years across all metrics; likely a two-year-cumulative publication); preserved as published.
`pct_revenue_total_k12`Percent Revenue Total K12	number	ratio	—	yes	Salaries+benefits for the category as a share of total district K-12 revenue (0-1 decimal scale; source publishes 0-100 and is divided by 100). The share is computed by GOSA against a total-revenue base that is NOT numerically reproducible from the `k12_revenues` topic (the implied base runs ~1.25-1.43x that ledger in every year), so do not divide this topic's dollars by that topic's totals. A ratio, not a bounded proportion: the 2021 file publishes values up to 1.0413 (2021 values run ~2x adjacent years across all metrics; likely a two-year-cumulative publication); preserved as published. Descripción completa▾ Salaries+benefits for the category as a share of total district K-12 revenue (0-1 decimal scale; source publishes 0-100 and is divided by 100). The share is computed by GOSA against a total-revenue base that is NOT numerically reproducible from the `k12_revenues` topic (the implied base runs ~1.25-1.43x that ledger in every year), so do not divide this topic's dollars by that topic's totals. A ratio, not a bounded proportion: the 2021 file publishes values up to 1.0413 (2021 values run ~2x adjacent years across all metrics; likely a two-year-cumulative publication); preserved as published.
`pct_expense_gf_title_lottery`Percent Expense Gf Title Lottery	number	ratio	—	yes	Salaries+benefits for the category as a share of district expenditures from General Fund / Title / Lottery funds (0-1 decimal scale; source publishes 0-100 and is divided by 100). A ratio, not a bounded proportion: the 2021 file systematically publishes values above 1.0 — the state Teachers and Paraprofessionals rollup is 1.0798 and the maximum is 1.2731 (2021 values run ~2x adjacent years across all metrics; likely a two-year-cumulative publication); preserved as published. Descripción completa▾ Salaries+benefits for the category as a share of district expenditures from General Fund / Title / Lottery funds (0-1 decimal scale; source publishes 0-100 and is divided by 100). A ratio, not a bounded proportion: the 2021 file systematically publishes values above 1.0 — the state Teachers and Paraprofessionals rollup is 1.0798 and the maximum is 1.2731 (2021 values run ~2x adjacent years across all metrics; likely a two-year-cumulative publication); preserved as published.
`pct_expense_total_k12`Percent Expense Total K12	number	ratio	—	yes	Salaries+benefits for the category as a share of total district K-12 expenditures (0-1 decimal scale; source publishes 0-100 and is divided by 100). The share is computed by GOSA against a total-expenditure base that is NOT numerically reproducible from the `k12_expenditures` topic (the implied base runs ~1.28-1.44x that ledger in every year), so do not divide this topic's dollars by that topic's totals. A ratio, not a bounded proportion: the 2021 file publishes values up to 1.2103 (2021 values run ~2x adjacent years across all metrics; likely a two-year-cumulative publication); preserved as published. Descripción completa▾ Salaries+benefits for the category as a share of total district K-12 expenditures (0-1 decimal scale; source publishes 0-100 and is divided by 100). The share is computed by GOSA against a total-expenditure base that is NOT numerically reproducible from the `k12_expenditures` topic (the implied base runs ~1.28-1.44x that ledger in every year), so do not divide this topic's dollars by that topic's totals. A ratio, not a bounded proportion: the 2021 file publishes values up to 1.2103 (2021 values run ~2x adjacent years across all metrics; likely a two-year-cumulative publication); preserved as published.

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	`districtsstates`	enum validado, predeterminado: districts
`district_code`	foreign_key	cualquier valor	valores múltiples
`school_code`	foreign_key	cualquier valor	valores múltiples
`staff_category`	categorical	`general_administrationschool_administrationteachers_and_paraprofessionals`	valores múltiples, enum validado, elige uno
`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), districts level

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

districts data for 2024

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

Filtered to staff_category = general_administration for 2024

curl "https://georgiacivicdata.org/api/v1/education/salaries_and_benefits?year=2024&staff_category=general_administration"

One district (code 601), 2024

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

Download 2024 as CSV

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

Notas y limitaciones

Manejo de NULL

El cero es un valor real y reportado.

Limitaciones

State rows have NULL district_code. school_code is always NULL — this is a district-only topic (no school-level detail exists at the source). District-detail rows include the 16 Regional Education Service Agencies (district codes 850-888), which are service-agency aggregates rather than school districts — exclude district_code between '850' and '888' when analyzing traditional LEAs. The published state row's composition changes in 2014: for 2011-2013 it equals the sum of ALL district-detail rows (RESAs and 7-digit state charters included, exact to floating-point), while from 2014 onward it equals the sum of traditional 3-digit districts only, excluding both the 850-888 RESAs and every 7-digit state-charter code (summing all district rows overshoots the state row by 2.6-4.7% in those years). The four pct_* columns are decimal ratios that legitimately exceed 1.0 in 2021 (school year 2020-21): category spending exceeded the chosen bases that year, up to 1.2731 — the 2021 file runs ~2x adjacent years across all metrics (dollars included), consistent with a two-year-cumulative publication. No suppression exists in this topic — NULL never means suppressed.