Data source: Big Local News · About: Big Local

4,566 rows where grade = "grade_7" and state = "WA" sorted by black 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
531217 WA King   school 5307710 17001   Seattle School District No. 1 530771001136 3095 Mercer International Middle School   Regular School No 2 06 08 2016   grade_7 40 98 72   1 164     1   20   196 200 0   65   17   281       8.0 396 40 98 72   1 164     1   20   196 200 0   65 17 281     8 396
2418840 WA King   school 5303960 17415   Kent School District 530396002986 5016 Mill Creek Middle School   Regular School No Middle 07 08 2019   grade_7 67 94 177   0 68     23   37   237 229 0   128   16   361       21.0 466 67 94 177   0 68     23   37   237 229 0   128 16 361     21 466
471227 WA King   school 5307710 17001   Seattle School District No. 1 530771001136 3095 Mercer International Middle School   Regular School No 2.0 06 08 2015   grade_7 35 93 51   1 141     1   15   173 164 0   68   17   247       1.0 337 35 93 51   1 141     1   15   173 164 0   68 17 247     1 337
2942702 WA King   school 5307710 17001   Seattle School District No. 1 530771001136 3095 Mercer International Middle School   Regular School No Middle 06 08 2021   grade_7 56 93 56   1 137     1   33   207 170 0   61   24   232       4.0 377 56 93 56   1 137     1   33   207 170 0   61 24 232     4 377
2468374 WA King   school 5307710 17001   Seattle School District No. 1 530771001249 3774 Aki Kurose Middle School   Regular School No Middle 06 08 2018   grade_7 12 91 34   0 80     3   13   131 102 0   54   33   198       5.0 233 12 91 34   0 80     3   13   131 102 0   54 33 198     5 233
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
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
468566 WA King   school 5305910 17417   Northshore School District 530591000480 4371 Skyview Middle School   Regular School No 2.0 07 09 2015   grade_7 158 9 34   2 75     0   14   134 158 0   13   0   66       17.0 292 158 9 34   2 75     0   14   134 158 0   13 0 66     17 292
469754 WA Pierce   school 5306960 27003   Puyallup School District 530696001022 3447 Aylen Jr High   Regular School No 2.0 07 09 2015   grade_7 129 9 39   5 6     0   12   97 103 0   11   2   87       6.0 200 129 9 39   5 6     0   12   97 103 0   11 2 87     6 200
471209 WA King   school 5307710 17001   Seattle School District No. 1 530771001212 3517 McClure Middle School   Regular School No 2.0 06 08 2015   grade_7 120 9 17   3 20     0   13   83 99 0   8   6   40       17.0 182 120 9 17   3 20     0   13   83 99 0   8 6 40     17 182
520739 WA Pierce   school 5300480 27403   Bethel School District 530048000595 4407 Frontier Middle School   Regular School No 2 06 08 2016   grade_7 174 9 25   7 13     2   14   125 119 0   2   2   95       13.0 244 174 9 25   7 13     2   14   125 119 0   2 2 95     13 244
521373 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108000183 3791 Fairview Middle School   Regular School No 2 07 08 2016   grade_7 138 9 37   0 18     4   38   121 123 0   9   15   115       13.0 244 138 9 37   0 18     4   38   121 123 0   9 15 115     13 244
523576 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000415 3320 Covington Middle School   Regular School No 2 06 08 2016   grade_7 195 9 92   0 17     6   21   199 141 0   44   13   222       6.0 340 195 9 92   0 17     6   21   199 141 0   44 13 222     6 340
525021 WA King   school 5303750 17411   Issaquah School District 530375000579 3636 Maywood Middle School   Regular School No 2 06 08 2016   grade_7 219 9 39   1 84     3   22   175 202 0   6   4   60       22.0 377 219 9 39   1 84     3   22   175 202 0   6 4 60     22 377
526265 WA King   school 5304230 17414   Lake Washington School District 530423000680 3232 Redmond Middle School   Regular School No 2 06 08 2016   grade_7 156 9 49   1 68     0   21   151 154 0   18   4   66       4.0 305 156 9 49   1 68     0   21   151 154 0   18 4 66     4 305
526980 WA Spokane   school 5304920 32354   Mead School District 530492000748 3851 Northwood Middle School   Regular School No 2 07 08 2016   grade_7 283 9 26   1 4     1   35   201 158 0   3   5   108       10.0 359 283 9 26   1 4     1   35   201 158 0   3 5 108     10 359
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
530374 WA Benton   school 5307320 3400   Richland School District 530732002504 3926 Enterprise Middle School   Regular School No 2 06 08 2016   grade_7 317 9 31   4 14     1   7   191 192 0   4   1   78       0.0 383 317 9 31   4 14     1   7   191 192 0   4 1 78     0 383
618110 WA Pierce   school 5300480 27403   Bethel School District 530048000595 4407 Frontier Middle School   Regular School No Middle 06 08 2017   grade_7 171 9 29   4 4     2   20   131 109 0   3   3   100       5.0 240 171 9 29   4 4     2   20   131 109 0   3 3 100     5 240
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
627795 WA Benton   school 5307320 3400   Richland School District 530732001091 2721 Carmichael Middle School   Regular School No Middle 06 08 2017   grade_7 207 9 62   1 6     0   12   147 150 0   14   7   121       1.0 297 207 9 62   1 6     0   12   147 150 0   14 7 121     1 297
628387 WA King   school 5307710 17001   Seattle School District No. 1 530771001180 2371 Hamilton International Middle School   Regular School No Middle 06 08 2017   grade_7 319 9 19   0 27     1   31   225 181 0   2   4   28       19.0 406 319 9 19   0 27     1   31   225 181 0   2 4 28     19 406
628526 WA King   school 5307710 17001   Seattle School District No. 1 530771003426 5276 Louisa Boren STEM K-8   Regular School No Elementary PK 08 2017   grade_7 29 9 5   0 10     0   6   26 33 0   2   1   17       2.0 59 29 9 5   0 10     0   6   26 33 0   2 1 17     2 59
628576 WA King   school 5307710 17001   Seattle School District No. 1 530771001212 3517 McClure Middle School   Regular School No Middle 06 08 2017   grade_7 106 9 22   1 19     2   13   77 95 0   6   9   31       14.0 172 106 9 22   1 19     2   13   77 95 0   6 9 31     14 172
631019 WA King   school 5308760 17409   Tahoma School District 530876002979 3341 Summit Trail Middle School   Regular School No Middle 06 07 2017   grade_7 229 9 21   0 12     2   19   149 143 0   5   2   44       24.0 292 229 9 21   0 12     2   19   149 143 0   5 2 44     24 292
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
2416679 WA Snohomish   school 5302670 31002   Everett School District 530267001725 4437 Gateway Middle School   Regular School No Middle 06 08 2019   grade_7 141 9 26   2 71     1   31   169 112 0   9   5   36       20.0 281 141 9 26   2 71     1   31   169 112 0   9 5 36     20 281
2416853 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000414 3785 Cascade Middle School   Regular School No Middle 06 08 2019   grade_7 180 9 97   0 13     10   27   183 153 0   42   10   223       6.0 336 180 9 97   0 13     10   27   183 153 0   42 10 223     6 336
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
2418274 WA King   school 5303750 17411   Issaquah School District 530375000579 3636 Maywood Middle School   Regular School No Middle 06 08 2019   grade_7 235 9 38   0 84     1   38   199 206 0   10   4   50       38.0 405 235 9 38   0 84     1   38   199 206 0   10 4 50     38 405
2418482 WA Benton   school 5303930 3017   Kennewick School District 530393000598 4028 Desert Hills Middle School   Regular School No Middle 06 08 2019   grade_7 245 9 39   1 2     1   7   153 151 0   3   1   65       14.0 304 245 9 39   1 2     1   7   153 151 0   3 1 65     14 304
2418515 WA Benton   school 5303930 3017   Kennewick School District 530393000603 3267 Highlands Middle School   Regular School No Middle 06 08 2019   grade_7 114 9 157   2 3     0   15   154 146 0   79   10   243       10.0 300 114 9 157   2 3     0   15   154 146 0   79 10 243     10 300
2419167 WA Snohomish   school 5304200 31004   Lake Stevens School District 530420000652 3408 Lake Stevens Middle School   Regular School No Middle 06 07 2019   grade_7 211 9 55   0 15     0   31   156 165 0   7   3   105       29.0 321 211 9 55   0 15     0   31   156 165 0   7 3 105     29 321
2422925 WA Pierce   school 5306960 27003   Puyallup School District 530696001032 3052 Kalles Junior High   Regular School No Middle 07 09 2019   grade_7 181 9 43   0 18     0   45   163 133 0   5   1   100       23.0 296 181 9 43   0 18     0   45   163 133 0   5 1 100     23 296
2426703 WA King   school 5308760 17409   Tahoma School District 530876001515 3937 Maple View Middle School   Regular School No Middle 06 08 2019   grade_7 220 9 42   1 20     2   39   175 158 0   2   3   60       34.0 333 220 9 42   1 20     2   39   175 158 0   2 3 60     34 333
2427164 WA Clark   school 5309270 6037   Vancouver School District 530927002018 4503 Discovery Middle School   Regular School No Middle 06 08 2019   grade_7 100 9 100   1 3     2   19   111 123 0   41   9   173       10.0 234 100 9 100   1 3     2   19   111 123 0   41 9 173     10 234
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
2461377 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000415 3320 Covington Middle School   Regular School No Middle 06 08 2018   grade_7 185 9 110   2 10     11   37   188 176 0   58   17   246       7.0 364 185 9 110   2 10     11   37   188 176 0   58 17 246     7 364
2462733 WA King   school 5303750 17411   Issaquah School District 530375000573 3038 Issaquah Middle School   Regular School No Middle 06 08 2018   grade_7 197 9 45   1 73     1   18   171 173 0   21   2   62       19.0 344 197 9 45   1 73     1   18   171 173 0   21 2 62     19 344
2462955 WA Benton   school 5303930 3017   Kennewick School District 530393000598 4028 Desert Hills Middle School   Regular School No Middle 06 08 2018   grade_7 223 9 45   1 6     0   13   139 158 0   3   0   76       9.0 297 223 9 45   1 6     0   13   139 158 0   3 0 76     9 297
2462981 WA Benton   school 5303930 3017   Kennewick School District 530393000603 3267 Highlands Middle School   Regular School No Middle 06 08 2018   grade_7 100 9 144   2 3     0   8   133 133 0   58   3   218       6.0 266 100 9 144   2 3     0   8   133 133 0   58 3 218     6 266
2464386 WA Mason   school 5304800 23311   Mary M Knight School District 530480003569 5445 Washington Connections Academy   Regular School No Other KG 10 2018   grade_7 78 9 12   2 3     2   6   62 50 0   0   0   29       11.0 112 78 9 12   2 3     2   6   62 50 0   0 0 29     11 112
2464671 WA Spokane   school 5304920 32354   Mead School District 530492000748 3851 Northwood Middle School   Regular School No Middle 06 08 2018   grade_7 339 9 27   3 7     0   30   211 204 0   3   15   107       17.0 415 339 9 27   3 7     0   30   211 204 0   3 15 107     17 415
2467296 WA Whitman   school 5306930 38267   Pullman School District 530693001019 3419 Lincoln Middle School   Regular School No Middle 06 08 2018   grade_7 160 9 19   1 18     0   12   104 115 0   5   6   63       16.0 219 160 9 19   1 18     0   12   104 115 0   5 6 63     16 219
2468610 WA King   school 5307710 17001   Seattle School District No. 1 530771001180 2371 Hamilton International Middle School   Regular School No Middle 06 08 2018   grade_7 241 9 36   0 30     0   22   187 151 0   1   11   38       18.0 338 241 9 36   0 30     0   22   187 151 0   1 11 38     18 338
2571967 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108000178 3237 Central Kitsap Middle School   Regular School No Middle 06 08 2020   grade_7 160 9 33   0 16     2   33   124 129 0   2   2   34       14.0 253 160 9 33   0 16     2   33   124 129 0   2 2 34     14 253
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
2576535 WA Snohomish   school 5304200 31004   Lake Stevens School District 530420001906 4139 North Lake Middle School   Regular School No Middle 06 07 2020   grade_7 299 9 48   7 18     2   38   220 201 0   9   6   115       36.0 421 299 9 48   7 18     2   38   220 201 0   9 6 115     36 421
2577389 WA Snohomish   school 5304860 31025   Marysville School District 530486000736 3355 Marysville Middle School   Regular School No Middle 06 08 2020   grade_7 124 9 96   5 22     3   36   144 151 0   38   10   166       11.0 295 124 9 96   5 22     3   36   144 151 0   38 10 166     11 295
2577547 WA Spokane   school 5304920 32354   Mead School District 530492000748 3851 Northwood Middle School   Regular School No Middle 06 08 2020   grade_7 349 9 34   3 9     0   42   232 214 0   10   14   136       8.0 446 349 9 34   3 9     0   42   232 214 0   10 14 136     8 446
2579392 WA Thurston   school 5306180 34111   Olympia School District 530618000935 3711 Washington Middle School   Regular School No Middle 06 08 2020   grade_7 161 9 33   0 22     1   37   138 123 2   1   3   55       15.0 263 161 9 33   0 22     1   37   138 123 2   1 3 55     15 263
2579759 WA Franklin   school 5306570 11001   Pasco School District 530657000967 2267 Mcloughlin Middle School   Regular School No Middle 07 08 2020   grade_7 279 9 371   1 7     1   36   354 350 0   86   1   388       20.0 704 279 9 371   1 7     1   36   354 350 0   86 1 388     20 704
2581509 WA King   school 5307710 17001   Seattle School District No. 1 530771003271 5175 Hazel Wolf K-8   Regular School No Elementary KG 08 2020   grade_7 47 9 14   0 8     0   11   51 37 1   10   0   27       9.0 89 47 9 14   0 8     0   11   51 37 1   10 0 27     9 89
2582503 WA Snohomish   school 5308020 31201   Snohomish School District 530802001790 4145 Valley View Middle School   Regular School No Middle 07 08 2020   grade_7 254 9 43   1 29     0   23   164 194 1   3   3   62       31.0 359 254 9 43   1 29     0   23   164 194 1   3 3 62     31 359
2936748 WA Benton   school 5303930 3017   Kennewick School District 530393000603 3267 Highlands Middle School   Regular School No Middle 06 08 2021   grade_7 78 9 159   1 2     2   11   139 123 0   46   5   202       13.0 262 78 9 159   1 2     2   11   139 123 0   46 5 202     13 262
2940332 WA Thurston   school 5306180 34111   Olympia School District 530618001737 4473 Thurgood Marshall Middle School   Regular School No Middle 06 08 2021   grade_7 68 9 13   1 13     1   17   66 56 0   3   1   40       7.0 122 68 9 13   1 13     1   17   66 56 0   3 1 40     7 122
2942491 WA King   school 5307710 17001   Seattle School District No. 1 530771001180 2371 Hamilton International Middle School   Regular School No Middle 06 08 2021   grade_7 216 9 39   0 29     2   51   185 159 2   2   0   27       17.0 346 216 9 39   0 29     2   51   185 159 2   2 0 27     17 346
2943897 WA Spokane   school 5308250 32081   Spokane School District 530825001732 4457 Chase Middle School   Regular School No Middle 07 08 2021   grade_7 230 9 37   4 10     1   51   178 164 0   21   7   198       12.0 342 230 9 37   4 10     1   51   178 164 0   21 7 198     12 342
2468819 WA King   school 5307710 17001   Seattle School District No. 1 530771001136 3095 Mercer International Middle School   Regular School No Middle 06 08 2018   grade_7 67 84 74   0 151     0   33   207 202 0   53   36   263       7.0 409 67 84 74   0 151     0   33   207 202 0   53 36 263     7 409
2423235 WA King   school 5300342 17910   Rainier Valley Leadership Academy 530034203602 5468 Rainier Valley Leadership Academy   Regular School Yes Middle 06 09 2019   grade_7 11 83 10   0 5     0   4   52 61 0   22   4   85       1.0 113 11 83 10   0 5     0   4   52 61 0   22 4 85     1 113
2467804 WA King   school 5307230 17403   Renton School District 530723002564 3280 Dimmitt Middle School   Regular School No Middle 06 08 2018   grade_7 22 83 35   0 52     6   23   97 124 0   33   13   170       9.0 221 22 83 35   0 52     6   23   97 124 0   33 13 170     9 221
2937075 WA King   school 5303960 17415   Kent School District 530396002986 5016 Mill Creek Middle School   Regular School No Middle 07 08 2021   grade_7 68 83 151   0 66     29   35   208 224 0   117   5   320       19.0 432 68 83 151   0 66     29   35   208 224 0   117 5 320     19 432
470235 WA King   school 5307230 17403   Renton School District 530723002564 3280 Dimmitt Middle School   Regular School No 2.0 06 08 2015   grade_7 41 82 67   2 93     4   17   144 162 0   31   12   226       11.0 306 41 82 67   2 93     4   17   144 162 0   31 12 226     11 306
460351 WA King   school 5300390 17405   Bellevue School District 530039000064 3338 Chinook Middle School   Regular School No 2.0 06 08 2015   grade_7 180 8 25   0 92     1   35   175 166 0   11   3   55       22.0 341 180 8 25   0 92     1   35   175 166 0   11 3 55     22 341
460487 WA King   school 5300390 17405   Bellevue School District 530039000093 3435 Tillicum Middle School   Regular School No 2.0 06 08 2015   grade_7 129 8 19   0 26     1   22   93 112 0   7   1   33       10.0 205 129 8 19   0 26     1   22   93 112 0   7 1 33     10 205
462792 WA Snohomish   school 5302400 31015   Edmonds School District 530240000332 3650 Brier Terrace Middle School   Regular School No 2.0 07 08 2015   grade_7 189 8 41   0 39     1   44   157 165 0   13   5   110       26.0 322 189 8 41   0 39     1   44   157 165 0   13 5 110     26 322
463663 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270002510 4498 Frontier Middle School   Regular School No 2.0 06 08 2015   grade_7 185 8 48   3 19     4   19   147 139 0   27   5   144       5.0 286 185 8 48   3 19     4   19   147 139 0   27 5 144     5 286
463764 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001901 4209 Pacific Middle School   Regular School No 2.0 06 08 2015   grade_7 212 8 37   1 24     6   26   167 147 0   19   3   133       11.0 314 212 8 37   1 24     6   26   167 147 0   19 3 133     11 314
465293 WA Benton   school 5303930 3017   Kennewick School District 530393000750 4429 Horse Heaven Hills Middle School   Regular School No 2.0 06 08 2015   grade_7 188 8 87   2 2     3   12   162 140 0   12   2   154       2.0 302 188 8 87   2 2     3   12   162 140 0   12 2 154     2 302
465945 WA Snohomish   school 5304200 31004   Lake Stevens School District 530420000652 3408 Lake Stevens Middle School   Regular School No 2.0 05 08 2015   grade_7 193 8 48   2 9     1   27   148 140 0   11   5   106       13.0 288 193 8 48   2 9     1   27   148 140 0   11 5 106     13 288
469811 WA Pierce   school 5306960 27003   Puyallup School District 530696001865 4183 Ferrucci Jr High   Regular School No 2.0 07 09 2015   grade_7 141 8 29   3 4     3   30   116 102 0   7   6   116       17.0 218 141 8 29   3 4     3   30   116 102 0   7 6 116     17 218
475475 WA Thurston   school 5310140 34002   Yelm School District 531014001717 2481 Yelm Middle School   Regular School No 2.0 07 09 2015   grade_7 152 8 36   1 5     0   24   96 130 0   4   1   104       16.0 226 152 8 36   1 5     0   24   96 130 0   4 1 104     16 226
520709 WA Pierce   school 5300480 27403   Bethel School District 530048003158 4578 Cougar Mountain Middle School   Regular School No 2 06 08 2016   grade_7 121 8 20   3 11     2   11   103 73 0   0   3   77       2.0 176 121 8 20   3 11     2   11   103 73 0   0 3 77     2 176
520718 WA Pierce   school 5300480 27403   Bethel School District 530048000123 2877 Elk Plain School of Choice   Regular School No 1 KG 07 2016   grade_7 27 8 6   0 2     0   1   23 21 0   0   0   17       5.0 44 27 8 6   0 2     0   1   23 21 0   0 0 17     5 44
523564 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000414 3785 Cascade Middle School   Regular School No 2 06 08 2016   grade_7 148 8 89   3 9     11   23   140 151 0   27   9   209       4.0 291 148 8 89   3 9     11   23   140 151 0   27 9 209     4 291
524031 WA King   school 5302820 17210   Federal Way School District 530282003245 5138 Technology Access Foundation Academy (Closed after 2016-2017 school year)   Regular School No 4 06 12 2016   grade_7 10 8 15   2 8     0   7   28 22 0   3   0   31       4.0 50 10 8 15   2 8     0   7   28 22 0   3 0 31     4 50
525301 WA Benton   school 5303930 3017   Kennewick School District 530393000607 3472 Park Middle School   Regular School No 2 06 08 2016   grade_7 61 8 198   1 8     0   4   161 119 0   72   5   255       11.0 280 61 8 198   1 8     0   4   161 119 0   72 5 255     11 280
526800 WA Snohomish   school 5304860 31025   Marysville School District 530486000736 3355 Marysville Middle School   Regular School No 2 05 08 2016   grade_7 123 8 76   6 11     3   28   128 127 0   18   11   143       9.0 255 123 8 76   6 11     3   28   128 127 0   18 11 143     9 255
528454 WA King   school 5305910 17417   Northshore School District 530591000480 4371 Skyview Middle School   Regular School No 2 07 09 2016   grade_7 174 8 44   3 98     1   34   178 184 0   9   0   66       14.0 362 174 8 44   3 98     1   34   178 184 0   9 0 66     14 362
528577 WA Island   school 5305940 15201   Oak Harbor School District 530594000904 3274 Oak Harbor Intermediate School   Regular School No 2 06 08 2016   grade_7 117 8 17   1 17     1   16   87 90 0   2   5   80       13.0 177 117 8 17   1 17     1   16   87 90 0   2 5 80     13 177
531294 WA King   school 5307710 17001   Seattle School District No. 1 530771001102 1620 Pathfinder K-8 School   Alternative Education School No 1 KG 08 2016   grade_7 35 8 5   0 5     0   6   30 29 0   2   3   12       4.0 59 35 8 5   0 5     0   6   30 29 0   2 3 12     4 59
531459 WA King   school 5307710 17001   Seattle School District No. 1 530771001307 1579 Tops K-8 School   Alternative Education School No 1 PK 08 2016   grade_7 30 8 3   1 13     0   5   23 37 0   4   1   19       6.0 60 30 8 3   1 13     0   5   23 37 0   4 1 19     6 60
534256 WA Clark   school 5309270 6037   Vancouver School District 530927001577 3146 Mcloughlin Middle School   Regular School No 2 06 08 2016   grade_7 105 8 151   0 7     21   17   167 142 0   72   15   266       8.0 309 105 8 151   0 7     21   17   167 142 0   72 15 266     8 309
617768 WA King   school 5300390 17405   Bellevue School District 530039000079 3631 Odle Middle School   Regular School No Middle 06 08 2017   grade_7 68 8 42   1 185     0   33   177 160 0   20   6   79       15.0 337 68 8 42   1 185     0   33   177 160 0   20 6 79     15 337
620159 WA Snohomish   school 5302400 31015   Edmonds School District 530240000332 3650 Brier Terrace Middle School   Regular School No Middle 07 08 2017   grade_7 145 8 44   2 55     2   40   153 143 0   18   5   92       28.0 296 145 8 44   2 55     2   40   153 143 0   18 5 92     28 296
620938 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000414 3785 Cascade Middle School   Regular School No Middle 06 08 2017   grade_7 159 8 74   1 16     10   24   170 122 0   27   17   194       9.0 292 159 8 74   1 16     10   24   170 122 0   27 17 194     9 292
622587 WA Benton   school 5303930 3017   Kennewick School District 530393003586 5439 Chinook Middle School   Regular School No Middle 06 08 2017   grade_7 166 8 71   0 10     1   13   141 128 0   14   2   147       7.0 269 166 8 71   0 10     1   13   141 128 0   14 2 147     7 269
624681 WA Grant   school 5305220 13161   Moses Lake School District 530522002625 2673 Frontier Middle School   Regular School No Middle 06 08 2017   grade_7 119 8 111   1 3     0   4   114 132 0   26   5   159       13.0 246 119 8 111   1 3     0   4   114 132 0   26 5 159     13 246
625509 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585000862 3361 Chinook Middle School   Regular School No Middle 06 08 2017   grade_7 117 8 44   2 31     6   29   120 117 0   11   6   115       12.0 237 117 8 44   2 31     6   29   120 117 0   11 6 115     12 237
628403 WA King   school 5307710 17001   Seattle School District No. 1 530771003271 5175 Hazel Wolf K-8   Regular School No Elementary KG 08 2017   grade_7 55 8 12   1 5     1   4   45 41 0   1   3   24       9.0 86 55 8 12   1 5     1   4   45 41 0   1 3 24     9 86
628820 WA King   school 5307710 17001   Seattle School District No. 1 530771001307 1579 Tops K-8 School   Alternative School No Elementary PK 08 2017   grade_7 29 8 2   1 10     0   3   26 27 0   2   1   14       5.0 53 29 8 2   1 10     0   3   26 27 0   2 1 14     5 53
2414058 WA Pierce   school 5300480 27403   Bethel School District 530048000595 4407 Frontier Middle School   Regular School No Middle 06 08 2019   grade_7 162 8 29   1 5     6   34   143 102 0   3   7   110       11.0 245 162 8 29   1 5     6   34   143 102 0   3 7 110     11 245
2414630 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108000178 3237 Central Kitsap Middle School   Regular School No Middle 06 08 2019   grade_7 152 8 38   0 11     0   36   115 130 0   6   1   82       13.0 245 152 8 38   0 11     0   36   115 130 0   6 1 82     13 245
2418519 WA Benton   school 5303930 3017   Kennewick School District 530393000750 4429 Horse Heaven Hills Middle School   Regular School No Middle 06 08 2019   grade_7 173 8 82   1 2     1   16   163 120 0   23   4   152       12.0 283 173 8 82   1 2     1   16   163 120 0   23 4 152     12 283
2419181 WA Snohomish   school 5304200 31004   Lake Stevens School District 530420001906 4139 North Lake Middle School   Regular School No Middle 06 07 2019   grade_7 250 8 45   3 6     1   33   181 165 0   5   6   101       46.0 346 250 8 45   3 6     1   33   181 165 0   5 6 101     46 346
2419351 WA King   school 5304230 17414   Lake Washington School District 530423000663 3590 Finn Hill Middle School   Regular School No Middle 06 08 2019   grade_7 126 8 25   0 19     0   30   112 96 0   12   2   42       16.0 208 126 8 25   0 19     0   30   112 96 0   12 2 42     16 208
2423503 WA Benton   school 5307320 3400   Richland School District 530732001250 2785 Chief Joseph Middle School   Regular School No Middle 06 08 2019   grade_7 153 8 54   1 2     1   12   121 110 0   19   6   136       1.0 231 153 8 54   1 2     1   12   121 110 0   19 6 136     1 231
2423937 WA King   school 5307710 17001   Seattle School District No. 1 530771001145 2209 Broadview-Thomson K-8 School   Regular School No Elementary PK 08 2019   grade_7 8 8 7   0 4     0   2   8 21 0   5   2   22       1.0 29 8 8 7   0 4     0   2   8 21 0   5 2 22     1 29
2424241 WA King   school 5307710 17001   Seattle School District No. 1 530771003426 5276 Louisa Boren STEM K-8   Regular School No Elementary PK 08 2019   grade_7 34 8 3   0 5     0   6   31 25 0   3   0   10       1.0 56 34 8 3   0 5     0   6   31 25 0   3 0 10     1 56
2424594 WA King   school 5307710 17001   Seattle School District No. 1 530771001264 3277 Whitman Middle School   Regular School No Middle 06 08 2019   grade_7 141 8 16   1 11     0   23   102 98 0   12   5   35       20.0 200 141 8 16   1 11     0   23   102 98 0   12 5 35     20 200

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