Data source: Big Local News · About: Big Local

4,705 rows where grade = "grade_8" and state = "WA" sorted by non_binary_int descending

View and edit SQL

year

grade

  • grade_8 · 4,705
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
2584401 WA King   school 5308130 17406   Tukwila School District 530813003650 5536 Tukwila Online Learning   Alternative School No High 06 12 2020   grade_8 11 5 1   0 1     0   0   6 7 5   0   0   8       0.0 18 11 5 1   0 1     0   0   6 7 5   0 0 8     0 18
2941097 WA Spokane   school 5300339 32907   PRIDE Prep Charter School District 530033903495 5339 PRIDE Prep School   Regular School Yes High 06 12 2021   grade_8 103 3 19   3 2     0   8   74 60 4   0   0   81       8.0 138 103 3 19   3 2     0   8   74 60 4   0 0 81     8 138
2945391 WA King   school 5308130 17406   Tukwila School District 530813001342 2564 Showalter Middle School   Regular School No Middle 06 08 2021   grade_8 17 35 86   2 48     10   13   103 104 4   59   7   163       3.0 211 17 35 86   2 48     10   13   103 104 4   59 7 163     3 211
2945411 WA King   school 5308130 17406   Tukwila School District 530813003650 5536 Tukwila Online Learning   Alternative School No High 06 12 2021   grade_8 0 9 0   0 0     0   0   2 3 4   0   0   5       0.0 9 0 9 0   0 0     0   0   2 3 4   0 0 5     0 9
2574222 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000415 3320 Covington Middle School   Regular School No Middle 06 08 2020   grade_8 179 10 120   1 14     13   26   179 181 3   54   19   242       17.0 363 179 10 120   1 14     13   26   179 181 3   54 19 242     17 363
2584377 WA King   school 5308130 17406   Tukwila School District 530813001342 2564 Showalter Middle School   Regular School No Middle 06 08 2020   grade_8 25 29 76   3 57     12   5   96 108 3   68   7   154       3.0 207 25 29 76   3 57     12   5   96 108 3   68 7 154     3 207
2934900 WA Snohomish   school 5302670 31002   Everett School District 530267002253 4334 Heatherwood Middle School   Regular School No Middle 06 08 2021   grade_8 143 16 66   4 68     1   23   178 140 3   23   5   92       12.0 321 143 16 66   4 68     1   23   178 140 3   23 5 92     12 321
2940339 WA Thurston   school 5306180 34111   Olympia School District 530618000935 3711 Washington Middle School   Regular School No Middle 06 08 2021   grade_8 163 8 34   0 24     1   40   141 126 3   0   3   54       15.0 270 163 8 34   0 24     1   40   141 126 3   0 3 54     15 270
2940388 WA Okanogan   school 5306220 24019   Omak School District 530622003307 5196 Washington Virtual Academy Omak Middle School   Regular School No Middle 06 08 2021   grade_8 634 35 71   3 32     6   17   383 412 3   18   0   324       30.0 798 634 35 71   3 32     6   17   383 412 3   18 0 324     30 798
2941879 WA Benton   school 5307320 3400   Richland School District 530732001250 2785 Chief Joseph Middle School   Regular School No Middle 06 08 2021   grade_8 176 7 70   0 3     1   19   137 136 3   14   1   139       18.0 276 176 7 70   0 3     1   19   137 136 3   14 1 139     18 276
2942492 WA King   school 5307710 17001   Seattle School District No. 1 530771001180 2371 Hamilton International Middle School   Regular School No Middle 06 08 2021   grade_8 220 11 28   1 26     0   54   173 164 3   7   3   35       21.0 340 220 11 28   1 26     0   54   173 164 3   7 3 35     21 340
2942542 WA King   school 5307710 17001   Seattle School District No. 1 530771003467 5351 Jane Addams Middle School   Regular School No Middle 06 08 2021   grade_8 148 29 41   0 43     3   48   166 143 3   26   21   95       17.0 312 148 29 41   0 43     3   48   166 143 3   26 21 95     17 312
2942685 WA King   school 5307710 17001   Seattle School District No. 1 530771001212 3517 McClure Middle School   Regular School No Middle 06 08 2021   grade_8 102 13 28   1 9     0   21   87 84 3   8   9   37       5.0 174 102 13 28   1 9     0   21   87 84 3   8 9 37     5 174
2945308 WA Yakima   school 5308970 39202   Toppenish School District 530897003385 5262 Northwest Allprep   Regular School No Other KG 12 2021   grade_8 38 4 6   0 0     0   1   20 26 3   5   0   27       0.0 49 38 4 6   0 0     0   1   20 26 3   5 0 27     0 49
2416748 WA Snohomish   school 5302670 31002   Everett School District 530267000399 2364 North Middle School   Regular School No Middle 06 08 2019   grade_8 115 7 51   3 7     9   22   125 87 2   36   15   134       8.0 214 115 7 51   3 7     9   22   125 87 2   36 15 134     8 214
2571197 WA Whatcom   school 5300420 37501   Bellingham School District 530042001739 4442 Kulshan Middle School   Regular School No Middle 06 08 2020   grade_8 142 2 41   2 6     2   18   108 103 2   11   6   90       25.0 213 142 2 41   2 6     2   18   108 103 2   11 6 90     25 213
2578900 WA King   school 5305910 17417   Northshore School District 530591000886 3345 Kenmore Middle School   Regular School No Middle 06 08 2020   grade_8 152 9 39   0 27     0   22   120 127 2   16   5   46       26.0 249 152 9 39   0 27     0   22   120 127 2   16 5 46     26 249
2583727 WA Pierce   school 5308700 27010   Tacoma School District 530870001458 3397 Bryant   Regular School No Elementary PK 08 2020   grade_8 43 3 7   2 3     0   4   35 25 2   2   0   28       8.0 62 43 3 7   2 3     0   4   35 25 2   2 0 28     8 62
2583898 WA Pierce   school 5308700 27010   Tacoma School District 530870001483 2376 Mason   Regular School No Middle 06 08 2020   grade_8 176 13 29   0 11     0   25   110 142 2   2   5   71       28.0 254 176 13 29   0 11     0   25   110 142 2   2 5 71     28 254
2932167 WA Whatcom   school 5300420 37501   Bellingham School District 530042000117 2075 Whatcom Middle School   Regular School No Middle 06 08 2021   grade_8 152 3 15   2 7     0   20   109 88 2   1   3   43       22.0 199 152 3 15   2 7     0   20   109 88 2   1 3 43     22 199
2934144 WA Yakima   school 5305370 39090   East Valley School District (Yakima) 530537000806 4055 East Valley Central Middle School   Regular School No Middle 06 08 2021   grade_8 121 1 140   3 0     0   7   150 120 2   16   12   163       10.0 272 121 1 140   3 0     0   7   150 120 2   16 12 163     10 272
2934276 WA Pierce   school 5302370 27404   Eatonville School District 530237001899 4230 Eatonville Middle School   Regular School No Middle 06 08 2021   grade_8 109 0 13   1 0     1   9   66 65 2   2   1   59       8.0 133 109 0 13   1 0     1   9   66 65 2   2 1 59     8 133
2934888 WA Snohomish   school 5302670 31002   Everett School District 530267001725 4437 Gateway Middle School   Regular School No Middle 06 08 2021   grade_8 157 12 34   3 92     1   23   162 158 2   10   3   48       22.0 322 157 12 34   3 92     1   23   162 158 2   10 3 48     22 322
2935181 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270003101 1926 Home Choice Academy   Alternative School No Other KG 12 2021   grade_8 30 1 2   1 2     0   4   16 22 2   2   0   14       2.0 40 30 1 2   1 2     0   4   16 22 2   2 0 14     2 40
2935260 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270002878 4561 Shahala Middle School   Regular School No Middle 06 08 2021   grade_8 167 11 71   2 46     3   25   189 134 2   24   4   108       10.0 325 167 11 71   2 46     3   25   189 134 2   24 4 108     10 325
2936253 WA King   school 5303540 17401   Highline School District 530354000554 2927 Sylvester Middle School   Regular School No Middle 06 08 2021   grade_8 78 20 51   3 20     5   28   106 97 2   21   11   92       0.0 205 78 20 51   3 20     5   28   106 97 2   21 11 92     0 205
2937745 WA King   school 5304230 17414   Lake Washington School District 530423000680 3232 Redmond Middle School   Regular School No Middle 06 08 2021   grade_8 139 2 33   0 136     0   35   179 164 2   10   4   35       34.0 345 139 2 33   0 136     0   35   179 164 2   10 4 35     34 345
2942059 WA Spokane   school 5307440 32416   Riverside School District 530744002908 1919 Independent Scholar   Alternative School No Other KG 12 2021   grade_8 12 0 0   2 0     0   2   7 7 2   0   0   9       2.0 16 12 0 0   2 0     0   2   7 7 2   0 0 9     2 16
2942356 WA King   school 5307710 17001   Seattle School District No. 1 530771002017 2838 Catharine Blaine K-8 School   Regular School No Elementary KG 08 2021   grade_8 48 3 11   0 3     0   10   43 30 2   2   0   6       6.0 75 48 3 11   0 3     0   10   43 30 2   2 0 6     6 75
2942414 WA King   school 5307710 17001   Seattle School District No. 1 530771001162 2729 Eckstein Middle School   Regular School No Middle 06 08 2021   grade_8 232 24 33   1 21     1   50   177 183 2   16   4   53       14.0 362 232 24 33   1 21     1   50   177 183 2   16 4 53     14 362
2942775 WA King   school 5307710 17001   Seattle School District No. 1 530771001102 1620 Pathfinder K-8 School   Alternative School No Elementary KG 08 2021   grade_8 42 4 5   0 2     0   7   34 24 2   1   1   10       4.0 60 42 4 5   0 2     0   7   34 24 2   1 1 10     4 60
2942950 WA King   school 5307710 17001   Seattle School District No. 1 530771001259 4064 Washington Middle School   Regular School No Middle 06 08 2021   grade_8 78 45 29   0 36     1   26   113 100 2   24   13   89       3.0 215 78 45 29   0 36     1   26   113 100 2   24 13 89     3 215
2944141 WA Spokane   school 5308250 32081   Spokane School District 530825001405 3356 Sacajawea Middle School   Regular School No Middle 07 08 2021   grade_8 305 14 34   3 11     3   53   235 186 2   11   8   151       20.0 423 305 14 34   3 11     3   53   235 186 2   11 8 151     20 423
2944823 WA Pierce   school 5308700 27010   Tacoma School District 530870001471 2377 Gray   Regular School No Middle 06 08 2021   grade_8 36 27 58   1 14     3   31   90 78 2   15   1   130       6.0 170 36 27 58   1 14     3   31   90 78 2   15 1 130     6 170
2413532 WA Clark   school 5300380 6119   Battle Ground School District 530038003409 5291 Maple Grove K-8 (Closed after 2018-2019 school year)   Regular School No Elementary PK 08 2019   grade_8 39 0 11   1 0     0   3   25 28 1   5   1   31       0.0 54 39 0 11   1 0     0   3   25 28 1   5 1 31     0 54
2413922 WA Whatcom   school 5300420 37501   Bellingham School District 530042000114 3201 Shuksan Middle School   Regular School No Middle 06 08 2019   grade_8 103 5 65   1 27     1   17   117 101 1   35   6   114       11.0 219 103 5 65   1 27     1   17   117 101 1   35 6 114     11 219
2414549 WA Chelan   school 5300950 4228   Cascade School District 530095000553 4403 Icicle River Middle School   Regular School No Middle 06 08 2019   grade_8 55 0 28   1 0     0   2   45 40 1   11   3   37       3.0 86 55 0 28   1 0     0   2   45 40 1   11 3 37     3 86
2415235 WA Kittitas   school 5301350 19404   Cle Elum-Roslyn School District 530135000242 2570 Walter Strom Middle School   Regular School No Middle 06 08 2019   grade_8 53 0 6   0 1     0   2   32 29 1   0   2   17       0.0 62 53 0 6   0 1     0   2   32 29 1   0 2 17     0 62
2416053 WA Pierce   school 5302370 27404   Eatonville School District 530237001899 4230 Eatonville Middle School   Regular School No Middle 06 08 2019   grade_8 109 2 9   1 1     2   6   76 53 1   2   4   47       5.0 130 109 2 9   1 1     2   6   76 53 1   2 4 47     5 130
2416082 WA Snohomish   school 5302400 31015   Edmonds School District 530240000329 3560 Alderwood Middle School   Regular School No Middle 07 08 2019   grade_8 164 23 122   5 68     7   29   201 216 1   66   14   225       29.0 418 164 23 122   5 68     7   29   201 216 1   66 14 225     29 418
2416102 WA Snohomish   school 5302400 31015   Edmonds School District 530240000332 3650 Brier Terrace Middle School   Regular School No Middle 07 08 2019   grade_8 188 18 50   1 50     3   31   169 171 1   18   6   101       25.0 341 188 18 50   1 50     3   31   169 171 1   18 6 101     25 341
2416282 WA Snohomish   school 5302400 31015   Edmonds School District 530240000351 3353 Meadowdale Middle School   Regular School No Middle 07 08 2019   grade_8 151 24 81   0 51     4   38   169 179 1   45   18   155       16.0 349 151 24 81   0 51     4   38   169 179 1   45 18 155     16 349
2416770 WA Snohomish   school 5302670 31002   Everett School District 530267002897 1907 Port Gardner   Alternative School No Other KG 12 2019   grade_8 5 0 1   0 0     0   1   4 2 1   0   0   1       0.0 7 5 0 1   0 0     0   1   4 2 1   0 0 1     0 7
2418516 WA Benton   school 5303930 3017   Kennewick School District 530393000603 3267 Highlands Middle School   Regular School No Middle 06 08 2019   grade_8 97 9 141   1 3     0   9   133 126 1   51   10   203       8.0 260 97 9 141   1 3     0   9   133 126 1   51 10 203     8 260
2421605 WA King   school 5305910 17417   Northshore School District 530591000891 4021 Northshore Middle School   Regular School No Middle 06 08 2019   grade_8 176 4 45   2 59     0   23   173 135 1   16   0   47       31.0 309 176 4 45   2 59     0   23   173 135 1   16 0 47     31 309
2421647 WA King   school 5305910 17417   Northshore School District 530591000480 4371 Skyview Middle School   Regular School No Middle 06 08 2019   grade_8 130 4 33   0 108     0   23   153 144 1   18   0   49       30.0 298 130 4 33   0 108     0   23   153 144 1   18 0 49     30 298
2422710 WA Clallam   school 5306820 5121   Port Angeles School District 530682001004 3318 Stevens Middle School   Regular School No Middle 07 08 2019   grade_8 186 0 32   13 4     0   26   131 129 1   2   2   151       10.0 261 186 0 32   13 4     0   26   131 129 1   2 2 151     10 261
2422714 WA Jefferson   school 5306840 16050   Port Townsend School District 530684001305 4475 Blue Heron Middle School   Regular School No Middle 06 08 2019   grade_8 93 1 11   1 4     0   7   60 56 1   0   1   61       7.0 117 93 1 11   1 4     0   7   60 56 1   0 1 61     7 117
2423269 WA Lincoln   school 5307210 22009   Reardan-Edwall School District 530721001063 2478 Reardan Middle-Senior High School   Regular School No High 06 12 2019   grade_8 42 0 3   2 0     0   5   28 23 1   0   1   21       1.0 52 42 0 3   2 0     0   5   28 23 1   0 1 21     1 52
2423456 WA King   school 5307230 17403   Renton School District 530723003603 5484 Vera Risdon Middle School   Regular School No Middle 06 08 2019   grade_8 80 13 74   0 82     1   20   134 135 1   32   6   113       24.0 270 80 13 74   0 82     1   20   134 135 1   32 6 113     24 270
2424595 WA King   school 5307710 17001   Seattle School District No. 1 530771001264 3277 Whitman Middle School   Regular School No Middle 06 08 2019   grade_8 119 7 15   0 9     2   16   85 82 1   3   0   29       16.0 168 119 7 15   0 9     2   16   85 82 1   3 0 29     16 168
2424814 WA Mason   school 5307900 23309   Shelton School District 530790002353 4363 Oakland Bay Junior High School   Regular School No Secondary 08 09 2019   grade_8 175 1 103   6 2     2   24   161 151 1   44   14   206       25.0 313 175 1 103   6 2     2   24   161 151 1   44 14 206     25 313
2426951 WA King   school 5308130 17406   Tukwila School District 530813001342 2564 Showalter Middle School   Regular School No Middle 06 08 2019   grade_8 22 43 69   1 62     10   8   111 103 1   53   12   154       5.0 215 22 43 69   1 62     10   8   111 103 1   53 12 154     5 215
2571283 WA Whatcom   school 5300420 37501   Bellingham School District 530042000117 2075 Whatcom Middle School   Regular School No Middle 06 08 2020   grade_8 188 4 25   1 6     0   29   140 112 1   1   2   55       26.0 253 188 4 25   1 6     0   29   140 112 1   1 2 55     26 253
2571696 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000689 4412 Bay View Elementary   Regular School No Elementary KG 08 2020   grade_8 47 0 16   0 6     0   5   42 31 1   1   2   23       4.0 74 47 0 16   0 6     0   5   42 31 1   1 2 23     4 74
2571902 WA Chelan   school 5300960 4222   CASHMERE SCHOOL DISTRICT 530096000169 2315 CASHMERE MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_8 67 0 53   0 0     1   3   61 62 1   4   1   55       0.0 124 67 0 53   0 0     1   3   61 62 1   4 1 55     0 124
2572713 WA Pierce   school 5301410 27400   Clover Park School District 530141000264 3297 Mann Middle School (Closed after 2019-2020 school year)   Regular School No Middle 06 08 2020   grade_8 46 15 49   1 0     8   20   69 69 1   2   2   77       13.0 139 46 15 49   1 0     8   20   69 69 1   2 2 77     13 139
2572825 WA Walla Walla   school 5301470 36250   College Place School District 530147000276 3541 John Sager Middle School   Regular School No Middle 06 08 2020   grade_8 58 0 63   0 0     0   7   59 68 1   18   5   79       9.0 128 58 0 63   0 0     0   7   59 68 1   18 5 79     9 128
2572918 WA Skagit   school 5301660 29011   Concrete School District 530166000286 2810 Concrete High School   Regular School No High 07 12 2020   grade_8 41 0 4   0 1     0   0   31 14 1   0   0   39       0.0 46 41 0 4   0 1     0   0   31 14 1   0 0 39     0 46
2573256 WA Yakima   school 5305370 39090   East Valley School District (Yakima) 530537000806 4055 East Valley Central Middle School   Regular School No Middle 06 08 2020   grade_8 111 2 136   1 5     0   10   119 145 1   26   6   165       0.0 265 111 2 136   1 5     0   10   119 145 1   26 6 165     0 265
2573435 WA Snohomish   school 5302400 31015   Edmonds School District 530240000332 3650 Brier Terrace Middle School   Regular School No Middle 07 08 2020   grade_8 169 20 56   1 52     2   45   189 155 1   21   3   113       26.0 345 169 20 56   1 52     2   45   189 155 1   21 3 113     26 345
2573981 WA Snohomish   school 5302670 31002   Everett School District 530267000393 3752 Eisenhower Middle School   Regular School No Middle 06 08 2020   grade_8 164 21 73   1 47     5   15   166 159 1   25   12   157       23.0 326 164 21 73   1 47     5   15   166 159 1   25 12 157     23 326
2574034 WA Snohomish   school 5302670 31002   Everett School District 530267002253 4334 Heatherwood Middle School   Regular School No Middle 06 08 2020   grade_8 201 12 62   1 62     3   30   193 177 1   23   17   95       31.0 371 201 12 62   1 62     3   30   193 177 1   23 17 95     31 371
2574367 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001901 4209 Pacific Middle School   Regular School No Middle 06 08 2020   grade_8 189 10 58   1 20     8   36   170 151 1   21   7   121       13.0 322 189 10 58   1 20     8   36   170 151 1   21 7 121     13 322
2574387 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270002878 4561 Shahala Middle School   Regular School No Middle 06 08 2020   grade_8 191 10 79   1 54     2   34   195 175 1   25   1   115       15.0 371 191 10 79   1 54     2   34   195 175 1   25 1 115     15 371
2574523 WA King   school 5302820 17210   Federal Way School District 530282002638 1759 Internet Academy   Alternative School No Other PK 12 2020   grade_8 9 2 3   0 1     0   3   6 11 1   0   0   4       3.0 18 9 2 3   0 1     0   3   6 11 1   0 0 4     3 18
2574529 WA King   school 5302820 17210   Federal Way School District 530282000438 3701 Kilo Middle School   Regular School No Middle 06 08 2020   grade_8 65 26 89   0 32     1   19   105 126 1   48   8   146       9.0 232 65 26 89   0 32     1   19   105 126 1   48 8 146     9 232
2574554 WA King   school 5302820 17210   Federal Way School District 530282000442 3381 Lakota Middle School   Regular School No Middle 06 08 2020   grade_8 89 38 81   1 15     18   40   149 132 1   32   11   167       15.0 282 89 38 81   1 15     18   40   149 132 1   32 11 167     15 282
2574794 WA Pierce   school 5302880 27417   Fife School District 530288003161 4582 Columbia Junior High School   Regular School No Secondary 08 09 2020   grade_8 146 12 68   3 29     17   43   155 162 1   31   7   153       4.0 318 146 12 68   3 29     17   43   155 162 1   31 7 153     4 318
2575132 WA Thurston   school 5303330 34324   Griffin School District 530333000510 2406 Griffin School   Regular School No Elementary PK 08 2020   grade_8 50 2 5   0 4     0   8   36 32 1   0   0   8       1.0 69 50 2 5   0 4     0   8   36 32 1   0 0 8     1 69
2575196 WA King   school 5303540 17401   Highline School District 530354000522 3163 Cascade Middle School   Regular School No Middle 06 08 2020   grade_8 24 29 122   1 63     8   6   134 118 1   86   18   204       0.0 253 24 29 122   1 63     8   6   134 118 1   86 18 204     0 253
2576838 WA King   school 5304230 17414   Lake Washington School District 530423001843 4167 Northstar Middle School   Alternative School No Middle 06 08 2020   grade_8 13 0 0   0 8     0   0   10 10 1   0   0   0       1.0 21 13 0 0   0 8     0   0   10 10 1   0 0 0     1 21
2576901 WA King   school 5304230 17414   Lake Washington School District 530423000683 3706 Rose Hill Middle School   Regular School No Middle 06 08 2020   grade_8 164 6 51   0 86     0   38   200 144 1   31   2   60       39.0 345 164 6 51   0 86     0   38   200 144 1   31 2 60     39 345
2578609 WA Mason   school 5305790 23403   North Mason School District 530579002847 1861 North Mason Homelink Program   Alternative School No Other KG 12 2020   grade_8 1 0 1   0 0     0   1   1 1 1   0   0   0       1.0 3 1 0 1   0 0     0   1   1 1 1   0 0 0     1 3
2578837 WA King   school 5305910 17417   Northshore School District 530591000879 3493 Canyon Park Middle School   Regular School No Middle 06 08 2020   grade_8 182 6 43   1 45     0   34   154 156 1   9   2   46       28.0 311 182 6 43   1 45     0   34   154 156 1   9 2 46     28 311
2579284 WA Thurston   school 5306180 34111   Olympia School District 530618000925 3133 Jefferson Middle School   Regular School No Middle 05 08 2020   grade_8 88 3 28   3 19     0   26   84 82 1   3   3   69       5.0 167 88 3 28   3 19     0   26   84 82 1   3 3 69     5 167
2579443 WA Okanogan   school 5306220 24019   Omak School District 530622003307 5196 Washington Virtual Academy Omak Middle School   Regular School No Middle 06 08 2020   grade_8 417 35 63   7 27     6   20   257 317 1   18   1   344       41.0 575 417 35 63   7 27     6   20   257 317 1   18 1 344     41 575
2580171 WA Whitman   school 5306930 38267   Pullman School District 530693001019 3419 Lincoln Middle School   Regular School No Middle 06 08 2020   grade_8 142 6 29   1 15     2   20   129 85 1   8   3   65       14.0 215 142 6 29   1 15     2   20   129 85 1   8 3 65     14 215
2581257 WA King   school 5307710 17001   Seattle School District No. 1 530771001249 3774 Aki Kurose Middle School   Regular School No Middle 06 08 2020   grade_8 8 59 39   2 72     6   17   108 94 1   42   18   152       9.0 203 8 59 39   2 72     6   17   108 94 1   42 18 152     9 203
2581416 WA King   school 5307710 17001   Seattle School District No. 1 530771001162 2729 Eckstein Middle School   Regular School No Middle 06 08 2020   grade_8 217 14 23   2 32     0   33   150 170 1   12   2   44       26.0 321 217 14 23   2 32     0   33   150 170 1   12 2 44     26 321
2581420 WA King   school 5307710 17001   Seattle School District No. 1 530771003612 5485 Edmonds S. Meany Middle School   Regular School No Middle 06 08 2020   grade_8 54 54 18   1 18     0   17   89 72 1   10   18   82       6.0 162 54 54 18   1 18     0   17   89 72 1   10 18 82     6 162
2581510 WA King   school 5307710 17001   Seattle School District No. 1 530771003271 5175 Hazel Wolf K-8   Regular School No Elementary KG 08 2020   grade_8 54 7 10   0 6     0   8   35 49 1   5   0   19       12.0 85 54 7 10   0 6     0   8   35 49 1   5 0 19     12 85
2581628 WA King   school 5307710 17001   Seattle School District No. 1 530771003426 5276 Louisa Boren STEM K-8   Regular School No Elementary PK 08 2020   grade_8 34 8 5   0 5     0   8   31 28 1   5   0   14       1.0 60 34 8 5   0 5     0   8   31 28 1   5 0 14     1 60
2581958 WA King   school 5307710 17001   Seattle School District No. 1 530771001259 4064 Washington Middle School   Regular School No Middle 06 08 2020   grade_8 77 49 18   0 38     1   33   114 101 1   16   10   78       6.0 216 77 49 18   0 38     1   33   114 101 1   16 10 78     6 216
2582122 WA Yakima   school 5307770 39119   Selah School District 530777003554 5385 Selah Middle School   Regular School No Middle 06 08 2020   grade_8 165 2 85   0 0     0   7   123 135 1   13   0   135       15.0 259 165 2 85   0 0     0   7   123 135 1   13 0 135     15 259
2582213 WA Mason   school 5307900 23309   Shelton School District 530790002353 4363 Oakland Bay Junior High School   Regular School No Middle 07 08 2020   grade_8 176 3 118   12 1     1   35   165 180 1   48   30   232       21.0 346 176 3 118   12 1     1   35   165 180 1   48 30 232     21 346
2584033 WA Pierce   school 5308700 27010   Tacoma School District 530870001507 3448 Truman   Regular School No Middle 06 08 2020   grade_8 121 45 38   4 23     2   28   148 112 1   16   23   158       23.0 261 121 45 38   4 23     2   28   148 112 1   16 23 158     23 261
2584130 WA King   school 5308760 17409   Tahoma School District 530876002979 3341 Summit Trail Middle School   Regular School No Middle 06 08 2020   grade_8 233 4 41   1 21     0   40   187 152 1   5   3   53       48.0 340 233 4 41   1 21     0   40   187 152 1   5 3 53     48 340
2584986 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001605 2780 Pioneer Middle School   Regular School No Middle 06 08 2020   grade_8 95 0 83   0 3     0   7   101 86 1   11   4   115       13.0 188 95 0 83   0 3     0   7   101 86 1   11 4 115     13 188
2585287 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001645 3538 Centennial Middle School   Regular School No Middle 06 08 2020   grade_8 157 3 26   2 5     2   25   121 98 1   11   4   124       13.0 220 157 3 26   2 5     2   25   121 98 1   11 4 124     13 220
2585386 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001653 4040 West Valley Jr High   Regular School No Middle 07 08 2020   grade_8 263 1 138   3 18     2   14   219 219 1   23   1   190       16.0 439 263 1 138   3 18     2   14   219 219 1   23 1 190     16 439
2931983 WA King   school 5300390 17405   Bellevue School District 530039000093 3435 Tillicum Middle School   Regular School No Middle 06 08 2021   grade_8 107 8 54   0 64     0   31   122 141 1   8   1   35       32.0 264 107 8 54   0 64     0   31   122 141 1   8 1 35     32 264
2932129 WA Whatcom   school 5300420 37501   Bellingham School District 530042000114 3201 Shuksan Middle School   Regular School No Middle 06 08 2021   grade_8 94 6 84   3 21     2   22   123 108 1   34   6   139       14.0 232 94 6 84   3 21     2   22   123 108 1   34 6 139     14 232
2932194 WA Pierce   school 5300480 27403   Bethel School District 530048000120 3250 Bethel Middle School   Regular School No Middle 06 08 2021   grade_8 78 15 54   2 2     20   41   109 102 1   8   2   131       6.0 212 78 15 54   2 2     20   41   109 102 1   8 2 131     6 212
2932251 WA Pierce   school 5300480 27403   Bethel School District 530048003158 4578 Cougar Mountain Middle School   Regular School No Middle 06 08 2021   grade_8 125 2 25   3 3     2   27   96 90 1   0   8   91       12.0 187 125 2 25   3 3     2   27   96 90 1   0 8 91     12 187
2932373 WA Pierce   school 5300480 27403   Bethel School District 530048000128 3751 Spanaway Middle School   Regular School No Middle 06 08 2021   grade_8 76 25 73   6 9     21   45   124 130 1   10   9   169       2.0 255 76 25 73   6 9     21   45   124 130 1   10 9 169     2 255
2933034 WA Spokane   school 5301110 32356   Central Valley School District 530111000195 3573 Greenacres Middle School   Regular School No Middle 06 08 2021   grade_8 163 3 5   3 5     2   4   91 93 1   7   3   48       2.0 185 163 3 5   3 5     2   4   91 93 1   7 3 48     2 185
2933660 WA Pierce   school 5301410 27400   Clover Park School District 530141000272 3500 Thomas Middle School   Regular School No Middle 06 08 2021   grade_8 104 42 104   1 11     16   51   169 159 1   26   5   196       16.0 329 104 42 104   1 11     16   51   169 159 1   26 5 196     16 329
2933870 WA Island   school 5301800 15204   Coupeville School District 530180002049 4004 Coupeville Middle School   Regular School No Middle 06 08 2021   grade_8 51 0 17   0 0     0   11   35 43 1   3   0   24       4.0 79 51 0 17   0 0     0   11   35 43 1   3 0 24     4 79
2933896 WA Clallam   school 5301830 5313   Crescent School District 530183002942 5030 Olympic Peninsula HomeConnection   Alternative School No Other KG 12 2021   grade_8 6 0 0   0 0     0   0   3 2 1   0   0   1       0.0 6 6 0 0   0 0     0   0   3 2 1   0 0 1     0 6

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