K-12 Expenditures by Spending Function

K-12 dollars spent by Georgia public schools and districts, broken out by spending function (instruction, transportation, administration, ...), 2011-2025.

Fuente: Governor's Office of Education and Workforce Strategy (GOEWS, formerly GOSA)
Cobertura de años: 2011–2025
Actualización: annual
Versión: 1.0.0
Hash del esquema: f87003f1c86b

Niveles de detalle disponibles

EstadoDistritoEscuela · predeterminado

Resumen

K-12 expenditures for every Georgia public school, school district, and the state as a whole, by spending function, published by the Governor's Office of Education and Workforce Strategy (GOEWS, formerly GOSA). Each row reports the total dollar amount and the per-FTE (full-time-equivalent student) dollar amount for one of 11 expenditure functions — instruction, pupil services, instructional support, school administration, general administration, maintenance and operations, transportation, media, school food services, debt services, and renovation and capital projects — covering school years 2010-11 through 2024-25. This is the full function-level spending ledger: all expenditures, broken out by function. The revenue side of the same report lives in the sibling topic `k12_revenues` (K-12 revenues by funding source, district/state detail); the two topics split the retired combined `revenues_and_expenditures` topic (one measure family per fact table) and share one bronze source, so they join cleanly on year and district_code. Distinct from the `per_pupil_expenditure` topic (FESR methodology), which is an included-cost per-pupil spending series whose totals intentionally differ from this full ledger.

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

Métrica clave

