{"main_topic":"education","sub_topic":"georgiainsights","topic":"wida_access","key":"education/georgiainsights/wida_access","version":"1.0.0","year_min":2017,"year_max":2024,"year_gaps":[],"update_frequency":"annual","detail_levels":["states"],"default_detail":"states","path_template":"education/wida_access/year={year}/{detail}.parquet","grain":["year","district_code","school_code","grade_level","domain","proficiency_level"],"title":"WIDA ACCESS English-Learner Proficiency Results","summary":"Statewide WIDA ACCESS English-language-proficiency results for Georgia English Learners by grade and test domain, 2017-2024.","description":"Georgia Insights (GaDOE) WIDA ACCESS for ELLs state-level results — the spring English-language-proficiency assessment for Georgia English Learners. For each grade (kindergarten through 12) and each of eight WIDA domains — four language domains (listening, speaking, reading, writing) and four composites (oral language, literacy, comprehension, overall score) — reports the count and share of ELL students scoring at each of the six WIDA proficiency levels (Level 1 Entering through Level 6 Reaching). This is a proficiency-level DISTRIBUTION: it carries headcounts and shares per level, not the underlying 1.0-6.0 scale scores, so it cannot answer an 'average WIDA score' question. The 2021 COVID file additionally publishes enrollment-based testing-participation rates (testing was voluntary/disrupted that year). Coverage: spring 2017 through spring 2024, state level only — bronze publishes no district or school breakdown and no demographic breakouts beyond grade.","source":"Georgia Insights (GaDOE)","source_url":"https://georgiainsights.gadoe.org/data-downloads/","endpoint":"/api/v1/education/wida_access","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Spring testing year, the ending calendar year of the school year (2024 = school year 2023-2024). Extracted from the filename and cross-checked against the sheet's title row.","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":"Always NULL: bronze reports statewide totals only, with no district breakdown.","valid_values":null,"example":null,"unit":null,"value_min":null,"value_max":null,"null_meaning":"NULL = state-level geography (every row), NOT suppression — this topic publishes state aggregates only.","key_metric_grain_contributor":false,"metric_component":null},{"name":"school_code","type":"string","role":"fk_school","nullable":true,"label":"School Code","short_description":"","description":"Always NULL: bronze reports statewide totals only, with no school breakdown.","valid_values":null,"example":null,"unit":null,"value_min":null,"value_max":null,"null_meaning":"NULL = state-level geography (every row), NOT suppression — this topic publishes state aggregates only.","key_metric_grain_contributor":false,"metric_component":null},{"name":"grade_level","type":"string","role":"categorical","nullable":false,"label":"Grade Level","short_description":"Grade tested, k (kindergarten) through 12.","description":"Canonical grade code (`k`, `01`..`12`). Grade is the bronze row axis; there is no `demographic` column because the source has no race/gender/economic breakouts.","valid_values":["01","02","03","04","05","06","07","08","09","10","11","12","k"],"example":"05","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"domain","type":"string","role":"categorical","nullable":false,"label":"Domain","short_description":"The skill area scored: listening, speaking, reading, writing, or one of four composite scores.","description":"WIDA test domain: four individually tested language domains (`listening`, `speaking`, `reading`, `writing`) plus four derived composites (`oral_language_composite` = 50% listening + 50% speaking; `literacy_composite` = 50% reading + 50% writing; `comprehension_composite` = 70% reading + 30% listening; `overall_score_composite` = 35% reading + 35% writing + 15% listening + 15% speaking).","valid_values":["comprehension_composite","listening","literacy_composite","oral_language_composite","overall_score_composite","reading","speaking","writing"],"example":"listening","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"proficiency_level","type":"string","role":"categorical","nullable":false,"label":"Proficiency Level","short_description":"WIDA proficiency band, level 1 (entering) up to level 6 (reaching).","description":"WIDA proficiency level, the fixed six-level scale from `level_1_entering` (lowest) to `level_6_reaching` (highest).","valid_values":["level_1_entering","level_2_emerging","level_3_developing","level_4_expanding","level_5_bridging","level_6_reaching"],"example":"level_4_expanding","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"num_at_proficiency_level","type":"integer","role":"metric","nullable":false,"label":"Number at Proficiency Level","short_description":"","description":"Count of ELL students in this grade scoring at this proficiency level in this domain. Zero is a real zero — the source has no suppression (state aggregates exceed any small-cell threshold).","valid_values":null,"example":6475,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":"numerator"},{"name":"pct_at_proficiency_level","type":"number","role":"metric","nullable":false,"label":"Percent at Proficiency Level","short_description":"Share of students tested in this domain who scored at this proficiency level, on a 0-1 scale.","description":"Share of domain-tested students at this level (0-1 scale; bronze publishes 0-100). The denominator is `num_tested_in_domain` (students tested in THIS domain), NOT `num_tested`. The six level shares sum to 1.0 per (year, grade_level, domain).","valid_values":null,"example":0.4577,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"num_tested_in_domain","type":"integer","role":"metric","nullable":false,"label":"Number Tested in Domain","short_description":"","description":"Students tested in this specific domain — the denominator of `pct_at_proficiency_level`. 2021 (Era 2): taken from the published `Total Tested in Domain` column. All other years (Era 1): reconstructed as the sum of the six `num_at_proficiency_level` counts for the (grade, domain) — the source leaves the denominator implicit (verified: the six published shares sum to 100.0 against exactly this total in every file, and the 2021 published value equals the level-count sum in every cell). Always <= `num_tested`.","valid_values":null,"example":14148,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":"denominator"},{"name":"num_tested","type":"integer","role":"metric","nullable":false,"label":"Number Tested","short_description":"","description":"Students in this grade tested in at least one domain — the grade-wide testing headcount, repeated on every (domain, level) row of the grade. Not every such student tested in every domain, so per-domain `num_tested_in_domain` is <= this value.","valid_values":null,"example":14148,"unit":"count","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"enrollment_tested_rate","type":"number","role":"metric","nullable":true,"label":"Enrollment Tested Rate","short_description":"","description":"Share of enrolled ELLs in this grade who tested in at least one domain (0-1 scale). Published only for 2021, when ACCESS participation was voluntary/disrupted; NULL for 2017-2020 and 2022-2024 (the enrolled-ELL denominator was never published outside 2021).","valid_values":null,"example":0.9545,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"NULL = metric not published that year (only the 2021 COVID file reports it), NOT suppression.","key_metric_grain_contributor":false,"metric_component":null},{"name":"enrollment_tested_in_domain_rate","type":"number","role":"metric","nullable":true,"label":"Enrollment Tested in Domain Rate","short_description":"","description":"Share of enrolled ELLs in this grade who tested in this domain (0-1 scale) — for composites, in every component domain (the source labels these `Tested in Both Domains` for the two-domain composites and `Tested in All Four Domains` for the overall score). Published only for 2021; NULL for all other years.","valid_values":null,"example":0.9541,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"NULL = metric not published that year (only the 2021 COVID file reports it), NOT suppression.","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"pct_at_proficiency_level","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":"This source has no suppression; a 0 is a real reported value. State rows have NULL district_code and school_code.","null_semantics":{"suppressed_to_null":false,"zero_is_real":true},"available_years":[2017,2018,2019,2020,2021,2022,2023,2024],"schema_hash":"1942277f42b93ba7e255a2484148b54f5376553c1644ad09ba57f66b77f965c3","tags":["education","georgia insights","wida_access"],"granularity_description":"One row per year, district_code, school_code, grade_level, domain, proficiency_level.","example_queries":[{"description":"Latest year (2024), states detail","query":"SELECT * FROM wida_access WHERE year = 2024 LIMIT 100"},{"description":"Filter by grade_level = 05","query":"SELECT * FROM wida_access WHERE grade_level = '05' 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":["states"],"default":"states"},{"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":"grade_level","kind":"categorical","column":"grade_level","type":"string","multi_value":true,"enum_enforced":true,"values":["01","02","03","04","05","06","07","08","09","10","11","12","k"],"has_total":false,"total_value":null,"requires_single_value":true},{"param":"domain","kind":"categorical","column":"domain","type":"string","multi_value":true,"enum_enforced":true,"values":["comprehension_composite","listening","literacy_composite","oral_language_composite","overall_score_composite","reading","speaking","writing"],"has_total":false,"total_value":null,"requires_single_value":true},{"param":"proficiency_level","kind":"categorical","column":"proficiency_level","type":"string","multi_value":true,"enum_enforced":true,"values":["level_1_entering","level_2_emerging","level_3_developing","level_4_expanding","level_5_bridging","level_6_reaching"],"has_total":false,"total_value":null,"requires_single_value":true},{"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":[]}