Data source: Big Local News · About: Big Local

4,566 rows where grade = "grade_7" and state = "WA" sorted by white_int 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
2940387 WA Okanogan   school 5306220 24019   Omak School District 530622003307 5196 Washington Virtual Academy Omak Middle School   Regular School No Middle 06 08 2021   grade_7 622 31 63   12 37     7   20   405 384 3   20   0   317       15.0 792 622 31 63   12 37     7   20   405 384 3   20 0 317     15 792
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
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
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
528928 WA Okanogan   school 5306220 24019   Omak School District 530622003307 5196 Washington Virtual Academy Omak Middle School   Regular School No 2 06 08 2016   grade_7 340 30 31   10 9     2   7   216 213 0   4   0   138       25.0 429 340 30 31   10 9     2   7   216 213 0   4 0 138     25 429
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
2577538 WA Spokane   school 5304920 32354   Mead School District 530492000747 3191 Mountainside Middle School   Regular School No Middle 07 08 2020   grade_7 333 4 28   3 8     6   19   195 206 0   8   17   132       8.0 401 333 4 28   3 8     6   19   195 206 0   8 17 132     8 401
469038 WA Okanogan   school 5306220 24019   Omak School District 530622003307 5196 Washington Virtual Academy Omak Middle School   Regular School No 2.0 06 08 2015   grade_7 329 23 27   4 22     3   5   218 195 0   2   0   104       30.0 413 329 23 27   4 22     3   5   218 195 0   2 0 104     30 413
2420209 WA Spokane   school 5304920 32354   Mead School District 530492000748 3851 Northwood Middle School   Regular School No Middle 06 08 2019   grade_7 328 4 25   0 6     3   37   213 190 0   1   12   127       12.0 403 328 4 25   0 6     3   37   213 190 0   1 12 127     12 403
526972 WA Spokane   school 5304920 32354   Mead School District 530492000747 3191 Mountainside Middle School   Regular School No 2 07 08 2016   grade_7 327 6 22   4 5     11   18   200 193 0   13   8   132       7.0 393 327 6 22   4 5     11   18   200 193 0   13 8 132     7 393
2422099 WA Okanogan   school 5306220 24019   Omak School District 530622003307 5196 Washington Virtual Academy Omak Middle School   Regular School No Middle 06 08 2019   grade_7 326 33 56   7 20     5   2   222 226 1   15   0   225       51.0 449 326 33 56   7 20     5   2   222 226 1   15 0 225     51 449
627803 WA Benton   school 5307320 3400   Richland School District 530732002504 3926 Enterprise Middle School   Regular School No Middle 06 08 2017   grade_7 323 1 59   4 19     0   5   190 221 0   6   6   106       2.0 411 323 1 59   4 19     0   5   190 221 0   6 6 106     2 411
2582397 WA Snohomish   school 5308020 31201   Snohomish School District 530802000540 4395 Centennial Middle School   Regular School No Middle 07 08 2020   grade_7 323 1 50   0 8     1   31   242 172 0   15   3   114       25.0 414 323 1 50   0 8     1   31   242 172 0   15 3 114     25 414
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
2469513 WA Snohomish   school 5308020 31201   Snohomish School District 530802000540 4395 Centennial Middle School   Regular School No Middle 07 08 2018   grade_7 318 0 48   1 8     1   29   206 199 0   14   5   105       36.0 405 318 0 48   1 8     1   29   206 199 0   14 5 105     36 405
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
2420200 WA Spokane   school 5304920 32354   Mead School District 530492000747 3191 Mountainside Middle School   Regular School No Middle 07 08 2019   grade_7 317 3 27   1 2     10   36   193 203 0   3   6   140       4.0 396 317 3 27   1 2     10   36   193 203 0   3 6 140     4 396
2425746 WA Spokane   school 5308250 32081   Spokane School District 530825001405 3356 Sacajawea Middle School   Regular School No Middle 07 08 2019   grade_7 315 12 31   3 8     3   40   205 207 0   13   9   150       24.0 412 315 12 31   3 8     3   40   205 207 0   13 9 150     24 412
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
531947 WA Snohomish   school 5308020 31201   Snohomish School District 530802000540 4395 Centennial Middle School   Regular School No 2 07 08 2016   grade_7 311 2 41   4 8     0   13   193 186 0   7   2   104       26.0 379 311 2 41   4 8     0   13   193 186 0   7 2 104     26 379
2422409 WA Franklin   school 5306570 11001   Pasco School District 530657000967 2267 Mcloughlin Middle School   Regular School No Middle 07 08 2019   grade_7 311 5 313   2 11     2   34   338 340 0   73   6   365       23.0 678 311 5 313   2 11     2   34   338 340 0   73 6 365     23 678
2583158 WA Spokane   school 5308250 32081   Spokane School District 530825001405 3356 Sacajawea Middle School   Regular School No Middle 07 08 2020   grade_7 310 16 33   3 14     2   53   237 194 1   9   5   150       21.0 432 310 16 33   3 14     2   53   237 194 1   9 5 150     21 432
629296 WA Snohomish   school 5308020 31201   Snohomish School District 530802000540 4395 Centennial Middle School   Regular School No Middle 07 08 2017   grade_7 309 1 44   1 9     0   15   186 193 0   7   4   105       30.0 379 309 1 44   1 9     0   15   186 193 0   7 4 105     30 379
2425000 WA Snohomish   school 5308020 31201   Snohomish School District 530802000540 4395 Centennial Middle School   Regular School No Middle 07 08 2019   grade_7 308 2 55   2 6     0   32   220 185 0   14   0   100       35.0 405 308 2 55   2 6     0   32   220 185 0   14 0 100     35 405
467033 WA Spokane   school 5304920 32354   Mead School District 530492000747 3191 Mountainside Middle School   Regular School No 2.0 07 08 2015   grade_7 307 3 12   2 3     5   19   174 177 0   7   11   121       8.0 351 307 3 12   2 3     5   19   174 177 0   7 11 121     8 351
467042 WA Spokane   school 5304920 32354   Mead School District 530492000748 3851 Northwood Middle School   Regular School No 2.0 07 08 2015   grade_7 305 5 23   3 7     0   33   208 168 0   1   10   127       6.0 376 305 5 23   3 7     0   33   208 168 0   1 10 127     6 376
532055 WA Snohomish   school 5308020 31201   Snohomish School District 530802001790 4145 Valley View Middle School   Regular School No 2 07 09 2016   grade_7 305 5 44   1 34     1   18   207 201 0   6   2   51       30.0 408 305 5 44   1 34     1   18   207 201 0   6 2 51     30 408
472717 WA Spokane   school 5308250 32081   Spokane School District 530825001405 3356 Sacajawea Middle School   Regular School No 2.0 07 08 2015   grade_7 304 13 20   4 11     2   47   201 200 0   11   10   159       14.0 401 304 13 20   4 11     2   47   201 200 0   11 10 159     14 401
2466891 WA Franklin   school 5306570 11001   Pasco School District 530657000967 2267 Mcloughlin Middle School   Regular School No Middle 07 08 2018   grade_7 301 5 322   3 10     3   27   352 319 0   87   8   379       8.0 671 301 5 322   3 10     3   27   352 319 0   87 8 379     8 671
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
2464662 WA Spokane   school 5304920 32354   Mead School District 530492000747 3191 Mountainside Middle School   Regular School No Middle 07 08 2018   grade_7 297 3 16   2 3     13   20   166 188 0   12   21   140       6.0 354 297 3 16   2 3     13   20   166 188 0   12 21 140     6 354
2944140 WA Spokane   school 5308250 32081   Spokane School District 530825001405 3356 Sacajawea Middle School   Regular School No Middle 07 08 2021   grade_7 297 14 42   2 8     2   62   222 205 0   15   9   145       16.0 427 297 14 42   2 8     2   62   222 205 0   15 9 145     16 427
471952 WA Snohomish   school 5308020 31201   Snohomish School District 530802000540 4395 Centennial Middle School   Regular School No 2.0 07 08 2015   grade_7 295 4 34   7 2     1   19   192 170 0   8   7   131       11.0 362 295 4 34   7 2     1   19   192 170 0   8 7 131     11 362
624366 WA Spokane   school 5304920 32354   Mead School District 530492000748 3851 Northwood Middle School   Regular School No Middle 07 08 2017   grade_7 295 7 29   2 4     1   35   194 179 0   2   12   120       10.0 373 295 7 29   2 4     1   35   194 179 0   2 12 120     10 373
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
2584129 WA King   school 5308760 17409   Tahoma School District 530876002979 3341 Summit Trail Middle School   Regular School No Middle 06 08 2020   grade_7 293 8 37   3 19     2   44   210 195 1   5   1   49       43.0 406 293 8 37   3 19     2   44   210 195 1   5 1 49     43 406
2463656 WA Snohomish   school 5304200 31004   Lake Stevens School District 530420001906 4139 North Lake Middle School   Regular School No Middle 06 07 2018   grade_7 292 4 49   2 22     0   32   210 191 0   12   6   115       42.0 401 292 4 49   2 22     0   32   210 191 0   12 6 115     42 401
532725 WA Spokane   school 5308250 32081   Spokane School District 530825001405 3356 Sacajawea Middle School   Regular School No 2 07 08 2016   grade_7 288 14 27   1 12     3   45   185 205 0   13   11   123       17.0 390 288 14 27   1 12     3   45   185 205 0   13 11 123     17 390
2937419 WA Snohomish   school 5304200 31004   Lake Stevens School District 530420001906 4139 North Lake Middle School   Regular School No Middle 06 07 2021   grade_7 287 13 66   2 12     0   35   213 202 0   16   2   129       33.0 415 287 13 66   2 12     0   35   213 202 0   16 2 129     33 415
534938 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001653 4040 West Valley Jr High   Regular School No 2 07 08 2016   grade_7 284 4 128   5 10     1   6   209 229 0   20   1   206       11.0 438 284 4 128   5 10     1   6   209 229 0   20 1 206     11 438
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
2470266 WA Spokane   school 5308250 32081   Spokane School District 530825001405 3356 Sacajawea Middle School   Regular School No Middle 07 08 2018   grade_7 283 15 28   1 11     3   51   199 193 0   23   7   152       41.0 392 283 15 28   1 11     3   51   199 193 0   23 7 152     41 392
472057 WA Snohomish   school 5308020 31201   Snohomish School District 530802001790 4145 Valley View Middle School   Regular School No 2.0 07 08 2015   grade_7 282 6 34   1 21     1   23   191 177 0   6   0   60       19.0 368 282 6 34   1 21     1   23   191 177 0   6 0 60     19 368
630066 WA Spokane   school 5308250 32081   Spokane School District 530825001405 3356 Sacajawea Middle School   Regular School No Middle 07 08 2017   grade_7 279 23 39   3 9     4   40   198 199 0   26   4   154       17.0 397 279 23 39   3 9     4   40   198 199 0   26 4 154     17 397
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
629406 WA Snohomish   school 5308020 31201   Snohomish School District 530802001790 4145 Valley View Middle School   Regular School No Middle 07 08 2017   grade_7 277 2 39   0 22     2   21   195 168 0   13   3   62       17.0 363 277 2 39   0 22     2   21   195 168 0   13 3 62     17 363
2943396 WA Snohomish   school 5308020 31201   Snohomish School District 530802000540 4395 Centennial Middle School   Regular School No Middle 07 08 2021   grade_7 277 1 61   4 8     2   22   197 176 2   18   4   95       21.0 375 277 1 61   4 8     2   22   197 176 2   18 4 95     21 375
2471231 WA King   school 5308760 17409   Tahoma School District 530876002979 3341 Summit Trail Middle School   Regular School No Middle 06 08 2018   grade_7 276 7 26   0 13     0   21   171 172 0   6   1   34       27.0 343 276 7 26   0 13     0   21   171 172 0   6 1 34     27 343
2427954 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001653 4040 West Valley Jr High   Regular School No Middle 07 08 2019   grade_7 275 1 138   2 16     3   17   222 230 0   24   1   211       14.0 452 275 1 138   2 16     3   17   222 230 0   24 1 211     14 452
472459 WA Spokane   school 5308250 32081   Spokane School District 530825001732 4457 Chase Middle School   Regular School No 2.0 07 08 2015   grade_7 272 10 37   4 19     1   24   206 161 0   15   6   204       15.0 367 272 10 37   4 19     1   24   206 161 0   15 6 204     15 367
470435 WA Benton   school 5307320 3400   Richland School District 530732002504 3926 Enterprise Middle School   Regular School No 2.0 06 08 2015   grade_7 271 5 36   2 14     0   11   157 182 0   6   5   73       0.0 339 271 5 36   2 14     0   11   157 182 0   6 5 73     0 339
2425494 WA Spokane   school 5308250 32081   Spokane School District 530825001732 4457 Chase Middle School   Regular School No Middle 07 08 2019   grade_7 271 10 46   5 19     3   59   212 201 0   22   11   235       100.0 413 271 10 46   5 19     3   59   212 201 0   22 11 235     100 413
474993 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001653 4040 West Valley Jr High   Regular School No 2.0 07 09 2015   grade_7 270 4 118   5 5     1   11   225 189 0   30   0   189       9.0 414 270 4 118   5 5     1   11   225 189 0   30 0 189     9 414
525222 WA Benton   school 5303930 3017   Kennewick School District 530393000598 4028 Desert Hills Middle School   Regular School No 2 06 08 2016   grade_7 270 4 45   1 7     0   13   174 166 0   3   1   91       21.0 340 270 4 45   1 7     0   13   174 166 0   3 1 91     21 340
527046 WA King   school 5304980 17400   Mercer Island School District 530498000764 3219 Islander Middle School   Regular School No 2 06 08 2016   grade_7 270 4 7   0 65     1   23   206 164 0   4   0   9       54.0 370 270 4 7   0 65     1   23   206 164 0   4 0 9     54 370
2469616 WA Snohomish   school 5308020 31201   Snohomish School District 530802001790 4145 Valley View Middle School   Regular School No Middle 07 08 2018   grade_7 270 7 39   3 29     2   21   194 177 0   7   0   59       23.0 371 270 7 39   3 29     2   21   194 177 0   7 0 59     23 371
525922 WA Snohomish   school 5304200 31004   Lake Stevens School District 530420001906 4139 North Lake Middle School   Regular School No 2 06 07 2016   grade_7 269 3 35   3 11     0   26   175 172 0   2   4   100       18.0 347 269 3 35   3 11     0   26   175 172 0   2 4 100     18 347
623310 WA Snohomish   school 5304200 31004   Lake Stevens School District 530420001906 4139 North Lake Middle School   Regular School No Middle 06 07 2017   grade_7 269 5 42   2 15     0   37   182 188 0   13   10   107       19.0 370 269 5 42   2 15     0   37   182 188 0   13 10 107     19 370
624433 WA King   school 5304980 17400   Mercer Island School District 530498000764 3219 Islander Middle School   Regular School No Middle 06 08 2017   grade_7 269 7 12   0 71     3   37   216 183 0   4   0   15       46.0 399 269 7 12   0 71     3   37   216 183 0   4 0 15     46 399
530988 WA King   school 5307710 17001   Seattle School District No. 1 530771001180 2371 Hamilton International Middle School   Regular School No 2 06 08 2016   grade_7 264 10 19   1 33     0   30   200 157 0   5   3   29       18.0 357 264 10 19   1 33     0   30   200 157 0   5 3 29     18 357
472721 WA Spokane   school 5308250 32081   Spokane School District 530825001406 3413 Salk Middle School   Regular School No 2.0 07 08 2015   grade_7 263 4 26   4 3     1   22   174 149 0   2   6   168       11.0 323 263 4 26   4 3     1   22   174 149 0   2 6 168     11 323
469325 WA Franklin   school 5306570 11001   Pasco School District 530657000967 2267 Mcloughlin Middle School   Regular School No 2.0 06 08 2015   grade_7 260 13 258   1 11     0   24   304 263 0   57   8   310       7.0 567 260 13 258   1 11     0   24   304 263 0   57 8 310     7 567
532471 WA Spokane   school 5308250 32081   Spokane School District 530825001732 4457 Chase Middle School   Regular School No 2 07 08 2016   grade_7 260 7 35   4 15     2   41   185 179 0   14   10   203       10.0 364 260 7 35   4 15     2   41   185 179 0   14 10 203     10 364
623493 WA King   school 5304230 17414   Lake Washington School District 530423002435 4386 Inglewood Middle School   Regular School No Middle 06 08 2017   grade_7 260 4 20   1 90     0   23   190 208 0   7   0   16       22.0 398 260 4 20   1 90     0   23   190 208 0   7 0 16     22 398
632278 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001653 4040 West Valley Jr High   Regular School No Middle 07 08 2017   grade_7 260 3 116   8 8     0   12   221 186 0   24   4   197       18.0 407 260 3 116   8 8     0   12   221 186 0   24 4 197     18 407
626681 WA Franklin   school 5306570 11001   Pasco School District 530657000967 2267 Mcloughlin Middle School   Regular School No Middle 07 08 2017   grade_7 257 12 287   1 13     4   35   291 318 0   5   4   311       13.0 609 257 12 287   1 13     4   35   291 318 0   5 4 311     13 609
2472474 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001653 4040 West Valley Jr High   Regular School No Middle 07 08 2018   grade_7 257 1 124   4 13     1   14   210 204 0   21   4   179       18.0 414 257 1 124   4 13     1   14   210 204 0   21 4 179     18 414
533682 WA King   school 5308760 17409   Tahoma School District 530876002979 3341 Summit Trail Middle School   Regular School No 2 06 08 2016   grade_7 256 2 28   1 10     2   26   156 169 0   2   1   49       22.0 325 256 2 28   1 10     2   26   156 169 0   2 1 49     22 325
2583165 WA Spokane   school 5308250 32081   Spokane School District 530825001406 3413 Salk Middle School   Regular School No Middle 06 08 2020   grade_7 255 10 38   4 1     1   51   180 180 0   9   13   205       15.0 360 255 10 38   4 1     1   51   180 180 0   9 13 205     15 360
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
526113 WA King   school 5304230 17414   Lake Washington School District 530423002435 4386 Inglewood Middle School   Regular School No 2 06 08 2016   grade_7 253 4 27   0 88     0   29   214 187 0   3   1   18       4.0 401 253 4 27   0 88     0   29   214 187 0   3 1 18     4 401
530365 WA Benton   school 5307320 3400   Richland School District 530732001091 2721 Carmichael Middle School   Regular School No 2 06 08 2016   grade_7 253 6 48   4 13     1   12   183 154 0   10   2   129       0.0 337 253 6 48   4 13     1   12   183 154 0   10 2 129     0 337
532730 WA Spokane   school 5308250 32081   Spokane School District 530825001406 3413 Salk Middle School   Regular School No 2 06 08 2016   grade_7 253 2 34   5 1     2   41   165 173 0   3   10   177       15.0 338 253 2 34   5 1     2   41   165 173 0   3 10 177     15 338
2464735 WA King   school 5304980 17400   Mercer Island School District 530498000764 3219 Islander Middle School   Regular School No Middle 06 08 2018   grade_7 253 4 9   0 72     1   28   192 175 0   7   0   13       66.0 367 253 4 9   0 72     1   28   192 175 0   7 0 13     66 367
533661 WA King   school 5308760 17409   Tahoma School District 530876001515 3937 Maple View Middle School   Regular School No 2 06 07 2016   grade_7 252 3 44   2 25     3   29   179 179 0   4   1   65       28.0 358 252 3 44   2 25     3   29   179 179 0   4 1 65     28 358
629488 WA King   school 5308040 17410   Snoqualmie Valley School District 530804003252 5135 Twin Falls Middle School   Regular School No Middle 06 08 2017   grade_7 252 1 19   0 9     1   11   145 148 0   7   2   31       22.0 293 252 1 19   0 9     1   11   145 148 0   7 2 31     22 293
466153 WA King   school 5304230 17414   Lake Washington School District 530423002435 4386 Inglewood Middle School   Regular School No 2.0 06 09 2015   grade_7 251 1 26   2 70     0   22   205 167 0   2   0   11       17.0 372 251 1 26   2 70     0   22   205 167 0   2 0 11     17 372
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
2582906 WA Spokane   school 5308250 32081   Spokane School District 530825001732 4457 Chase Middle School   Regular School No Middle 07 08 2020   grade_7 250 16 44   1 11     1   57   189 191 0   14   12   210       16.0 380 250 16 44   1 11     1   57   189 191 0   14 12 210     16 380
2944150 WA Spokane   school 5308250 32081   Spokane School District 530825001406 3413 Salk Middle School   Regular School No Middle 06 08 2021   grade_7 250 4 42   1 2     0   49   179 169 0   2   7   200       13.0 348 250 4 42   1 2     0   49   179 169 0   2 7 200     13 348
630997 WA King   school 5308760 17409   Tahoma School District 530876001515 3937 Maple View Middle School   Regular School No Middle 06 07 2017   grade_7 249 4 33   0 17     6   27   175 161 0   6   3   55       27.0 336 249 4 33   0 17     6   27   175 161 0   6 3 55     27 336
2424620 WA Skagit   school 5307740 29101   Sedro-Woolley School District 530774001273 3181 Cascade Middle School   Regular School No Middle 07 08 2019   grade_7 249 1 83   8 0     2   15   192 166 0   27   12   195       41.0 358 249 1 83   8 0     2   15   192 166 0   27 12 195     41 358
465262 WA Benton   school 5303930 3017   Kennewick School District 530393000598 4028 Desert Hills Middle School   Regular School No 4.0 06 10 2015   grade_7 248 4 54   5 8     0   7   181 145 0   5   1   101       1.0 326 248 4 54   5 8     0   7   181 145 0   5 1 101     1 326
467107 WA King   school 5304980 17400   Mercer Island School District 530498000764 3219 Islander Middle School   Regular School No 2.0 06 08 2015   grade_7 248 1 20   1 67     0   23   189 171 0   7   0   17       43.0 360 248 1 20   1 67     0   23   189 171 0   7 0 17     43 360
2469136 WA Skagit   school 5307740 29101   Sedro-Woolley School District 530774001273 3181 Cascade Middle School   Regular School No Middle 07 08 2018   grade_7 247 2 73   5 3     1   11   170 172 0   16   12   182       30.0 342 247 2 73   5 3     1   11   170 172 0   16 12 182     30 342
2576733 WA King   school 5304230 17414   Lake Washington School District 530423002435 4386 Inglewood Middle School   Regular School No Middle 06 08 2020   grade_7 247 6 23   0 140     2   26   229 215 0   7   1   20       44.0 444 247 6 23   0 140     2   26   229 215 0   7 1 20     44 444
2428022 WA Pierce   school 5309780 27416   White River School District 530978003005 3458 Glacier Middle School   Regular School No Middle 06 08 2019   grade_7 246 3 34   2 4     0   16   163 142 0   17   2   99       13.0 305 246 3 34   2 4     0   16   163 142 0   17 2 99     13 305
2579082 WA Island   school 5305940 15201   Oak Harbor School District 530594000901 3939 North Whidbey Middle School   Regular School No Middle 07 08 2020   grade_7 246 18 80   1 21     3   58   214 213 0   23   14   188       26.0 427 246 18 80   1 21     3   58   214 213 0   23 14 188     26 427
2585451 WA Pierce   school 5309780 27416   White River School District 530978003005 3458 Glacier Middle School   Regular School No Middle 06 08 2020   grade_7 246 2 22   4 2     0   15   158 133 0   10   6   102       18.0 291 246 2 22   4 2     0   15   158 133 0   10 6 102     18 291
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
2945141 WA King   school 5308760 17409   Tahoma School District 530876002979 3341 Summit Trail Middle School   Regular School No Middle 06 08 2021   grade_7 245 12 33   1 27     1   42   194 166 1   4   3   41       24.0 361 245 12 33   1 27     1   42   194 166 1   4 3 41     24 361
465963 WA Snohomish   school 5304200 31004   Lake Stevens School District 530420001906 4139 North Lake Middle School   Regular School No 2.0 06 08 2015   grade_7 244 3 36   1 9     5   18   172 144 0   7   3   98       16.0 316 244 3 36   1 9     5   18   172 144 0   7 3 98     16 316
617496 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002452 4505 Woodward Middle School   Regular School No Middle 07 08 2017   grade_7 243 3 26   2 8     1   20   139 164 0   4   3   33       21.0 303 243 3 26   2 8     1   20   139 164 0   4 3 33     21 303
2425752 WA Spokane   school 5308250 32081   Spokane School District 530825001406 3413 Salk Middle School   Regular School No Middle 06 08 2019   grade_7 243 7 36   1 3     4   46   155 185 0   4   11   188       99.0 340 243 7 36   1 3     4   46   155 185 0   4 11 188     99 340
2459015 WA Clark   school 5300810 6117   Camas School District 530081002512 4508 Skyridge Middle School   Regular School No Middle 06 08 2018   grade_7 242 2 19   0 34     1   32   157 173 0   10   2   40       28.0 330 242 2 19   0 34     1   32   157 173 0   10 2 40     28 330
2470272 WA Spokane   school 5308250 32081   Spokane School District 530825001406 3413 Salk Middle School   Regular School No Middle 06 08 2018   grade_7 242 0 26   4 5     2   48   175 152 0   4   3   176       30.0 327 242 0 26   4 5     2   48   175 152 0   4 3 176     30 327
2575829 WA Benton   school 5303930 3017   Kennewick School District 530393000598 4028 Desert Hills Middle School   Regular School No Middle 06 08 2020   grade_7 242 7 39   1 9     0   12   162 148 0   1   0   76       16.0 310 242 7 39   1 9     0   12   162 148 0   1 0 76     16 310
461186 WA Clark   school 5300810 6117   Camas School District 530081002512 4508 Skyridge Middle School   Regular School No 2.0 06 08 2015   grade_7 241 3 19   3 20     1   32   149 170 0   3   1   38       12.0 319 241 3 19   3 20     1   32   149 170 0   3 1 38     12 319
473696 WA King   school 5308760 17409   Tahoma School District 530876002979 3341 Summit Trail Middle School   Regular School No 2.0 06 07 2015   grade_7 241 2 27   0 9     1   23   135 168 0   4   4   45       25.0 303 241 2 27   0 9     1   23   135 168 0   4 4 45     25 303
529248 WA Franklin   school 5306570 11001   Pasco School District 530657000967 2267 Mcloughlin Middle School   Regular School No 2 07 08 2016   grade_7 241 10 318   2 17     1   33   313 309 0   77   9   342       10.0 622 241 10 318   2 17     1   33   313 309 0   77 9 342     10 622

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