education

Georgia Office of Student Achievement (GOSA) certified-personnel years-of-experience measures, compiled from local schoo

Georgia Office of Student Achievement (GOSA) certified-personnel years-of-experience measures, compiled from local school systems' Certified/Classified Personnel Information (CPI) submissions. For every Georgia public school, school district, and 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 employee group per year; coverage runs from the 2010-11 school year through 2023-24. 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.

Filterable categorical columns (comma-separated values union; multiple columns AND together):

  • employee_type — one of: administrators, pk_12_teachers, support_personnel

Detail levels available: districts, schools, states (default: schools)

Year coverage: 2011–2024 (14 years, no gaps)

NULL handling: zero is a real value.

Source: Governor's Office of Student Achievement (GOSA)

get/api/v1/education/certified_personnel_experience

Request

  • Base URL: https://georgiacivicdata.org
  • URL: https://georgiacivicdata.org/api/v1/education/certified_personnel_experience
  • Auth: none declared

Query parameters

yearinteger nullable

Exact year

year_mininteger nullable

Inclusive lower bound

year_maxinteger nullable

Inclusive upper bound

district_codestring nullable

Comma-separated list of GOSA district codes (e.g. 601,602)

school_codestring nullable

Comma-separated list of GOSA school codes. Combine with district_code for unique school keys.

county_fipsstring nullable

Comma-separated list of 5-digit county FIPS codes (e.g. 13121,13067)

tract_geoidstring nullable

Comma-separated list of 11-digit census tract GEOIDs (e.g. 13121011100)

block_group_geoidstring nullable

Comma-separated list of 12-digit census block group GEOIDs (e.g. 131210111001)

demographicstring nullable

Comma-separated demographic codes (e.g. all,black,hispanic)

detailstring nullable

Detail level (whatever the topic publishes — e.g. schools, districts, counties, or states).

limitinteger nullable

Page size

offsetinteger

Page offset

columnsstring nullable

Comma-separated output columns to return (fact columns plus joined dimension attributes). Defaults to all.

format'json' | 'csv' | 'parquet'

Response format: json | csv | parquet

Response

Paginated rows. JSON returns an envelope with data and pagination; CSV/Parquet return raw bytes with X-Total-Count header.

unknown required

Changes

No recorded changes to this operation across all 1 revision of this API.