High School Completers

Counts of Georgia high school completers by diploma or certificate type, by school, district, and state and demographic subgroup, 2011-2024.

Fuente: GOSA
Cobertura de años: 2011–2024
Actualización: annual
Versión: 1.0.0
Hash del esquema: eaad9877ebaf

Niveles de detalle disponibles

EstadoDistritoEscuela · predeterminado

Resumen

Number of Georgia public high-school completers by credential type (General Education Diplomas, Diplomas with College Prep Endorsements, Diplomas with Vocational Endorsements, Diplomas with Both College Prep and Vocational Endorsements, Special Education Diplomas, Certificates of Attendance) and completer type (graduates vs. other completers), broken out by 9 demographic subgroups (gender, race/ethnicity, and the all-students total), with each demographic's share of the credential's completers. School, district, and state levels, school years 2010-11 through 2023-24, published by GOSA.

Granularidad de fila: Una fila por year, district_code, school_code, demographic, completer_type, credential_type.

Métrica clave

num_completers — Number Completers (count)

El valor principal que la mayoría de las consultas busca.

Esquema JSON →Contrato de datos (YAML) →

Variables

Todas las columnas de la tabla de hechos. El código es el nombre exacto del campo que devuelve la API.

Columna	Tipo	Unidad	Rango	¿Nulo?	Descripción
`year`Year	integer	—	—	no	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. Descripción completa▾ 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.
`district_code`District Code	string	—	—	yes	GOSA district code (FK to districts dimension): 3-digit zero-padded county/city codes or 7-digit state-charter codes. NULL on state-level rows. Descripción completa▾ GOSA district code (FK to districts dimension): 3-digit zero-padded county/city codes or 7-digit state-charter codes. NULL on state-level rows. Se une a districts; agrega sus columnas de etiqueta.
`school_code`School Code	string	—	—	yes	GOSA school code, zero-padded to 4 characters (composite FK to schools dimension with district_code; not globally unique on its own). The 2011, 2018, 2019, and 2020 source files mix 3- and 4-character codes; the transform normalizes all years to 4 characters. NULL on district- and state-level rows. Descripción completa▾ GOSA school code, zero-padded to 4 characters (composite FK to schools dimension with district_code; not globally unique on its own). The 2011, 2018, 2019, and 2020 source files mix 3- and 4-character codes; the transform normalizes all years to 4 characters. NULL on district- and state-level rows. Se une a schools; agrega sus columnas de etiqueta.
`demographic`Demographic	string	—	—	no	Demographic subgroup: all students, gender, or one of six race/ethnicity buckets (Asian is combined Asian/Pacific Islander). Descripción completa▾ Demographic subgroup (FK to the global demographics dimension): the all-students total, gender (male, female), and six race/ethnicity buckets. Race uses the combined asian_pacific_islander key (pre-1997 OMB convention): the source publishes a bare 'Asian' label with no separate Pacific Islander row, and the six race buckets sum exactly to the Total in every fully published group, so Pacific Islanders are folded in, never dropped. 'all' is the unfiltered total and overlaps every other value; subgroups are mutually exclusive only within their own category (race, gender). 9 valores permitidos▾ `all` `asian_pacific_islander` `black` `female` `hispanic` `male` `multiracial` `native_american` `white` Se une a demographics; agrega sus columnas de etiqueta.
`completer_type`Completer Type	string	—	—	no	High-level cohort: graduates (the four diploma credentials) vs. other_completers (special-ed diplomas and certificates of attendance). Descripción completa▾ High-level completer cohort: 'graduates' covers the four diploma credentials (general education, college prep, vocational, both); 'other_completers' covers Special Education Diplomas and Certificates of Attendance (students who did not meet the full diploma course/assessment criteria). Functionally determined by credential_type (each credential belongs to exactly one completer_type; enforced by a quality check). NOT the denominator of pct_of_credential_type — that metric's denominator is the single credential's total. 2 valores permitidos▾ `graduates` `other_completers`
`credential_type`Credential Type	string	—	—	no	Specific credential earned: general-education, college-prep, vocational, or both diplomas, special-ed diplomas, or certificates of attendance. Descripción completa▾ Specific credential earned. Six values from 2012 onward; the 2010-11 school year (year=2011) predates 'general_education_diplomas' and carries only the other five. From 2012 onward Georgia phased out endorsement diplomas, so general_education_diplomas dominates Graduates counts in later years. 6 valores permitidos▾ `certificates_of_attendance` `diplomas_college_prep` `diplomas_college_prep_and_vocational` `diplomas_vocational` `general_education_diplomas` `special_education_diplomas`
`num_completers`Number Completers	integer	count	—	yes	Number of completers in this demographic who earned this credential during the school year; NULL means GOSA suppressed a small cell, not zero. Descripción completa▾ Number of completers in this demographic who earned this credential during the school year at this school/district/state. Literal 0 is a real published value (appears only in 2012-2017 and 2021-2022); NULL is suppression. In 2023-2024 every published count is >= 10; earlier years publish smaller values.
`pct_of_credential_type`Percent of Credential Type	number	proportion	—	yes	Share of the credential's completers who belong to this demographic — a demographic-within-credential share on the 0-1 scale (source publishes 0-100 with one decimal; divided by 100). The denominator is the credential's own demographic='all' total at the same geography, NOT the completer_type cohort total: rows with demographic='all' are always exactly 1.0 where published, gender pairs sum to ~1, and the six race buckets sum to ~1 within a credential (all pinned as quality checks). Credentials do NOT sum to 1 within a completer_type. Descripción completa▾ Share of the credential's completers who belong to this demographic — a demographic-within-credential share on the 0-1 scale (source publishes 0-100 with one decimal; divided by 100). The denominator is the credential's own demographic='all' total at the same geography, NOT the completer_type cohort total: rows with demographic='all' are always exactly 1.0 where published, gender pairs sum to ~1, and the six race buckets sum to ~1 within a credential (all pinned as quality checks). Credentials do NOT sum to 1 within a completer_type.

