Data source: Big Local News · About: Big Local

644 rows where grade = "grade_7", state = "WA" and year = 2016 sorted by native_american_alaskan_native_int

View and edit SQL

year

  • 2016 · 644

grade

  • grade_7 · 644
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
519700 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003002055 4267 Grays Harbor Juvenile Detention   Regular School No 4 06 12 2016   grade_7 0 1 0   0 0     0   0   0 1 0   0   0   1       0.0 1 0 1 0   0 0     0   0   0 1 0   0 0 1     0 1
519723 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No 1 KG 08 2016   grade_7 0 0 1   0 0     0   0   1 0 0   0   0   0       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 0     0 1
519762 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No 4 06 12 2016   grade_7 45 0 3   0 0     0   1   24 25 0   0   3   17       2.0 49 45 0 3   0 0     0   1   24 25 0   0 3 17     2 49
519772 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No 1 PK 08 2016   grade_7 26 0 0   0 0     0   0   10 16 0   0   0   7       0.0 26 26 0 0   0 0     0   0   10 16 0   0 0 7     0 26
519880 WA Snohomish   school 5300240 31016   Arlington School District 530024002589 1714 Stillaguamish Valley Learning Center   Alternative Education School No 4 KG 12 2016   grade_7 11 0 0   0 0     0   1   7 5 0   0   0   0       0.0 12 11 0 0   0 0     0   1   7 5 0   0 0 0     0 12
520018 WA King   school 5300300 17408   Auburn School District 530030001443 4462 Mt Baker Middle School   Regular School No 2 06 08 2016   grade_7 131 16 100   0 26     10   24   166 141 0   32   4   157       3.0 307 131 16 100   0 26     10   24   166 141 0   32 4 157     3 307
520109 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002802 1841 Mosaic Home Education Partnership   Alternative Education School No 1 KG 08 2016   grade_7 6 0 1   0 0     0   3   5 5 0   0   0   1       1.0 10 6 0 1   0 0     0   3   5 5 0   0 0 1     1 10
520119 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002523 1699 Odyssey Multiage Program   Regular School No 1 01 08 2016   grade_7 20 0 3   0 2     0   1   15 11 0   0   0   1       3.0 26 20 0 3   0 2     0   1   15 11 0   0 0 1     3 26
520144 WA Clark   school 5300380 6119   Battle Ground School District 530038000048 2671 Amboy Middle School   Regular School No 2 05 08 2016   grade_7 143 0 3   0 2     0   2   74 76 0   0   1   62       6.0 150 143 0 3   0 2     0   2   74 76 0   0 1 62     6 150
520159 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative Education School No 4 03 12 2016   grade_7 55 0 1   0 1     0   1   28 30 0   0   0   12       0.0 58 55 0 1   0 1     0   1   28 30 0   0 0 12     0 58
520206 WA Clark   school 5300380 6119   Battle Ground School District 530038002857 1875 Homelink River   Alternative Education School No 4 KG 12 2016   grade_7 78 2 9   0 0     0   6   39 56 0   1   0   32       2.0 95 78 2 9   0 0     0   6   39 56 0   1 0 32     2 95
520213 WA Clark   school 5300380 6119   Battle Ground School District 530038000052 3545 Laurin Middle School   Regular School No 2 05 08 2016   grade_7 127 0 15   0 12     2   12   85 83 0   6   3   66       8.0 168 127 0 15   0 12     2   12   85 83 0   6 3 66     8 168
520232 WA Clark   school 5300380 6119   Battle Ground School District 530038000054 3997 Pleasant Valley Middle   Regular School No 2 05 08 2016   grade_7 80 0 16   0 5     1   9   56 55 0   4   1   47       2.0 111 80 0 16   0 5     1   9   56 55 0   4 1 47     2 111
520254 WA Clark   school 5300380 6119   Battle Ground School District 530038003531 5382 Summit View Middle School (Closed after 2016-2017 school year)   Regular School No 2 07 08 2016   grade_7 11 0 1   0 0     0   0   9 3 0   1   1   5       0.0 12 11 0 1   0 0     0   0   9 3 0   1 1 5     0 12
520259 WA Clark   school 5300380 6119   Battle Ground School District 530038003214 5131 Tukes Valley Middle School   Regular School No 2 05 08 2016   grade_7 122 1 9   0 1     0   4   63 74 0   1   3   50       5.0 137 122 1 9   0 1     0   4   63 74 0   1 3 50     5 137
520290 WA King   school 5300390 17405   Bellevue School District 530039003354 5240 Bellevue Big Picture School   Alternative Education School No 4 06 12 2016   grade_7 47 2 3   0 19     0   9   47 33 0   1   0   11       12.0 80 47 2 3   0 19     0   9   47 33 0   1 0 11     12 80
520317 WA King   school 5300390 17405   Bellevue School District 530039003434 5281 Central Educational Services   Regular School No 4 PK 13 2016   grade_7 2 0 1   0 0     0   0   2 1 0   0   0   0       0.0 3 2 0 1   0 0     0   0   2 1 0   0 0 0     0 3
520329 WA King   school 5300390 17405   Bellevue School District 530039000064 3338 Chinook Middle School   Regular School No 2 06 08 2016   grade_7 174 5 20   0 97     1   40   169 168 0   16   2   44       19.0 337 174 5 20   0 97     1   40   169 168 0   16 2 44     19 337
520357 WA King   school 5300390 17405   Bellevue School District 530039000068 3166 Highland Middle School   Regular School No 2 06 08 2016   grade_7 66 7 55   0 35     0   11   89 85 0   21   6   82       9.0 174 66 7 55   0 35     0   11   89 85 0   21 6 82     9 174
520369 WA King   school 5300390 17405   Bellevue School District 530039003149 3522 International School   Alternative Education School No 4 06 12 2016   grade_7 37 1 5   0 33     0   11   36 51 0   3   0   7       5.0 87 37 1 5   0 33     0   11   36 51 0   3 0 7     5 87
520408 WA King   school 5300390 17405   Bellevue School District 530039000079 3631 Odle Middle School   Regular School No 2 06 08 2016   grade_7 68 4 37   0 160     0   19   168 120 0   20   0   71       15.0 288 68 4 37   0 160     0   19   168 120 0   20 0 71     15 288
520464 WA King   school 5300390 17405   Bellevue School District 530039000093 3435 Tillicum Middle School   Regular School No 2 06 08 2016   grade_7 140 7 31   0 50     1   15   118 126 0   6   4   46       20.0 244 140 7 31   0 50     1   15   118 126 0   6 4 46     20 244
520468 WA King   school 5300390 17405   Bellevue School District 530039000094 3283 Tyee Middle School   Regular School No 2 06 08 2016   grade_7 122 5 17   0 150     0   38   179 153 0   14   1   46       19.0 332 122 5 17   0 150     0   38   179 153 0   14 1 46     19 332
520492 WA Whatcom   school 5300420 37501   Bellingham School District 530042003476 5366 Bellingham Family Partnership Program   Alternative Education School No 4 KG 12 2016   grade_7 8 0 0   0 0     0   2   5 5 0   0   0   2       2.0 10 8 0 0   0 0     0   2   5 5 0   0 0 2     2 10
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
520857 WA Klickitat   school 5300510 20203   Bickleton School District 530051000129 3392 Bickleton Elementary & High Schl   Regular School No 4 KG 12 2016   grade_7 5 0 1   0 0     0   0   5 1 0   0   0   3       0.0 6 5 0 1   0 0     0   0   5 1 0   0 0 3     0 6
520879 WA Whatcom   school 5300570 37503   Blaine School District 530057003020 5021 Blaine Home Connections   Alternative Education School No 4 KG 11 2016   grade_7 7 0 1   0 0     0   0   1 7 0   0   0   1       0.0 8 7 0 1   0 0     0   0   1 7 0   0 0 1     0 8
520886 WA Whatcom   school 5300570 37503   Blaine School District 530057000131 3796 Blaine Middle School   Regular School No 2 06 08 2016   grade_7 112 5 20   0 3     0   5   80 65 0   6   0   87       14.0 145 112 5 20   0 3     0   5   80 65 0   6 0 87     14 145
520905 WA Lewis   school 5300630 21234   Boistfort School District 530063000133 2516 Boistfort Elem   Regular School No 1 PK 08 2016   grade_7 7 0 0   0 0     0   0   5 2 0   0   0   5       0.0 7 7 0 0   0 0     0   0   5 2 0   0 0 5     0 7
520929 WA Kitsap   school 5300660 18100   Bremerton School District 530066002652 1749 Bremerton Homelink Program   Alternative Education School No 1 KG 08 2016   grade_7 5 0 0   0 0     0   1   3 3 0   0   0   3       1.0 6 5 0 0   0 0     0   1   3 3 0   0 0 3     1 6
521011 WA Okanogan   school 5300690 24111   Brewster School District 530069002284 4223 Brewster Middle School   Regular School No 2 06 08 2016   grade_7 7 0 62   0 0     0   0   37 32 0   24   0   63       2.0 69 7 0 62   0 0     0   0   37 32 0   24 0 63     2 69
521034 WA Douglas   school 5300720 9075   Bridgeport School District 530072001271 4213 Bridgeport Middle School   Regular School No 2 05 08 2016   grade_7 1 0 55   0 1     0   0   25 32 0   19   4   57       2.0 57 1 0 55   0 1     0   0   25 32 0   19 4 57     2 57
521043 WA Jefferson   school 5300750 16046   Brinnon School District 530075000153 2836 Brinnon Elementary   Regular School No 1 KG 08 2016   grade_7 3 0 0   0 0     0   1   3 1 0   0   0   4       0.0 4 3 0 0   0 0     0   1   3 1 0   0 0 4     0 4
521055 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000154 3603 Allen Elementary   Regular School No 1 KG 08 2016   grade_7 18 0 28   0 0     0   0   20 26 0   15   8   35       0.0 46 18 0 28   0 0     0   0   20 26 0   15 8 35     0 46
521087 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000156 2379 Edison Elementary   Regular School No 1 KG 08 2016   grade_7 43 1 2   0 0     0   0   28 18 0   0   0   13       0.0 46 43 1 2   0 0     0   0   28 18 0   0 0 13     0 46
521098 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000157 3251 Lucille Umbarger Elementary   Regular School No 1 KG 08 2016   grade_7 52 0 59   0 0     0   4   60 55 0   21   1   81       1.0 115 52 0 59   0 0     0   4   60 55 0   21 1 81     1 115
521153 WA Clark   school 5300810 6117   Camas School District 530081003066 5054 Liberty Middle School   Regular School No 2 06 08 2016   grade_7 217 1 19   0 6     1   16   141 119 0   5   3   58       17.0 260 217 1 19   0 6     1   16   141 119 0   5 3 58     17 260
521215 WA Pierce   school 5300870 27019   Carbonado School District 530087000166 2466 Carbonado Historical School 19   Regular School No 1 PK 08 2016   grade_7 20 0 1   0 1     0   1   11 12 0   0   0   7       0.0 23 20 0 1   0 1     0   1   11 12 0   0 0 7     0 23
521242 WA Chelan   school 5300950 4228   Cascade School District 530095003528 5418 Cascade Home-Link   Regular School No 1 KG 08 2016   grade_7 0 1 1   0 0     0   0   0 2 0   0   0   0       0.0 2 0 1 1   0 0     0   0   0 2 0   0 0 0     0 2
521288 WA Cowlitz   school 5300990 8401   Castle Rock School District 530099000173 3969 Castle Rock Middle School   Regular School No 2 06 08 2016   grade_7 73 1 5   0 0     2   3   39 45 0   2   3   52       11.0 84 73 1 5   0 0     2   3   39 45 0   2 3 52     11 84
521297 WA Klickitat   school 5301050 20215   Centerville School District 530105000175 2251 Centerville Elementary   Regular School No 1 KG 08 2016   grade_7 10 0 0   0 0     0   0   5 5 0   0   0   5       1.0 10 10 0 0   0 0     0   0   5 5 0   0 0 5     1 10
521373 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108000183 3791 Fairview Middle School   Regular School No 2 07 08 2016   grade_7 138 9 37   0 18     4   38   121 123 0   9   15   115       13.0 244 138 9 37   0 18     4   38   121 123 0   9 15 115     13 244
521395 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108002524 4509 Klahowya Secondary   Regular School No 3 07 12 2016   grade_7 124 0 13   0 4     1   13   76 79 0   0   5   52       8.0 155 124 0 13   0 4     1   13   76 79 0   0 5 52     8 155
521413 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108002574 1740 Off Campus (Closed after 2016-2017 school year)   Alternative Education School No 4 KG 12 2016   grade_7 13 0 1   0 0     0   1   7 8 0   0   0   2       0.0 15 13 0 1   0 0     0   1   7 8 0   0 0 2     0 15
521498 WA Spokane   school 5301110 32356   Central Valley School District 530111000193 3890 Evergreen Middle School   Regular School No 2 06 08 2016   grade_7 206 2 11   0 3     0   11   117 116 0   3   4   87       13.0 233 206 2 11   0 3     0   11   117 116 0   3 4 87     13 233
521508 WA Spokane   school 5301110 32356   Central Valley School District 530111000195 3573 Greenacres Middle School   Regular School No 2 06 08 2016   grade_7 223 2 15   0 7     0   11   111 147 0   2   0   61       22.0 258 223 2 15   0 7     0   11   111 147 0   2 0 61     22 258
521586 WA Spokane   school 5301110 32356   Central Valley School District 530111003137 1964 Spokane Valley Learning Academy   Regular School No 4 KG 12 2016   grade_7 8 0 0   0 0     0   0   1 7 0   0   0   1       0.0 8 8 0 0   0 0     0   0   1 7 0   0 0 1     0 8
521726 WA Spokane   school 5301230 32360   Cheney School District 530123003014 5035 HomeWorks   Alternative Education School No 4 KG 12 2016   grade_7 3 0 0   0 0     0   0   1 2 0   0   0   0       0.0 3 3 0 0   0 0     0   0   1 2 0   0 0 0     0 3
521788 WA Stevens   school 5301260 33036   Chewelah School District 530126000230 2404 Jenkins Junior/Senior High   Regular School No 3 07 12 2016   grade_7 47 0 3   0 1     0   1   29 23 0   0   1   32       1.0 52 47 0 3   0 1     0   1   29 23 0   0 1 32     1 52
521801 WA Stevens   school 5301260 33036   Chewelah School District 530126002687 1763 Quartzite Learning   Alternative Education School No 4 KG 12 2016   grade_7 4 0 0   0 0     0   0   0 4 0   0   0   1       0.0 4 4 0 0   0 0     0   0   0 4 0   0 0 1     0 4
521836 WA Jefferson   school 5301290 16049   Chimacum School District 530129002630 1724 PI Program   Alternative Education School No 4 KG 12 2016   grade_7 5 0 1   0 0     0   1   3 4 0   0   0   4       2.0 7 5 0 1   0 0     0   1   3 4 0   0 0 4     2 7
521918 WA Kittitas   school 5301350 19404   Cle Elum-Roslyn School District 530135000242 2570 Walter Strom Middle School   Regular School No 2 06 08 2016   grade_7 58 0 8   0 1     0   1   39 29 0   1   0   35       1.0 68 58 0 8   0 1     0   1   39 29 0   1 0 35     1 68
521990 WA Pierce   school 5301410 27400   Clover Park School District 530141000271 2041 Firwood   Regular School No 4 04 12 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
522046 WA Pierce   school 5301410 27400   Clover Park School District 530141000263 3602 Lochburn Middle School   Regular School No 2 06 08 2016   grade_7 36 37 61   0 14     16   22   95 91 0   19   12   174       2.0 186 36 37 61   0 14     16   22   95 91 0   19 12 174     2 186
522051 WA Pierce   school 5301410 27400   Clover Park School District 530141000264 3297 Mann Middle School (Closed after 2019-2020 school year)   Regular School No 2 06 08 2016   grade_7 59 15 24   0 7     10   18   72 61 0   2   1   76       3.0 133 59 15 24   0 7     10   18   72 61 0   2 1 76     3 133
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
522123 WA Pierce   school 5301410 27400   Clover Park School District 530141003396 5297 Transition Day Students   Regular School No 4 05 12 2016   grade_7 0 0 0   0 0     0   1   0 1 0   0   0   1       0.0 1 0 0 0   0 0     0   1   0 1 0   0 0 1     0 1
522140 WA Whitman   school 5301440 38300   Colfax School District 530144000273 3366 Colfax High School   Regular School No 3 07 12 2016   grade_7 47 0 1   0 0     0   2   27 23 0   0   0   16       2.0 50 47 0 1   0 0     0   2   27 23 0   0 0 16     2 50
522167 WA Walla Walla   school 5301470 36250   College Place School District 530147000276 3541 John Sager Middle School   Regular School No 2 05 08 2016   grade_7 57 1 40   0 0     0   2   54 46 0   12   2   60       1.0 100 57 1 40   0 0     0   2   54 46 0   12 2 60     1 100
522179 WA Whitman   school 5301500 38306   Colton School District 530150000277 2588 Colton School   Regular School No 4 PK 12 2016   grade_7 15 0 1   0 0     0   0   8 8 0   0   0   5       1.0 16 15 0 1   0 0     0   0   8 8 0   0 0 5     1 16
522247 WA Stevens   school 5301630 33115   Colville School District 530163003305 1594 Panorama School   Alternative Education School No 4 PK 12 2016   grade_7 2 0 1   0 0     0   0   0 3 0   0   0   1       0.0 3 2 0 1   0 0     0   0   0 3 0   0 0 1     0 3
522283 WA Skagit   school 5301680 29317   Conway School District 530168000287 2578 Conway School District 317   Regular School No 1 PK 08 2016   grade_7 40 0 5   0 0     0   0   19 26 0   1   2   10       1.0 45 40 0 5   0 0     0   0   19 26 0   1 2 10     1 45
522327 WA Island   school 5301800 15204   Coupeville School District 530180002049 4004 Coupeville Middle School   Regular School No 2 06 08 2016   grade_7 54 0 7   0 3     0   5   29 40 0   3   1   23       7.0 69 54 0 7   0 3     0   5   29 40 0   3 1 23     7 69
522353 WA Clallam   school 5301830 5313   Crescent School District 530183002942 5030 Olympic Peninsula HomeConnection   Alternative Education School No 4 KG 12 2016   grade_7 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
522369 WA Lincoln   school 5301860 22073   Creston School District 530186000294 2863 Creston Jr-Sr High School   Regular School No 3 07 12 2016   grade_7 13 0 0   0 0     0   0   6 7 0   0   1   2       0.0 13 13 0 0   0 0     0   0   6 7 0   0 1 2     0 13
522485 WA Spokane   school 5302070 32414   Deer Park School District 530207002827 1852 Deer Park Home Link Program   Alternative Education School No 4 KG 12 2016   grade_7 31 2 3   0 0     0   0   12 24 0   0   0   9       5.0 36 31 2 3   0 0     0   0   12 24 0   0 0 9     5 36
522527 WA Spokane   school 5302280 32361   East Valley School District (Spokane) 530228002600 1712 Continuous Curriculum School   Regular School No 1 KG 08 2016   grade_7 35 0 1   0 2     0   2   23 17 0   0   0   10       3.0 40 35 0 1   0 2     0   2   23 17 0   0 0 10     3 40
522591 WA Spokane   school 5302280 32361   East Valley School District (Spokane) 530228003240 5156 Washington Academy of Arts and Technology (Closed after 2015-2016 school year)   Alternative Education School No 4 KG 12 2016   grade_7 16 0 3   0 0     0   1   11 9 0   0   0   8       1.0 20 16 0 3   0 0     0   1   11 9 0   0 0 8     1 20
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
522713 WA Pierce   school 5302370 27404   Eatonville School District 530237000325 2808 Columbia Crest A-STEM Academy   Regular School No 1 KG 08 2016   grade_7 12 0 1   0 0     0   1   10 4 0   0   1   6       0.0 14 12 0 1   0 0     0   1   10 4 0   0 1 6     0 14
522746 WA Pierce   school 5302370 27404   Eatonville School District 530237003389 5300 Mt. Rainier Parent Partnership   Alternative Education School No 1 KG 08 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
522823 WA Snohomish   school 5302400 31015   Edmonds School District 530240000337 3754 College Place Middle School   Regular School No 2 07 08 2016   grade_7 113 21 63   0 16     1   26   131 109 0   26   12   124       14.0 240 113 21 63   0 16     1   26   131 109 0   26 12 124     14 240
522831 WA Snohomish   school 5302400 31015   Edmonds School District 530240002821 1830 Contracted Schools   Special Education School No 4 04 12 2016   grade_7 2 1 1   0 1     0   1   5 1 0   0   0   6       0.0 6 2 1 1   0 1     0   1   5 1 0   0 0 6     0 6
522863 WA Snohomish   school 5302400 31015   Edmonds School District 530240003139 1966 Edmonds Heights K-12   Alternative Education School No 4 KG 12 2016   grade_7 42 1 9   0 4     0   7   31 32 0   0   1   17       1.0 63 42 1 9   0 4     0   7   31 32 0   0 1 17     1 63
522919 WA Snohomish   school 5302400 31015   Edmonds School District 530240000348 3463 Madrona K-8 School   Alternative Education School No 1 PK 08 2016   grade_7 45 4 8   0 12     0   6   38 37 0   2   0   12       10.0 75 45 4 8   0 12     0   6   38 37 0   2 0 12     10 75
522930 WA Snohomish   school 5302400 31015   Edmonds School District 530240000349 3818 Maplewood Center (Closed after 2016-2017 school year)   Special Education School No 4 KG 12 2016   grade_7 1 1 2   0 0     0   0   3 1 0   0   0   2       0.0 4 1 1 2   0 0     0   0   3 1 0   0 0 2     0 4
522940 WA Snohomish   school 5302400 31015   Edmonds School District 530240002474 1685 Maplewood Parent Coop   Alternative Education School No 1 KG 08 2016   grade_7 39 1 3   0 3     0   5   25 26 0   0   0   5       6.0 51 39 1 3   0 3     0   5   25 26 0   0 0 5     6 51
523038 WA Snohomish   school 5302400 31015   Edmonds School District 530240002290 1558 Unassigned School   Special Education School No 4 PK 11 2016   grade_7 3 0 0   0 0     0   0   3 0 0   0   0   0       0.0 3 3 0 0   0 0     0   0   3 0 0   0 0 0     0 3
523064 WA Kittitas   school 5302460 19401   Ellensburg School District 530246003168 5097 K-12 Ellensburg Learning Center   Alternative Education School No 4 PK 12 2016   grade_7 3 0 0   0 0     0   0   1 2 0   0   0   0       0.0 3 3 0 0   0 0     0   0   1 2 0   0 0 0     0 3
523077 WA Kittitas   school 5302460 19401   Ellensburg School District 530246000367 2453 Morgan Middle School   Regular School No 2 06 08 2016   grade_7 171 3 45   0 6     1   4   112 118 0   17   1   99       7.0 230 171 3 45   0 6     1   4   112 118 0   17 1 99     7 230
523115 WA Grays Harbor   school 5302490 14068   Elma School District 530249002060 4245 Elma Middle School   Regular School No 2 06 08 2016   grade_7 82 0 22   0 1     0   9   67 50 0   5   1   72       2.0 117 82 0 22   0 1     0   9   67 50 0   5 1 72     2 117
523124 WA Whitman   school 5302520 38308   Endicott School District 530252000373 2207 Endicott/St John Elem and Middle   Regular School No 1 PK 08 2016   grade_7 19 0 0   0 0     0   1   12 8 0   0   0   11       0.0 20 19 0 0   0 0     0   1   12 8 0   0 0 11     0 20
523133 WA Chelan   school 5302550 4127   Entiat School District 530255000374 3317 Entiat Middle and High School   Regular School No 4 06 12 2016   grade_7 17 0 10   0 1     0   0   13 15 0   5   1   22       0.0 28 17 0 10   0 1     0   0   13 15 0   5 1 22     0 28
523182 WA King   school 5300001 17216   Enumclaw School District 530000103038 1523 Special Ed School   Special Education School No 4 PK 12 2016   grade_7 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
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
523226 WA Grant   school 5302610 13165   Ephrata School District 530261000387 3373 Ephrata Middle School   Regular School No 2 06 08 2016   grade_7 141 0 44   0 2     0   3   92 98 0   7   10   104       10.0 190 141 0 44   0 2     0   3   92 98 0   7 10 104     10 190
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
523263 WA Spokane   school 5300010 32801   ESD 101 acting as a school district 530001002930 3526 Spokane Juvenile Detention School   Regular School No 4 06 12 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
523275 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000503407 5290 Clark County Juvenile Detention School   Regular School No 4 03 12 2016   grade_7 2 0 0   0 0     0   0   2 0 0   0   0   0       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 0     0 2
523283 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000502917 3294 Cowlitz County Youth Services Center   Regular School No 4 06 12 2016   grade_7 0 0 1   0 0     0   0   1 0 0   0   0   0       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 0     0 1
523303 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702927 3481 Kitsap Co Detention Ctr   Regular School No 4 06 12 2016   grade_7 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
523314 WA Skagit   school 5300008 29801   ESD 189 acting as a school district 530000802923 3420 Whatcom Co Detention Center   Regular School No 3 07 12 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
523394 WA Snohomish   school 5302670 31002   Everett School District 530267002253 4334 Heatherwood Middle School   Regular School No 2 06 08 2016   grade_7 169 15 47   0 59     2   29   165 156 0   16   2   110       8.0 321 169 15 47   0 59     2   29   165 156 0   16 2 110     8 321
523478 WA Snohomish   school 5302670 31002   Everett School District 530267002897 1907 Port Gardner   Alternative Education School No 4 KG 12 2016   grade_7 11 0 0   0 0     0   0   5 6 0   0   0   1       0.0 11 11 0 0   0 0     0   0   5 6 0   0 0 1     0 11
523544 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270001270 1646 49th Street Academy   Special Education School No 4 KG 12 2016   grade_7 4 0 1   0 0     0   0   5 0 0   0   0   4       1.0 5 4 0 1   0 0     0   0   5 0 0   0 0 4     1 5
523576 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270000415 3320 Covington Middle School   Regular School No 2 06 08 2016   grade_7 195 9 92   0 17     6   21   199 141 0   44   13   222       6.0 340 195 9 92   0 17     6   21   199 141 0   44 13 222     6 340
523662 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270003101 1926 Home Choice Academy   Alternative Education School No 4 KG 12 2016   grade_7 17 0 2   0 0     0   2   16 5 0   0   1   6       2.0 21 17 0 2   0 0     0   2   16 5 0   0 1 6     2 21
523685 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270002710 1801 iQ Academy Washington (Closed after 2016-2017 school year)   Alternative Education School No 4 06 12 2016   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
523742 WA Clark   school 5302700 6114   Evergreen School District (Clark) 530270002878 4561 Shahala Middle School   Regular School No 2 06 08 2016   grade_7 211 14 47   0 71     2   38   206 177 0   13   5   99       17.0 383 211 14 47   0 71     2   38   206 177 0   13 5 99     17 383
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

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