{"main_topic":"education","sub_topic":"gosa","topic":"certified_personnel_experience","key":"education/gosa/certified_personnel_experience","version":"1.0.0","year_min":2011,"year_max":2025,"year_gaps":[],"update_frequency":"annual","detail_levels":["districts","schools","states"],"default_detail":"schools","path_template":"education/certified_personnel_experience/year={year}/{detail}.parquet","grain":["year","district_code","school_code","employee_type"],"title":"Certified Personnel Years of Experience","summary":"Experience distribution of Georgia school staff -- headcounts in five experience bands plus mean years of experience for administrators, PK-12 teachers, and support personnel by school, district, and state, 2011-2025.","description":"Governor's Office of Education and Workforce Strategy (GOEWS, formerly GOSA) certified-personnel years-of-experience measures, compiled from local school systems' Certified/Classified Personnel Information (CPI) submissions. For every Georgia public school, for each school district (all but `799` State Schools in 2024-25; see limitations), and for the state as a whole, publishes the experience distribution of the certified-personnel roster for each of three employee groups (Administrators, PK-12 Teachers, Support Personnel): headcounts in five mutually exclusive experience bands (less than 1 year, 1-10, 11-20, 21-30, over 30 years) plus the mean years of experience. One row per school, district, or state per year for each employee group it reports staff in: a school or district that employs no certified staff in a group has no row for that group (about one school-year in seven lacks at least one), while the state rows always cover all three. Coverage runs from the 2010-11 school year through 2024-25. This is one of three topics derived from the same GOSA Certified Personnel source: `certified_personnel_composition` carries the staff headcount axes (certificate level, certification status, gender, employment status, race/ethnicity — including the total staff counts), and `certified_personnel_compensation` carries the FTE position counts and salary/contract-day measures.","explorer":true,"source":"Governor's Office of Education and Workforce Strategy (GOEWS, formerly GOSA)","source_url":"https://goews.georgia.gov/dashboards-data-report-card/downloadable-data","endpoint":"/api/v1/education/certified_personnel_experience","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Ending calendar year of the school year. Year 2024 = 2023-2024 school year. Derived from the bronze `LONG_SCHOOL_YEAR` column's ending 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":true,"label":"District Code","short_description":"","description":"GOSA district code (FK to the education districts dimension): 3-digit zero-padded for standard districts, 7-digit for state/commission charter schools (present from 2012 onward). NULL for state-level aggregate rows (the bronze sentinel `ALL`).","valid_values":null,"example":"644","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":"4-digit zero-padded GOSA school code (FK to the education schools dimension, composite key with district_code). NULL for district-level and state-level aggregate rows (the bronze sentinel `ALL`).","valid_values":null,"example":"0189","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"employee_type","type":"string","role":"categorical","nullable":false,"label":"Employee Type","short_description":"Which staff group the measurements cover: administrators, PK-12 teachers, or support personnel.","description":"Employee group this row's experience measures cover. Snake_case recode of bronze EMPLOYEE_TYPE: `administrators`, `pk_12_teachers`, `support_personnel`.","valid_values":["administrators","pk_12_teachers","support_personnel"],"example":"pk_12_teachers","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"num_staff_less_than_1_yr","type":"integer","role":"metric","nullable":false,"label":"Number Staff Less Than 1 Yr","short_description":"Headcount of staff with less than 1 year of experience.","description":"Whole-person headcount of staff in this employee group with less than 1 year of experience. One of five mutually exclusive experience bands (<1, 1-10, 11-20, 21-30, >30 years). The bands may be summed WITHIN a row to get the staff count reported in experience bands (at state level this can differ slightly from the totals of other staff attributes in the sibling certified_personnel_composition topic, so do not treat them as interchangeable), but school rows must never be summed to rebuild district or state counts (staff serving multiple schools are counted once per school assignment but deduplicated at higher levels). Zero counts are real (no suppression in this source).","valid_values":null,"example":12,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"num_staff_1_to_10_yr","type":"integer","role":"metric","nullable":false,"label":"Number Staff 1 to 10 Yr","short_description":"Headcount of staff with 1-10 years of experience.","description":"Whole-person headcount of staff in this employee group with 1 to 10 years of experience. One of five mutually exclusive experience bands (<1, 1-10, 11-20, 21-30, >30 years). The bands may be summed WITHIN a row to get the staff count reported in experience bands (at state level this can differ slightly from the totals of other staff attributes in the sibling certified_personnel_composition topic, so do not treat them as interchangeable), but school rows must never be summed to rebuild district or state counts (staff serving multiple schools are counted once per school assignment but deduplicated at higher levels). Zero counts are real (no suppression in this source).","valid_values":null,"example":45,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"num_staff_11_to_20_yr","type":"integer","role":"metric","nullable":false,"label":"Number Staff 11 to 20 Yr","short_description":"Headcount of staff with 11-20 years of experience.","description":"Whole-person headcount of staff in this employee group with 11 to 20 years of experience. One of five mutually exclusive experience bands (<1, 1-10, 11-20, 21-30, >30 years). The bands may be summed WITHIN a row to get the staff count reported in experience bands (at state level this can differ slightly from the totals of other staff attributes in the sibling certified_personnel_composition topic, so do not treat them as interchangeable), but school rows must never be summed to rebuild district or state counts (staff serving multiple schools are counted once per school assignment but deduplicated at higher levels). Zero counts are real (no suppression in this source).","valid_values":null,"example":30,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"num_staff_21_to_30_yr","type":"integer","role":"metric","nullable":false,"label":"Number Staff 21 to 30 Yr","short_description":"Headcount of staff with 21-30 years of experience.","description":"Whole-person headcount of staff in this employee group with 21 to 30 years of experience. One of five mutually exclusive experience bands (<1, 1-10, 11-20, 21-30, >30 years). The bands may be summed WITHIN a row to get the staff count reported in experience bands (at state level this can differ slightly from the totals of other staff attributes in the sibling certified_personnel_composition topic, so do not treat them as interchangeable), but school rows must never be summed to rebuild district or state counts (staff serving multiple schools are counted once per school assignment but deduplicated at higher levels). Zero counts are real (no suppression in this source).","valid_values":null,"example":15,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"num_staff_over_30_yr","type":"integer","role":"metric","nullable":false,"label":"Number Staff Over 30 Yr","short_description":"Headcount of staff with more than 30 years of experience.","description":"Whole-person headcount of staff in this employee group with more than 30 years of experience. One of five mutually exclusive experience bands (<1, 1-10, 11-20, 21-30, >30 years). The bands may be summed WITHIN a row to get the staff count reported in experience bands (at state level this can differ slightly from the totals of other staff attributes in the sibling certified_personnel_composition topic, so do not treat them as interchangeable), but school rows must never be summed to rebuild district or state counts (staff serving multiple schools are counted once per school assignment but deduplicated at higher levels). Zero counts are real (no suppression in this source).","valid_values":null,"example":4,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"avg_years_experience","type":"number","role":"metric","nullable":false,"label":"Average Years Experience","short_description":"Mean years of experience across the employee group's certified-personnel roster.","description":"Mean years of experience across this entity's certified-personnel roster for the employee group, in years (0.01 precision; observed range [0, 51] across all 15 source years, enforced to [0, 60] by a quality check). An ENTITY-LEVEL mean: never sum it across entities, and a state mean is not the sum (or simple average) of district means. Carries no `unit` marker — a mean in years fits none of the unit vocabulary values — and no `metric_component` counts: the source publishes no separate N for this mean. The five band columns summed within a row give the count reported in experience bands; source totals across measure families can differ (at state level by up to 0.26% in 2024-25), so do not use a sibling `certified_personnel_composition` total as this mean's denominator.","valid_values":null,"example":13.28,"unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"avg_years_experience","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":"This source has no suppression; a 0 is a real reported value. State rows have NULL district_code and school_code. District rows have NULL school_code. District rows are served where the source publishes them. For a single-school state charter (7-digit district code) whose district row the source omits, the district row is a copy of its one school row (6 charters in 2017-18, 2 in 2018-19, 29 in 2024-25); where the source does publish such a charter's district row, it equals the school row. `799` State Schools has school rows but no district row in 2024-25; its schools and the state rows are still served, and no other district row is built from school rows. A school or district has a row only for the employee groups it reports staff in (no row has zero staff in every band): 5,894 of 40,860 school-years and 72 of 3,145 district-years lack at least one of the three groups, so a missing group means no certified staff of that kind were reported there, not a suppressed row.","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,2025],"schema_hash":"167aeba533a2e79b1a38b4cd634e78b1061d882e30468b2bbdca88851e14dbae","tags":["education","governor's office of education and workforce strategy","certified_personnel_experience","goews","gosa"],"granularity_description":"One row per year, district_code, school_code, employee_type (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2025), schools detail","query":"SELECT * FROM certified_personnel_experience WHERE year = 2025 LIMIT 100"},{"description":"District 644 in 2025","query":"SELECT * FROM certified_personnel_experience WHERE district_code = '644' AND year = 2025 LIMIT 100"},{"description":"Filter by employee_type = pk_12_teachers","query":"SELECT * FROM certified_personnel_experience WHERE employee_type = 'pk_12_teachers' AND year = 2025 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","states"],"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":"employee_type","kind":"categorical","column":"employee_type","type":"string","multi_value":true,"enum_enforced":true,"values":["administrators","pk_12_teachers","support_personnel"],"has_total":false,"total_value":null,"requires_single_value":true,"nullable":false,"null_filter_token":null},{"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"]},{"param":"school_level","kind":"dimension_attribute","dimension":"schools","column":"school_level","type":"string","multi_value":true,"enum_enforced":true,"values":["elementary","middle","high","k12","other"]},{"param":"locale","kind":"dimension_attribute","dimension":"schools","column":"locale","type":"string","multi_value":true,"enum_enforced":true,"values":["city","suburb","town","rural"]}],"filter_hints":[],"non_additive":[{"column":"school_code","reason":"Staff serving several schools are counted once at each school but once in the district and state rows, so school rows can add up to more than the published district or state figure.","metrics":["num_staff_less_than_1_yr","num_staff_1_to_10_yr","num_staff_11_to_20_yr","num_staff_21_to_30_yr","num_staff_over_30_yr"]}],"value_implications":[],"year_meaning":null,"pooled_rates":[],"series_breaks":[],"values_endpoint":"/api/v1/education/certified_personnel_experience/values"}