Data source: Big Local News · About: Big Local

4,566 rows where grade = "grade_7" and state = "WA" sorted by female_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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
2940738 WA Franklin   school 5306570 11001   Pasco School District 530657003735 5624 Ray Reynolds Middle School   Regular School No Middle 06 08 2021   grade_7 167 6 206   1 7     0   14   180 221 0   46   3   210       10.0 401 167 6 206   1 7     0   14   180 221 0   46 3 210     10 401
2585385 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001653 4040 West Valley Jr High   Regular School No Middle 07 08 2020   grade_7 229 7 165   8 13     0   16   218 219 1   29   4   235       7.0 438 229 7 165   8 13     0   16   218 219 1   29 4 235     7 438
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
627676 WA King   school 5307230 17403   Renton School District 530723001079 3035 McKnight Middle School   Regular School No Middle 06 08 2017   grade_7 152 14 108   1 130     0   20   211 214 0   35   9   189       23.0 425 152 14 108   1 130     0   20   211 214 0   35 9 189     23 425
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
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
622951 WA King   school 5303960 17415   Kent School District 530396002986 5016 Mill Creek Middle School   Regular School No Middle 07 08 2017   grade_7 67 67 150   1 66     22   46   206 213 0   91   15   331       12.0 419 67 67 150   1 66     22   46   206 213 0   91 15 331     12 419
2460581 WA Snohomish   school 5302400 31015   Edmonds School District 530240000329 3560 Alderwood Middle School   Regular School No Middle 07 08 2018   grade_7 157 20 128   4 66     5   32   199 213 0   64   10   224       28.0 412 157 20 128   4 66     5   32   199 213 0   64 10 224     28 412
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
463783 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270002878 4561 Shahala Middle School   Regular School No 2.0 06 08 2015   grade_7 222 16 58   0 74     1   25   185 211 0   18   6   123       8.0 396 222 16 58   0 74     1   25   185 211 0   18 6 123     8 396
465607 WA King   school 5303960 17415   Kent School District 530396002986 5016 Mill Creek Middle School   Regular School No 2.0 07 08 2015   grade_7 84 79 164   3 72     15   19   227 209 0   83   17   358       5.0 436 84 79 164   3 72     15   19   227 209 0   83 17 358     5 436
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
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
2575621 WA King   school 5303750 17411   Issaquah School District 530375000579 3636 Maywood Middle School   Regular School No Middle 06 08 2020   grade_7 229 7 39   1 90     1   36   196 207 0   15   4   53       40.0 403 229 7 39   1 90     1   36   196 207 0   15 4 53     40 403
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
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
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
2939921 WA King   school 5305910 17417   Northshore School District 530591000480 4371 Skyview Middle School   Regular School No Middle 06 08 2021   grade_7 154 10 53   0 158     0   27   197 205 0   22   0   55       36.0 402 154 10 53   0 158     0   27   197 205 0   22 0 55     36 402
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
2463834 WA King   school 5304230 17414   Lake Washington School District 530423002435 4386 Inglewood Middle School   Regular School No Middle 06 08 2018   grade_7 237 4 26   0 119     1   28   211 204 0   13   0   13       30.0 415 237 4 26   0 119     1   28   211 204 0   13 0 13     30 415
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
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
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
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
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
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
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
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
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
2934304 WA Snohomish   school 5302400 31015   Edmonds School District 530240000329 3560 Alderwood Middle School   Regular School No Middle 07 08 2021   grade_7 149 42 128   2 71     4   36   230 201 1   78   12   209       19.0 432 149 42 128   2 71     4   36   230 201 1   78 12 209     19 432
2936492 WA King   school 5303750 17411   Issaquah School District 530375000579 3636 Maywood Middle School   Regular School No Middle 06 08 2021   grade_7 194 6 41   1 105     0   48   194 201 0   15   5   53       33.0 395 194 6 41   1 105     0   48   194 201 0   15 5 53     33 395
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
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
2416081 WA Snohomish   school 5302400 31015   Edmonds School District 530240000329 3560 Alderwood Middle School   Regular School No Middle 07 08 2019   grade_7 158 21 91   1 69     5   50   195 200 0   43   11   180       30.0 395 158 21 91   1 69     5   50   195 200 0   43 11 180     30 395
2421737 WA Island   school 5305940 15201   Oak Harbor School District 530594000901 3939 North Whidbey Middle School   Regular School No Middle 07 08 2019   grade_7 237 20 65   3 24     3   56   208 200 0   20   6   179       24.0 408 237 20 65   3 24     3   56   208 200 0   20 6 179     24 408
530247 WA King   school 5307230 17403   Renton School District 530723001079 3035 McKnight Middle School   Regular School No 2 06 08 2016   grade_7 140 34 90   3 119     3   19   209 199 0   26   2   173       29.0 408 140 34 90   3 119     3   19   209 199 0   26 2 173     29 408
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
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
2419341 WA King   school 5304230 17414   Lake Washington School District 530423001841 4148 Evergreen Middle School   Regular School No Middle 06 08 2019   grade_7 172 11 28   0 153     0   25   191 198 0   6   0   24       27.0 389 172 11 28   0 153     0   25   191 198 0   6 0 24     27 389
2466197 WA Island   school 5305940 15201   Oak Harbor School District 530594000901 3939 North Whidbey Middle School   Regular School No Middle 07 08 2018   grade_7 210 13 82   2 34     4   48   197 196 0   25   15   181       22.0 393 210 13 82   2 34     4   48   197 196 0   25 15 181     22 393
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
2573615 WA Snohomish   school 5302400 31015   Edmonds School District 530240000351 3353 Meadowdale Middle School   Regular School No Middle 07 08 2020   grade_7 179 41 88   2 29     5   36   184 195 1   45   8   171       15.0 380 179 41 88   2 29     5   36   184 195 1   45 8 171     15 380
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
2573414 WA Snohomish   school 5302400 31015   Edmonds School District 530240000329 3560 Alderwood Middle School   Regular School No Middle 07 08 2020   grade_7 135 23 116   2 80     2   33   197 194 0   50   8   197       14.0 391 135 23 116   2 80     2   33   197 194 0   50 8 197     14 391
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
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
2946426 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001653 4040 West Valley Jr High   Regular School No Middle 07 08 2021   grade_7 219 7 173   3 11     0   20   238 194 1   33   4   217       15.0 433 219 7 173   3 11     0   20   238 194 1   33 4 217     15 433
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
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
2422352 WA Franklin   school 5306570 11001   Pasco School District 530657002936 4564 Ellen Ochoa Middle School   Regular School No Middle 07 08 2019   grade_7 26 4 340   0 3     0   5   185 193 0   211   10   359       2.0 378 26 4 340   0 3     0   5   185 193 0   211 10 359     2 378
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
2576184 WA King   school 5303960 17415   Kent School District 530396002986 5016 Mill Creek Middle School   Regular School No Middle 07 08 2020   grade_7 64 75 168   1 67     28   28   238 193 0   132   14   355       14.0 431 64 75 168   1 67     28   28   238 193 0   132 14 355     14 431
2937609 WA King   school 5304230 17414   Lake Washington School District 530423002435 4386 Inglewood Middle School   Regular School No Middle 06 08 2021   grade_7 195 5 22   1 160     1   33   224 193 0   7   0   11       37.0 417 195 5 22   1 160     1   33   224 193 0   7 0 11     37 417
462771 WA Snohomish   school 5302400 31015   Edmonds School District 530240000329 3560 Alderwood Middle School   Regular School No 2.0 07 08 2015   grade_7 133 25 85   1 79     5   32   168 192 0   32   7   188       21.0 360 133 25 85   1 79     5   32   168 192 0   32 7 188     21 360
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
2462767 WA King   school 5303750 17411   Issaquah School District 530375000579 3636 Maywood Middle School   Regular School No Middle 06 08 2018   grade_7 211 4 37   0 88     0   25   173 192 0   9   7   49       24.0 365 211 4 37   0 88     0   25   173 192 0   9 7 49     24 365
620140 WA Snohomish   school 5302400 31015   Edmonds School District 530240000329 3560 Alderwood Middle School   Regular School No Middle 07 08 2017   grade_7 155 24 95   2 82     6   32   205 191 0   36   7   185       27.0 396 155 24 95   2 82     6   32   205 191 0   36 7 185     27 396
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
2466828 WA Franklin   school 5306570 11001   Pasco School District 530657002936 4564 Ellen Ochoa Middle School   Regular School No Middle 07 08 2018   grade_7 15 3 339   0 0     0   4   170 191 0   195   12   343       4.0 361 15 3 339   0 0     0   4   170 191 0   195 12 343     4 361
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
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
2582229 WA King   school 5307920 17412   Shoreline School District 530792001297 3674 Albert Einstein Middle School   Regular School No Middle 07 08 2020   grade_7 185 30 48   0 62     5   54   194 190 0   19   7   104       26.0 384 185 30 48   0 62     5   54   194 190 0   19 7 104     26 384
2934867 WA Snohomish   school 5302670 31002   Everett School District 530267000397 3253 Evergreen Middle School   Regular School No Middle 06 08 2021   grade_7 155 24 103   1 36     5   27   161 190 0   42   17   210       11.0 351 155 24 103   1 36     5   27   161 190 0   42 17 210     11 351
2940009 WA Island   school 5305940 15201   Oak Harbor School District 530594000901 3939 North Whidbey Middle School   Regular School No Middle 07 08 2021   grade_7 228 14 82   0 22     5   56   217 190 0   12   10   153       14.0 407 228 14 82   0 22     5   56   217 190 0   12 10 153     14 407
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
622393 WA King   school 5303750 17411   Issaquah School District 530375000579 3636 Maywood Middle School   Regular School No Middle 06 08 2017   grade_7 218 6 46   0 84     0   27   192 189 0   13   2   65       20.0 381 218 6 46   0 84     0   27   192 189 0   13 2 65     20 381
631587 WA Clark   school 5309270 6037   Vancouver School District 530927001577 3146 Mcloughlin Middle School   Regular School No Middle 06 08 2017   grade_7 108 11 170   1 13     18   29   161 189 0   82   21   286       11.0 350 108 11 170   1 13     18   29   161 189 0   82 21 286     11 350
2419382 WA King   school 5304230 17414   Lake Washington School District 530423002435 4386 Inglewood Middle School   Regular School No Middle 06 08 2019   grade_7 229 7 28   0 101     0   32   208 189 0   7   0   13       40.0 397 229 7 28   0 101     0   32   208 189 0   7 0 13     40 397
2579698 WA Franklin   school 5306570 11001   Pasco School District 530657002936 4564 Ellen Ochoa Middle School   Regular School No Middle 07 08 2020   grade_7 16 6 359   0 2     0   5   199 189 0   160   3   364       4.0 388 16 6 359   0 2     0   5   199 189 0   160 3 364     4 388
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
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
2942413 WA King   school 5307710 17001   Seattle School District No. 1 530771001162 2729 Eckstein Middle School   Regular School No Middle 06 08 2021   grade_7 240 25 21   3 38     0   53   190 188 2   17   3   63       27.0 380 240 25 21   3 38     0   53   190 188 2   17 3 63     27 380
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
2416281 WA Snohomish   school 5302400 31015   Edmonds School District 530240000351 3353 Meadowdale Middle School   Regular School No Middle 07 08 2019   grade_7 177 30 88   0 41     5   42   196 187 0   51   14   189       13.0 383 177 30 88   0 41     5   42   196 187 0   51 14 189     13 383
2461538 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270002878 4561 Shahala Middle School   Regular School No Middle 06 08 2018   grade_7 203 12 69   0 57     3   32   189 187 0   23   8   123       17.0 376 203 12 69   0 57     3   32   189 187 0   23 8 123     17 376
2575636 WA King   school 5303750 17411   Issaquah School District 530375000580 3879 Pine Lake Middle School   Regular School No Middle 06 08 2020   grade_7 130 3 41   0 150     0   26   163 187 0   10   1   21       18.0 350 130 3 41   0 150     0   26   163 187 0   10 1 21     18 350
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
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
2581415 WA King   school 5307710 17001   Seattle School District No. 1 530771001162 2729 Eckstein Middle School   Regular School No Middle 06 08 2020   grade_7 241 25 36   2 19     1   52   190 186 0   13   3   53       19.0 376 241 25 36   2 19     1   52   190 186 0   13 3 53     19 376
2581700 WA King   school 5307710 17001   Seattle School District No. 1 530771001136 3095 Mercer International Middle School   Regular School No Middle 06 08 2020   grade_7 57 75 62   1 168     0   27   204 186 0   57   8   230       10.0 390 57 75 62   1 168     0   27   204 186 0   57 8 230     10 390
470316 WA King   school 5307230 17403   Renton School District 530723001079 3035 McKnight Middle School   Regular School No 2.0 06 08 2015   grade_7 121 22 93   1 116     5   19   192 185 0   24   11   165       16.0 377 121 22 93   1 116     5   19   192 185 0   24 11 165     16 377
525573 WA King   school 5303960 17415   Kent School District 530396002986 5016 Mill Creek Middle School   Regular School No 2 07 08 2016   grade_7 71 56 133   1 71     25   30   202 185 0   77   5   299       13.0 387 71 56 133   1 71     25   30   202 185 0   77 5 299     13 387
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
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

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