enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
2579759 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
2466891 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
2422409 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
2579698 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
2418840 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
2422352 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
465607 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
2576184 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
529191 529191 WA Franklin   school 5306570 11001   Pasco School District 530657002936 4564 Ellen Ochoa Middle School   Regular School No 2 06 08 2016   grade_7 13 4 341   0 1     0   1   197 163 0   152   2   348       3.0 360 13 4 341   0 1     0   1   197 163 0   152 2 348     3 360
2579814 2579814 WA Franklin   school 5306570 11001   Pasco School District 530657000973 3324 Stevens Middle School   Regular School No Middle 07 08 2020   grade_7 29 3 344   0 1     0   1   207 171 0   154   6   348       2.0 378 29 3 344   0 1     0   1   207 171 0   154 6 348     2 378
2422462 2422462 WA Franklin   school 5306570 11001   Pasco School District 530657000973 3324 Stevens Middle School   Regular School No Middle 07 08 2019   grade_7 46 4 314   0 3     0   3   211 159 0   192   23   344       3.0 370 46 4 314   0 3     0   3   211 159 0   192 23 344     3 370
2466828 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
529248 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
2466948 2466948 WA Franklin   school 5306570 11001   Pasco School District 530657000973 3324 Stevens Middle School   Regular School No Middle 07 08 2018   grade_7 29 4 330   0 1     0   3   184 183 0   197   12   340       7.0 367 29 4 330   0 1     0   3   184 183 0   197 12 340     7 367
626733 626733 WA Franklin   school 5306570 11001   Pasco School District 530657000973 3324 Stevens Middle School   Regular School No Middle 07 08 2017   grade_7 32 3 311   0 1     0   2   166 183 0   15   12   335       3.0 349 32 3 311   0 1     0   2   166 183 0   15 12 335     3 349
2940772 2940772 WA Franklin   school 5306570 11001   Pasco School District 530657000973 3324 Stevens Middle School   Regular School No Middle 06 08 2021   grade_7 12 1 331   0 1     2   3   177 173 0   159   9   335       5.0 350 12 1 331   0 1     2   3   177 173 0   159 9 335     5 350
622951 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
2940574 2940574 WA Adams   school 5306480 1147   Othello School District 530648000956 3471 McFarland Middle School   Regular School No Middle 06 08 2021   grade_7 32 1 361   0 2     0   2   219 179 0   128   2   327       13.0 398 32 1 361   0 2     0   2   219 179 0   128 2 327     13 398
626622 626622 WA Franklin   school 5306570 11001   Pasco School District 530657002936 4564 Ellen Ochoa Middle School   Regular School No Middle 07 08 2017   grade_7 6 2 318   0 1     0   5   153 179 0   6   6   325       3.0 332 6 2 318   0 1     0   5   153 179 0   6 6 325     3 332
529301 529301 WA Franklin   school 5306570 11001   Pasco School District 530657000973 3324 Stevens Middle School   Regular School No 2 07 08 2016   grade_7 18 4 310   0 1     0   3   169 167 0   129   8   322       8.0 336 18 4 310   0 1     0   3   169 167 0   129 8 322     8 336
2579611 2579611 WA Adams   school 5306480 1147   Othello School District 530648000956 3471 McFarland Middle School   Regular School No Middle 06 08 2020   grade_7 33 0 329   0 1     0   2   187 178 0   112   2   322       15.0 365 33 0 329   0 1     0   2   187 178 0   112 2 322     15 365
2937075 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
2940387 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
626681 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
469325 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
469282 469282 WA Franklin   school 5306570 11001   Pasco School District 530657002936 4564 Ellen Ochoa Middle School   Regular School No 2.0 06 08 2015   grade_7 15 4 290   0 1     0   7   162 155 0   142   12   309       2.0 317 15 4 290   0 1     0   7   162 155 0   142 12 309     2 317
2940662 2940662 WA Franklin   school 5306570 11001   Pasco School District 530657002936 4564 Ellen Ochoa Middle School   Regular School No Middle 06 08 2021   grade_7 15 1 311   0 3     0   2   158 174 0   134   3   309       3.0 332 15 1 311   0 3     0   2   158 174 0   134 3 309     3 332
2422268 2422268 WA Adams   school 5306480 1147   Othello School District 530648000956 3471 McFarland Middle School   Regular School No Middle 06 08 2019   grade_7 25 0 317   0 2     0   2   178 169 0   120   6   303       13.0 347 25 0 317   0 2     0   2   178 169 0   120 6 303     13 347
2427614 2427614 WA Yakima   school 5309480 39207   Wapato School District 530948001615 2131 Wapato Middle School   Regular School No Middle 06 08 2019   grade_7 7 0 227   73 7     0   10   163 161 0   159   8   303       4.0 324 7 0 227   73 7     0   10   163 161 0   159 8 303     4 324
2463306 2463306 WA King   school 5303960 17415   Kent School District 530396002986 5016 Mill Creek Middle School   Regular School No Middle 07 08 2018   grade_7 45 64 160   1 58     26   39   208 185 0   117   11   301       11.0 393 45 64 160   1 58     26   39   208 185 0   117 11 301     11 393
2579442 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
469374 469374 WA Franklin   school 5306570 11001   Pasco School District 530657000973 3324 Stevens Middle School   Regular School No 2.0 06 08 2015   grade_7 36 3 274   0 1     0   6   155 165 0   123   10   299       5.0 320 36 3 274   0 1     0   6   155 165 0   123 10 299     5 320
525573 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
2585787 2585787 WA Yakima   school 5310110 39007   Yakima School District 531011001708 2314 Washington Middle School   Regular School No Middle 06 08 2020   grade_7 14 0 297   3 0     0   0   147 167 0   113   13   296       6.0 314 14 0 297   3 0     0   0   147 167 0   113 13 296     6 314
2575232 2575232 WA King   school 5303540 17401   Highline School District 530354003674 5551 Glacier Middle School   Regular School No Middle 06 08 2020   grade_7 45 34 188   0 53     11   18   186 163 0   112   22   294       0.0 349 45 34 188   0 53     11   18   186 163 0   112 22 294     0 349
2584714 2584714 WA Clark   school 5309270 6037   Vancouver School District 530927001577 3146 Mcloughlin Middle School   Regular School No Middle 06 08 2020   grade_7 153 10 160   3 9     20   24   206 173 0   74   19   294       10.0 379 153 10 160   3 9     20   24   206 173 0   74 19 294     10 379
2466743 2466743 WA Adams   school 5306480 1147   Othello School District 530648000956 3471 McFarland Middle School   Regular School No Middle 06 08 2018   grade_7 31 0 294   0 0     0   1   170 169 0   117   8   292       8.0 339 31 0 294   0 0     0   1   170 169 0   117 8 292     8 339
2471383 2471383 WA Yakima   school 5308970 39202   Toppenish School District 530897001535 2264 Toppenish Middle School   Regular School No Middle 06 08 2018   grade_7 7 0 261   39 0     0   6   149 164 0   130   11   292       10.0 313 7 0 261   39 0     0   6   149 164 0   130 11 292     10 313
472732 472732 WA Spokane   school 5308250 32081   Spokane School District 530825001408 3257 Shaw Middle School   Regular School No 2.0 07 08 2015   grade_7 187 16 38   7 15     17   44   166 158 0   33   23   289       8.0 324 187 16 38   7 15     17   44   166 158 0   33 23 289     8 324
2426875 2426875 WA Yakima   school 5308970 39202   Toppenish School District 530897001535 2264 Toppenish Middle School   Regular School No Middle 06 08 2019   grade_7 3 1 253   44 0     0   7   165 143 0   140   5   288       10.0 308 3 1 253   44 0     0   7   165 143 0   140 5 288     10 308
631587 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
2425545 2425545 WA Spokane   school 5308250 32081   Spokane School District 530825001411 3758 Garry Middle School   Regular School No Middle 07 08 2019   grade_7 174 13 47   5 14     15   59   187 140 0   46   20   286       36.0 327 174 13 47   5 14     15   59   187 140 0   46 20 286     36 327
2574907 2574907 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294000479 3300 Morris Ford Middle School   Regular School No Middle 06 08 2020   grade_7 98 22 136   4 30     15   54   198 161 0   38   21   285       13.0 359 98 22 136   4 30     15   54   198 161 0   38 21 285     13 359
464657 464657 WA King   school 5303540 17401   Highline School District 530354000524 3098 Chinook Middle School   Regular School No 2.0 07 08 2015   grade_7 34 61 135   2 58     21   12   154 169 0   77   8   283       4.0 323 34 61 135   2 58     21   12   154 169 0   77 8 283     4 323
473850 473850 WA Yakima   school 5308970 39202   Toppenish School District 530897001535 2264 Toppenish Middle School   Regular School No 2.0 06 08 2015   grade_7 5 0 239   38 0     0   0   154 128 0   79   3   281       10.0 282 5 0 239   38 0     0   0   154 128 0   79 3 281     10 282
531217 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
2417867 2417867 WA King   school 5303540 17401   Highline School District 530354000524 3098 Chinook Middle School   Regular School No Middle 07 08 2019   grade_7 49 65 120   0 60     28   9   183 148 0   89   20   281       6.0 331 49 65 120   0 60     28   9   183 148 0   89 20 281     6 331
2584303 2584303 WA Yakima   school 5308970 39202   Toppenish School District 530897001535 2264 Toppenish Middle School   Regular School No Middle 06 08 2020   grade_7 9 0 244   36 0     0   3   137 155 0   108   14   278       10.0 292 9 0 244   36 0     0   3   137 155 0   108 14 278     10 292
2585691 2585691 WA Yakima   school 5310110 39007   Yakima School District 531011001691 2410 Franklin Middle School   Regular School No Middle 06 08 2020   grade_7 67 2 242   3 3     0   15   175 157 0   58   20   278       11.0 332 67 2 242   3 3     0   15   175 157 0   58 20 278     11 332
464646 464646 WA King   school 5303540 17401   Highline School District 530354000522 3163 Cascade Middle School   Regular School No 2.0 07 08 2015   grade_7 22 44 138   5 68     20   15   173 139 0   84   10   277       6.0 312 22 44 138   5 68     20   15   173 139 0   84 10 277     6 312
2417679 2417679 WA Yakima   school 5303150 39200   Grandview School District 530315000498 3071 Grandview Middle School   Regular School No Middle 06 08 2019   grade_7 21 0 288   0 0     0   0   159 150 0   84   3   277       2.0 309 21 0 288   0 0     0   0   159 150 0   84 3 277     2 309
475320 475320 WA Yakima   school 5310110 39007   Yakima School District 531011001698 3615 Lewis & Clark Middle School   Regular School No 2.0 06 08 2015   grade_7 42 1 239   2 0     1   5   147 143 0   91   8   273       5.0 290 42 1 239   2 0     1   5   147 143 0   91 8 273     5 290
2574221 2574221 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000415 3320 Covington Middle School   Regular School No Middle 06 08 2020   grade_7 184 16 118   2 10     11   35   203 172 1   54   24   273       8.0 376 184 16 118   2 10     11   35   203 172 1   54 24 273     8 376
2427286 2427286 WA Clark   school 5309270 6037   Vancouver School District 530927001577 3146 Mcloughlin Middle School   Regular School No Middle 06 08 2019   grade_7 105 11 160   2 10     23   24   172 163 0   90   15   272       8.0 335 105 11 160   2 10     23   24   172 163 0   90 15 272     8 335
2946072 2946072 WA Yakima   school 5309480 39207   Wapato School District 530948001615 2131 Wapato Middle School   Regular School No Middle 06 08 2021   grade_7 3 0 214   64 3     0   17   169 132 0   143   5   272       7.0 301 3 0 214   64 3     0   17   169 132 0   143 5 272     7 301
2582961 2582961 WA Spokane   school 5308250 32081   Spokane School District 530825001411 3758 Garry Middle School   Regular School No Middle 07 08 2020   grade_7 177 18 39   3 6     20   52   167 148 0   42   13   271       12.0 315 177 18 39   3 6     20   52   167 148 0   42 13 271     12 315
465339 465339 WA Benton   school 5303930 3017   Kennewick School District 530393000607 3472 Park Middle School   Regular School No 2.0 06 08 2015   grade_7 107 19 145   1 14     1   7   144 150 0   68   3   270       2.0 294 107 19 145   1 14     1   7   144 150 0   68 3 270     2 294
2945318 2945318 WA Yakima   school 5308970 39202   Toppenish School District 530897001535 2264 Toppenish Middle School   Regular School No Middle 06 08 2021   grade_7 3 1 260   36 2     0   4   155 151 0   93   2   270       12.0 306 3 1 260   36 2     0   4   155 151 0   93 2 270     12 306
524285 524285 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294000479 3300 Morris Ford Middle School   Regular School No 2 06 08 2016   grade_7 146 26 69   1 24     14   35   175 140 0   15   4   269       8.0 315 146 26 69   1 24     14   35   175 140 0   15 4 269     8 315
2945734 2945734 WA Clark   school 5309270 6037   Vancouver School District 530927001577 3146 Mcloughlin Middle School   Regular School No Middle 06 08 2021   grade_7 107 7 173   3 8     23   17   169 169 0   93   9   269       8.0 338 107 7 173   3 8     23   17   169 169 0   93 9 269     8 338
475288 475288 WA Yakima   school 5310110 39007   Yakima School District 531011001691 2410 Franklin Middle School   Regular School No 2.0 06 08 2015   grade_7 64 2 215   2 1     0   7   162 129 0   86   10   267       9.0 291 64 2 215   2 1     0   7   162 129 0   86 10 267     9 291
534256 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
2428351 2428351 WA Yakima   school 5310110 39007   Yakima School District 531011001708 2314 Washington Middle School   Regular School No Middle 06 08 2019   grade_7 14 2 265   3 0     0   3   149 138 0   129   13   266       8.0 287 14 2 265   3 0     0   3   149 138 0   129 13 266     8 287
2943943 2943943 WA Spokane   school 5308250 32081   Spokane School District 530825001411 3758 Garry Middle School   Regular School No Middle 07 08 2021   grade_7 173 12 41   5 8     7   61   171 136 0   36   13   266       8.0 307 173 12 41   5 8     7   61   171 136 0   36 13 266     8 307
534593 534593 WA Yakima   school 5309480 39207   Wapato School District 530948001615 2131 Wapato Middle School   Regular School No 2 06 08 2016   grade_7 12 0 188   67 2     0   7   146 130 0   62   12   265       0.0 276 12 0 188   67 2     0   7   146 130 0   62 12 265     0 276
2585723 2585723 WA Yakima   school 5310110 39007   Yakima School District 531011001698 3615 Lewis & Clark Middle School   Regular School No Middle 06 08 2020   grade_7 29 0 251   2 1     0   5   160 128 0   77   7   265       8.0 288 29 0 251   2 1     0   5   160 128 0   77 7 265     8 288
2471786 2471786 WA Clark   school 5309270 6037   Vancouver School District 530927001577 3146 Mcloughlin Middle School   Regular School No Middle 06 08 2018   grade_7 107 12 159   0 10     16   21   151 174 0   90   10   264       11.0 325 107 12 159   0 10     16   21   151 174 0   90 10 264     11 325
2936110 2936110 WA King   school 5303540 17401   Highline School District 530354003674 5551 Glacier Middle School   Regular School No Middle 06 08 2021   grade_7 41 32 164   2 47     14   22   158 164 0   105   22   264       0.0 322 41 32 164   2 47     14   22   158 164 0   105 22 264     0 322
533833 533833 WA Yakima   school 5308970 39202   Toppenish School District 530897001535 2264 Toppenish Middle School   Regular School No 2 06 08 2016   grade_7 4 0 255   43 0     0   3   169 136 0   107   14   263       6.0 305 4 0 255   43 0     0   3   169 136 0   107 14 263     6 305
2468819 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
2417571 2417571 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294000481 3401 Perry G Keithley Middle School   Regular School No Middle 06 08 2019   grade_7 90 43 97   1 7     16   50   158 146 0   22   15   262       10.0 304 90 43 97   1 7     16   50   158 146 0   22 15 262     10 304
2946756 2946756 WA Yakima   school 5310110 39007   Yakima School District 531011001698 3615 Lewis & Clark Middle School   Regular School No Middle 06 08 2021   grade_7 31 0 256   4 0     0   7   136 162 0   91   5   262       6.0 298 31 0 256   4 0     0   7   136 162 0   91 5 262     6 298
2946821 2946821 WA Yakima   school 5310110 39007   Yakima School District 531011001708 2314 Washington Middle School   Regular School No Middle 06 08 2021   grade_7 8 1 266   4 0     0   4   147 136 0   90   9   262       14.0 283 8 1 266   4 0     0   4   147 136 0   90 9 262     14 283
524776 524776 WA King   school 5303540 17401   Highline School District 530354000554 2927 Sylvester Middle School   Regular School No 2 07 08 2016   grade_7 69 29 141   4 75     11   19   177 171 0   71   20   260       10.0 348 69 29 141   4 75     11   19   177 171 0   71 20 260     10 348
626535 626535 WA Adams   school 5306480 1147   Othello School District 530648000956 3471 McFarland Middle School   Regular School No Middle 06 08 2017   grade_7 32 0 270   0 0     0   0   167 135 0   100   6   260       8.0 302 32 0 270   0 0     0   0   167 135 0   100 6 260     8 302
2575019 2575019 WA Yakima   school 5303150 39200   Grandview School District 530315000498 3071 Grandview Middle School   Regular School No Middle 06 08 2020   grade_7 18 1 288   0 0     0   1   149 159 0   70   12   260       7.0 308 18 1 288   0 0     0   1   149 159 0   70 12 260     7 308
2425763 2425763 WA Spokane   school 5308250 32081   Spokane School District 530825001408 3257 Shaw Middle School   Regular School No Middle 06 08 2019   grade_7 154 20 45   8 2     13   56   159 139 0   39   30   259       44.0 298 154 20 45   8 2     13   56   159 139 0   39 30 259     44 298
464327 464327 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294000479 3300 Morris Ford Middle School   Regular School No 2.0 06 08 2015   grade_7 121 28 99   1 27     3   31   164 146 0   20   4   258       11.0 310 121 28 99   1 27     3   31   164 146 0   20 4 258     11 310
630084 630084 WA Spokane   school 5308250 32081   Spokane School District 530825001408 3257 Shaw Middle School   Regular School No Middle 07 08 2017   grade_7 157 18 29   9 13     18   44   153 135 0   40   14   256       4.0 288 157 18 29   9 13     18   44   153 135 0   40 14 256     4 288
2472809 2472809 WA Yakima   school 5310110 39007   Yakima School District 531011001698 3615 Lewis & Clark Middle School   Regular School No Middle 06 08 2018   grade_7 25 0 247   3 1     0   3   138 141 0   96   5   256       8.0 279 25 0 247   3 1     0   3   138 141 0   96 5 256     8 279
474634 474634 WA Yakima   school 5309480 39207   Wapato School District 530948001615 2131 Wapato Middle School   Regular School No 2.0 06 08 2015   grade_7 9 0 171   62 6     1   10   131 128 0   66   4   255       4.0 259 9 0 171   62 6     1   10   131 128 0   66 4 255     4 259
525301 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
535325 535325 WA Yakima   school 5310110 39007   Yakima School District 531011001708 2314 Washington Middle School   Regular School No 2 06 08 2016   grade_7 12 2 243   1 1     0   1   132 128 0   115   14   255       4.0 260 12 2 243   1 1     0   1   132 128 0   115 14 255     4 260
630516 630516 WA Yakima   school 5308670 39201   Sunnyside School District 530867001451 3313 Harrison Middle School   Regular School No Middle 06 08 2017   grade_7 17 0 292   0 0     0   8   156 161 0   96   9   255       4.0 317 17 0 292   0 0     0   8   156 161 0   96 9 255     4 317
2462532 2462532 WA King   school 5303540 17401   Highline School District 530354000554 2927 Sylvester Middle School   Regular School No Middle 07 08 2018   grade_7 77 18 149   2 52     10   21   164 165 0   80   21   255       9.0 329 77 18 149   2 52     10   21   164 165 0   80 21 255     9 329
2417567 2417567 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294000479 3300 Morris Ford Middle School   Regular School No Middle 06 08 2019   grade_7 119 26 104   1 28     11   48   171 166 0   18   13   254       14.0 337 119 26 104   1 28     11   48   171 166 0   18 13 254     14 337
475383 475383 WA Yakima   school 5310110 39007   Yakima School District 531011001708 2314 Washington Middle School   Regular School No 2.0 06 08 2015   grade_7 8 0 246   0 0     0   6   121 139 0   121   5   251       7.0 260 8 0 246   0 0     0   6   121 139 0   121 5 251     7 260
622156 622156 WA King   school 5303540 17401   Highline School District 530354000554 2927 Sylvester Middle School   Regular School No Middle 07 08 2017   grade_7 87 29 136   7 52     13   22   183 163 0   78   13   251       2.0 346 87 29 136   7 52     13   22   183 163 0   78 13 251     2 346
622675 622675 WA Benton   school 5303930 3017   Kennewick School District 530393000607 3472 Park Middle School   Regular School No Middle 06 08 2017   grade_7 64 13 161   0 17     0   13   160 108 0   77   10   251       5.0 268 64 13 161   0 17     0   13   160 108 0   77 10 251     5 268
2472127 2472127 WA Yakima   school 5309480 39207   Wapato School District 530948001615 2131 Wapato Middle School   Regular School No Middle 06 08 2018   grade_7 7 0 185   60 4     0   8   154 110 0   145   22   251       1.0 264 7 0 185   60 4     0   8   154 110 0   145 22 251     1 264
529104 529104 WA Adams   school 5306480 1147   Othello School District 530648000956 3471 McFarland Middle School   Regular School No 2 06 08 2016   grade_7 36 1 268   0 3     0   0   181 127 0   82   4   250       8.0 308 36 1 268   0 3     0   0   181 127 0   82 4 250     8 308
621778 621778 WA Yakima   school 5303150 39200   Grandview School District 530315000498 3071 Grandview Middle School   Regular School No Middle 06 08 2017   grade_7 12 0 268   0 0     0   2   149 133 0   98   10   250       3.0 282 12 0 268   0 0     0   2   149 133 0   98 10 250     3 282
628594 628594 WA King   school 5307710 17001   Seattle School District No. 1 530771001136 3095 Mercer International Middle School   Regular School No Middle 06 08 2017   grade_7 37 76 67   1 153     1   19   183 171 0   42   27   250       6.0 354 37 76 67   1 153     1   19   183 171 0   42 27 250     6 354
632608 632608 WA Yakima   school 5310110 39007   Yakima School District 531011001698 3615 Lewis & Clark Middle School   Regular School No Middle 06 08 2017   grade_7 39 1 242   2 0     2   4   141 149 0   99   6   250       5.0 290 39 1 242   2 0     2   4   141 149 0   99 6 250     5 290
2472874 2472874 WA Yakima   school 5310110 39007   Yakima School District 531011001708 2314 Washington Middle School   Regular School No Middle 06 08 2018   grade_7 14 2 248   1 0     0   1   128 138 0   120   8   250       10.0 266 14 2 248   1 0     0   1   128 138 0   120 8 250     10 266
472516 472516 WA Spokane   school 5308250 32081   Spokane School District 530825001411 3758 Garry Middle School   Regular School No 2.0 07 08 2015   grade_7 171 12 49   10 7     10   44   152 151 0   14   12   249       14.0 303 171 12 49   10 7     10   44   152 151 0   14 12 249     14 303
2574911 2574911 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294000481 3401 Perry G Keithley Middle School   Regular School No Middle 06 08 2020   grade_7 86 31 87   2 13     31   44   153 141 0   22   12   249       10.0 294 86 31 87   2 13     31   44   153 141 0   22 12 249     10 294
621660 621660 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294000479 3300 Morris Ford Middle School   Regular School No Middle 06 08 2017   grade_7 134 18 80   2 24     7   39   157 147 0   21   8   248       16.0 304 134 18 80   2 24     7   39   157 147 0   21 8 248     16 304
464448 464448 WA Yakima   school 5303150 39200   Grandview School District 530315000498 3071 Grandview Middle School   Regular School No 2.0 06 08 2015   grade_7 14 0 261   0 0     0   1   131 145 0   86   10   247       0.0 276 14 0 261   0 0     0   1   131 145 0   86 10 247     0 276
471227 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

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