enrollments

Data source: Big Local News · About: Big Local

658 rows where grade = "grade_7", state = "WA" and year = 2017 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 658 ✖

grade ✖

  • grade_7 · 658 ✖
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
617047 617047 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2017   grade_7 0 0 1   0 0     0   0   0 1 0   1   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   1 0 1     0 1
617062 617062 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003002055 4267 Grays Harbor Juvenile Detention   Regular School No Other 06 12 2017   grade_7 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
617169 617169 WA Skagit   school 5300150 29103   Anacortes School District 530015000018 3252 Island View Elementary   Regular School No Elementary KG 06 2017   grade_7 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
618612 618612 WA Chelan   school 5300950 4228   Cascade School District 530095003528 5418 Cascade Home-Link   Regular School No Elementary KG 08 2017   grade_7 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
619033 619033 WA Lewis   school 5301170 21302   Chehalis School District 530117003486 5369 Lewis County Alternative School   Alternative School No Other 06 12 2017   grade_7 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
619482 619482 WA Pierce   school 5301410 27400   Clover Park School District 530141003396 5297 Transition Day Students   Regular School No Other 05 12 2017   grade_7 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
619609 619609 WA Stevens   school 5301630 33115   Colville School District 530163003305 1594 Panorama School   Alternative School No Other PK 12 2017   grade_7 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
620593 620593 WA Grant   school 5302610 13165   Ephrata School District 530261002934 4229 Beezley Springs Elementary   Special Education School No Elementary PK 01 2017   grade_7 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
620685 620685 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702927 3481 Kitsap Co Detention Ctr   Regular School No High 08 12 2017   grade_7 0 0 0   0 0     1   0   1 0 0   0   0   1       0.0 1 0 0 0   0 0     1   0   1 0 0   0 0 1     0 1
621539 621539 WA Pierce   school 5302880 27417   Fife School District 530288003161 4582 Columbia Junior High School   Regular School No Other 08 09 2017   grade_7 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
621554 621554 WA Pierce   school 5302880 27417   Fife School District 530288000466 2809 Endeavour Intermediate   Regular School No Elementary 02 05 2017   grade_7 0 1 0   0 0     0   0   1 0 0   0   1   1       0.0 1 0 1 0   0 0     0   0   1 0 0   0 1 1     0 1
621936 621936 WA Yakima   school 5303510 39203   Highland School District 530351000517 3073 Tieton Intermediate School   Regular School No Elementary 04 06 2017   grade_7 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
622256 622256 WA Snohomish   school 5303720 31063   Index Elementary School District 63 530372000569 2948 Index Elementary School District 63   Regular School No Elementary PK 08 2017   grade_7 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
622547 622547 WA Cowlitz   school 5300003 8458   Kelso School District 530000303076 5076 Special Education   Special Education School No Other PK 12 2017   grade_7 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
622893 622893 WA King   school 5303960 17415   Kent School District 530396002570 4492 Kentlake High School   Regular School No High 07 12 2017   grade_7 0 1 0   0 0     0   0   1 0 0   1   0   0       0.0 1 0 1 0   0 0     0   0   1 0 0   1 0 0     0 1
623197 623197 WA Whitman   school 5304150 38126   LaCrosse School District 530415000648 2088 Lacrosse High School   Regular School No Other 06 12 2017   grade_7 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
623409 623409 WA King   school 5304230 17414   Lake Washington School District 530423001141 4439 Eastlake High School   Regular School No High 09 12 2017   grade_7 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
624078 624078 WA Stevens   school 5304830 33207   Mary Walker School District 530483002843 1857 Springdale Academy (Closed after 2018-2019 school year)   Alternative School No Other KG 12 2017   grade_7 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
624442 624442 WA King   school 5304980 17400   Mercer Island School District 530498000759 2981 Lakeridge Elementary School   Regular School No Elementary KG 05 2017   grade_7 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
624506 624506 WA Okanogan   school 5305020 24350   Methow Valley School District 530502002807 1845 Alternative Educational Experience   Alternative School No Other KG 12 2017   grade_7 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
625401 625401 WA Kitsap   school 5305760 18400   North Kitsap School District 530576002653 1733 Parent Assisted Learning   Alternative School No Other KG 12 2017   grade_7 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
626125 626125 WA Okanogan   school 5306150 24105   Okanogan School District 530615002915 3193 Okanogan Co Juvenile Detention   Regular School No High 08 12 2017   grade_7 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
626427 626427 WA San Juan   school 5306300 28137   Orcas Island School District 530630000946 3808 Waldron Island School   Regular School No Elementary KG 08 2017   grade_7 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
626963 626963 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_7 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
627295 627295 WA Pierce   school 5306960 27003   Puyallup School District 530696003315 1640 Puyallup Online Academy/POA   Alternative School No Other KG 12 2017   grade_7 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
627386 627386 WA Jefferson   school 5301380 16020   Queets-Clearwater School District 530138000243 2491 Queets-Clearwater Elementary   Regular School No Elementary KG 08 2017   grade_7 0 0 0   1 0     0   0   0 1 0   0   0   1       0.0 1 0 0 0   1 0     0   0   0 1 0   0 0 1     0 1
627478 627478 WA Grant   school 5307080 13144   Quincy School District 530708002714 4536 Monument Elementary   Regular School No Elementary 04 06 2017   grade_7 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
628428 628428 WA King   school 5307710 17001   Seattle School District No. 1 530771002928 3496 Interagency Detention School   Regular School No Other 06 12 2017   grade_7 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
628439 628439 WA King   school 5307710 17001   Seattle School District No. 1 530771001365 1635 Interagency Programs   Alternative School No Other 06 12 2017   grade_7 0 0 1   0 0     0   0   0 1 0   0   1   1       0.0 1 0 0 1   0 0     0   0   0 1 0   0 1 1     0 1
628974 628974 WA Yakima   school 5307770 39119   Selah School District 530777002149 4272 Selah Academy Online   Alternative School No High 08 12 2017   grade_7 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
629061 629061 WA San Juan   school 5307860 28010   Shaw Island School District 530786001291 3725 Shaw Island Elementary School   Regular School No Elementary KG 08 2017   grade_7 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
629310 629310 WA Snohomish   school 5308020 31201   Snohomish School District 530802002029 4241 Dutch Hill Elementary   Regular School No Elementary KG 06 2017   grade_7 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
629322 629322 WA Snohomish   school 5308020 31201   Snohomish School District 530802003217 5128 Glacier Peak High School   Regular School No High 09 12 2017   grade_7 0 0 1   0 0     0   0   0 1 0   0   0   0       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 0     0 1
629384 629384 WA Snohomish   school 5308020 31201   Snohomish School District 530802002593 1730 Snohomish Center   Special Education School No Other PK 12 2017   grade_7 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
629753 629753 WA Spokane   school 5308250 32081   Spokane School District 530825000074 1604 Alternative Tamarack School   Regular School No High 07 12 2017   grade_7 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
630288 630288 WA Chelan   school 5308430 4069   Stehekin School District 530843001428 2265 Stehekin Elementary   Regular School No Elementary KG 08 2017   grade_7 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
630327 630327 WA Pierce   school 5308460 27001   Steilacoom Hist. School District 530846001807 4131 Steilacoom High   Regular School No High 09 12 2017   grade_7 0 0 0   0 0     1   0   1 0 0   0   0   1       0.0 1 0 0 0   0 0     1   0   1 0 0   0 0 1     0 1
631023 631023 WA King   school 5308760 17409   Tahoma School District 530876002874 4556 Tahoma Jr High (Closed after 2016-2017 school year)   Regular School No Other 08 09 2017   grade_7 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
631037 631037 WA Whitman   school 5308790 38265   Tekoa School District 530879001520 2052 Tekoa Elementary School   Regular School No Elementary PK 06 2017   grade_7 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
631375 631375 WA Pierce   school 5309180 27083   University Place School District 530918001549 3600 Curtis Senior High   Regular School No High 10 12 2017   grade_7 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
631859 631859 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001607 4071 Lincoln High School   Alternative School No High 09 12 2017   grade_7 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
632351 632351 WA Pierce   school 5309780 27416   White River School District 530978003544 5390 White River Homeschool   Regular School No Other KG 12 2017   grade_7 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
632603 632603 WA Yakima   school 5310110 39007   Yakima School District 531011002932 4092 Juvenile Detention Center   Regular School No Other 05 12 2017   grade_7 0 0 1   0 0     0   0   1 0 0   1   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   1 0 1     0 1
632752 632752 WA Thurston   school 5310140 34002   Yelm School District 531014001715 3848 Southworth Elementary   Regular School No Elementary KG 06 2017   grade_7 0 0 1   0 0     0   0   0 1 0   1   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   1 0 1     0 1
619541 619541 WA Whitman   school 5301500 38306   Colton School District 530150000277 2588 Colton School   Regular School No Other PK 12 2017   grade_7 10 0 0   0 0     0   0   4 6 0   0   0   3       0.0 10 10 0 0   0 0     0   0   4 6 0   0 0 3     0 10
623285 623285 WA Snohomish   school 5304200 31004   Lake Stevens School District 530420002670 1753 Homelink   Alternative School No Other KG 12 2017   grade_7 9 0 1   0 0     0   0   5 5 0   0   0   3       0.0 10 9 0 1   0 0     0   0   5 5 0   0 0 3     0 10
623720 623720 WA Whitman   school 5304290 38264   Lamont School District 530429000687 3137 Lamont Middle School   Regular School No Middle 05 08 2017   grade_7 9 0 1   0 0     0   0   4 6 0   0   0   5       1.0 10 9 0 1   0 0     0   0   4 6 0   0 0 5     1 10
625381 625381 WA Kitsap   school 5305760 18400   North Kitsap School District 530576002654 3126 Middle School Options (Closed after 2019-2020 school year)   Regular School No Middle 06 08 2017   grade_7 10 0 0   0 0     0   0   3 7 0   0   0   1       0.0 10 10 0 0   0 0     0   0   3 7 0   0 0 1     0 10
629472 629472 WA King   school 5308040 17410   Snoqualmie Valley School District 530804003394 5296 Snoqualmie Parent Partnership Program   Alternative School No Other KG 10 2017   grade_7 9 1 0   0 0     0   0   6 4 0   0   1   1       1.0 10 9 1 0   0 0     0   0   6 4 0   0 1 1     1 10
631685 631685 WA Clark   school 5309270 6037   Vancouver School District 530927003246 5149 Vancouver Virtual Learning Academy   Alternative School No Other 06 12 2017   grade_7 8 0 1   0 0     0   1   6 4 0   0   0   7       1.0 10 8 0 1   0 0     0   1   6 4 0   0 0 7     1 10
631063 631063 WA Thurston   school 5308820 34402   Tenino School District 530882001523 3795 Tenino Middle School   Regular School No Middle 06 08 2017   grade_7 87 0 7   2 0     0   4   55 45 0   1   9   57       1.0 100 87 0 7   2 0     0   4   55 45 0   1 9 57     1 100
618617 618617 WA Chelan   school 5300950 4228   Cascade School District 530095000553 4403 Icicle River Middle School   Regular School No Middle 06 08 2017   grade_7 64 0 33   1 0     0   3   48 54 0   13   7   60       3.0 102 64 0 33   1 0     0   3   48 54 0   13 7 60     3 102
621922 621922 WA Yakima   school 5303510 39203   Highland School District 530351003148 2718 Highland Junior High School   Regular School No Middle 07 08 2017   grade_7 18 0 84   0 0     0   0   44 58 0   29   4   89       1.0 102 18 0 84   0 0     0   0   44 58 0   29 4 89     1 102
625498 625498 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585003280 5168 Aspire Middle School   Regular School No Middle 06 08 2017   grade_7 60 2 10   0 9     0   23   46 58 0   0   2   27       5.0 104 60 2 10   0 9     0   23   46 58 0   0 2 27     5 104
625268 625268 WA Whatcom   school 5305670 37506   Nooksack Valley School District 530567000838 2687 Nooksack Valley Middle School   Regular School No Middle 06 08 2017   grade_7 59 0 39   4 0     0   3   45 60 0   18   4   68       7.0 105 59 0 39   4 0     0   3   45 60 0   18 4 68     7 105
627153 627153 WA Pierce   school 5306960 27003   Puyallup School District 530696001024 2575 Edgemont Jr High   Regular School No Other 07 09 2017   grade_7 66 4 13   3 10     1   8   53 52 0   4   0   40       6.0 105 66 4 13   3 10     1   8   53 52 0   4 0 40     6 105
626324 626324 WA Okanogan   school 5306220 24019   Omak School District 530622001912 4237 Omak Middle School   Regular School No Middle 06 08 2017   grade_7 43 0 28   25 1     0   9   55 51 0   6   1   58       3.0 106 43 0 28   25 1     0   9   55 51 0   6 1 58     3 106
630910 630910 WA Pierce   school 5308700 27010   Tacoma School District 530870001504 2359 Stewart   Regular School No Middle 06 08 2017   grade_7 29 21 28   2 19     2   5   59 47 0   14   7   89       3.0 106 29 21 28   2 19     2   5   59 47 0   14 7 89     3 106
629715 629715 WA Island   school 5308190 15206   South Whidbey School District 530819001358 2511 South Whidbey Middle   Regular School No Middle 06 08 2017   grade_7 89 0 8   0 6     1   3   53 54 0   0   3   37       6.0 107 89 0 8   0 6     1   3   53 54 0   0 3 37     6 107
623093 623093 WA Benton   school 5304020 3052   Kiona-Benton City School District 530402000640 3961 Kiona-Benton City Middle School   Regular School No Middle 06 08 2017   grade_7 57 0 48   1 0     0   2   57 51 0   18   1   80       1.0 108 57 0 48   1 0     0   2   57 51 0   18 1 80     1 108
624637 624637 WA Grays Harbor   school 5305160 14066   Montesano School District 530516000780 2180 Montesano Jr-Sr High   Regular School No High 07 12 2017   grade_7 81 0 17   3 1     0   6   44 64 0   2   2   51       9.0 108 81 0 17   3 1     0   6   44 64 0   2 2 51     9 108
625137 625137 WA Yakima   school 5305460 39003   Naches Valley School District 530546000824 2898 Naches Valley Middle School   Regular School No Middle 05 08 2017   grade_7 73 0 29   1 1     0   4   52 56 0   10   2   59       3.0 108 73 0 29   1 1     0   4   52 56 0   10 2 59     3 108
625231 625231 WA Spokane   school 5305640 32325   Nine Mile Falls School District 530564002680 4521 Lakeside Middle School   Regular School No Middle 06 08 2017   grade_7 92 2 5   3 1     1   5   56 53 0   1   1   45       2.0 109 92 2 5   3 1     1   5   56 53 0   1 1 45     2 109
618942 618942 WA Spokane   school 5301110 32356   Central Valley School District 530111003137 1964 Spokane Valley Learning Academy   Regular School No Other KG 12 2017   grade_7 11 0 0   0 0     0   0   4 7 0   0   0   4       0.0 11 11 0 0   0 0     0   0   4 7 0   0 0 4     0 11
628047 628047 WA King   school 5304560 17407   Riverview School District 530456002797 1854 PARADE   Alternative School No Other PK 12 2017   grade_7 11 0 0   0 0     0   0   4 7 0   0   0   0       0.0 11 11 0 0   0 0     0   0   4 7 0   0 0 0     0 11
629254 629254 WA Skamania   school 5307950 30002   Skamania School District 530795001319 3405 Skamania Elementary   Regular School No Elementary KG 08 2017   grade_7 9 0 2   0 0     0   0   3 8 0   0   0   8       1.0 11 9 0 2   0 0     0   0   3 8 0   0 0 8     1 11
631075 631075 WA Kittitas   school 5308850 19400   Thorp School District 530885001525 2514 Thorp Elem & Jr Sr High   Regular School No Other KG 12 2017   grade_7 10 0 0   0 0     0   1   4 7 0   0   1   5       0.0 11 10 0 0   0 0     0   1   4 7 0   0 1 5     0 11
618633 618633 WA Chelan   school 5300960 4222   CASHMERE SCHOOL DISTRICT 530096000169 2315 CASHMERE MIDDLE SCHOOL   Regular School No Middle 05 08 2017   grade_7 53 0 52   0 0     0   7   55 57 0   11   2   62       6.0 112 53 0 52   0 0     0   7   55 57 0   11 2 62     6 112
632796 632796 WA Yakima   school 5310170 39205   Zillah School District 531017002502 4481 Zillah Middle School   Regular School No Middle 07 08 2017   grade_7 45 0 56   7 0     0   5   69 44 0   14   2   71       2.0 113 45 0 56   7 0     0   5   69 44 0   14 2 71     2 113
623208 623208 WA Chelan   school 5301200 4129   Lake Chelan School District 530120000218 2317 Chelan Middle School   Regular School No Middle 06 08 2017   grade_7 54 2 54   0 0     0   4   56 58 0   17   4   74       4.0 114 54 2 54   0 0     0   4   56 58 0   17 4 74     4 114
622226 622226 WA Grays Harbor   school 5303660 14028   Hoquiam School District 530366000565 2391 Hoquiam Middle School   Regular School No Middle 06 08 2017   grade_7 77 1 15   13 0     0   10   58 58 0   3   2   84       0.0 116 77 1 15   13 0     0   10   58 58 0   3 2 84     0 116
619558 619558 WA Stevens   school 5301560 33206   Columbia (Stevens) School District 530156000278 3508 Columbia High And Elementary   Regular School No Other PK 12 2017   grade_7 7 0 3   1 0     0   1   9 3 0   0   1   11       2.0 12 7 0 3   1 0     0   1   9 3 0   0 1 11     2 12
619748 619748 WA Ferry   school 5301890 10050   Curlew School District 530189000295 2006 Curlew Elem & High School   Regular School No Other KG 12 2017   grade_7 10 0 1   0 0     0   1   4 8 0   0   0   11       1.0 12 10 0 1   0 0     0   1   4 8 0   0 0 11     1 12
626265 626265 WA Thurston   school 5306180 34111   Olympia School District 530618003377 5248 Olympia Regional Learning Academy B   Regular School No Elementary KG 08 2017   grade_7 9 0 1   0 0     0   2   3 9 0   0   0   4       2.0 12 9 0 1   0 0     0   2   3 9 0   0 0 4     2 12
629014 629014 WA Pend Oreille   school 5307800 26070   Selkirk School District 530780003341 5225 Selkirk Middle School   Regular School No Middle 06 08 2017   grade_7 10 0 1   1 0     0   0   9 3 0   0   1   6       0.0 12 10 0 1   1 0     0   0   9 3 0   0 1 6     0 12
630562 630562 WA Kitsap   school 5300328 18902   Suquamish Tribal Education Department 530032803493 5319 Chief Kitsap Academy   Regular School No Other KG 12 2017   grade_7 0 0 4   4 0     0   3   7 5 0   0   0   8       0.0 12 0 0 4   4 0     0   3   7 5 0   0 0 8     0 12
632435 632435 WA Grant   school 5309900 13167   Wilson Creek School District 530990001675 2473 Wilson Creek High   Regular School No High 07 12 2017   grade_7 10 0 2   0 0     0   0   7 5 0   0   0   7       0.0 12 10 0 2   0 0     0   0   7 5 0   0 0 7     0 12
619529 619529 WA Walla Walla   school 5301470 36250   College Place School District 530147000276 3541 John Sager Middle School   Regular School No Middle 06 08 2017   grade_7 61 2 47   0 3     1   4   61 59 0   21   3   76       5.0 120 61 2 47   0 3     1   4   61 59 0   21 3 76     5 120
620115 620115 WA Pierce   school 5302370 27404   Eatonville School District 530237001899 4230 Eatonville Middle School   Regular School No Middle 06 08 2017   grade_7 99 3 6   0 1     0   11   60 60 0   0   6   54       11.0 120 99 3 6   0 1     0   11   60 60 0   0 6 54     11 120
628748 628748 WA King   school 5307710 17001   Seattle School District No. 1 530771002716 1796 Salmon Bay K-8 School   Alternative School No Elementary KG 08 2017   grade_7 100 5 9   0 4     0   3   59 62 0   1   2   15       4.0 121 100 5 9   0 4     0   3   59 62 0   1 2 15     4 121
617615 617615 WA Clark   school 5300380 6119   Battle Ground School District 530038003214 5131 Tukes Valley Middle School   Regular School No Middle 05 08 2017   grade_7 106 0 10   0 1     0   5   63 59 0   4   1   51       3.0 122 106 0 10   0 1     0   5   63 59 0   4 1 51     3 122
624412 624412 WA Spokane   school 5304950 32326   Medical Lake School District 530495000756 3965 Medical Lake Middle School   Regular School No Middle 06 08 2017   grade_7 93 2 13   0 1     2   12   64 59 0   0   3   51       4.0 123 93 2 13   0 1     2   12   64 59 0   0 3 51     4 123
631729 631729 WA King   school 5309300 17402   Vashon Island School District 530930001589 3667 McMurray Middle School   Regular School No Middle 06 08 2017   grade_7 98 0 11   0 1     1   13   75 49 0   3   0   18       8.0 124 98 0 11   0 1     1   13   75 49 0   3 0 18     8 124
618468 618468 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000157 3251 Lucille Umbarger Elementary   Regular School No Elementary 01 08 2017   grade_7 39 0 79   2 2     0   4   59 67 0   30   3   91       2.0 126 39 0 79   2 2     0   4   59 67 0   30 3 91     2 126
621818 621818 WA Yakima   school 5303180 39204   Granger School District 530318000504 2531 Granger Middle School   Regular School No Middle 05 08 2017   grade_7 4 0 121   2 0     0   1   64 64 0   28   1   111       0.0 128 4 0 121   2 0     0   1   64 64 0   28 1 111     0 128
617535 617535 WA Clark   school 5300380 6119   Battle Ground School District 530038003176 5089 Daybreak Middle   Regular School No Middle 05 08 2017   grade_7 112 2 9   0 1     1   4   70 59 0   3   2   53       2.0 129 112 2 9   0 1     1   4   70 59 0   3 2 53     2 129
619584 619584 WA Stevens   school 5301630 33115   Colville School District 530163000283 3831 Colville Junior High School   Regular School No Middle 06 08 2017   grade_7 111 1 5   5 1     1   5   70 59 0   0   0   70       0.0 129 111 1 5   5 1     1   5   70 59 0   0 0 70     0 129
623236 623236 WA Grays Harbor   school 5307050 14097   Lake Quinault School District 530705001051 2973 Lake Quinault High School (Closed after 2017-2018 school year)   Regular School No Other 06 12 2017   grade_7 5 0 7   1 0     0   0   6 7 0   5   1   13       0.0 13 5 0 7   1 0     0   0   6 7 0   5 1 13     0 13
629042 629042 WA Clallam   school 5307830 5323   Sequim School District 530783002552 1708 Olympic Peninsula Academy   Alternative School No Other PK 12 2017   grade_7 11 0 2   0 0     0   0   4 9 0   0   0   6       0.0 13 11 0 2   0 0     0   0   4 9 0   0 0 6     0 13
629186 629186 WA King   school 5307920 17412   Shoreline School District 530792002646 1771 Home Education Exchange   Alternative School No Other KG 10 2017   grade_7 10 0 3   0 0     0   0   7 6 0   0   0   1       0.0 13 10 0 3   0 0     0   0   7 6 0   0 0 1     0 13
630233 630233 WA Snohomish   school 5308340 31401   Stanwood-Camano School District 530834003011 5004 Saratoga School   Alternative School No Other KG 12 2017   grade_7 9 0 2   0 0     0   2   5 8 0   0   0   2       1.0 13 9 0 2   0 0     0   2   5 8 0   0 0 2     1 13
631435 631435 WA Stevens   school 5309240 33070   Valley School District 530924001555 2405 Valley School   Regular School No Elementary KG 08 2017   grade_7 9 0 2   0 0     0   2   5 8 0   0   0   11       0.0 13 9 0 2   0 0     0   2   5 8 0   0 0 11     0 13
632035 632035 WA Douglas   school 5309600 9209   Waterville School District 530960001628 2162 Waterville High School   Regular School No Other 06 12 2017   grade_7 10 0 1   1 1     0   0   6 7 0   0   1   7       0.0 13 10 0 1   1 1     0   0   6 7 0   0 1 7     0 13
619410 619410 WA Pierce   school 5301410 27400   Clover Park School District 530141000264 3297 Mann Middle School (Closed after 2019-2020 school year)   Regular School No Middle 06 08 2017   grade_7 56 15 28   3 4     5   23   68 66 0   4   6   74       2.0 134 56 15 28   3 4     5   23   68 66 0   4 6 74     2 134
623811 623811 WA Cowlitz   school 5304470 8122   Longview School District 530447002947 4574 Mt. Solo Middle School   Regular School No Middle 06 08 2017   grade_7 101 0 20   1 2     0   11   66 69 0   7   7   70       8.0 135 101 0 20   1 2     0   11   66 69 0   7 7 70     8 135
626184 626184 WA Thurston   school 5306180 34111   Olympia School District 530618000925 3133 Jefferson Middle School   Regular School No Middle 05 08 2017   grade_7 82 4 20   1 14     1   15   74 63 0   4   5   57       5.0 137 82 4 20   1 14     1   15   74 63 0   4 5 57     5 137
617588 617588 WA Clark   school 5300380 6119   Battle Ground School District 530038000054 3997 Pleasant Valley Middle   Regular School No Middle 05 08 2017   grade_7 91 1 27   1 6     0   13   75 64 0   5   1   51       6.0 139 91 1 27   1 6     0   13   75 64 0   5 1 51     6 139
618770 618770 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108002574 1740 Off Campus (Closed after 2016-2017 school year)   Alternative School No Other KG 12 2017   grade_7 9 0 1   0 0     0   4   7 7 0   0   0   2       1.0 14 9 0 1   0 0     0   4   7 7 0   0 0 2     1 14
620081 620081 WA Kittitas   school 5302340 19028   Easton School District 530234000324 3554 Easton School   Regular School No Other KG 12 2017   grade_7 9 0 4   1 0     0   0   6 8 0   2   0   9       0.0 14 9 0 4   1 0     0   0   6 8 0   2 0 9     0 14
623745 623745 WA Adams   school 5304410 1158   Lind School District 530441003416 5293 Lind-Ritzville Middle School   Regular School No Middle 06 08 2017   grade_7 9 0 5   0 0     0   0   3 11 0   4   2   8       0.0 14 9 0 5   0 0     0   0   3 11 0   4 2 8     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]);