education

Georgia Office of Student Achievement (GOSA) certified-personnel compensation dataset, compiled from local school system

Georgia Office of Student Achievement (GOSA) certified-personnel compensation dataset, 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 four position measures per employee group (Administrators, PK-12 Teachers, Support Personnel): the full-time-equivalent (FTE) count of certified positions and the average annual salary, average daily salary, and average contract days of those positions. Coverage runs from the 2010-11 school year through 2023-24. This is one of three topics split from the retired certified_personnel dataset, all reading the same GOSA source: staff headcounts by certificate level, certification status, gender, employment status, and race/ethnicity live in certified_personnel_composition, and years-of-experience band headcounts live in certified_personnel_experience.

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_compensation

Request

  • Base URL: https://georgiacivicdata.org
  • URL: https://georgiacivicdata.org/api/v1/education/certified_personnel_compensation
  • 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.