{"main_topic":"education","sub_topic":"georgiainsights","topic":"pathway_completion_world_language","key":"education/georgiainsights/pathway_completion_world_language","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_completion_world_language/year={year}/{detail}.parquet","grain":["year","district_code","school_code"],"title":"CCRPI Pathway Completion Rate: World Language","summary":"Share of each graduating cohort completing three or more courses in a single world language, by school and district, 2021-2024.","description":"Georgia's CCRPI Readiness 'Pathway Completion' indicator for the World Language area at the state, district, and school level, 2021-2024. Despite the upstream GaDOE/Georgia Insights file label ('Pathways Graduation Rates'), this is NOT a graduation rate — it measures, among each graduating cohort, the share who completed a World Language pathway: three or more courses in a single world language. For actual graduation rates see `graduation_rate_4_year_cohort` and `ccrpi_graduation_rate`. One of four sibling topics split from one shared Georgia Insights source — the others are `pathway_completion_advanced_academic`, `pathway_completion_ctae`, and `pathway_completion_fine_arts`. All four read the same bronze workbooks and publish identical (year, district, school) row sets, but the four per-area rates are INDEPENDENT and OVERLAPPING: a student completing more than one pathway is counted in each area, so the rates do NOT partition the cohort. No demographic breakdown. Source: Georgia Insights / GaDOE.","source":"Georgia Insights (GaDOE)","source_url":"https://georgiainsights.gadoe.org/data-downloads/","endpoint":"/api/v1/education/pathway_completion_world_language","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":"world_language_pathway_rate","type":"number","role":"metric","nullable":true,"label":"World Language Pathway Rate","short_description":"Share of the cohort completing three or more courses in one world language, on a 0-1 scale.","description":"Share of the graduating cohort who completed three or more courses in a single world language, 0-1 scale (bronze ships 0-100; divided by 100). One of four INDEPENDENT, OVERLAPPING per-area completion rates published by the pathway_completion_* sibling topics — they do not partition the cohort, and summed across topics they routinely exceed 1.0. Has the highest NULL rate of the four areas (~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 jointly across the four sibling pathway topics at transform time).","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"world_language_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. world_language_pathway_rate is one of four INDEPENDENT, OVERLAPPING per-area completion rates — the sibling topics pathway_completion_advanced_academic, pathway_completion_ctae, and pathway_completion_fine_arts publish the other three areas over the identical row set. The rates do NOT partition the cohort: a student completing more than one pathway is counted in each area, so the four rates for one entity routinely sum above 1.0 — do not sum them or treat them as mutually exclusive shares. World Language has the highest suppression of the four areas (~42-44% of rows NULL in 2022-2024). 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 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) and preserves partial-zero 2021 rows — leaving 180 surviving 2021 zero cells across the four sibling rates 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":"c589880a52b9615a2f88412a18339815e4ae58f15ecf2a0eb1bc0afefd5e8be9","tags":["education","georgia insights","pathway_completion_world_language"],"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_completion_world_language WHERE year = 2024 LIMIT 100"},{"description":"District 625 in 2024","query":"SELECT * FROM pathway_completion_world_language 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"]},{"param":"school_level","kind":"dimension_attribute","dimension":"schools","column":"school_level","type":"string","multi_value":true,"enum_enforced":true,"values":["elementary","middle","high","k12","other"]},{"param":"locale","kind":"dimension_attribute","dimension":"schools","column":"locale","type":"string","multi_value":true,"enum_enforced":true,"values":["city","suburb","town","rural"]}],"filter_hints":[],"values_endpoint":"/api/v1/education/pathway_completion_world_language/values"}