enrollments

Data source: Big Local News · About: Big Local

4,566 rows where grade = "grade_7" and state = "WA" sorted by ell 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
632608 632608 WA Yakima   school 5310110 39007   Yakima School District 531011001698 3615 Lewis & Clark Middle School   Regular School No Middle 06 08 2017   grade_7 39 1 242   2 0     2   4   141 149 0   99   6   250       5.0 290 39 1 242   2 0     2   4   141 149 0   99 6 250     5 290
621778 621778 WA Yakima   school 5303150 39200   Grandview School District 530315000498 3071 Grandview Middle School   Regular School No Middle 06 08 2017   grade_7 12 0 268   0 0     0   2   149 133 0   98   10   250       3.0 282 12 0 268   0 0     0   2   149 133 0   98 10 250     3 282
2462177 2462177 WA Yakima   school 5303150 39200   Grandview School District 530315000498 3071 Grandview Middle School   Regular School No Middle 06 08 2018   grade_7 25 0 240   0 0     0   0   132 133 0   98   16   220       2.0 265 25 0 240   0 0     0   0   132 133 0   98 16 220     2 265
621972 621972 WA King   school 5303540 17401   Highline School District 530354000522 3163 Cascade Middle School   Regular School No Middle 07 08 2017   grade_7 22 20 146   2 53     12   8   138 125 0   97   8   230       4.0 263 22 20 146   2 53     12   8   138 125 0   97 8 230     4 263
630516 630516 WA Yakima   school 5308670 39201   Sunnyside School District 530867001451 3313 Harrison Middle School   Regular School No Middle 06 08 2017   grade_7 17 0 292   0 0     0   8   156 161 0   96   9   255       4.0 317 17 0 292   0 0     0   8   156 161 0   96 9 255     4 317
2472809 2472809 WA Yakima   school 5310110 39007   Yakima School District 531011001698 3615 Lewis & Clark Middle School   Regular School No Middle 06 08 2018   grade_7 25 0 247   3 1     0   3   138 141 0   96   5   256       8.0 279 25 0 247   3 1     0   3   138 141 0   96 5 256     8 279
469212 469212 WA Adams   school 5306480 1147   Othello School District 530648000956 3471 McFarland Middle School   Regular School No 2.0 06 08 2015   grade_7 42 1 252   0 0     0   0   158 137 0   93   7   242       7.0 295 42 1 252   0 0     0   0   158 137 0   93 7 242     7 295
2945318 2945318 WA Yakima   school 5308970 39202   Toppenish School District 530897001535 2264 Toppenish Middle School   Regular School No Middle 06 08 2021   grade_7 3 1 260   36 2     0   4   155 151 0   93   2   270       12.0 306 3 1 260   36 2     0   4   155 151 0   93 2 270     12 306
2945734 2945734 WA Clark   school 5309270 6037   Vancouver School District 530927001577 3146 Mcloughlin Middle School   Regular School No Middle 06 08 2021   grade_7 107 7 173   3 8     23   17   169 169 0   93   9   269       8.0 338 107 7 173   3 8     23   17   169 169 0   93 9 269     8 338
475320 475320 WA Yakima   school 5310110 39007   Yakima School District 531011001698 3615 Lewis & Clark Middle School   Regular School No 2.0 06 08 2015   grade_7 42 1 239   2 0     1   5   147 143 0   91   8   273       5.0 290 42 1 239   2 0     1   5   147 143 0   91 8 273     5 290
622951 622951 WA King   school 5303960 17415   Kent School District 530396002986 5016 Mill Creek Middle School   Regular School No Middle 07 08 2017   grade_7 67 67 150   1 66     22   46   206 213 0   91   15   331       12.0 419 67 67 150   1 66     22   46   206 213 0   91 15 331     12 419
2470719 2470719 WA Yakima   school 5308670 39201   Sunnyside School District 530867001451 3313 Harrison Middle School   Regular School No Middle 06 08 2018   grade_7 15 0 282   0 0     0   5   155 147 0   91   15   243       6.0 302 15 0 282   0 0     0   5   155 147 0   91 15 243     6 302
2945948 2945948 WA Grant   school 5309360 13073   Wahluke School District 530936003264 5144 Wahluke Junior High   Regular School No Middle 06 08 2021   grade_7 5 0 209   1 0     0   0   107 108 0   91   23   203       3.0 215 5 0 209   1 0     0   0   107 108 0   91 23 203     3 215
2946756 2946756 WA Yakima   school 5310110 39007   Yakima School District 531011001698 3615 Lewis & Clark Middle School   Regular School No Middle 06 08 2021   grade_7 31 0 256   4 0     0   7   136 162 0   91   5   262       6.0 298 31 0 256   4 0     0   7   136 162 0   91 5 262     6 298
2427286 2427286 WA Clark   school 5309270 6037   Vancouver School District 530927001577 3146 Mcloughlin Middle School   Regular School No Middle 06 08 2019   grade_7 105 11 160   2 10     23   24   172 163 0   90   15   272       8.0 335 105 11 160   2 10     23   24   172 163 0   90 15 272     8 335
2471786 2471786 WA Clark   school 5309270 6037   Vancouver School District 530927001577 3146 Mcloughlin Middle School   Regular School No Middle 06 08 2018   grade_7 107 12 159   0 10     16   21   151 174 0   90   10   264       11.0 325 107 12 159   0 10     16   21   151 174 0   90 10 264     11 325
2946821 2946821 WA Yakima   school 5310110 39007   Yakima School District 531011001708 2314 Washington Middle School   Regular School No Middle 06 08 2021   grade_7 8 1 266   4 0     0   4   147 136 0   90   9   262       14.0 283 8 1 266   4 0     0   4   147 136 0   90 9 262     14 283
460491 460491 WA King   school 5300390 17405   Bellevue School District 530039000094 3283 Tyee Middle School   Regular School No 2.0 06 08 2015   grade_7 107 3 22   0 164     1   29   164 162 0   9   3   62       18.0 326 107 3 22   0 164     1   29   164 162 0   9 3 62     18 326
461692 461692 WA Lewis   school 5301170 21302   Chehalis School District 530117002252 4311 Chehalis Middle School   Regular School No 2.0 06 08 2015   grade_7 176 2 28   0 7     0   11   102 122 0   9   11   124       0.0 224 176 2 28   0 7     0   11   102 122 0   9 11 124     0 224
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
465032 465032 WA King   school 5303750 17411   Issaquah School District 530375000573 3038 Issaquah Middle School   Regular School No 2.0 06 08 2015   grade_7 170 5 32   1 44     2   11   128 137 0   9   1   37       18.0 265 170 5 32   1 44     2   11   128 137 0   9 1 37     18 265
466471 466471 WA Cowlitz   school 5304470 8122   Longview School District 530447000705 2831 Monticello Middle School   Regular School No 2.0 06 08 2015   grade_7 80 0 42   3 4     1   12   72 70 0   9   10   114       1.0 142 80 0 42   3 4     1   12   72 70 0   9 10 114     1 142
467350 467350 WA Grant   school 5305220 13161   Moses Lake School District 530522003482 5354 Endeavor Middle School   Regular School No 2.0 06 08 2015   grade_7 29 3 50   1 0     0   4   47 40 0   9   8   79       5.0 87 29 3 50   1 0     0   4   47 40 0   9 8 79     5 87
470847 470847 WA King   school 5307710 17001   Seattle School District No. 1 530771001145 2209 Broadview-Thomson K-8 School   Regular School No 1.0 PK 08 2015   grade_7 26 12 14   1 7     0   5   33 32 0   9   7   43       2.0 65 26 12 14   1 7     0   5   33 32 0   9 7 43     2 65
472519 472519 WA Spokane   school 5308250 32081   Spokane School District 530825001377 3258 Glover Middle School   Regular School No 2.0 07 08 2015   grade_7 237 10 35   11 2     3   46   175 169 0   9   23   242       14.0 344 237 10 35   11 2     3   46   175 169 0   9 23 242     14 344
473145 473145 WA Pierce   school 5308610 27320   Sumner School District 530861001447 3499 Sumner Middle School   Regular School No 2.0 06 09 2015   grade_7 159 2 40   5 4     2   15   110 117 0   9   5   102       11.0 227 159 2 40   5 4     2   15   110 117 0   9 5 102     11 227
473596 473596 WA Pierce   school 5308700 27010   Tacoma School District 530870001507 3448 Truman   Regular School No 2.0 06 08 2015   grade_7 156 43 25   4 30     3   4   116 149 0   9   11   161       3.0 265 156 43 25   4 30     3   4   116 149 0   9 11 161     3 265
473798 473798 WA Okanogan   school 5308940 24404   Tonasket School District 530894001647 4196 Tonasket Middle School   Regular School No 2.0 06 08 2015   grade_7 50 0 30   0 0     0   5   47 38 0   9   4   62       0.0 85 50 0 30   0 0     0   5   47 38 0   9 4 62     0 85
520559 520559 WA Whatcom   school 5300420 37501   Bellingham School District 530042001739 4442 Kulshan Middle School   Regular School No 2 06 08 2016   grade_7 121 5 35   1 6     0   13   85 96 0   9   2   86       13.0 181 121 5 35   1 6     0   13   85 96 0   9 2 86     13 181
521262 521262 WA Chelan   school 5300960 4222   CASHMERE SCHOOL DISTRICT 530096000169 2315 CASHMERE MIDDLE SCHOOL   Regular School No 2 05 08 2016   grade_7 80 1 46   2 1     0   3   61 72 0   9   3   67       6.0 133 80 1 46   2 1     0   3   61 72 0   9 3 67     6 133
521373 521373 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108000183 3791 Fairview Middle School   Regular School No 2 07 08 2016   grade_7 138 9 37   0 18     4   38   121 123 0   9   15   115       13.0 244 138 9 37   0 18     4   38   121 123 0   9 15 115     13 244
521542 521542 WA Spokane   school 5301110 32356   Central Valley School District 530111000198 2776 North Pines Middle School   Regular School No 2 06 08 2016   grade_7 120 5 16   4 5     5   8   83 80 0   9   12   118       7.0 163 120 5 16   4 5     5   8   83 80 0   9 12 118     7 163
524986 524986 WA King   school 5303750 17411   Issaquah School District 530375000573 3038 Issaquah Middle School   Regular School No 2 06 08 2016   grade_7 139 6 23   1 50     0   16   108 127 0   9   1   37       12.0 235 139 6 23   1 50     0   16   108 127 0   9 1 37     12 235
525595 525595 WA King   school 5303960 17415   Kent School District 530396002521 4485 Northwood Middle School   Regular School No 2 07 08 2016   grade_7 141 31 29   3 69     3   42   160 158 0   9   2   101       24.0 318 141 31 29   3 69     3   42   160 158 0   9 2 101     24 318
526391 526391 WA Cowlitz   school 5304470 8122   Longview School District 530447000699 3475 Cascade Middle School   Regular School No 2 06 08 2016   grade_7 110 1 34   4 3     0   17   76 93 0   9   11   109       5.0 169 110 1 34   4 3     0   17   76 93 0   9 11 109     5 169
526435 526435 WA Cowlitz   school 5304470 8122   Longview School District 530447000705 2831 Monticello Middle School   Regular School No 2 06 08 2016   grade_7 99 1 41   5 7     0   13   88 78 0   9   8   125       2.0 166 99 1 41   5 7     0   13   88 78 0   9 8 125     2 166
528291 528291 WA King   school 5305910 17417   Northshore School District 530591000879 3493 Canyon Park Middle School   Regular School No 2 07 09 2016   grade_7 179 7 34   0 21     1   26   123 145 0   9   4   73       7.0 268 179 7 34   0 21     1   26   123 145 0   9 4 73     7 268
528454 528454 WA King   school 5305910 17417   Northshore School District 530591000480 4371 Skyview Middle School   Regular School No 2 07 09 2016   grade_7 174 8 44   3 98     1   34   178 184 0   9   0   66       14.0 362 174 8 44   3 98     1   34   178 184 0   9 0 66     14 362
529040 529040 WA Douglas   school 5306390 9013   Orondo School District 530639000949 2666 Orondo Elementary and Middle School   Regular School No 1 PK 07 2016   grade_7 0 0 18   0 0     0   0   5 13 0   9   6   18       0.0 18 0 0 18   0 0     0   0   5 13 0   9 6 18     0 18
529685 529685 WA Pierce   school 5306960 27003   Puyallup School District 530696001022 3447 Aylen Jr High   Regular School No 2 07 09 2016   grade_7 130 1 43   4 8     1   15   108 94 0   9   3   83       11.0 202 130 1 43   4 8     1   15   108 94 0   9 3 83     11 202
529690 529690 WA Pierce   school 5306960 27003   Puyallup School District 530696001026 3750 Ballou Jr High   Regular School No 2 07 09 2016   grade_7 130 10 35   4 21     0   30   114 116 0   9   3   96       17.0 230 130 10 35   4 21     0   30   114 116 0   9 3 96     17 230
530010 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
534042 534042 WA Pierce   school 5309180 27083   University Place School District 530918002383 4325 Drum Intermediate   Regular School No 2 05 07 2016   grade_7 103 19 33   0 14     1   41   95 116 0   9   4   87       7.0 211 103 19 33   0 14     1   41   95 116 0   9 4 87     7 211
534311 534311 WA Clark   school 5309270 6037   Vancouver School District 530927002944 4591 Thomas Jefferson Middle School   Regular School No 2 06 08 2016   grade_7 208 4 30   0 9     1   20   132 140 0   9   0   85       12.0 272 208 4 30   0 9     1   20   132 140 0   9 0 85     12 272
617569 617569 WA Clark   school 5300380 6119   Battle Ground School District 530038000052 3545 Laurin Middle School   Regular School No Middle 05 08 2017   grade_7 104 2 22   1 11     0   8   66 82 0   9   3   62       5.0 148 104 2 22   1 11     0   8   66 82 0   9 3 62     5 148
617923 617923 WA Whatcom   school 5300420 37501   Bellingham School District 530042001739 4442 Kulshan Middle School   Regular School No Middle 06 08 2017   grade_7 112 5 31   2 11     0   16   94 83 0   9   7   89       14.0 177 112 5 31   2 11     0   16   94 83 0   9 7 89     14 177
619023 619023 WA Lewis   school 5301170 21302   Chehalis School District 530117002252 4311 Chehalis Middle School   Regular School No Middle 06 08 2017   grade_7 155 1 46   0 3     1   12   115 103 0   9   8   117       2.0 218 155 1 46   0 3     1   12   115 103 0   9 8 117     2 218
622630 622630 WA Benton   school 5303930 3017   Kennewick School District 530393000750 4429 Horse Heaven Hills Middle School   Regular School No Middle 06 08 2017   grade_7 169 1 80   0 0     0   15   138 127 0   9   0   141       10.0 265 169 1 80   0 0     0   15   138 127 0   9 0 141     10 265
623713 623713 WA Snohomish   school 5304260 31306   Lakewood School District 530426000686 3893 Lakewood Middle School   Regular School No Middle 06 08 2017   grade_7 144 4 27   5 2     2   18   103 99 0   9   4   79       7.0 202 144 4 27   5 2     2   18   103 99 0   9 4 79     7 202
627119 627119 WA Pierce   school 5306960 27003   Puyallup School District 530696001022 3447 Aylen Jr High   Regular School No Other 07 09 2017   grade_7 155 7 48   2 9     4   29   131 123 0   9   4   90       23.0 254 155 7 48   2 9     4   29   131 123 0   9 4 90     23 254
629873 629873 WA Spokane   school 5308250 32081   Spokane School District 530825001377 3258 Glover Middle School   Regular School No Middle 07 08 2017   grade_7 143 11 27   4 5     4   38   125 107 0   9   13   191       6.0 232 143 11 27   4 5     4   38   125 107 0   9 13 191     6 232
630725 630725 WA Pierce   school 5308700 27010   Tacoma School District 530870001473 2338 Jason Lee   Regular School No Middle 06 08 2017   grade_7 64 47 19   3 11     4   15   82 81 0   9   16   107       3.0 163 64 47 19   3 11     4   15   82 81 0   9 16 107     3 163
631381 631381 WA Pierce   school 5309180 27083   University Place School District 530918002383 4325 Drum Intermediate   Regular School No Middle 05 07 2017   grade_7 105 18 30   2 18     2   40   98 117 0   9   5   88       13.0 215 105 18 30   2 18     2   40   98 117 0   9 5 88     13 215
631641 631641 WA Clark   school 5309270 6037   Vancouver School District 530927002944 4591 Thomas Jefferson Middle School   Regular School No Middle 06 08 2017   grade_7 211 6 40   2 7     1   11   150 128 0   9   7   77       12.0 278 211 6 40   2 7     1   11   150 128 0   9 7 77     12 278
632060 632060 WA Stevens   school 5309630 33049   Wellpinit School District #49 530963003150 4232 Wellpinit Middle School   Regular School No Middle 06 08 2017   grade_7 1 0 1   14 0     0   5   12 9 0   9   5   19       0.0 21 1 0 1   14 0     0   5   12 9 0   9 5 19     0 21
2413540 2413540 WA Clark   school 5300380 6119   Battle Ground School District 530038000054 3997 Pleasant Valley Middle   Regular School No Middle 05 08 2019   grade_7 79 3 23   1 9     4   13   66 66 0   9   4   53       10.0 132 79 3 23   1 9     4   13   66 66 0   9 4 53     10 132
2414675 2414675 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108000183 3791 Fairview Middle School   Regular School No Middle 06 08 2019   grade_7 118 13 32   0 11     2   40   115 101 0   9   4   109       14.0 216 118 13 32   0 11     2   40   115 101 0   9 4 109     14 216
2414783 2414783 WA Spokane   school 5301110 32356   Central Valley School District 530111000193 3890 Evergreen Middle School   Regular School No Middle 06 08 2019   grade_7 233 4 0   6 8     2   7   141 119 0   9   6   107       14.0 260 233 4 0   6 8     2   7   141 119 0   9 6 107     14 260
2416504 2416504 WA King   school 5300001 17216   Enumclaw School District 530000102795 4550 Thunder Mountain Middle School   Regular School No Middle 06 08 2019   grade_7 110 2 37   4 3     0   5   88 73 0   9   3   36       4.0 161 110 2 37   4 3     0   5   88 73 0   9 3 36     4 161
2416679 2416679 WA Snohomish   school 5302670 31002   Everett School District 530267001725 4437 Gateway Middle School   Regular School No Middle 06 08 2019   grade_7 141 9 26   2 71     1   31   169 112 0   9   5   36       20.0 281 141 9 26   2 71     1   31   169 112 0   9 5 36     20 281
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
2419650 2419650 WA Cowlitz   school 5304470 8122   Longview School District 530447000699 3475 Cascade Middle School   Regular School No Middle 06 08 2019   grade_7 137 0 49   4 4     0   9   97 106 0   9   14   134       5.0 203 137 0 49   4 4     0   9   97 106 0   9 14 134     5 203
2420273 2420273 WA King   school 5304980 17400   Mercer Island School District 530498000764 3219 Islander Middle School   Regular School No Middle 06 08 2019   grade_7 228 1 17   1 86     0   38   206 165 0   9   0   19       68.0 371 228 1 17   1 86     0   38   206 165 0   9 0 19     68 371
2420991 2420991 WA Okanogan   school 5305550 24014   Nespelem School District #14 530555000832 2494 Nespelem Elementary   Regular School No Elementary PK 08 2019   grade_7 1 0 0   12 0     0   0   9 4 0   9   0   13       0.0 13 1 0 0   12 0     0   0   9 4 0   9 0 13     0 13
2421604 2421604 WA King   school 5305910 17417   Northshore School District 530591000891 4021 Northshore Middle School   Regular School No Middle 06 08 2019   grade_7 178 4 53   0 58     0   37   183 147 0   9   0   50       35.0 330 178 4 53   0 58     0   37   183 147 0   9 0 50     35 330
2422753 2422753 WA Walla Walla   school 5306870 36402   Prescott School District 530687001010 3575 Prescott Jr Sr High   Regular School No High 07 12 2019   grade_7 2 0 20   0 0     0   0   11 11 0   9   0   22       2.0 22 2 0 20   0 0     0   0   11 11 0   9 0 22     2 22
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
2422916 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
2424488 2424488 WA King   school 5307710 17001   Seattle School District No. 1 530771001311 1596 Seattle World School   Alternative School No High 06 12 2019   grade_7 1 2 5   0 7     0   0   8 7 0   9   4   14       0.0 15 1 2 5   0 7     0   0   8 7 0   9 4 14     0 15
2425103 2425103 WA Snohomish   school 5308020 31201   Snohomish School District 530802001790 4145 Valley View Middle School   Regular School No Middle 07 08 2019   grade_7 231 1 37   0 20     0   24   143 170 0   9   0   47       29.0 313 231 1 37   0 20     0   24   143 170 0   9 0 47     29 313
2427001 2427001 WA Thurston   school 5309100 34033   Tumwater School District 530910001734 4452 George Washington Bush Middle Sch   Regular School No Middle 06 08 2019   grade_7 175 1 34   2 2     0   24   130 108 0   9   8   85       10.0 238 175 1 34   2 2     0   24   130 108 0   9 8 85     10 238
2427095 2427095 WA Pierce   school 5309180 27083   University Place School District 530918001550 3296 Narrows View Intermediate   Regular School No Middle 05 07 2019   grade_7 114 20 30   1 23     3   31   124 98 0   9   5   99       16.0 222 114 20 30   1 23     3   31   124 98 0   9 5 99     16 222
2458425 2458425 WA Whatcom   school 5300420 37501   Bellingham School District 530042001739 4442 Kulshan Middle School   Regular School No Middle 06 08 2018   grade_7 135 4 36   2 4     0   15   104 92 0   9   8   84       20.0 196 135 4 36   2 4     0   15   104 92 0   9 8 84     20 196
2458699 2458699 WA Pierce   school 5300480 27403   Bethel School District 530048000128 3751 Spanaway Middle School   Regular School No Middle 06 08 2018   grade_7 80 28 54   3 14     16   32   111 116 0   9   11   147       11.0 227 80 28 54   3 14     16   32   111 116 0   9 11 147     11 227
2459500 2459500 WA Lewis   school 5301170 21302   Chehalis School District 530117002252 4311 Chehalis Middle School   Regular School No Middle 06 08 2018   grade_7 156 0 36   0 2     0   12   108 98 0   9   9   107       4.0 206 156 0 36   0 2     0   12   108 98 0   9 9 107     4 206
2459592 2459592 WA Spokane   school 5301230 32360   Cheney School District 530123003428 5269 Westwood Middle School   Regular School No Middle 06 08 2018   grade_7 139 6 18   5 4     3   19   96 98 0   9   4   98       13.0 194 139 6 18   5 4     3   19   96 98 0   9 4 98     13 194
2462767 2462767 WA King   school 5303750 17411   Issaquah School District 530375000579 3636 Maywood Middle School   Regular School No Middle 06 08 2018   grade_7 211 4 37   0 88     0   25   173 192 0   9   7   49       24.0 365 211 4 37   0 88     0   25   173 192 0   9 7 49     24 365
2464051 2464051 WA Snohomish   school 5304260 31306   Lakewood School District 530426000686 3893 Lakewood Middle School   Regular School No Middle 06 08 2018   grade_7 121 2 29   0 3     3   16   86 88 0   9   10   66       13.0 174 121 2 29   0 3     3   16   86 88 0   9 10 66     13 174
2465833 2465833 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585000868 3611 Nisqually Middle School   Regular School No Middle 06 08 2018   grade_7 122 17 49   3 12     7   33   114 129 0   9   8   107       16.0 243 122 17 49   3 12     7   33   114 129 0   9 8 107     16 243
2466353 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
2467655 2467655 WA Clallam   school 5307020 5402   Quillayute Valley School District 530702001047 2349 Forks High School   Regular School No High 07 12 2018   grade_7 48 0 27   1 1     0   5   45 37 0   9   0   42       1.0 82 48 0 27   1 1     0   5   45 37 0   9 0 42     1 82
2469008 2469008 WA King   school 5307710 17001   Seattle School District No. 1 530771002933 4218 South Shore PK-8 School   Regular School No Elementary PK 08 2018   grade_7 1 32 8   1 20     1   6   34 35 0   9   7   45       1.0 69 1 32 8   1 20     1   6   34 35 0   9 7 45     1 69
2469758 2469758 WA Pacific   school 5308100 25118   South Bend School District 530810001337 2214 South Bend High School   Regular School No High 07 12 2018   grade_7 23 0 28   1 2     1   8   34 29 0   9   5   46       2.0 63 23 0 28   1 2     1   8   34 29 0   9 5 46     2 63
2471597 2471597 WA Pierce   school 5309180 27083   University Place School District 530918001550 3296 Narrows View Intermediate   Regular School No Middle 05 07 2018   grade_7 124 18 44   3 23     2   38   114 138 0   9   4   100       19.0 252 124 18 44   3 23     2   38   114 138 0   9 4 100     19 252
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
2472372 2472372 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001645 3538 Centennial Middle School   Regular School No Middle 06 08 2018   grade_7 145 4 26   2 2     1   25   118 87 0   9   11   127       8.0 205 145 4 26   2 2     1   25   118 87 0   9 11 127     8 205
2575737 2575737 WA Cowlitz   school 5300003 8458   Kelso School District 530000300591 3322 Coweeman Middle School   Regular School No Middle 06 08 2020   grade_7 133 1 25   2 1     3   7   92 80 0   9   0   106       8.0 172 133 1 25   2 1     3   7   92 80 0   9 0 106     8 172
2575815 2575815 WA Benton   school 5303930 3017   Kennewick School District 530393003586 5439 Chinook Middle School   Regular School No Middle 06 08 2020   grade_7 223 6 94   2 6     0   23   189 165 0   9   4   186       10.0 354 223 6 94   2 6     0   23   189 165 0   9 4 186     10 354
2576535 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
2576950 2576950 WA Snohomish   school 5304260 31306   Lakewood School District 530426000686 3893 Lakewood Middle School   Regular School No Middle 06 08 2020   grade_7 133 6 31   0 4     4   26   113 91 0   9   5   86       13.0 204 133 6 31   0 4     4   26   113 91 0   9 5 86     13 204
2578670 2578670 WA Thurston   school 5305850 34003   North Thurston Public Schools 530585000606 4409 Komachin Middle School   Regular School No Middle 06 08 2020   grade_7 110 12 52   2 18     8   38   141 99 0   9   7   117       15.0 240 110 12 52   2 18     8   38   141 99 0   9 7 117     15 240
2582619 2582619 WA Grant   school 5308070 13156   Soap Lake School District 530807001335 3089 Soap Lake Middle & High School   Regular School No High 06 12 2020   grade_7 27 1 22   0 1     0   0   27 24 0   9   5   48       0.0 51 27 1 22   0 1     0   0   27 24 0   9 5 48     0 51
2583158 2583158 WA Spokane   school 5308250 32081   Spokane School District 530825001405 3356 Sacajawea Middle School   Regular School No Middle 07 08 2020   grade_7 310 16 33   3 14     2   53   237 194 1   9   5   150       21.0 432 310 16 33   3 14     2   53   237 194 1   9 5 150     21 432
2583165 2583165 WA Spokane   school 5308250 32081   Spokane School District 530825001406 3413 Salk Middle School   Regular School No Middle 06 08 2020   grade_7 255 10 38   4 1     1   51   180 180 0   9   13   205       15.0 360 255 10 38   4 1     1   51   180 180 0   9 13 205     15 360
2583831 2583831 WA Pierce   school 5308700 27010   Tacoma School District 530870001473 2338 Jason Lee   Regular School No Middle 06 08 2020   grade_7 83 47 25   2 6     3   31   101 96 0   9   25   133       12.0 197 83 47 25   2 6     3   31   101 96 0   9 25 133     12 197
2933220 2933220 WA Lewis   school 5301170 21302   Chehalis School District 530117002252 4311 Chehalis Middle School   Regular School No Middle 06 08 2021   grade_7 171 1 48   2 3     1   17   128 115 0   9   6   117       4.0 243 171 1 48   2 3     1   17   128 115 0   9 6 117     4 243
2941167 2941167 WA Pierce   school 5306960 27003   Puyallup School District 530696001022 3447 Aylen Jr High   Regular School No Middle 07 09 2021   grade_7 138 6 50   4 12     0   26   125 111 0   9   6   83       19.0 236 138 6 50   4 12     0   26   125 111 0   9 6 83     19 236
2942629 2942629 WA King   school 5307710 17001   Seattle School District No. 1 530771003426 5276 Louisa Boren STEM K-8   Regular School No Elementary PK 08 2021   grade_7 43 14 9   0 7     0   9   54 27 1   9   3   25       4.0 82 43 14 9   0 7     0   9   54 27 1   9 3 25     4 82
2942980 2942980 WA King   school 5307710 17001   Seattle School District No. 1 530771001264 3277 Whitman Middle School   Regular School No Middle 06 08 2021   grade_7 147 8 24   1 7     1   23   104 106 1   9   8   38       8.0 211 147 8 24   1 7     1   23   104 106 1   9 8 38     8 211
2944465 2944465 WA Snohomish   school 5308550 31311   Sultan School District 530855001439 2105 Sultan Middle School   Regular School No Middle 06 08 2021   grade_7 86 4 35   0 3     2   3   70 63 0   9   0   62       4.0 133 86 4 35   0 3     2   3   70 63 0   9 0 62     4 133

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