Data source: Big Local News · About: Big Local

5,735 rows where grade = "grade_6" and state = "WA" sorted by low_income_int descending

View and edit SQL

year

grade

  • grade_6 · 5,735
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
469324 WA Franklin   school 5306570 11001   Pasco School District 530657000967 2267 Mcloughlin Middle School   Regular School No 2.0 06 08 2015   grade_6 261 12 300   2 17     1   27   314 306 0   80   7   352       8.0 620 261 12 300   2 17     1   27   314 306 0   80 7 352     8 620
469281 WA Franklin   school 5306570 11001   Pasco School District 530657002936 4564 Ellen Ochoa Middle School   Regular School No 2.0 06 08 2015   grade_6 15 4 337   0 1     0   1   189 169 0   192   16   348       4.0 358 15 4 337   0 1     0   1   189 169 0   192 16 348     4 358
2940771 WA Franklin   school 5306570 11001   Pasco School District 530657000973 3324 Stevens Middle School   Regular School No Middle 06 08 2021   grade_6 10 1 361   1 1     1   1   187 189 0   198   9   348       2.0 376 10 1 361   1 1     1   1   187 189 0   198 9 348     2 376
473849 WA Yakima   school 5308970 39202   Toppenish School District 530897001535 2264 Toppenish Middle School   Regular School No 2.0 06 08 2015   grade_6 4 0 255   50 0     0   2   174 137 0   114   6   310       8.0 311 4 0 255   50 0     0   2   174 137 0   114 6 310     8 311
469373 WA Franklin   school 5306570 11001   Pasco School District 530657000973 3324 Stevens Middle School   Regular School No 2.0 06 08 2015   grade_6 15 4 303   0 1     1   4   171 157 0   151   11   308       9.0 328 15 4 303   0 1     1   4   171 157 0   151 11 308     9 328
2427285 WA Clark   school 5309270 6037   Vancouver School District 530927001577 3146 Mcloughlin Middle School   Regular School No Middle 06 08 2019   grade_6 143 8 164   4 7     18   24   193 175 0   81   20   304       9.0 368 143 8 164   4 7     18   24   193 175 0   81 20 304     9 368
2466742 WA Adams   school 5306480 1147   Othello School District 530648000956 3471 McFarland Middle School   Regular School No Middle 06 08 2018   grade_6 26 0 307   0 1     0   2   177 174 0   121   1   303       13.0 351 26 0 307   0 1     0   2   177 174 0   121 1 303     13 351
2945317 WA Yakima   school 5308970 39202   Toppenish School District 530897001535 2264 Toppenish Middle School   Regular School No Middle 06 08 2021   grade_6 5 1 275   44 0     0   4   157 172 0   101   3   302       9.0 329 5 1 275   44 0     0   4   157 172 0   101 3 302     9 329
2428350 WA Yakima   school 5310110 39007   Yakima School District 531011001708 2314 Washington Middle School   Regular School No Middle 06 08 2019   grade_6 15 0 297   3 0     0   0   143 172 0   125   7   300       11.0 315 15 0 297   3 0     0   0   143 172 0   125 7 300     11 315
2940386 WA Okanogan   school 5306220 24019   Omak School District 530622003307 5196 Washington Virtual Academy Omak Middle School   Regular School No Middle 06 08 2021   grade_6 554 42 59   6 28     4   23   372 338 6   12   2   300       8.0 716 554 42 59   6 28     4   23   372 338 6   12 2 300     8 716
2471785 WA Clark   school 5309270 6037   Vancouver School District 530927001577 3146 Mcloughlin Middle School   Regular School No Middle 06 08 2018   grade_6 117 7 158   2 11     26   24   183 162 0   96   12   295       8.0 345 117 7 158   2 11     26   24   183 162 0   96 12 295     8 345
2584713 WA Clark   school 5309270 6037   Vancouver School District 530927001577 3146 Mcloughlin Middle School   Regular School No Middle 06 08 2020   grade_6 118 3 181   4 7     19   23   175 180 0   95   14   295       11.0 355 118 3 181   4 7     19   23   175 180 0   95 14 295     11 355
2471382 WA Yakima   school 5308970 39202   Toppenish School District 530897001535 2264 Toppenish Middle School   Regular School No Middle 06 08 2018   grade_6 6 1 256   43 0     0   5   170 141 0   146   5   294       9.0 311 6 1 256   43 0     0   5   170 141 0   146 5 294     9 311
2940661 WA Franklin   school 5306570 11001   Pasco School District 530657002936 4564 Ellen Ochoa Middle School   Regular School No Middle 06 08 2021   grade_6 9 1 326   0 3     0   3   174 168 0   160   4   294       2.0 342 9 1 326   0 3     0   3   174 168 0   160 4 294     2 342
2426874 WA Yakima   school 5308970 39202   Toppenish School District 530897001535 2264 Toppenish Middle School   Regular School No Middle 06 08 2019   grade_6 12 0 251   42 1     0   5   150 161 0   129   6   293       10.0 311 12 0 251   42 1     0   5   150 161 0   129 6 293     10 311
2585041 WA Yakima   school 5309480 39207   Wapato School District 530948001615 2131 Wapato Middle School   Regular School No Middle 06 08 2020   grade_6 3 0 215   71 3     0   18   176 134 0   155   14   293       7.0 310 3 0 215   71 3     0   18   176 134 0   155 14 293     7 310
626534 WA Adams   school 5306480 1147   Othello School District 530648000956 3471 McFarland Middle School   Regular School No Middle 06 08 2017   grade_6 28 0 311   0 0     0   2   170 171 0   130   4   292       5.0 341 28 0 311   0 0     0   2   170 171 0   130 4 292     5 341
2426206 WA Yakima   school 5308670 39201   Sunnyside School District 530867001451 3313 Harrison Middle School   Regular School No Middle 06 08 2019   grade_6 11 0 318   0 1     0   3   161 172 0   87   11   290       3.0 333 11 0 318   0 1     0   3   161 172 0   87 11 290     3 333
2472126 WA Yakima   school 5309480 39207   Wapato School District 530948001615 2131 Wapato Middle School   Regular School No Middle 06 08 2018   grade_6 8 0 226   61 5     0   9   155 154 0   152   29   289       4.0 309 8 0 226   61 5     0   9   155 154 0   152 29 289     4 309
2575231 WA King   school 5303540 17401   Highline School District 530354003674 5551 Glacier Middle School   Regular School No Middle 06 08 2020   grade_6 37 32 175   3 47     16   13   160 163 0   122   21   286       0.0 323 37 32 175   3 47     16   13   160 163 0   122 21 286     0 323
628593 WA King   school 5307710 17001   Seattle School District No. 1 530771001136 3095 Mercer International Middle School   Regular School No Middle 06 08 2017   grade_6 64 97 80   0 154     0   28   211 212 0   66   37   285       9.0 423 64 97 80   0 154     0   28   211 212 0   66 37 285     9 423
535256 WA Yakima   school 5310110 39007   Yakima School District 531011001698 3615 Lewis & Clark Middle School   Regular School No 2 06 08 2016   grade_6 42 1 241   3 0     2   4   144 149 0   97   8   284       6.0 293 42 1 241   3 0     2   4   144 149 0   97 8 284     6 293
471226 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_6 40 94 79   1 163     1   23   199 202 0   95   15   283       8.0 401 40 94 79   1 163     1   23   199 202 0   95 15 283     8 401
2417566 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294000479 3300 Morris Ford Middle School   Regular School No Middle 06 08 2019   grade_6 98 29 115   4 30     18   56   187 163 0   33   17   283       10.0 350 98 29 115   4 30     18   56   187 163 0   33 17 283     10 350
2462176 WA Yakima   school 5303150 39200   Grandview School District 530315000498 3071 Grandview Middle School   Regular School No Middle 06 08 2018   grade_6 23 0 293   0 0     0   0   168 148 0   89   8   283       3.0 316 23 0 293   0 0     0   0   168 148 0   89 8 283     3 316
2584302 WA Yakima   school 5308970 39202   Toppenish School District 530897001535 2264 Toppenish Middle School   Regular School No Middle 06 08 2020   grade_6 3 1 255   38 2     0   4   154 149 0   98   15   283       11.0 303 3 1 255   38 2     0   4   154 149 0   98 15 283     11 303
474281 WA Clark   school 5309270 6037   Vancouver School District 530927001577 3146 Mcloughlin Middle School   Regular School No 2.0 06 08 2015   grade_6 106 13 149   2 8     22   16   156 160 0   74   17   277       9.0 316 106 13 149   2 8     22   16   156 160 0   74 17 277     9 316
2428286 WA Yakima   school 5310110 39007   Yakima School District 531011001698 3615 Lewis & Clark Middle School   Regular School No Middle 06 08 2019   grade_6 33 2 260   1 1     0   5   175 127 0   81   7   277       10.0 302 33 2 260   1 1     0   5   175 127 0   81 7 277     10 302
474633 WA Yakima   school 5309480 39207   Wapato School District 530948001615 2131 Wapato Middle School   Regular School No 2.0 06 08 2015   grade_6 11 0 193   69 2     0   5   146 134 0   65   10   276       1.0 280 11 0 193   69 2     0   5   146 134 0   65 10 276     1 280
631586 WA Clark   school 5309270 6037   Vancouver School District 530927001577 3146 Mcloughlin Middle School   Regular School No Middle 06 08 2017   grade_6 109 14 156   1 12     14   23   152 177 0   91   24   275       8.0 329 109 14 156   1 12     14   23   152 177 0   91 24 275     8 329
2416863 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000415 3320 Covington Middle School   Regular School No Middle 06 08 2019   grade_6 180 17 116   2 13     7   32   201 166 0   64   20   275       10.0 367 180 17 116   2 13     7   32   201 166 0   64 20 275     10 367
531216 WA King   school 5307710 17001   Seattle School District No. 1 530771001136 3095 Mercer International Middle School   Regular School No 2 06 08 2016   grade_6 35 82 70   1 161     0   22   191 180 0   59   24   274       4.0 371 35 82 70   1 161     0   22   191 180 0   59 24 274     4 371
535225 WA Yakima   school 5310110 39007   Yakima School District 531011001691 2410 Franklin Middle School   Regular School No 2 06 08 2016   grade_6 51 1 233   2 0     0   14   147 154 0   77   9   273       8.0 301 51 1 233   2 0     0   14   147 154 0   77 9 273     8 301
2428254 WA Yakima   school 5310110 39007   Yakima School District 531011001691 2410 Franklin Middle School   Regular School No Middle 06 08 2019   grade_6 69 2 236   3 3     0   10   173 150 0   67   11   273       14.0 323 69 2 236   3 3     0   10   173 150 0   67 11 273     14 323
525300 WA Benton   school 5303930 3017   Kennewick School District 530393000607 3472 Park Middle School   Regular School No 2 06 08 2016   grade_6 65 15 176   1 19     0   9   159 126 0   85   5   272       2.0 285 65 15 176   1 19     0   9   159 126 0   85 5 272     2 285
2585722 WA Yakima   school 5310110 39007   Yakima School District 531011001698 3615 Lewis & Clark Middle School   Regular School No Middle 06 08 2020   grade_6 28 0 263   3 0     0   7   133 168 0   85   9   272       7.0 301 28 0 263   3 0     0   7   133 168 0   85 9 272     7 301
525249 WA Benton   school 5303930 3017   Kennewick School District 530393000603 3267 Highlands Middle School   Regular School No 2 06 08 2016   grade_6 133 10 150   2 8     3   15   167 154 0   53   9   271       18.0 321 133 10 150   2 8     3   15   167 154 0   53 9 271     18 321
631167 WA Yakima   school 5308970 39202   Toppenish School District 530897001535 2264 Toppenish Middle School   Regular School No Middle 06 08 2017   grade_6 7 0 260   31 0     0   6   146 158 0   133   19   269       13.0 304 7 0 260   31 0     0   6   146 158 0   133 19 269     13 304
2417678 WA Yakima   school 5303150 39200   Grandview School District 530315000498 3071 Grandview Middle School   Regular School No Middle 06 08 2019   grade_6 22 1 287   0 0     0   1   151 160 0   68   5   269       3.0 311 22 1 287   0 0     0   1   151 160 0   68 5 269     3 311
2472873 WA Yakima   school 5310110 39007   Yakima School District 531011001708 2314 Washington Middle School   Regular School No Middle 06 08 2018   grade_6 15 2 265   2 0     0   3   150 137 0   136   7   269       10.0 287 15 2 265   2 0     0   3   150 137 0   136 7 269     10 287
2946755 WA Yakima   school 5310110 39007   Yakima School District 531011001698 3615 Lewis & Clark Middle School   Regular School No Middle 06 08 2021   grade_6 38 0 265   2 0     0   3   159 149 0   71   5   269       10.0 308 38 0 265   2 0     0   3   159 149 0   71 5 269     10 308
533175 WA Yakima   school 5308670 39201   Sunnyside School District 530867001451 3313 Harrison Middle School   Regular School No 2 06 08 2016   grade_6 15 0 278   0 0     0   8   154 147 0   96   24   267       2.0 301 15 0 278   0 0     0   8   154 147 0   96 24 267     2 301
2461376 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000415 3320 Covington Middle School   Regular School No Middle 06 08 2018   grade_6 206 8 107   0 12     8   30   174 197 0   74   14   266       18.0 371 206 8 107   0 12     8   30   174 197 0   74 14 266     18 371
2462070 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294000481 3401 Perry G Keithley Middle School   Regular School No Middle 06 08 2018   grade_6 92 39 99   1 8     21   51   158 153 0   27   11   266       7.0 311 92 39 99   1 8     21   51   158 153 0   27 11 266     7 311
2570648 WA King   school 5300300 17408   Auburn School District 530030000038 3169 Olympic Middle School   Regular School No Middle 06 08 2020   grade_6 83 14 146   17 29     30   36   163 192 0   74   6   266       3.0 355 83 14 146   17 29     30   36   163 192 0   74 6 266     3 355
2574906 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294000479 3300 Morris Ford Middle School   Regular School No Middle 06 08 2020   grade_6 103 34 114   2 19     13   51   175 161 0   26   17   265       11.0 336 103 34 114   2 19     13   51   175 161 0   26 17 265     11 336
2574910 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294000481 3401 Perry G Keithley Middle School   Regular School No Middle 06 08 2020   grade_6 82 32 79   6 18     25   64   141 165 0   28   17   265       9.0 306 82 32 79   6 18     25   64   141 165 0   28 17 265     9 306
2585786 WA Yakima   school 5310110 39007   Yakima School District 531011001708 2314 Washington Middle School   Regular School No Middle 06 08 2020   grade_6 8 2 261   4 1     0   3   145 134 0   104   10   265       15.0 279 8 2 261   4 1     0   3   145 134 0   104 10 265     15 279
475319 WA Yakima   school 5310110 39007   Yakima School District 531011001698 3615 Lewis & Clark Middle School   Regular School No 2.0 06 08 2015   grade_6 32 3 219   3 3     0   7   126 141 0   94   10   264       4.0 267 32 3 219   3 3     0   7   126 141 0   94 10 264     4 267
631924 WA Yakima   school 5309480 39207   Wapato School District 530948001615 2131 Wapato Middle School   Regular School No Middle 06 08 2017   grade_6 5 0 185   67 3     0   8   149 119 0   94   17   263       1.0 268 5 0 185   67 3     0   8   149 119 0   94 17 263     1 268
620950 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000415 3320 Covington Middle School   Regular School No Middle 06 08 2017   grade_6 188 7 118   3 7     14   36   195 178 0   90   22   262       7.0 373 188 7 118   3 7     14   36   195 178 0   90 22 262     7 373
2472808 WA Yakima   school 5310110 39007   Yakima School District 531011001698 3615 Lewis & Clark Middle School   Regular School No Middle 06 08 2018   grade_6 33 0 267   3 0     0   6   167 142 0   96   7   262       11.0 309 33 0 267   3 0     0   6   167 142 0   96 7 262     11 309
534255 WA Clark   school 5309270 6037   Vancouver School District 530927001577 3146 Mcloughlin Middle School   Regular School No 2 06 08 2016   grade_6 99 13 166   0 14     16   26   158 176 0   83   22   261       9.0 334 99 13 166   0 14     16   26   158 176 0   83 22 261     9 334
529103 WA Adams   school 5306480 1147   Othello School District 530648000956 3471 McFarland Middle School   Regular School No 2 06 08 2016   grade_6 31 0 272   0 0     0   0   164 139 0   97   6   260       6.0 303 31 0 272   0 0     0   0   164 139 0   97 6 260     6 303
632674 WA Yakima   school 5310110 39007   Yakima School District 531011001708 2314 Washington Middle School   Regular School No Middle 06 08 2017   grade_6 12 3 256   2 0     0   1   135 139 0   136   20   260       9.0 274 12 3 256   2 0     0   1   135 139 0   136 20 260     9 274
464326 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294000479 3300 Morris Ford Middle School   Regular School No 2.0 06 08 2015   grade_6 135 30 73   3 22     15   30   169 139 0   16   8   259       7.0 308 135 30 73   3 22     15   30   169 139 0   16 8 259     7 308
524399 WA Yakima   school 5303150 39200   Grandview School District 530315000498 3071 Grandview Middle School   Regular School No 2 06 08 2016   grade_6 12 0 266   1 1     0   2   146 136 0   100   12   259       3.0 282 12 0 266   1 1     0   2   146 136 0   100 12 259     3 282
534592 WA Yakima   school 5309480 39207   Wapato School District 530948001615 2131 Wapato Middle School   Regular School No 2 06 08 2016   grade_6 8 0 187   59 8     0   7   131 138 0   88   17   258       0.0 269 8 0 187   59 8     0   7   131 138 0   88 17 258     0 269
465288 WA Benton   school 5303930 3017   Kennewick School District 530393000603 3267 Highlands Middle School   Regular School No 2.0 06 08 2015   grade_6 180 11 137   0 6     1   10   174 171 0   56   3   257       4.0 345 180 11 137   0 6     1   10   174 171 0   56 3 257     4 345
630515 WA Yakima   school 5308670 39201   Sunnyside School District 530867001451 3313 Harrison Middle School   Regular School No Middle 06 08 2017   grade_6 14 0 285   1 0     0   5   157 148 0   93   1   257       6.0 305 14 0 285   1 0     0   5   157 148 0   93 1 257     6 305
632607 WA Yakima   school 5310110 39007   Yakima School District 531011001698 3615 Lewis & Clark Middle School   Regular School No Middle 06 08 2017   grade_6 28 0 243   3 1     0   3   131 147 0   98   6   256       7.0 278 28 0 243   3 1     0   3   131 147 0   98 6 256     7 278
535324 WA Yakima   school 5310110 39007   Yakima School District 531011001708 2314 Washington Middle School   Regular School No 2 06 08 2016   grade_6 4 2 248   4 1     0   1   122 138 0   130   12   255       7.0 260 4 2 248   4 1     0   1   122 138 0   130 12 255     7 260
2575018 WA Yakima   school 5303150 39200   Grandview School District 530315000498 3071 Grandview Middle School   Regular School No Middle 06 08 2020   grade_6 14 0 277   0 0     0   0   155 136 0   79   14   255       1.0 291 14 0 277   0 0     0   0   155 136 0   79 14 255     1 291
475382 WA Yakima   school 5310110 39007   Yakima School District 531011001708 2314 Washington Middle School   Regular School No 2.0 06 08 2015   grade_6 12 2 240   0 0     0   2   132 124 0   122   4   253       1.0 256 12 2 240   0 0     0   2   132 124 0   122 4 253     1 256
621659 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294000479 3300 Morris Ford Middle School   Regular School No Middle 06 08 2017   grade_6 108 27 92   2 28     12   36   175 130 0   29   11   253       11.0 305 108 27 92   2 28     12   36   175 130 0   29 11 253     11 305
2936109 WA King   school 5303540 17401   Highline School District 530354003674 5551 Glacier Middle School   Regular School No Middle 06 08 2021   grade_6 22 28 196   0 49     14   25   151 183 0   96   24   253       0.0 334 22 28 196   0 49     14   25   151 183 0   96 24 253     0 334
2417570 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294000481 3401 Perry G Keithley Middle School   Regular School No Middle 06 08 2019   grade_6 88 28 93   1 14     24   41   150 139 0   16   18   252       9.0 289 88 28 93   1 14     24   41   150 139 0   16 18 252     9 289
2462066 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294000479 3300 Morris Ford Middle School   Regular School No Middle 06 08 2018   grade_6 110 26 108   2 27     10   49   170 162 0   24   3   252       8.0 332 110 26 108   2 27     10   49   170 162 0   24 3 252     8 332
2574220 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000415 3320 Covington Middle School   Regular School No Middle 06 08 2020   grade_6 201 12 94   3 13     13   28   178 186 0   65   17   252       18.0 364 201 12 94   3 13     13   28   178 186 0   65 17 252     18 364
2946820 WA Yakima   school 5310110 39007   Yakima School District 531011001708 2314 Washington Middle School   Regular School No Middle 06 08 2021   grade_6 14 0 252   0 1     0   7   133 141 0   104   7   252       5.0 274 14 0 252   0 1     0   7   133 141 0   104 7 252     5 274
464447 WA Yakima   school 5303150 39200   Grandview School District 530315000498 3071 Grandview Middle School   Regular School No 2.0 06 08 2015   grade_6 17 0 256   0 0     0   2   131 144 0   85   4   251       0.0 275 17 0 256   0 0     0   2   131 144 0   85 4 251     0 275
2462980 WA Benton   school 5303930 3017   Kennewick School District 530393000603 3267 Highlands Middle School   Regular School No Middle 06 08 2018   grade_6 111 10 157   3 2     0   13   144 152 0   77   3   251       12.0 296 111 10 157   3 2     0   13   144 152 0   77 3 251     12 296
2575194 WA King   school 5303540 17401   Highline School District 530354000522 3163 Cascade Middle School   Regular School No Middle 06 08 2020   grade_6 28 34 136   3 58     3   18   145 135 0   87   17   251       0.0 280 28 34 136   3 58     3   18   145 135 0   87 17 251     0 280
465338 WA Benton   school 5303930 3017   Kennewick School District 530393000607 3472 Park Middle School   Regular School No 2.0 06 08 2015   grade_6 70 6 183   1 7     0   4   146 125 0   79   11   250       1.0 271 70 6 183   1 7     0   4   146 125 0   79 11 250     1 271
2424306 WA King   school 5307710 17001   Seattle School District No. 1 530771001136 3095 Mercer International Middle School   Regular School No Middle 06 08 2019   grade_6 58 73 62   2 167     0   28   203 187 0   68   13   250       11.0 390 58 73 62   2 167     0   28   203 187 0   68 13 250     11 390
2427613 WA Yakima   school 5309480 39207   Wapato School District 530948001615 2131 Wapato Middle School   Regular School No Middle 06 08 2019   grade_6 9 0 190   48 7     0   9   139 124 0   132   5   250       2.0 263 9 0 190   48 7     0   9   139 124 0   132 5 250     2 263
2578173 WA Snohomish   school 5305430 31006   Mukilteo School District 530543001910 4231 Explorer Middle School   Regular School No Middle 06 08 2020   grade_6 100 29 129   1 42     3   36   176 164 0   76   7   250       23.0 340 100 29 129   1 42     3   36   176 164 0   76 7 250     23 340
2585690 WA Yakima   school 5310110 39007   Yakima School District 531011001691 2410 Franklin Middle School   Regular School No Middle 06 08 2020   grade_6 54 2 232   2 3     1   6   148 152 0   78   14   250       16.0 300 54 2 232   2 3     1   6   148 152 0   78 14 250     16 300
627599 WA King   school 5307230 17403   Renton School District 530723002564 3280 Dimmitt Middle School   Regular School No Middle 06 08 2017   grade_6 35 96 90   0 77     5   30   149 184 0   64   17   249       12.0 333 35 96 90   0 77     5   30   149 184 0   64 17 249     12 333
2945733 WA Clark   school 5309270 6037   Vancouver School District 530927001577 3146 Mcloughlin Middle School   Regular School No Middle 06 08 2021   grade_6 113 14 151   4 7     14   22   177 148 0   73   13   249       6.0 325 113 14 151   4 7     14   22   177 148 0   73 13 249     6 325
475394 WA Yakima   school 5310110 39007   Yakima School District 531011001710 3368 Wilson Middle School   Regular School No 2.0 06 08 2015   grade_6 73 3 196   0 3     0   6   147 134 0   54   8   248       5.0 281 73 3 196   0 3     0   6   147 134 0   54 8 248     5 281
2575912 WA Benton   school 5303930 3017   Kennewick School District 530393000607 3472 Park Middle School   Regular School No Middle 06 08 2020   grade_6 57 5 191   0 6     0   12   149 122 0   12   5   248       2.0 271 57 5 191   0 6     0   12   149 122 0   12 5 248     2 271
630677 WA Pierce   school 5308700 27010   Tacoma School District 530870003299 5170 First Creek Middle School   Regular School No Middle 06 08 2017   grade_6 54 59 92   8 39     18   11   155 126 0   62   13   247       11.0 281 54 59 92   8 39     18   11   155 126 0   62 13 247     11 281
2936747 WA Benton   school 5303930 3017   Kennewick School District 530393000603 3267 Highlands Middle School   Regular School No Middle 06 08 2021   grade_6 114 5 170   0 4     3   10   145 161 0   78   4   247       10.0 306 114 5 170   0 4     3   10   145 161 0   78 4 247     10 306
469211 WA Adams   school 5306480 1147   Othello School District 530648000956 3471 McFarland Middle School   Regular School No 2.0 06 08 2015   grade_6 35 1 262   0 3     0   0   174 127 0   97   8   246       7.0 301 35 1 262   0 3     0   0   174 127 0   97 8 246     7 301
524284 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294000479 3300 Morris Ford Middle School   Regular School No 2 06 08 2016   grade_6 132 17 83   1 25     7   37   157 145 0   19   8   246       6.0 302 132 17 83   1 25     7   37   157 145 0   19 8 246     6 302
2418514 WA Benton   school 5303930 3017   Kennewick School District 530393000603 3267 Highlands Middle School   Regular School No Middle 06 08 2019   grade_6 120 8 150   2 1     1   8   148 142 0   6   9   245       8.0 290 120 8 150   2 1     1   8   148 142 0   6 9 245     8 290
2935899 WA Yakima   school 5303150 39200   Grandview School District 530315000498 3071 Grandview Middle School   Regular School No Middle 06 08 2021   grade_6 15 1 292   0 1     0   0   161 148 0   74   3   245       5.0 309 15 1 292   0 1     0   0   161 148 0   74 3 245     5 309
470234 WA King   school 5307230 17403   Renton School District 530723002564 3280 Dimmitt Middle School   Regular School No 2.0 06 08 2015   grade_6 36 92 72   3 87     9   20   154 165 0   45   13   244       3.0 319 36 92 72   3 87     9   20   154 165 0   45 13 244     3 319
530169 WA King   school 5307230 17403   Renton School District 530723002564 3280 Dimmitt Middle School   Regular School No 2 06 08 2016   grade_6 32 88 91   1 76     4   27   154 165 0   50   9   244       9.0 319 32 88 91   1 76     4   27   154 165 0   50 9 244     9 319
2946724 WA Yakima   school 5310110 39007   Yakima School District 531011001691 2410 Franklin Middle School   Regular School No Middle 06 08 2021   grade_6 50 3 230   4 3     0   5   145 150 0   68   11   244       7.0 295 50 3 230   4 3     0   5   145 150 0   68 11 244     7 295
533832 WA Yakima   school 5308970 39202   Toppenish School District 530897001535 2264 Toppenish Middle School   Regular School No 2 06 08 2016   grade_6 7 2 213   46 0     0   2   139 131 0   112   14   243       5.0 270 7 2 213   46 0     0   2   139 131 0   112 14 243     5 270
475287 WA Yakima   school 5310110 39007   Yakima School District 531011001691 2410 Franklin Middle School   Regular School No 2.0 06 08 2015   grade_6 61 1 194   3 0     0   9   134 134 0   54   9   242       8.0 268 61 1 194   3 0     0   9   134 134 0   54 9 242     8 268
2468818 WA King   school 5307710 17001   Seattle School District No. 1 530771001136 3095 Mercer International Middle School   Regular School No Middle 06 08 2018   grade_6 48 76 70   1 146     1   37   195 184 0   92   35   241       7.0 379 48 76 70   1 146     1   37   195 184 0   92 35 241     7 379
2931543 WA King   school 5300300 17408   Auburn School District 530030000038 3169 Olympic Middle School   Regular School No Middle 06 08 2021   grade_6 66 27 153   5 17     18   44   165 165 0   75   0   241       2.0 330 66 27 153   5 17     18   44   165 165 0   75 0 241     2 330
2585798 WA Yakima   school 5310110 39007   Yakima School District 531011001710 3368 Wilson Middle School   Regular School No Middle 06 08 2020   grade_6 79 4 214   6 1     1   18   154 169 0   42   10   240       25.0 323 79 4 214   6 1     1   18   154 169 0   42 10 240     25 323
2427958 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972002545 4506 West Valley Middle School   Regular School No Middle 05 06 2019   grade_6 247 6 150   7 12     0   17   218 221 0   31   4   239       7.0 439 247 6 150   7 12     0   17   218 221 0   31 4 239     7 439
2946071 WA Yakima   school 5309480 39207   Wapato School District 530948001615 2131 Wapato Middle School   Regular School No Middle 06 08 2021   grade_6 4 0 189   57 4     0   1   139 116 0   118   17   237       4.0 255 4 0 189   57 4     0   1   139 116 0   118 17 237     4 255
632573 WA Yakima   school 5310110 39007   Yakima School District 531011001691 2410 Franklin Middle School   Regular School No Middle 06 08 2017   grade_6 54 1 208   4 0     0   5   143 129 0   75   9   236       4.0 272 54 1 208   4 0     0   5   143 129 0   75 9 236     4 272
2426229 WA Yakima   school 5308670 39201   Sunnyside School District 530867003037 5049 Sierra Vista Middle School   Regular School No Middle 06 08 2019   grade_6 16 0 247   0 0     0   3   130 136 0   79   14   236       3.0 266 16 0 247   0 0     0   3   130 136 0   79 14 236     3 266

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