expenditure_amount — Expenditure Amount (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 SCHOOL_YEAR / LONG_SCHOOL_YEAR column and cross-checked against the filename year. Descripción completa▾ Ending (spring) calendar year of the school year (e.g. 2024 for 2023-24), parsed from the source's SCHOOL_YEAR / LONG_SCHOOL_YEAR column and cross-checked against the filename year.
`district_code`District Code	string	—	—	yes	GOSA district code (FK to districts dimension): 3-digit zero-padded county/city codes or 7-digit compound codes for commission / state charter schools. Codes 850-888 are RESA service agencies (typed 'resa' in the dimension): their district-level rollup rows are published 2011-2024 only (none in 2025); RESA codes also appear on school-detail rows for GNETS and other programs (2012, 2017, 2019-2025; in 2025 only there). NULL on state-level rows — the bronze sentinel 'ALL' is mapped to NULL. Descripción completa▾ GOSA district code (FK to districts dimension): 3-digit zero-padded county/city codes or 7-digit compound codes for commission / state charter schools. Codes 850-888 are RESA service agencies (typed 'resa' in the dimension): their district-level rollup rows are published 2011-2024 only (none in 2025); RESA codes also appear on school-detail rows for GNETS and other programs (2012, 2017, 2019-2025; in 2025 only there). NULL on state-level rows — the bronze sentinel 'ALL' is mapped to NULL. Se une a districts; agrega sus columnas de etiqueta.
`school_code`School Code	string	—	—	yes	4-digit zero-padded GOSA school code (composite FK to schools dimension with district_code). NULL on district- and state-level rows (bronze sentinel 'ALL' mapped to NULL). The 2012 file publishes a minority of codes as 3-digit; they are zero-padded to match the other years. 2023-2024 'DOE OTHER' rows (GNETS programs, alternative schools, Pre-K centers, central offices) carry real institution numbers and appear under the school detail level, matching where the pre-2023 files placed the same entities in the years that publish them (2011-2012, 2017, 2019-2022; the 2013-2016 and 2018 files publish traditional schools only). The 2025 file has no DOE OTHER level and labels the same entities School directly. Descripción completa▾ 4-digit zero-padded GOSA school code (composite FK to schools dimension with district_code). NULL on district- and state-level rows (bronze sentinel 'ALL' mapped to NULL). The 2012 file publishes a minority of codes as 3-digit; they are zero-padded to match the other years. 2023-2024 'DOE OTHER' rows (GNETS programs, alternative schools, Pre-K centers, central offices) carry real institution numbers and appear under the school detail level, matching where the pre-2023 files placed the same entities in the years that publish them (2011-2012, 2017, 2019-2022; the 2013-2016 and 2018 files publish traditional schools only). The 2025 file has no DOE OTHER level and labels the same entities School directly. Se une a schools; agrega sus columnas de etiqueta.
`expenditure_function`Expenditure Function	string	—	—	no	Spending function of the expenditure: instruction, pupil_services, transportation, school_administration, and 7 more. Descripción completa▾ Spending function of the expenditure (11 values): instruction, pupil_services, instructional_support, school_administration, general_administration, maintenance_and_operations, transportation, media, school_food_services, debt_services, and renovation_and_capital_projects. Every school, district and state row set carries all 11 functions in every year it appears (enforced by quality checks), so summing expenditure_amount over the 11 functions gives the entity's total expenditure. The bronze spelling 'School food Services' (lowercase food) is an upstream-report typo normalized to school_food_services. 11 valores permitidos▾ `debt_services` `general_administration` `instruction` `instructional_support` `maintenance_and_operations` `media` `pupil_services` `renovation_and_capital_projects` `school_administration` `school_food_services` `transportation`
`expenditure_amount`Expenditure Amount	number	currency	—	yes	Total dollars spent on this function at the row's level; negatives are real budget adjustments. Descripción completa▾ Total dollar amount spent on this expenditure function at the row's detail level. Never NULL (enforced by a quality check — the source publishes no suppression). Negative values are legitimate budget adjustments / corrections and are preserved; no range check applies. This is the full-ledger figure; it is NOT comparable to the FESR-methodology totals in the per_pupil_expenditure topic, which count only included costs.
`expenditure_per_pupil`Expenditure per Pupil	number	currency	—	yes	Per-FTE (full-time-equivalent student) dollar amount spent on this function. Can be negative (budget adjustments). NULL only in 2012-2014 where the bronze FTE denominator was missing or zero (475 rows; enforced by a quality check). Caution — not always a true per-pupil amount: in the 2024 file the source publishes expenditure_per_pupil equal to expenditure_amount verbatim on EVERY school-detail row (all 35,398 rows, traditional schools included), so 2024 school-level values carry no per-pupil information at all; in 2023 the same artifact covers all 9,526 DOE OTHER school rows plus 151 other nonzero school rows; in 2012 it covers the rows with a missing FTE_COUNT; in 2025 it covers 3,375 of the 18,228 nonzero school rows (890 entities: 825 non-traditional entities such as the former DOE OTHER programs, central offices and facilities, plus 65 schools with a grade span, e.g. Cass High School), while the other 14,853 nonzero 2025 school rows carry true per-FTE values; and in the other years that publish non-traditional entities it covers about 3,000 school rows a year, 90-95% of them on the non-traditional entities (school codes 6xxx-8xxx: central offices, facilities, programs), which carry it on nearly every nonzero row. On district and state rows the artifact is confined to the 16 RESA rollup district rows (codes 850-888; every nonzero RESA row in 2011-2012 and 2015-2024, NULL in 2013-2014, no RESA rows in 2025): standard-district, charter and state rows carry true per-FTE values in every year (enforced by a quality check). For a reliable school-level per-pupil spending series, use the per_pupil_expenditure topic (FESR methodology) instead; here, verify expenditure_per_pupil <> expenditure_amount (or sanity-check the magnitude) before treating a school-level value as per-pupil spending. Descripción completa▾ Per-FTE (full-time-equivalent student) dollar amount spent on this function. Can be negative (budget adjustments). NULL only in 2012-2014 where the bronze FTE denominator was missing or zero (475 rows; enforced by a quality check). Caution — not always a true per-pupil amount: in the 2024 file the source publishes expenditure_per_pupil equal to expenditure_amount verbatim on EVERY school-detail row (all 35,398 rows, traditional schools included), so 2024 school-level values carry no per-pupil information at all; in 2023 the same artifact covers all 9,526 DOE OTHER school rows plus 151 other nonzero school rows; in 2012 it covers the rows with a missing FTE_COUNT; in 2025 it covers 3,375 of the 18,228 nonzero school rows (890 entities: 825 non-traditional entities such as the former DOE OTHER programs, central offices and facilities, plus 65 schools with a grade span, e.g. Cass High School), while the other 14,853 nonzero 2025 school rows carry true per-FTE values; and in the other years that publish non-traditional entities it covers about 3,000 school rows a year, 90-95% of them on the non-traditional entities (school codes 6xxx-8xxx: central offices, facilities, programs), which carry it on nearly every nonzero row. On district and state rows the artifact is confined to the 16 RESA rollup district rows (codes 850-888; every nonzero RESA row in 2011-2012 and 2015-2024, NULL in 2013-2014, no RESA rows in 2025): standard-district, charter and state rows carry true per-FTE values in every year (enforced by a quality check). For a reliable school-level per-pupil spending series, use the per_pupil_expenditure topic (FESR methodology) instead; here, verify expenditure_per_pupil <> expenditure_amount (or sanity-check the magnitude) before treating a school-level value as per-pupil spending.

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	`districtsschoolsstates`	enum validado, predeterminado: schools
`district_code`	foreign_key	cualquier valor	valores múltiples
`school_code`	foreign_key	cualquier valor	valores múltiples
`expenditure_function`	categorical	11 valores permitidos▾ `debt_services` `general_administration` `instruction` `instructional_support` `maintenance_and_operations` `media` `pupil_services` `renovation_and_capital_projects` `school_administration` `school_food_services` `transportation`	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), schools level

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

