zelma

Coming soon! Zelma version 1.1 will launch mid-June, including additional state and student subgroup data.

Export Data

Download data from any state in csv format.

Data Availability

There may be intermittent years missing if the state did not publish data, for example due to field testing a new assesment.
StateSubjectDate StartDate End
AlabamaELA20152023
AlabamaMath20152023
AlabamaScience20152023
AlaskaELA20172022
AlaskaMath20172022
AlaskaScience20172022
ArizonaELA20102023
ArizonaMath20102023
ArizonaScience20102023
ArizonaWriting20102014
ArkansasELA20092023
ArkansasEnglish20162023
ArkansasMath20092023
ArkansasReading20162023
ArkansasScience20092023
ArkansasSTEM20162023
ArkansasWriting20162017
CaliforniaELA20102023
CaliforniaMath20102023
CaliforniaScience20102013
CaliforniaSocial Studies20102013
ColoradoELA20152023
ColoradoMath20152023
ColoradoScience20142023
ColoradoSocial Studies20142015
ConnecticutELA20152023
ConnecticutMath20152023
ConnecticutScience20192023
DelawareELA20152023
DelawareMath20152023
DelawareScience20152023
DelawareSocial Studies20152022
District of ColumbiaELA20152023
District of ColumbiaMath20152023
District of ColumbiaScience20192022
FloridaELA20152023
FloridaMath20152023
FloridaScience20152023
GeorgiaELA20112022
GeorgiaMath20112022
GeorgiaReading20112014
GeorgiaScience20112022
GeorgiaSocial Studies20112022
HawaiiELA20152023
HawaiiMath20152023
HawaiiScience20222023
IdahoELA20152023
IdahoMath20152023
IdahoScience20152023
IllinoisELA20152023
IllinoisMath20152023
IllinoisScience20162023
IndianaELA20052023
IndianaMath20052023
IndianaScience20112023
IndianaSocial Studies20112023
IowaELA20132023
IowaMath20132023
IowaScience20192023
KansasELA20152023
KansasMath20152023
KansasScience20192023
KentuckyELA20122023
KentuckyMath20122023
KentuckyScience20122023
KentuckySocial Studies20122023
KentuckyWriting20122023
LouisianaELA20142023
LouisianaMath20142023
LouisianaScience20142023
LouisianaSocial Studies20142023
MarylandELA20152023
MarylandMath20152023
MarylandScience20152023
MassachusettsELA20102023
MassachusettsMath20102023
MassachusettsScience20102023
MichiganELA20152023
MichiganMath20152023
MichiganScience20152023
MichiganSocial Studies20152023
MinnesotaELA19982023
MinnesotaMath19982023
MinnesotaScience20082023
MinnesotaWriting19982005
MississippiELA20142023
MississippiMath20142023
MississippiScience20142023
MissouriELA20102022
MissouriMath20102022
MissouriScience20102022
MontanaELA20162023
MontanaMath20162023
MontanaScience20222023
NebraskaELA20162023
NebraskaMath20162023
NebraskaScience20162023
NebraskaWriting20162016
NevadaELA20162023
NevadaMath20162023
NevadaScience20172023
New HampshireELA20092023
New HampshireMath20092023
New HampshireScience20092023
New JerseyELA20152022
New JerseyMath20152022
New JerseyScience20192022
New MexicoELA20172019
New MexicoMath20172019
New MexicoScience20172019
New YorkELA20062022
New YorkMath20062022
New YorkScience20062022
New YorkSocial Studies20062010
North CarolinaELA20142023
North CarolinaMath20142023
North CarolinaScience20142023
North DakotaELA20152023
North DakotaMath20152023
North DakotaScience20152023
OhioELA20162023
OhioMath20162023
OhioScience20162023
OhioSocial Studies20162018
OklahomaELA20172023
OklahomaMath20172023
OklahomaScience20172023
OregonELA20152023
OregonMath20152023
OregonScience20152023
PennsylvaniaELA20152023
PennsylvaniaMath20152023
PennsylvaniaScience20152023
Rhode IslandELA20182023
Rhode IslandMath20182023
Rhode IslandScience20192023
South CarolinaELA20162023
South CarolinaMath20162023
South CarolinaScience20162023
South CarolinaSocial Studies20162019
South DakotaELA20032023
South DakotaMath20032023
South DakotaScience20072023
TennesseeELA20102023
TennesseeMath20102023
TennesseeScience20102023
TennesseeSocial Studies20132023
TexasELA20122023
TexasMath20122023
TexasScience20122023
TexasSocial Studies20122023
TexasWriting20122021
UtahELA20142023
UtahMath20142023
UtahScience20142023
VermontELA20162022
VermontMath20162022
VermontScience20192022
VirginiaELA19982023
VirginiaMath19982023
VirginiaReading19982005
VirginiaScience19982023
VirginiaSocial Studies19982014
VirginiaSTEM19982002
VirginiaWriting19982023
WashingtonELA20152023
WashingtonMath20152023
WashingtonScience20182023
West VirginiaELA20152023
West VirginiaMath20152023
West VirginiaScience20192023
WisconsinELA20162023
WisconsinMath20162023
WisconsinScience20162023
WisconsinSocial Studies20162023
WyomingELA20142023
WyomingMath20142023
WyomingScience20142023
WyomingWriting20142014
Codebook

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”).

