This file includes Report Card spring assessment data from 2014-15 through the most current year of data. Data is disaggregated by school, district, and the state level and includes counts of students by the following groups: grade level, gender, race/ethnicity, and student programs and special characteristics. Please review the notes below for more information and notes for downloading this data.
This dataset has the following 29 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
SchoolYear | schoolyear | text | The school year the test was administered | 2018-19 2017-18 2016-17 2015-16 2014-15 view top 100 |
OrganizationLevel | organizationlevel | text | This field designates if the data is for a school, district, or the state. | School District ESD State view top 100 |
County | county | text | King Pierce Snohomish Spokane Clark view top 100 | |
ESDName | esdname | text | Educational Servce DIstrict Name | Puget Sound Educational Service District 121 Northwest Educational Service District 189 Educational Service District 101 Educational Service District 112 Capital Region ESD 113 view top 100 |
ESDOrganizationID | esdorganizationid | text | Educational Servce DIstrict ID | 100006 100009 100001 100003 100004 view top 100 |
DistrictCode | districtcode | text | Unique district code | 17001 32081 27010 17415 17414 view top 100 |
DistrictName | districtname | text | Seattle School District #1 Spokane School District Tacoma School District Kent School District Lake Washington School District view top 100 | |
DistrictOrganizationId | districtorganizationid | text | unique district ID | 100229 100247 100261 100117 100127 view top 100 |
SchoolCode | schoolcode | text | Unique school code | 4412 2714 5291 2842 5175 view top 100 |
SchoolName | schoolname | text | District Total Jefferson Elementary Washington Elementary School Roosevelt Elementary School Cascade Middle School view top 100 | |
SchoolOrganizationid | schoolorganizationid | text | Unique school ID | 102372 103167 105536 101266 104944 view top 100 |
CurrentSchoolType | currentschooltype | text | P A S R J view top 100 | |
StudentGroupType | studentgrouptype | text | Gender, Race/Ethnicity, Student Programs and Characteristics | Race Gender FRL SWD ELL view top 100 |
StudentGroup | studentgroup | text | A subgroup of StudentGroupType. designates specific gender, race/ethnicity, or programs and characteristics associated with the data. | All Students Non-Foster Care Non Section 504 Non-Homeless Non Migrant view top 100 |
GradeLevel | gradelevel | text | All Grades 05 04 03 08 view top 100 | |
TestAdministration | testadministration | text | This field designates the assessment: Access to Instruction and Measurement (AIM), Smarter Ballance Assessment Consortium (SBAC), Washington Comprehensive Assessment of Science (WCAS), and English Learner Progress Assessment (ELPA) | SBAC ELPA AIM WCAS MSPHSPE view top 100 |
TestSubject | testsubject | text | Designates the tested subject: Science, English Language Arts (ELA), Science, ELPA, and WIDA | ELA Math ELPA Science Biology view top 100 |
Suppression | suppression | text | This field designates if suppression was applied to the row | N<10 None Cross Student Group - N<10 <10% Cross Organization - N<10 view top 100 |
Count of Students Expected to Test | count_of_students_expected | text | Count of students expected to test (excluding students the previously passed the assessment) | NULL 13 12 11 15 view top 100 |
CountMetStandard | countmetstandard | text | Of the students that were expected to test, this is the count of students that met standard. Includes students that previously passed the assessment | NULL 4 5 6 3 view top 100 |
CountofStudentsExpectedtoTest(including previously passed) | count_of_students_expected_to_test_including_previously_passed | text | Count of students expected to test (including students the previously passed the assessment) | NULL 13 12 11 15 view top 100 |
PercentMetStandard | percentmetstandard | text | A percent of students that met standard (CountMetStandard divided by Count of Students expected to test including previously passed) | Suppressed: N<10 <10% No Students 50.0% 33.3% view top 100 |
PercentLevel1 | percentlevel1 | text | Percent of students that scored level 1: not proficient | NULL 0.0000000000000 0.2000000000000 0.2500000000000 0.3333333333333 view top 100 |
PercentLevel2 | percentlevel2 | text | Percent of students that scored level 2: not proficient | NULL 0.2500000000000 0.2000000000000 0.3333333333333 0.1666666666666 view top 100 |
PercentLevel3 | percentlevel3 | text | Percent of students that scored level 3: proficient | NULL 0.3333333333333 0.2500000000000 0.2000000000000 0.1666666666666 view top 100 |
PercentLevel4 | percentlevel4 | text | Percent of students that scored level 4: proficient | NULL 0.0000000000000 0.2000000000000 0.2500000000000 0.1666666666666 view top 100 |
PercentMetTestedOnly | percentmettestedonly | text | Percent of Students that met Standard (using only students that tested as denominator) | NULL 0.5000000000000 0.3333333333333 0.6666666666666 0.2000000000000 view top 100 |
Percent No Score | percent_no_score | text | Percent of students that were not given a score | NULL 0.0000000000000 0.1000000000000 0.0909090909090 0.0833333333333 view top 100 |
DataAsOf | dataasof | calendar_date | Date data was extracted | 2022-02-09T00:00:00.000 view top 100 |