CCRPI Pathway Completion Rates

Share of each graduating cohort completing a course pathway in four elective areas, by school and district, 2021-2024.

Source: Georgia Insights (GaDOE)
Year coverage: 2021–2024
Updated: annual
Version: 1.0.0
Schema hash: e31c596116d2

Detail levels available

StateDistrictSchool · default

Overview

Georgia's CCRPI 'Pathways' completion indicator at the state, district, and school level, 2021-2024. NOTE ON THE TOPIC NAME: despite `pathway_graduation_rate` (which mirrors the GaDOE/Georgia Insights file label 'Pathways Graduation Rates'), this is the CCRPI Readiness 'Pathway Completion' indicator — NOT a graduation rate. It measures, among each graduating cohort, the share who completed a coherent three-course sequence ('pathway') in each of four elective areas: Advanced Academic (AP/IB/dual enrollment), World Language, Fine Arts, and CTAE (Career, Technical, and Agricultural Education). For actual graduation rates see `graduation_rate_4_year_cohort` and `ccrpi_graduation_rate`. The four area rates are INDEPENDENT, OVERLAPPING per-area completion rates — they do NOT partition the cohort and routinely sum above 1.0 (a student completing two pathways is counted in both). 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.
`advanced_academic_pathway_rate`Advanced Academic Pathway Rate	number	proportion	—	yes	Share of the graduating cohort who completed an Advanced Academic pathway (AP, IB, or dual enrollment), 0-1 scale (bronze ships 0-100; divided by 100). One of four INDEPENDENT, OVERLAPPING per-area completion rates — they do not partition the cohort and routinely sum above 1.0. Full description▾ Share of the graduating cohort who completed an Advanced Academic pathway (AP, IB, or dual enrollment), 0-1 scale (bronze ships 0-100; divided by 100). One of four INDEPENDENT, OVERLAPPING per-area completion rates — they do not partition the cohort and routinely sum above 1.0.
`world_language_pathway_rate`World Language Pathway Rate	number	proportion	—	yes	Share of the graduating cohort who completed three or more courses in a single world language, 0-1 scale. One of four independent, overlapping per-area completion rates. Has the highest NULL rate of the four (~42-44% in 2022-2024) — World Language is the least common pathway at smaller schools. Full description▾ Share of the graduating cohort who completed three or more courses in a single world language, 0-1 scale. One of four independent, overlapping per-area completion rates. Has the highest NULL rate of the four (~42-44% in 2022-2024) — World Language is the least common pathway at smaller schools.
`fine_arts_pathway_rate`Fine Arts Pathway Rate	number	proportion	—	yes	Share of the graduating cohort who completed a three-course Fine Arts sequence (visual arts, music, theater, dance), 0-1 scale. One of four independent, overlapping per-area completion rates. Full description▾ Share of the graduating cohort who completed a three-course Fine Arts sequence (visual arts, music, theater, dance), 0-1 scale. One of four independent, overlapping per-area completion rates.
`ctae_pathway_rate`CTAE Pathway Rate	number	proportion	—	yes	Share of the cohort completing a CTAE (career/technical) course pathway, on a 0-1 scale. Full description▾ Share of the graduating cohort who completed a CTAE (Career, Technical, and Agricultural Education) pathway — three sequenced CTAE courses in a single program area — 0-1 scale. One of four independent, overlapping per-area completion rates.

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

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_graduation_rate"

schools data for 2024

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

One district (code 625), 2024

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

Download 2024 as CSV

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

Notes & limitations

NULL handling

Suppressed cells (too few students to report) are NULL, never zero.
Zero is a real, reported value.

Limitations

Suppressed cells are NULL (not zero). State rows have NULL district_code and school_code; district rows have NULL school_code. The four area rates (advanced_academic_pathway_rate, world_language_pathway_rate, fine_arts_pathway_rate, ctae_pathway_rate) are INDEPENDENT, OVERLAPPING per-area completion rates, NOT a partition of the cohort: a student who completes more than one pathway is counted in each, so the four rates routinely sum above 1.0 — do not sum them or treat them as mutually exclusive shares. 2021 zero-encoding: the 2021 bronze file carries no text suppression markers (unlike the 'NA'/'TFS' used from 2022 on) and encodes 'no applicable students' as 0.0. The transform NULLs the 47 rows where all four rates are exactly 0.0 (implausible as genuine rates; the same row identities appear as NA/TFS in later years) and preserves partial-zero 2021 rows — leaving 180 surviving 2021 zero cells (~18% of 2021 rows) ambiguous between a genuine 0% rate and suppression; 171 of the 180 appear as NA/TFS at the same identities in 2022, so most are likely suppression. Coverage is 2021-2024; a 2025 source file exists upstream but is not yet ingested.