K-12 Revenues by Funding Source

K-12 dollars taken in by Georgia public school districts, broken out by funding source (local, federal, state QBE, lottery, other), 2011-2024.

Fuente: Governor's Office of Student Achievement (GOSA)
Cobertura de años: 2011–2024
Actualización: annual
Versión: 1.0.0
Hash del esquema: 4907a5512e84

Niveles de detalle disponibles

EstadoDistrito · predeterminado

Resumen

K-12 revenues for every Georgia public school district and the state as a whole, by funding source, published by the Governor's Office of Student Achievement (GOSA). Each row reports the total dollar amount and the per-FTE (full-time-equivalent student) dollar amount for one of 6 revenue sources — local, federal, state QBE (Quality Basic Education formula), state lottery, state other, and other — covering school years 2010-11 through 2023-24. District and state detail only: the source never publishes school-level revenues. The spending side of the same GOSA report lives in the sibling topic `k12_expenditures` (K-12 expenditures by spending function, school detail included); 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.

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

Métrica clave

revenue_amount — Revenue 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). 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). 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	Always NULL: the source publishes revenues at district and state detail only — there are no school-level revenue rows in any year (enforced by a quality check and a transform-time assertion). The column exists so every education fact table shares the same key-column shape. For school-level finance, see the sibling topic k12_expenditures (expenditures only). Descripción completa▾ Always NULL: the source publishes revenues at district and state detail only — there are no school-level revenue rows in any year (enforced by a quality check and a transform-time assertion). The column exists so every education fact table shares the same key-column shape. For school-level finance, see the sibling topic k12_expenditures (expenditures only). Se une a schools; agrega sus columnas de etiqueta.
`revenue_source`Revenue Source	string	—	—	no	Funding source of the revenue: local, federal, state_qbe, state_lottery, state_other, or other. Descripción completa▾ Funding source of the revenue (6 values): local (local taxes and other local funds), federal, state_qbe (Georgia's Quality Basic Education formula allotment), state_lottery, state_other (state funds outside QBE and lottery), and other. NOTE: state_lottery revenue_amount is published as 0.0 on every row of every year in this source (lottery dollars evidently flow outside this ledger) — the category is kept for grid completeness, faithful to bronze. Every district and state row set carries all 6 sources in every year (enforced by quality checks), so summing revenue_amount over the 6 sources gives the entity's total revenue. 6 valores permitidos▾ `federal` `local` `other` `state_lottery` `state_other` `state_qbe`
`revenue_amount`Revenue Amount	number	currency	—	yes	Total dollars received from this revenue source at the row's level; negatives are real budget adjustments. Descripción completa▾ Total dollar amount received from this revenue source 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.
`revenue_per_pupil`Revenue per Pupil	number	currency	—	yes	Per-FTE (full-time-equivalent student) dollar amount received from this revenue source. Can be negative (budget adjustments). NULL only in 2013-2014 where the bronze FTE denominator was missing (192 district rows; enforced by a quality check). Caution — not always a true per-pupil amount: the 16 RESA service-agency district rows (codes 850-888, no FTE denominator) publish revenue_per_pupil equal to revenue_amount verbatim in EVERY year including 2023-2024 (all 438 nonzero verbatim rows across all years are exactly those RESAs). Standard-district and state rows carry true per-FTE values. Verify revenue_per_pupil <> revenue_amount (or sanity-check the magnitude) before treating a value as per-pupil revenue. Descripción completa▾ Per-FTE (full-time-equivalent student) dollar amount received from this revenue source. Can be negative (budget adjustments). NULL only in 2013-2014 where the bronze FTE denominator was missing (192 district rows; enforced by a quality check). Caution — not always a true per-pupil amount: the 16 RESA service-agency district rows (codes 850-888, no FTE denominator) publish revenue_per_pupil equal to revenue_amount verbatim in EVERY year including 2023-2024 (all 438 nonzero verbatim rows across all years are exactly those RESAs). Standard-district and state rows carry true per-FTE values. Verify revenue_per_pupil <> revenue_amount (or sanity-check the magnitude) before treating a value as per-pupil revenue.

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
`revenue_source`	categorical	`federallocalotherstate_lotterystate_otherstate_qbe`	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/k12_revenues"

districts data for 2024

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

Filtered to revenue_source = federal for 2024

curl "https://georgiacivicdata.org/api/v1/education/k12_revenues?year=2024&revenue_source=federal"

One district (code 644), 2024

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

Download 2024 as CSV

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

Notas y limitaciones

Manejo de NULL

El cero es un valor real y reportado.

Limitaciones

District and state detail only — the source never publishes school-level revenues, so school_code is always NULL (school-level finance exists only on the expenditure side; see the sibling topic k12_expenditures). State rows have NULL district_code and school_code. District detail includes the 16 RESA service-agency rollups (district codes 850-888) — exclude them when analyzing traditional districts only. State rows are published independently of district rows and do not always equal the sum of district values within a source — treat each detail level as its own published series. revenue_per_pupil is not a true per-pupil amount everywhere: a few dozen district rows per year publish it equal to revenue_amount verbatim (entities with no FTE denominator, mostly RESA rollups). No suppression exists in this topic — NULL never means suppressed; the only NULL metric values are 192 revenue_per_pupil district rows in 2013-2014 with a missing FTE denominator. Negative dollar values are legitimate budget adjustments and are preserved.