This file includes Report Card assessment data from 2017-18 school year. 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.
This dataset has the following 31 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| SchoolYear | schoolyear | text | The school year the test was administered | 2017-18 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 No. 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 | 1685 2842 4412 3489 5276 view top 100 |
| SchoolName | schoolname | text | District Total ESD Total Washington Elementary School Roosevelt Elementary School Jefferson Elementary view top 100 | |
| SchoolOrganizationid | schoolorganizationid | text | Unique school ID | NULL 102514 101266 102372 101503 view top 100 |
| CurrentSchoolType | currentschooltype | text | P A 5 S R view top 100 | |
| StudentGroupType | studentgrouptype | text | Gender, Race/Ethnicity, Student Programs and Characteristics | Race Gender FRL SWD homeless 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 Military Parent Non-Homeless view top 100 |
| GradeLevel | gradelevel | text | All Grades 05 03 04 08 view top 100 | |
| Test Administration (group) | test_administration_group | text | General, Alternate, or Other. This field designates the type of assessment General refers to the standard SBAC (ELA & Math) and WCAS (Science) assessments, Alternate designates the AIM (ELA, math, and science assessments), Other designates the English Learner Progress Assessment (ELPA) | SBAC ELPA AIM WCAS WIDA 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 WIDA view top 100 |
| TestSubject | testsubject | text | Designates the tested subject: Science, English Language Arts (ELA), Science, ELPA, and WIDA | Math ELA ELPA Science WIDA 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 Student Group - Top/Bottom 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 11 14 16 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 7 view top 100 |
| Count of students expected to test 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 11 14 16 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) | N<10 <10% 50.0% No Students 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 3: 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.4000000000000 view top 100 |
| Percent No Score | percent_no_score | text | Percent of students that were not given a score | NULL 0.0000000000000 0.0909090909090 0.0714285714285 0.0769230769230 view top 100 |
| DataAsOf | dataasof | text | Date data was extracted | 9/8/2023 view top 100 |
| PercentParticipation | percentparticipation | text | Percent of students that received a score | NULL 1.0000000000000 0.9375000000000 0.9500000000000 0.9230769230769 view top 100 |