Data source: Big Local News · About: Big Local

681 rows where grade = "grade_8", state = "WA" and year = 2020 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2020 · 681

grade

  • grade_8 · 681
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
2572471 WA Pierce   school   27901   Chief Leschi Schools   5549 Chief Leschi Schools             2020   grade_8 0 0 5   37 0     0   3   25 20 0   0   0   30       0.0 45 0 0 5   37 0     0   3   25 20 0   0 0 30     0 45
2577135 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2020   grade_8 0 0 0   30 0     0   0   16 14 0   0   0   24       0.0 30 0 0 0   30 0     0   0   16 14 0   0 0 24     0 30
2578132 WA King   school   17903   Muckleshoot Indian Tribe   1986 Muckleshoot Tribal School             2020   grade_8 0 0 1   32 0     0   2   22 13 0   0   0   26       0.0 35 0 0 1   32 0     0   2   22 13 0   0 0 26     0 35
2579426 WA Okanogan   school   24019   Omak School District   4278 Paschal Sherman             2020   grade_8 0 0 1   8 0     0   0   6 3 0   0   0   9       0.0 9 0 0 1   8 0     0   0   6 3 0   0 0 9     0 9
2580499 WA Clallam   school   5903   Quileute Tribal School District   5430 Quileute Tribal School             2020   grade_8 0 0 2   6 0     0   0   3 5 0   0   0   7       0.0 8 0 0 2   6 0     0   0   3 5 0   0 0 7     0 8
2584869 WA Thurston   school   34901   WA HE LUT Indian School Agency   5496 Wa He Lut Indian School             2020   grade_8 0 2 1   15 0     0   0   8 10 0   0   4   14       1.0 18 0 2 1   15 0     0   0   8 10 0   0 4 14     1 18
2571727 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000157 3251 Lucille Umbarger Elementary   Regular School No Elementary 01 08 2020   grade_8 34 0 65   0 1     0   5   59 46 0   31   5   74       5.0 105 34 0 65   0 1     0   5   59 46 0   31 5 74     5 105
2582166 WA Clallam   school 5307830 5323   Sequim School District 530783002552 1708 Olympic Peninsula Academy   Alternative School No Other 01 12 2020   grade_8 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
2585680 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2020   grade_8 8 0 15   0 0     0   3   16 10 0   3   1   16       3.0 26 8 0 15   0 0     0   3   16 10 0   3 1 16     3 26
2570325 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003003633 5514 Grays Harbor Academy   Alternative School No Other 03 12 2020   grade_8 4 0 3   0 0     0   0   3 4 0   0   0   4       0.0 7 4 0 3   0 0     0   0   3 4 0   0 0 4     0 7
2570782 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2020   grade_8 51 0 3   0 2     0   4   27 33 0   1   0   11       2.0 60 51 0 3   0 2     0   4   27 33 0   1 0 11     2 60
2573916 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000503407 5290 Clark County Juvenile Detention School   Regular School No Other 03 12 2020   grade_8 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
2579146 WA Grays Harbor   school 5306000 14400   Oakville School District 530600003712 5584 Oakville Homelink Alternative School   Alternative School No Other 03 12 2020   grade_8 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
2572654 WA Pierce   school 5301410 27400   Clover Park School District 530141000271 2041 Firwood   Regular School No Other 04 12 2020   grade_8 4 1 0   0 1     0   0   2 4 0   0   0   1       0.0 6 4 1 0   0 1     0   0   2 4 0   0 0 1     0 6
2572780 WA Pierce   school 5301410 27400   Clover Park School District 530141003396 5297 Transition Day Students   Regular School No Other 04 12 2020   grade_8 2 1 0   0 0     0   0   3 0 0   0   1   2       0.0 3 2 1 0   0 0     0   0   3 0 0   0 1 2     0 3
2584039 WA Pierce   school 5308700 27010   Tacoma School District 530870001508 3116 Wainwright   Regular School No Middle 04 08 2020   grade_8 43 12 14   2 3     1   9   42 42 0   1   1   36       7.0 84 43 12 14   2 3     1   9   42 42 0   1 1 36     7 84
2570767 WA Clark   school 5300380 6119   Battle Ground School District 530038000048 2671 Amboy Middle School   Regular School No Middle 05 08 2020   grade_8 119 0 2   0 0     0   3   62 62 0   2   1   32       8.0 124 119 0 2   0 0     0   3   62 62 0   2 1 32     8 124
2570795 WA Clark   school 5300380 6119   Battle Ground School District 530038003262 5133 Chief Umtuch Middle   Regular School No Middle 05 08 2020   grade_8 127 2 17   1 1     0   11   92 67 0   6   4   60       8.0 159 127 2 17   1 1     0   11   92 67 0   6 4 60     8 159
2570801 WA Clark   school 5300380 6119   Battle Ground School District 530038003176 5089 Daybreak Middle   Regular School No Middle 05 08 2020   grade_8 113 2 23   0 4     0   6   76 72 0   9   3   58       8.0 148 113 2 23   0 4     0   6   76 72 0   9 3 58     8 148
2570839 WA Clark   school 5300380 6119   Battle Ground School District 530038000052 3545 Laurin Middle School   Regular School No Middle 05 08 2020   grade_8 149 2 24   0 4     1   8   105 83 0   13   1   64       8.0 188 149 2 24   0 4     1   8   105 83 0   13 1 64     8 188
2570857 WA Clark   school 5300380 6119   Battle Ground School District 530038000054 3997 Pleasant Valley Middle   Regular School No Middle 05 08 2020   grade_8 72 3 28   2 7     4   12   59 69 0   8   1   54       9.0 128 72 3 28   2 7     4   12   59 69 0   8 1 54     9 128
2570881 WA Clark   school 5300380 6119   Battle Ground School District 530038003214 5131 Tukes Valley Middle School   Regular School No Middle 05 08 2020   grade_8 99 0 20   1 1     0   8   71 58 0   4   1   39       5.0 129 99 0 20   1 1     0   8   71 58 0   4 1 39     5 129
2571902 WA Chelan   school 5300960 4222   CASHMERE SCHOOL DISTRICT 530096000169 2315 CASHMERE MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_8 67 0 53   0 0     1   3   61 62 1   4   1   55       0.0 124 67 0 53   0 0     1   3   61 62 1   4 1 55     0 124
2572341 WA Lewis   school 5301170 21302   Chehalis School District 530117002883 1559 Lewis County Juvenile Detention   Regular School No High 05 12 2020   grade_8 2 0 0   0 0     0   0   1 1 0   0   0   1       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 1     0 2
2574511 WA King   school 5302820 17210   Federal Way School District 530282000437 3898 Illahee Middle School   Regular School No Middle 05 08 2020   grade_8 52 53 67   2 42     21   33   135 135 0   34   8   181       13.0 270 52 53 67   2 42     21   33   135 135 0   34 8 181     13 270
2574976 WA Klickitat   school 5303090 20404   Goldendale School District 530309000491 3393 Goldendale Middle School   Regular School No Middle 05 08 2020   grade_8 64 0 12   1 0     0   5   44 38 0   1   0   66       0.0 82 64 0 12   1 0     0   5   44 38 0   1 0 66     0 82
2575057 WA Yakima   school 5303180 39204   Granger School District 530318000504 2531 Granger Middle School   Regular School No Middle 05 08 2020   grade_8 6 0 103   4 0     0   0   67 46 0   37   4   102       2.0 113 6 0 103   4 0     0   0   67 46 0   37 4 102     2 113
2575554 WA King   school 5303750 17411   Issaquah School District 530375001773 3569 Echo Glen School   Regular School No High 05 12 2020   grade_8 3 0 3   0 0     0   1   7 0 0   1   0   6       4.0 7 3 0 3   0 0     0   1   7 0 0   1 0 6     4 7
2576314 WA Stevens   school 5303990 33212   Kettle Falls School District 530399001904 3198 Kettle Falls Middle School   Regular School No Middle 05 08 2020   grade_8 50 0 3   4 1     0   10   33 35 0   0   5   40       9.0 68 50 0 3   4 1     0   10   33 35 0   0 5 40     9 68
2576956 WA Whitman   school 5304290 38264   Lamont School District 530429000687 3137 Lamont Middle School   Regular School No Middle 05 08 2020   grade_8 10 0 0   0 0     0   0   4 6 0   0   1   8       0.0 10 10 0 0   0 0     0   0   4 6 0   0 1 8     0 10
2578290 WA Yakima   school 5305460 39003   Naches Valley School District 530546000824 2898 Naches Valley Middle School   Regular School No Middle 05 08 2020   grade_8 65 1 33   2 0     0   3   58 46 0   10   0   54       7.0 104 65 1 33   2 0     0   3   58 46 0   10 0 54     7 104
2578352 WA Pend Oreille   school 5305610 26056   Newport School District 530561001911 3968 Sadie Halstead Middle School   Regular School No Middle 05 08 2020   grade_8 82 0 4   1 1     0   4   43 49 0   0   9   54       1.0 92 82 0 4   1 1     0   4   43 49 0   0 9 54     1 92
2579284 WA Thurston   school 5306180 34111   Olympia School District 530618000925 3133 Jefferson Middle School   Regular School No Middle 05 08 2020   grade_8 88 3 28   3 19     0   26   84 82 1   3   3   69       5.0 167 88 3 28   3 19     0   26   84 82 1   3 3 69     5 167
2580599 WA King   school 5300335 17908   Rainier Prep Charter School District 530033503533 5380 Rainier Prep   Regular School Yes Middle 05 08 2020   grade_8 2 27 45   0 3     0   7   44 40 0   18   1   71       3.0 84 2 27 45   0 3     0   7   44 40 0   18 1 71     3 84
2582927 WA Spokane   school 5308250 32081   Spokane School District 530825001397 3819 Excelsior Youth Center School (Closed after 2019-2020 school year)   Regular School No High 05 12 2020   grade_8 1 1 0   0 0     0   0   2 0 0   0   0   2       0.0 2 1 1 0   0 0     0   0   2 0 0   0 0 2     0 2
2583950 WA Pierce   school 5308700 27010   Tacoma School District 530870002171 2039 Remann Hall Juvenile Detention Center   Regular School No High 05 12 2020   grade_8 0 1 0   0 0     0   0   1 0 0   0   0   0       0.0 1 0 1 0   0 0     0   0   1 0 0   0 0 0     0 1
2584357 WA Klickitat   school 5309060 20400   Trout Lake School District 530906001539 2676 Trout Lake School   Regular School No High 05 12 2020   grade_8 15 0 3   0 0     0   1   10 9 0   1   0   0       3.0 19 15 0 3   0 0     0   1   10 9 0   1 0 0     3 19
2585337 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969002685 1755 West Valley City School   Alternative School No Middle 05 08 2020   grade_8 36 0 7   0 0     0   8   18 33 0   0   0   20       2.0 51 36 0 7   0 0     0   8   18 33 0   0 0 20     2 51
2585642 WA Cowlitz   school 5310050 8404   Woodland School District 531005003509 5409 Woodland Middle School   Regular School No Middle 05 08 2020   grade_8 110 3 38   0 2     0   11   79 85 0   6   9   83       7.0 164 110 3 38   0 2     0   11   79 85 0   6 9 83     7 164
2585719 WA Yakima   school 5310110 39007   Yakima School District 531011002932 4092 Juvenile Detention Center   Regular School No High 05 12 2020   grade_8 0 0 1   0 0     0   0   1 0 0   0   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 1     0 1
2570331 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003002055 4267 Grays Harbor Juvenile Detention   Regular School No High 06 12 2020   grade_8 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
2570358 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000009 2305 Miller Junior High   Regular School No Middle 06 08 2020   grade_8 128 5 75   10 5     0   25   119 129 0   22   13   181       13.0 248 128 5 75   10 5     0   25   119 129 0   22 13 181     13 248
2570391 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No High 06 12 2020   grade_8 51 1 5   0 1     0   1   30 29 0   1   1   18       3.0 59 51 1 5   0 1     0   1   30 29 0   1 1 18     3 59
2570412 WA Skagit   school 5300150 29103   Anacortes School District 530015000015 2707 Anacortes Middle School   Regular School No Middle 06 08 2020   grade_8 158 2 21   2 10     0   11   112 92 0   1   8   54       18.0 204 158 2 21   2 10     0   11   112 92 0   1 8 54     18 204
2570470 WA Snohomish   school 5300240 31016   Arlington School District 530024003008 5010 Haller Middle School   Regular School No Middle 06 08 2020   grade_8 145 4 38   4 1     0   16   104 104 0   9   2   71       10.0 208 145 4 38   4 1     0   16   104 104 0   9 2 71     10 208
2570490 WA Snohomish   school 5300240 31016   Arlington School District 530024000024 3124 Post Middle School   Regular School No Middle 06 08 2020   grade_8 141 1 32   1 1     2   17   114 81 0   13   5   71       12.0 195 141 1 32   1 1     2   17   114 81 0   13 5 71     12 195
2570533 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No High 06 12 2020   grade_8 40 1 3   0 0     0   3   23 24 0   0   0   17       2.0 47 40 1 3   0 0     0   3   23 24 0   0 0 17     2 47
2570573 WA King   school 5300300 17408   Auburn School District 530030000033 2394 Cascade Middle School   Regular School No Middle 06 08 2020   grade_8 112 35 84   1 21     13   27   147 146 0   49   8   197       7.0 293 112 35 84   1 21     13   27   147 146 0   49 8 197     7 293
2570646 WA King   school 5300300 17408   Auburn School District 530030001443 4462 Mt Baker Middle School   Regular School No Middle 06 08 2020   grade_8 95 15 104   0 31     23   37   155 150 0   54   3   145       10.0 305 95 15 104   0 31     23   37   155 150 0   54 3 145     10 305
2570650 WA King   school 5300300 17408   Auburn School District 530030000038 3169 Olympic Middle School   Regular School No Middle 06 08 2020   grade_8 75 19 121   5 25     27   27   169 130 0   71   5   222       4.0 299 75 19 121   5 25     27   27   169 130 0   71 5 222     4 299
2570662 WA King   school 5300300 17408   Auburn School District 530030002434 4385 Rainier Middle School   Regular School No Middle 06 08 2020   grade_8 132 44 96   1 37     8   23   168 173 0   59   4   190       9.0 341 132 44 96   1 37     8   23   168 173 0   59 4 190     9 341
2570813 WA Clark   school 5300380 6119   Battle Ground School District 530038003601 5502 Daybreak Youth Services   Regular School No High 06 12 2020   grade_8 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
2570910 WA King   school 5300390 17405   Bellevue School District 530039003354 5240 Bellevue Big Picture School   Alternative School No High 06 12 2020   grade_8 32 4 7   1 24     0   13   45 36 0   4   0   16       17.0 81 32 4 7   1 24     0   13   45 36 0   4 0 16     17 81
2570954 WA King   school 5300390 17405   Bellevue School District 530039000064 3338 Chinook Middle School   Regular School No Middle 06 08 2020   grade_8 144 11 26   0 99     0   36   145 171 0   25   3   38       34.0 316 144 11 26   0 99     0   36   145 171 0   25 3 38     34 316
2570982 WA King   school 5300390 17405   Bellevue School District 530039000068 3166 Highland Middle School   Regular School No Middle 06 08 2020   grade_8 39 15 44   0 29     1   12   75 65 0   32   4   66       12.0 140 39 15 44   0 29     1   12   75 65 0   32 4 66     12 140
2570994 WA King   school 5300390 17405   Bellevue School District 530039003149 3522 International School   Alternative School No High 06 12 2020   grade_8 32 1 4   0 44     0   9   45 45 0   1   0   7       7.0 90 32 1 4   0 44     0   9   45 45 0   1 0 7     7 90
2571036 WA King   school 5300390 17405   Bellevue School District 530039000079 3631 Odle Middle School   Regular School No Middle 06 08 2020   grade_8 80 8 48   0 202     1   34   196 177 0   28   3   74       21.0 373 80 8 48   0 202     1   34   196 177 0   28 3 74     21 373
2571092 WA King   school 5300390 17405   Bellevue School District 530039000093 3435 Tillicum Middle School   Regular School No Middle 06 08 2020   grade_8 121 4 44   1 55     2   28   131 124 0   13   2   31       31.0 255 121 4 44   1 55     2   28   131 124 0   13 2 31     31 255
2571096 WA King   school 5300390 17405   Bellevue School District 530039000094 3283 Tyee Middle School   Regular School No Middle 06 08 2020   grade_8 94 3 19   0 195     1   32   186 158 0   21   1   27       26.0 344 94 3 19   0 195     1   32   186 158 0   21 1 27     26 344
2571177 WA Whatcom   school 5300420 37501   Bellingham School District 530042000104 2066 Fairhaven Middle School   Regular School No Middle 06 08 2020   grade_8 159 4 20   2 13     0   14   120 92 0   3   1   43       12.0 212 159 4 20   2 13     0   14   120 92 0   3 1 43     12 212
2571197 WA Whatcom   school 5300420 37501   Bellingham School District 530042001739 4442 Kulshan Middle School   Regular School No Middle 06 08 2020   grade_8 142 2 41   2 6     2   18   108 103 2   11   6   90       25.0 213 142 2 41   2 6     2   18   108 103 2   11 6 90     25 213
2571244 WA Whatcom   school 5300420 37501   Bellingham School District 530042000114 3201 Shuksan Middle School   Regular School No Middle 06 08 2020   grade_8 96 3 72   3 26     1   19   105 115 0   38   7   127       21.0 220 96 3 72   3 26     1   19   105 115 0   38 7 127     21 220
2571270 WA Whatcom   school 5300420 37501   Bellingham School District 530042002774 1799 Visions (Seamar Youth Center)   Alternative School No High 06 12 2020   grade_8 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
2571283 WA Whatcom   school 5300420 37501   Bellingham School District 530042000117 2075 Whatcom Middle School   Regular School No Middle 06 08 2020   grade_8 188 4 25   1 6     0   29   140 112 1   1   2   55       26.0 253 188 4 25   1 6     0   29   140 112 1   1 2 55     26 253
2571308 WA Pierce   school 5300480 27403   Bethel School District 530048000120 3250 Bethel Middle School   Regular School No Middle 06 08 2020   grade_8 117 13 59   1 14     17   46   139 128 0   18   6   156       9.0 267 117 13 59   1 14     17   46   139 128 0   18 6 156     9 267
2571319 WA Pierce   school 5300480 27403   Bethel School District 530048001819 4186 Cedarcrest Middle School   Regular School No Middle 06 08 2020   grade_8 75 37 38   3 18     6   45   125 97 0   9   7   132       7.0 222 75 37 38   3 18     6   45   125 97 0   9 7 132     7 222
2571350 WA Pierce   school 5300480 27403   Bethel School District 530048003158 4578 Cougar Mountain Middle School   Regular School No Middle 06 08 2020   grade_8 129 2 41   2 3     3   19   101 98 0   2   8   94       7.0 199 129 2 41   2 3     3   19   101 98 0   2 8 94     7 199
2571378 WA Pierce   school 5300480 27403   Bethel School District 530048000595 4407 Frontier Middle School   Regular School No Middle 06 08 2020   grade_8 180 7 40   1 6     6   34   163 111 0   4   4   126       9.0 274 180 7 40   1 6     6   34   163 111 0   4 4 126     9 274
2571402 WA Pierce   school 5300480 27403   Bethel School District 530048003343 5206 Liberty Middle School   Regular School No Middle 06 08 2020   grade_8 105 16 68   2 8     16   43   125 133 0   9   6   130       12.0 258 105 16 68   2 8     16   43   125 133 0   9 6 130     12 258
2571472 WA Pierce   school 5300480 27403   Bethel School District 530048000128 3751 Spanaway Middle School   Regular School No Middle 06 08 2020   grade_8 102 26 63   0 10     15   39   136 119 0   26   9   167       7.0 255 102 26 63   0 10     15   39   136 119 0   26 9 167     7 255
2571513 WA Whatcom   school 5300570 37503   Blaine School District 530057000131 3796 Blaine Middle School   Regular School No Middle 06 08 2020   grade_8 120 5 25   1 7     0   14   93 79 0   4   5   88       21.0 172 120 5 25   1 7     0   14   93 79 0   4 5 88     21 172
2571585 WA Kitsap   school 5300660 18100   Bremerton School District 530066001144 4441 Mountain View Middle School   Regular School No Middle 06 08 2020   grade_8 142 15 65   4 14     4   50   148 146 0   17   5   191       23.0 294 142 15 65   4 14     4   50   148 146 0   17 5 191     23 294
2571642 WA Okanogan   school 5300690 24111   Brewster School District 530069002284 4223 Brewster Middle School   Regular School No Middle 06 08 2020   grade_8 0 0 2   0 0     0   0   1 1 0   2   0   2       0.0 2 0 0 2   0 0     0   0   1 1 0   2 0 2     0 2
2571666 WA Douglas   school 5300720 9075   Bridgeport School District 530072001271 4213 Bridgeport Middle School   Regular School No Middle 06 08 2020   grade_8 1 0 54   0 0     0   0   27 28 0   28   2   54       0.0 55 1 0 54   0 0     0   0   27 28 0   28 2 54     0 55
2571787 WA Clark   school 5300810 6117   Camas School District 530081003066 5054 Liberty Middle School   Regular School No Middle 06 08 2020   grade_8 229 2 36   1 6     0   22   163 133 0   2   8   66       24.0 296 229 2 36   1 6     0   22   163 133 0   2 8 66     24 296
2571791 WA Clark   school 5300810 6117   Camas School District 530081003652 5534 Odyssey Middle School   Regular School No Middle 06 08 2020   grade_8 53 0 7   1 3     0   2   40 26 0   0   0   8       8.0 66 53 0 7   1 3     0   2   40 26 0   0 0 8     8 66
2571804 WA Clark   school 5300810 6117   Camas School District 530081002512 4508 Skyridge Middle School   Regular School No Middle 06 08 2020   grade_8 189 4 36   1 38     0   28   146 150 0   7   0   46       17.0 296 189 4 36   1 38     0   28   146 150 0   7 0 46     17 296
2571844 WA Clallam   school 5300840 5401   Cape Flattery School District 530084000165 3145 Neah Bay Junior/ Senior High School   Regular School No High 06 12 2020   grade_8 0 0 4   8 0     0   5   5 12 0   0   1   14       1.0 17 0 0 4   8 0     0   5   5 12 0   0 1 14     1 17
2571887 WA Chelan   school 5300950 4228   Cascade School District 530095000553 4403 Icicle River Middle School   Regular School No Middle 06 08 2020   grade_8 56 0 40   1 0     0   5   55 47 0   11   5   59       6.0 102 56 0 40   1 0     0   5   55 47 0   11 5 59     6 102
2571926 WA Cowlitz   school 5300990 8401   Castle Rock School District 530099000173 3969 Castle Rock Middle School   Regular School No Middle 06 08 2020   grade_8 108 0 12   1 1     1   2   58 67 0   5   0   73       7.0 125 108 0 12   1 1     1   2   58 67 0   5 0 73     7 125
2571968 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108000178 3237 Central Kitsap Middle School   Regular School No Middle 06 08 2020   grade_8 156 11 37   3 14     0   39   122 138 0   3   1   12       0.0 260 156 11 37   3 14     0   39   122 138 0   3 1 12     0 260
2572012 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108000183 3791 Fairview Middle School   Regular School No Middle 06 08 2020   grade_8 117 14 40   0 13     2   40   122 104 0   0   1   11       0.0 226 117 14 40   0 13     2   40   122 104 0   0 1 11     0 226
2572035 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108002524 4509 Klahowya Secondary   Regular School No High 06 12 2020   grade_8 104 0 15   0 0     0   23   63 79 0   4   2   26       13.0 142 104 0 15   0 0     0   23   63 79 0   4 2 26     13 142
2572053 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108002056 4249 Ridgetop Middle School   Regular School No Middle 06 08 2020   grade_8 118 6 35   0 11     4   45   117 102 0   0   0   4       1.0 219 118 6 35   0 11     4   45   117 102 0   0 0 4     1 219
2572089 WA Spokane   school 5301110 32356   Central Valley School District 530111000189 3260 Bowdish Middle School   Regular School No Middle 06 08 2020   grade_8 140 2 4   1 1     1   10   80 79 0   3   4   80       4.0 159 140 2 4   1 1     1   10   80 79 0   3 4 80     4 159
2572120 WA Spokane   school 5301110 32356   Central Valley School District 530111000193 3890 Evergreen Middle School   Regular School No Middle 06 08 2020   grade_8 196 6 1   5 9     6   8   127 104 0   6   8   82       9.0 231 196 6 1   5 9     6   8   127 104 0   6 8 82     9 231
2572133 WA Spokane   school 5301110 32356   Central Valley School District 530111000195 3573 Greenacres Middle School   Regular School No Middle 06 08 2020   grade_8 159 1 1   1 3     0   6   95 76 0   1   1   46       10.0 171 159 1 1   1 3     0   6   95 76 0   1 1 46     10 171
2572137 WA Spokane   school 5301110 32356   Central Valley School District 530111001826 4185 Horizon Middle School   Regular School No Middle 06 08 2020   grade_8 141 2 1   1 1     3   5   82 72 0   0   2   46       3.0 154 141 2 1   1 1     3   5   82 72 0   0 2 46     3 154
2572163 WA Spokane   school 5301110 32356   Central Valley School District 530111000198 2776 North Pines Middle School   Regular School No Middle 06 08 2020   grade_8 121 10 4   3 2     6   11   88 69 0   9   0   118       6.0 157 121 10 4   3 2     6   11   88 69 0   9 0 118     6 157
2572202 WA Spokane   school 5301110 32356   Central Valley School District 530111003706 5552 Selkirk Middle School   Regular School No Middle 06 08 2020   grade_8 148 5 3   0 3     0   3   88 74 0   2   1   39       6.0 162 148 5 3   0 3     0   3   88 74 0   2 1 39     6 162
2572320 WA Lewis   school 5301170 21302   Chehalis School District 530117002252 4311 Chehalis Middle School   Regular School No Middle 06 08 2020   grade_8 153 2 41   0 1     0   13   107 103 0   9   6   103       12.0 210 153 2 41   0 1     0   13   107 103 0   9 6 103     12 210
2572371 WA Spokane   school 5301230 32360   Cheney School District 530123000224 2447 Cheney Middle School   Regular School No Middle 06 08 2020   grade_8 124 4 23   0 0     1   17   76 93 0   2   3   69       0.0 169 124 4 23   0 0     1   17   76 93 0   2 3 69     0 169
2572418 WA Spokane   school 5301230 32360   Cheney School District 530123003428 5269 Westwood Middle School   Regular School No Middle 06 08 2020   grade_8 148 6 17   8 7     5   17   106 102 0   10   6   114       1.0 208 148 6 17   8 7     5   17   106 102 0   10 6 114     1 208
2572586 WA Kittitas   school 5301350 19404   Cle Elum-Roslyn School District 530135000242 2570 Walter Strom Middle School   Regular School No Middle 06 08 2020   grade_8 53 0 8   0 1     0   2   36 28 0   2   1   32       1.0 64 53 0 8   0 1     0   2   36 28 0   2 1 32     1 64
2572593 WA Pierce   school 5301410 27400   Clover Park School District 530141003000 5027 General William H. Harrison Preparatory School   Regular School No High 06 12 2020   grade_8 46 8 62   1 5     1   13   60 76 0   5   2   84       7.0 136 46 8 62   1 5     1   13   60 76 0   5 2 84     7 136
2572676 WA Pierce   school 5301410 27400   Clover Park School District 530141000257 3248 Hudtloff Middle School   Regular School No Middle 06 08 2020   grade_8 50 36 90   3 17     9   40   144 101 0   37   8   171       7.0 245 50 36 90   3 17     9   40   144 101 0   37 8 171     7 245
2572709 WA Pierce   school 5301410 27400   Clover Park School District 530141000263 3602 Lochburn Middle School   Regular School No Middle 06 08 2020   grade_8 40 37 83   0 7     21   31   120 99 0   40   15   193       4.0 219 40 37 83   0 7     21   31   120 99 0   40 15 193     4 219
2572713 WA Pierce   school 5301410 27400   Clover Park School District 530141000264 3297 Mann Middle School (Closed after 2019-2020 school year)   Regular School No Middle 06 08 2020   grade_8 46 15 49   1 0     8   20   69 69 1   2   2   77       13.0 139 46 15 49   1 0     8   20   69 69 1   2 2 77     13 139
2572765 WA Pierce   school 5301410 27400   Clover Park School District 530141000272 3500 Thomas Middle School   Regular School No Middle 06 08 2020   grade_8 37 22 53   1 6     14   16   86 63 0   17   7   121       7.0 149 37 22 53   1 6     14   16   86 63 0   17 7 121     7 149
2572825 WA Walla Walla   school 5301470 36250   College Place School District 530147000276 3541 John Sager Middle School   Regular School No Middle 06 08 2020   grade_8 58 0 63   0 0     0   7   59 68 1   18   5   79       9.0 128 58 0 63   0 0     0   7   59 68 1   18 5 79     9 128

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