enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 4,466 ✖
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
464221 464221 WA Pierce   school 5302880 27417   Fife School District 530288000467 3798 Surprise Lake Middle School   Regular School No 2.0 06 07 2015   grade_7 150 9 42   4 21     8   38   139 133 0   21   5   121       13.0 272 150 9 42   4 21     8   38   139 133 0   21 5 121     13 272
469121 469121 WA Spokane   school 5306330 32123   Orchard Prairie School District 530633000947 3723 Orchard Prairie Elementary   Regular School No 1.0 KG 07 2015   grade_7 4 0 0   0 0     0   0   3 1 0   0   0   1       0.0 4 4 0 0   0 0     0   0   3 1 0   0 0 1     0 4
469146 469146 WA Douglas   school 5306390 9013   Orondo School District 530639000949 2666 Orondo Elementary and Middle School   Regular School No 1.0 PK 07 2015   grade_7 3 0 28   0 0     0   0   20 11 0   18   11   31       0.0 31 3 0 28   0 0     0   0   20 11 0   18 11 31     0 31
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
471762 471762 WA Mason   school 5307900 23309   Shelton School District 530790002990 4586 Olympic Middle School   Regular School No 2.0 06 07 2015   grade_7 148 1 71   6 2     1   17   125 121 0   23   13   179       10.0 246 148 1 71   6 2     1   17   125 121 0   23 13 179     10 246
472376 472376 WA Mason   school 5308220 23042   Southside School District 530822001360 2744 Southside Elementary   Regular School No 1.0 KG 07 2015   grade_7 21 1 2   0 1     0   5   16 14 0   0   1   14       1.0 30 21 1 2   0 1     0   5   16 14 0   0 1 14     1 30
473666 473666 WA King   school 5308760 17409   Tahoma School District 530876001515 3937 Maple View Middle School   Regular School No 2.0 06 07 2015   grade_7 225 5 30   3 16     0   32   166 145 0   4   1   69       29.0 311 225 5 30   3 16     0   32   166 145 0   4 1 69     29 311
473696 473696 WA King   school 5308760 17409   Tahoma School District 530876002979 3341 Summit Trail Middle School   Regular School No 2.0 06 07 2015   grade_7 241 2 27   0 9     1   23   135 168 0   4   4   45       25.0 303 241 2 27   0 9     1   23   135 168 0   4 4 45     25 303
474063 474063 WA Pierce   school 5309180 27083   University Place School District 530918002383 4325 Drum Intermediate   Regular School No 2.0 05 07 2015   grade_7 107 17 25   0 22     1   34   107 99 0   6   6   87       14.0 206 107 17 25   0 22     1   34   107 99 0   6 6 87     14 206
474075 474075 WA Pierce   school 5309180 27083   University Place School District 530918001550 3296 Narrows View Intermediate   Regular School No 2.0 05 07 2015   grade_7 107 25 21   1 32     1   35   120 102 0   4   4   96       10.0 222 107 25 21   1 32     1   35   120 102 0   4 4 96     10 222
520718 520718 WA Pierce   school 5300480 27403   Bethel School District 530048000123 2877 Elk Plain School of Choice   Regular School No 1 KG 07 2016   grade_7 27 8 6   0 2     0   1   23 21 0   0   0   17       5.0 44 27 8 6   0 2     0   1   23 21 0   0 0 17     5 44
522067 522067 WA Pierce   school 5301410 27400   Clover Park School District 530141001897 3910 Oak Grove   Regular School No 1 KG 07 2016   grade_7 2 0 0   0 0     0   0   2 0 0   0   0   1       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 1     0 2
522642 522642 WA Douglas   school 5302310 9206   Eastmont School District 530231002948 4590 Clovis Point Intermediate School   Regular School No 2 05 07 2016   grade_7 80 1 112   0 1     1   6   103 98 0   26   8   140       8.0 201 80 1 112   0 1     1   6   103 98 0   26 8 140     8 201
523209 523209 WA Grant   school 5302610 13165   Ephrata School District 530261002934 4229 Beezley Springs Elementary   Special Education School No 1 PK 07 2016   grade_7 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
523240 523240 WA Grant   school 5302610 13165   Ephrata School District 530261000388 3092 Grant Elementary   Regular School No 1 PK 07 2016   grade_7 2 0 2   0 0     0   0   3 1 0   0   0   4       0.0 4 2 0 2   0 0     0   0   3 1 0   0 0 4     0 4
523794 523794 WA King   school 5300332 17906   Excel Public Charter School 530033203536 5377 Excel Public Charter School (Closed after 2018-2019 school year)   Regular School Yes 2 06 07 2016   grade_7 29 24 2   0 4     0   3   36 26 0   0   0   37       0.0 62 29 24 2   0 4     0   3   36 26 0   0 0 37     0 62
524163 524163 WA Pierce   school 5302880 27417   Fife School District 530288000466 2809 Endeavour Intermediate   Regular School No 1 02 07 2016   grade_7 0 0 0   0 0     0   1   1 0 0   0   0   1       0.0 1 0 0 0   0 0     0   1   1 0 0   0 0 1     0 1
524173 524173 WA Pierce   school 5302880 27417   Fife School District 530288002875 4557 Hedden Elementary School   Regular School No 1 02 07 2016   grade_7 0 0 1   0 0     0   1   1 1 0   0   0   1       0.0 2 0 0 1   0 0     0   1   1 1 0   0 0 1     0 2
524177 524177 WA Pierce   school 5302880 27417   Fife School District 530288000467 3798 Surprise Lake Middle School   Regular School No 2 06 07 2016   grade_7 158 13 58   3 23     13   23   143 148 0   13   3   141       14.0 291 158 13 58   3 23     13   23   143 148 0   13 3 141     14 291
525922 525922 WA Snohomish   school 5304200 31004   Lake Stevens School District 530420001906 4139 North Lake Middle School   Regular School No 2 06 07 2016   grade_7 269 3 35   3 11     0   26   175 172 0   2   4   100       18.0 347 269 3 35   3 11     0   26   175 172 0   2 4 100     18 347
527461 527461 WA Skamania   school 5305340 30029   Mount Pleasant School District 530534000804 3459 Mount Pleasant School   Regular School No 1 KG 07 2016   grade_7 1 0 0   0 0     0   1   1 1 0   0   0   1       0.0 2 1 0 0   0 0     0   1   1 1 0   0 0 1     0 2
528844 528844 WA Thurston   school 5306180 34111   Olympia School District 530618003377 5248 Olympia Regional Learning Academy B   Regular School No 1 KG 07 2016   grade_7 17 0 1   0 3     0   2   10 13 0   0   0   4       1.0 23 17 0 1   0 3     0   2   10 13 0   0 0 4     1 23
529013 529013 WA Spokane   school 5306330 32123   Orchard Prairie School District 530633000947 3723 Orchard Prairie Elementary   Regular School No 1 KG 07 2016   grade_7 7 0 0   0 0     0   0   3 4 0   0   0   3       0.0 7 7 0 0   0 0     0   0   3 4 0   0 0 3     0 7
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
531758 531758 WA Mason   school 5307900 23309   Shelton School District 530790002990 4586 Olympic Middle School   Regular School No 2 06 07 2016   grade_7 146 1 79   11 3     0   15   133 122 0   21   32   178       8.0 255 146 1 79   11 3     0   15   133 122 0   21 32 178     8 255
532247 532247 WA Kitsap   school 5308160 18402   South Kitsap School District 530816002357 4348 Hidden Creek Elementary School   Regular School No 1 PK 07 2016   grade_7 0 0 0   0 1     0   0   1 0 0   0   0   0       0.0 1 0 0 0   0 1     0   0   1 0 0   0 0 0     0 1
532384 532384 WA Mason   school 5308220 23042   Southside School District 530822001360 2744 Southside Elementary   Regular School No 1 KG 07 2016   grade_7 16 0 3   0 0     0   2   13 8 0   0   2   7       0.0 21 16 0 3   0 0     0   2   13 8 0   0 2 7     0 21
533661 533661 WA King   school 5308760 17409   Tahoma School District 530876001515 3937 Maple View Middle School   Regular School No 2 06 07 2016   grade_7 252 3 44   2 25     3   29   179 179 0   4   1   65       28.0 358 252 3 44   2 25     3   29   179 179 0   4 1 65     28 358
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
534054 534054 WA Pierce   school 5309180 27083   University Place School District 530918001550 3296 Narrows View Intermediate   Regular School No 2 05 07 2016   grade_7 128 13 40   2 19     0   29   123 108 0   4   4   97       10.0 231 128 13 40   2 19     0   29   123 108 0   4 4 97     10 231
620021 620021 WA Douglas   school 5302310 9206   Eastmont School District 530231002948 4590 Clovis Point Intermediate School   Regular School No Middle 05 07 2017   grade_7 71 0 118   0 1     2   8   104 96 0   44   8   143       10.0 200 71 0 118   0 1     2   8   104 96 0   44 8 143     10 200
620068 620068 WA Douglas   school 5302310 9206   Eastmont School District 530231001762 4095 Sterling School   Regular School No Elementary KG 07 2017   grade_7 132 5 92   0 2     0   7   116 122 0   29   2   124       5.0 238 132 5 92   0 2     0   7   116 122 0   29 2 124     5 238
621567 621567 WA Pierce   school 5302880 27417   Fife School District 530288000467 3798 Surprise Lake Middle School   Regular School No Middle 06 07 2017   grade_7 131 11 59   3 23     9   37   126 147 0   32   4   119       8.0 273 131 11 59   3 23     9   37   126 147 0   32 4 119     8 273
623292 623292 WA Snohomish   school 5304200 31004   Lake Stevens School District 530420000652 3408 Lake Stevens Middle School   Regular School No Middle 06 07 2017   grade_7 194 4 61   0 10     2   30   158 143 0   8   2   109       26.0 301 194 4 61   0 10     2   30   158 143 0   8 2 109     26 301
623310 623310 WA Snohomish   school 5304200 31004   Lake Stevens School District 530420001906 4139 North Lake Middle School   Regular School No Middle 06 07 2017   grade_7 269 5 42   2 15     0   37   182 188 0   13   10   107       19.0 370 269 5 42   2 15     0   37   182 188 0   13 10 107     19 370
626437 626437 WA Spokane   school 5306330 32123   Orchard Prairie School District 530633000947 3723 Orchard Prairie Elementary   Regular School No Elementary KG 07 2017   grade_7 8 0 0   0 0     0   0   2 6 0   0   0   0       0.0 8 8 0 0   0 0     0   0   2 6 0   0 0 0     0 8
629105 629105 WA Mason   school 5307900 23309   Shelton School District 530790002990 4586 Olympic Middle School   Regular School No Middle 06 07 2017   grade_7 172 0 96   11 0     0   17   158 138 0   43   27   205       11.0 296 172 0 96   11 0     0   17   158 138 0   43 27 205     11 296
629726 629726 WA Mason   school 5308220 23042   Southside School District 530822001360 2744 Southside Elementary   Regular School No Elementary KG 07 2017   grade_7 12 1 2   0 1     0   1   6 11 0   0   2   4       0.0 17 12 1 2   0 1     0   1   6 11 0   0 2 4     0 17
629732 629732 WA Spokane   school 5300337 32901   Spokane International Academy 530033703539 5381 Spokane International Academy   Regular School Yes Elementary KG 07 2017   grade_7 38 0 7   0 2     0   6   24 29 0   1   0   27       3.0 53 38 0 7   0 2     0   6   24 29 0   1 0 27     3 53
630997 630997 WA King   school 5308760 17409   Tahoma School District 530876001515 3937 Maple View Middle School   Regular School No Middle 06 07 2017   grade_7 249 4 33   0 17     6   27   175 161 0   6   3   55       27.0 336 249 4 33   0 17     6   27   175 161 0   6 3 55     27 336
631019 631019 WA King   school 5308760 17409   Tahoma School District 530876002979 3341 Summit Trail Middle School   Regular School No Middle 06 07 2017   grade_7 229 9 21   0 12     2   19   149 143 0   5   2   44       24.0 292 229 9 21   0 12     2   19   149 143 0   5 2 44     24 292
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
631394 631394 WA Pierce   school 5309180 27083   University Place School District 530918001550 3296 Narrows View Intermediate   Regular School No Middle 05 07 2017   grade_7 123 17 33   0 23     1   40   130 107 0   11   4   101       19.0 237 123 17 33   0 23     1   40   130 107 0   11 4 101     19 237
2415377 2415377 WA Pierce   school 5301410 27400   Clover Park School District 530141001897 3910 Oak Grove   Regular School No Elementary KG 07 2019   grade_7 0 1 0   0 1     0   1   2 1 0   0   0   1       0.0 3 0 1 0   0 1     0   1   2 1 0   0 0 1     0 3
2415964 2415964 WA Douglas   school 5302310 9206   Eastmont School District 530231002948 4590 Clovis Point Intermediate School   Regular School No Middle 05 07 2019   grade_7 101 1 128   1 0     0   6   119 118 0   34   5   152       18.0 237 101 1 128   1 0     0   6   119 118 0   34 5 152     18 237
2416007 2416007 WA Douglas   school 5302310 9206   Eastmont School District 530231001762 4095 Sterling School   Regular School No Elementary KG 07 2019   grade_7 152 0 98   1 3     0   14   139 129 0   21   5   147       19.0 268 152 0 98   1 3     0   14   139 129 0   21 5 147     19 268
2417476 2417476 WA Pierce   school 5302880 27417   Fife School District 530288000467 3798 Surprise Lake Middle School   Regular School No Middle 06 07 2019   grade_7 141 18 69   3 25     15   41   150 162 0   25   4   143       6.0 312 141 18 69   3 25     15   41   150 162 0   25 4 143     6 312
2419167 2419167 WA Snohomish   school 5304200 31004   Lake Stevens School District 530420000652 3408 Lake Stevens Middle School   Regular School No Middle 06 07 2019   grade_7 211 9 55   0 15     0   31   156 165 0   7   3   105       29.0 321 211 9 55   0 15     0   31   156 165 0   7 3 105     29 321
2419181 2419181 WA Snohomish   school 5304200 31004   Lake Stevens School District 530420001906 4139 North Lake Middle School   Regular School No Middle 06 07 2019   grade_7 250 8 45   3 6     1   33   181 165 0   5   6   101       46.0 346 250 8 45   3 6     1   33   181 165 0   5 6 101     46 346
2422175 2422175 WA Spokane   school 5306330 32123   Orchard Prairie School District 530633000947 3723 Orchard Prairie Elementary   Regular School No Elementary KG 07 2019   grade_7 6 0 0   0 0     0   0   5 1 0   0   0   0       0.0 6 6 0 0   0 0     0   0   5 1 0   0 0 0     0 6
2424819 2424819 WA Mason   school 5307900 23309   Shelton School District 530790002990 4586 Olympic Middle School   Regular School No Middle 06 07 2019   grade_7 166 0 118   12 1     1   29   156 171 0   53   24   229       17.0 327 166 0 118   12 1     1   29   156 171 0   53 24 229     17 327
2425404 2425404 WA Mason   school 5308220 23042   Southside School District 530822001360 2744 Southside Elementary   Regular School No Elementary KG 07 2019   grade_7 14 0 5   1 1     0   2   7 16 0   0   2   8       0.0 23 14 0 5   1 1     0   2   7 16 0   0 2 8     0 23
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
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
2460467 2460467 WA Douglas   school 5302310 9206   Eastmont School District 530231002948 4590 Clovis Point Intermediate School   Regular School No Middle 05 07 2018   grade_7 82 0 116   0 0     0   3   112 89 0   43   1   135       5.0 201 82 0 116   0 0     0   3   112 89 0   43 1 135     5 201
2460512 2460512 WA Douglas   school 5302310 9206   Eastmont School District 530231001762 4095 Sterling School   Regular School No Elementary KG 07 2018   grade_7 142 0 118   2 1     1   4   130 138 0   30   1   156       15.0 268 142 0 118   2 1     1   4   130 138 0   30 1 156     15 268
2461975 2461975 WA Pierce   school 5302880 27417   Fife School District 530288000467 3798 Surprise Lake Middle School   Regular School No Middle 06 07 2018   grade_7 131 13 52   2 30     20   36   134 150 0   34   4   124       19.0 284 131 13 52   2 30     20   36   134 150 0   34 4 124     19 284
2463641 2463641 WA Snohomish   school 5304200 31004   Lake Stevens School District 530420000652 3408 Lake Stevens Middle School   Regular School No Middle 06 07 2018   grade_7 228 4 53   0 14     3   27   181 148 0   14   3   103       25.0 329 228 4 53   0 14     3   27   181 148 0   14 3 103     25 329
2463656 2463656 WA Snohomish   school 5304200 31004   Lake Stevens School District 530420001906 4139 North Lake Middle School   Regular School No Middle 06 07 2018   grade_7 292 4 49   2 22     0   32   210 191 0   12   6   115       42.0 401 292 4 49   2 22     0   32   210 191 0   12 6 115     42 401
2466643 2466643 WA Spokane   school 5306330 32123   Orchard Prairie School District 530633000947 3723 Orchard Prairie Elementary   Regular School No Elementary KG 07 2018   grade_7 4 0 0   0 0     0   0   1 3 0   0   0   0       0.0 4 4 0 0   0 0     0   0   1 3 0   0 0 0     0 4
2469334 2469334 WA Mason   school 5307900 23309   Shelton School District 530790002990 4586 Olympic Middle School   Regular School No Middle 06 07 2018   grade_7 156 1 95   5 1     1   18   145 132 0   41   22   193       15.0 277 156 1 95   5 1     1   18   145 132 0   41 22 193     15 277
2469918 2469918 WA Mason   school 5308220 23042   Southside School District 530822001360 2744 Southside Elementary   Regular School No Elementary KG 07 2018   grade_7 18 0 3   1 1     0   2   11 14 0   0   2   9       1.0 25 18 0 3   1 1     0   2   11 14 0   0 2 9     1 25
2471141 2471141 WA Pierce   school 5308700 27010   Tacoma School District 530870001508 3116 Wainwright   Regular School No Middle 04 07 2018   grade_7 42 15 9   2 3     1   10   36 46 0   4   4   40       8.0 82 42 15 9   2 3     1   10   36 46 0   4 4 40     8 82
2471585 2471585 WA Pierce   school 5309180 27083   University Place School District 530918002383 4325 Drum Intermediate   Regular School No Middle 05 07 2018   grade_7 84 30 33   1 21     6   25   98 102 0   11   1   87       10.0 200 84 30 33   1 21     6   25   98 102 0   11 1 87     10 200
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
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
2573341 2573341 WA Douglas   school 5302310 9206   Eastmont School District 530231001762 4095 Sterling School   Regular School No Elementary KG 07 2020   grade_7 119 0 139   1 1     0   4   131 133 0   30   6   170       18.0 264 119 0 139   1 1     0   4   131 133 0   30 6 170     18 264
2574820 2574820 WA Pierce   school 5302880 27417   Fife School District 530288000467 3798 Surprise Lake Middle School   Regular School No Middle 06 07 2020   grade_7 123 18 64   3 28     16   37   154 135 0   24   5   144       18.0 289 123 18 64   3 28     16   37   154 135 0   24 5 144     18 289
2576521 2576521 WA Snohomish   school 5304200 31004   Lake Stevens School District 530420000652 3408 Lake Stevens Middle School   Regular School No Middle 06 07 2020   grade_7 227 6 62   0 15     1   39   170 180 0   17   5   118       32.0 350 227 6 62   0 15     1   39   170 180 0   17 5 118     32 350
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
2579520 2579520 WA Spokane   school 5306330 32123   Orchard Prairie School District 530633000947 3723 Orchard Prairie Elementary   Regular School No Elementary KG 07 2020   grade_7 7 0 0   0 0     0   0   4 3 0   2   0   1       0.0 7 7 0 0   0 0     0   0   4 3 0   2 0 1     0 7
2582810 2582810 WA Mason   school 5308220 23042   Southside School District 530822001360 2744 Southside Elementary   Regular School No Elementary KG 07 2020   grade_7 18 0 3   1 0     0   1   14 9 0   0   1   12       1.0 23 18 0 3   1 0     0   1   14 9 0   0 1 12     1 23
2584512 2584512 WA Pierce   school 5309180 27083   University Place School District 530918002383 4325 Drum Intermediate   Regular School No Middle 05 07 2020   grade_7 100 18 35   1 22     1   38   115 100 0   8   4   76       22.0 215 100 18 35   1 22     1   38   115 100 0   8 4 76     22 215
2584523 2584523 WA Pierce   school 5309180 27083   University Place School District 530918001550 3296 Narrows View Intermediate   Regular School No Middle 05 07 2020   grade_7 104 16 36   2 16     3   44   105 116 0   5   3   97       17.0 221 104 16 36   2 16     3   44   105 116 0   5 3 97     17 221
2933623 2933623 WA Pierce   school 5301410 27400   Clover Park School District 530141001897 3910 Oak Grove   Regular School No Elementary KG 07 2021   grade_7 1 1 0   0 0     0   0   1 1 0   0   0   0       0.0 2 1 1 0   0 0     0   0   1 1 0   0 0 0     0 2
2934181 2934181 WA Douglas   school 5302310 9206   Eastmont School District 530231002948 4590 Clovis Point Intermediate School   Regular School No Middle 05 07 2021   grade_7 81 0 158   0 1     0   1   139 102 0   39   4   174       8.0 241 81 0 158   0 1     0   1   139 102 0   39 4 174     8 241
2934229 2934229 WA Douglas   school 5302310 9206   Eastmont School District 530231001762 4095 Sterling School   Regular School No Elementary KG 07 2021   grade_7 139 1 141   1 2     0   13   144 153 0   21   5   159       11.0 297 139 1 141   1 2     0   13   144 153 0   21 5 159     11 297
2935687 2935687 WA Pierce   school 5302880 27417   Fife School District 530288000467 3798 Surprise Lake Middle School   Regular School No Middle 06 07 2021   grade_7 115 17 70   2 27     17   38   133 153 0   29   5   148       7.0 286 115 17 70   2 27     17   38   133 153 0   29 5 148     7 286
2937405 2937405 WA Snohomish   school 5304200 31004   Lake Stevens School District 530420000652 3408 Lake Stevens Middle School   Regular School No Middle 06 07 2021   grade_7 220 6 60   1 14     3   30   180 154 0   12   6   84       37.0 334 220 6 60   1 14     3   30   180 154 0   12 6 84     37 334
2937419 2937419 WA Snohomish   school 5304200 31004   Lake Stevens School District 530420001906 4139 North Lake Middle School   Regular School No Middle 06 07 2021   grade_7 287 13 66   2 12     0   35   213 202 0   16   2   129       33.0 415 287 13 66   2 12     0   35   213 202 0   16 2 129     33 415
2940464 2940464 WA Spokane   school 5306330 32123   Orchard Prairie School District 530633000947 3723 Orchard Prairie Elementary   Regular School No Elementary KG 07 2021   grade_7 8 0 1   0 0     0   0   5 4 0   0   0   1       0.0 9 8 0 1   0 0     0   0   5 4 0   0 0 1     0 9
2943804 2943804 WA Mason   school 5308220 23042   Southside School District 530822001360 2744 Southside Elementary   Regular School No Elementary KG 07 2021   grade_7 12 0 2   0 0     0   5   10 9 0   0   1   7       0.0 19 12 0 2   0 0     0   5   10 9 0   0 1 7     0 19
2945531 2945531 WA Pierce   school 5309180 27083   University Place School District 530918002383 4325 Drum Intermediate   Regular School No Middle 05 07 2021   grade_7 93 24 34   2 16     3   40   109 103 0   4   3   89       7.0 212 93 24 34   2 16     3   40   109 103 0   4 3 89     7 212
2945542 2945542 WA Pierce   school 5309180 27083   University Place School District 530918001550 3296 Narrows View Intermediate   Regular School No Middle 05 07 2021   grade_7 92 22 37   0 19     4   49   106 117 0   6   4   83       8.0 223 92 22 37   0 19     4   49   106 117 0   6 4 83     8 223
459757 459757 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000009 2305 Miller Junior High   Regular School No 2.0 07 08 2015   grade_7 141 3 46   10 5     2   7   101 113 0   10   15   159       8.0 214 141 3 46   10 5     2   7   101 113 0   10 15 159     8 214
459800 459800 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No 1.0 KG 08 2015   grade_7 16 0 3   0 0     0   0   13 6 0   0   0   7       0.0 19 16 0 3   0 0     0   0   13 6 0   0 0 7     0 19
459811 459811 WA Skagit   school 5300150 29103   Anacortes School District 530015000015 2707 Anacortes Middle School   Regular School No 2.0 07 08 2015   grade_7 181 6 13   3 15     2   2   120 102 0   2   5   72       13.0 222 181 6 13   3 15     2   2   120 102 0   2 5 72     13 222
459866 459866 WA Snohomish   school 5300240 31016   Arlington School District 530024003008 5010 Haller Middle School   Regular School No 2.0 06 08 2015   grade_7 168 5 24   3 6     1   8   100 115 0   4   2   78       6.0 215 168 5 24   3 6     1   8   100 115 0   4 2 78     6 215
459888 459888 WA Snohomish   school 5300240 31016   Arlington School District 530024000024 3124 Post Middle School   Regular School No 2.0 06 08 2015   grade_7 174 1 18   2 4     1   8   99 109 0   5   1   81       6.0 208 174 1 18   2 4     1   8   99 109 0   5 1 81     6 208
459965 459965 WA King   school 5300300 17408   Auburn School District 530030000033 2394 Cascade Middle School   Regular School No 2.0 06 08 2015   grade_7 116 21 55   1 13     19   12   130 107 0   24   5   167       7.0 237 116 21 55   1 13     19   12   130 107 0   24 5 167     7 237
460042 460042 WA King   school 5300300 17408   Auburn School District 530030001443 4462 Mt Baker Middle School   Regular School No 2.0 06 08 2015   grade_7 140 19 90   1 26     10   32   154 164 0   18   3   173       10.0 318 140 19 90   1 26     10   32   154 164 0   18 3 173     10 318
460046 460046 WA King   school 5300300 17408   Auburn School District 530030000038 3169 Olympic Middle School   Regular School No 2.0 06 08 2015   grade_7 83 13 91   12 15     16   18   126 122 0   46   2   194       4.0 248 83 13 91   12 15     16   18   126 122 0   46 2 194     4 248
460059 460059 WA King   school 5300300 17408   Auburn School District 530030002434 4385 Rainier Middle School   Regular School No 2.0 06 08 2015   grade_7 145 32 56   1 28     7   18   148 139 0   13   2   155       18.0 287 145 32 56   1 28     7   18   148 139 0   13 2 155     18 287
460131 460131 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002802 1841 Mosaic Home Education Partnership   Alternative Education School No 1.0 KG 08 2015   grade_7 4 0 0   0 0     0   0   4 0 0   0   0   1       0.0 4 4 0 0   0 0     0   0   4 0 0   0 0 1     0 4
460141 460141 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002523 1699 Odyssey Multiage Program   Regular School No 1.0 01 08 2015   grade_7 20 0 1   0 2     0   1   13 11 0   0   0   2       1.0 24 20 0 1   0 2     0   1   13 11 0   0 0 2     1 24
460156 460156 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002452 4505 Woodward Middle School   Regular School No 2.0 07 08 2015   grade_7 216 4 22   1 10     0   32   152 133 0   1   0   22       18.0 285 216 4 22   1 10     0   32   152 133 0   1 0 22     18 285
460165 460165 WA Clark   school 5300380 6119   Battle Ground School District 530038000048 2671 Amboy Middle School   Regular School No 2.0 05 08 2015   grade_7 134 0 7   1 0     0   5   73 74 0   0   2   72       2.0 147 134 0 7   1 0     0   5   73 74 0   0 2 72     2 147
460194 460194 WA Clark   school 5300380 6119   Battle Ground School District 530038003262 5133 Chief Umtuch Middle   Regular School No 2.0 05 08 2015   grade_7 121 2 16   0 3     0   10   91 61 0   3   5   71       2.0 152 121 2 16   0 3     0   10   91 61 0   3 5 71     2 152
460199 460199 WA Clark   school 5300380 6119   Battle Ground School District 530038003176 5089 Daybreak Middle   Regular School No 2.0 05 08 2015   grade_7 104 0 13   0 3     1   7   55 73 0   7   3   66       4.0 128 104 0 13   0 3     1   7   55 73 0   7 3 66     4 128
460234 460234 WA Clark   school 5300380 6119   Battle Ground School District 530038000052 3545 Laurin Middle School   Regular School No 2.0 05 08 2015   grade_7 120 2 18   0 6     0   8   75 79 0   6   1   54       5.0 154 120 2 18   0 6     0   8   75 79 0   6 1 54     5 154

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