Data source: Big Local News · About: Big Local

4,566 rows where grade = "grade_7" and state = "WA" sorted by native_hawaiian_pacific_islander_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
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
2470283 WA Spokane   school 5308250 32081   Spokane School District 530825001408 3257 Shaw Middle School   Regular School No Middle 06 08 2018   grade_7 145 10 38   7 8     29   47   136 148 0   57   16   243       29.0 284 145 10 38   7 8     29   47   136 148 0   57 16 243     29 284
2931466 WA King   school 5300300 17408   Auburn School District 530030000033 2394 Cascade Middle School   Regular School No Middle 06 08 2021   grade_7 94 23 80   1 37     29   39   152 151 0   44   1   184       3.0 303 94 23 80   1 37     29   39   152 151 0   44 1 184     3 303
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
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
2571318 WA Pierce   school 5300480 27403   Bethel School District 530048001819 4186 Cedarcrest Middle School   Regular School No Middle 06 08 2020   grade_7 92 42 58   2 24     28   43   152 137 0   13   5   186       8.0 289 92 42 58   2 24     28   43   152 137 0   13 5 186     8 289
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
2931544 WA King   school 5300300 17408   Auburn School District 530030000038 3169 Olympic Middle School   Regular School No Middle 06 08 2021   grade_7 72 14 151   15 25     27   35   159 180 0   60   2   246       4.0 339 72 14 151   15 25     27   35   159 180 0   60 2 246     4 339
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
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
2462365 WA King   school 5303540 17401   Highline School District 530354000524 3098 Chinook Middle School   Regular School No Middle 07 08 2018   grade_7 32 56 108   1 39     25   13   135 139 0   82   11   233       3.0 274 32 56 108   1 39     25   13   135 139 0   82 11 233     3 274
2572708 WA Pierce   school 5301410 27400   Clover Park School District 530141000263 3602 Lochburn Middle School   Regular School No Middle 06 08 2020   grade_7 23 34 82   0 8     25   33   105 100 0   40   13   191       8.0 205 23 34 82   0 8     25   33   105 100 0   40 13 191     8 205
2462071 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294000481 3401 Perry G Keithley Middle School   Regular School No Middle 06 08 2018   grade_7 67 35 68   5 13     24   51   144 119 0   18   17   222       7.0 263 67 35 68   5 13     24   51   144 119 0   18 17 222     7 263
2570572 WA King   school 5300300 17408   Auburn School District 530030000033 2394 Cascade Middle School   Regular School No Middle 06 08 2020   grade_7 112 30 75   1 19     24   25   160 126 0   52   7   179       5.0 286 112 30 75   1 19     24   25   160 126 0   52 7 179     5 286
2574510 WA King   school 5302820 17210   Federal Way School District 530282000437 3898 Illahee Middle School   Regular School No Middle 05 08 2020   grade_7 58 52 63   2 39     24   41   148 130 1   43   5   183       9.0 279 58 52 63   2 39     24   41   148 130 1   43 5 183     9 279
2933608 WA Pierce   school 5301410 27400   Clover Park School District 530141000263 3602 Lochburn Middle School   Regular School No Middle 06 08 2021   grade_7 34 25 66   2 8     24   29   99 88 1   37   6   170       2.0 188 34 25 66   2 8     24   29   99 88 1   37 6 170     2 188
2413331 WA King   school 5300300 17408   Auburn School District 530030000038 3169 Olympic Middle School   Regular School No Middle 06 08 2019   grade_7 69 17 108   9 27     23   41   166 128 0   51   4   219       4.0 294 69 17 108   9 27     23   41   166 128 0   51 4 219     4 294
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
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
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
524289 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294000481 3401 Perry G Keithley Middle School   Regular School No 2 05 08 2016   grade_7 76 28 73   2 11     22   34   112 135 0   10   7   222       5.0 247 76 28 73   2 11     22   34   112 135 0   10 7 222     5 247
524731 WA King   school 5303540 17401   Highline School District 530354000543 3333 Pacific Middle School   Regular School No 2 07 08 2016   grade_7 84 31 100   2 29     22   33   159 142 0   37   10   202       7.0 301 84 31 100   2 29     22   33   159 142 0   37 10 202     7 301
621665 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294000481 3401 Perry G Keithley Middle School   Regular School No Middle 06 08 2017   grade_7 85 43 66   3 10     22   38   127 140 0   13   10   230       6.0 267 85 43 66   3 10     22   38   127 140 0   13 10 230     6 267
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
2417163 WA King   school 5302820 17210   Federal Way School District 530282000437 3898 Illahee Middle School   Regular School No Middle 05 08 2019   grade_7 51 45 72   3 42     22   33   127 141 0   37   11   175       10.0 268 51 45 72   3 42     22   33   127 141 0   37 11 175     10 268
2459872 WA Pierce   school 5301410 27400   Clover Park School District 530141000263 3602 Lochburn Middle School   Regular School No Middle 06 08 2018   grade_7 37 32 89   0 12     22   21   123 90 0   42   14   198       5.0 213 37 32 89   0 12     22   21   123 90 0   42 14 198     5 213
2574553 WA King   school 5302820 17210   Federal Way School District 530282000442 3381 Lakota Middle School   Regular School No Middle 06 08 2020   grade_7 68 37 89   2 22     22   27   142 124 1   35   11   171       14.0 267 68 37 89   2 22     22   27   142 124 1   35 11 171     14 267
2935380 WA King   school 5302820 17210   Federal Way School District 530282000437 3898 Illahee Middle School   Regular School No Middle 05 08 2021   grade_7 48 53 78   1 29     22   32   132 131 0   44   9   168       14.0 263 48 53 78   1 29     22   32   132 131 0   44 9 168     14 263
2935777 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294000481 3401 Perry G Keithley Middle School   Regular School No Middle 06 08 2021   grade_7 75 28 77   5 17     22   61   131 154 0   24   11   206       8.0 285 75 28 77   5 17     22   61   131 154 0   24 11 206     8 285
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
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
2413327 WA King   school 5300300 17408   Auburn School District 530030001443 4462 Mt Baker Middle School   Regular School No Middle 06 08 2019   grade_7 104 12 108   0 33     21   40   162 156 0   50   5   159       7.0 318 104 12 108   0 33     21   40   162 156 0   50 5 159     7 318
2458545 WA Pierce   school 5300480 27403   Bethel School District 530048001819 4186 Cedarcrest Middle School   Regular School No Middle 06 08 2018   grade_7 84 21 36   3 19     21   34   123 95 0   7   5   152       14.0 218 84 21 36   3 19     21   34   123 95 0   7 5 152     14 218
2571471 WA Pierce   school 5300480 27403   Bethel School District 530048000128 3751 Spanaway Middle School   Regular School No Middle 06 08 2020   grade_7 87 27 73   3 12     21   52   135 140 0   16   9   194       4.0 275 87 27 73   3 12     21   52   135 140 0   16 9 194     4 275
2935423 WA King   school 5302820 17210   Federal Way School District 530282000442 3381 Lakota Middle School   Regular School No Middle 06 08 2021   grade_7 58 24 83   1 25     21   29   126 115 0   26   9   145       8.0 241 58 24 83   1 25     21   29   126 115 0   26 9 145     8 241
2935553 WA King   school 5302820 17210   Federal Way School District 530282000452 3431 Totem Middle School   Regular School No Middle 06 08 2021   grade_7 21 47 113   3 49     21   23   138 139 0   58   6   217       3.0 277 21 47 113   3 49     21   23   138 139 0   58 6 217     3 277
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
621358 WA King   school 5302820 17210   Federal Way School District 530282000448 3626 Sacajawea Middle School   Regular School No Middle 06 08 2017   grade_7 66 16 82   1 30     20   37   135 117 0   33   3   159       5.0 252 66 16 82   1 30     20   37   135 117 0   33 3 159     5 252
2461975 WA Pierce   school 5302880 27417   Fife School District 530288000467 3798 Surprise Lake Middle School   Regular School No Middle 06 07 2018   grade_7 131 13 52   2 30     20   36   134 150 0   34   4   124       19.0 284 131 13 52   2 30     20   36   134 150 0   34 4 124     19 284
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
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
2936206 WA King   school 5303540 17401   Highline School District 530354000543 3333 Pacific Middle School   Regular School No Middle 06 08 2021   grade_7 50 40 98   2 40     20   22   135 137 0   83   20   190       0.0 272 50 40 98   2 40     20   22   135 137 0   83 20 190     0 272
459965 WA King   school 5300300 17408   Auburn School District 530030000033 2394 Cascade Middle School   Regular School No 2.0 06 08 2015   grade_7 116 21 55   1 13     19   12   130 107 0   24   5   167       7.0 237 116 21 55   1 13     19   12   130 107 0   24 5 167     7 237
2417206 WA King   school 5302820 17210   Federal Way School District 530282000442 3381 Lakota Middle School   Regular School No Middle 06 08 2019   grade_7 87 38 80   1 15     19   39   151 127 1   40   10   166       9.0 279 87 38 80   1 15     19   39   151 127 1   40 10 166     9 279
2570649 WA King   school 5300300 17408   Auburn School District 530030000038 3169 Olympic Middle School   Regular School No Middle 06 08 2020   grade_7 77 21 130   19 18     19   30   154 160 0   70   3   230       7.0 314 77 21 130   19 18     19   30   154 160 0   70 3 230     7 314
2575207 WA King   school 5303540 17401   Highline School District 530354000524 3098 Chinook Middle School   Regular School No Middle 06 08 2020   grade_7 22 49 96   0 29     19   14   115 114 0   56   12   195       0.0 229 22 49 96   0 29     19   14   115 114 0   56 12 195     0 229
2931540 WA King   school 5300300 17408   Auburn School District 530030001443 4462 Mt Baker Middle School   Regular School No Middle 06 08 2021   grade_7 106 17 113   1 34     19   38   163 165 0   58   0   176       4.0 328 106 17 113   1 34     19   38   163 165 0   58 0 176     4 328
2932193 WA Pierce   school 5300480 27403   Bethel School District 530048000120 3250 Bethel Middle School   Regular School No Middle 06 08 2021   grade_7 100 20 52   1 6     19   39   134 103 0   7   6   153       8.0 237 100 20 52   1 6     19   39   134 103 0   7 6 153     8 237
2932219 WA Pierce   school 5300480 27403   Bethel School District 530048001819 4186 Cedarcrest Middle School   Regular School No Middle 06 08 2021   grade_7 89 39 55   3 16     19   31   132 120 0   5   3   150       10.0 252 89 39 55   3 16     19   31   132 120 0   5 3 150     10 252
2933578 WA Pierce   school 5301410 27400   Clover Park School District 530141000257 3248 Hudtloff Middle School   Regular School No Middle 06 08 2021   grade_7 55 23 88   1 14     19   31   121 109 1   40   10   165       7.0 231 55 23 88   1 14     19   31   121 109 1   40 10 165     7 231
2933659 WA Pierce   school 5301410 27400   Clover Park School District 530141000272 3500 Thomas Middle School   Regular School No Middle 06 08 2021   grade_7 99 31 93   4 5     19   44   155 139 1   19   5   178       14.0 295 99 31 93   4 5     19   44   155 139 1   19 5 178     14 295
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
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
2457885 WA King   school 5300300 17408   Auburn School District 530030000038 3169 Olympic Middle School   Regular School No Middle 06 08 2018   grade_7 87 19 108   8 16     18   27   151 132 0   70   5   208       3.0 283 87 19 108   8 16     18   27   151 132 0   70 5 208     3 283
2461777 WA King   school 5302820 17210   Federal Way School District 530282000448 3626 Sacajawea Middle School   Regular School No Middle 06 08 2018   grade_7 43 28 94   1 32     18   21   123 114 0   49   6   166       5.0 237 43 28 94   1 32     18   21   123 114 0   49 6 166     5 237
2470880 WA Pierce   school 5308700 27010   Tacoma School District 530870003299 5170 First Creek Middle School   Regular School No Middle 06 08 2018   grade_7 49 44 84   6 28     18   17   145 101 0   47   7   212       7.0 246 49 44 84   6 28     18   17   145 101 0   47 7 212     7 246
2583176 WA Spokane   school 5308250 32081   Spokane School District 530825001408 3257 Shaw Middle School   Regular School No Middle 06 08 2020   grade_7 142 10 50   5 7     18   48   141 139 0   31   14   242       13.0 280 142 10 50   5 7     18   48   141 139 0   31 14 242     13 280
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
523870 WA King   school 5302820 17210   Federal Way School District 530282000437 3898 Illahee Middle School   Regular School No 2 05 08 2016   grade_7 70 21 52   1 52     17   39   141 111 0   25   0   134       6.0 252 70 21 52   1 52     17   39   141 111 0   25 0 134     6 252
523914 WA King   school 5302820 17210   Federal Way School District 530282000442 3381 Lakota Middle School   Regular School No 2 06 08 2016   grade_7 83 33 62   0 27     17   29   126 125 0   25   4   158       7.0 251 83 33 62   0 27     17   29   126 125 0   25 4 158     7 251
2461671 WA King   school 5302820 17210   Federal Way School District 530282000437 3898 Illahee Middle School   Regular School No Middle 05 08 2018   grade_7 61 39 55   3 38     17   27   121 119 0   35   4   142       9.0 240 61 39 55   3 38     17   27   121 119 0   35 4 142     9 240
2935687 WA Pierce   school 5302880 27417   Fife School District 530288000467 3798 Surprise Lake Middle School   Regular School No Middle 06 07 2021   grade_7 115 17 70   2 27     17   38   133 153 0   29   5   148       7.0 286 115 17 70   2 27     17   38   133 153 0   29 5 148     7 286
460046 WA King   school 5300300 17408   Auburn School District 530030000038 3169 Olympic Middle School   Regular School No 2.0 06 08 2015   grade_7 83 13 91   12 15     16   18   126 122 0   46   2   194       4.0 248 83 13 91   12 15     16   18   126 122 0   46 2 194     4 248
522046 WA Pierce   school 5301410 27400   Clover Park School District 530141000263 3602 Lochburn Middle School   Regular School No 2 06 08 2016   grade_7 36 37 61   0 14     16   22   95 91 0   19   12   174       2.0 186 36 37 61   0 14     16   22   95 91 0   19 12 174     2 186
524046 WA King   school 5302820 17210   Federal Way School District 530282000452 3431 Totem Middle School   Regular School No 2 06 08 2016   grade_7 30 29 85   4 35     16   25   117 107 0   52   6   175       3.0 224 30 29 85   4 35     16   25   117 107 0   52 6 175     3 224
524604 WA King   school 5303540 17401   Highline School District 530354000524 3098 Chinook Middle School   Regular School No 2 07 08 2016   grade_7 41 47 112   2 50     16   18   147 139 0   75   17   247       2.0 286 41 47 112   2 50     16   18   147 139 0   75 17 247     2 286
533239 WA Pierce   school 5308700 27010   Tacoma School District 530870001454 3054 Baker   Regular School No 2 06 08 2016   grade_7 41 48 69   3 45     16   12   124 110 0   24   15   153       9.0 234 41 48 69   3 45     16   12   124 110 0   24 15 153     9 234
621432 WA King   school 5302820 17210   Federal Way School District 530282000452 3431 Totem Middle School   Regular School No Middle 06 08 2017   grade_7 36 37 94   2 23     16   31   116 123 0   61   4   180       4.0 239 36 37 94   2 23     16   31   116 123 0   61 4 180     4 239
621984 WA King   school 5303540 17401   Highline School District 530354000524 3098 Chinook Middle School   Regular School No Middle 07 08 2017   grade_7 37 51 105   0 57     16   10   144 132 0   79   16   224       4.0 276 37 51 105   0 57     16   10   144 132 0   79 16 224     4 276
2415358 WA Pierce   school 5301410 27400   Clover Park School District 530141000263 3602 Lochburn Middle School   Regular School No Middle 06 08 2019   grade_7 35 35 88   1 8     16   34   128 89 0   39   12   193       2.0 217 35 35 88   1 8     16   34   128 89 0   39 12 193     2 217
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
2458699 WA Pierce   school 5300480 27403   Bethel School District 530048000128 3751 Spanaway Middle School   Regular School No Middle 06 08 2018   grade_7 80 28 54   3 14     16   32   111 116 0   9   11   147       11.0 227 80 28 54   3 14     16   32   111 116 0   9 11 147     11 227
2461847 WA King   school 5302820 17210   Federal Way School District 530282000452 3431 Totem Middle School   Regular School No Middle 06 08 2018   grade_7 31 40 79   0 30     16   22   109 109 0   81   3   175       5.0 218 31 40 79   0 30     16   22   109 109 0   81 3 175     5 218
2462353 WA King   school 5303540 17401   Highline School District 530354000522 3163 Cascade Middle School   Regular School No Middle 07 08 2018   grade_7 29 27 146   3 49     16   20   151 139 0   103   15   246       8.0 290 29 27 146   3 49     16   20   151 139 0   103 15 246     8 290
2470913 WA Pierce   school 5308700 27010   Tacoma School District 530870001471 2377 Gray   Regular School No Middle 06 08 2018   grade_7 46 46 41   0 17     16   18   99 85 0   19   17   149       3.0 184 46 46 41   0 17     16   18   99 85 0   19 17 149     3 184
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
2574614 WA King   school 5302820 17210   Federal Way School District 530282000448 3626 Sacajawea Middle School   Regular School No Middle 06 08 2020   grade_7 45 39 116   1 25     16   23   151 113 1   53   9   208       5.0 265 45 39 116   1 25     16   23   151 113 1   53 9 208     5 265
2574820 WA Pierce   school 5302880 27417   Fife School District 530288000467 3798 Surprise Lake Middle School   Regular School No Middle 06 07 2020   grade_7 123 18 64   3 28     16   37   154 135 0   24   5   144       18.0 289 123 18 64   3 28     16   37   154 135 0   24 5 144     18 289
462047 WA Pierce   school 5301410 27400   Clover Park School District 530141000263 3602 Lochburn Middle School   Regular School No 2.0 06 08 2015   grade_7 39 15 75   0 11     15   21   98 78 0   24   12   158       5.0 176 39 15 75   0 11     15   21   98 78 0   24 12 158     5 176
464782 WA King   school 5303540 17401   Highline School District 530354000543 3333 Pacific Middle School   Regular School No 2.0 07 08 2015   grade_7 115 38 98   4 31     15   31   186 146 0   32   12   206       4.0 332 115 38 98   4 31     15   31   186 146 0   32 12 206     4 332
465604 WA King   school 5303960 17415   Kent School District 530396000626 3233 Meridian Middle School   Regular School No 2.0 07 08 2015   grade_7 84 48 73   3 92     15   24   175 164 0   59   7   220       17.0 339 84 48 73   3 92     15   24   175 164 0   59 7 220     17 339
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
520022 WA King   school 5300300 17408   Auburn School District 530030000038 3169 Olympic Middle School   Regular School No 2 06 08 2016   grade_7 84 18 79   15 14     15   16   137 104 0   44   5   186       7.0 241 84 18 79   15 14     15   16   137 104 0   44 5 186     7 241
617385 WA King   school 5300300 17408   Auburn School District 530030000038 3169 Olympic Middle School   Regular School No Middle 06 08 2017   grade_7 84 16 87   7 14     15   26   126 123 0   58   3   192       5.0 249 84 16 87   7 14     15   26   126 123 0   58 3 192     5 249
2417476 WA Pierce   school 5302880 27417   Fife School District 530288000467 3798 Surprise Lake Middle School   Regular School No Middle 06 07 2019   grade_7 141 18 69   3 25     15   41   150 162 0   25   4   143       6.0 312 141 18 69   3 25     15   41   150 162 0   25 4 143     6 312
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
2457881 WA King   school 5300300 17408   Auburn School District 530030001443 4462 Mt Baker Middle School   Regular School No Middle 06 08 2018   grade_7 104 24 119   1 44     15   28   178 157 0   43   1   186       5.0 335 104 24 119   1 44     15   28   178 157 0   43 1 186     5 335
2462488 WA King   school 5303540 17401   Highline School District 530354000543 3333 Pacific Middle School   Regular School No Middle 07 08 2018   grade_7 90 51 113   4 32     15   31   163 173 0   53   20   239       10.0 336 90 51 113   4 32     15   31   163 173 0   53 20 239     10 336
2571307 WA Pierce   school 5300480 27403   Bethel School District 530048000120 3250 Bethel Middle School   Regular School No Middle 06 08 2020   grade_7 99 14 64   3 6     15   40   128 113 0   13   9   150       5.0 241 99 14 64   3 6     15   40   128 113 0   13 9 150     5 241
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
2936085 WA King   school 5303540 17401   Highline School District 530354000524 3098 Chinook Middle School   Regular School No Middle 06 08 2021   grade_7 21 62 107   0 32     15   9   129 117 0   63   5   187       0.0 246 21 62 107   0 32     15   9   129 117 0   63 5 187     0 246
2944161 WA Spokane   school 5308250 32081   Spokane School District 530825001408 3257 Shaw Middle School   Regular School No Middle 06 08 2021   grade_7 146 8 40   5 4     15   55   150 123 0   28   16   232       8.0 273 146 8 40   5 4     15   55   150 123 0   28 16 232     8 273
460694 WA Pierce   school 5300480 27403   Bethel School District 530048001819 4186 Cedarcrest Middle School   Regular School No 4.0 06 12 2015   grade_7 100 30 26   1 15     14   17   108 95 0   0   2   138       6.0 203 100 30 26   1 15     14   17   108 95 0   0 2 138     6 203
464018 WA King   school 5302820 17210   Federal Way School District 530282000448 3626 Sacajawea Middle School   Regular School No 2.0 06 08 2015   grade_7 67 23 78   0 23     14   26   112 119 0   29   1   149       3.0 231 67 23 78   0 23     14   26   112 119 0   29 1 149     3 231
473228 WA Pierce   school 5308700 27010   Tacoma School District 530870001454 3054 Baker   Regular School No 2.0 06 08 2015   grade_7 69 37 64   5 47     14   11   118 129 0   28   9   190       14.0 247 69 37 64   5 47     14   11   118 129 0   28 9 190     14 247
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
528108 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585000606 4409 Komachin Middle School   Regular School No 2 07 08 2016   grade_7 206 15 59   2 27     14   42   181 184 0   10   22   183       25.0 365 206 15 59   2 27     14   42   181 184 0   10 22 183     25 365
533370 WA Pierce   school 5308700 27010   Tacoma School District 530870001471 2377 Gray   Regular School No 2 06 08 2016   grade_7 58 49 54   1 21     14   8   99 106 0   22   14   148       2.0 205 58 49 54   1 21     14   8   99 106 0   22 14 148     2 205
619406 WA Pierce   school 5301410 27400   Clover Park School District 530141000263 3602 Lochburn Middle School   Regular School No Middle 06 08 2017   grade_7 28 30 70   1 10     14   30   87 96 0   30   18   167       0.0 183 28 30 70   1 10     14   30   87 96 0   30 18 167     0 183
2417267 WA King   school 5302820 17210   Federal Way School District 530282000448 3626 Sacajawea Middle School   Regular School No Middle 06 08 2019   grade_7 56 41 104   1 23     14   14   120 132 1   52   6   183       4.0 253 56 41 104   1 23     14   14   120 132 1   52 6 183     4 253

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