Data source: Big Local News · About: Big Local

4,566 rows where grade = "grade_7" and state = "WA" sorted by native_american_alaskan_native 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
466864 WA Snohomish   school 5304860 31025   Marysville School District 530486000736 3355 Marysville Middle School   Regular School No 2.0 06 08 2015   grade_7 173 5 57   9 13     2   26   151 134 0   23   4   165       11.0 285 173 5 57   9 13     2   26   151 134 0   23 4 165     11 285
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
527760 WA Okanogan   school 5305550 24014   Nespelem School District #14 530555000832 2494 Nespelem Elementary   Regular School No 1 PK 08 2016   grade_7 0 0 1   9 0     0   0   8 2 0   7   0   10       0.0 10 0 0 1   9 0     0   0   8 2 0   7 0 10     0 10
527852 WA Grays Harbor   school 5305700 14064   North Beach School District No. 64 530570002039 3788 North Beach Junior High School   Regular School No 2 07 08 2016   grade_7 25 1 5   9 0     0   2   24 18 0   0   6   34       0.0 42 25 1 5   9 0     0   2   24 18 0   0 6 34     0 42
529553 WA Clallam   school 5306820 5121   Port Angeles School District 530682001004 3318 Stevens Middle School   Regular School No 2 07 08 2016   grade_7 194 2 23   9 4     0   30   129 133 0   0   4   147       16.0 262 194 2 23   9 4     0   30   129 133 0   0 4 147     16 262
624090 WA Stevens   school 5304830 33207   Mary Walker School District 530483000732 3894 Springdale Middle School   Regular School No Middle 06 08 2017   grade_7 25 0 1   9 0     0   2   25 12 0   2   1   32       0.0 37 25 0 1   9 0     0   2   25 12 0   2 1 32     0 37
626355 WA Okanogan   school 5306220 24019   Omak School District 530622003307 5196 Washington Virtual Academy Omak Middle School   Regular School No Middle 06 08 2017   grade_7 363 37 33   9 20     9   4   225 250 0   10   0   158       28.0 475 363 37 33   9 20     9   4   225 250 0   10 0 158     28 475
628292 WA King   school 5307710 17001   Seattle School District No. 1 530771001913 2839 David T. Denny International Middle School   Regular School No Middle 06 08 2017   grade_7 52 64 71   9 37     2   20   131 124 0   50   28   187       4.0 255 52 64 71   9 37     2   20   131 124 0   50 28 187     4 255
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
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
2423783 WA Thurston   school 5307470 34401   Rochester School District 530747001118 3067 Rochester Middle School   Regular School No Middle 06 08 2019   grade_7 123 0 35   9 1     0   19   99 88 0   4   7   91       10.0 187 123 0 35   9 1     0   19   99 88 0   4 7 91     10 187
2457604 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000009 2305 Miller Junior High   Regular School No Middle 07 08 2018   grade_7 127 0 80   9 3     0   16   120 115 0   28   13   176       9.0 235 127 0 80   9 3     0   16   120 115 0   28 13 176     9 235
2464441 WA Snohomish   school 5304860 31025   Marysville School District 530486002425 4357 Cedarcrest School   Regular School No Middle 06 08 2018   grade_7 143 2 58   9 19     3   29   152 111 0   27   5   142       10.0 263 143 2 58   9 19     3   29   152 111 0   27 5 142     10 263
2465137 WA Whatcom   school 5305310 37507   Mount Baker School District 530531002608 3003 Mount Baker Junior High   Regular School No Middle 07 08 2018   grade_7 125 4 20   9 1     0   8   95 72 0   22   2   123       4.0 167 125 4 20   9 1     0   8   95 72 0   22 2 123     4 167
2466353 WA Okanogan   school 5306150 24105   Okanogan School District 530615003144 2245 Okanogan Middle School   Regular School No Middle 06 08 2018   grade_7 60 1 24   9 1     0   4   52 47 0   9   4   54       5.0 99 60 1 24   9 1     0   4   52 47 0   9 4 54     5 99
2471939 WA Thurston   school   34901   WA HE LUT Indian School Agency   5496 Wa He Lut Indian School             2018   grade_7 0 0 0   9 0     0   1   5 5 0   0   0   9       0.0 10 0 0 0   9 0     0   1   5 5 0   0 0 9     0 10
2580186 WA Pierce   school 5306960 27003   Puyallup School District 530696001022 3447 Aylen Jr High   Regular School No Middle 07 09 2020   grade_7 152 8 50   9 11     1   35   156 110 0   18   7   106       24.0 266 152 8 50   9 11     1   35   156 110 0   18 7 106     24 266
2582212 WA Mason   school 5307900 23309   Shelton School District 530790002353 4363 Oakland Bay Junior High School   Regular School No Middle 07 08 2020   grade_7 145 3 104   9 0     1   22   143 141 0   51   33   201       26.0 284 145 3 104   9 0     1   22   143 141 0   51 33 201     26 284
2584075 WA Grays Harbor   school 5308730 14077   Taholah School District 530873002956 5032 Taholah Elementary & Middle School   Regular School No Elementary KG 08 2020   grade_7 0 0 3   9 0     0   2   5 9 0   0   2   8       0.0 14 0 0 3   9 0     0   2   5 9 0   0 2 8     0 14
2942155 WA Thurston   school 5307470 34401   Rochester School District 530747001118 3067 Rochester Middle School   Regular School No Middle 06 08 2021   grade_7 98 1 38   9 3     1   14   90 74 0   7   1   88       8.0 164 98 1 38   9 3     1   14   90 74 0   7 1 88     8 164
2943005 WA Skagit   school 5307740 29101   Sedro-Woolley School District 530774001273 3181 Cascade Middle School   Regular School No Middle 07 08 2021   grade_7 223 1 70   9 3     2   21   154 176 0   17   8   162       21.0 330 223 1 70   9 3     2   21   154 176 0   17 8 162     21 330
2945086 WA Grays Harbor   school 5308730 14077   Taholah School District 530873002956 5032 Taholah Elementary & Middle School   Regular School No Elementary KG 08 2021   grade_7 0 0 1   9 0     0   1   5 6 0   0   1   7       0.0 11 0 0 1   9 0     0   1   5 6 0   0 1 7     0 11
466803 WA Snohomish   school 5304860 31025   Marysville School District 530486002425 4357 Cedarcrest School   Regular School No 2.0 06 08 2015   grade_7 155 5 83   8 16     1   29   144 153 0   20   3   150       6.0 297 155 5 83   8 16     1   29   144 153 0   20 3 150     6 297
467528 WA Whatcom   school 5305310 37507   Mount Baker School District 530531002608 3003 Mount Baker Junior High   Regular School No 2.0 07 08 2015   grade_7 88 0 12   8 2     0   4   63 51 0   7   2   70       2.0 114 88 0 12   8 2     0   4   63 51 0   7 2 70     2 114
468186 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585000862 3361 Chinook Middle School   Regular School No 2.0 06 08 2015   grade_7 173 12 68   8 31     2   35   171 158 0   19   13   173       20.0 329 173 12 68   8 31     2   35   171 158 0   19 13 173     20 329
468824 WA Okanogan   school 5306150 24105   Okanogan School District 530615003144 2245 Okanogan Middle School   Regular School No 2.0 06 08 2015   grade_7 55 0 21   8 0     0   10   54 40 0   6   2   57       0.0 94 55 0 21   8 0     0   10   54 40 0   6 2 57     0 94
626334 WA Okanogan   school   24019   Omak School District   4278 Paschal Sherman             2017   grade_7 0 0 0   8 0     0   0   5 3 0   0   0   8       0.0 8 0 0 0   8 0     0   0   5 3 0   0 0 8     0 8
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
632278 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001653 4040 West Valley Jr High   Regular School No Middle 07 08 2017   grade_7 260 3 116   8 8     0   12   221 186 0   24   4   197       18.0 407 260 3 116   8 8     0   12   221 186 0   24 4 197     18 407
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
2422761 WA Spokane   school 5300339 32907   PRIDE Prep Charter School District 530033903495 5339 PRIDE Prep School   Regular School Yes High 06 12 2019   grade_7 77 12 0   8 5     1   0   58 45 0   0   1   55       10.0 103 77 12 0   8 5     1   0   58 45 0   0 1 55     10 103
2422916 WA Pierce   school 5306960 27003   Puyallup School District 530696003260 5142 Glacier View Junior High   Regular School No Middle 07 09 2019   grade_7 170 11 49   8 10     4   44   147 149 0   9   2   97       25.0 296 170 11 49   8 10     4   44   147 149 0   9 2 97     25 296
2424620 WA Skagit   school 5307740 29101   Sedro-Woolley School District 530774001273 3181 Cascade Middle School   Regular School No Middle 07 08 2019   grade_7 249 1 83   8 0     2   15   192 166 0   27   12   195       41.0 358 249 1 83   8 0     2   15   192 166 0   27 12 195     41 358
2425763 WA Spokane   school 5308250 32081   Spokane School District 530825001408 3257 Shaw Middle School   Regular School No Middle 06 08 2019   grade_7 154 20 45   8 2     13   56   159 139 0   39   30   259       44.0 298 154 20 45   8 2     13   56   159 139 0   39 30 259     44 298
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
2462603 WA Grays Harbor   school 5303660 14028   Hoquiam School District 530366000565 2391 Hoquiam Middle School   Regular School No Middle 06 08 2018   grade_7 95 2 15   8 2     0   8   70 60 0   3   4   88       2.0 130 95 2 15   8 2     0   8   70 60 0   3 4 88     2 130
2465464 WA Okanogan   school 5305550 24014   Nespelem School District #14 530555000832 2494 Nespelem Elementary   Regular School No Elementary PK 08 2018   grade_7 0 0 0   8 0     0   0   5 3 0   5   0   8       0.0 8 0 0 0   8 0     0   0   5 3 0   5 0 8     0 8
2465651 WA Kitsap   school 5305760 18400   North Kitsap School District 530576002324 4359 Kingston Middle School   Regular School No Middle 06 08 2018   grade_7 106 2 18   8 3     1   18   84 72 0   2   6   65       8.0 156 106 2 18   8 3     1   18   84 72 0   2 6 65     8 156
2466542 WA Okanogan   school   24019   Omak School District   4278 Paschal Sherman             2018   grade_7 1 0 0   8 0     0   0   5 4 0   0   2   9       0.0 9 1 0 0   8 0     0   0   5 4 0   0 2 9     0 9
2575417 WA Mason   school 5303600 23404   Hood Canal School District 530360003666 5515 Hood Canal Middle School (Closed after 2019-2020 school year)   Regular School No Middle 06 08 2020   grade_7 21 0 6   8 0     0   4   24 15 0   2   2   29       3.0 39 21 0 6   8 0     0   4   24 15 0   2 2 29     3 39
2585385 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001653 4040 West Valley Jr High   Regular School No Middle 07 08 2020   grade_7 229 7 165   8 13     0   16   218 219 1   29   4   235       7.0 438 229 7 165   8 13     0   16   218 219 1   29 4 235     7 438
2933941 WA Pend Oreille   school 5301920 26059   Cusick School District 530192000297 2423 Cusick Jr Sr High School   Regular School No High 06 12 2021   grade_7 6 0 1   8 0     0   3   11 7 0   0   3   15       0.0 18 6 0 1   8 0     0   3   11 7 0   0 3 15     0 18
2938187 WA Snohomish   school 5304860 31025   Marysville School District 530486002475 1656 10th Street School   Regular School No Middle 06 08 2021   grade_7 33 2 9   8 3     0   4   21 38 0   2   0   25       6.0 59 33 2 9   8 3     0   4   21 38 0   2 0 25     6 59
2940190 WA Okanogan   school 5306150 24105   Okanogan School District 530615003144 2245 Okanogan Middle School   Regular School No Middle 06 08 2021   grade_7 51 0 27   8 0     0   5   47 44 0   8   1   53       4.0 91 51 0 27   8 0     0   5   47 44 0   8 1 53     4 91
2941480 WA Clallam   school   5903   Quileute Tribal School District   5430 Quileute Tribal School             2021   grade_7 1 0 2   8 0     0   0   7 4 0   0   0   8       0.0 11 1 0 2   8 0     0   0   7 4 0   0 0 8     0 11
2427614 WA Yakima   school 5309480 39207   Wapato School District 530948001615 2131 Wapato Middle School   Regular School No Middle 06 08 2019   grade_7 7 0 227   73 7     0   10   163 161 0   159   8   303       4.0 324 7 0 227   73 7     0   10   163 161 0   159 8 303     4 324
465832 WA Skagit   school 5304110 29311   La Conner School District 530411001905 3900 La Conner Middle   Regular School No 2.0 06 08 2015   grade_7 24 0 7   7 1     0   1   19 21 0   3   0   20       2.0 40 24 0 7   7 1     0   1   19 21 0   3 0 20     2 40
468258 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585000868 3611 Nisqually Middle School   Regular School No 2.0 06 08 2015   grade_7 80 14 66   7 14     10   41   129 103 0   8   10   136       8.0 232 80 14 66   7 14     10   41   129 103 0   8 10 136     8 232
471698 WA Clallam   school 5307830 5323   Sequim School District 530783002617 4519 Sequim Middle School   Regular School No 2.0 06 08 2015   grade_7 152 0 18   7 5     0   10   97 95 0   4   7   99       0.0 192 152 0 18   7 5     0   10   97 95 0   4 7 99     0 192
471952 WA Snohomish   school 5308020 31201   Snohomish School District 530802000540 4395 Centennial Middle School   Regular School No 2.0 07 08 2015   grade_7 295 4 34   7 2     1   19   192 170 0   8   7   131       11.0 362 295 4 34   7 2     1   19   192 170 0   8 7 131     11 362
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
473215 WA Pierce   school 5308700 27010   Tacoma School District 530870003155 4575 Angelo Giaudrone Middle School   Regular School No 2.0 06 08 2015   grade_7 64 47 39   7 24     2   9   101 91 0   14   4   158       6.0 192 64 47 39   7 24     2   9   101 91 0   14 4 158     6 192
520605 WA Whatcom   school 5300420 37501   Bellingham School District 530042000114 3201 Shuksan Middle School   Regular School No 2 06 08 2016   grade_7 95 3 57   7 36     2   18   103 115 0   20   10   147       7.0 218 95 3 57   7 36     2   18   103 115 0   20 10 147     7 218
520739 WA Pierce   school 5300480 27403   Bethel School District 530048000595 4407 Frontier Middle School   Regular School No 2 06 08 2016   grade_7 174 9 25   7 13     2   14   125 119 0   2   2   95       13.0 244 174 9 25   7 13     2   14   125 119 0   2 2 95     13 244
528714 WA Okanogan   school 5306150 24105   Okanogan School District 530615003144 2245 Okanogan Middle School   Regular School No 2 06 08 2016   grade_7 56 0 20   7 1     0   4   39 49 0   4   2   52       2.0 88 56 0 20   7 1     0   4   39 49 0   4 2 52     2 88
530010 WA Clallam   school 5307020 5402   Quillayute Valley School District 530702001047 2349 Forks High School   Regular School No 3 07 12 2016   grade_7 38 1 24   7 1     0   5   49 27 0   9   3   49       2.0 76 38 1 24   7 1     0   5   49 27 0   9 3 49     2 76
530877 WA King   school 5307710 17001   Seattle School District No. 1 530771001913 2839 David T. Denny International Middle School   Regular School No 2 06 08 2016   grade_7 70 70 84   7 43     4   13   159 132 0   26   25   211       4.0 291 70 70 84   7 43     4   13   159 132 0   26 25 211     4 291
533337 WA Pierce   school 5308700 27010   Tacoma School District 530870003299 5170 First Creek Middle School   Regular School No 2 06 08 2016   grade_7 40 63 60   7 44     7   11   119 113 0   21   7   178       18.0 232 40 63 60   7 44     7   11   119 113 0   21 7 178     18 232
535054 WA Lincoln   school 5309840 22200   Wilbur School District 530984001668 3289 Wilbur Secondary School   Regular School No 3 07 12 2016   grade_7 18 0 1   7 0     0   2   15 13 0   0   0   16       0.0 28 18 0 1   7 0     0   2   15 13 0   0 0 16     0 28
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
622112 WA King   school 5303540 17401   Highline School District 530354000543 3333 Pacific Middle School   Regular School No Middle 07 08 2017   grade_7 80 48 93   7 29     10   23   154 136 0   47   16   172       10.0 290 80 48 93   7 29     10   23   154 136 0   47 16 172     10 290
622156 WA King   school 5303540 17401   Highline School District 530354000554 2927 Sylvester Middle School   Regular School No Middle 07 08 2017   grade_7 87 29 136   7 52     13   22   183 163 0   78   13   251       2.0 346 87 29 136   7 52     13   22   183 163 0   78 13 251     2 346
624853 WA Whatcom   school 5305310 37507   Mount Baker School District 530531002608 3003 Mount Baker Junior High   Regular School No Middle 07 08 2017   grade_7 117 0 12   7 1     1   8   71 75 0   7   3   99       1.0 146 117 0 12   7 1     1   8   71 75 0   7 3 99     1 146
625189 WA Okanogan   school 5305550 24014   Nespelem School District #14 530555000832 2494 Nespelem Elementary   Regular School No Elementary PK 08 2017   grade_7 0 0 0   7 0     0   0   5 2 0   6   0   7       0.0 7 0 0 0   7 0     0   0   5 2 0   6 0 7     0 7
627456 WA Clallam   school 5307020 5402   Quillayute Valley School District 530702001047 2349 Forks High School   Regular School No High 07 12 2017   grade_7 32 0 28   7 1     0   7   33 42 0   12   0   52       1.0 75 32 0 28   7 1     0   7   33 42 0   12 0 52     1 75
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
632742 WA Thurston   school 5310140 34002   Yelm School District 531014003068 5052 Ridgeline Middle School   Regular School No Other 07 09 2017   grade_7 148 0 32   7 1     1   11   116 84 0   1   1   83       10.0 200 148 0 32   7 1     1   11   116 84 0   1 1 83     10 200
632796 WA Yakima   school 5310170 39205   Zillah School District 531017002502 4481 Zillah Middle School   Regular School No Middle 07 08 2017   grade_7 45 0 56   7 0     0   5   69 44 0   14   2   71       2.0 113 45 0 56   7 0     0   5   69 44 0   14 2 71     2 113
2421892 WA Okanogan   school 5306150 24105   Okanogan School District 530615003144 2245 Okanogan Middle School   Regular School No Middle 06 08 2019   grade_7 37 0 26   7 0     0   6   41 35 0   8   2   42       3.0 76 37 0 26   7 0     0   6   41 35 0   8 2 42     3 76
2422099 WA Okanogan   school 5306220 24019   Omak School District 530622003307 5196 Washington Virtual Academy Omak Middle School   Regular School No Middle 06 08 2019   grade_7 326 33 56   7 20     5   2   222 226 1   15   0   225       51.0 449 326 33 56   7 20     5   2   222 226 1   15 0 225     51 449
2428255 WA Yakima   school 5310110 39007   Yakima School District 531011001691 2410 Franklin Middle School   Regular School No Middle 06 08 2019   grade_7 46 0 215   7 0     0   5   127 146 0   73   10   233       8.0 273 46 0 215   7 0     0   5   127 146 0   73 10 233     8 273
2460214 WA Pend Oreille   school 5301920 26059   Cusick School District 530192000297 2423 Cusick Jr Sr High School   Regular School No High 06 12 2018   grade_7 9 0 0   7 0     0   1   9 8 0   0   3   12       0.0 17 9 0 0   7 0     0   1   9 8 0   0 3 12     0 17
2465541 WA Whatcom   school 5305670 37506   Nooksack Valley School District 530567000838 2687 Nooksack Valley Middle School   Regular School No Middle 06 08 2018   grade_7 70 1 35   7 0     1   5   60 59 0   10   3   67       12.0 119 70 1 35   7 0     1   5   60 59 0   10 3 67     12 119
2466252 WA Grays Harbor   school 5306000 14400   Oakville School District 530600000909 2283 Oakville High School   Regular School No High 06 12 2018   grade_7 14 0 1   7 0     0   0   11 11 0   1   0   17       0.0 22 14 0 1   7 0     0   0   11 11 0   1 0 17     0 22
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
2472959 WA Thurston   school 5310140 34002   Yelm School District 531014001717 2481 Yelm Middle School   Regular School No Middle 06 08 2018   grade_7 155 2 45   7 5     1   24   116 123 0   4   3   119       10.0 239 155 2 45   7 5     1   24   116 123 0   4 3 119     10 239
2572417 WA Spokane   school 5301230 32360   Cheney School District 530123003428 5269 Westwood Middle School   Regular School No Middle 06 08 2020   grade_7 148 1 21   7 6     8   12   108 95 0   12   4   114       9.0 203 148 1 21   7 6     8   12   108 95 0   12 4 114     9 203
2576535 WA Snohomish   school 5304200 31004   Lake Stevens School District 530420001906 4139 North Lake Middle School   Regular School No Middle 06 07 2020   grade_7 299 9 48   7 18     2   38   220 201 0   9   6   115       36.0 421 299 9 48   7 18     2   38   220 201 0   9 6 115     36 421
2577329 WA Snohomish   school 5304860 31025   Marysville School District 530486002425 4357 Cedarcrest School   Regular School No Middle 06 08 2020   grade_7 125 6 83   7 15     9   37   143 139 0   33   11   162       6.0 282 125 6 83   7 15     9   37   143 139 0   33 11 162     6 282
2578009 WA Whatcom   school 5305310 37507   Mount Baker School District 530531002608 3003 Mount Baker Junior High   Regular School No Middle 07 08 2020   grade_7 102 2 19   7 1     1   15   75 72 0   14   4   95       12.0 147 102 2 19   7 1     1   15   75 72 0   14 4 95     12 147
2578711 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585000868 3611 Nisqually Middle School   Regular School No Middle 06 08 2020   grade_7 142 16 67   7 15     11   51   158 151 0   15   16   159       17.0 309 142 16 67   7 15     11   51   158 151 0   15 16 159     17 309
2933270 WA Spokane   school 5301230 32360   Cheney School District 530123000224 2447 Cheney Middle School   Regular School No Middle 06 08 2021   grade_7 149 4 33   7 2     0   15   111 99 0   4   6   105       3.0 210 149 4 33   7 2     0   15   111 99 0   4 6 105     3 210
2936319 WA Grays Harbor   school 5303660 14028   Hoquiam School District 530366000565 2391 Hoquiam Middle School   Regular School No Middle 06 08 2021   grade_7 50 1 23   7 0     0   10   44 47 0   5   2   73       2.0 91 50 1 23   7 0     0   10   44 47 0   5 2 73     2 91
2936347 WA Ferry   school 5300002 10070   Inchelium School District 530000202870 4214 Inchelium Middle School   Regular School No Middle 06 08 2021   grade_7 2 0 0   7 0     1   5   5 10 0   5   0   12       0.0 15 2 0 0   7 0     1   5   5 10 0   5 0 12     0 15
2939285 WA Whatcom   school 5305670 37506   Nooksack Valley School District 530567000838 2687 Nooksack Valley Middle School   Regular School No Middle 06 08 2021   grade_7 81 0 53   7 2     0   10   81 72 0   17   7   78       12.0 153 81 0 53   7 2     0   10   81 72 0   17 7 78     12 153
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
534593 WA Yakima   school 5309480 39207   Wapato School District 530948001615 2131 Wapato Middle School   Regular School No 2 06 08 2016   grade_7 12 0 188   67 2     0   7   146 130 0   62   12   265       0.0 276 12 0 188   67 2     0   7   146 130 0   62 12 265     0 276
2946072 WA Yakima   school 5309480 39207   Wapato School District 530948001615 2131 Wapato Middle School   Regular School No Middle 06 08 2021   grade_7 3 0 214   64 3     0   17   169 132 0   143   5   272       7.0 301 3 0 214   64 3     0   17   169 132 0   143 5 272     7 301
474634 WA Yakima   school 5309480 39207   Wapato School District 530948001615 2131 Wapato Middle School   Regular School No 2.0 06 08 2015   grade_7 9 0 171   62 6     1   10   131 128 0   66   4   255       4.0 259 9 0 171   62 6     1   10   131 128 0   66 4 255     4 259
469771 WA Pierce   school   27003   Puyallup School District   4110 Chief Leschi Schools(Closed)             2015   grade_7 0 0 3   61 0     0   2   30 36 0   0   7   36       0.0 66 0 0 3   61 0     0   2   30 36 0   0 7 36     0 66
2472127 WA Yakima   school 5309480 39207   Wapato School District 530948001615 2131 Wapato Middle School   Regular School No Middle 06 08 2018   grade_7 7 0 185   60 4     0   8   154 110 0   145   22   251       1.0 264 7 0 185   60 4     0   8   154 110 0   145 22 251     1 264
460871 WA Pierce   school 5300480 27403   Bethel School District 530048000128 3751 Spanaway Middle School   Regular School No 2.0 06 09 2015   grade_7 91 32 42   6 20     11   15   118 99 0   13   3   144       8.0 217 91 32 42   6 20     11   15   118 99 0   13 3 144     8 217
461892 WA Asotin   school 5301320 2250   Clarkston School District 530132000237 2501 Lincoln Middle School   Regular School No 2.0 07 08 2015   grade_7 176 1 12   6 1     0   6   91 111 0   1   11   117       5.0 202 176 1 12   6 1     0   6   91 111 0   1 11 117     5 202
463190 WA King   school 5300001 17216   Enumclaw School District 530000102054 4210 Enumclaw Middle School   Regular School No 2.0 06 08 2015   grade_7 120 3 9   6 0     0   5   76 67 0   2   3   56       2.0 143 120 3 9   6 0     0   5   76 67 0   2 3 56     2 143
464866 WA Mason   school 5303600 23404   Hood Canal School District 530360000561 2310 Hood Canal Elementary School   Regular School No 1.0 PK 08 2015   grade_7 11 0 1   6 0     0   11   12 17 0   0   0   28       0.0 29 11 0 1   6 0     0   11   12 17 0   0 0 28     0 29
467944 WA Grays Harbor   school 5305700 14064   North Beach School District No. 64 530570002039 3788 North Beach Junior High School   Regular School No 2.0 06 08 2015   grade_7 34 0 4   6 0     0   1   22 23 0   0   5   35       1.0 45 34 0 4   6 0     0   1   22 23 0   0 5 35     1 45
469017 WA Okanogan   school   24019   Omak School District   4278 Paschal Sherman             2015   grade_7 1 0 0   6 0     0   1   3 5 0   0   0   8       0.0 8 1 0 0   6 0     0   1   3 5 0   0 0 8     0 8
470077 WA Clallam   school 5307020 5402   Quillayute Valley School District 530702001047 2349 Forks High School   Regular School No 3.0 07 12 2015   grade_7 39 1 23   6 2     0   7   35 43 0   3   3   52       5.0 78 39 1 23   6 2     0   7   35 43 0   3 3 52     5 78
471510 WA King   school 5307710 17001   Seattle School District No. 1 530771001264 3277 Whitman Middle School   Regular School No 1.0 KG 08 2015   grade_7 187 33 38   6 18     2   24   155 153 0   12   13   98       16.0 308 187 33 38   6 18     2   24   155 153 0   12 13 98     16 308
471762 WA Mason   school 5307900 23309   Shelton School District 530790002990 4586 Olympic Middle School   Regular School No 2.0 06 07 2015   grade_7 148 1 71   6 2     1   17   125 121 0   23   13   179       10.0 246 148 1 71   6 2     1   17   125 121 0   23 13 179     10 246

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