Data source: Big Local News · About: Big Local

1,263 rows where grade = "grade_5", state = "WA" and year = 2017 sorted by white

View and edit SQL

year

  • 2017 · 1,263

grade

  • grade_5 · 1,263
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white ▼ black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
617407 WA King   school 5300300 17408   Auburn School District 530030002904 1915 Special Ed School   Special Education School No Other PK 12 2017   grade_5 0 1 0   0 0     0   0   0 1 0   0   0   1       0.0 1 0 1 0   0 0     0   0   0 1 0   0 0 1     0 1
618320 WA Kitsap   school 5300660 18100   Bremerton School District 530066001144 4441 Mountain View Middle School   Regular School No Middle 06 08 2017   grade_5 0 0 1   0 0     0   0   1 0 0   0   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 1     0 1
618567 WA Clallam   school 5300840 5401   Cape Flattery School District 530084003042 2594 Neah Bay Elementary School   Regular School No Elementary KG 05 2017   grade_5 0 0 4   11 0     0   4   5 14 0   0   0   17       1.0 19 0 0 4   11 0     0   4   5 14 0   0 0 17     1 19
618733 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108000183 3791 Fairview Middle School   Regular School No Middle 06 08 2017   grade_5 0 0 1   0 0     0   0   1 0 0   0   0   0       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 0     0 1
619971 WA Yakima   school 5305370 39090   East Valley School District (Yakima) 530537000806 4055 East Valley Central Middle School   Regular School No Middle 06 08 2017   grade_5 0 0 1   0 0     0   0   1 0 0   0   1   1       0.0 1 0 0 1   0 0     0   0   1 0 0   0 1 1     0 1
620212 WA Snohomish   school 5302400 31015   Edmonds School District 530240002821 1830 Contracted Schools   Special Education School No Other 04 12 2017   grade_5 0 0 0   0 0     0   1   1 0 0   0   0   0       0.0 1 0 0 0   0 0     0   1   1 0 0   0 0 0     0 1
620313 WA Snohomish   school 5302400 31015   Edmonds School District 530240000349 3818 Maplewood Center (Closed after 2016-2017 school year)   Special Education School No Other KG 12 2017   grade_5 0 0 1   0 0     0   0   0 1 0   0   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 1     0 1
620423 WA Snohomish   school 5302400 31015   Edmonds School District 530240002290 1558 Unassigned School   Special Education School No Other PK 09 2017   grade_5 0 0 1   0 0     0   0   0 1 0   0   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 1     0 1
620667 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000502917 3294 Cowlitz County Youth Services Center   Regular School No Other 06 12 2017   grade_5 0 0 0   0 0     0   1   1 0 0   0   0   0       0.0 1 0 0 0   0 0     0   1   1 0 0   0 0 0     0 1
621264 WA King   school 5302820 17210   Federal Way School District 530282002638 1759 Internet Academy   Alternative School No Other PK 12 2017   grade_5 0 1 1   0 2     0   1   1 4 0   0   0   2       0.0 5 0 1 1   0 2     0   1   1 4 0   0 0 2     0 5
621853 WA Snohomish   school 5303210 31332   Granite Falls School District 530321002303 4330 Mountain Way Elementary   Regular School No Elementary KG 02 2017   grade_5 0 0 1   0 0     0   0   1 0 0   0   0   0       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 0     0 1
622238 WA Ferry   school 5300002 10070   Inchelium School District 530000202871 4215 Inchelium Elementary School   Regular School No Elementary KG 05 2017   grade_5 0 0 0   12 0     0   5   6 11 0   8   0   15       0.0 17 0 0 0   12 0     0   5   6 11 0   8 0 15     0 17
622470 WA Ferry   school 5303870 10003   Keller School District 530387000586 2602 Keller Elementary School   Regular School No Elementary KG 06 2017   grade_5 0 0 0   4 0     0   0   3 1 0   0   1   2       0.0 4 0 0 0   4 0     0   0   3 1 0   0 1 2     0 4
623538 WA King   school 5304230 17414   Lake Washington School District 530423000672 2308 Kirkland Middle School   Regular School No Middle 06 08 2017   grade_5 0 1 0   0 0     0   0   1 0 0   0   0   0       0.0 1 0 1 0   0 0     0   0   1 0 0   0 0 0     0 1
623632 WA King   school 5304230 17414   Lake Washington School District 530423000680 3232 Redmond Middle School   Regular School No Middle 06 08 2017   grade_5 0 0 0   0 1     0   0   1 0 0   1   0   0       0.0 1 0 0 0   0 1     0   0   1 0 0   1 0 0     0 1
623902 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2017   grade_5 0 0 0   22 0     0   0   10 12 0   0   0   19       0.0 22 0 0 0   22 0     0   0   10 12 0   0 0 19     0 22
624679 WA Grant   school 5305220 13161   Moses Lake School District 530522002625 2673 Frontier Middle School   Regular School No Middle 06 08 2017   grade_5 0 0 1   0 0     0   0   0 1 0   0   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 1     0 1
624975 WA King   school   17903   Muckleshoot Indian Tribe   1986 Muckleshoot Tribal School             2017   grade_5 0 1 0   32 0     0   0   18 15 0   0   0   30       0.0 33 0 1 0   32 0     0   0   18 15 0   0 0 30     0 33
625632 WA Thurston   school   34003   North Thurston Public Schools   8407 Wa He Lut Indian School(Closed)             2017   grade_5 0 0 1   10 0     0   0   5 6 0   0   0   4       0.0 11 0 0 1   10 0     0   0   5 6 0   0 0 4     0 11
626567 WA Douglas   school 5306510 9102   Palisades School District 530651000959 2502 Palisades Elementary School   Regular School No Elementary KG 05 2017   grade_5 0 0 3   0 0     0   0   3 0 0   1   0   3       0.0 3 0 0 3   0 0     0   0   3 0 0   1 0 3     0 3
627135 WA Pierce   school   27003   Puyallup School District   4110 Chief Leschi Schools(Closed)             2017   grade_5 0 0 3   48 0     0   5   28 28 0   0   1   13       1.0 56 0 0 3   48 0     0   5   28 28 0   0 1 13     1 56
627426 WA Clallam   school   5903   Quileute Tribal School District   5430 Quileute Tribal School             2017   grade_5 0 0 1   7 0     0   0   4 4 0   0   0   7       0.0 8 0 0 1   7 0     0   0   4 4 0   0 0 7     0 8
627674 WA King   school 5307230 17403   Renton School District 530723001079 3035 McKnight Middle School   Regular School No Middle 06 08 2017   grade_5 0 0 0   0 1     0   0   0 1 0   0   0   0       0.0 1 0 0 0   0 1     0   0   0 1 0   0 0 0     0 1
628091 WA Klickitat   school 5307530 20403   Roosevelt School District 530753001119 3530 Roosevelt Elementary School   Regular School No Elementary KG 06 2017   grade_5 0 0 3   0 0     0   0   1 2 0   3   0   0       0.0 3 0 0 3   0 0     0   0   1 2 0   3 0 0     0 3
628194 WA King   school 5307710 17001   Seattle School District No. 1 530771001173 2307 Bailey Gatzert Elementary School   Regular School No Elementary PK 05 2017   grade_5 0 25 12   0 10     0   4   25 26 0   10   10   41       0.0 51 0 25 12   0 10     0   4   25 26 0   10 10 41     0 51
628307 WA King   school 5307710 17001   Seattle School District No. 1 530771001161 2321 Dunlap Elementary School   Regular School No Elementary PK 05 2017   grade_5 0 21 12   1 9     1   2   24 22 0   12   14   41       0.0 46 0 21 12   1 9     1   2   24 22 0   12 14 41     0 46
628571 WA King   school 5307710 17001   Seattle School District No. 1 530771001143 2089 Martin Luther King Jr. Elementary School   Regular School No Elementary PK 05 2017   grade_5 0 16 7   0 19     2   3   31 16 0   10   6   31       1.0 47 0 16 7   0 19     2   3   31 16 0   10 6 31     1 47
629540 WA Pacific   school 5308100 25118   South Bend School District 530810003365 5243 Pacific Virtual Learning   Alternative School No Other KG 12 2017   grade_5 0 0 0   0 1     0   0   1 0 0   0   1   0       0.0 1 0 0 0   0 1     0   0   1 0 0   0 1 0     0 1
629619 WA Kitsap   school 5308160 18402   South Kitsap School District 530816001351 3046 Marcus Whitman Middle School   Regular School No Other 07 09 2017   grade_5 0 0 1   0 0     0   0   1 0 0   0   0   0       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 0     0 1
630967 WA Grays Harbor   school 5308730 14077   Taholah School District 530873002956 5032 Taholah Elementary & Middle School   Regular School No Elementary KG 08 2017   grade_5 0 0 3   11 0     0   0   9 5 0   0   2   9       0.0 14 0 0 3   11 0     0   0   9 5 0   0 2 9     0 14
631134 WA Yakima   school 5308970 39202   Toppenish School District 530897001531 2608 Garfield Elementary School   Regular School No Elementary KG 05 2017   grade_5 0 0 63   11 0     0   0   42 32 0   44   1   70       0.0 74 0 0 63   11 0     0   0   42 32 0   44 1 70     0 74
631364 WA Pierce   school 5309180 27083   University Place School District 530918001552 3792 Chambers Elementary   Regular School No Elementary KG 04 2017   grade_5 0 1 0   0 0     0   0   1 0 0   0   0   1       0.0 1 0 1 0   0 0     0   0   1 0 0   0 0 1     0 1
631721 WA King   school 5309300 17402   Vashon Island School District 530930002720 1822 Family Link   Alternative School No Other KG 12 2017   grade_5 0 0 0   0 1     0   0   1 0 0   0   0   0       0.0 1 0 0 0   0 1     0   0   1 0 0   0 0 0     0 1
631796 WA Walla Walla   school 5309390 36401   Waitsburg School District 530939002492 2174 Preston Hall Middle School   Regular School No Middle 06 08 2017   grade_5 0 0 0   0 0     0   1   1 0 0   0   0   1       0.0 1 0 0 0   0 0     0   1   1 0 0   0 0 1     0 1
632050 WA Stevens   school 5309630 33049   Wellpinit School District #49 530963003146 2549 Wellpinit Elementary School   Regular School No Elementary KG 05 2017   grade_5 0 0 2   15 0     0   4   13 8 0   6   8   19       0.0 21 0 0 2   15 0     0   4   13 8 0   6 8 19     0 21
632581 WA Yakima   school 5310110 39007   Yakima School District 531011001692 2176 Garfield Elementary School   Regular School No Elementary KG 05 2017   grade_5 0 2 82   0 0     0   0   38 46 0   47   1   79       0.0 84 0 2 82   0 0     0   0   38 46 0   47 1 79     0 84
617442 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033003113 1939 Bainbridge Special Education Services   Special Education School No Other PK 12 2017   grade_5 1 0 1   0 0     0   0   2 0 0   0   0   0       0.0 2 1 0 1   0 0     0   0   2 0 0   0 0 0     0 2
617670 WA King   school 5300390 17405   Bellevue School District 530039003434 5281 Central Educational Services   Regular School No Other PK 13 2017   grade_5 1 0 0   0 0     0   1   2 0 0   0   0   0       0.0 2 1 0 0   0 0     0   1   2 0 0   0 0 0     0 2
618520 WA Clark   school 5300810 6117   Camas School District 530081003066 5054 Liberty Middle School   Regular School No Middle 06 08 2017   grade_5 1 0 0   0 0     0   0   1 0 0   1   0   0       1.0 1 1 0 0   0 0     0   0   1 0 0   1 0 0     1 1
618597 WA Chelan   school 5300950 4228   Cascade School District 530095002937 4566 Beaver Valley School   Regular School No Elementary KG 04 2017   grade_5 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
618610 WA Chelan   school 5300950 4228   Cascade School District 530095003528 5418 Cascade Home-Link   Regular School No Elementary KG 08 2017   grade_5 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
619250 WA Asotin   school 5301320 2250   Clarkston School District 530132002613 3616 Special Services   Special Education School No Other PK 12 2017   grade_5 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
619423 WA Pierce   school 5301410 27400   Clover Park School District 530141001897 3910 Oak Grove   Regular School No Elementary KG 06 2017   grade_5 1 0 1   0 0     0   1   2 1 0   0   0   0       0.0 3 1 0 1   0 0     0   1   2 1 0   0 0 0     0 3
619461 WA Pierce   school 5301410 27400   Clover Park School District 530141002862 1882 Special Education Services/relife   Special Education School No Other PK 12 2017   grade_5 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
620547 WA King   school 5300001 17216   Enumclaw School District 530000102054 4210 Enumclaw Middle School   Regular School No Middle 06 08 2017   grade_5 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
620591 WA Grant   school 5302610 13165   Ephrata School District 530261002934 4229 Beezley Springs Elementary   Special Education School No Elementary PK 01 2017   grade_5 1 0 2   0 0     0   0   2 1 0   0   0   2       0.0 3 1 0 2   0 0     0   0   2 1 0   0 0 2     0 3
620624 WA Grant   school 5302610 13165   Ephrata School District 530261000388 3092 Grant Elementary   Regular School No Elementary KG 04 2017   grade_5 1 0 1   0 0     0   0   2 0 0   0   0   2       0.0 2 1 0 1   0 0     0   0   2 0 0   0 0 2     0 2
621663 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294000481 3401 Perry G Keithley Middle School   Regular School No Middle 06 08 2017   grade_5 1 0 0   0 0     0   1   1 1 0   0   0   0       0.0 2 1 0 0   0 0     0   1   1 1 0   0 0 0     0 2
622219 WA Grays Harbor   school 5303660 14028   Hoquiam School District 530366003290 5191 Hoquiam Homelink School   Regular School No Other KG 12 2017   grade_5 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
623158 WA Clark   school 5304170 6101   La Center School District 530417003451 5326 La Center Home School Academy   Alternative School No Other KG 12 2017   grade_5 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
623219 WA Chelan   school 5301200 4129   Lake Chelan School District 530120000219 3861 Holden Village Community School   Regular School No Other KG 12 2017   grade_5 1 1 0   0 0     0   1   2 1 0   0   0   1       0.0 3 1 1 0   0 0     0   1   2 1 0   0 0 1     0 3
623392 WA King   school 5304230 17414   Lake Washington School District 530423001598 1649 Contractual Schools   Alternative School No Other PK 12 2017   grade_5 1 0 0   0 0     0   1   2 0 0   0   0   1       0.0 2 1 0 0   0 0     0   1   2 0 0   0 0 1     0 2
623872 WA San Juan   school 5304530 28144   Lopez School District 530453003419 5299 CVA-Lopez Island (Closed after 2018-2019 school year)   Alternative School No Other KG 12 2017   grade_5 1 1 0   0 0     0   0   2 0 0   0   0   1       0.0 2 1 1 0   0 0     0   0   2 0 0   0 0 1     0 2
624061 WA Stevens   school 5304830 33207   Mary Walker School District 530483003591 5446 Mary Walker Alternative Learning Experience   Alternative School No Other KG 12 2017   grade_5 1 0 1   0 0     0   1   3 0 0   0   0   3       0.0 3 1 0 1   0 0     0   1   3 0 0   0 0 3     0 3
624204 WA Snohomish   school 5304860 31025   Marysville School District 530486002900 1910 Marysville SD Special   Special Education School No Other PK 13 2017   grade_5 1 0 1   1 0     0   0   3 0 0   0   0   2       0.0 3 1 0 1   1 0     0   0   3 0 0   0 0 2     0 3
624236 WA Snohomish   school 5304860 31025   Marysville School District 530486002590 1744 School Home Partnership Program   Alternative School No Elementary KG 08 2017   grade_5 1 0 0   0 0     0   1   2 0 0   0   0   2       0.0 2 1 0 0   0 0     0   1   2 0 0   0 0 2     0 2
624666 WA Grant   school 5305220 13161   Moses Lake School District 530522000785 3022 Chief Moses Middle School   Regular School No Middle 06 08 2017   grade_5 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
625112 WA Snohomish   school 5305430 31006   Mukilteo School District 530543002820 1848 Special Services   Special Education School No Other PK 12 2017   grade_5 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
625187 WA Okanogan   school 5305550 24014   Nespelem School District #14 530555000832 2494 Nespelem Elementary   Regular School No Elementary PK 08 2017   grade_5 1 0 0   12 0     0   0   7 6 0   12   0   13       0.0 13 1 0 0   12 0     0   0   7 6 0   12 0 13     0 13
625342 WA Franklin   school 5305730 11051   North Franklin School District 530573003364 5261 North Franklin Virtual Academy (Closed after 2019-2020 school year)   Alternative School No Elementary KG 06 2017   grade_5 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
625971 WA Island   school 5305940 15201   Oak Harbor School District 530594000901 3939 North Whidbey Middle School   Regular School No Middle 06 08 2017   grade_5 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
626003 WA Island   school 5305940 15201   Oak Harbor School District 530594002047 3662 Special Education   Special Education School No Elementary PK PK 2017   grade_5 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
626182 WA Thurston   school 5306180 34111   Olympia School District 530618000925 3133 Jefferson Middle School   Regular School No Middle 05 08 2017   grade_5 1 0 1   0 0     0   0   2 0 0   0   0   1       0.0 2 1 0 1   0 0     0   0   2 0 0   0 0 1     0 2
626651 WA Franklin   school 5306570 11001   Pasco School District 530657000965 2790 Longfellow Elementary   Regular School No Elementary PK 06 2017   grade_5 1 1 60   0 0     0   0   36 26 0   41   5   60       0.0 62 1 1 60   0 0     0   0   36 26 0   41 5 60     0 62
626962 WA Clallam   school 5306820 5121   Port Angeles School District 530682002551 1715 Parents As Partners (Closed after 2018-2019 school year)   Alternative School No Elementary KG 08 2017   grade_5 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
627438 WA Clallam   school 5307020 5402   Quillayute Valley School District 530702002507 1671 District Run Home School   Alternative School No Other KG 12 2017   grade_5 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
627705 WA King   school 5307230 17403   Renton School District 530723003073 5070 Renton Academy   Alternative School No Other KG 12 2017   grade_5 1 4 0   0 0     0   0   5 0 0   0   0   4       0.0 5 1 4 0   0 0     0   0   5 0 0   0 0 4     0 5
627876 WA Benton   school 5307320 3400   Richland School District 530732002941 2001 Special Programs   Special Education School No Other PK 12 2017   grade_5 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
628299 WA King   school 5307710 17001   Seattle School District No. 1 530771001158 3803 Dearborn Park International School   Regular School No Elementary KG 05 2017   grade_5 1 16 3   0 23     0   4   33 14 0   14   4   39       0.0 47 1 16 3   0 23     0   4   33 14 0   14 4 39     0 47
628319 WA King   school 5307710 17001   Seattle School District No. 1 530771001163 2118 Emerson Elementary School   Regular School No Elementary PK 05 2017   grade_5 1 8 10   0 6     0   6   12 19 0   9   6   24       0.0 31 1 8 10   0 6     0   6   12 19 0   9 6 24     0 31
628701 WA King   school 5307710 17001   Seattle School District No. 1 530771003361 3380 Rainier View Elementary School   Regular School No Elementary PK 05 2017   grade_5 1 15 5   0 12     1   6   18 22 0   6   5   33       2.0 40 1 15 5   0 12     1   6   18 22 0   6 5 33     2 40
628886 WA King   school 5307710 17001   Seattle School District No. 1 530771001267 3581 Wing Luke Elementary School   Regular School No Elementary KG 05 2017   grade_5 1 25 5   0 24     0   3   21 37 0   8   2   44       0.0 58 1 25 5   0 24     0   3   21 37 0   8 2 44     0 58
628986 WA Yakima   school 5307770 39119   Selah School District 530777003348 5231 Selah HomeLink   Regular School No Elementary KG 08 2017   grade_5 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
629077 WA Mason   school 5307900 23309   Shelton School District 530790002151 4288 Choice Middle and High School   Alternative School No Other KG 12 2017   grade_5 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
629103 WA Mason   school 5307900 23309   Shelton School District 530790002990 4586 Olympic Middle School   Regular School No Middle 06 07 2017   grade_5 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
629382 WA Snohomish   school 5308020 31201   Snohomish School District 530802002593 1730 Snohomish Center   Special Education School No Other PK 12 2017   grade_5 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
629451 WA King   school 5308040 17410   Snoqualmie Valley School District 530804003309 5181 Snoqualmie Access   Special Education School No Other PK 12 2017   grade_5 1 0 0   0 0     0   0   1 0 0   0   0   0       1.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     1 1
630030 WA Spokane   school 5308250 32081   Spokane School District 530825002364 1567 Pratt Academy   Alternative School No Other 03 12 2017   grade_5 1 0 0   1 0     0   0   2 0 0   0   1   2       2.0 2 1 0 0   1 0     0   0   2 0 0   0 1 2     2 2
630523 WA Yakima   school 5308670 39201   Sunnyside School District 530867001448 2469 Outlook Elementary School   Regular School No Elementary PK 05 2017   grade_5 1 0 109   0 0     0   2   62 50 0   49   6   106       0.0 112 1 0 109   0 0     0   2   62 50 0   49 6 106     0 112
631177 WA Yakima   school 5308970 39202   Toppenish School District 530897003027 4588 Valley View Elementary   Regular School No Elementary KG 05 2017   grade_5 1 0 67   7 0     0   2   42 35 0   39   3   73       3.0 77 1 0 67   7 0     0   2   42 35 0   39 3 73     3 77
631344 WA Thurston   school 5309100 34033   Tumwater School District 530910001545 3612 Tumwater Middle School   Regular School No Middle 07 08 2017   grade_5 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
631772 WA Grant   school 5309360 13073   Wahluke School District 530936001890 4222 Morris Schott Elementary   Regular School No Elementary KG 05 2017   grade_5 1 0 60   0 0     0   0   35 26 0   49   3   61       1.0 61 1 0 60   0 0     0   0   35 26 0   49 3 61     1 61
631863 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001605 2780 Pioneer Middle School   Regular School No Middle 06 08 2017   grade_5 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
631896 WA Yakima   school 5309480 39207   Wapato School District 530948002611 4518 Adams Elementary   Regular School No Elementary PK 05 2017   grade_5 1 0 43   11 0     0   1   33 23 0   18   4   52       2.0 56 1 0 43   11 0     0   1   33 23 0   18 4 52     2 56
632033 WA Douglas   school 5309600 9209   Waterville School District 530960001628 2162 Waterville High School   Regular School No Other 06 12 2017   grade_5 1 0 0   0 0     0   0   1 0 0   0   1   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 1 1     0 1
632530 WA Cowlitz   school 5310050 8404   Woodland School District 531005001684 3513 Yale Elementary   Regular School No Elementary KG 05 2017   grade_5 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
619441 WA Pierce   school 5301410 27400   Clover Park School District 530141002581 2189 Park Lodge Elementary School   Regular School No Elementary PK 05 2017   grade_5 10 12 34   2 3     3   12   39 37 0   13   6   74       0.0 76 10 12 34   2 3     3   12   39 37 0   13 6 74     0 76
620698 WA Lewis   school 5302640 21036   Evaline School District 530264000390 2355 Evaline Elementary School   Regular School No Elementary KG 06 2017   grade_5 10 0 1   0 0     0   0   4 7 0   0   0   7       0.0 11 10 0 1   0 0     0   0   4 7 0   0 0 7     0 11
621454 WA King   school 5302820 17210   Federal Way School District 530282000455 3583 Wildwood Elementary School   Regular School No Elementary PK 05 2017   grade_5 10 7 49   0 2     5   2   43 32 0   24   1   74       1.0 75 10 7 49   0 2     5   2   43 32 0   24 1 74     1 75
622058 WA King   school 5303540 17401   Highline School District 530354000533 3278 Madrona Elementary   Regular School No Elementary PK 06 2017   grade_5 10 21 54   0 9     10   4   62 46 0   48   7   103       2.0 108 10 21 54   0 9     10   4   62 46 0   48 7 103     2 108
622095 WA King   school 5303540 17401   Highline School District 530354000539 2144 Mount View Elementary   Regular School No Elementary PK 06 2017   grade_5 10 6 45   1 16     2   2   40 42 0   31   5   70       4.0 82 10 6 45   1 16     2   2   40 42 0   31 5 70     4 82
622788 WA King   school 5303960 17415   Kent School District 530396000614 2851 East Hill Elementary School   Regular School No Elementary PK 06 2017   grade_5 10 18 22   0 17     4   7   33 45 0   28   4   59       2.0 78 10 18 22   0 17     4   7   33 45 0   28 4 59     2 78
622931 WA King   school 5303960 17415   Kent School District 530396001603 4465 Meadow Ridge Elementary School   Regular School No Elementary PK 06 2017   grade_5 10 17 22   0 18     2   4   51 22 0   27   3   57       2.0 73 10 17 22   0 18     2   4   51 22 0   27 3 57     2 73
622997 WA King   school 5303960 17415   Kent School District 530396000630 3593 Pine Tree Elementary School   Regular School No Elementary PK 06 2017   grade_5 10 10 13   0 8     3   6   25 25 0   21   2   43       0.0 50 10 10 13   0 8     3   6   25 25 0   21 2 43     0 50
623048 WA King   school 5303960 17415   Kent School District 530396000635 3677 Springbrook Elementary School   Regular School No Elementary PK 06 2017   grade_5 10 10 28   0 16     2   6   33 39 0   27   2   59       3.0 72 10 10 28   0 16     2   6   33 39 0   27 2 59     3 72
626435 WA Spokane   school 5306330 32123   Orchard Prairie School District 530633000947 3723 Orchard Prairie Elementary   Regular School No Elementary KG 07 2017   grade_5 10 0 2   0 0     0   0   8 4 0   0   0   1       0.0 12 10 0 2   0 0     0   0   8 4 0   0 0 1     0 12
628207 WA King   school 5307710 17001   Seattle School District No. 1 530771001140 2070 Beacon Hill International School   Regular School No Elementary KG 05 2017   grade_5 10 4 26   0 22     1   5   33 35 0   24   3   44       1.0 68 10 4 26   0 22     1   5   33 35 0   24 3 44     1 68
628835 WA King   school 5307710 17001   Seattle School District No. 1 530771003356 2977 Viewlands Elementary School   Regular School No Elementary PK 05 2017   grade_5 10 7 10   0 5     0   4   12 24 0   6   3   24       0.0 36 10 7 10   0 5     0   4   12 24 0   6 3 24     0 36
630188 WA Whitman   school 5308310 38322   St. John School District 530831001420 3069 St John Elementary   Regular School No Elementary KG 05 2017   grade_5 10 0 0   0 0     0   1   4 7 0   0   0   4       0.0 11 10 0 0   0 0     0   1   4 7 0   0 0 4     0 11
630231 WA Snohomish   school 5308340 31401   Stanwood-Camano School District 530834003011 5004 Saratoga School   Alternative School No Other KG 12 2017   grade_5 10 1 1   0 0     0   2   7 7 0   0   0   3       0.0 14 10 1 1   0 0     0   2   7 7 0   0 0 3     0 14

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);