{"main_topic":"education","sub_topic":"gosa","topic":"salaries_and_benefits","key":"education/gosa/salaries_and_benefits","version":"1.0.0","year_min":2011,"year_max":2024,"year_gaps":[],"update_frequency":"annual","detail_levels":["districts","states"],"default_detail":"districts","path_template":"education/salaries_and_benefits/year={year}/{detail}.parquet","grain":["year","district_code","school_code","staff_category"],"title":"District Salaries and Benefits","summary":"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.","description":"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. Published by GOSA for school years 2010-11 through 2023-24.","source":"GOSA","source_url":"https://gosa.georgia.gov/dashboards-data-report-card/downloadable-data","endpoint":"/api/v1/education/salaries_and_benefits","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"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.","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":true,"label":"District Code","short_description":"","description":"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.","valid_values":null,"example":"601","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 (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).","valid_values":null,"example":null,"unit":null,"value_min":null,"value_max":null,"null_meaning":"Always NULL — this topic publishes no school-level rows; the column exists so every education fact table shares the same key shape.","key_metric_grain_contributor":false,"metric_component":null},{"name":"staff_category","type":"string","role":"categorical","nullable":false,"label":"Staff Category","short_description":"Which staff the dollars cover: teachers_and_paraprofessionals, school_administration, or general_administration (one row per category).","description":"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.","valid_values":["general_administration","school_administration","teachers_and_paraprofessionals"],"example":"teachers_and_paraprofessionals","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"salaries","type":"number","role":"metric","nullable":true,"label":"Salaries","short_description":"","description":"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.","valid_values":null,"example":6204400.0,"unit":"currency","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"benefits","type":"number","role":"metric","nullable":true,"label":"Benefits","short_description":"","description":"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.","valid_values":null,"example":3059444.0,"unit":"currency","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"salaries_and_benefits","type":"number","role":"metric","nullable":true,"label":"Salaries and Benefits","short_description":"Total salary plus benefit dollars the district spent on this staff category in the year.","description":"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).","valid_values":null,"example":9263900.0,"unit":"currency","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_revenue_gf_title_lottery","type":"number","role":"metric","nullable":true,"label":"Percent Revenue Gf Title Lottery","short_description":"","description":"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, because category spending exceeded the GF/Title/Lottery revenue base that year; preserved as published.","valid_values":null,"example":0.4183,"unit":"ratio","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_revenue_total_k12","type":"number","role":"metric","nullable":true,"label":"Percent Revenue Total K12","short_description":"","description":"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). 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.","valid_values":null,"example":0.3727,"unit":"ratio","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_expense_gf_title_lottery","type":"number","role":"metric","nullable":true,"label":"Percent Expense Gf Title Lottery","short_description":"","description":"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.","valid_values":null,"example":0.4558,"unit":"ratio","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"pct_expense_total_k12","type":"number","role":"metric","nullable":true,"label":"Percent Expense Total K12","short_description":"","description":"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). 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.","valid_values":null,"example":0.4058,"unit":"ratio","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"salaries_and_benefits","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":"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, and do not sum district rows to reproduce the state rollup without accounting for them. 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.","null_semantics":{"suppressed_to_null":false,"zero_is_real":true},"available_years":[2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024],"schema_hash":"ffaac60d83b2d20322b3c674737f23db80fbe61eabbf8d3c1b9d39848a5a7629","tags":["education","gosa","salaries_and_benefits"],"granularity_description":"One row per year, district_code, school_code, staff_category (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2024), districts detail","query":"SELECT * FROM salaries_and_benefits WHERE year = 2024 LIMIT 100"},{"description":"District 601 in 2024","query":"SELECT * FROM salaries_and_benefits WHERE district_code = '601' AND year = 2024 LIMIT 100"},{"description":"Filter by staff_category = teachers_and_paraprofessionals","query":"SELECT * FROM salaries_and_benefits WHERE staff_category = 'teachers_and_paraprofessionals' 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","states"],"default":"districts"},{"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":"staff_category","kind":"categorical","column":"staff_category","type":"string","multi_value":true,"enum_enforced":true,"values":["general_administration","school_administration","teachers_and_paraprofessionals"],"has_total":false,"total_value":null,"requires_single_value":true},{"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":[]}