Pathway Completer Graduation Rate: CTAE

Four-year cohort graduation rate of students who completed a CTAE (career/technical) pathway, by school and district, 2021-2024.

Source: Georgia Insights (GaDOE)
Year coverage: 2021–2024
Updated: annual
Version: 1.1.0
Schema hash: 594f582de7e8

Detail levels available

StateDistrictSchool · default

Overview

Four-year adjusted cohort graduation rate of students who completed a CTAE pathway (Career, Technical, and Agricultural Education: three sequenced CTAE courses in a single program area) at the state, district, and school level, 2021-2024: among cohort members who completed the pathway, the share earning a regular diploma within four years. Published by GaDOE / Georgia Insights as the 'Pathways Graduation Rate'. The denominator is the pathway completers, not the whole cohort, so the rate says nothing about how many students completed the pathway; compare to the all-students rate in `graduation_rate_4_year_cohort` (pathway completers graduate at rates well above it). One of four sibling topics split from one shared Georgia Insights source — the others are `pathway_completion_advanced_academic`, `pathway_completion_fine_arts`, and `pathway_completion_world_language`. All four read the same bronze workbooks and publish identical (year, district, school) row sets, but the four per-area rates are INDEPENDENT: each has its own completer denominator and a student who completed more than one pathway is counted in each area, so the rates neither partition the cohort nor combine into an all-pathway figure. Distinct from the CCRPI Readiness 'Pathway Completion' indicator (the share of students completing any pathway, served by `ccrpi_readiness`). No demographic breakdown. Source: Georgia Insights / GaDOE.

Row grain: One row per year, district_code, school_code.

Key metric

ctae_pathway_rate — CTAE Pathway Rate (proportion)

The single headline value most answers want.

JSON schema →Data contract (YAML) →

Variables

Every column in the fact table. The code is the exact field name the API returns.

Column	Type	Unit	Range	Null?	Description
`year`Year	integer	—	—	no	Cohort graduation year (e.g., 2024 = the 2023-2024 graduating cohort). Sourced from the in-file COHORT YEAR column, which equals the filename year in every bronze file. Full description▾ Cohort graduation year (e.g., 2024 = the 2023-2024 graduating cohort). Sourced from the in-file COHORT YEAR column, which equals the filename year in every bronze file.
`district_code`District Code	string	—	—	yes	GOSA district code (FK to districts dimension). Standard 3-digit codes are zero-padded; 7-digit state-charter network codes (e.g., '7820120') pass through unchanged. NULL on the state-level aggregate row. Full description▾ GOSA district code (FK to districts dimension). Standard 3-digit codes are zero-padded; 7-digit state-charter network codes (e.g., '7820120') pass through unchanged. NULL on the state-level aggregate row. Joins districts; adds its label columns.
`school_code`School Code	string	—	—	yes	4-digit GOSA school code (FK to schools dimension; composite key with district_code). Bronze 2021-2023 files mix 3- and 4-char school IDs; 3-char codes are zero-padded to align with 2024's uniformly 4-char format ('195' -> '0195'). NULL on state- and district-level aggregate rows. Full description▾ 4-digit GOSA school code (FK to schools dimension; composite key with district_code). Bronze 2021-2023 files mix 3- and 4-char school IDs; 3-char codes are zero-padded to align with 2024's uniformly 4-char format ('195' -> '0195'). NULL on state- and district-level aggregate rows. Joins schools; adds its label columns.
`ctae_pathway_rate`CTAE Pathway Rate	number	proportion	—	yes	Four-year graduation rate of students who completed a CTAE (career/technical) pathway, on a 0-1 scale. Full description▾ Four-year adjusted cohort graduation rate of students who completed a CTAE pathway (Career, Technical, and Agricultural Education: three sequenced CTAE courses in a single program area): among cohort members who completed the pathway, the share earning a regular diploma within four years, 0-1 scale (bronze ships 0-100; divided by 100). The denominator is the pathway completers, not the cohort — this is not the share of students completing the pathway. One of four INDEPENDENT per-area completer graduation rates published by the pathway_completion_* sibling topics; each has its own denominator, so the four rates cannot be summed or averaged into an all-pathway figure. Compare to the all-students rate in graduation_rate_4_year_cohort.

Filters

Query parameters the fact endpoint accepts. Comma-separated values are OR within a parameter; multiple parameters AND together.

Parameter	Kind	Allowed values	Notes
`year`	year_exact	any value	—
`year_min`	year_range	any value	—
`year_max`	year_range	any value	—
`detail`	detail	`districtsschoolsstates`	enum-enforced, default: schools
`district_code`	foreign_key	any value	multi-value
`school_code`	foreign_key	any value	multi-value
`district_type`	dimension_attribute	7 allowed values▾ `commission_charter` `resa` `standard` `state_agency` `state_charter` `state_school` `state_special`	multi-value, enum-enforced
`school_level`	dimension_attribute	`elementarymiddlehighk12other`	multi-value, enum-enforced
`locale`	dimension_attribute	`citysuburbtownrural`	multi-value, enum-enforced

Example requests

Run these against the base URL — they return live data.

All rows (first page), schools level

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

schools data for 2024

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

One district (code 625), 2024

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

Download 2024 as CSV

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

Notes & limitations

NULL handling

Suppressed cells (too few students to report) are NULL, never zero.

Limitations

Suppressed cells are NULL (not zero). State rows have NULL district_code and school_code; district rows have NULL school_code. ctae_pathway_rate is the graduation rate of a self-selected subgroup — students who completed a CTAE (career/technical) pathway — and says nothing about how many students completed the pathway; completer rates run well above the all-students rate in graduation_rate_4_year_cohort. It is one of four INDEPENDENT per-area completer graduation rates — the sibling topics pathway_completion_advanced_academic, pathway_completion_fine_arts, and pathway_completion_world_language publish the other three areas over the identical row set. Each rate has its own denominator (that area's completers) and a student who completed more than one pathway is counted in each area, so the four rates cannot be summed, averaged, or read as shares of one cohort. No completer counts (numerator or denominator) are published, so rates cannot be re-aggregated across entities or years. District and state rows are published aggregates, not roll-ups of the listed school rows — a district's rate can fall outside the range of its schools (e.g. single-school Buford City 2022: district 0.9865 vs its high school 0.991). 2021 zero-encoding: the 2021 bronze file carries no text suppression markers (unlike the 'NA'/'TFS' used from 2022 on) and encodes 'no pathway completers' as 0.0. The shared bronze module NULLs the 47 rows where all four sibling rates are exactly 0.0 (implausible as genuine rates; the same row identities appear as NA/TFS in later years), then — per column, matched on (district, school) identity — NULLs each surviving 2021 zero cell whose entity carries NA/TFS in the same column in 2022 (the source's own 'no/too few completers' statement for that entity): 171 of the 180 surviving 2021 zero cells across the four sibling rates (13 of this topic's 14). The 9 remaining 2021 zeros are preserved as published because 2022 offers no evidence either way — 6 belong to schools absent from the 2022 file and 3 are numeric in 2022 (in this topic: 1, KIPP Atlanta Collegiate Academy 761/0212, 0 in 2021 and 1.0 in 2022); treat a 2021 0 with caution. Coverage is 2021-2024; a 2025 source file exists upstream but is not yet ingested.