enrollments

Data source: Big Local News · About: Big Local

4,566 rows where grade = "grade_7" and state = "WA" sorted by total descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 4,566 ✖
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
632385 632385 WA Klickitat   school 5309810 20405   White Salmon Valley School District 530981001666 3394 Wayne M Henkle Middle School   Regular School No Middle 07 08 2017   grade_7 63 0 35   0 0     0   1   57 42 0   15   2   47       4.0 99 63 0 35   0 0     0   1   57 42 0   15 2 47     4 99
2466353 2466353 WA Okanogan   school 5306150 24105   Okanogan School District 530615003144 2245 Okanogan Middle School   Regular School No Middle 06 08 2018   grade_7 60 1 24   9 1     0   4   52 47 0   9   4   54       5.0 99 60 1 24   9 1     0   4   52 47 0   9 4 54     5 99
2471336 2471336 WA Okanogan   school 5308940 24404   Tonasket School District 530894001647 4196 Tonasket Middle School   Regular School No Middle 06 08 2018   grade_7 45 0 49   0 0     1   4   48 51 0   17   9   76       0.0 99 45 0 49   0 0     1   4   48 51 0   17 9 76     0 99
2578351 2578351 WA Pend Oreille   school 5305610 26056   Newport School District 530561001911 3968 Sadie Halstead Middle School   Regular School No Middle 05 08 2020   grade_7 80 0 11   2 0     0   6   60 39 0   0   8   71       9.0 99 80 0 11   2 0     0   6   60 39 0   0 8 71     9 99
2467248 2467248 WA Spokane   school 5300339 32907   PRIDE Prep Charter School District 530033903495 5339 PRIDE Prep School   Regular School Yes High 06 12 2018   grade_7 69 10 0   6 1     2   10   63 35 0   0   0   52       6.0 98 69 10 0   6 1     2   10   63 35 0   0 0 52     6 98
2470005 2470005 WA Spokane   school 5308250 32081   Spokane School District 530825002764 3008 Bryant Center   Alternative School No Other PK 12 2018   grade_7 74 2 14   0 2     0   6   55 43 0   0   0   26       9.0 98 74 2 14   0 2     0   6   55 43 0   0 0 26     9 98
464485 464485 WA Yakima   school 5303180 39204   Granger School District 530318000504 2531 Granger Middle School   Regular School No 2.0 05 08 2015   grade_7 3 0 88   5 0     0   1   55 42 0   32   3   87       1.0 97 3 0 88   5 0     0   1   55 42 0   32 3 87     1 97
621175 621175 WA King   school 5300332 17906   Excel Public Charter School 530033203536 5377 Excel Public Charter School (Closed after 2018-2019 school year)   Regular School Yes Middle 06 08 2017   grade_7 35 31 6   0 10     2   13   56 41 0   12   1   36       9.0 97 35 31 6   0 10     2   13   56 41 0   12 1 36     9 97
2428069 2428069 WA Klickitat   school 5309810 20405   White Salmon Valley School District 530981001666 3394 Wayne M Henkle Middle School   Regular School No Middle 07 08 2019   grade_7 55 0 38   2 0     1   1   56 41 0   18   5   48       7.0 97 55 0 38   2 0     1   1   56 41 0   18 5 48     7 97
2939167 2939167 WA Yakima   school 5305460 39003   Naches Valley School District 530546000824 2898 Naches Valley Middle School   Regular School No Middle 05 08 2021   grade_7 66 0 27   1 0     0   3   51 46 0   4   1   51       12.0 97 66 0 27   1 0     0   3   51 46 0   4 1 51     12 97
533573 533573 WA Pierce   school 5308700 27010   Tacoma School District 530870001504 2359 Stewart   Regular School No 2 06 08 2016   grade_7 40 19 18   3 13     1   2   53 43 0   4   7   56       3.0 96 40 19 18   3 13     1   2   53 43 0   4 7 56     3 96
2462272 2462272 WA Pierce   school 5300338 27904   Green Dot Destiny 530033803553 5378 Destiny Charter Middle School (Closed after 2018-2019 school year)   Regular School Yes Middle 06 08 2018   grade_7 26 26 21   1 1     5   16   55 41 0   7   1   74       2.0 96 26 26 21   1 1     5   16   55 41 0   7 1 74     2 96
2571886 2571886 WA Chelan   school 5300950 4228   Cascade School District 530095000553 4403 Icicle River Middle School   Regular School No Middle 06 08 2020   grade_7 57 2 31   0 0     0   6   56 40 0   7   6   45       4.0 96 57 2 31   0 0     0   6   56 40 0   7 6 45     4 96
2584799 2584799 WA Clark   school 5309270 6037   Vancouver School District 530927002508 1689 Vancouver School of Arts and Academics   Regular School No High 06 12 2020   grade_7 64 0 16   0 4     0   12   32 64 0   1   2   32       4.0 96 64 0 16   0 4     0   12   32 64 0   1 2 32     4 96
461296 461296 WA Cowlitz   school 5300990 8401   Castle Rock School District 530099000173 3969 Castle Rock Middle School   Regular School No 2.0 06 08 2015   grade_7 74 0 10   2 0     1   8   52 43 0   0   2   48       9.0 95 74 0 10   2 0     1   8   52 43 0   0 2 48     9 95
475504 475504 WA Yakima   school 5310170 39205   Zillah School District 531017002502 4481 Zillah Middle School   Regular School No 2.0 07 08 2015   grade_7 35 0 51   5 0     0   4   57 38 0   10   3   56       2.0 95 35 0 51   5 0     0   4   57 38 0   10 3 56     2 95
520206 520206 WA Clark   school 5300380 6119   Battle Ground School District 530038002857 1875 Homelink River   Alternative Education School No 4 KG 12 2016   grade_7 78 2 9   0 0     0   6   39 56 0   1   0   32       2.0 95 78 2 9   0 0     0   6   39 56 0   1 0 32     2 95
527779 527779 WA Pend Oreille   school 5305610 26056   Newport School District 530561001911 3968 Sadie Halstead Middle School   Regular School No 2 05 08 2016   grade_7 87 0 2   0 0     0   6   44 51 0   0   9   61       3.0 95 87 0 2   0 0     0   6   44 51 0   0 9 61     3 95
626293 626293 WA Thurston   school 5306180 34111   Olympia School District 530618001737 4473 Thurgood Marshall Middle School   Regular School No Middle 06 08 2017   grade_7 68 2 8   1 6     1   9   53 42 0   1   0   39       6.0 95 68 2 8   1 6     1   9   53 42 0   1 0 39     6 95
628001 628001 WA Spokane   school 5307440 32416   Riverside School District 530744001114 3466 Riverside Middle School   Regular School No Middle 06 08 2017   grade_7 86 1 3   4 0     1   0   49 46 0   0   2   54       2.0 95 86 1 3   4 0     1   0   49 46 0   0 2 54     2 95
2421008 2421008 WA Pend Oreille   school 5305610 26056   Newport School District 530561001911 3968 Sadie Halstead Middle School   Regular School No Middle 05 08 2019   grade_7 86 1 4   0 1     0   3   48 47 0   0   11   63       15.0 95 86 1 4   0 1     0   3   48 47 0   0 11 63     15 95
2422713 2422713 WA Jefferson   school 5306840 16050   Port Townsend School District 530684001305 4475 Blue Heron Middle School   Regular School No Middle 06 08 2019   grade_7 74 1 11   1 1     0   7   49 46 0   3   2   47       6.0 95 74 1 11   1 1     0   7   49 46 0   3 2 47     6 95
2472985 2472985 WA Yakima   school 5310170 39205   Zillah School District 531017002502 4481 Zillah Middle School   Regular School No Middle 07 08 2018   grade_7 37 0 53   3 0     0   2   54 41 0   12   2   58       1.0 95 37 0 53   3 0     0   2   54 41 0   12 2 58     1 95
468824 468824 WA Okanogan   school 5306150 24105   Okanogan School District 530615003144 2245 Okanogan Middle School   Regular School No 2.0 06 08 2015   grade_7 55 0 21   8 0     0   10   54 40 0   6   2   57       0.0 94 55 0 21   8 0     0   10   54 40 0   6 2 57     0 94
521246 521246 WA Chelan   school 5300950 4228   Cascade School District 530095000553 4403 Icicle River Middle School   Regular School No 2 06 08 2016   grade_7 69 0 23   2 0     0   0   54 40 0   12   1   50       4.0 94 69 0 23   2 0     0   0   54 40 0   12 1 50     4 94
2420472 2420472 WA Grays Harbor   school 5305160 14066   Montesano School District 530516000780 2180 Montesano Jr-Sr High   Regular School No High 07 12 2019   grade_7 73 0 13   1 1     0   6   49 45 0   2   1   34       4.0 94 73 0 13   1 1     0   6   49 45 0   2 1 34     4 94
2426829 2426829 WA Okanogan   school 5308940 24404   Tonasket School District 530894001647 4196 Tonasket Middle School   Regular School No Middle 06 08 2019   grade_7 49 0 35   2 0     0   5   47 47 0   12   7   69       3.0 94 49 0 35   2 0     0   5   47 47 0   12 7 69     3 94
2462317 2462317 WA Yakima   school 5303510 39203   Highland School District 530351003148 2718 Highland Junior High School   Regular School No Middle 07 08 2018   grade_7 20 1 73   0 0     0   0   44 50 0   32   6   84       0.0 94 20 1 73   0 0     0   0   44 50 0   32 6 84     0 94
2578289 2578289 WA Yakima   school 5305460 39003   Naches Valley School District 530546000824 2898 Naches Valley Middle School   Regular School No Middle 05 08 2020   grade_7 69 1 21   0 0     0   3   51 43 0   5   0   49       10.0 94 69 1 21   0 0     0   3   51 43 0   5 0 49     10 94
2943597 2943597 WA King   school 5308040 17410   Snoqualmie Valley School District 530804002158 1502 Two Rivers School   Regular School No High 06 12 2021   grade_7 66 0 8   0 8     0   12   45 49 0   2   0   8       7.0 94 66 0 8   0 8     0   12   45 49 0   2 0 8     7 94
463724 463724 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270002710 1801 iQ Academy Washington (Closed after 2016-2017 school year)   Alternative Education School No 3.0 07 12 2015   grade_7 64 16 10   0 0     0   3   51 42 0   5   0   30       0.0 93 64 16 10   0 0     0   3   51 42 0   5 0 30     0 93
624485 624485 WA Whatcom   school 5305010 37505   Meridian School District 530501000767 3930 Meridian Middle School   Regular School No Middle 06 08 2017   grade_7 56 1 28   0 4     0   4   57 36 0   13   2   56       6.0 93 56 1 28   0 4     0   4   57 36 0   13 2 56     6 93
629811 629811 WA Spokane   school 5308250 32081   Spokane School District 530825002764 3008 Bryant Center   Alternative School No Other PK 12 2017   grade_7 73 1 12   1 1     0   5   40 53 0   0   0   17       3.0 93 73 1 12   1 1     0   5   40 53 0   0 0 17     3 93
2421301 2421301 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585003280 5168 Aspire Middle School   Regular School No Middle 06 08 2019   grade_7 61 1 19   0 5     0   7   31 62 0   1   3   28       9.0 93 61 1 19   0 5     0   7   31 62 0   1 3 28     9 93
2463563 2463563 WA Chelan   school 5301200 4129   Lake Chelan School District 530120000218 2317 Chelan Middle School   Regular School No Middle 06 08 2018   grade_7 43 0 49   0 0     0   1   47 46 0   27   4   62       3.0 93 43 0 49   0 0     0   1   47 46 0   27 4 62     3 93
2945817 2945817 WA Clark   school 5309270 6037   Vancouver School District 530927002508 1689 Vancouver School of Arts and Academics   Regular School No High 06 12 2021   grade_7 59 1 14   0 5     0   14   26 67 0   1   0   23       5.0 93 59 1 14   0 5     0   14   26 67 0   1 0 23     5 93
2420512 2420512 WA Grant   school 5305220 13161   Moses Lake School District 530522003482 5354 Endeavor Middle School   Regular School No Middle 06 08 2019   grade_7 16 3 68   0 0     0   5   43 49 0   29   2   85       5.0 92 16 3 68   0 0     0   5   43 49 0   29 2 85     5 92
2426634 2426634 WA Pierce   school 5308700 27010   Tacoma School District 530870001508 3116 Wainwright   Regular School No Middle 04 08 2019   grade_7 45 16 16   1 4     1   9   45 47 0   1   2   39       5.0 92 45 16 16   1 4     1   9   45 47 0   1 2 39     5 92
2570993 2570993 WA King   school 5300390 17405   Bellevue School District 530039003149 3522 International School   Alternative School No High 06 12 2020   grade_7 36 1 7   0 39     0   9   47 45 0   3   0   11       8.0 92 36 1 7   0 39     0   9   47 45 0   3 0 11     8 92
2584241 2584241 WA Okanogan   school 5308940 24404   Tonasket School District 530894001647 4196 Tonasket Middle School   Regular School No Middle 06 08 2020   grade_7 50 0 39   0 0     0   3   44 48 0   4   0   77       2.0 92 50 0 39   0 0     0   3   44 48 0   4 0 77     2 92
2942507 2942507 WA King   school 5307710 17001   Seattle School District No. 1 530771003271 5175 Hazel Wolf K-8   Regular School No Elementary KG 08 2021   grade_7 53 12 8   0 7     1   11   40 51 1   2   0   21       6.0 92 53 12 8   0 7     1   11   40 51 1   2 0 21     6 92
464353 464353 WA Spokane   school 5302970 32358   Freeman School District 530297003013 4593 Freeman Middle School   Regular School No 2.0 06 08 2015   grade_7 82 1 6   1 1     0   0   50 41 0   0   1   21       4.0 91 82 1 6   1 1     0   0   50 41 0   0 1 21     4 91
474377 474377 WA Clark   school 5309270 6037   Vancouver School District 530927002508 1689 Vancouver School of Arts and Academics   Regular School No 4.0 06 12 2015   grade_7 67 2 11   0 4     1   6   20 71 0   0   0   30       6.0 91 67 2 11   0 4     1   6   20 71 0   0 0 30     6 91
535037 535037 WA Klickitat   school 5309810 20405   White Salmon Valley School District 530981001666 3394 Wayne M Henkle Middle School   Regular School No 2 07 08 2016   grade_7 56 0 32   0 1     0   2   46 45 0   12   1   54       0.0 91 56 0 32   0 1     0   2   46 45 0   12 1 54     0 91
631120 631120 WA Okanogan   school 5308940 24404   Tonasket School District 530894001647 4196 Tonasket Middle School   Regular School No Middle 06 08 2017   grade_7 54 0 32   0 0     0   5   45 46 0   11   6   57       0.0 91 54 0 32   0 0     0   5   45 46 0   11 6 57     0 91
2413674 2413674 WA King   school 5300390 17405   Bellevue School District 530039003149 3522 International School   Alternative School No High 06 12 2019   grade_7 32 1 5   0 43     0   10   45 46 0   2   0   7       8.0 91 32 1 5   0 43     0   10   45 46 0   2 0 7     8 91
2427369 2427369 WA Clark   school 5309270 6037   Vancouver School District 530927002508 1689 Vancouver School of Arts and Academics   Regular School No High 06 12 2019   grade_7 63 1 13   0 4     1   9   26 65 0   0   0   28       5.0 91 63 1 13   0 4     1   9   26 65 0   0 0 28     5 91
2471870 2471870 WA Clark   school 5309270 6037   Vancouver School District 530927002508 1689 Vancouver School of Arts and Academics   Regular School No High 06 12 2018   grade_7 70 2 10   1 4     1   3   30 61 0   0   0   15       2.0 91 70 2 10   1 4     1   3   30 61 0   0 0 15     2 91
2585059 2585059 WA Grant   school 5309510 13146   Warden School District 530951001620 3909 Warden Middle School   Regular School No Middle 06 08 2020   grade_7 19 0 72   0 0     0   0   50 41 0   11   3   88       2.0 91 19 0 72   0 0     0   0   50 41 0   11 3 88     2 91
2931887 2931887 WA King   school 5300390 17405   Bellevue School District 530039003149 3522 International School   Alternative School No High 06 12 2021   grade_7 27 3 4   0 50     0   7   44 47 0   6   0   4       7.0 91 27 3 4   0 50     0   7   44 47 0   6 0 4     7 91
2936036 2936036 WA Yakima   school 5303510 39203   Highland School District 530351003148 2718 Highland Junior High School   Regular School No Middle 07 08 2021   grade_7 22 0 68   0 1     0   0   47 44 0   13   1   75       6.0 91 22 0 68   0 1     0   0   47 44 0   13 1 75     6 91
2936319 2936319 WA Grays Harbor   school 5303660 14028   Hoquiam School District 530366000565 2391 Hoquiam Middle School   Regular School No Middle 06 08 2021   grade_7 50 1 23   7 0     0   10   44 47 0   5   2   73       2.0 91 50 1 23   7 0     0   10   44 47 0   5 2 73     2 91
2940190 2940190 WA Okanogan   school 5306150 24105   Okanogan School District 530615003144 2245 Okanogan Middle School   Regular School No Middle 06 08 2021   grade_7 51 0 27   8 0     0   5   47 44 0   8   1   53       4.0 91 51 0 27   8 0     0   5   47 44 0   8 1 53     4 91
2941046 2941046 WA Jefferson   school 5306840 16050   Port Townsend School District 530684001305 4475 Blue Heron Middle School   Regular School No Middle 06 08 2021   grade_7 68 0 11   0 3     0   9   47 44 0   3   1   50       3.0 91 68 0 11   0 3     0   9   47 44 0   3 1 50     3 91
2944501 2944501 WA King   school 5300343 17905   Summit Public School: Atlas 530034303611 5469 Summit Public School: Atlas   Regular School Yes High 06 12 2021   grade_7 34 24 17   1 2     0   11   47 43 1   0   0   41       3.0 91 34 24 17   1 2     0   11   47 43 1   0 0 41     3 91
631677 631677 WA Clark   school 5309270 6037   Vancouver School District 530927002508 1689 Vancouver School of Arts and Academics   Regular School No Other 06 12 2017   grade_7 64 1 13   0 3     2   7   32 58 0   0   1   22       3.0 90 64 1 13   0 3     2   7   32 58 0   0 1 22     3 90
2463447 2463447 WA Benton   school 5304020 3052   Kiona-Benton City School District 530402000640 3961 Kiona-Benton City Middle School   Regular School No Middle 06 08 2018   grade_7 47 0 39   0 0     0   4   55 35 0   13   0   67       3.0 90 47 0 39   0 0     0   4   55 35 0   13 0 67     3 90
2575158 2575158 WA Yakima   school 5303510 39203   Highland School District 530351003148 2718 Highland Junior High School   Regular School No Middle 07 08 2020   grade_7 21 0 68   0 0     0   1   54 36 0   23   0   75       1.0 90 21 0 68   0 0     0   1   54 36 0   23 0 75     1 90
2579150 2579150 WA Pacific   school 5306060 25101   Ocean Beach School District 530606000911 2517 Hilltop Elementary School   Regular School No Middle 06 08 2020   grade_7 69 0 16   0 1     0   4   49 41 0   8   15   57       7.0 90 69 0 16   0 1     0   4   49 41 0   8 15 57     7 90
2945809 2945809 WA Clark   school 5309270 6037   Vancouver School District 530927003415 5271 Vancouver iTech Preparatory   Regular School No High 06 12 2021   grade_7 53 2 18   0 7     1   9   62 28 0   4   0   29       11.0 90 53 2 18   0 7     1   9   62 28 0   4 0 29     11 90
462412 462412 WA Pend Oreille   school 5301920 26059   Cusick School District 530192000297 2423 Cusick Jr Sr High School   Regular School No 4.0 06 12 2015   grade_7 6 0 2   1 0     0   0   6 3 0   0   2   5       0.0 9 6 0 2   1 0     0   0   6 3 0   0 2 5     0 9
463505 463505 WA Snohomish   school 5302670 31002   Everett School District 530267002897 1907 Port Gardner   Alternative Education School No 4.0 KG 12 2015   grade_7 9 0 0   0 0     0   0   7 2 0   0   0   1       2.0 9 9 0 0   0 0     0   0   7 2 0   0 0 1     2 9
464370 464370 WA Whitman   school 5303000 38302   Garfield School District 530300000487 2896 Garfield Middle School   Regular School No 2.0 06 08 2015   grade_7 8 0 1   0 0     0   0   2 7 0   0   0   3       2.0 9 8 0 1   0 0     0   0   2 7 0   0 0 3     2 9
470040 470040 WA Jefferson   school 5306990 16048   Quilcene School District 530699003353 5236 Partnership for Excellence in Alternative Remote Learning   Alternative Education School No 4.0 KG 12 2015   grade_7 7 0 1   0 1     0   0   5 4 0   0   0   1       0.0 9 7 0 1   0 1     0   0   5 4 0   0 0 1     0 9
470251 470251 WA King   school 5307230 17403   Renton School District 530723002721 1784 H.O.M.E. Program   Alternative Education School No 4.0 KG 12 2015   grade_7 6 2 0   1 0     0   0   4 5 0   0   0   3       0.0 9 6 2 0   1 0     0   0   4 5 0   0 0 3     0 9
470603 470603 WA Spokane   school 5307440 32416   Riverside School District 530744002908 1919 Independent Scholar   Alternative Education School No 4.0 KG 12 2015   grade_7 8 0 1   0 0     0   0   6 3 0   0   0   5       0.0 9 8 0 1   0 0     0   0   6 3 0   0 0 5     0 9
470671 470671 WA King   school 5304560 17407   Riverview School District 530456002797 1854 PARADE   Alternative Education School No 4.0 PK 12 2015   grade_7 8 0 1   0 0     0   0   5 4 0   0   0   2       0.0 9 8 0 1   0 0     0   0   5 4 0   0 0 2     0 9
471151 471151 WA King   school 5307710 17001   Seattle School District No. 1 530771001132 3874 Licton Springs K-8   Alternative Education School No 1.0 PK 08 2015   grade_7 4 2 0   1 1     0   1   5 4 0   1   1   4       0.0 9 4 2 0   1 1     0   1   5 4 0   1 1 4     0 9
471847 471847 WA King   school 5307920 17412   Shoreline School District 530792002646 1771 Home Education Exchange   Alternative Education School No 4.0 KG 10 2015   grade_7 5 0 2   1 0     0   1   6 3 0   0   0   2       0.0 9 5 0 2   1 0     0   1   6 3 0   0 0 2     0 9
472007 472007 WA Snohomish   school 5308020 31201   Snohomish School District 530802002894 1904 Parent Partnership   Alternative Education School No 4.0 KG 12 2015   grade_7 9 0 0   0 0     0   0   4 5 0   0   0   3       0.0 9 9 0 0   0 0     0   0   4 5 0   0 0 3     0 9
472231 472231 WA Kitsap   school 5308160 18402   South Kitsap School District 530816002575 1718 Explorer Academy   Alternative Education School No 4.0 KG 12 2015   grade_7 8 0 1   0 0     0   0   7 2 0   0   0   3       0.0 9 8 0 1   0 0     0   0   7 2 0   0 0 3     0 9
473210 473210 WA Kitsap   school 5300328 18902   Suquamish Tribal Education Department 530032803493 5319 Chief Kitsap Academy   Regular School No 4.0 KG 12 2015   grade_7 0 1 3   2 0     0   3   2 7 0   0   1   7       1.0 9 0 1 3   2 0     0   3   2 7 0   0 1 7     1 9
524342 524342 WA Klickitat   school 5303030 20401   Glenwood School District 530303000489 3048 Glenwood Secondary   Regular School No 4 06 12 2016   grade_7 6 0 1   0 0     0   2   5 4 0   0   0   3       0.0 9 6 0 1   0 0     0   2   5 4 0   0 0 3     0 9
527955 527955 WA Kitsap   school 5305760 18400   North Kitsap School District 530576002654 3126 Middle School Options (Closed after 2019-2020 school year)   Regular School No 2 06 08 2016   grade_7 8 0 0   0 0     0   1   4 5 0   0   0   1       0.0 9 8 0 0   0 0     0   1   4 5 0   0 0 1     0 9
528253 528253 WA Stevens   school 5305880 33211   Northport School District 530588003370 5252 Northport Homelink Program   Alternative Education School No 4 KG 12 2016   grade_7 8 0 1   0 0     0   0   5 4 0   0   0   7       0.0 9 8 0 1   0 0     0   0   5 4 0   0 0 7     0 9
532236 532236 WA Kitsap   school 5308160 18402   South Kitsap School District 530816002575 1718 Explorer Academy   Alternative Education School No 4 KG 12 2016   grade_7 7 1 0   0 0     0   1   3 6 0   0   0   5       0.0 9 7 1 0   0 0     0   1   3 6 0   0 0 5     0 9
532351 532351 WA Island   school 5308190 15206   South Whidbey School District 530819002050 1682 South Whidbey Academy   Alternative Education School No 4 KG 12 2016   grade_7 8 0 1   0 0     0   0   4 5 0   0   0   3       0.0 9 8 0 1   0 0     0   0   4 5 0   0 0 3     0 9
532887 532887 WA Snohomish   school 5308340 31401   Stanwood-Camano School District 530834003011 5004 Saratoga School   Alternative Education School No 4 KG 12 2016   grade_7 9 0 0   0 0     0   0   5 4 0   0   0   1       0.0 9 9 0 0   0 0     0   0   5 4 0   0 0 1     0 9
618558 618558 WA Clallam   school 5300840 5401   Cape Flattery School District 530084000164 3422 Clallam Bay High & Elementary   Regular School No Other KG 12 2017   grade_7 5 0 3   0 0     0   1   4 5 0   0   0   7       2.0 9 5 0 3   0 0     0   1   4 5 0   0 0 7     2 9
619190 619190 WA Jefferson   school 5301290 16049   Chimacum School District 530129002630 1724 PI Program   Alternative School No Other KG 12 2017   grade_7 8 0 0   1 0     0   0   3 6 0   0   0   2       0.0 9 8 0 0   1 0     0   0   3 6 0   0 0 2     0 9
619718 619718 WA Clallam   school 5301830 5313   Crescent School District 530183002942 5030 Olympic Peninsula HomeConnection   Alternative School No Other KG 12 2017   grade_7 8 0 0   0 1     0   0   1 8 0   0   0   3       0.0 9 8 0 0   0 1     0   0   1 8 0   0 0 3     0 9
621705 621705 WA Whitman   school 5303000 38302   Garfield School District 530300000487 2896 Garfield Middle School   Regular School No Middle 06 08 2017   grade_7 7 0 1   0 0     0   1   3 6 0   0   0   6       0.0 9 7 0 1   0 0     0   1   3 6 0   0 0 6     0 9
623433 623433 WA King   school 5304230 17414   Lake Washington School District 530423002725 1688 Emerson K-12   Alternative School No Other KG 12 2017   grade_7 8 0 0   0 0     0   1   4 5 0   0   0   0       1.0 9 8 0 0   0 0     0   1   4 5 0   0 0 0     1 9
624037 624037 WA Mason   school 5304800 23311   Mary M Knight School District 530480003571 5444 Mary M. Knight School   Regular School No Other PK 12 2017   grade_7 8 1 0   0 0     0   0   4 5 0   0   0   6       0.0 9 8 1 0   0 0     0   0   4 5 0   0 0 6     0 9
626012 626012 WA Whitman   school 5305970 38324   Oakesdale School District 530597000907 3205 Oakesdale Elementary School   Regular School No Elementary KG 08 2017   grade_7 6 0 3   0 0     0   0   3 6 0   0   0   4       0.0 9 6 0 3   0 0     0   0   3 6 0   0 0 4     0 9
632016 632016 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other KG 12 2017   grade_7 8 0 1   0 0     0   0   7 2 0   0   1   6       0.0 9 8 0 1   0 0     0   0   7 2 0   0 1 6     0 9
632144 632144 WA Chelan   school 5309660 4246   Wenatchee School District 530966002550 1742 Valley Academy Of Learning (Closed after 2018-2019 school year)   Alternative School No Other KG 12 2017   grade_7 7 0 0   0 0     0   2   5 4 0   0   1   1       1.0 9 7 0 0   0 0     0   2   5 4 0   0 1 1     1 9
2414187 2414187 WA Whatcom   school 5300570 37503   Blaine School District 530057003020 5021 Blaine Home Connections   Alternative School No Other KG 11 2019   grade_7 8 0 0   0 0     0   1   6 3 0   0   0   2       0.0 9 8 0 0   0 0     0   1   6 3 0   0 0 2     0 9
2416018 2416018 WA Kittitas   school 5302340 19028   Easton School District 530234000324 3554 Easton School   Regular School No Other PK 12 2019   grade_7 6 0 2   0 0     0   1   2 7 0   0   2   7       0.0 9 6 0 2   0 0     0   1   2 7 0   0 2 7     0 9
2419323 2419323 WA King   school 5304230 17414   Lake Washington School District 530423002725 1688 Emerson K-12   Alternative School No Other KG 12 2019   grade_7 5 0 0   0 2     0   2   4 5 0   0   0   2       0.0 9 5 0 0   0 2     0   2   4 5 0   0 0 2     0 9
2419608 2419608 WA Whitman   school 5304290 38264   Lamont School District 530429000687 3137 Lamont Middle School   Regular School No Middle 05 08 2019   grade_7 8 0 0   0 0     0   1   3 6 0   0   1   7       0.0 9 8 0 0   0 0     0   1   3 6 0   0 1 7     0 9
2421613 2421613 WA King   school 5305910 17417   Northshore School District 530591002730 1814 Northshore Networks   Alternative School No Other KG 12 2019   grade_7 6 0 1   0 0     0   2   2 7 0   1   0   3       3.0 9 6 0 1   0 0     0   2   2 7 0   1 0 3     3 9
2421777 2421777 WA Whitman   school 5305970 38324   Oakesdale School District 530597000908 2432 Oakesdale High School   Regular School No High 06 12 2019   grade_7 9 0 0   0 0     0   0   4 5 0   0   0   5       0.0 9 9 0 0   0 0     0   0   4 5 0   0 0 5     0 9
2423129 2423129 WA Clallam   school   5903   Quileute Tribal School District   5430 Quileute Tribal School             2019   grade_7 0 0 3   6 0     0   0   3 6 0   0   0   7       0.0 9 0 0 3   6 0     0   0   3 6 0   0 0 7     0 9
2425711 2425711 WA Spokane   school 5308250 32081   Spokane School District 530825002364 1567 Pratt Academy   Alternative School No Other 03 12 2019   grade_7 7 0 2   0 0     0   0   9 0 0   0   0   9       5.0 9 7 0 2   0 0     0   0   9 0 0   0 0 9     5 9
2426095 2426095 WA Stevens   school 5308580 33202   Summit Valley School District 530858001203 4394 Summit Valley School   Regular School No Elementary PK 08 2019   grade_7 8 0 0   0 0     0   1   5 4 0   0   0   6       0.0 9 8 0 0   0 0     0   1   5 4 0   0 0 6     0 9
2428154 2428154 WA Grays Harbor   school 5309990 14117   Wishkah Valley School District 530999001679 3375 Wishkah Valley Elementary/High School   Regular School No Other KG 12 2019   grade_7 9 0 0   0 0     0   0   1 8 0   0   0   2       2.0 9 9 0 0   0 0     0   0   1 8 0   0 0 2     2 9
2458736 2458736 WA Whatcom   school 5300570 37503   Blaine School District 530057003020 5021 Blaine Home Connections   Alternative School No Other KG 11 2018   grade_7 9 0 0   0 0     0   0   3 6 0   0   0   1       0.0 9 9 0 0   0 0     0   0   3 6 0   0 0 1     0 9
2459036 2459036 WA Clallam   school 5300840 5401   Cape Flattery School District 530084000164 3422 Clallam Bay High & Elementary   Regular School No Other KG 12 2018   grade_7 4 0 0   2 1     0   2   7 2 0   0   0   7       0.0 9 4 0 0   2 1     0   2   7 2 0   0 0 7     0 9
2459138 2459138 WA Klickitat   school 5301050 20215   Centerville School District 530105000175 2251 Centerville Elementary   Regular School No Elementary KG 08 2018   grade_7 8 0 1   0 0     0   0   6 3 0   0   0   3       0.0 9 8 0 1   0 0     0   0   6 3 0   0 0 3     0 9

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]);