{"main_topic":"education","sub_topic":"georgiainsights","topic":"pathway_graduation_rate","key":"education/georgiainsights/pathway_graduation_rate","version":"1.0.0","year_min":2021,"year_max":2024,"year_gaps":[],"update_frequency":"annual","detail_levels":["districts","schools","states"],"default_detail":"schools","path_template":"education/pathway_graduation_rate/year={year}/{detail}.parquet","grain":["year","district_code","school_code"],"title":"CCRPI Pathway Completion Rates","summary":"Share of each graduating cohort completing a course pathway in four elective areas, by school and district, 2021-2024.","description":"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.","source":"Georgia Insights (GaDOE)","source_url":"https://georgiainsights.gadoe.org/data-downloads/","endpoint":"/api/v1/education/pathway_graduation_rate","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","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.","valid_values":null,"example":2024,"unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"district_code","type":"string","role":"fk_district","nullable":true,"label":"District Code","short_description":"","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.","valid_values":null,"example":"625","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"school_code","type":"string","role":"fk_school","nullable":true,"label":"School Code","short_description":"","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.","valid_values":null,"example":"0411","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"advanced_academic_pathway_rate","type":"number","role":"metric","nullable":true,"label":"Advanced Academic Pathway Rate","short_description":"","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.","valid_values":null,"example":0.995,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Suppressed (bronze 'TFS') or no applicable students (bronze 'NA' in 2022-2024; all-four-zero encoding in 2021, masked at transform time).","key_metric_grain_contributor":false,"metric_component":null},{"name":"world_language_pathway_rate","type":"number","role":"metric","nullable":true,"label":"World Language Pathway Rate","short_description":"","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.","valid_values":null,"example":0.9926,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Suppressed (bronze 'TFS') or no applicable students (bronze 'NA' in 2022-2024; all-four-zero encoding in 2021, masked at transform time).","key_metric_grain_contributor":false,"metric_component":null},{"name":"fine_arts_pathway_rate","type":"number","role":"metric","nullable":true,"label":"Fine Arts Pathway Rate","short_description":"","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.","valid_values":null,"example":0.9789,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Suppressed (bronze 'TFS') or no applicable students (bronze 'NA' in 2022-2024; all-four-zero encoding in 2021, masked at transform time).","key_metric_grain_contributor":false,"metric_component":null},{"name":"ctae_pathway_rate","type":"number","role":"metric","nullable":true,"label":"CTAE Pathway Rate","short_description":"Share of the cohort completing a CTAE (career/technical) course pathway, on a 0-1 scale.","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.","valid_values":null,"example":0.9824,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"Suppressed (bronze 'TFS') or no applicable students (bronze 'NA' in 2022-2024; all-four-zero encoding in 2021, masked at transform time).","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"ctae_pathway_rate","usage":"Star-schema fact table. Join the districts dimension on district_code; the schools dimension on district_code + school_code. Read directly with DuckDB over Parquet.","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.","null_semantics":{"suppressed_to_null":true,"zero_is_real":true},"available_years":[2021,2022,2023,2024],"schema_hash":"e31c596116d259a2604d2e2b2753906ccb45e31dcf57095c7d32dfae0cc552bd","tags":["education","georgia insights","pathway_graduation_rate"],"granularity_description":"One row per year, district_code, school_code (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2024), schools detail","query":"SELECT * FROM pathway_graduation_rate WHERE year = 2024 LIMIT 100"},{"description":"District 625 in 2024","query":"SELECT * FROM pathway_graduation_rate WHERE district_code = '625' AND year = 2024 LIMIT 100"}],"foreign_keys":[{"column":"district_code","target_object":"districts","target_columns":["district_code"],"attribute_columns_added":["district_name","district_census_id","district_type"],"scope":"domain"},{"column":"school_code","target_object":"schools","target_columns":["district_code","school_code"],"attribute_columns_added":["school_name"],"scope":"domain"}],"filters":[{"param":"year","kind":"year_exact","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"year_min","kind":"year_range","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"year_max","kind":"year_range","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"detail","kind":"detail","type":"string","multi_value":false,"enum_enforced":true,"values":["districts","schools","states"],"default":"schools"},{"param":"district_code","kind":"foreign_key","column":"district_code","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"school_code","kind":"foreign_key","column":"school_code","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"district_type","kind":"dimension_attribute","dimension":"districts","column":"district_type","type":"string","multi_value":true,"enum_enforced":true,"values":["commission_charter","resa","standard","state_agency","state_charter","state_school","state_special"]}],"filter_hints":[]}