Filtros

Parámetros de consulta que acepta el endpoint de hechos. Los valores separados por comas son OR dentro de un parámetro; varios parámetros se combinan con AND.

Parámetro	Tipo	Valores permitidos	Notas
`year`	year_exact	cualquier valor	—
`year_min`	year_range	cualquier valor	—
`year_max`	year_range	cualquier valor	—
`detail`	detail	`districtsschoolsstates`	enum validado, predeterminado: schools
`district_code`	foreign_key	cualquier valor	valores múltiples
`school_code`	foreign_key	cualquier valor	valores múltiples
`demographic`	foreign_key	9 valores permitidos▾ `all` `asian_pacific_islander` `black` `female` `hispanic` `male` `multiracial` `native_american` `white`	valores múltiples, enum validado
`completer_type`	categorical	`graduatesother_completers`	valores múltiples, enum validado, elige uno
`credential_type`	categorical	`certificates_of_attendancediplomas_college_prepdiplomas_college_prep_and_vocationaldiplomas_vocationalgeneral_education_diplomasspecial_education_diplomas`	valores múltiples, enum validado, elige uno
`district_type`	dimension_attribute	7 valores permitidos▾ `commission_charter` `resa` `standard` `state_agency` `state_charter` `state_school` `state_special`	valores múltiples, enum validado
`demographic_category`	dimension_attribute	12 valores permitidos▾ `aggregate` `disability` `economic_status` `esol` `foster_care` `gender` `grade` `homeless_status` `migrant_status` `military` `race` `sped`	valores múltiples, enum validado

Ejemplos de solicitudes

Ejecútalos contra la URL base: devuelven datos en vivo.

All rows (first page), schools level

curl "https://georgiacivicdata.org/api/v1/education/high_school_completers"

schools data for 2024

curl "https://georgiacivicdata.org/api/v1/education/high_school_completers?year=2024"

Filtered to completer_type = graduates for 2024

curl "https://georgiacivicdata.org/api/v1/education/high_school_completers?year=2024&completer_type=graduates"

One district (code 601), 2024

curl "https://georgiacivicdata.org/api/v1/education/high_school_completers?district_code=601&year=2024&detail=districts"

Download 2024 as CSV

curl "https://georgiacivicdata.org/api/v1/education/high_school_completers?year=2024&format=csv"

Notas y limitaciones

Manejo de NULL

Las celdas suprimidas (muy pocos estudiantes para reportar) son NULL, nunca cero.
El cero es un valor real y reportado.

Limitaciones

Suppressed cells are NULL (not zero): GOSA suppresses small cells, blanking ~65-90% of num_completers values depending on the year (suppression tightened over time), and even some state-level cells (e.g. the phased-out endorsement-diploma credentials in recent years) — school-level analyses should expect sparse coverage, and summing only published subgroup counts undercounts true totals. pct_of_credential_type is a demographic composition share (demographic within credential), not a credential-mix share — do not sum it across credentials. State rows have NULL district_code and school_code; district rows have NULL school_code. The race axis uses the combined asian_pacific_islander bucket — not comparable row-for-row with split-convention topics without aggregating those topics' asian + pacific_islander rows at query time. year=2011 lacks the general_education_diplomas credential (it did not exist yet).