CategoryVariableDescriptionSource
01_DirectoryState

State name

NCES
01_DirectoryStateAbbrev

State abbreviation

NCES
01_DirectoryStateFips

State FIPS ID

NCES
01_DirectorySchYear

School year in which the data were reported (e.g., 2021-22 represents data from Spring 2022)

SEA
01_DirectoryDataLevel

Level at which the data are reported (State, District, School)

SEA
01_DirectoryDistName

District name

SEA
01_DirectoryDistType

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_DirectorySchName

School name

SEA
01_DirectorySchType

School type (Regular school, Special education school, Vocational school, Other/alternative school, Reportable program)

NCES
02_IDNCESDistrictID

NCES district ID

NCES
02_IDStateAssignedDistID

State-assigned district ID

SEA
02_IDState_leaid

State LEA ID

NCES
02_IDNCESSchoolID

NCES school ID

NCES
02_IDStateAssignedSchID

State-assigned school ID

SEA
02_IDseasch
NCES
03_NCESDistCharter

Charter indicator - district (Yes, No)

NCES
03_NCESSchLevel

School level (Prekindergarten, Primary, Middle, High, Adult Education, Not applicable, Missing/not reported, Secondary, Ungraded, Other)

NCES
03_NCESSchVirtual

Virtual school indicator Yes, No, Missing/not reported

NCES
03_NCESCountyName

County in which the district or school is located.

NCES (county_name)
03_NCESCountyCode

County code in which the district or school is located, also referred to as the county-level FIPS code

NCES
04_TestAssmtName

Name of state assessment

SEA
02_TestAssmtType

Assessment type (Regular, Regular and alt)

SEA
01_TestSubject

Assessment subject area (ela, math, sci, eng, read, wri, stem, soc)

SEA
01_TestGradeLevel

Grade tested (G03, G04, G05, G06, G07, G08, G38)

SEA
01_TestStudentGroup

Student demographic group (All Students, RaceEth, Ethnicity, EL Status, Economic Status, Gender)

SEA
01_TestStudentGroup_TotalTested

Number of tested students in the designated StudentGroup

SEA
01_TestStudentSubGroup

Student demographic subgroup.

All Students:

  • All Students

RaceEth:

  • American Indian or Alaska Native
  • Asian
  • Black or African American
  • Native Hawaiian or Pacific Islander
  • Two or More
  • White
  • Hispanic or Latino
  • Unknown

Ethnicity:

  • Hispanic or Latino
  • Not Hispanic or Latino

EL Status:

  • English Learner
  • English Proficient
  • Other

Economic Status:

  • Economically Disadvantaged
  • Not Economically Disadvantaged
  • Other

Gender:

  • Male
  • Female
  • Unknown
SEA
01_TestStudentSubGroup_TotalTested

Number of tested students in the designated Student Sub-Group.

SEA
02_PerfLev1_count

Count of students within subgroup performing at Level 1.

SEA
02_PerfLev1_percent

Percent of students within subgroup performing at Level 1.

SEA
02_PerfLev2_count

Count of students within subgroup performing at Level 2.

SEA
02_PerfLev2_percent

Percent of students within subgroup performing at Level 2.

SEA
02_PerfLev3_count

Count of students within subgroup performing at Level 3.

SEA
02_PerfLev3_percent

Percent of students within subgroup performing at Level 3.

SEA
02_PerfLev4_count

Count of students within subgroup performing at Level 4.

SEA
02_PerfLev4_percent

Percent of students within subgroup performing at Level 4.

SEA
02_PerfLev5_count

Count of students within subgroup performing at Level 5.

SEA
02_PerfLev5_percent

Percent of students within subgroup performing at Level 5.

SEA
02_PerfAvgScaleScore

Avg scale score within subgroup.

SEA
03_ProficiencyProficiencyCriteria

Levels included in determining proficiency status.

SEA
03_ProficiencyProficientOrAbove_count

Count of students achieving proficiency or above on the state assessment.

SEA
03_ProficiencyProficientOrAbove_percent

Percent of students achieving proficiency or above on the state assessment.

SEA
04_ParticParticipationRate

Participation rate

SEA
05_TestFlagsFlag_AsstNameChange

Flag denoting a change in the assessment's name from the prior year only. (Y = change, N = no change)

Zelma
05_TestFlagsFlag_CutScoreChange_ELA

Flag denoting a change in scoring determinations in ELA from the prior year only. (Y = change, N = no change)

Zelma
05_TestFlagsFlag_CutScoreChange_math

Flag denoting a change in scoring determinations in math from the prior year only. (Y = change, N = no change)

Zelma
05_TestFlagsFlag_CutScoreChange_sci

Flag denoting a change in scoring determinations in science from the prior year only. (Y = change, N = no change)

Zelma
05_TestFlagsFlag_CutScoreChange_read

Flag denoting a change in scoring determinations in reading from the prior year only. (Y = change, N = no change)

Zelma
05_TestFlagsFlag_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

Data Documentation

Current Version: 1.0
Data Documentation Version 1.0 PDF
Download Previous Versions
©2023 Zelma Education
X