Data source: Big Local News · About: Big Local

4,566 rows where grade = "grade_7" and state = "WA" sorted by native_hawaiian_pacific_islander 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
463385 WA Snohomish   school 5302670 31002   Everett School District 530267000397 3253 Evergreen Middle School   Regular School No 2.0 06 08 2015   grade_7 171 9 81   0 32     9   19   157 164 0   36   12   205       11.0 321 171 9 81   0 32     9   19   157 164 0   36 12 205     11 321
463601 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000414 3785 Cascade Middle School   Regular School No 2.0 06 08 2015   grade_7 175 13 59   3 14     9   19   146 146 0   21   8   205       6.0 292 175 13 59   3 14     9   19   146 146 0   21 8 205     6 292
463953 WA King   school 5302820 17210   Federal Way School District 530282000442 3381 Lakota Middle School   Regular School No 2.0 06 08 2015   grade_7 106 35 55   1 26     9   37   147 122 0   24   1   152       8.0 269 106 35 55   1 26     9   37   147 122 0   24 1 152     8 269
472958 WA Pierce   school 5308460 27001   Steilacoom Hist. School District 530846001431 2237 Pioneer Middle   Regular School No 2.0 06 08 2015   grade_7 119 16 36   3 26     9   38   124 123 0   3   3   67       10.0 247 119 16 36   3 26     9   38   124 123 0   3 3 67     10 247
522108 WA Pierce   school 5301410 27400   Clover Park School District 530141000272 3500 Thomas Middle School   Regular School No 2 06 08 2016   grade_7 64 17 51   1 7     9   16   99 66 0   4   1   141       3.0 165 64 17 51   1 7     9   16   99 66 0   4 1 141     3 165
523980 WA King   school 5302820 17210   Federal Way School District 530282001376 4456 Saghalie Middle School (Closed after 2016-2017 school year)   Regular School No 2 06 08 2016   grade_7 39 24 64   0 12     9   25   100 73 0   17   5   133       14.0 173 39 24 64   0 12     9   25   100 73 0   17 5 133     14 173
525557 WA King   school 5303960 17415   Kent School District 530396000624 3764 Meeker Middle School   Regular School No 2 07 08 2016   grade_7 86 51 65   0 73     9   22   174 132 0   41   6   211       14.0 306 86 51 65   0 73     9   22   174 132 0   41 6 211     14 306
529709 WA Pierce   school 5306960 27003   Puyallup School District 530696001178 4443 Doris Stahl Junior High   Regular School No 2 05 09 2016   grade_7 149 20 48   2 23     9   37   141 147 0   15   4   126       16.0 288 149 20 48   2 23     9   37   141 147 0   15 4 126     16 288
530253 WA King   school 5307230 17403   Renton School District 530723001070 3434 Nelsen Middle School   Regular School No 2 06 08 2016   grade_7 100 55 68   2 76     9   25   185 150 0   20   3   208       18.0 335 100 55 68   2 76     9   25   185 150 0   20 3 208     18 335
618899 WA Spokane   school 5301110 32356   Central Valley School District 530111000198 2776 North Pines Middle School   Regular School No Middle 06 08 2017   grade_7 139 5 17   2 3     9   11   93 93 0   17   5   140       10.0 186 139 5 17   2 3     9   11   93 93 0   17 5 140     10 186
619370 WA Pierce   school 5301410 27400   Clover Park School District 530141000257 3248 Hudtloff Middle School   Regular School No Middle 06 08 2017   grade_7 63 18 99   3 11     9   31   122 112 0   35   8   155       2.0 234 63 18 99   3 11     9   31   122 112 0   35 8 155     2 234
621567 WA Pierce   school 5302880 27417   Fife School District 530288000467 3798 Surprise Lake Middle School   Regular School No Middle 06 07 2017   grade_7 131 11 59   3 23     9   37   126 147 0   32   4   119       8.0 273 131 11 59   3 23     9   37   126 147 0   32 4 119     8 273
624358 WA Spokane   school 5304920 32354   Mead School District 530492000747 3191 Mountainside Middle School   Regular School No Middle 07 08 2017   grade_7 294 6 26   1 6     9   22   193 171 0   1   16   129       7.0 364 294 6 26   1 6     9   22   193 171 0   1 16 129     7 364
626355 WA Okanogan   school 5306220 24019   Omak School District 530622003307 5196 Washington Virtual Academy Omak Middle School   Regular School No Middle 06 08 2017   grade_7 363 37 33   9 20     9   4   225 250 0   10   0   158       28.0 475 363 37 33   9 20     9   4   225 250 0   10 0 158     28 475
629870 WA Spokane   school 5308250 32081   Spokane School District 530825001411 3758 Garry Middle School   Regular School No Middle 07 08 2017   grade_7 178 17 36   7 7     9   50   163 141 0   27   9   247       20.0 304 178 17 36   7 7     9   50   163 141 0   27 9 247     20 304
2416864 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000415 3320 Covington Middle School   Regular School No Middle 06 08 2019   grade_7 190 7 119   0 12     9   26   176 183 4   62   14   242       17.0 363 190 7 119   0 12     9   26   176 183 4   62 14 242     17 363
2417009 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001901 4209 Pacific Middle School   Regular School No Middle 06 08 2019   grade_7 195 9 55   1 18     9   35   163 159 0   23   11   116       13.0 322 195 9 55   1 18     9   35   163 159 0   23 11 116     13 322
2421371 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585000868 3611 Nisqually Middle School   Regular School No Middle 06 08 2019   grade_7 143 13 56   6 19     9   42   178 110 0   17   10   142       15.0 288 143 13 56   6 19     9   42   178 110 0   17 10 142     15 288
2458812 WA Kitsap   school 5300660 18100   Bremerton School District 530066001144 4441 Mountain View Middle School   Regular School No Middle 06 08 2018   grade_7 171 20 49   2 10     9   38   172 127 0   16   6   206       19.0 299 171 20 49   2 10     9   38   172 127 0   16 6 206     19 299
2459839 WA Pierce   school 5301410 27400   Clover Park School District 530141000257 3248 Hudtloff Middle School   Regular School No Middle 06 08 2018   grade_7 63 25 101   2 12     9   42   139 115 0   33   10   173       2.0 254 63 25 101   2 12     9   42   139 115 0   33 10 173     2 254
2461366 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000414 3785 Cascade Middle School   Regular School No Middle 06 08 2018   grade_7 182 9 76   3 14     9   28   160 161 0   32   12   196       8.0 321 182 9 76   3 14     9   28   160 161 0   32 12 196     8 321
2466563 WA Okanogan   school 5306220 24019   Omak School District 530622003307 5196 Washington Virtual Academy Omak Middle School   Regular School No Middle 06 08 2018   grade_7 315 41 42   5 19     9   8   210 229 0   8   1   222       31.0 439 315 41 42   5 19     9   8   210 229 0   8 1 222     31 439
2574206 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000414 3785 Cascade Middle School   Regular School No Middle 06 08 2020   grade_7 166 9 98   1 10     9   35   177 150 1   27   12   199       10.0 328 166 9 98   1 10     9   35   177 150 1   27 12 199     10 328
2574366 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001901 4209 Pacific Middle School   Regular School No Middle 06 08 2020   grade_7 210 11 66   0 19     9   47   191 171 0   25   12   171       16.0 362 210 11 66   0 19     9   47   191 171 0   25 12 171     16 362
2574684 WA King   school 5302820 17210   Federal Way School District 530282000452 3431 Totem Middle School   Regular School No Middle 06 08 2020   grade_7 26 49 82   0 33     9   22   124 97 0   65   3   169       3.0 221 26 49 82   0 33     9   22   124 97 0   65 3 169     3 221
2577329 WA Snohomish   school 5304860 31025   Marysville School District 530486002425 4357 Cedarcrest School   Regular School No Middle 06 08 2020   grade_7 125 6 83   7 15     9   37   143 139 0   33   11   162       6.0 282 125 6 83   7 15     9   37   143 139 0   33 11 162     6 282
2579442 WA Okanogan   school 5306220 24019   Omak School District 530622003307 5196 Washington Virtual Academy Omak Middle School   Regular School No Middle 06 08 2020   grade_7 345 25 50   3 25     9   20   238 239 0   10   0   301       24.0 477 345 25 50   3 25     9   20   238 239 0   10 0 301     24 477
2580191 WA Pierce   school 5306960 27003   Puyallup School District 530696001026 3750 Ballou Jr High   Regular School No Middle 07 09 2020   grade_7 157 15 57   0 22     9   47   150 157 0   22   5   111       26.0 307 157 15 57   0 22     9   47   150 157 0   22 5 111     26 307
2584376 WA King   school 5308130 17406   Tukwila School District 530813001342 2564 Showalter Middle School   Regular School No Middle 06 08 2020   grade_7 15 37 90   2 49     9   16   109 108 1   65   13   177       3.0 218 15 37 90   2 49     9   16   109 108 1   65 13 177     3 218
2933318 WA Spokane   school 5301230 32360   Cheney School District 530123003428 5269 Westwood Middle School   Regular School No Middle 06 08 2021   grade_7 114 5 19   1 4     9   16   92 76 0   4   8   85       4.0 168 114 5 19   1 4     9   16   92 76 0   4 8 85     4 168
2945022 WA Pierce   school 5308700 27010   Tacoma School District 530870001504 2359 Stewart   Regular School No Middle 06 08 2021   grade_7 60 32 61   6 24     9   38   123 107 0   28   11   175       6.0 230 60 32 61   6 24     9   38   123 107 0   28 11 175     6 230
2945390 WA King   school 5308130 17406   Tukwila School District 530813001342 2564 Showalter Middle School   Regular School No Middle 06 08 2021   grade_7 21 35 73   2 52     9   17   102 99 8   63   4   167       3.0 209 21 35 73   2 52     9   17   102 99 8   63 4 167     3 209
460680 WA Pierce   school 5300480 27403   Bethel School District 530048000120 3250 Bethel Middle School   Regular School No 2.0 06 09 2015   grade_7 112 36 38   3 11     8   15   112 111 0   1   5   129       9.0 223 112 36 38   3 11     8   15   112 111 0   1 5 129     9 223
464027 WA King   school 5302820 17210   Federal Way School District 530282002964 5029 Sequoyah Middle School   Regular School No 2.0 06 08 2015   grade_7 67 25 28   2 20     8   20   87 83 0   10   2   107       4.0 170 67 25 28   2 20     8   20   87 83 0   10 2 107     4 170
464221 WA Pierce   school 5302880 27417   Fife School District 530288000467 3798 Surprise Lake Middle School   Regular School No 2.0 06 07 2015   grade_7 150 9 42   4 21     8   38   139 133 0   21   5   121       13.0 272 150 9 42   4 21     8   38   139 133 0   21 5 121     13 272
468207 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585000606 4409 Komachin Middle School   Regular School No 2.0 07 08 2015   grade_7 183 29 60   3 23     8   52   189 169 0   8   9   162       14.0 358 183 29 60   3 23     8   52   189 169 0   8 9 162     14 358
469776 WA Pierce   school 5306960 27003   Puyallup School District 530696001178 4443 Doris Stahl Junior High   Regular School No 2.0 07 09 2015   grade_7 136 16 44   2 15     8   41   112 150 0   10   1   110       16.0 262 136 16 44   2 15     8   41   112 150 0   10 1 110     16 262
472262 WA Kitsap   school 5308160 18402   South Kitsap School District 530816001351 3046 Marcus Whitman Middle School   Regular School No 2.0 07 09 2015   grade_7 178 3 25   1 6     8   24   129 116 0   4   0   132       8.0 245 178 3 25   1 6     8   24   129 116 0   4 0 132     8 245
473366 WA Pierce   school 5308700 27010   Tacoma School District 530870001471 2377 Gray   Regular School No 2.0 06 08 2015   grade_7 70 55 42   3 25     8   8   116 95 0   15   13   167       2.0 211 70 55 42   3 25     8   8   116 95 0   15 13 167     2 211
473380 WA Pierce   school 5308700 27010   Tacoma School District 530870001473 2338 Jason Lee   Regular School No 2.0 06 08 2015   grade_7 103 70 18   4 10     8   8   111 110 0   3   12   155       1.0 221 103 70 18   4 10     8   8   111 110 0   3 12 155     1 221
474203 WA Clark   school 5309270 6037   Vancouver School District 530927001562 3902 Gaiser Middle School   Regular School No 2.0 06 08 2015   grade_7 176 12 68   0 10     8   23   153 144 0   32   8   191       3.0 297 176 12 68   0 10     8   23   153 144 0   32 8 191     3 297
520662 WA Pierce   school 5300480 27403   Bethel School District 530048000120 3250 Bethel Middle School   Regular School No 2 06 08 2016   grade_7 125 15 32   3 14     8   21   115 103 0   6   8   125       5.0 218 125 15 32   3 14     8   21   115 103 0   6 8 125     5 218
520766 WA Pierce   school 5300480 27403   Bethel School District 530048003343 5206 Liberty Middle School   Regular School No 2 06 08 2016   grade_7 124 14 24   2 9     8   15   106 90 0   2   0   87       6.0 196 124 14 24   2 9     8   15   106 90 0   2 0 87     6 196
523888 WA King   school 5302820 17210   Federal Way School District 530282000438 3701 Kilo Middle School   Regular School No 2 06 08 2016   grade_7 64 12 67   1 10     8   30   89 103 0   22   3   131       5.0 192 64 12 67   1 10     8   30   89 103 0   22 3 131     5 192
527688 WA Snohomish   school 5305430 31006   Mukilteo School District 530543000719 4425 Voyager Middle School   Regular School No 2 06 08 2016   grade_7 79 34 95   2 36     8   9   125 138 0   43   6   197       9.0 263 79 34 95   2 36     8   9   125 138 0   43 6 197     9 263
530170 WA King   school 5307230 17403   Renton School District 530723002564 3280 Dimmitt Middle School   Regular School No 2 06 08 2016   grade_7 32 76 84   2 92     8   20   145 169 0   37   7   232       9.0 314 32 76 84   2 92     8   20   145 169 0   37 7 232     9 314
621003 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270002510 4498 Frontier Middle School   Regular School No Middle 06 08 2017   grade_7 174 4 45   1 14     8   8   128 126 0   22   6   119       16.0 254 174 4 45   1 14     8   8   128 126 0   22 6 119     16 254
621254 WA King   school 5302820 17210   Federal Way School District 530282000437 3898 Illahee Middle School   Regular School No Middle 05 08 2017   grade_7 72 34 50   1 35     8   30   121 109 0   15   3   133       6.0 230 72 34 50   1 35     8   30   121 109 0   15 3 133     6 230
630579 WA Pierce   school 5308700 27010   Tacoma School District 530870001454 3054 Baker   Regular School No Middle 06 08 2017   grade_7 61 41 60   0 50     8   21   117 124 0   28   11   186       12.0 241 61 41 60   0 50     8   21   117 124 0   28 11 186     12 241
631463 WA Clark   school 5309270 6037   Vancouver School District 530927002018 4503 Discovery Middle School   Regular School No Middle 06 08 2017   grade_7 83 7 74   0 1     8   17   90 100 0   25   11   155       4.0 190 83 7 74   0 1     8   17   90 100 0   25 11 155     4 190
631507 WA Clark   school 5309270 6037   Vancouver School District 530927001562 3902 Gaiser Middle School   Regular School No Middle 06 08 2017   grade_7 159 15 99   3 5     8   20   149 160 0   37   17   188       8.0 309 159 15 99   3 5     8   20   149 160 0   37 17 188     8 309
2418825 WA King   school 5303960 17415   Kent School District 530396000624 3764 Meeker Middle School   Regular School No Middle 07 08 2019   grade_7 74 58 72   1 95     8   37   185 160 0   77   6   221       15.0 345 74 58 72   1 95     8   37   185 160 0   77 6 221     15 345
2418837 WA King   school 5303960 17415   Kent School District 530396000626 3233 Meridian Middle School   Regular School No Middle 07 08 2019   grade_7 72 40 57   0 82     8   21   139 141 0   51   6   178       17.0 280 72 40 57   0 82     8   21   139 141 0   51 6 178     17 280
2423381 WA King   school 5307230 17403   Renton School District 530723001070 3434 Nelsen Middle School   Regular School No Middle 06 08 2019   grade_7 67 47 81   2 88     8   43   162 174 0   39   14   201       19.0 336 67 47 81   2 88     8   43   162 174 0   39 14 201     19 336
2426259 WA Pierce   school 5308700 27010   Tacoma School District 530870003155 4575 Angelo Giaudrone Middle School   Regular School No Middle 06 08 2019   grade_7 53 50 47   1 24     8   20   94 109 0   20   12   160       10.0 203 53 50 47   1 24     8   20   94 109 0   20 12 160     10 203
2461781 WA King   school 5302820 17210   Federal Way School District 530282002964 5029 Sequoyah Middle School   Regular School No Middle 06 08 2018   grade_7 46 30 42   0 22     8   22   79 91 0   28   1   135       5.0 170 46 30 42   0 22     8   22   79 91 0   28 1 135     5 170
2470768 WA Pierce   school 5308700 27010   Tacoma School District 530870003155 4575 Angelo Giaudrone Middle School   Regular School No Middle 06 08 2018   grade_7 53 48 46   2 27     8   28   118 94 0   21   21   157       12.0 212 53 48 46   2 27     8   28   118 94 0   21 21 157     12 212
2571401 WA Pierce   school 5300480 27403   Bethel School District 530048003343 5206 Liberty Middle School   Regular School No Middle 06 08 2020   grade_7 111 15 66   2 9     8   38   119 130 0   10   1   135       11.0 249 111 15 66   2 9     8   38   119 130 0   10 1 135     11 249
2572417 WA Spokane   school 5301230 32360   Cheney School District 530123003428 5269 Westwood Middle School   Regular School No Middle 06 08 2020   grade_7 148 1 21   7 6     8   12   108 95 0   12   4   114       9.0 203 148 1 21   7 6     8   12   108 95 0   12 4 114     9 203
2574618 WA King   school 5302820 17210   Federal Way School District 530282002964 5029 Sequoyah Middle School   Regular School No Middle 06 08 2020   grade_7 60 42 56   1 26     8   20   103 110 0   33   5   158       5.0 213 60 42 56   1 26     8   20   103 110 0   33 5 158     5 213
2578670 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585000606 4409 Komachin Middle School   Regular School No Middle 06 08 2020   grade_7 110 12 52   2 18     8   38   141 99 0   9   7   117       15.0 240 110 12 52   2 18     8   38   141 99 0   9 7 117     15 240
2582714 WA Kitsap   school 5308160 18402   South Kitsap School District 530816001351 3046 Marcus Whitman Middle School   Regular School No Middle 06 08 2020   grade_7 146 3 37   3 7     8   38   130 112 0   7   2   114       13.0 242 146 3 37   3 7     8   38   130 112 0   7 2 114     13 242
2585875 WA Thurston   school 5310140 34002   Yelm School District 531014001717 2481 Yelm Middle School   Regular School No Middle 06 08 2020   grade_7 163 2 41   5 5     8   28   134 117 1   5   7   139       13.0 252 163 2 41   5 5     8   28   134 117 1   5 7 139     13 252
2932485 WA Kitsap   school 5300660 18100   Bremerton School District 530066001144 4441 Mountain View Middle School   Regular School No Middle 06 08 2021   grade_7 149 15 70   2 9     8   48   152 149 0   23   0   199       12.0 301 149 15 70   2 9     8   48   152 149 0   23 0 199     12 301
2933063 WA Spokane   school 5301110 32356   Central Valley School District 530111000198 2776 North Pines Middle School   Regular School No Middle 06 08 2021   grade_7 130 7 4   0 5     8   8   82 80 0   12   8   106       1.0 162 130 7 4   0 5     8   8   82 80 0   12 8 106     1 162
2935072 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000414 3785 Cascade Middle School   Regular School No Middle 06 08 2021   grade_7 159 8 92   1 13     8   33   156 157 1   42   9   202       3.0 314 159 8 92   1 13     8   33   156 157 1   42 9 202     3 314
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
2941227 WA Pierce   school 5306960 27003   Puyallup School District 530696001865 4183 Ferrucci Jr High   Regular School No Middle 07 09 2021   grade_7 135 21 61   3 19     8   28   144 131 0   10   6   128       32.0 275 135 21 61   3 19     8   28   144 131 0   10 6 128     32 275
2943694 WA Kitsap   school 5308160 18402   South Kitsap School District 530816001877 4142 John Sedgwick Middle School   Regular School No Middle 06 08 2021   grade_7 178 3 30   1 5     8   22   125 122 0   2   0   64       8.0 247 178 3 30   1 5     8   22   125 122 0   2 0 64     8 247
460059 WA King   school 5300300 17408   Auburn School District 530030002434 4385 Rainier Middle School   Regular School No 2.0 06 08 2015   grade_7 145 32 56   1 28     7   18   148 139 0   13   2   155       18.0 287 145 32 56   1 28     7   18   148 139 0   13 2 155     18 287
463614 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000415 3320 Covington Middle School   Regular School No 2.0 06 08 2015   grade_7 212 18 73   1 9     7   19   182 157 0   38   9   245       7.0 339 212 18 73   1 9     7   19   182 157 0   38 9 245     7 339
464022 WA King   school 5302820 17210   Federal Way School District 530282001376 4456 Saghalie Middle School (Closed after 2016-2017 school year)   Regular School No 2.0 06 08 2015   grade_7 47 13 61   3 6     7   12   84 65 0   21   2   110       5.0 149 47 13 61   3 6     7   12   84 65 0   21 2 110     5 149
465412 WA King   school 5303960 17415   Kent School District 530396001142 4440 Cedar Heights Middle School   Regular School No 2.0 07 08 2015   grade_7 194 25 53   1 20     7   30   177 153 0   26   2   156       13.0 330 194 25 53   1 20     7   30   177 153 0   26 2 156     13 330
522778 WA Snohomish   school 5302400 31015   Edmonds School District 530240000332 3650 Brier Terrace Middle School   Regular School No 2 07 08 2016   grade_7 181 13 48   1 40     7   47   191 146 0   13   14   121       27.0 337 181 13 48   1 40     7   47   191 146 0   13 14 121     27 337
523984 WA King   school 5302820 17210   Federal Way School District 530282002964 5029 Sequoyah Middle School   Regular School No 2 06 08 2016   grade_7 73 30 42   1 26     7   33   98 114 0   15   7   130       8.0 212 73 30 42   1 26     7   33   98 114 0   15 7 130     8 212
533337 WA Pierce   school 5308700 27010   Tacoma School District 530870003299 5170 First Creek Middle School   Regular School No 2 06 08 2016   grade_7 40 63 60   7 44     7   11   119 113 0   21   7   178       18.0 232 40 63 60   7 44     7   11   119 113 0   21 7 178     18 232
618135 WA Pierce   school 5300480 27403   Bethel School District 530048003343 5206 Liberty Middle School   Regular School No Middle 06 08 2017   grade_7 147 17 36   1 10     7   31   134 117 0   3   7   129       14.0 251 147 17 36   1 10     7   31   134 117 0   3 7 129     14 251
618322 WA Kitsap   school 5300660 18100   Bremerton School District 530066001144 4441 Mountain View Middle School   Regular School No Middle 06 08 2017   grade_7 141 17 47   2 12     7   43   134 135 0   12   7   175       12.0 269 141 17 47   2 12     7   43   134 135 0   12 7 175     12 269
620951 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000415 3320 Covington Middle School   Regular School No Middle 06 08 2017   grade_7 204 9 86   4 16     7   17   162 181 0   44   17   241       8.0 343 204 9 86   4 16     7   17   162 181 0   44 17 241     8 343
621155 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000428 4051 Wyeast Middle School   Regular School No Middle 06 08 2017   grade_7 143 6 106   3 7     7   14   140 146 0   44   10   180       5.0 286 143 6 106   3 7     7   14   140 146 0   44 10 180     5 286
621660 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294000479 3300 Morris Ford Middle School   Regular School No Middle 06 08 2017   grade_7 134 18 80   2 24     7   39   157 147 0   21   8   248       16.0 304 134 18 80   2 24     7   39   157 147 0   21 8 248     16 304
622753 WA King   school 5303960 17415   Kent School District 530396001142 4440 Cedar Heights Middle School   Regular School No Middle 07 08 2017   grade_7 165 35 55   3 28     7   25   177 141 0   30   6   163       18.0 318 165 35 55   3 28     7   25   177 141 0   30 6 163     18 318
625087 WA Snohomish   school 5305430 31006   Mukilteo School District 530543000820 3120 Olympic View Middle School   Regular School No Middle 06 08 2017   grade_7 160 20 55   1 38     7   27   158 150 0   32   6   158       12.0 308 160 20 55   1 38     7   27   158 150 0   32 6 158     12 308
2414000 WA Pierce   school 5300480 27403   Bethel School District 530048001819 4186 Cedarcrest Middle School   Regular School No Middle 06 08 2019   grade_7 81 29 39   4 18     7   48   124 102 0   10   2   137       7.0 226 81 29 39   4 18     7   48   124 102 0   10 2 137     7 226
2414827 WA Spokane   school 5301110 32356   Central Valley School District 530111000198 2776 North Pines Middle School   Regular School No Middle 06 08 2019   grade_7 150 9 2   3 3     7   12   103 83 0   14   3   147       0.0 186 150 9 2   3 3     7   12   103 83 0   14 3 147     0 186
2415362 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 2019   grade_7 37 19 43   0 1     7   24   65 66 0   4   1   90       13.0 131 37 19 43   0 1     7   24   65 66 0   4 1 90     13 131
2417855 WA King   school 5303540 17401   Highline School District 530354000522 3163 Cascade Middle School   Regular School No Middle 07 08 2019   grade_7 34 20 135   1 54     7   11   140 122 0   78   13   221       5.0 262 34 20 135   1 54     7   11   140 122 0   78 13 221     5 262
2426406 WA Pierce   school 5308700 27010   Tacoma School District 530870001471 2377 Gray   Regular School No Middle 06 08 2019   grade_7 46 38 45   2 16     7   14   84 84 0   25   14   150       3.0 168 46 38 45   2 16     7   14   84 84 0   25 14 150     3 168
2459264 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108002056 4249 Ridgetop Middle School   Regular School No Middle 06 08 2018   grade_7 135 7 57   2 13     7   41   138 124 0   0   0   96       11.0 262 135 7 57   2 13     7   41   138 124 0   0 0 96     11 262
2459374 WA Spokane   school 5301110 32356   Central Valley School District 530111000198 2776 North Pines Middle School   Regular School No Middle 06 08 2018   grade_7 110 7 25   2 2     7   10   80 83 0   20   5   122       9.0 163 110 7 25   2 2     7   10   80 83 0   20 5 122     9 163
2459876 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 2018   grade_7 49 13 31   2 0     7   25   68 59 0   2   1   72       3.0 127 49 13 31   2 0     7   25   68 59 0   2 1 72     3 127
2465792 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585000606 4409 Komachin Middle School   Regular School No Middle 06 08 2018   grade_7 106 23 60   1 13     7   34   125 119 0   11   9   109       18.0 244 106 23 60   1 13     7   34   125 119 0   11 9 109     18 244
2465833 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585000868 3611 Nisqually Middle School   Regular School No Middle 06 08 2018   grade_7 122 17 49   3 12     7   33   114 129 0   9   8   107       16.0 243 122 17 49   3 12     7   33   114 129 0   9 8 107     16 243
2467885 WA King   school 5307230 17403   Renton School District 530723001070 3434 Nelsen Middle School   Regular School No Middle 06 08 2018   grade_7 110 58 64   0 73     7   32   188 156 0   33   16   210       17.0 344 110 58 64   0 73     7   32   188 156 0   33 16 210     17 344
2468512 WA King   school 5307710 17001   Seattle School District No. 1 530771001913 2839 David T. Denny International Middle School   Regular School No Middle 06 08 2018   grade_7 62 63 93   4 47     7   9   159 126 0   54   33   209       3.0 285 62 63 93   4 47     7   9   159 126 0   54 33 209     3 285
2469770 WA Kitsap   school 5308160 18402   South Kitsap School District 530816001346 3680 Cedar Heights Middle School   Regular School No Middle 06 08 2018   grade_7 182 4 39   5 15     7   23   137 138 0   5   2   122       9.0 275 182 4 39   5 15     7   23   137 138 0   5 2 122     9 275
2471135 WA Pierce   school 5308700 27010   Tacoma School District 530870001507 3448 Truman   Regular School No Middle 06 08 2018   grade_7 114 47 41   3 19     7   19   128 122 0   23   21   162       12.0 250 114 47 41   3 19     7   19   128 122 0   23 21 162     12 250
2572712 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 2020   grade_7 55 21 36   1 8     7   35   77 86 0   11   3   89       12.0 163 55 21 36   1 8     7   35   77 86 0   11 3 89     12 163
2572764 WA Pierce   school 5301410 27400   Clover Park School District 530141000272 3500 Thomas Middle School   Regular School No Middle 06 08 2020   grade_7 68 26 55   0 8     7   16   96 84 0   16   12   143       8.0 180 68 26 55   0 8     7   16   96 84 0   16 12 143     8 180
2574528 WA King   school 5302820 17210   Federal Way School District 530282000438 3701 Kilo Middle School   Regular School No Middle 06 08 2020   grade_7 63 25 70   1 21     7   18   121 84 0   37   10   145       8.0 205 63 25 70   1 21     7   18   121 84 0   37 10 145     8 205

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