Postsecondary Outcomes of HS Graduates (C12, Georgia)

How many Georgia public high school graduates enrolled in a Georgia college and earned a year of credit, by school, district, and demographic subgroup, 2008-2020 cohorts.

Fuente: GOSA
Cobertura de años: 2008–2020
Actualización: annual
Versión: 1.0.0
Hash del esquema: afe2abc74f9e

Niveles de detalle disponibles

EstadoDistritoEscuela · predeterminado

Resumen

GOSA Postsecondary C12 Report: three raw student counts per demographic subgroup along the high-school-graduate-to-postsecondary pipeline, for every Georgia public high school with official district and state rollups — high school graduates in the cohort year (num_graduates), graduates who enrolled in a Georgia postsecondary institution (num_enrolled_in_college), and graduates who earned at least 24 postsecondary credit hours (roughly one year of college) within two years of initial enrollment (num_earned_24_credits). IMPORTANT: unlike the sibling C11 report, which counts enrollment in institutions anywhere in the nation, C12 counts Georgia institutions only (verified: for the same 2016 cohort C11 reports 71,095 enrolled statewide vs C12's 57,468, while graduate counts agree), so C11 and C12 enrollment figures are NOT directly comparable. Covers HS graduating cohorts 2008-2020; no rates are published — derive college-going rate as num_enrolled_in_college / num_graduates and credit-earning rate as num_earned_24_credits / num_graduates at query time.

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

Métrica clave

num_enrolled_in_college — Number Enrolled in College (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	HS graduating cohort year (ending calendar year of the school year; 2020 means the class of 2019-20), parsed from the source's School Year column and cross-checked against the filename (publication year = cohort year + 4). Never the publication year. Descripción completa▾ HS graduating cohort year (ending calendar year of the school year; 2020 means the class of 2019-20), parsed from the source's School Year column and cross-checked against the filename (publication year = cohort year + 4). Never the publication year.
`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 2015-2019 source files strip leading zeros; the transform restores them. 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 2015-2019 source files strip leading zeros; the transform restores them. NULL on district- and state-level rows. Se une a schools; agrega sus columnas de etiqueta.
`demographic`Demographic	string	—	—	no	Student subgroup the row covers (race, gender, economic, or special-population); 'all' is the cohort total. Race uses the split asian / pacific_islander convention. Descripción completa▾ Demographic subgroup (FK to the global demographics dimension). Race uses the SPLIT convention: asian and pacific_islander are separate buckets (the source publishes a distinct Pacific Islander group from cohort 2009 onward, and at the state level the seven race buckets sum exactly to the all-students total in most years), never the combined asian_pacific_islander rollup. pacific_islander rows are absent (not NULL) in year=2008 — the 2012 source file does not carry the group. 'all' is the unfiltered total and overlaps every other value; subgroups are mutually exclusive only within their own category (race, gender, economic status, special population). 14 valores permitidos▾ `all` `asian` `black` `economically_disadvantaged` `english_learners` `female` `hispanic` `male` `migrant` `multiracial` `native_american` `pacific_islander` `students_with_disabilities` `white` Se une a demographics; agrega sus columnas de etiqueta.
`num_graduates`Number Graduates	integer	count	—	yes	Number of students in the demographic subgroup who graduated from high school in the cohort year. Published values are always >= 10 (GOSA suppresses smaller cells as TFS). The denominator for both derived rates. Descripción completa▾ Number of students in the demographic subgroup who graduated from high school in the cohort year. Published values are always >= 10 (GOSA suppresses smaller cells as TFS). The denominator for both derived rates.
`num_enrolled_in_college`Number Enrolled in College	integer	count	—	yes	Count of the cohort's graduates who enrolled in a Georgia college; divide by num_graduates for the in-state college-going rate (Georgia institutions only). Descripción completa▾ Number of those graduates who enrolled in a postsecondary institution located in Georgia (public or private, 2-year or 4-year). Georgia institutions ONLY — the sibling C11 report counts enrollment anywhere in the nation, so C11 and C12 enrollment figures are not comparable. Never exceeds num_graduates where both are published (enforced by a quality check).
`num_earned_24_credits`Number Earned 24 Credits	integer	count	—	yes	Number of those graduates who accumulated at least 24 credit hours of postsecondary coursework — roughly one year of college instruction — within two years of initial enrollment; a persistence / college-readiness signal. Never exceeds num_enrolled_in_college or num_graduates where both are published (enforced by quality checks). Descripción completa▾ Number of those graduates who accumulated at least 24 credit hours of postsecondary coursework — roughly one year of college instruction — within two years of initial enrollment; a persistence / college-readiness signal. Never exceeds num_enrolled_in_college or num_graduates where both are published (enforced by quality checks).

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	14 valores permitidos▾ `all` `asian` `black` `economically_disadvantaged` `english_learners` `female` `hispanic` `male` `migrant` `multiracial` `native_american` `pacific_islander` `students_with_disabilities` `white`	valores múltiples, enum validado
`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/postsecondary_c12"

schools data for 2020

curl "https://georgiacivicdata.org/api/v1/education/postsecondary_c12?year=2020"

One district (code 601), 2020

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

Download 2020 as CSV

curl "https://georgiacivicdata.org/api/v1/education/postsecondary_c12?year=2020&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 publishes counts below 10 as TFS, so sparse subgroups (pacific_islander, native_american, migrant) are almost universally suppressed at school level, and summing only published school rows undercounts true totals — use district or state rows for official aggregates (a district total is NOT the sum of its published school rows). num_enrolled_in_college counts enrollment in GEORGIA institutions only; it is not comparable to the C11 report's nationwide enrollment count. pacific_islander rows are absent in year=2008. State rows have NULL district_code and school_code; district rows have NULL school_code.