Data source: Big Local News · About: Big Local

4,566 rows where grade = "grade_7" and state = "WA" sorted by homeless 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
462839 WA Snohomish   school 5302400 31015   Edmonds School District 530240000337 3754 College Place Middle School   Regular School No 2.0 07 08 2015   grade_7 115 25 63   2 19     0   27   124 127 0   37   9   128       9.0 251 115 25 63   2 19     0   27   124 127 0   37 9 128     9 251
463614 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000415 3320 Covington Middle School   Regular School No 2.0 06 08 2015   grade_7 212 18 73   1 9     7   19   182 157 0   38   9   245       7.0 339 212 18 73   1 9     7   19   182 157 0   38 9 245     7 339
468207 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585000606 4409 Komachin Middle School   Regular School No 2.0 07 08 2015   grade_7 183 29 60   3 23     8   52   189 169 0   8   9   162       14.0 358 183 29 60   3 23     8   52   189 169 0   8 9 162     14 358
468773 WA Grays Harbor   school 5306090 14172   Ocosta School District 530609000914 3024 Ocosta Junior - Senior High   Regular School No 3.0 07 12 2015   grade_7 27 0 11   3 0     0   10   24 27 0   1   9   40       2.0 51 27 0 11   3 0     0   10   24 27 0   1 9 40     2 51
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
521467 WA Spokane   school 5301110 32356   Central Valley School District 530111000189 3260 Bowdish Middle School   Regular School No 2 06 08 2016   grade_7 139 7 15   3 2     0   15   99 82 0   3   9   104       16.0 181 139 7 15   3 2     0   15   99 82 0   3 9 104     16 181
521632 WA Lewis   school 5301140 21401   Centralia School District 530114000205 3240 Centralia Middle School   Regular School No 2 07 08 2016   grade_7 146 5 85   3 1     1   13   132 122 0   18   9   207       3.0 254 146 5 85   3 1     1   13   132 122 0   18 9 207     3 254
522491 WA Spokane   school 5302070 32414   Deer Park School District 530207000308 3261 Deer Park Middle School   Regular School No 2 04 08 2016   grade_7 139 3 12   2 3     0   0   88 71 0   0   9   98       8.0 159 139 3 12   2 3     0   0   88 71 0   0 9 98     8 159
522758 WA Snohomish   school 5302400 31015   Edmonds School District 530240000329 3560 Alderwood Middle School   Regular School No 2 07 08 2016   grade_7 135 25 77   1 71     2   37   182 166 0   26   9   179       15.0 348 135 25 77   1 71     2   37   182 166 0   26 9 179     15 348
523564 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000414 3785 Cascade Middle School   Regular School No 2 06 08 2016   grade_7 148 8 89   3 9     11   23   140 151 0   27   9   209       4.0 291 148 8 89   3 9     11   23   140 151 0   27 9 209     4 291
523628 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270002510 4498 Frontier Middle School   Regular School No 2 06 08 2016   grade_7 160 5 45   1 20     3   18   137 115 0   18   9   127       7.0 252 160 5 45   1 20     3   18   137 115 0   18 9 127     7 252
527779 WA Pend Oreille   school 5305610 26056   Newport School District 530561001911 3968 Sadie Halstead Middle School   Regular School No 2 05 08 2016   grade_7 87 0 2   0 0     0   6   44 51 0   0   9   61       3.0 95 87 0 2   0 0     0   6   44 51 0   0 9 61     3 95
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
531165 WA King   school 5307710 17001   Seattle School District No. 1 530771001207 2435 Madison Middle School   Regular School No 2 06 08 2016   grade_7 176 22 26   0 39     1   26   147 143 0   6   9   86       21.0 290 176 22 26   0 39     1   26   147 143 0   6 9 86     21 290
534786 WA Chelan   school 5309660 4246   Wenatchee School District 530966001635 3210 Pioneer Middle School   Regular School No 2 06 08 2016   grade_7 89 0 113   1 1     0   7   104 107 0   43   9   142       10.0 211 89 0 113   1 1     0   7   104 107 0   43 9 142     10 211
618007 WA Whatcom   school 5300420 37501   Bellingham School District 530042000117 2075 Whatcom Middle School   Regular School No Middle 06 08 2017   grade_7 175 2 20   2 5     0   15   124 95 0   4   9   69       15.0 219 175 2 20   2 5     0   15   124 95 0   4 9 69     15 219
622948 WA King   school 5303960 17415   Kent School District 530396000626 3233 Meridian Middle School   Regular School No Middle 07 08 2017   grade_7 73 42 75   1 84     11   23   159 150 0   60   9   194       14.0 309 73 42 75   1 84     11   23   159 150 0   60 9 194     14 309
624889 WA Skagit   school 5305400 29320   Mount Vernon School District 530540000810 3821 La Venture Middle School   Regular School No Middle 06 08 2017   grade_7 58 1 147   2 2     2   3   88 127 0   46   9   172       8.0 215 58 1 147   2 2     2   3   88 127 0   46 9 172     8 215
627676 WA King   school 5307230 17403   Renton School District 530723001079 3035 McKnight Middle School   Regular School No Middle 06 08 2017   grade_7 152 14 108   1 130     0   20   211 214 0   35   9   189       23.0 425 152 14 108   1 130     0   20   211 214 0   35 9 189     23 425
628576 WA King   school 5307710 17001   Seattle School District No. 1 530771001212 3517 McClure Middle School   Regular School No Middle 06 08 2017   grade_7 106 9 22   1 19     2   13   77 95 0   6   9   31       14.0 172 106 9 22   1 19     2   13   77 95 0   6 9 31     14 172
629564 WA Kitsap   school 5308160 18402   South Kitsap School District 530816001346 3680 Cedar Heights Middle School   Regular School No Middle 06 08 2017   grade_7 179 6 24   2 10     6   29   144 112 0   5   9   123       13.0 256 179 6 24   2 10     6   29   144 112 0   5 9 123     13 256
629870 WA Spokane   school 5308250 32081   Spokane School District 530825001411 3758 Garry Middle School   Regular School No Middle 07 08 2017   grade_7 178 17 36   7 7     9   50   163 141 0   27   9   247       20.0 304 178 17 36   7 7     9   50   163 141 0   27 9 247     20 304
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
630678 WA Pierce   school 5308700 27010   Tacoma School District 530870003299 5170 First Creek Middle School   Regular School No Middle 06 08 2017   grade_7 41 59 95   8 44     13   12   139 133 0   48   9   237       4.0 272 41 59 95   8 44     13   12   139 133 0   48 9 237     4 272
631063 WA Thurston   school 5308820 34402   Tenino School District 530882001523 3795 Tenino Middle School   Regular School No Middle 06 08 2017   grade_7 87 0 7   2 0     0   4   55 45 0   1   9   57       1.0 100 87 0 7   2 0     0   4   55 45 0   1 9 57     1 100
632121 WA Chelan   school 5309660 4246   Wenatchee School District 530966001635 3210 Pioneer Middle School   Regular School No Middle 06 08 2017   grade_7 98 0 103   1 1     0   4   107 100 0   46   9   126       12.0 207 98 0 103   1 1     0   4   107 100 0   46 9 126     12 207
2413253 WA King   school 5300300 17408   Auburn School District 530030000033 2394 Cascade Middle School   Regular School No Middle 06 08 2019   grade_7 109 32 82   1 24     13   27   148 140 0   43   9   189       8.0 288 109 32 82   1 24     13   27   148 140 0   43 9 189     8 288
2414398 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000157 3251 Lucille Umbarger Elementary   Regular School No Elementary 01 08 2019   grade_7 35 0 64   0 2     0   3   56 48 0   35   9   76       4.0 104 35 0 64   0 2     0   3   56 48 0   35 9 76     4 104
2415324 WA Pierce   school 5301410 27400   Clover Park School District 530141000257 3248 Hudtloff Middle School   Regular School No Middle 06 08 2019   grade_7 50 26 93   1 17     10   37   133 101 0   45   9   179       4.0 234 50 26 93   1 17     10   37   133 101 0   45 9 179     4 234
2416101 WA Snohomish   school 5302400 31015   Edmonds School District 530240000332 3650 Brier Terrace Middle School   Regular School No Middle 07 08 2019   grade_7 166 23 59   0 51     2   42   182 161 0   28   9   111       31.0 343 166 23 59   0 51     2   42   182 161 0   28 9 111     31 343
2416915 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270002510 4498 Frontier Middle School   Regular School No Middle 06 08 2019   grade_7 167 6 62   2 5     4   15   152 109 0   30   9   134       9.0 261 167 6 62   2 5     4   15   152 109 0   30 9 134     9 261
2417773 WA Pierce   school 5300338 27904   Green Dot Destiny 530033803553 5378 Destiny Charter Middle School (Closed after 2018-2019 school year)   Regular School Yes Middle 06 08 2019   grade_7 17 16 5   0 0     4   7   24 25 0   6   9   45       2.0 49 17 16 5   0 0     4   7   24 25 0   6 9 45     2 49
2420042 WA Snohomish   school 5304860 31025   Marysville School District 530486000736 3355 Marysville Middle School   Regular School No Middle 06 08 2019   grade_7 139 7 71   8 13     2   36   140 136 0   26   9   162       16.0 276 139 7 71   8 13     2   36   140 136 0   26 9 162     16 276
2424158 WA King   school 5307710 17001   Seattle School District No. 1 530771003467 5351 Jane Addams Middle School   Regular School No Middle 06 08 2019   grade_7 159 25 41   0 48     0   35   169 139 0   24   9   83       18.0 308 159 25 41   0 48     0   35   169 139 0   24 9 83     18 308
2424563 WA King   school 5307710 17001   Seattle School District No. 1 530771001259 4064 Washington Middle School   Regular School No Middle 06 08 2019   grade_7 77 49 23   0 37     3   32   117 104 0   16   9   83       7.0 221 77 49 23   0 37     3   32   117 104 0   16 9 83     7 221
2425746 WA Spokane   school 5308250 32081   Spokane School District 530825001405 3356 Sacajawea Middle School   Regular School No Middle 07 08 2019   grade_7 315 12 31   3 8     3   40   205 207 0   13   9   150       24.0 412 315 12 31   3 8     3   40   205 207 0   13 9 150     24 412
2427164 WA Clark   school 5309270 6037   Vancouver School District 530927002018 4503 Discovery Middle School   Regular School No Middle 06 08 2019   grade_7 100 9 100   1 3     2   19   111 123 0   41   9   173       10.0 234 100 9 100   1 3     2   19   111 123 0   41 9 173     10 234
2459500 WA Lewis   school 5301170 21302   Chehalis School District 530117002252 4311 Chehalis Middle School   Regular School No Middle 06 08 2018   grade_7 156 0 36   0 2     0   12   108 98 0   9   9   107       4.0 206 156 0 36   0 2     0   12   108 98 0   9 9 107     4 206
2465792 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585000606 4409 Komachin Middle School   Regular School No Middle 06 08 2018   grade_7 106 23 60   1 13     7   34   125 119 0   11   9   109       18.0 244 106 23 60   1 13     7   34   125 119 0   11 9 109     18 244
2466301 WA Grays Harbor   school 5306090 14172   Ocosta School District 530609000914 3024 Ocosta Junior - Senior High   Regular School No High 07 12 2018   grade_7 25 0 11   2 1     0   6   29 16 0   3   9   40       0.0 45 25 0 11   2 1     0   6   29 16 0   3 9 40     0 45
2468945 WA King   school 5307710 17001   Seattle School District No. 1 530771003620 5486 Robert Eagle Staff Middle School   Regular School No Middle 06 08 2018   grade_7 128 29 31   0 19     0   28   131 104 0   21   9   71       7.0 235 128 29 31   0 19     0   28   131 104 0   21 9 71     7 235
2471336 WA Okanogan   school 5308940 24404   Tonasket School District 530894001647 4196 Tonasket Middle School   Regular School No Middle 06 08 2018   grade_7 45 0 49   0 0     1   4   48 51 0   17   9   76       0.0 99 45 0 49   0 0     1   4   48 51 0   17 9 76     0 99
2570981 WA King   school 5300390 17405   Bellevue School District 530039000068 3166 Highland Middle School   Regular School No Middle 06 08 2020   grade_7 42 12 67   0 22     0   12   79 76 0   40   9   87       8.0 155 42 12 67   0 22     0   12   79 76 0   40 9 87     8 155
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
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
2572267 WA Lewis   school 5301140 21401   Centralia School District 530114000205 3240 Centralia Middle School   Regular School No Middle 07 08 2020   grade_7 135 0 114   0 2     0   16   123 145 0   27   9   220       10.0 268 135 0 114   0 2     0   16   123 145 0   27 9 220     10 268
2572319 WA Lewis   school 5301170 21302   Chehalis School District 530117002252 4311 Chehalis Middle School   Regular School No Middle 06 08 2020   grade_7 150 0 47   0 3     0   10   109 101 0   12   9   114       7.0 210 150 0 47   0 3     0   10   109 101 0   12 9 114     7 210
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
2577450 WA Snohomish   school 5304860 31025   Marysville School District 530486000735 2813 Totem Middle School   Regular School No Middle 06 08 2020   grade_7 83 5 31   29 18     0   20   84 102 0   36   9   114       6.0 186 83 5 31   29 18     0   20   84 102 0   36 9 114     6 186
2580062 WA Clallam   school 5306820 5121   Port Angeles School District 530682001004 3318 Stevens Middle School   Regular School No Middle 07 08 2020   grade_7 208 1 27   12 2     1   35   156 130 0   4   9   149       13.0 286 208 1 27   12 2     1   35   156 130 0   4 9 149     13 286
2580689 WA King   school 5307230 17403   Renton School District 530723002564 3280 Dimmitt Middle School   Regular School No Middle 06 08 2020   grade_7 14 61 62   3 59     5   13   99 118 0   34   9   161       13.0 217 14 61 62   3 59     5   13   99 118 0   34 9 161     13 217
2580845 WA King   school 5307230 17403   Renton School District 530723003603 5484 Vera Risdon Middle School   Regular School No Middle 06 08 2020   grade_7 98 19 78   0 85     1   30   160 151 0   31   9   115       18.0 311 98 19 78   0 85     1   30   160 151 0   31 9 115     18 311
2583909 WA Pierce   school 5308700 27010   Tacoma School District 530870001487 3244 Meeker   Regular School No Middle 06 08 2020   grade_7 110 16 37   1 24     4   28   106 114 0   16   9   77       10.0 220 110 16 37   1 24     4   28   106 114 0   16 9 77     10 220
2584038 WA Pierce   school 5308700 27010   Tacoma School District 530870001508 3116 Wainwright   Regular School No Middle 04 08 2020   grade_7 58 22 18   3 10     0   21   66 66 0   7   9   79       7.0 132 58 22 18   3 10     0   21   66 66 0   7 9 79     7 132
2584683 WA Clark   school 5309270 6037   Vancouver School District 530927001570 3543 Jason Lee Middle School   Regular School No Middle 06 08 2020   grade_7 133 10 54   3 12     5   19   111 125 0   15   9   114       10.0 236 133 10 54   3 12     5   19   111 125 0   15 9 114     10 236
2933452 WA Asotin   school 5301320 2250   Clarkston School District 530132000237 2501 Lincoln Middle School   Regular School No Middle 07 08 2021   grade_7 140 3 19   3 1     0   14   87 93 0   0   9   114       9.0 180 140 3 19   3 1     0   14   87 93 0   0 9 114     9 180
2934847 WA Snohomish   school 5302670 31002   Everett School District 530267000393 3752 Eisenhower Middle School   Regular School No Middle 06 08 2021   grade_7 174 24 66   0 51     2   23   154 185 1   23   9   151       16.0 340 174 24 66   0 51     2   23   154 185 1   23 9 151     16 340
2935072 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000414 3785 Cascade Middle School   Regular School No Middle 06 08 2021   grade_7 159 8 92   1 13     8   33   156 157 1   42   9   202       3.0 314 159 8 92   1 13     8   33   156 157 1   42 9 202     3 314
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
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
2935958 WA Snohomish   school 5303210 31332   Granite Falls School District 530321001770 4113 Granite Falls Middle School   Regular School No Middle 06 08 2021   grade_7 119 1 23   4 1     1   16   83 82 0   5   9   78       7.0 165 119 1 23   4 1     1   16   83 82 0   5 9 78     7 165
2936252 WA King   school 5303540 17401   Highline School District 530354000554 2927 Sylvester Middle School   Regular School No Middle 06 08 2021   grade_7 94 16 65   1 26     7   27   110 125 1   23   9   110       0.0 236 94 16 65   1 26     7   27   110 125 1   23 9 110     0 236
2938434 WA Spokane   school 5304920 32354   Mead School District 530492000748 3851 Northwood Middle School   Regular School No Middle 06 08 2021   grade_7 198 5 29   4 5     3   19   136 127 0   4   9   48       5.0 263 198 5 29   4 5     3   19   136 127 0   4 9 48     5 263
2939638 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585000868 3611 Nisqually Middle School   Regular School No Middle 06 08 2021   grade_7 141 17 74   7 17     4   53   178 135 0   17   9   162       12.0 313 141 17 74   7 17     4   53   178 135 0   17 9 162     12 313
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
2941101 WA Benton   school 5306900 3116   Prosser School District 530690001013 2906 Housel Middle School   Regular School No Middle 06 08 2021   grade_7 53 0 148   1 3     0   6   97 114 0   39   9   167       7.0 211 53 0 148   1 3     0   6   97 114 0   39 9 167     7 211
2941757 WA King   school 5307230 17403   Renton School District 530723001070 3434 Nelsen Middle School   Regular School No Middle 06 08 2021   grade_7 72 60 83   1 83     7   48   192 162 0   47   9   201       18.0 354 72 60 83   1 83     7   48   192 162 0   47 9 201     18 354
2944140 WA Spokane   school 5308250 32081   Spokane School District 530825001405 3356 Sacajawea Middle School   Regular School No Middle 07 08 2021   grade_7 297 14 42   2 8     2   62   222 205 0   15   9   145       16.0 427 297 14 42   2 8     2   62   222 205 0   15 9 145     16 427
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
2946339 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001645 3538 Centennial Middle School   Regular School No Middle 06 08 2021   grade_7 155 5 30   4 3     1   20   117 100 1   11   9   124       13.0 218 155 5 30   4 3     1   20   117 100 1   11 9 124     13 218
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
461484 WA Spokane   school 5301110 32356   Central Valley School District 530111000189 3260 Bowdish Middle School   Regular School No 2.0 06 08 2015   grade_7 136 3 6   1 3     1   15   85 80 0   3   8   90       14.0 165 136 3 6   1 3     1   15   85 80 0   3 8 90     14 165
461650 WA Lewis   school 5301140 21401   Centralia School District 530114000205 3240 Centralia Middle School   Regular School No 4.0 05 12 2015   grade_7 168 2 89   0 3     1   9   124 148 0   18   8   205       0.0 272 168 2 89   0 3     1   9   124 148 0   18 8 205     0 272
462992 WA Snohomish   school 5302400 31015   Edmonds School District 530240000351 3353 Meadowdale Middle School   Regular School No 2.0 07 08 2015   grade_7 184 21 71   0 44     2   25   187 160 0   29   8   160       18.0 347 184 21 71   0 44     2   25   187 160 0   29 8 160     18 347
463418 WA Snohomish   school 5302670 31002   Everett School District 530267002253 4334 Heatherwood Middle School   Regular School No 2.0 06 08 2015   grade_7 170 6 45   0 64     0   29   159 155 0   12   8   102       8.0 314 170 6 45   0 64     0   29   159 155 0   12 8 102     8 314
463601 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000414 3785 Cascade Middle School   Regular School No 2.0 06 08 2015   grade_7 175 13 59   3 14     9   19   146 146 0   21   8   205       6.0 292 175 13 59   3 14     9   19   146 146 0   21 8 205     6 292
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
467350 WA Grant   school 5305220 13161   Moses Lake School District 530522003482 5354 Endeavor Middle School   Regular School No 2.0 06 08 2015   grade_7 29 3 50   1 0     0   4   47 40 0   9   8   79       5.0 87 29 3 50   1 0     0   4   47 40 0   9 8 79     5 87
467591 WA Skagit   school 5305400 29320   Mount Vernon School District 530540002585 4511 Mount Baker Middle School   Regular School No 2.0 06 08 2015   grade_7 86 6 111   2 4     0   8   121 96 0   44   8   147       10.0 217 86 6 111   2 4     0   8   121 96 0   44 8 147     10 217
468975 WA Thurston   school 5306180 34111   Olympia School District 530618001737 4473 Thurgood Marshall Middle School   Regular School No 2.0 06 08 2015   grade_7 90 2 14   0 5     0   17   61 67 0   1   8   47       2.0 128 90 2 14   0 5     0   17   61 67 0   1 8 47     2 128
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
470704 WA Thurston   school 5307470 34401   Rochester School District 530747001118 3067 Rochester Middle School   Regular School No 2.0 06 08 2015   grade_7 104 2 37   5 2     0   6   83 73 0   1   8   90       7.0 156 104 2 37   5 2     0   6   83 73 0   1 8 90     7 156
471536 WA Skagit   school 5307740 29101   Sedro-Woolley School District 530774001273 3181 Cascade Middle School   Regular School No 2.0 07 08 2015   grade_7 199 4 67   4 2     1   8   151 134 0   20   8   188       14.0 285 199 4 67   4 2     1   8   151 134 0   20 8 188     14 285
473136 WA Pierce   school 5308610 27320   Sumner School District 530861002580 4502 Mountain View Middle School   Regular School No 2.0 06 09 2015   grade_7 181 4 18   2 2     2   15   113 111 0   4   8   79       13.0 224 181 4 18   2 2     2   15   113 111 0   4 8 79     13 224
473576 WA Pierce   school 5308700 27010   Tacoma School District 530870001504 2359 Stewart   Regular School No 2.0 06 08 2015   grade_7 55 37 32   5 16     4   3   84 68 0   11   8   132       2.0 152 55 37 32   5 16     4   3   84 68 0   11 8 132     2 152
473973 WA Thurston   school 5309100 34033   Tumwater School District 530910001734 4452 George Washington Bush Middle Sch   Regular School No 2.0 07 08 2015   grade_7 192 3 30   0 1     1   18   123 122 0   2   8   85       6.0 245 192 3 30   0 1     1   18   123 122 0   2 8 85     6 245
474203 WA Clark   school 5309270 6037   Vancouver School District 530927001562 3902 Gaiser Middle School   Regular School No 2.0 06 08 2015   grade_7 176 12 68   0 10     8   23   153 144 0   32   8   191       3.0 297 176 12 68   0 10     8   23   153 144 0   32 8 191     3 297
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
519860 WA Snohomish   school 5300240 31016   Arlington School District 530024000024 3124 Post Middle School   Regular School No 2 06 08 2016   grade_7 140 1 23   2 3     1   8   93 85 0   8   8   78       3.0 178 140 1 23   2 3     1   8   93 85 0   8 8 78     3 178
520662 WA Pierce   school 5300480 27403   Bethel School District 530048000120 3250 Bethel Middle School   Regular School No 2 06 08 2016   grade_7 125 15 32   3 14     8   21   115 103 0   6   8   125       5.0 218 125 15 32   3 14     8   21   115 103 0   6 8 125     5 218
520842 WA Pierce   school 5300480 27403   Bethel School District 530048000128 3751 Spanaway Middle School   Regular School No 2 06 09 2016   grade_7 94 31 48   9 14     13   29   121 117 0   17   8   156       7.0 238 94 31 48   9 14     13   29   121 117 0   17 8 156     7 238
521055 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000154 3603 Allen Elementary   Regular School No 1 KG 08 2016   grade_7 18 0 28   0 0     0   0   20 26 0   15   8   35       0.0 46 18 0 28   0 0     0   0   20 26 0   15 8 35     0 46
522642 WA Douglas   school 5302310 9206   Eastmont School District 530231002948 4590 Clovis Point Intermediate School   Regular School No 2 05 07 2016   grade_7 80 1 112   0 1     1   6   103 98 0   26   8   140       8.0 201 80 1 112   0 1     1   6   103 98 0   26 8 140     8 201
522966 WA Snohomish   school 5302400 31015   Edmonds School District 530240000351 3353 Meadowdale Middle School   Regular School No 2 07 08 2016   grade_7 178 27 90   3 47     4   37   203 183 0   34   8   175       19.0 386 178 27 90   3 47     4   37   203 183 0   34 8 175     19 386
526435 WA Cowlitz   school 5304470 8122   Longview School District 530447000705 2831 Monticello Middle School   Regular School No 2 06 08 2016   grade_7 99 1 41   5 7     0   13   88 78 0   9   8   125       2.0 166 99 1 41   5 7     0   13   88 78 0   9 8 125     2 166
526972 WA Spokane   school 5304920 32354   Mead School District 530492000747 3191 Mountainside Middle School   Regular School No 2 07 08 2016   grade_7 327 6 22   4 5     11   18   200 193 0   13   8   132       7.0 393 327 6 22   4 5     11   18   200 193 0   13 8 132     7 393
528560 WA Island   school 5305940 15201   Oak Harbor School District 530594000901 3939 North Whidbey Middle School   Regular School No 2 06 08 2016   grade_7 99 7 32   2 12     2   22   98 78 0   11   8   98       11.0 176 99 7 32   2 12     2   22   98 78 0   11 8 98     11 176
528626 WA Pacific   school 5306060 25101   Ocean Beach School District 530606000911 2517 Hilltop Elementary School   Regular School No 2 04 09 2016   grade_7 48 0 12   2 2     0   8   41 31 0   3   8   53       2.0 72 48 0 12   2 2     0   8   41 31 0   3 8 53     2 72
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
531197 WA King   school 5307710 17001   Seattle School District No. 1 530771001212 3517 McClure Middle School   Regular School No 2 06 08 2016   grade_7 128 11 16   1 13     1   9   97 82 0   8   8   31       12.0 179 128 11 16   1 13     1   9   97 82 0   8 8 31     12 179

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