enrollments

Data source: Big Local News · About: Big Local

4,566 rows where grade = "grade_7" and state = "WA" sorted by section_504 descending

✎ View and edit SQL

This data as json, CSV (advanced)

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
2425752 2425752 WA Spokane   school 5308250 32081   Spokane School District 530825001406 3413 Salk Middle School   Regular School No Middle 06 08 2019   grade_7 243 7 36   1 3     4   46   155 185 0   4   11   188       99.0 340 243 7 36   1 3     4   46   155 185 0   4 11 188     99 340
460680 460680 WA Pierce   school 5300480 27403   Bethel School District 530048000120 3250 Bethel Middle School   Regular School No 2.0 06 09 2015   grade_7 112 36 38   3 11     8   15   112 111 0   1   5   129       9.0 223 112 36 38   3 11     8   15   112 111 0   1 5 129     9 223
460914 460914 WA Whatcom   school 5300570 37503   Blaine School District 530057000131 3796 Blaine Middle School   Regular School No 2.0 06 08 2015   grade_7 134 1 25   2 4     6   10   84 98 0   2   3   97       9.0 182 134 1 25   2 4     6   10   84 98 0   2 3 97     9 182
461296 461296 WA Cowlitz   school 5300990 8401   Castle Rock School District 530099000173 3969 Castle Rock Middle School   Regular School No 2.0 06 08 2015   grade_7 74 0 10   2 0     1   8   52 43 0   0   2   48       9.0 95 74 0 10   2 0     1   8   52 43 0   0 2 48     9 95
462839 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
464186 464186 WA Whatcom   school 5302850 37502   Ferndale School District 530285000463 3762 Vista Middle School   Regular School No 2.0 06 08 2015   grade_7 130 2 27   19 6     0   10   104 90 0   9   0   104       9.0 194 130 2 27   19 6     0   10   104 90 0   9 0 104     9 194
465189 465189 WA Cowlitz   school 5300003 8458   Kelso School District 530000300592 2916 Huntington Middle School   Regular School No 2.0 06 08 2015   grade_7 138 0 29   3 1     2   12   85 100 0   4   12   108       9.0 185 138 0 29   3 1     2   12   85 100 0   4 12 108     9 185
466200 466200 WA King   school 5304230 17414   Lake Washington School District 530423000672 2308 Kirkland Middle School   Regular School No 2.0 06 09 2015   grade_7 156 1 10   1 18     0   14   111 89 0   1   2   31       9.0 200 156 1 10   1 18     0   14   111 89 0   1 2 31     9 200
467146 467146 WA Whatcom   school 5305010 37505   Meridian School District 530501000767 3930 Meridian Middle School   Regular School No 2.0 06 08 2015   grade_7 76 2 20   0 3     0   4   50 55 0   6   2   50       9.0 105 76 2 20   0 3     0   4   50 55 0   6 2 50     9 105
467226 467226 WA Snohomish   school 5305130 31103   Monroe School District 530513002761 4544 Hidden River Middle School   Regular School No 2.0 05 08 2015   grade_7 101 0 22   1 3     0   9   93 43 0   2   0   47       9.0 136 101 0 22   1 3     0   9   93 43 0   2 0 47     9 136
467687 467687 WA Snohomish   school 5305430 31006   Mukilteo School District 530543001910 4231 Explorer Middle School   Regular School No 2.0 06 08 2015   grade_7 87 18 123   3 52     4   23   167 143 0   48   5   210       9.0 310 87 18 123   3 52     4   23   167 143 0   48 5 210     9 310
467779 467779 WA Snohomish   school 5305430 31006   Mukilteo School District 530543000719 4425 Voyager Middle School   Regular School No 2.0 06 08 2015   grade_7 100 25 106   1 34     3   20   141 148 0   33   6   200       9.0 289 100 25 106   1 34     3   20   141 148 0   33 6 200     9 289
474340 474340 WA Clark   school 5309270 6037   Vancouver School District 530927002944 4591 Thomas Jefferson Middle School   Regular School No 2.0 06 08 2015   grade_7 197 5 33   1 5     0   14   131 124 0   7   4   100       9.0 255 197 5 33   1 5     0   14   131 124 0   7 4 100     9 255
474544 474544 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001601 3510 Garrison Middle School   Regular School No 2.0 06 08 2015   grade_7 103 2 100   1 1     0   5   100 112 0   26   3   131       9.0 212 103 2 100   1 1     0   5   100 112 0   26 3 131     9 212
474840 474840 WA Chelan   school 5309660 4246   Wenatchee School District 530966001635 3210 Pioneer Middle School   Regular School No 2.0 06 08 2015   grade_7 126 0 102   2 1     0   7   117 121 0   46   6   150       9.0 238 126 0 102   2 1     0   7   117 121 0   46 6 150     9 238
474993 474993 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001653 4040 West Valley Jr High   Regular School No 2.0 07 09 2015   grade_7 270 4 118   5 5     1   11   225 189 0   30   0   189       9.0 414 270 4 118   5 5     1   11   225 189 0   30 0 189     9 414
475045 475045 WA Pierce   school 5309780 27416   White River School District 530978003005 3458 Glacier Middle School   Regular School No 2.0 06 08 2015   grade_7 222 1 29   4 1     0   11   143 125 0   3   5   105       9.0 268 222 1 29   4 1     0   11   143 125 0   3 5 105     9 268
475288 475288 WA Yakima   school 5310110 39007   Yakima School District 531011001691 2410 Franklin Middle School   Regular School No 2.0 06 08 2015   grade_7 64 2 215   2 1     0   7   162 129 0   86   10   267       9.0 291 64 2 215   2 1     0   7   162 129 0   86 10 267     9 291
520357 520357 WA King   school 5300390 17405   Bellevue School District 530039000068 3166 Highland Middle School   Regular School No 2 06 08 2016   grade_7 66 7 55   0 35     0   11   89 85 0   21   6   82       9.0 174 66 7 55   0 35     0   11   89 85 0   21 6 82     9 174
526800 526800 WA Snohomish   school 5304860 31025   Marysville School District 530486000736 3355 Marysville Middle School   Regular School No 2 05 08 2016   grade_7 123 8 76   6 11     3   28   128 127 0   18   11   143       9.0 255 123 8 76   6 11     3   28   128 127 0   18 11 143     9 255
527162 527162 WA Snohomish   school 5305130 31103   Monroe School District 530513002761 4544 Hidden River Middle School   Regular School No 2 06 08 2016   grade_7 103 1 26   0 7     0   11   78 70 0   5   4   46       9.0 148 103 1 26   0 7     0   11   78 70 0   5 4 46     9 148
527238 527238 WA Grays Harbor   school 5305160 14066   Montesano School District 530516000780 2180 Montesano Jr-Sr High   Regular School No 3 07 12 2016   grade_7 99 0 15   3 0     0   4   68 53 0   0   0   51       9.0 121 99 0 15   3 0     0   4   68 53 0   0 0 51     9 121
527688 527688 WA Snohomish   school 5305430 31006   Mukilteo School District 530543000719 4425 Voyager Middle School   Regular School No 2 06 08 2016   grade_7 79 34 95   2 36     8   9   125 138 0   43   6   197       9.0 263 79 34 95   2 36     8   9   125 138 0   43 6 197     9 263
528076 528076 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585003280 5168 Aspire Middle School   Regular School No 2 06 08 2016   grade_7 71 4 8   0 7     0   14   38 66 0   0   3   34       9.0 104 71 4 8   0 7     0   14   38 66 0   0 3 34     9 104
530170 530170 WA King   school 5307230 17403   Renton School District 530723002564 3280 Dimmitt Middle School   Regular School No 2 06 08 2016   grade_7 32 76 84   2 92     8   20   145 169 0   37   7   232       9.0 314 32 76 84   2 92     8   20   145 169 0   37 7 232     9 314
530653 530653 WA Thurston   school 5307470 34401   Rochester School District 530747001118 3067 Rochester Middle School   Regular School No 2 06 08 2016   grade_7 117 0 36   6 1     0   9   82 87 0   4   10   91       9.0 169 117 0 36   6 1     0   9   82 87 0   4 10 91     9 169
530699 530699 WA Grant   school 5307620 13160   Royal School District 530762001124 3620 Royal Middle School   Regular School No 2 07 08 2016   grade_7 22 0 103   0 0     0   0   63 62 0   43   13   89       9.0 125 22 0 103   0 0     0   0   63 62 0   43 13 89     9 125
533125 533125 WA Pierce   school 5308610 27320   Sumner School District 530861001808 4132 Lakeridge Middle School   Regular School No 2 06 08 2016   grade_7 174 0 19   0 4     1   13   97 114 0   0   8   78       9.0 211 174 0 19   0 4     1   13   97 114 0   0 8 78     9 211
533145 533145 WA Pierce   school 5308610 27320   Sumner School District 530861002580 4502 Mountain View Middle School   Regular School No 2 06 08 2016   grade_7 139 1 23   0 2     2   24   87 104 0   3   4   69       9.0 191 139 1 23   0 2     2   24   87 104 0   3 4 69     9 191
533239 533239 WA Pierce   school 5308700 27010   Tacoma School District 530870001454 3054 Baker   Regular School No 2 06 08 2016   grade_7 41 48 69   3 45     16   12   124 110 0   24   15   153       9.0 234 41 48 69   3 45     16   12   124 110 0   24 15 153     9 234
533451 533451 WA Pierce   school 5308700 27010   Tacoma School District 530870001483 2376 Mason   Regular School No 2 06 08 2016   grade_7 208 27 24   3 18     3   8   143 148 0   4   5   92       9.0 291 208 27 24   3 18     3   8   143 148 0   4 5 92     9 291
534533 534533 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001605 2780 Pioneer Middle School   Regular School No 2 05 08 2016   grade_7 137 2 73   0 6     0   5   101 122 0   15   8   129       9.0 223 137 2 73   0 6     0   5   101 122 0   15 8 129     9 223
535226 535226 WA Yakima   school 5310110 39007   Yakima School District 531011001691 2410 Franklin Middle School   Regular School No 2 06 08 2016   grade_7 64 3 189   3 0     1   12   143 129 0   50   7   241       9.0 272 64 3 189   3 0     1   12   143 129 0   50 7 241     9 272
618791 618791 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108002056 4249 Ridgetop Middle School   Regular School No Middle 06 08 2017   grade_7 143 6 28   0 17     4   43   120 121 0   6   0   71       9.0 241 143 6 28   0 17     4   43   120 121 0   6 0 71     9 241
619870 619870 WA Pierce   school 5302130 27343   Dieringer School District 530213000694 4416 North Tapps Middle School   Regular School No Middle 06 08 2017   grade_7 130 1 12   0 13     0   13   74 95 0   0   1   15       9.0 169 130 1 12   0 13     0   13   74 95 0   0 1 15     9 169
620938 620938 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000414 3785 Cascade Middle School   Regular School No Middle 06 08 2017   grade_7 159 8 74   1 16     10   24   170 122 0   27   17   194       9.0 292 159 8 74   1 16     10   24   170 122 0   27 17 194     9 292
621175 621175 WA King   school 5300332 17906   Excel Public Charter School 530033203536 5377 Excel Public Charter School (Closed after 2018-2019 school year)   Regular School Yes Middle 06 08 2017   grade_7 35 31 6   0 10     2   13   56 41 0   12   1   36       9.0 97 35 31 6   0 10     2   13   56 41 0   12 1 36     9 97
621688 621688 WA Spokane   school 5302970 32358   Freeman School District 530297003013 4593 Freeman Middle School   Regular School No Middle 06 08 2017   grade_7 61 1 3   0 0     1   2   37 31 0   0   0   21       9.0 68 61 1 3   0 0     1   2   37 31 0   0 0 21     9 68
624183 624183 WA Snohomish   school 5304860 31025   Marysville School District 530486000736 3355 Marysville Middle School   Regular School No Middle 06 08 2017   grade_7 133 4 63   5 18     3   20   131 115 0   30   10   133       9.0 246 133 4 63   5 18     3   20   131 115 0   30 10 133     9 246
624637 624637 WA Grays Harbor   school 5305160 14066   Montesano School District 530516000780 2180 Montesano Jr-Sr High   Regular School No High 07 12 2017   grade_7 81 0 17   3 1     0   6   44 64 0   2   2   51       9.0 108 81 0 17   3 1     0   6   44 64 0   2 2 51     9 108
625120 625120 WA Snohomish   school 5305430 31006   Mukilteo School District 530543000719 4425 Voyager Middle School   Regular School No Middle 06 08 2017   grade_7 83 26 115   2 40     1   33   161 139 0   46   8   206       9.0 300 83 26 115   2 40     1   33   161 139 0   46 8 206     9 300
628079 628079 WA Thurston   school 5307470 34401   Rochester School District 530747001118 3067 Rochester Middle School   Regular School No Middle 06 08 2017   grade_7 116 1 42   5 1     0   16   99 82 0   11   5   101       9.0 181 116 1 42   5 1     0   16   99 82 0   11 5 101     9 181
628403 628403 WA King   school 5307710 17001   Seattle School District No. 1 530771003271 5175 Hazel Wolf K-8   Regular School No Elementary KG 08 2017   grade_7 55 8 12   1 5     1   4   45 41 0   1   3   24       9.0 86 55 8 12   1 5     1   4   45 41 0   1 3 24     9 86
630392 630392 WA Snohomish   school 5308550 31311   Sultan School District 530855001439 2105 Sultan Middle School   Regular School No Middle 06 08 2017   grade_7 104 1 29   1 3     0   3   76 65 0   7   5   80       9.0 141 104 1 29   1 3     0   3   76 65 0   7 5 80     9 141
632173 632173 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001645 3538 Centennial Middle School   Regular School No Middle 06 08 2017   grade_7 165 6 20   4 2     0   17   109 105 0   5   8   122       9.0 214 165 6 20   4 2     0   17   109 105 0   5 8 122     9 214
632574 632574 WA Yakima   school 5310110 39007   Yakima School District 531011001691 2410 Franklin Middle School   Regular School No Middle 06 08 2017   grade_7 52 1 221   3 0     0   13   148 142 0   64   11   240       9.0 290 52 1 221   3 0     0   13   148 142 0   64 11 240     9 290
2413175 2413175 WA Snohomish   school 5300240 31016   Arlington School District 530024000024 3124 Post Middle School   Regular School No Middle 06 08 2019   grade_7 140 1 29   1 1     2   16   110 80 0   14   4   76       9.0 190 140 1 29   1 1     2   16   110 80 0   14 4 76     9 190
2413479 2413479 WA Clark   school 5300380 6119   Battle Ground School District 530038003262 5133 Chief Umtuch Middle   Regular School No Middle 05 08 2019   grade_7 120 2 14   0 0     0   10   86 60 0   7   5   53       9.0 146 120 2 14   0 0     0   10   86 60 0   7 5 53     9 146
2414563 2414563 WA Chelan   school 5300960 4222   CASHMERE SCHOOL DISTRICT 530096000169 2315 CASHMERE MIDDLE SCHOOL   Regular School No Middle 05 08 2019   grade_7 69 0 58   0 0     0   4   62 69 0   3   0   63       9.0 131 69 0 58   0 0     0   4   62 69 0   3 0 63     9 131
2416915 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
2417206 2417206 WA King   school 5302820 17210   Federal Way School District 530282000442 3381 Lakota Middle School   Regular School No Middle 06 08 2019   grade_7 87 38 80   1 15     19   39   151 127 1   40   10   166       9.0 279 87 38 80   1 15     19   39   151 127 1   40 10 166     9 279
2417433 2417433 WA Whatcom   school 5302850 37502   Ferndale School District 530285002832 4554 Horizon Middle School   Regular School No Middle 06 08 2019   grade_7 94 0 34   17 4     0   11   81 79 0   9   3   91       9.0 160 94 0 34   17 4     0   11   81 79 0   9 3 91     9 160
2419093 2419093 WA Chelan   school 5301200 4129   Lake Chelan School District 530120000218 2317 Chelan Middle School   Regular School No Middle 06 08 2019   grade_7 60 0 54   0 1     0   2   61 56 0   15   4   70       9.0 117 60 0 54   0 1     0   2   61 56 0   15 4 70     9 117
2421256 2421256 WA Mason   school 5305790 23403   North Mason School District 530579000860 3174 Hawkins Middle School   Regular School No Middle 06 08 2019   grade_7 102 2 38   3 0     2   6   84 69 0   13   11   96       9.0 153 102 2 38   3 0     2   6   84 69 0   13 11 96     9 153
2421301 2421301 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585003280 5168 Aspire Middle School   Regular School No Middle 06 08 2019   grade_7 61 1 19   0 5     0   7   31 62 0   1   3   28       9.0 93 61 1 19   0 5     0   7   31 62 0   1 3 28     9 93
2422808 2422808 WA Whitman   school 5306930 38267   Pullman School District 530693001019 3419 Lincoln Middle School   Regular School No Middle 06 08 2019   grade_7 156 5 26   2 18     0   21   129 99 0   9   6   78       9.0 228 156 5 26   2 18     0   21   129 99 0   9 6 78     9 228
2423208 2423208 WA Grant   school 5307080 13144   Quincy School District 530708001056 2510 Quincy Middle School   Regular School No Middle 07 08 2019   grade_7 20 0 224   0 0     0   0   135 109 0   109   4   213       9.0 244 20 0 224   0 0     0   0   135 109 0   109 4 213     9 244
2423871 2423871 WA King   school 5307710 17001   Seattle School District No. 1 530771001249 3774 Aki Kurose Middle School   Regular School No Middle 06 08 2019   grade_7 7 64 37   2 65     5   21   106 95 0   37   13   149       9.0 201 7 64 37   2 65     5   21   106 95 0   37 13 149     9 201
2425260 2425260 WA Kitsap   school 5308160 18402   South Kitsap School District 530816001346 3680 Cedar Heights Middle School   Regular School No Middle 06 08 2019   grade_7 172 3 25   4 11     3   20   119 119 0   7   3   107       9.0 238 172 3 25   4 11     3   20   119 119 0   7 3 107     9 238
2425413 2425413 WA Spokane   school 5300337 32901   Spokane International Academy 530033703539 5381 Spokane International Academy   Regular School Yes Elementary KG 08 2019   grade_7 57 1 12   1 2     0   9   32 50 0   2   0   30       9.0 82 57 1 12   1 2     0   9   32 50 0   2 0 30     9 82
2427084 2427084 WA Pierce   school 5309180 27083   University Place School District 530918002383 4325 Drum Intermediate   Regular School No Middle 05 07 2019   grade_7 93 17 29   0 12     0   37   96 92 0   7   3   70       9.0 188 93 17 29   0 12     0   37   96 92 0   7 3 70     9 188
2427765 2427765 WA Chelan   school 5309660 4246   Wenatchee School District 530966001006 4432 Foothills Middle School   Regular School No Middle 06 08 2019   grade_7 96 0 94   1 2     0   7   96 104 0   32   10   106       9.0 200 96 0 94   1 2     0   7   96 104 0   32 10 106     9 200
2457604 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
2457734 2457734 WA Snohomish   school 5300240 31016   Arlington School District 530024000024 3124 Post Middle School   Regular School No Middle 06 08 2018   grade_7 162 0 24   0 5     0   23   111 103 0   6   8   92       9.0 214 162 0 24   0 5     0   23   111 103 0   6 8 92     9 214
2459374 2459374 WA Spokane   school 5301110 32356   Central Valley School District 530111000198 2776 North Pines Middle School   Regular School No Middle 06 08 2018   grade_7 110 7 25   2 2     7   10   80 83 0   20   5   122       9.0 163 110 7 25   2 2     7   10   80 83 0   20 5 122     9 163
2460344 2460344 WA Spokane   school 5302280 32361   East Valley School District (Spokane) 530228002600 1712 Continuous Curriculum School   Regular School No Elementary KG 08 2018   grade_7 53 1 5   1 2     0   4   29 37 0   1   1   22       9.0 66 53 1 5   1 2     0   4   29 37 0   1 1 22     9 66
2460746 2460746 WA Snohomish   school 5302400 31015   Edmonds School District 530240000348 3463 Madrona K-8 School   Alternative School No Elementary PK 08 2018   grade_7 46 8 6   0 4     0   11   39 36 0   1   1   12       9.0 75 46 8 6   0 4     0   11   39 36 0   1 1 12     9 75
2461671 2461671 WA King   school 5302820 17210   Federal Way School District 530282000437 3898 Illahee Middle School   Regular School No Middle 05 08 2018   grade_7 61 39 55   3 38     17   27   121 119 0   35   4   142       9.0 240 61 39 55   3 38     17   27   121 119 0   35 4 142     9 240
2462532 2462532 WA King   school 5303540 17401   Highline School District 530354000554 2927 Sylvester Middle School   Regular School No Middle 07 08 2018   grade_7 77 18 149   2 52     10   21   164 165 0   80   21   255       9.0 329 77 18 149   2 52     10   21   164 165 0   80 21 255     9 329
2462955 2462955 WA Benton   school 5303930 3017   Kennewick School District 530393000598 4028 Desert Hills Middle School   Regular School No Middle 06 08 2018   grade_7 223 9 45   1 6     0   13   139 158 0   3   0   76       9.0 297 223 9 45   1 6     0   13   139 158 0   3 0 76     9 297
2463520 2463520 WA Clark   school 5304170 6101   La Center School District 530417000649 3371 La Center Middle School   Regular School No Middle 06 08 2018   grade_7 102 2 12   2 1     0   6   75 50 0   2   6   32       9.0 125 102 2 12   2 1     0   6   75 50 0   2 6 32     9 125
2464147 2464147 WA Cowlitz   school 5304470 8122   Longview School District 530447000705 2831 Monticello Middle School   Regular School No Middle 06 08 2018   grade_7 112 4 36   3 1     3   8   72 95 0   7   18   131       9.0 167 112 4 36   3 1     3   8   72 95 0   7 18 131     9 167
2464869 2464869 WA Snohomish   school 5305130 31103   Monroe School District 530513002761 4544 Hidden River Middle School   Regular School No Middle 06 08 2018   grade_7 98 0 36   1 6     0   10   78 73 0   13   0   43       9.0 151 98 0 36   1 6     0   10   78 73 0   13 0 43     9 151
2465197 2465197 WA Skagit   school 5305400 29320   Mount Vernon School District 530540002585 4511 Mount Baker Middle School   Regular School No Middle 06 08 2018   grade_7 76 1 124   2 10     2   5   117 103 0   56   3   141       9.0 220 76 1 124   2 10     2   5   117 103 0   56 3 141     9 220
2466501 2466501 WA Thurston   school 5306180 34111   Olympia School District 530618001737 4473 Thurgood Marshall Middle School   Regular School No Middle 06 08 2018   grade_7 81 7 26   1 10     0   15   73 67 0   3   4   53       9.0 140 81 7 26   1 10     0   15   73 67 0   3 4 53     9 140
2467059 2467059 WA Pierce   school 5306690 27401   Peninsula School District 530669001863 4156 Key Peninsula Middle School   Regular School No Middle 06 08 2018   grade_7 142 0 14   1 2     0   14   85 88 0   3   5   87       9.0 173 142 0 14   1 2     0   14   85 88 0   3 5 87     9 173
2467313 2467313 WA Pierce   school 5306960 27003   Puyallup School District 530696001022 3447 Aylen Jr High   Regular School No Middle 07 09 2018   grade_7 136 5 37   1 13     2   22   117 99 0   17   3   77       9.0 216 136 5 37   1 13     2   22   117 99 0   17 3 77     9 216
2467804 2467804 WA King   school 5307230 17403   Renton School District 530723002564 3280 Dimmitt Middle School   Regular School No Middle 06 08 2018   grade_7 22 83 35   0 52     6   23   97 124 0   33   13   170       9.0 221 22 83 35   0 52     6   23   97 124 0   33 13 170     9 221
2468288 2468288 WA Thurston   school 5307470 34401   Rochester School District 530747001118 3067 Rochester Middle School   Regular School No Middle 06 08 2018   grade_7 104 0 40   6 0     0   15   82 83 0   11   10   87       9.0 165 104 0 40   6 0     0   15   82 83 0   11 10 87     9 165
2469770 2469770 WA Kitsap   school 5308160 18402   South Kitsap School District 530816001346 3680 Cedar Heights Middle School   Regular School No Middle 06 08 2018   grade_7 182 4 39   5 15     7   23   137 138 0   5   2   122       9.0 275 182 4 39   5 15     7   23   137 138 0   5 2 122     9 275
2470005 2470005 WA Spokane   school 5308250 32081   Spokane School District 530825002764 3008 Bryant Center   Alternative School No Other PK 12 2018   grade_7 74 2 14   0 2     0   6   55 43 0   0   0   26       9.0 98 74 2 14   0 2     0   6   55 43 0   0 0 26     9 98
2470592 2470592 WA Snohomish   school 5308550 31311   Sultan School District 530855001439 2105 Sultan Middle School   Regular School No Middle 06 08 2018   grade_7 125 1 35   1 0     0   4   93 73 0   11   5   91       9.0 166 125 1 35   1 0     0   4   93 73 0   11 5 91     9 166
2471755 2471755 WA Clark   school 5309270 6037   Vancouver School District 530927001570 3543 Jason Lee Middle School   Regular School No Middle 06 08 2018   grade_7 143 5 56   0 16     4   16   128 112 0   20   4   107       9.0 240 143 5 56   0 16     4   16   128 112 0   20 4 107     9 240
2471862 2471862 WA Clark   school 5309270 6037   Vancouver School District 530927003415 5271 Vancouver iTech Preparatory   Regular School No High 06 12 2018   grade_7 34 0 10   0 3     0   9   42 14 0   0   0   19       9.0 56 34 0 10   0 3     0   9   42 14 0   0 0 19     9 56
2472201 2472201 WA Clark   school 5309540 6112   Washougal School District 530954001892 4207 Jemtegaard Middle School   Regular School No Middle 06 08 2018   grade_7 154 0 32   0 0     0   11   93 104 0   9   2   87       9.0 197 154 0 32   0 0     0   11   93 104 0   9 2 87     9 197
2472284 2472284 WA Chelan   school 5309660 4246   Wenatchee School District 530966001006 4432 Foothills Middle School   Regular School No Middle 06 08 2018   grade_7 98 0 85   0 9     0   5   88 109 0   24   3   111       9.0 197 98 0 85   0 9     0   5   88 109 0   24 3 111     9 197
2570909 2570909 WA King   school 5300390 17405   Bellevue School District 530039003354 5240 Bellevue Big Picture School   Alternative School No High 06 12 2020   grade_7 31 0 4   0 30     0   11   40 36 0   5   0   9       9.0 76 31 0 4   0 30     0   11   40 36 0   5 0 9     9 76
2571349 2571349 WA Pierce   school 5300480 27403   Bethel School District 530048003158 4578 Cougar Mountain Middle School   Regular School No Middle 06 08 2020   grade_7 138 0 32   2 2     2   26   104 97 1   1   11   106       9.0 202 138 0 32   2 2     2   26   104 97 1   1 11 106     9 202
2571358 2571358 WA Pierce   school 5300480 27403   Bethel School District 530048000123 2877 Elk Plain School of Choice   Regular School No Elementary KG 08 2020   grade_7 46 7 9   0 4     0   15   39 42 0   4   1   35       9.0 81 46 7 9   0 4     0   15   39 42 0   4 1 35     9 81
2572370 2572370 WA Spokane   school 5301230 32360   Cheney School District 530123000224 2447 Cheney Middle School   Regular School No Middle 06 08 2020   grade_7 200 2 20   4 4     3   12   114 131 0   4   4   118       9.0 245 200 2 20   4 4     3   12   114 131 0   4 4 118     9 245
2572417 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
2572675 2572675 WA Pierce   school 5301410 27400   Clover Park School District 530141000257 3248 Hudtloff Middle School   Regular School No Middle 06 08 2020   grade_7 64 40 105   1 10     11   36   133 134 0   38   16   198       9.0 267 64 40 105   1 10     11   36   133 134 0   38 16 198     9 267
2573298 2573298 WA Douglas   school 5302310 9206   Eastmont School District 530231002948 4590 Clovis Point Intermediate School   Regular School No Middle 05 07 2020   grade_7 98 0 110   3 0     0   2   108 105 0   32   2   133       9.0 213 98 0 110   3 0     0   2   108 105 0   32 2 133     9 213
2573385 2573385 WA Pierce   school 5302370 27404   Eatonville School District 530237001899 4230 Eatonville Middle School   Regular School No Middle 06 08 2020   grade_7 116 1 11   2 0     1   9   67 71 2   3   4   68       9.0 140 116 1 11   2 0     1   9   67 71 2   3 4 68     9 140
2574419 2574419 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000428 4051 Wyeast Middle School   Regular School No Middle 06 08 2020   grade_7 123 11 113   3 9     13   30   160 142 0   56   7   188       9.0 302 123 11 113   3 9     13   30   160 142 0   56 7 188     9 302
2574510 2574510 WA King   school 5302820 17210   Federal Way School District 530282000437 3898 Illahee Middle School   Regular School No Middle 05 08 2020   grade_7 58 52 63   2 39     24   41   148 130 1   43   5   183       9.0 279 58 52 63   2 39     24   41   148 130 1   43 5 183     9 279
2574933 2574933 WA Spokane   school 5302970 32358   Freeman School District 530297003013 4593 Freeman Middle School   Regular School No Middle 06 08 2020   grade_7 76 0 5   0 0     0   0   39 42 0   0   0   19       9.0 81 76 0 5   0 0     0   0   39 42 0   0 0 19     9 81
2578351 2578351 WA Pend Oreille   school 5305610 26056   Newport School District 530561001911 3968 Sadie Halstead Middle School   Regular School No Middle 05 08 2020   grade_7 80 0 11   2 0     0   6   60 39 0   0   8   71       9.0 99 80 0 11   2 0     0   6   60 39 0   0 8 71     9 99
2578412 2578412 WA Whatcom   school 5305670 37506   Nooksack Valley School District 530567000838 2687 Nooksack Valley Middle School   Regular School No Middle 06 08 2020   grade_7 64 1 57   2 2     0   4   74 56 0   11   2   79       9.0 130 64 1 57   2 2     0   4   74 56 0   11 2 79     9 130
2579909 2579909 WA Pierce   school 5306690 27401   Peninsula School District 530669000983 2294 Goodman Middle School   Regular School No Middle 06 08 2020   grade_7 132 2 15   0 2     1   24   83 93 0   2   3   31       9.0 176 132 2 15   0 2     1   24   83 93 0   2 3 31     9 176

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