education

Georgia certified-personnel staff composition, from the Governor's Office of Student Achievement (GOSA) Certified Person

Georgia certified-personnel staff composition, from the Governor's Office of Student Achievement (GOSA) Certified Personnel report (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 staff headcounts along five mutually exclusive staff-attribute axes — certificate level (Bachelor's through Doctoral, plus Other), certification status (Professional / Provisional), gender, employment status (Full/Part-time), and race/ethnicity — for each of three employee groups (Administrators, PK-12 Teachers, Support Personnel), school years 2010-11 through 2023-24. This topic covers WHO the staff are; its sibling topics from the same GOSA source cover how experienced they are (certified_personnel_experience: years-of-experience band headcounts and the mean) and their positions and pay (certified_personnel_compensation: FTE position counts and average salary/contract days).

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

  • employee_type — one of: administrators, pk_12_teachers, support_personnel
  • staff_attribute_category — one of: certificate_level, certification_status, employment_status, gender, race_ethnicity
  • staff_attribute — one of: 4_yr_bachelors, 5_yr_masters, 6_yr_specialists, 7_yr_doctoral, asian_pacific_islander, black, female, full_time, hispanic, male, multiracial, native_american, other, part_time, professional, provisional, white

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_composition

Request

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