Coming soon! Zelma version 1.1 will launch mid-June, including additional state and student subgroup data.
Export Data
Data Availability
State | Subject | Date Start | Date End |
---|---|---|---|
Alabama | ELA | 2015 | 2023 |
Alabama | Math | 2015 | 2023 |
Alabama | Science | 2015 | 2023 |
Alaska | ELA | 2017 | 2022 |
Alaska | Math | 2017 | 2022 |
Alaska | Science | 2017 | 2022 |
Arizona | ELA | 2010 | 2023 |
Arizona | Math | 2010 | 2023 |
Arizona | Science | 2010 | 2023 |
Arizona | Writing | 2010 | 2014 |
Arkansas | ELA | 2009 | 2023 |
Arkansas | English | 2016 | 2023 |
Arkansas | Math | 2009 | 2023 |
Arkansas | Reading | 2016 | 2023 |
Arkansas | Science | 2009 | 2023 |
Arkansas | STEM | 2016 | 2023 |
Arkansas | Writing | 2016 | 2017 |
California | ELA | 2010 | 2023 |
California | Math | 2010 | 2023 |
California | Science | 2010 | 2013 |
California | Social Studies | 2010 | 2013 |
Colorado | ELA | 2015 | 2023 |
Colorado | Math | 2015 | 2023 |
Colorado | Science | 2014 | 2023 |
Colorado | Social Studies | 2014 | 2015 |
Connecticut | ELA | 2015 | 2023 |
Connecticut | Math | 2015 | 2023 |
Connecticut | Science | 2019 | 2023 |
Delaware | ELA | 2015 | 2023 |
Delaware | Math | 2015 | 2023 |
Delaware | Science | 2015 | 2023 |
Delaware | Social Studies | 2015 | 2022 |
District of Columbia | ELA | 2015 | 2023 |
District of Columbia | Math | 2015 | 2023 |
District of Columbia | Science | 2019 | 2022 |
Florida | ELA | 2015 | 2023 |
Florida | Math | 2015 | 2023 |
Florida | Science | 2015 | 2023 |
Georgia | ELA | 2011 | 2022 |
Georgia | Math | 2011 | 2022 |
Georgia | Reading | 2011 | 2014 |
Georgia | Science | 2011 | 2022 |
Georgia | Social Studies | 2011 | 2022 |
Hawaii | ELA | 2015 | 2023 |
Hawaii | Math | 2015 | 2023 |
Hawaii | Science | 2022 | 2023 |
Idaho | ELA | 2015 | 2023 |
Idaho | Math | 2015 | 2023 |
Idaho | Science | 2015 | 2023 |
Illinois | ELA | 2015 | 2023 |
Illinois | Math | 2015 | 2023 |
Illinois | Science | 2016 | 2023 |
Indiana | ELA | 2005 | 2023 |
Indiana | Math | 2005 | 2023 |
Indiana | Science | 2011 | 2023 |
Indiana | Social Studies | 2011 | 2023 |
Iowa | ELA | 2013 | 2023 |
Iowa | Math | 2013 | 2023 |
Iowa | Science | 2019 | 2023 |
Kansas | ELA | 2015 | 2023 |
Kansas | Math | 2015 | 2023 |
Kansas | Science | 2019 | 2023 |
Kentucky | ELA | 2012 | 2023 |
Kentucky | Math | 2012 | 2023 |
Kentucky | Science | 2012 | 2023 |
Kentucky | Social Studies | 2012 | 2023 |
Kentucky | Writing | 2012 | 2023 |
Louisiana | ELA | 2014 | 2023 |
Louisiana | Math | 2014 | 2023 |
Louisiana | Science | 2014 | 2023 |
Louisiana | Social Studies | 2014 | 2023 |
Maryland | ELA | 2015 | 2023 |
Maryland | Math | 2015 | 2023 |
Maryland | Science | 2015 | 2023 |
Massachusetts | ELA | 2010 | 2023 |
Massachusetts | Math | 2010 | 2023 |
Massachusetts | Science | 2010 | 2023 |
Michigan | ELA | 2015 | 2023 |
Michigan | Math | 2015 | 2023 |
Michigan | Science | 2015 | 2023 |
Michigan | Social Studies | 2015 | 2023 |
Minnesota | ELA | 1998 | 2023 |
Minnesota | Math | 1998 | 2023 |
Minnesota | Science | 2008 | 2023 |
Minnesota | Writing | 1998 | 2005 |
Mississippi | ELA | 2014 | 2023 |
Mississippi | Math | 2014 | 2023 |
Mississippi | Science | 2014 | 2023 |
Missouri | ELA | 2010 | 2022 |
Missouri | Math | 2010 | 2022 |
Missouri | Science | 2010 | 2022 |
Montana | ELA | 2016 | 2023 |
Montana | Math | 2016 | 2023 |
Montana | Science | 2022 | 2023 |
Nebraska | ELA | 2016 | 2023 |
Nebraska | Math | 2016 | 2023 |
Nebraska | Science | 2016 | 2023 |
Nebraska | Writing | 2016 | 2016 |
Nevada | ELA | 2016 | 2023 |
Nevada | Math | 2016 | 2023 |
Nevada | Science | 2017 | 2023 |
New Hampshire | ELA | 2009 | 2023 |
New Hampshire | Math | 2009 | 2023 |
New Hampshire | Science | 2009 | 2023 |
New Jersey | ELA | 2015 | 2022 |
New Jersey | Math | 2015 | 2022 |
New Jersey | Science | 2019 | 2022 |
New Mexico | ELA | 2017 | 2019 |
New Mexico | Math | 2017 | 2019 |
New Mexico | Science | 2017 | 2019 |
New York | ELA | 2006 | 2022 |
New York | Math | 2006 | 2022 |
New York | Science | 2006 | 2022 |
New York | Social Studies | 2006 | 2010 |
North Carolina | ELA | 2014 | 2023 |
North Carolina | Math | 2014 | 2023 |
North Carolina | Science | 2014 | 2023 |
North Dakota | ELA | 2015 | 2023 |
North Dakota | Math | 2015 | 2023 |
North Dakota | Science | 2015 | 2023 |
Ohio | ELA | 2016 | 2023 |
Ohio | Math | 2016 | 2023 |
Ohio | Science | 2016 | 2023 |
Ohio | Social Studies | 2016 | 2018 |
Oklahoma | ELA | 2017 | 2023 |
Oklahoma | Math | 2017 | 2023 |
Oklahoma | Science | 2017 | 2023 |
Oregon | ELA | 2015 | 2023 |
Oregon | Math | 2015 | 2023 |
Oregon | Science | 2015 | 2023 |
Pennsylvania | ELA | 2015 | 2023 |
Pennsylvania | Math | 2015 | 2023 |
Pennsylvania | Science | 2015 | 2023 |
Rhode Island | ELA | 2018 | 2023 |
Rhode Island | Math | 2018 | 2023 |
Rhode Island | Science | 2019 | 2023 |
South Carolina | ELA | 2016 | 2023 |
South Carolina | Math | 2016 | 2023 |
South Carolina | Science | 2016 | 2023 |
South Carolina | Social Studies | 2016 | 2019 |
South Dakota | ELA | 2003 | 2023 |
South Dakota | Math | 2003 | 2023 |
South Dakota | Science | 2007 | 2023 |
Tennessee | ELA | 2010 | 2023 |
Tennessee | Math | 2010 | 2023 |
Tennessee | Science | 2010 | 2023 |
Tennessee | Social Studies | 2013 | 2023 |
Texas | ELA | 2012 | 2023 |
Texas | Math | 2012 | 2023 |
Texas | Science | 2012 | 2023 |
Texas | Social Studies | 2012 | 2023 |
Texas | Writing | 2012 | 2021 |
Utah | ELA | 2014 | 2023 |
Utah | Math | 2014 | 2023 |
Utah | Science | 2014 | 2023 |
Vermont | ELA | 2016 | 2022 |
Vermont | Math | 2016 | 2022 |
Vermont | Science | 2019 | 2022 |
Virginia | ELA | 1998 | 2023 |
Virginia | Math | 1998 | 2023 |
Virginia | Reading | 1998 | 2005 |
Virginia | Science | 1998 | 2023 |
Virginia | Social Studies | 1998 | 2014 |
Virginia | STEM | 1998 | 2002 |
Virginia | Writing | 1998 | 2023 |
Washington | ELA | 2015 | 2023 |
Washington | Math | 2015 | 2023 |
Washington | Science | 2018 | 2023 |
West Virginia | ELA | 2015 | 2023 |
West Virginia | Math | 2015 | 2023 |
West Virginia | Science | 2019 | 2023 |
Wisconsin | ELA | 2016 | 2023 |
Wisconsin | Math | 2016 | 2023 |
Wisconsin | Science | 2016 | 2023 |
Wisconsin | Social Studies | 2016 | 2023 |
Wyoming | ELA | 2014 | 2023 |
Wyoming | Math | 2014 | 2023 |
Wyoming | Science | 2014 | 2023 |
Wyoming | Writing | 2014 | 2014 |
The Zelma codebook provides the full list of variables contained in all state data files, as well as a brief description of each variable, value labels, and the data source. Not all files have available data for all variables; in other words, even though all files have all variables in the file, some fields may be empty. The codebook can also be accessed via a CSV download.
The data sources for all variables include the National Center for Education Statistics (“NCES”), raw data or information from state education agencies (“SEA”), and flags for changes in assessments contributed by Zelma as a guide for researchers interested in comparing data over time (“Zelma”).
Category | Variable | Description | Source |
---|---|---|---|
01_Directory | State | State name | NCES |
01_Directory | StateAbbrev | State abbreviation | NCES |
01_Directory | StateFips | State FIPS ID | NCES |
01_Directory | SchYear | School year in which the data were reported (e.g., 2021-22 represents data from Spring 2022) | SEA |
01_Directory | DataLevel | Level at which the data are reported (State, District, School) | SEA |
01_Directory | DistName | District name | SEA |
01_Directory | DistType | District type (Regular local school district, Component district, Local school district that is a component of a supervisory union, Supervisory union, Regional education service agency, State-operated agency, Federal-operated agency, Charter agency, Specialized public school district, Other education agency) | NCES |
01_Directory | SchName | School name | SEA |
01_Directory | SchType | School type (Regular school, Special education school, Vocational school, Other/alternative school, Reportable program) | NCES |
02_ID | NCESDistrictID | NCES district ID | NCES |
02_ID | StateAssignedDistID | State-assigned district ID | SEA |
02_ID | State_leaid | State LEA ID | NCES |
02_ID | NCESSchoolID | NCES school ID | NCES |
02_ID | StateAssignedSchID | State-assigned school ID | SEA |
02_ID | seasch | NCES | |
03_NCES | DistCharter | Charter indicator - district (Yes, No) | NCES |
03_NCES | SchLevel | School level (Prekindergarten, Primary, Middle, High, Adult Education, Not applicable, Missing/not reported, Secondary, Ungraded, Other) | NCES |
03_NCES | SchVirtual | Virtual school indicator Yes, No, Missing/not reported | NCES |
03_NCES | CountyName | County in which the district or school is located. | NCES (county_name) |
03_NCES | CountyCode | County code in which the district or school is located, also referred to as the county-level FIPS code | NCES |
04_Test | AssmtName | Name of state assessment | SEA |
02_Test | AssmtType | Assessment type (Regular, Regular and alt) | SEA |
01_Test | Subject | Assessment subject area (ela, math, sci, eng, read, wri, stem, soc) | SEA |
01_Test | GradeLevel | Grade tested (G03, G04, G05, G06, G07, G08, G38) | SEA |
01_Test | StudentGroup | Student demographic group (All Students, RaceEth, Ethnicity, EL Status, Economic Status, Gender) | SEA |
01_Test | StudentGroup_TotalTested | Number of tested students in the designated StudentGroup | SEA |
01_Test | StudentSubGroup | Student demographic subgroup. All Students:
RaceEth:
Ethnicity:
EL Status:
Economic Status:
Gender:
| SEA |
01_Test | StudentSubGroup_TotalTested | Number of tested students in the designated Student Sub-Group. | SEA |
02_Perf | Lev1_count | Count of students within subgroup performing at Level 1. | SEA |
02_Perf | Lev1_percent | Percent of students within subgroup performing at Level 1. | SEA |
02_Perf | Lev2_count | Count of students within subgroup performing at Level 2. | SEA |
02_Perf | Lev2_percent | Percent of students within subgroup performing at Level 2. | SEA |
02_Perf | Lev3_count | Count of students within subgroup performing at Level 3. | SEA |
02_Perf | Lev3_percent | Percent of students within subgroup performing at Level 3. | SEA |
02_Perf | Lev4_count | Count of students within subgroup performing at Level 4. | SEA |
02_Perf | Lev4_percent | Percent of students within subgroup performing at Level 4. | SEA |
02_Perf | Lev5_count | Count of students within subgroup performing at Level 5. | SEA |
02_Perf | Lev5_percent | Percent of students within subgroup performing at Level 5. | SEA |
02_Perf | AvgScaleScore | Avg scale score within subgroup. | SEA |
03_Proficiency | ProficiencyCriteria | Levels included in determining proficiency status. | SEA |
03_Proficiency | ProficientOrAbove_count | Count of students achieving proficiency or above on the state assessment. | SEA |
03_Proficiency | ProficientOrAbove_percent | Percent of students achieving proficiency or above on the state assessment. | SEA |
04_Partic | ParticipationRate | Participation rate | SEA |
05_TestFlags | Flag_AsstNameChange | Flag denoting a change in the assessment's name from the prior year only. (Y = change, N = no change) | Zelma |
05_TestFlags | Flag_CutScoreChange_ELA | Flag denoting a change in scoring determinations in ELA from the prior year only. (Y = change, N = no change) | Zelma |
05_TestFlags | Flag_CutScoreChange_math | Flag denoting a change in scoring determinations in math from the prior year only. (Y = change, N = no change) | Zelma |
05_TestFlags | Flag_CutScoreChange_sci | Flag denoting a change in scoring determinations in science from the prior year only. (Y = change, N = no change) | Zelma |
05_TestFlags | Flag_CutScoreChange_read | Flag denoting a change in scoring determinations in reading from the prior year only. (Y = change, N = no change) | Zelma |
05_TestFlags | Flag_CutScoreChange_oth | Flag denoting a change in scoring determinations in a subject other than math, ELA or science from the prior year only. (Y = change, N = no change) | Zelma |