enrollments

Data source: Big Local News · About: Big Local

4,566 rows where grade = "grade_7" and state = "WA" sorted by county 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
462612 462612 WA Yakima   school 5305370 39090   East Valley School District (Yakima) 530537000806 4055 East Valley Central Middle School   Regular School No 2.0 06 08 2015   grade_7 103 1 112   4 4     0   3   118 109 0   18   0   146       2.0 227 103 1 112   4 4     0   3   118 109 0   18 0 146     2 227
464448 464448 WA Yakima   school 5303150 39200   Grandview School District 530315000498 3071 Grandview Middle School   Regular School No 2.0 06 08 2015   grade_7 14 0 261   0 0     0   1   131 145 0   86   10   247       0.0 276 14 0 261   0 0     0   1   131 145 0   86 10 247     0 276
464485 464485 WA Yakima   school 5303180 39204   Granger School District 530318000504 2531 Granger Middle School   Regular School No 2.0 05 08 2015   grade_7 3 0 88   5 0     0   1   55 42 0   32   3   87       1.0 97 3 0 88   5 0     0   1   55 42 0   32 3 87     1 97
464592 464592 WA Yakima   school 5303510 39203   Highland School District 530351003148 2718 Highland Junior High School   Regular School No 2.0 07 09 2015   grade_7 18 2 60   2 0     0   3   45 40 0   18   3   65       1.0 85 18 2 60   2 0     0   3   45 40 0   18 3 65     1 85
466665 466665 WA Yakima   school 5304650 39120   Mabton School District 530465003406 5289 Mabton Jr. Sr. High   Regular School No 3.0 07 12 2015   grade_7 2 0 68   0 0     0   0   33 37 0   30   6   68       0.0 70 2 0 68   0 0     0   0   33 37 0   30 6 68     0 70
467481 467481 WA Yakima   school 5305280 39209   Mount Adams School District 530528001851 2389 Mount Adams Middle School   Regular School No 2.0 06 08 2015   grade_7 2 0 31   30 0     0   5   40 28 0   10   12   67       5.0 68 2 0 31   30 0     0   5   40 28 0   10 12 67     5 68
467792 467792 WA Yakima   school 5305460 39003   Naches Valley School District 530546000824 2898 Naches Valley Middle School   Regular School No 1.0 03 08 2015   grade_7 91 0 19   0 0     0   3   58 55 0   2   1   55       1.0 113 91 0 19   0 0     0   3   58 55 0   2 1 55     1 113
471637 471637 WA Yakima   school 5307770 39119   Selah School District 530777003348 5231 Selah HomeLink   Regular School No 1.0 KG 08 2015   grade_7 3 0 1   0 0     0   0   3 1 0   0   0   1       0.0 4 3 0 1   0 0     0   0   3 1 0   0 0 1     0 4
471643 471643 WA Yakima   school 5307770 39119   Selah School District 530777002779 4546 Selah Intermediate (Closed after 2014-2015 school year)   Regular School No 2.0 05 07 2015   grade_7 189 0 79   2 2     0   5   142 135 0   14   0   148       5.0 277 189 0 79   2 2     0   5   142 135 0   14 0 148     5 277
473167 473167 WA Yakima   school 5308670 39201   Sunnyside School District 530867001451 3313 Harrison Middle School   Regular School No 2.0 06 08 2015   grade_7 12 0 243   0 1     0   0   140 116 0   58   15   213       2.0 256 12 0 243   0 1     0   0   140 116 0   58 15 213     2 256
473186 473186 WA Yakima   school 5308670 39201   Sunnyside School District 530867003037 5049 Sierra Vista Middle School   Regular School No 2.0 06 08 2015   grade_7 18 0 199   0 0     0   1   102 116 0   62   7   177       1.0 218 18 0 199   0 0     0   1   102 116 0   62 7 177     1 218
473804 473804 WA Yakima   school 5308970 39202   Toppenish School District 530897002378 1508 Computer Academy Toppenish High School   Alternative Education School No 4.0 06 12 2015   grade_7 1 0 1   0 0     0   0   2 0 0   0   0   2       2.0 2 1 0 1   0 0     0   0   2 0 0   0 0 2     2 2
473839 473839 WA Yakima   school 5308970 39202   Toppenish School District 530897003385 5262 Northwest Allprep   Regular School No 4.0 KG 12 2015   grade_7 14 1 0   0 2     0   1   13 5 0   0   0   10       0.0 18 14 1 0   0 2     0   1   13 5 0   0 0 10     0 18
473846 473846 WA Yakima   school 5308970 39202   Toppenish School District 530897001534 2900 Toppenish High School   Regular School No 3.0 09 12 2015   grade_7 0 0 1   1 0     0   0   1 1 0   0   1   2       0.0 2 0 0 1   1 0     0   0   1 1 0   0 1 2     0 2
473850 473850 WA Yakima   school 5308970 39202   Toppenish School District 530897001535 2264 Toppenish Middle School   Regular School No 2.0 06 08 2015   grade_7 5 0 239   38 0     0   0   154 128 0   79   3   281       10.0 282 5 0 239   38 0     0   0   154 128 0   79 3 281     10 282
474039 474039 WA Yakima   school 5309150 39002   Union Gap School District 530915002382 2714 Union Gap School   Regular School No 1.0 PK 08 2015   grade_7 14 0 50   2 1     0   1   35 33 0   10   2   59       1.0 68 14 0 50   2 1     0   1   35 33 0   10 2 59     1 68
474634 474634 WA Yakima   school 5309480 39207   Wapato School District 530948001615 2131 Wapato Middle School   Regular School No 2.0 06 08 2015   grade_7 9 0 171   62 6     1   10   131 128 0   66   4   255       4.0 259 9 0 171   62 6     1   10   131 128 0   66 4 255     4 259
474989 474989 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972003340 5221 West Valley High School Freshman Campus (Closed after 2018-2019 school year)   Regular School No 4.0 09 09 2015   grade_7 1 0 1   0 0     0   0   2 0 0   0   0   2       0.0 2 1 0 1   0 0     0   0   2 0 0   0 0 2     0 2
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
475277 475277 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No 1.0 KG 08 2015   grade_7 11 0 16   0 0     0   1   15 13 0   3   1   17       1.0 28 11 0 16   0 0     0   1   15 13 0   3 1 17     1 28
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
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
475383 475383 WA Yakima   school 5310110 39007   Yakima School District 531011001708 2314 Washington Middle School   Regular School No 2.0 06 08 2015   grade_7 8 0 246   0 0     0   6   121 139 0   121   5   251       7.0 260 8 0 246   0 0     0   6   121 139 0   121 5 251     7 260
475395 475395 WA Yakima   school 5310110 39007   Yakima School District 531011001710 3368 Wilson Middle School   Regular School No 2.0 06 08 2015   grade_7 58 1 174   1 2     0   16   128 124 0   45   7   217       10.0 252 58 1 174   1 2     0   16   128 124 0   45 7 217     10 252
475403 475403 WA Yakima   school 5310110 39007   Yakima School District 531011003263 5153 Yakima Online   Alternative Education School No 4.0 KG 12 2015   grade_7 3 0 0   0 0     0   0   2 1 0   0   1   2       1.0 3 3 0 0   0 0     0   0   2 1 0   0 1 2     1 3
475504 475504 WA Yakima   school 5310170 39205   Zillah School District 531017002502 4481 Zillah Middle School   Regular School No 2.0 07 08 2015   grade_7 35 0 51   5 0     0   4   57 38 0   10   3   56       2.0 95 35 0 51   5 0     0   4   57 38 0   10 3 56     2 95
522597 522597 WA Yakima   school 5305370 39090   East Valley School District (Yakima) 530537000806 4055 East Valley Central Middle School   Regular School No 4 06 12 2016   grade_7 98 4 100   2 2     0   3   110 99 0   15   6   143       8.0 209 98 4 100   2 2     0   3   110 99 0   15 6 143     8 209
524400 524400 WA Yakima   school 5303150 39200   Grandview School District 530315000498 3071 Grandview Middle School   Regular School No 2 06 08 2016   grade_7 19 0 254   0 0     0   1   129 145 0   71   5   240       3.0 274 19 0 254   0 0     0   1   129 145 0   71 5 240     3 274
524437 524437 WA Yakima   school 5303180 39204   Granger School District 530318000504 2531 Granger Middle School   Regular School No 2 05 08 2016   grade_7 7 0 99   4 0     0   0   54 56 0   22   0   93       2.0 110 7 0 99   4 0     0   0   54 56 0   22 0 93     2 110
524545 524545 WA Yakima   school 5303510 39203   Highland School District 530351003148 2718 Highland Junior High School   Regular School No 2 07 08 2016   grade_7 19 0 56   0 1     0   1   37 40 0   13   2   67       3.0 77 19 0 56   0 1     0   1   37 40 0   13 2 67     3 77
526614 526614 WA Yakima   school 5304650 39120   Mabton School District 530465003406 5289 Mabton Jr. Sr. High   Regular School No 3 07 12 2016   grade_7 1 0 60   0 0     0   0   28 33 0   23   2   59       1.0 61 1 0 60   0 0     0   0   28 33 0   23 2 59     1 61
527401 527401 WA Yakima   school 5305280 39209   Mount Adams School District 530528001851 2389 Mount Adams Middle School   Regular School No 2 07 08 2016   grade_7 2 0 23   39 0     0   0   33 31 0   2   15   58       7.0 64 2 0 23   39 0     0   0   33 31 0   2 15 58     7 64
527702 527702 WA Yakima   school 5305460 39003   Naches Valley School District 530546000824 2898 Naches Valley Middle School   Regular School No 2 05 08 2016   grade_7 63 1 16   0 0     0   2   40 42 0   5   3   37       3.0 82 63 1 16   0 0     0   2   40 42 0   5 3 37     3 82
531638 531638 WA Yakima   school 5307770 39119   Selah School District 530777003348 5231 Selah HomeLink   Regular School No 1 KG 08 2016   grade_7 3 0 0   0 0     0   0   1 2 0   0   0   1       0.0 3 3 0 0   0 0     0   0   1 2 0   0 0 1     0 3
531647 531647 WA Yakima   school 5307770 39119   Selah School District 530777003554 5385 Selah Middle School   Regular School No 2 06 08 2016   grade_7 171 0 66   3 0     1   9   131 119 0   12   1   131       7.0 250 171 0 66   3 0     1   9   131 119 0   12 1 131     7 250
533176 533176 WA Yakima   school 5308670 39201   Sunnyside School District 530867001451 3313 Harrison Middle School   Regular School No 2 06 08 2016   grade_7 20 1 237   0 0     0   2   130 130 0   52   15   226       0.0 260 20 1 237   0 0     0   2   130 130 0   52 15 226     0 260
533199 533199 WA Yakima   school 5308670 39201   Sunnyside School District 530867003037 5049 Sierra Vista Middle School   Regular School No 2 06 08 2016   grade_7 10 0 220   0 0     0   5   124 111 0   54   16   208       4.0 235 10 0 220   0 0     0   5   124 111 0   54 16 208     4 235
533790 533790 WA Yakima   school 5308970 39202   Toppenish School District 530897002378 1508 Computer Academy Toppenish High School   Alternative Education School No 4 06 12 2016   grade_7 0 0 0   1 0     0   0   0 1 0   0   0   1       0.0 1 0 0 0   1 0     0   0   0 1 0   0 0 1     0 1
533822 533822 WA Yakima   school 5308970 39202   Toppenish School District 530897003385 5262 Northwest Allprep   Regular School No 4 KG 12 2016   grade_7 9 1 0   0 0     0   0   3 7 0   0   0   5       0.0 10 9 1 0   0 0     0   0   3 7 0   0 0 5     0 10
533833 533833 WA Yakima   school 5308970 39202   Toppenish School District 530897001535 2264 Toppenish Middle School   Regular School No 2 06 08 2016   grade_7 4 0 255   43 0     0   3   169 136 0   107   14   263       6.0 305 4 0 255   43 0     0   3   169 136 0   107 14 263     6 305
534018 534018 WA Yakima   school 5309150 39002   Union Gap School District 530915002382 2714 Union Gap School   Regular School No 1 PK 08 2016   grade_7 10 0 53   0 0     0   3   31 35 0   7   0   59       2.0 66 10 0 53   0 0     0   3   31 35 0   7 0 59     2 66
534593 534593 WA Yakima   school 5309480 39207   Wapato School District 530948001615 2131 Wapato Middle School   Regular School No 2 06 08 2016   grade_7 12 0 188   67 2     0   7   146 130 0   62   12   265       0.0 276 12 0 188   67 2     0   7   146 130 0   62 12 265     0 276
534930 534930 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001654 3074 West Valley High School   Regular School No 3 07 12 2016   grade_7 0 0 1   0 1     0   0   1 1 0   0   0   2       0.0 2 0 0 1   0 1     0   0   1 1 0   0 0 2     0 2
534934 534934 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972003340 5221 West Valley High School Freshman Campus (Closed after 2018-2019 school year)   Regular School No 4 07 10 2016   grade_7 1 0 1   1 0     0   0   2 1 0   1   0   3       0.0 3 1 0 1   1 0     0   0   2 1 0   1 0 3     0 3
534938 534938 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001653 4040 West Valley Jr High   Regular School No 2 07 08 2016   grade_7 284 4 128   5 10     1   6   209 229 0   20   1   206       11.0 438 284 4 128   5 10     1   6   209 229 0   20 1 206     11 438
535214 535214 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No 1 01 08 2016   grade_7 7 0 16   1 0     0   1   13 12 0   4   0   17       1.0 25 7 0 16   1 0     0   1   13 12 0   4 0 17     1 25
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
535257 535257 WA Yakima   school 5310110 39007   Yakima School District 531011001698 3615 Lewis & Clark Middle School   Regular School No 2 06 08 2016   grade_7 24 2 220   3 2     0   7   124 134 0   84   4   246       8.0 258 24 2 220   3 2     0   7   124 134 0   84 4 246     8 258
535325 535325 WA Yakima   school 5310110 39007   Yakima School District 531011001708 2314 Washington Middle School   Regular School No 2 06 08 2016   grade_7 12 2 243   1 1     0   1   132 128 0   115   14   255       4.0 260 12 2 243   1 1     0   1   132 128 0   115 14 255     4 260
535337 535337 WA Yakima   school 5310110 39007   Yakima School District 531011001710 3368 Wilson Middle School   Regular School No 2 06 08 2016   grade_7 71 3 202   0 4     0   7   151 136 0   46   11   247       8.0 287 71 3 202   0 4     0   7   151 136 0   46 11 247     8 287
535448 535448 WA Yakima   school 5310170 39205   Zillah School District 531017002502 4481 Zillah Middle School   Regular School No 2 07 08 2016   grade_7 48 0 62   6 1     0   3   69 51 0   10   4   71       1.0 120 48 0 62   6 1     0   3   69 51 0   10 4 71     1 120
619973 619973 WA Yakima   school 5305370 39090   East Valley School District (Yakima) 530537000806 4055 East Valley Central Middle School   Regular School No Middle 06 08 2017   grade_7 122 1 113   3 0     0   7   136 110 0   16   3   153       5.0 246 122 1 113   3 0     0   7   136 110 0   16 3 153     5 246
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
621818 621818 WA Yakima   school 5303180 39204   Granger School District 530318000504 2531 Granger Middle School   Regular School No Middle 05 08 2017   grade_7 4 0 121   2 0     0   1   64 64 0   28   1   111       0.0 128 4 0 121   2 0     0   1   64 64 0   28 1 111     0 128
621922 621922 WA Yakima   school 5303510 39203   Highland School District 530351003148 2718 Highland Junior High School   Regular School No Middle 07 08 2017   grade_7 18 0 84   0 0     0   0   44 58 0   29   4   89       1.0 102 18 0 84   0 0     0   0   44 58 0   29 4 89     1 102
621936 621936 WA Yakima   school 5303510 39203   Highland School District 530351000517 3073 Tieton Intermediate School   Regular School No Elementary 04 06 2017   grade_7 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
623990 623990 WA Yakima   school 5304650 39120   Mabton School District 530465003406 5289 Mabton Jr. Sr. High   Regular School No High 07 12 2017   grade_7 2 0 74   0 0     0   0   43 33 0   27   6   68       1.0 76 2 0 74   0 0     0   0   43 33 0   27 6 68     1 76
624805 624805 WA Yakima   school 5305280 39209   Mount Adams School District 530528001851 2389 Mount Adams Middle School   Regular School No Middle 07 08 2017   grade_7 0 0 19   47 0     0   3   32 37 0   29   8   65       7.0 69 0 0 19   47 0     0   3   32 37 0   29 8 65     7 69
625137 625137 WA Yakima   school 5305460 39003   Naches Valley School District 530546000824 2898 Naches Valley Middle School   Regular School No Middle 05 08 2017   grade_7 73 0 29   1 1     0   4   52 56 0   10   2   59       3.0 108 73 0 29   1 1     0   4   52 56 0   10 2 59     3 108
628974 628974 WA Yakima   school 5307770 39119   Selah School District 530777002149 4272 Selah Academy Online   Alternative School No High 08 12 2017   grade_7 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
628988 628988 WA Yakima   school 5307770 39119   Selah School District 530777003348 5231 Selah HomeLink   Regular School No Elementary KG 08 2017   grade_7 7 0 0   0 0     0   0   2 5 0   0   0   2       0.0 7 7 0 0   0 0     0   0   2 5 0   0 0 2     0 7
628997 628997 WA Yakima   school 5307770 39119   Selah School District 530777003554 5385 Selah Middle School   Regular School No Middle 06 08 2017   grade_7 175 1 91   4 2     0   12   144 141 0   19   2   154       4.0 285 175 1 91   4 2     0   12   144 141 0   19 2 154     4 285
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
630538 630538 WA Yakima   school 5308670 39201   Sunnyside School District 530867003037 5049 Sierra Vista Middle School   Regular School No Middle 06 08 2017   grade_7 20 0 193   0 0     0   2   109 106 0   58   7   194       2.0 215 20 0 193   0 0     0   2   109 106 0   58 7 194     2 215
631126 631126 WA Yakima   school 5308970 39202   Toppenish School District 530897002378 1508 Computer Academy Toppenish High School   Alternative School No Other 06 12 2017   grade_7 0 0 2   0 0     0   0   1 1 0   1   0   2       0.0 2 0 0 2   0 0     0   0   1 1 0   1 0 2     0 2
631158 631158 WA Yakima   school 5308970 39202   Toppenish School District 530897003385 5262 Northwest Allprep   Regular School No Other KG 12 2017   grade_7 32 1 2   0 2     0   0   18 19 0   0   0   8       0.0 37 32 1 2   0 2     0   0   18 19 0   0 0 8     0 37
631168 631168 WA Yakima   school 5308970 39202   Toppenish School District 530897001535 2264 Toppenish Middle School   Regular School No Middle 06 08 2017   grade_7 6 1 221   47 0     0   1   138 138 0   122   19   241       7.0 276 6 1 221   47 0     0   1   138 138 0   122 19 241     7 276
631354 631354 WA Yakima   school 5309150 39002   Union Gap School District 530915002382 2714 Union Gap School   Regular School No Elementary PK 08 2017   grade_7 11 0 54   1 1     0   1   42 26 0   14   0   62       0.0 68 11 0 54   1 1     0   1   42 26 0   14 0 62     0 68
631925 631925 WA Yakima   school 5309480 39207   Wapato School District 530948001615 2131 Wapato Middle School   Regular School No Middle 06 08 2017   grade_7 8 0 178   58 8     0   8   126 134 0   79   30   246       0.0 260 8 0 178   58 8     0   8   126 134 0   79 30 246     0 260
632274 632274 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972003340 5221 West Valley High School Freshman Campus (Closed after 2018-2019 school year)   Regular School No Other 09 09 2017   grade_7 1 0 1   0 0     0   0   2 0 0   0   0   2       0.0 2 1 0 1   0 0     0   0   2 0 0   0 0 2     0 2
632278 632278 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001653 4040 West Valley Jr High   Regular School No Middle 07 08 2017   grade_7 260 3 116   8 8     0   12   221 186 0   24   4   197       18.0 407 260 3 116   8 8     0   12   221 186 0   24 4 197     18 407
632283 632283 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972002545 4506 West Valley Middle School   Regular School No Middle 05 06 2017   grade_7 3 0 0   0 0     0   0   3 0 0   0   0   1       0.0 3 3 0 0   0 0     0   0   3 0 0   0 0 1     0 3
632552 632552 WA Yakima   school 5310110 39007   Yakima School District 531011001689 2116 Davis High School   Regular School No High 09 12 2017   grade_7 0 0 2   0 0     0   0   1 1 0   1   0   1       0.0 2 0 0 2   0 0     0   0   1 1 0   1 0 1     0 2
632562 632562 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2017   grade_7 11 0 16   0 0     0   0   10 17 0   4   0   14       1.0 27 11 0 16   0 0     0   0   10 17 0   4 0 14     1 27
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
632603 632603 WA Yakima   school 5310110 39007   Yakima School District 531011002932 4092 Juvenile Detention Center   Regular School No Other 05 12 2017   grade_7 0 0 1   0 0     0   0   1 0 0   1   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   1 0 1     0 1
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
632675 632675 WA Yakima   school 5310110 39007   Yakima School District 531011001708 2314 Washington Middle School   Regular School No Middle 06 08 2017   grade_7 7 2 229   4 0     0   1   120 123 0   123   8   219       8.0 243 7 2 229   4 0     0   1   120 123 0   123 8 219     8 243
632687 632687 WA Yakima   school 5310110 39007   Yakima School District 531011001710 3368 Wilson Middle School   Regular School No Middle 06 08 2017   grade_7 70 2 204   6 2     0   13   144 153 0   56   3   213       8.0 297 70 2 204   6 2     0   13   144 153 0   56 3 213     8 297
632693 632693 WA Yakima   school 5310110 39007   Yakima School District 531011003263 5153 Yakima Online   Alternative School No Other 06 12 2017   grade_7 1 0 1   0 0     0   0   1 1 0   0   0   1       0.0 2 1 0 1   0 0     0   0   1 1 0   0 0 1     0 2
632796 632796 WA Yakima   school 5310170 39205   Zillah School District 531017002502 4481 Zillah Middle School   Regular School No Middle 07 08 2017   grade_7 45 0 56   7 0     0   5   69 44 0   14   2   71       2.0 113 45 0 56   7 0     0   5   69 44 0   14 2 71     2 113
2415921 2415921 WA Yakima   school 5305370 39090   East Valley School District (Yakima) 530537000806 4055 East Valley Central Middle School   Regular School No Middle 06 08 2019   grade_7 114 2 140   2 5     0   11   127 147 0   26   6   180       7.0 274 114 2 140   2 5     0   11   127 147 0   26 6 180     7 274
2417679 2417679 WA Yakima   school 5303150 39200   Grandview School District 530315000498 3071 Grandview Middle School   Regular School No Middle 06 08 2019   grade_7 21 0 288   0 0     0   0   159 150 0   84   3   277       2.0 309 21 0 288   0 0     0   0   159 150 0   84 3 277     2 309
2417716 2417716 WA Yakima   school 5303180 39204   Granger School District 530318000504 2531 Granger Middle School   Regular School No Middle 05 08 2019   grade_7 8 0 103   4 0     0   0   66 49 0   36   6   102       2.0 115 8 0 103   4 0     0   0   66 49 0   36 6 102     2 115
2417818 2417818 WA Yakima   school 5303510 39203   Highland School District 530351003148 2718 Highland Junior High School   Regular School No Middle 07 08 2019   grade_7 26 0 71   0 0     0   5   51 51 0   17   6   82       2.0 102 26 0 71   0 0     0   5   51 51 0   17 6 82     2 102
2419870 2419870 WA Yakima   school 5304650 39120   Mabton School District 530465003406 5289 Mabton Jr. Sr. High   Regular School No High 07 12 2019   grade_7 2 0 71   0 0     0   0   34 39 0   29   0   72       3.0 73 2 0 71   0 0     0   0   34 39 0   29 0 72     3 73
2420629 2420629 WA Yakima   school 5305280 39209   Mount Adams School District 530528001851 2389 Mount Adams Middle School   Regular School No Middle 07 08 2019   grade_7 6 0 28   40 0     0   6   42 38 0   27   11   78       8.0 80 6 0 28   40 0     0   6   42 38 0   27 11 78     8 80
2420947 2420947 WA Yakima   school 5305460 39003   Naches Valley School District 530546000824 2898 Naches Valley Middle School   Regular School No Middle 05 08 2019   grade_7 69 0 31   0 0     0   3   59 44 0   12   0   54       7.0 103 69 0 31   0 0     0   3   59 44 0   12 0 54     7 103
2424708 2424708 WA Yakima   school 5307770 39119   Selah School District 530777003348 5231 Selah HomeLink   Regular School No Elementary KG 08 2019   grade_7 1 0 2   0 0     0   0   2 1 0   0   0   0       0.0 3 1 0 2   0 0     0   0   2 1 0   0 0 0     0 3
2424718 2424718 WA Yakima   school 5307770 39119   Selah School District 530777003554 5385 Selah Middle School   Regular School No Middle 06 08 2019   grade_7 173 3 77   0 1     0   6   130 130 0   16   3   139       10.0 260 173 3 77   0 1     0   6   130 130 0   16 3 139     10 260
2426207 2426207 WA Yakima   school 5308670 39201   Sunnyside School District 530867001451 3313 Harrison Middle School   Regular School No Middle 06 08 2019   grade_7 26 1 264   0 0     0   3   155 139 0   81   8   243       5.0 294 26 1 264   0 0     0   3   155 139 0   81 8 243     5 294
2426230 2426230 WA Yakima   school 5308670 39201   Sunnyside School District 530867003037 5049 Sierra Vista Middle School   Regular School No Middle 06 08 2019   grade_7 12 0 219   1 0     0   2   126 108 0   60   11   203       2.0 234 12 0 219   1 0     0   2   126 108 0   60 11 203     2 234
2426865 2426865 WA Yakima   school 5308970 39202   Toppenish School District 530897003385 5262 Northwest Allprep   Regular School No Other KG 12 2019   grade_7 28 1 1   0 2     0   0   23 9 0   4   0   1       0.0 32 28 1 1   0 2     0   0   23 9 0   4 0 1     0 32
2426875 2426875 WA Yakima   school 5308970 39202   Toppenish School District 530897001535 2264 Toppenish Middle School   Regular School No Middle 06 08 2019   grade_7 3 1 253   44 0     0   7   165 143 0   140   5   288       10.0 308 3 1 253   44 0     0   7   165 143 0   140 5 288     10 308
2427062 2427062 WA Yakima   school 5309150 39002   Union Gap School District 530915002382 2714 Union Gap School   Regular School No Elementary PK 08 2019   grade_7 13 0 53   0 0     0   3   29 40 0   15   1   65       1.0 69 13 0 53   0 0     0   3   29 40 0   15 1 65     1 69
2427614 2427614 WA Yakima   school 5309480 39207   Wapato School District 530948001615 2131 Wapato Middle School   Regular School No Middle 06 08 2019   grade_7 7 0 227   73 7     0   10   163 161 0   159   8   303       4.0 324 7 0 227   73 7     0   10   163 161 0   159 8 303     4 324
2427954 2427954 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001653 4040 West Valley Jr High   Regular School No Middle 07 08 2019   grade_7 275 1 138   2 16     3   17   222 230 0   24   1   211       14.0 452 275 1 138   2 16     3   17   222 230 0   24 1 211     14 452
2427959 2427959 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972002545 4506 West Valley Middle School   Regular School No Middle 05 06 2019   grade_7 1 0 0   0 1     0   0   1 1 0   1   0   1       0.0 2 1 0 0   0 1     0   0   1 1 0   1 0 1     0 2
2427963 2427963 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972003619 5505 WEST VALLEY VIRTUAL ACADEMY 7-8   Regular School No Middle 07 08 2019   grade_7 4 0 1   0 0     0   0   3 2 0   0   0   1       0.0 5 4 0 1   0 0     0   0   3 2 0   0 0 1     0 5
2428232 2428232 WA Yakima   school 5310110 39007   Yakima School District 531011001689 2116 Davis High School   Regular School No High 09 12 2019   grade_7 1 0 0   0 0     0   0   0 1 0   1   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   1 0 1     0 1

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