Data source: Big Local News · About: Big Local

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

View and edit SQL

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
473742 WA Thurston   school 5308820 34402   Tenino School District 530882001523 3795 Tenino Middle School   Regular School No 2.0 06 08 2015   grade_7 99 0 2   2 0     1   2   51 55 0   0   2   51       6.0 106 99 0 2   2 0     1   2   51 55 0   0 2 51     6 106
474426 WA King   school 5309300 17402   Vashon Island School District 530930001589 3667 McMurray Middle School   Regular School No 2.0 06 08 2015   grade_7 99 1 10   1 4     0   2   64 53 0   3   0   27       4.0 117 99 1 10   1 4     0   2   64 53 0   3 0 27     4 117
526435 WA Cowlitz   school 5304470 8122   Longview School District 530447000705 2831 Monticello Middle School   Regular School No 2 06 08 2016   grade_7 99 1 41   5 7     0   13   88 78 0   9   8   125       2.0 166 99 1 41   5 7     0   13   88 78 0   9 8 125     2 166
527238 WA Grays Harbor   school 5305160 14066   Montesano School District 530516000780 2180 Montesano Jr-Sr High   Regular School No 3 07 12 2016   grade_7 99 0 15   3 0     0   4   68 53 0   0   0   51       9.0 121 99 0 15   3 0     0   4   68 53 0   0 0 51     9 121
528560 WA Island   school 5305940 15201   Oak Harbor School District 530594000901 3939 North Whidbey Middle School   Regular School No 2 06 08 2016   grade_7 99 7 32   2 12     2   22   98 78 0   11   8   98       11.0 176 99 7 32   2 12     2   22   98 78 0   11 8 98     11 176
529620 WA Benton   school 5306900 3116   Prosser School District 530690001013 2906 Housel Middle School   Regular School No 2 06 08 2016   grade_7 99 3 105   0 2     1   0   105 105 0   50   6   136       3.0 210 99 3 105   0 2     1   0   105 105 0   50 6 136     3 210
530571 WA Spokane   school 5307440 32416   Riverside School District 530744001114 3466 Riverside Middle School   Regular School No 2 06 08 2016   grade_7 99 0 5   3 1     1   2   67 44 0   1   2   63       0.0 111 99 0 5   3 1     1   2   67 44 0   1 2 63     0 111
534396 WA King   school 5309300 17402   Vashon Island School District 530930001589 3667 McMurray Middle School   Regular School No 2 06 08 2016   grade_7 99 2 19   0 3     0   9   75 57 0   5   1   37       7.0 132 99 2 19   0 3     0   9   75 57 0   5 1 37     7 132
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
2571307 WA Pierce   school 5300480 27403   Bethel School District 530048000120 3250 Bethel Middle School   Regular School No Middle 06 08 2020   grade_7 99 14 64   3 6     15   40   128 113 0   13   9   150       5.0 241 99 14 64   3 6     15   40   128 113 0   13 9 150     5 241
2574777 WA Whatcom   school 5302850 37502   Ferndale School District 530285002832 4554 Horizon Middle School   Regular School No Middle 06 08 2020   grade_7 99 2 31   18 8     0   18   68 107 1   8   1   90       4.0 176 99 2 31   18 8     0   18   68 107 1   8 1 90     4 176
2578174 WA Snohomish   school 5305430 31006   Mukilteo School District 530543001910 4231 Explorer Middle School   Regular School No Middle 06 08 2020   grade_7 99 20 130   1 45     6   39   170 170 0   62   4   229       21.0 340 99 20 130   1 45     6   39   170 170 0   62 4 229     21 340
2933659 WA Pierce   school 5301410 27400   Clover Park School District 530141000272 3500 Thomas Middle School   Regular School No Middle 06 08 2021   grade_7 99 31 93   4 5     19   44   155 139 1   19   5   178       14.0 295 99 31 93   4 5     19   44   155 139 1   19 5 178     14 295
2937095 WA King   school 5303960 17415   Kent School District 530396002521 4485 Northwood Middle School   Regular School No Middle 07 08 2021   grade_7 99 14 41   0 86     8   41   146 143 0   16   3   99       24.0 289 99 14 41   0 86     8   41   146 143 0   16 3 99     24 289
464893 WA Grays Harbor   school 5303660 14028   Hoquiam School District 530366000565 2391 Hoquiam Middle School   Regular School No 2.0 06 08 2015   grade_7 98 2 19   4 1     1   6   71 60 0   2   3   95       3.0 131 98 2 19   4 1     1   6   71 60 0   2 3 95     3 131
522597 WA Yakima   school 5305370 39090   East Valley School District (Yakima) 530537000806 4055 East Valley Central Middle School   Regular School No 4 06 12 2016   grade_7 98 4 100   2 2     0   3   110 99 0   15   6   143       8.0 209 98 4 100   2 2     0   3   110 99 0   15 6 143     8 209
623807 WA Cowlitz   school 5304470 8122   Longview School District 530447000705 2831 Monticello Middle School   Regular School No Middle 06 08 2017   grade_7 98 1 47   4 3     3   10   89 77 0   16   15   126       2.0 166 98 1 47   4 3     3   10   89 77 0   16 15 126     2 166
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
632121 WA Chelan   school 5309660 4246   Wenatchee School District 530966001635 3210 Pioneer Middle School   Regular School No Middle 06 08 2017   grade_7 98 0 103   1 1     0   4   107 100 0   46   9   126       12.0 207 98 0 103   1 1     0   4   107 100 0   46 9 126     12 207
2423705 WA Spokane   school 5307440 32416   Riverside School District 530744001114 3466 Riverside Middle School   Regular School No Middle 06 08 2019   grade_7 98 0 5   1 2     0   6   61 51 0   0   2   51       2.0 112 98 0 5   1 2     0   6   61 51 0   0 2 51     2 112
2464151 WA Cowlitz   school 5304470 8122   Longview School District 530447002947 4574 Mt. Solo Middle School   Regular School No Middle 06 08 2018   grade_7 98 0 21   1 1     0   10   60 71 0   6   3   62       13.0 131 98 0 21   1 1     0   10   60 71 0   6 3 62     13 131
2464869 WA Snohomish   school 5305130 31103   Monroe School District 530513002761 4544 Hidden River Middle School   Regular School No Middle 06 08 2018   grade_7 98 0 36   1 6     0   10   78 73 0   13   0   43       9.0 151 98 0 36   1 6     0   10   78 73 0   13 0 43     9 151
2472284 WA Chelan   school 5309660 4246   Wenatchee School District 530966001006 4432 Foothills Middle School   Regular School No Middle 06 08 2018   grade_7 98 0 85   0 9     0   5   88 109 0   24   3   111       9.0 197 98 0 85   0 9     0   5   88 109 0   24 3 111     9 197
2573298 WA Douglas   school 5302310 9206   Eastmont School District 530231002948 4590 Clovis Point Intermediate School   Regular School No Middle 05 07 2020   grade_7 98 0 110   3 0     0   2   108 105 0   32   2   133       9.0 213 98 0 110   3 0     0   2   108 105 0   32 2 133     9 213
2574907 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294000479 3300 Morris Ford Middle School   Regular School No Middle 06 08 2020   grade_7 98 22 136   4 30     15   54   198 161 0   38   21   285       13.0 359 98 22 136   4 30     15   54   198 161 0   38 21 285     13 359
2580845 WA King   school 5307230 17403   Renton School District 530723003603 5484 Vera Risdon Middle School   Regular School No Middle 06 08 2020   grade_7 98 19 78   0 85     1   30   160 151 0   31   9   115       18.0 311 98 19 78   0 85     1   30   160 151 0   31 9 115     18 311
2942155 WA Thurston   school 5307470 34401   Rochester School District 530747001118 3067 Rochester Middle School   Regular School No Middle 06 08 2021   grade_7 98 1 38   9 3     1   14   90 74 0   7   1   88       8.0 164 98 1 38   9 3     1   14   90 74 0   7 1 88     8 164
460620 WA Whatcom   school 5300420 37501   Bellingham School District 530042000114 3201 Shuksan Middle School   Regular School No 2.0 06 08 2015   grade_7 97 4 59   4 17     1   18   106 94 0   14   7   126       12.0 200 97 4 59   4 17     1   18   106 94 0   14 7 126     12 200
462011 WA Pierce   school 5301410 27400   Clover Park School District 530141000257 3248 Hudtloff Middle School   Regular School No 2.0 06 08 2015   grade_7 97 32 76   0 17     6   34   135 127 0   25   3   172       4.0 262 97 32 76   0 17     6   34   135 127 0   25 3 172     4 262
527510 WA Skagit   school 5305400 29320   Mount Vernon School District 530540002585 4511 Mount Baker Middle School   Regular School No 2 06 08 2016   grade_7 97 7 129   1 3     4   7   121 127 0   35   1   166       11.0 248 97 7 129   1 3     4   7   121 127 0   35 1 166     11 248
622626 WA Benton   school 5303930 3017   Kennewick School District 530393000603 3267 Highlands Middle School   Regular School No Middle 06 08 2017   grade_7 97 7 126   1 4     2   7   125 119 0   47   5   206       12.0 244 97 7 126   1 4     2   7   125 119 0   47 5 206     12 244
2414588 WA Cowlitz   school 5300990 8401   Castle Rock School District 530099000173 3969 Castle Rock Middle School   Regular School No Middle 06 08 2019   grade_7 97 0 11   1 1     1   2   49 64 0   3   0   65       6.0 113 97 0 11   1 1     1   2   49 64 0   3 0 65     6 113
2426066 WA Snohomish   school 5308550 31311   Sultan School District 530855001439 2105 Sultan Middle School   Regular School No Middle 06 08 2019   grade_7 97 3 32   0 2     0   6   78 62 0   10   0   78       8.0 140 97 3 32   0 2     0   6   78 62 0   10 0 78     8 140
2458031 WA Clark   school 5300380 6119   Battle Ground School District 530038003262 5133 Chief Umtuch Middle   Regular School No Middle 05 08 2018   grade_7 97 0 20   0 0     0   6   61 62 0   6   1   53       5.0 123 97 0 20   0 0     0   6   61 62 0   6 1 53     5 123
2460644 WA Snohomish   school 5302400 31015   Edmonds School District 530240000337 3754 College Place Middle School   Regular School No Middle 07 08 2018   grade_7 97 14 56   4 16     0   18   111 94 0   32   6   100       13.0 205 97 14 56   4 16     0   18   111 94 0   32 6 100     13 205
2464567 WA Snohomish   school 5304860 31025   Marysville School District 530486000735 2813 Totem Middle School   Regular School No Middle 06 08 2018   grade_7 97 1 39   32 16     2   16   99 104 0   53   6   120       3.0 203 97 1 39   32 16     2   16   99 104 0   53 6 120     3 203
2571243 WA Whatcom   school 5300420 37501   Bellingham School District 530042000114 3201 Shuksan Middle School   Regular School No Middle 06 08 2020   grade_7 97 6 81   3 19     3   20   119 109 1   35   10   144       16.0 229 97 6 81   3 19     3   20   119 109 1   35 10 144     16 229
2576773 WA King   school 5304230 17414   Lake Washington School District 530423000671 3922 Kamiakin Middle School   Regular School No Middle 06 08 2020   grade_7 97 8 39   1 44     1   25   112 103 0   28   0   61       15.0 215 97 8 39   1 44     1   25   112 103 0   28 0 61     15 215
2584967 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001601 3510 Garrison Middle School   Regular School No Middle 06 08 2020   grade_7 97 0 81   1 1     0   4   85 99 0   15   5   106       7.0 184 97 0 81   1 1     0   4   85 99 0   15 5 106     7 184
2931982 WA King   school 5300390 17405   Bellevue School District 530039000093 3435 Tillicum Middle School   Regular School No Middle 06 08 2021   grade_7 97 6 35   0 76     0   40   143 110 1   14   3   35       23.0 254 97 6 35   0 76     0   40   143 110 1   14 3 35     23 254
617306 WA King   school 5300300 17408   Auburn School District 530030000033 2394 Cascade Middle School   Regular School No Middle 06 08 2017   grade_7 96 26 63   1 24     12   21   111 132 0   33   6   161       6.0 243 96 26 63   1 24     12   21   111 132 0   33 6 161     6 243
2427765 WA Chelan   school 5309660 4246   Wenatchee School District 530966001006 4432 Foothills Middle School   Regular School No Middle 06 08 2019   grade_7 96 0 94   1 2     0   7   96 104 0   32   10   106       9.0 200 96 0 94   1 2     0   7   96 104 0   32 10 106     9 200
2578376 WA Spokane   school 5305640 32325   Nine Mile Falls School District 530564002680 4521 Lakeside Middle School   Regular School No Middle 06 08 2020   grade_7 96 1 7   3 0     0   7   55 59 0   0   1   39       1.0 114 96 1 7   3 0     0   7   55 59 0   0 1 39     1 114
2935655 WA Whatcom   school 5302850 37502   Ferndale School District 530285000463 3762 Vista Middle School   Regular School No Middle 06 08 2021   grade_7 96 1 37   12 11     0   20   95 82 0   8   1   79       14.0 177 96 1 37   12 11     0   20   95 82 0   8 1 79     14 177
467899 WA Spokane   school 5305640 32325   Nine Mile Falls School District 530564002680 4521 Lakeside Middle School   Regular School No 2.0 06 08 2015   grade_7 95 2 1   0 1     1   7   49 58 0   0   0   25       0.0 107 95 2 1   0 1     1   7   49 58 0   0 0 25     0 107
520605 WA Whatcom   school 5300420 37501   Bellingham School District 530042000114 3201 Shuksan Middle School   Regular School No 2 06 08 2016   grade_7 95 3 57   7 36     2   18   103 115 0   20   10   147       7.0 218 95 3 57   7 36     2   18   103 115 0   20 10 147     7 218
528869 WA Thurston   school 5306180 34111   Olympia School District 530618001737 4473 Thurgood Marshall Middle School   Regular School No 2 06 08 2016   grade_7 95 9 17   2 15     0   6   80 64 0   5   3   63       4.0 144 95 9 17   2 15     0   6   80 64 0   5 3 63     4 144
623534 WA King   school 5304230 17414   Lake Washington School District 530423000671 3922 Kamiakin Middle School   Regular School No Middle 06 08 2017   grade_7 95 4 43   0 31     0   22   102 93 0   25   1   63       12.0 195 95 4 43   0 31     0   22   102 93 0   25 1 63     12 195
2421032 WA Spokane   school 5305640 32325   Nine Mile Falls School District 530564002680 4521 Lakeside Middle School   Regular School No Middle 06 08 2019   grade_7 95 2 6   2 0     0   3   54 54 0   0   2   27       3.0 108 95 2 6   2 0     0   3   54 54 0   0 2 27     3 108
2426772 WA Thurston   school 5308820 34402   Tenino School District 530882001523 3795 Tenino Middle School   Regular School No Middle 06 08 2019   grade_7 95 1 4   0 1     0   2   59 44 0   0   3   57       2.0 103 95 1 4   0 1     0   2   59 44 0   0 3 57     2 103
2427556 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001605 2780 Pioneer Middle School   Regular School No Middle 06 08 2019   grade_7 95 0 80   0 2     0   7   102 82 0   13   5   111       10.0 184 95 0 80   0 2     0   7   102 82 0   13 5 111     10 184
2462236 WA Snohomish   school 5303210 31332   Granite Falls School District 530321001770 4113 Granite Falls Middle School   Regular School No Middle 06 08 2018   grade_7 95 2 17   5 1     1   4   69 56 0   7   13   66       1.0 125 95 2 17   5 1     1   4   69 56 0   7 13 66     1 125
2462603 WA Grays Harbor   school 5303660 14028   Hoquiam School District 530366000565 2391 Hoquiam Middle School   Regular School No Middle 06 08 2018   grade_7 95 2 15   8 2     0   8   70 60 0   3   4   88       2.0 130 95 2 15   8 2     0   8   70 60 0   3 4 88     2 130
2945042 WA Pierce   school 5308700 27010   Tacoma School District 530870001507 3448 Truman   Regular School No Middle 06 08 2021   grade_7 95 25 41   1 13     4   40   115 103 1   13   5   121       20.0 219 95 25 41   1 13     4   40   115 103 1   13 5 121     20 219
460253 WA Clark   school 5300380 6119   Battle Ground School District 530038000054 3997 Pleasant Valley Middle   Regular School No 2.0 05 08 2015   grade_7 94 0 20   1 1     1   9   64 62 0   6   2   56       4.0 126 94 0 20   1 1     1   9   64 62 0   6 2 56     4 126
462659 WA Douglas   school 5302310 9206   Eastmont School District 530231002948 4590 Clovis Point Intermediate School   Regular School No 2.0 05 07 2015   grade_7 94 1 102   0 0     0   5   101 101 0   44   4   138       5.0 202 94 1 102   0 0     0   5   101 101 0   44 4 138     5 202
466940 WA Snohomish   school 5304860 31025   Marysville School District 530486000735 2813 Totem Middle School   Regular School No 2.0 06 09 2015   grade_7 94 2 24   32 8     2   24   86 100 0   6   1   87       5.0 186 94 2 24   32 8     2   24   86 100 0   6 1 87     5 186
469785 WA Pierce   school 5306960 27003   Puyallup School District 530696001024 2575 Edgemont Jr High   Regular School No 2.0 07 09 2015   grade_7 94 4 14   1 10     4   10   68 69 0   5   5   61       6.0 137 94 4 14   1 10     4   10   68 69 0   5 5 61     6 137
520842 WA Pierce   school 5300480 27403   Bethel School District 530048000128 3751 Spanaway Middle School   Regular School No 2 06 09 2016   grade_7 94 31 48   9 14     13   29   121 117 0   17   8   156       7.0 238 94 31 48   9 14     13   29   121 117 0   17 8 156     7 238
534131 WA Clark   school 5309270 6037   Vancouver School District 530927002018 4503 Discovery Middle School   Regular School No 2 06 08 2016   grade_7 94 14 79   1 2     5   13   103 105 0   28   12   164       6.0 208 94 14 79   1 2     5   13   103 105 0   28 12 164     6 208
534512 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001601 3510 Garrison Middle School   Regular School No 2 06 09 2016   grade_7 94 1 81   1 1     0   8   88 98 0   15   2   118       5.0 186 94 1 81   1 1     0   8   88 98 0   15 2 118     5 186
2417433 WA Whatcom   school 5302850 37502   Ferndale School District 530285002832 4554 Horizon Middle School   Regular School No Middle 06 08 2019   grade_7 94 0 34   17 4     0   11   81 79 0   9   3   91       9.0 160 94 0 34   17 4     0   11   81 79 0   9 3 91     9 160
2463326 WA King   school 5303960 17415   Kent School District 530396002521 4485 Northwood Middle School   Regular School No Middle 07 08 2018   grade_7 94 23 41   2 67     4   30   137 124 0   16   1   77       30.0 261 94 23 41   2 67     4   30   137 124 0   16 1 77     30 261
2463875 WA King   school 5304230 17414   Lake Washington School District 530423000671 3922 Kamiakin Middle School   Regular School No Middle 06 08 2018   grade_7 94 5 34   0 42     0   18   104 89 0   21   1   82       6.0 193 94 5 34   0 42     0   18   104 89 0   21 1 82     6 193
2468975 WA King   school 5307710 17001   Seattle School District No. 1 530771002716 1796 Salmon Bay K-8 School   Alternative School No Elementary KG 08 2018   grade_7 94 1 4   1 11     0   6   70 47 0   1   2   6       12.0 117 94 1 4   1 11     0   6   70 47 0   1 2 6     12 117
2575372 WA King   school 5303540 17401   Highline School District 530354000554 2927 Sylvester Middle School   Regular School No Middle 06 08 2020   grade_7 94 22 51   1 24     7   16   112 102 1   21   11   109       0.0 215 94 22 51   1 24     7   16   112 102 1   21 11 109     0 215
2584591 WA Clark   school 5309270 6037   Vancouver School District 530927002018 4503 Discovery Middle School   Regular School No Middle 06 08 2020   grade_7 94 8 96   1 7     5   22   121 112 0   28   16   177       8.0 233 94 8 96   1 7     5   22   121 112 0   28 16 177     8 233
2931466 WA King   school 5300300 17408   Auburn School District 530030000033 2394 Cascade Middle School   Regular School No Middle 06 08 2021   grade_7 94 23 80   1 37     29   39   152 151 0   44   1   184       3.0 303 94 23 80   1 37     29   39   152 151 0   44 1 184     3 303
2935773 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294000479 3300 Morris Ford Middle School   Regular School No Middle 06 08 2021   grade_7 94 34 113   2 22     11   51   168 159 0   30   3   225       8.0 327 94 34 113   2 22     11   51   168 159 0   30 3 225     8 327
2936252 WA King   school 5303540 17401   Highline School District 530354000554 2927 Sylvester Middle School   Regular School No Middle 06 08 2021   grade_7 94 16 65   1 26     7   27   110 125 1   23   9   110       0.0 236 94 16 65   1 26     7   27   110 125 1   23 9 110     0 236
2945983 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001601 3510 Garrison Middle School   Regular School No Middle 06 08 2021   grade_7 94 0 96   0 2     0   9   99 102 0   19   4   106       11.0 201 94 0 96   0 2     0   9   99 102 0   19 4 106     11 201
465592 WA King   school 5303960 17415   Kent School District 530396000624 3764 Meeker Middle School   Regular School No 2.0 07 08 2015   grade_7 93 70 56   0 78     5   23   180 145 0   50   7   216       16.0 325 93 70 56   0 78     5   23   180 145 0   50 7 216     16 325
471384 WA King   school 5307710 17001   Seattle School District No. 1 530771002716 1796 Salmon Bay K-8 School   Alternative Education School No 1.0 KG 08 2015   grade_7 93 3 9   1 4     0   8   58 60 0   0   1   14       7.0 118 93 3 9   1 4     0   8   58 60 0   0 1 14     7 118
529412 WA Pierce   school 5306690 27401   Peninsula School District 530669001863 4156 Key Peninsula Middle School   Regular School No 2 06 08 2016   grade_7 93 1 3   1 0     0   14   53 59 0   0   2   68       4.0 112 93 1 3   1 0     0   14   53 59 0   0 2 68     4 112
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
624917 WA Skagit   school 5305400 29320   Mount Vernon School District 530540002585 4511 Mount Baker Middle School   Regular School No Middle 06 08 2017   grade_7 93 2 109   0 7     2   4   102 115 0   47   7   143       12.0 217 93 2 109   0 7     2   4   102 115 0   47 7 143     12 217
2427084 WA Pierce   school 5309180 27083   University Place School District 530918002383 4325 Drum Intermediate   Regular School No Middle 05 07 2019   grade_7 93 17 29   0 12     0   37   96 92 0   7   3   70       9.0 188 93 17 29   0 12     0   37   96 92 0   7 3 70     9 188
2464098 WA Cowlitz   school 5304470 8122   Longview School District 530447000699 3475 Cascade Middle School   Regular School No Middle 06 08 2018   grade_7 93 2 48   3 3     0   18   86 81 0   12   8   102       6.0 167 93 2 48   3 3     0   18   86 81 0   12 8 102     6 167
2577734 WA Snohomish   school 5305130 31103   Monroe School District 530513002761 4544 Hidden River Middle School   Regular School No Middle 06 08 2020   grade_7 93 1 35   1 8     0   10   60 88 0   6   0   55       11.0 148 93 1 35   1 8     0   10   60 88 0   6 0 55     11 148
2932938 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108002524 4509 Klahowya Secondary   Regular School No High 06 12 2021   grade_7 93 1 13   1 0     0   19   62 65 0   1   1   39       8.0 127 93 1 13   1 0     0   19   62 65 0   1 1 39     8 127
2940320 WA Thurston   school 5306180 34111   Olympia School District 530618000936 3696 Reeves Middle School   Regular School No Middle 06 08 2021   grade_7 93 5 21   2 2     0   18   81 59 1   0   2   52       6.0 141 93 5 21   2 2     0   18   81 59 1   0 2 52     6 141
2945531 WA Pierce   school 5309180 27083   University Place School District 530918002383 4325 Drum Intermediate   Regular School No Middle 05 07 2021   grade_7 93 24 34   2 16     3   40   109 103 0   4   3   89       7.0 212 93 24 34   2 16     3   40   109 103 0   4 3 89     7 212
464172 WA Whatcom   school 5302850 37502   Ferndale School District 530285002832 4554 Horizon Middle School   Regular School No 2.0 06 08 2015   grade_7 92 2 31   22 7     0   9   79 84 0   8   3   89       8.0 163 92 2 31   22 7     0   9   79 84 0   8 3 89     8 163
524128 WA Whatcom   school 5302850 37502   Ferndale School District 530285002832 4554 Horizon Middle School   Regular School No 2 06 08 2016   grade_7 92 0 29   17 4     0   12   79 75 0   0   5   69       11.0 154 92 0 29   17 4     0   12   79 75 0   0 5 69     11 154
621519 WA Whatcom   school 5302850 37502   Ferndale School District 530285002832 4554 Horizon Middle School   Regular School No Middle 06 08 2017   grade_7 92 4 27   20 6     0   10   100 59 0   5   3   85       14.0 159 92 4 27   20 6     0   10   100 59 0   5 3 85     14 159
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
2413563 WA Clark   school 5300380 6119   Battle Ground School District 530038003214 5131 Tukes Valley Middle School   Regular School No Middle 05 08 2019   grade_7 92 0 15   0 0     0   8   61 54 0   2   0   31       4.0 115 92 0 15   0 0     0   8   61 54 0   2 0 31     4 115
2416146 WA Snohomish   school 5302400 31015   Edmonds School District 530240000337 3754 College Place Middle School   Regular School No Middle 07 08 2019   grade_7 92 13 74   3 13     4   21   118 102 0   32   10   114       12.0 220 92 13 74   3 13     4   21   118 102 0   32 10 114     12 220
2425392 WA Island   school 5308190 15206   South Whidbey School District 530819001358 2511 South Whidbey Middle   Regular School No Middle 07 08 2019   grade_7 92 0 8   0 1     1   8   60 50 0   0   8   41       6.0 110 92 0 8   0 1     1   8   60 50 0   0 8 41     6 110
2458036 WA Clark   school 5300380 6119   Battle Ground School District 530038003176 5089 Daybreak Middle   Regular School No Middle 05 08 2018   grade_7 92 1 10   0 1     1   4   55 54 0   4   1   46       5.0 109 92 1 10   0 1     1   4   55 54 0   4 1 46     5 109
2469906 WA Island   school 5308190 15206   South Whidbey School District 530819001358 2511 South Whidbey Middle   Regular School No Middle 07 08 2018   grade_7 92 1 7   0 4     0   8   53 59 0   0   2   35       3.0 112 92 1 7   0 4     0   8   53 59 0   0 2 35     3 112
2571318 WA Pierce   school 5300480 27403   Bethel School District 530048001819 4186 Cedarcrest Middle School   Regular School No Middle 06 08 2020   grade_7 92 42 58   2 24     28   43   152 137 0   13   5   186       8.0 289 92 42 58   2 24     28   43   152 137 0   13 5 186     8 289
2579388 WA Thurston   school 5306180 34111   Olympia School District 530618001737 4473 Thurgood Marshall Middle School   Regular School No Middle 06 08 2020   grade_7 92 5 18   4 8     0   8   77 58 0   6   3   51       10.0 135 92 5 18   4 8     0   8   77 58 0   6 3 51     10 135
2945542 WA Pierce   school 5309180 27083   University Place School District 530918001550 3296 Narrows View Intermediate   Regular School No Middle 05 07 2021   grade_7 92 22 37   0 19     4   49   106 117 0   6   4   83       8.0 223 92 22 37   0 19     4   49   106 117 0   6 4 83     8 223
2946237 WA Chelan   school 5309660 4246   Wenatchee School District 530966001006 4432 Foothills Middle School   Regular School No Middle 06 08 2021   grade_7 92 2 90   1 7     1   5   111 87 0   35   6   99       6.0 198 92 2 90   1 7     1   5   111 87 0   35 6 99     6 198
460871 WA Pierce   school 5300480 27403   Bethel School District 530048000128 3751 Spanaway Middle School   Regular School No 2.0 06 09 2015   grade_7 91 32 42   6 20     11   15   118 99 0   13   3   144       8.0 217 91 32 42   6 20     11   15   118 99 0   13 3 144     8 217
467792 WA Yakima   school 5305460 39003   Naches Valley School District 530546000824 2898 Naches Valley Middle School   Regular School No 1.0 03 08 2015   grade_7 91 0 19   0 0     0   3   58 55 0   2   1   55       1.0 113 91 0 19   0 0     0   3   58 55 0   2 1 55     1 113
472360 WA Island   school 5308190 15206   South Whidbey School District 530819001358 2511 South Whidbey Middle   Regular School No 2.0 06 08 2015   grade_7 91 1 4   0 5     1   4   57 49 0   0   3   26       1.0 106 91 1 4   0 5     1   4   57 49 0   0 3 26     1 106
526156 WA King   school 5304230 17414   Lake Washington School District 530423000671 3922 Kamiakin Middle School   Regular School No 2 06 08 2016   grade_7 91 2 35   1 43     0   13   93 92 0   16   4   63       1.0 185 91 2 35   1 43     0   13   93 92 0   16 4 63     1 185
528857 WA Thurston   school 5306180 34111   Olympia School District 530618000936 3696 Reeves Middle School   Regular School No 2 06 08 2016   grade_7 91 2 13   2 4     0   10   61 61 0   1   1   47       5.0 122 91 2 13   2 4     0   10   61 61 0   1 1 47     5 122

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