schools data for 2025

curl "https://georgiacivicdata.org/api/v1/education/k12_expenditures?year=2025"

Filtered to expenditure_function = debt_services for 2025

curl "https://georgiacivicdata.org/api/v1/education/k12_expenditures?year=2025&expenditure_function=debt_services"

One district (code 644), 2025

curl "https://georgiacivicdata.org/api/v1/education/k12_expenditures?district_code=644&year=2025&detail=districts"

Download 2025 as CSV

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

Notas y limitaciones

Manejo de NULL

El cero es un valor real y reportado.

Limitaciones

State rows have NULL district_code and school_code; district rows have NULL school_code. The school detail level includes non-traditional entities (central offices, GNETS programs, Pre-K centers, maintenance/transportation facilities — school codes 6xxx-8xxx) only in 2011-2012, 2017 and 2019-2025 (~650 central-office/facility and ~200 program entities per year); the 2013-2016 and 2018 files publish traditional schools only (~2,260 entities), so school-level totals in those five years cover roughly 74-80% of the state total, do not sum to district totals, and are not comparable with the other years (state rows are complete in every year; district rows cover every entity with school rows except Talbot County (730), which is absent from the 2018 file entirely, so the 2018 state row excludes it too, three charters with school rows but no district row in 2018-2019 (7820618 in 2018; 7830620 and 7830621 in 2019), and the 2025 coverage change below). District detail includes the 16 RESA service-agency rollups (district codes 850-888) in 2011-2024 only (the 2025 file has none) — exclude the non-traditional school entities and the RESA rows when analyzing traditional schools/districts only. The 2025 file (2024-25) publishes fewer district rows: 203 district entities (180 standard districts + 23 single-school charters; 2024: 180 + 52 charters + 16 RESAs). 29 charters in the 2025 file (26 carried over from 2024, 3 new) and 34 RESA-coded entities (16 RESA central offices, 6 auxiliary facilities, 12 GNETS or academy programs) have school rows but no district row, and 3 of 2024's charters are absent from the file, so a charter's district-level series may end in 2024 and 2025 school-level sums exceed district sums (by 0.1-52% per function, 1.7% overall); no district rows are synthesized. expenditure_per_pupil is not a true per-pupil amount everywhere: the 2024 file publishes it equal to expenditure_amount on every school-detail row (traditional schools included — 2024 school-level per-FTE values are totals, not per-pupil amounts), the 2023 file does so on all DOE OTHER school rows plus 151 other nonzero school rows, the 2012 file on its missing-FTE rows, the 2025 file on 3,375 of its 18,228 nonzero school rows (890 entities, mostly non-traditional), the other years on most non-traditional school rows (school codes 6xxx-8xxx), and every year on the RESA district rows that carry a value (2011-2012, 2015-2024) — for a reliable school-level per-pupil spending series use the per_pupil_expenditure topic (FESR methodology) instead. State rows do not always equal the sum of all district rows within a function: in 2011-2013 the state row equals the sum of all district rows (within $0.47), but from 2014 on it equals the sum of the standard districts only, excluding the charter and RESA district rows, so a sum over all district rows overstates the state total (e.g. the 2014 renovation_and_capital_projects district sum runs about 5x the published state total, all of the excess charter spending; 2025 debt_services 1.34x) — exclude charters and RESAs to reconcile to the state row from 2014 on, and otherwise treat each detail level as its own published series. This topic is the full function-level ledger; its totals intentionally differ from the FESR included-cost figures in per_pupil_expenditure. No suppression exists in this topic — NULL never means suppressed; the only NULL metric values are 475 expenditure_per_pupil rows in 2012-2014 with a missing/zero FTE denominator. Negative dollar values are legitimate budget adjustments and are preserved.