enrollments

Data source: Big Local News · About: Big Local

658 rows where grade = "grade_7", state = "WA" and year = 2017 sorted by district_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 658 ✖

grade ✖

  • grade_7 · 658 ✖
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
620549 620549 WA King   school 5300001 17216   Enumclaw School District 530000102054 4210 Enumclaw Middle School   Regular School No Middle 06 08 2017   grade_7 116 1 18   1 0     1   4   73 68 0   6   6   46       3.0 141 116 1 18   1 0     1   4   73 68 0   6 6 46     3 141
620581 620581 WA King   school 5300001 17216   Enumclaw School District 530000102795 4550 Thunder Mountain Middle School   Regular School No Middle 06 08 2017   grade_7 118 2 35   1 0     0   8   83 81 0   5   4   54       5.0 164 118 2 35   1 0     0   8   83 81 0   5 4 54     5 164
622247 622247 WA Ferry   school 5300002 10070   Inchelium School District 530000202870 4214 Inchelium Middle School   Regular School No Middle 06 08 2017   grade_7 0 0 0   13 0     0   3   7 9 0   7   0   12       0.0 16 0 0 0   13 0     0   3   7 9 0   7 0 12     0 16
622514 622514 WA Cowlitz   school 5300003 8458   Kelso School District 530000300591 3322 Coweeman Middle School   Regular School No Middle 06 08 2017   grade_7 141 0 32   4 3     0   9   84 105 0   12   1   101       8.0 189 141 0 32   4 3     0   9   84 105 0   12 1 101     8 189
622518 622518 WA Cowlitz   school 5300003 8458   Kelso School District 530000300592 2916 Huntington Middle School   Regular School No Middle 06 08 2017   grade_7 109 0 36   0 2     0   7   81 73 0   6   5   102       5.0 154 109 0 36   0 2     0   7   81 73 0   6 5 102     5 154
622547 622547 WA Cowlitz   school 5300003 8458   Kelso School District 530000303076 5076 Special Education   Special Education School No Other PK 12 2017   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
620685 620685 WA Kitsap   school 5300007 18801   ESD 114 acting as a school district 530000702927 3481 Kitsap Co Detention Ctr   Regular School No High 08 12 2017   grade_7 0 0 0   0 0     1   0   1 0 0   0   0   1       0.0 1 0 0 0   0 0     1   0   1 0 0   0 0 1     0 1
631955 631955 WA Thurston   school 5300015 34975   Washington Center for Deaf and Hard of Hearing Youth 530001501016 4246 Washington State School for the Deaf   Regular School No Other PK 12 2017   grade_7 3 0 4   0 0     0   1   4 4 0   0   0   5       0.0 8 3 0 4   0 0     0   1   4 4 0   0 0 5     0 8
617047 617047 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000001 2834 A J West Elementary   Regular School No Elementary PK 06 2017   grade_7 0 0 1   0 0     0   0   0 1 0   1   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   1 0 1     0 1
617062 617062 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003002055 4267 Grays Harbor Juvenile Detention   Regular School No Other 06 12 2017   grade_7 1 0 0   0 0     0   0   1 0 0   0   1   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 1 1     0 1
617085 617085 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No Elementary KG 06 2017   grade_7 0 0 2   0 0     0   0   1 1 0   2   0   1       0.0 2 0 0 2   0 0     0   0   1 1 0   2 0 1     0 2
617089 617089 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000009 2305 Miller Junior High   Regular School No Middle 07 08 2017   grade_7 148 5 58   10 5     0   12   110 128 0   20   14   170       6.0 238 148 5 58   10 5     0   12   110 128 0   20 14 170     6 238
617125 617125 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No Other 06 12 2017   grade_7 40 0 2   0 1     0   0   20 23 0   0   0   13       0.0 43 40 0 2   0 1     0   0   20 23 0   0 0 13     0 43
617135 617135 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary KG 08 2017   grade_7 22 0 0   0 0     0   1   11 12 0   0   0   10       1.0 23 22 0 0   0 0     0   1   11 12 0   0 0 10     1 23
617147 617147 WA Skagit   school 5300150 29103   Anacortes School District 530015000015 2707 Anacortes Middle School   Regular School No Middle 07 08 2017   grade_7 149 3 21   1 8     0   3   93 92 0   4   0   63       13.0 185 149 3 21   1 8     0   3   93 92 0   4 0 63     13 185
617169 617169 WA Skagit   school 5300150 29103   Anacortes School District 530015000018 3252 Island View Elementary   Regular School No Elementary KG 06 2017   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
617206 617206 WA Snohomish   school 5300240 31016   Arlington School District 530024003008 5010 Haller Middle School   Regular School No Middle 06 08 2017   grade_7 165 4 42   6 5     2   8   132 100 0   15   2   77       11.0 232 165 4 42   6 5     2   8   132 100 0   15 2 77     11 232
617227 617227 WA Snohomish   school 5300240 31016   Arlington School District 530024000024 3124 Post Middle School   Regular School No Middle 06 08 2017   grade_7 182 3 18   4 2     0   8   131 86 0   10   13   93       11.0 217 182 3 18   4 2     0   8   131 86 0   10 13 93     11 217
617248 617248 WA Snohomish   school 5300240 31016   Arlington School District 530024002589 1714 Stillaguamish Valley Learning Center   Alternative School No Other KG 12 2017   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
617270 617270 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No Other 06 12 2017   grade_7 51 0 2   0 1     0   7   30 31 0   0   1   19       0.0 61 51 0 2   0 1     0   7   30 31 0   0 1 19     0 61
617306 617306 WA King   school 5300300 17408   Auburn School District 530030000033 2394 Cascade Middle School   Regular School No Middle 06 08 2017   grade_7 96 26 63   1 24     12   21   111 132 0   33   6   161       6.0 243 96 26 63   1 24     12   21   111 132 0   33 6 161     6 243
617381 617381 WA King   school 5300300 17408   Auburn School District 530030001443 4462 Mt Baker Middle School   Regular School No Middle 06 08 2017   grade_7 134 23 107   4 33     13   25   169 170 0   36   3   173       5.0 339 134 23 107   4 33     13   25   169 170 0   36 3 173     5 339
617385 617385 WA King   school 5300300 17408   Auburn School District 530030000038 3169 Olympic Middle School   Regular School No Middle 06 08 2017   grade_7 84 16 87   7 14     15   26   126 123 0   58   3   192       5.0 249 84 16 87   7 14     15   26   126 123 0   58 3 192     5 249
617398 617398 WA King   school 5300300 17408   Auburn School District 530030002434 4385 Rainier Middle School   Regular School No Middle 06 08 2017   grade_7 154 21 64   0 33     5   24   153 148 0   19   4   147       10.0 301 154 21 64   0 33     5   24   153 148 0   19 4 147     10 301
626106 626106 WA Thurston   school 5300318 34974   Office of the Governor (Sch for Blind) 530031802385 3799 Washington State School for the Blind   Regular School No Other 06 13 2017   grade_7 4 0 1   1 0     0   0   3 3 0   0   0   4       0.0 6 4 0 1   1 0     0   0   3 3 0   0 0 4     0 6
630562 630562 WA Kitsap   school 5300328 18902   Suquamish Tribal Education Department 530032803493 5319 Chief Kitsap Academy   Regular School No Other KG 12 2017   grade_7 0 0 4   4 0     0   3   7 5 0   0   0   8       0.0 12 0 0 4   4 0     0   3   7 5 0   0 0 8     0 12
617443 617443 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033003113 1939 Bainbridge Special Education Services   Special Education School No Other PK 12 2017   grade_7 3 0 0   0 0     0   0   2 1 0   0   0   0       0.0 3 3 0 0   0 0     0   0   2 1 0   0 0 0     0 3
617472 617472 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002802 1841 Mosaic Home Education Partnership   Alternative School No Elementary KG 08 2017   grade_7 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
617482 617482 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002523 1699 Odyssey Multiage Program   Regular School No Elementary 01 08 2017   grade_7 22 0 0   0 0     0   2   12 12 0   0   0   3       2.0 24 22 0 0   0 0     0   2   12 12 0   0 0 3     2 24
617496 617496 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002452 4505 Woodward Middle School   Regular School No Middle 07 08 2017   grade_7 243 3 26   2 8     1   20   139 164 0   4   3   33       21.0 303 243 3 26   2 8     1   20   139 164 0   4 3 33     21 303
621175 621175 WA King   school 5300332 17906   Excel Public Charter School 530033203536 5377 Excel Public Charter School (Closed after 2018-2019 school year)   Regular School Yes Middle 06 08 2017   grade_7 35 31 6   0 10     2   13   56 41 0   12   1   36       9.0 97 35 31 6   0 10     2   13   56 41 0   12 1 36     9 97
627508 627508 WA King   school 5300335 17908   Rainier Prep Charter School District 530033503533 5380 Rainier Prep   Regular School Yes Middle 05 08 2017   grade_7 5 27 36   0 11     1   7   48 39 0   18   1   71       3.0 87 5 27 36   0 11     1   7   48 39 0   18 1 71     3 87
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
621877 621877 WA Pierce   school 5300338 27904   Green Dot Destiny 530033803553 5378 Destiny Charter Middle School (Closed after 2018-2019 school year)   Regular School Yes Middle 06 08 2017   grade_7 29 43 44   5 2     3   26   80 72 0   4   12   127       4.0 152 29 43 44   5 2     3   26   80 72 0   4 12 127     4 152
627046 627046 WA Spokane   school 5300339 32907   PRIDE Prep Charter School District 530033903495 5339 PRIDE Prep School   Regular School Yes Other 06 12 2017   grade_7 58 6 4   4 1     1   7   46 35 0   0   0   43       4.0 81 58 6 4   4 1     1   7   46 35 0   0 0 43     4 81
617501 617501 WA Clark   school 5300380 6119   Battle Ground School District 530038000048 2671 Amboy Middle School   Regular School No Middle 05 08 2017   grade_7 138 0 3   2 1     0   0   78 66 0   1   1   47       8.0 144 138 0 3   2 1     0   0   78 66 0   1 1 47     8 144
617516 617516 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2017   grade_7 53 0 0   0 1     0   4   28 30 0   0   0   9       1.0 58 53 0 0   0 1     0   4   28 30 0   0 0 9     1 58
617530 617530 WA Clark   school 5300380 6119   Battle Ground School District 530038003262 5133 Chief Umtuch Middle   Regular School No Middle 05 08 2017   grade_7 126 2 14   0 1     0   7   81 69 0   7   1   62       3.0 150 126 2 14   0 1     0   7   81 69 0   7 1 62     3 150
617535 617535 WA Clark   school 5300380 6119   Battle Ground School District 530038003176 5089 Daybreak Middle   Regular School No Middle 05 08 2017   grade_7 112 2 9   0 1     1   4   70 59 0   3   2   53       2.0 129 112 2 9   0 1     1   4   70 59 0   3 2 53     2 129
617562 617562 WA Clark   school 5300380 6119   Battle Ground School District 530038002857 1875 Homelink River   Alternative School No Other KG 12 2017   grade_7 60 2 2   0 1     0   6   33 38 0   6   0   24       1.0 71 60 2 2   0 1     0   6   33 38 0   6 0 24     1 71
617569 617569 WA Clark   school 5300380 6119   Battle Ground School District 530038000052 3545 Laurin Middle School   Regular School No Middle 05 08 2017   grade_7 104 2 22   1 11     0   8   66 82 0   9   3   62       5.0 148 104 2 22   1 11     0   8   66 82 0   9 3 62     5 148
617578 617578 WA Clark   school 5300380 6119   Battle Ground School District 530038003409 5291 Maple Grove K-8 (Closed after 2018-2019 school year)   Regular School No Elementary PK 08 2017   grade_7 35 0 3   0 2     0   1   22 19 0   6   2   19       3.0 41 35 0 3   0 2     0   1   22 19 0   6 2 19     3 41
617588 617588 WA Clark   school 5300380 6119   Battle Ground School District 530038000054 3997 Pleasant Valley Middle   Regular School No Middle 05 08 2017   grade_7 91 1 27   1 6     0   13   75 64 0   5   1   51       6.0 139 91 1 27   1 6     0   13   75 64 0   5 1 51     6 139
617615 617615 WA Clark   school 5300380 6119   Battle Ground School District 530038003214 5131 Tukes Valley Middle School   Regular School No Middle 05 08 2017   grade_7 106 0 10   0 1     0   5   63 59 0   4   1   51       3.0 122 106 0 10   0 1     0   5   63 59 0   4 1 51     3 122
617645 617645 WA King   school 5300390 17405   Bellevue School District 530039003354 5240 Bellevue Big Picture School   Alternative School No Other 06 12 2017   grade_7 44 4 5   0 16     0   7   41 35 0   0   0   15       8.0 76 44 4 5   0 16     0   7   41 35 0   0 0 15     8 76
617686 617686 WA King   school 5300390 17405   Bellevue School District 530039000064 3338 Chinook Middle School   Regular School No Middle 06 08 2017   grade_7 173 3 30   0 116     1   29   175 177 0   30   5   49       31.0 352 173 3 30   0 116     1   29   175 177 0   30 5 49     31 352
617714 617714 WA King   school 5300390 17405   Bellevue School District 530039000068 3166 Highland Middle School   Regular School No Middle 06 08 2017   grade_7 68 11 54   1 28     1   18   95 86 0   23   3   78       10.0 181 68 11 54   1 28     1   18   95 86 0   23 3 78     10 181
617726 617726 WA King   school 5300390 17405   Bellevue School District 530039003149 3522 International School   Alternative School No Other 06 12 2017   grade_7 50 1 1   0 29     0   6   41 46 0   0   0   4       4.0 87 50 1 1   0 29     0   6   41 46 0   0 0 4     4 87
617768 617768 WA King   school 5300390 17405   Bellevue School District 530039000079 3631 Odle Middle School   Regular School No Middle 06 08 2017   grade_7 68 8 42   1 185     0   33   177 160 0   20   6   79       15.0 337 68 8 42   1 185     0   33   177 160 0   20 6 79     15 337
617824 617824 WA King   school 5300390 17405   Bellevue School District 530039000093 3435 Tillicum Middle School   Regular School No Middle 06 08 2017   grade_7 103 5 21   0 35     0   25   93 96 0   12   0   32       8.0 189 103 5 21   0 35     0   25   93 96 0   12 0 32     8 189
617828 617828 WA King   school 5300390 17405   Bellevue School District 530039000094 3283 Tyee Middle School   Regular School No Middle 06 08 2017   grade_7 89 7 22   0 178     1   36   179 154 0   16   0   44       21.0 333 89 7 22   0 178     1   36   179 154 0   16 0 44     21 333
617852 617852 WA Whatcom   school 5300420 37501   Bellingham School District 530042003476 5366 Bellingham Family Partnership Program   Alternative School No Other KG 12 2017   grade_7 6 0 1   0 0     0   1   5 3 0   0   0   1       1.0 8 6 0 1   0 0     0   1   5 3 0   0 0 1     1 8
617897 617897 WA Whatcom   school 5300420 37501   Bellingham School District 530042000104 2066 Fairhaven Middle School   Regular School No Middle 06 08 2017   grade_7 153 1 16   1 17     0   12   94 106 0   3   6   42       18.0 200 153 1 16   1 17     0   12   94 106 0   3 6 42     18 200
617923 617923 WA Whatcom   school 5300420 37501   Bellingham School District 530042001739 4442 Kulshan Middle School   Regular School No Middle 06 08 2017   grade_7 112 5 31   2 11     0   16   94 83 0   9   7   89       14.0 177 112 5 31   2 11     0   16   94 83 0   9 7 89     14 177
617968 617968 WA Whatcom   school 5300420 37501   Bellingham School District 530042000114 3201 Shuksan Middle School   Regular School No Middle 06 08 2017   grade_7 116 5 48   5 17     2   12   101 104 0   21   13   126       10.0 205 116 5 48   5 17     2   12   101 104 0   21 13 126     10 205
618007 618007 WA Whatcom   school 5300420 37501   Bellingham School District 530042000117 2075 Whatcom Middle School   Regular School No Middle 06 08 2017   grade_7 175 2 20   2 5     0   15   124 95 0   4   9   69       15.0 219 175 2 20   2 5     0   15   124 95 0   4 9 69     15 219
618035 618035 WA Pierce   school 5300480 27403   Bethel School District 530048000120 3250 Bethel Middle School   Regular School No Middle 06 08 2017   grade_7 110 20 30   2 9     13   23   105 104 0   7   4   128       7.0 209 110 20 30   2 9     13   23   105 104 0   7 4 128     7 209
618048 618048 WA Pierce   school 5300480 27403   Bethel School District 530048001819 4186 Cedarcrest Middle School   Regular School No Other 06 12 2017   grade_7 84 37 32   3 15     10   17   104 95 0   7   5   134       7.0 199 84 37 32   3 15     10   17   104 95 0   7 5 134     7 199
618080 618080 WA Pierce   school 5300480 27403   Bethel School District 530048003158 4578 Cougar Mountain Middle School   Regular School No Middle 06 08 2017   grade_7 133 4 23   4 8     4   14   101 90 0   1   1   113       8.0 191 133 4 23   4 8     4   14   101 90 0   1 1 113     8 191
618089 618089 WA Pierce   school 5300480 27403   Bethel School District 530048000123 2877 Elk Plain School of Choice   Regular School No Elementary KG 08 2017   grade_7 38 4 16   0 4     1   4   34 33 0   0   1   26       5.0 67 38 4 16   0 4     1   4   34 33 0   0 1 26     5 67
618110 618110 WA Pierce   school 5300480 27403   Bethel School District 530048000595 4407 Frontier Middle School   Regular School No Middle 06 08 2017   grade_7 171 9 29   4 4     2   20   131 109 0   3   3   100       5.0 240 171 9 29   4 4     2   20   131 109 0   3 3 100     5 240
618135 618135 WA Pierce   school 5300480 27403   Bethel School District 530048003343 5206 Liberty Middle School   Regular School No Middle 06 08 2017   grade_7 147 17 36   1 10     7   31   134 117 0   3   7   129       14.0 251 147 17 36   1 10     7   31   134 117 0   3 7 129     14 251
618212 618212 WA Pierce   school 5300480 27403   Bethel School District 530048000128 3751 Spanaway Middle School   Regular School No Middle 06 08 2017   grade_7 88 26 51   5 7     10   35   118 104 0   20   10   172       12.0 222 88 26 51   5 7     10   35   118 104 0   20 10 172     12 222
618227 618227 WA Klickitat   school 5300510 20203   Bickleton School District 530051000129 3392 Bickleton Elementary & High Schl   Regular School No Other KG 12 2017   grade_7 1 0 3   0 0     0   0   2 2 0   0   0   0       0.0 4 1 0 3   0 0     0   0   2 2 0   0 0 0     0 4
618248 618248 WA Whatcom   school 5300570 37503   Blaine School District 530057003020 5021 Blaine Home Connections   Alternative School No Other KG 11 2017   grade_7 4 0 0   0 0     0   1   1 4 0   0   0   0       0.0 5 4 0 0   0 0     0   1   1 4 0   0 0 0     0 5
618254 618254 WA Whatcom   school 5300570 37503   Blaine School District 530057000131 3796 Blaine Middle School   Regular School No Middle 06 08 2017   grade_7 113 4 16   3 4     3   3   81 65 0   4   3   71       12.0 146 113 4 16   3 4     3   3   81 65 0   4 3 71     12 146
618273 618273 WA Lewis   school 5300630 21234   Boistfort School District 530063000133 2516 Boistfort Elem   Regular School No Elementary PK 08 2017   grade_7 7 0 0   1 0     0   0   4 4 0   0   0   5       0.0 8 7 0 0   1 0     0   0   4 4 0   0 0 5     0 8
618298 618298 WA Kitsap   school 5300660 18100   Bremerton School District 530066002652 1749 Bremerton Homelink Program   Alternative School No Elementary KG 08 2017   grade_7 4 0 2   0 0     0   1   4 3 0   0   0   5       0.0 7 4 0 2   0 0     0   1   4 3 0   0 0 5     0 7
618322 618322 WA Kitsap   school 5300660 18100   Bremerton School District 530066001144 4441 Mountain View Middle School   Regular School No Middle 06 08 2017   grade_7 141 17 47   2 12     7   43   134 135 0   12   7   175       12.0 269 141 17 47   2 12     7   43   134 135 0   12 7 175     12 269
618354 618354 WA Kitsap   school 5300660 18100   Bremerton School District 530066000144 2613 West Hills S.T.E.M. Academy   Regular School No Elementary PK 08 2017   grade_7 22 1 10   2 4     1   11   31 20 0   1   0   38       7.0 51 22 1 10   2 4     1   11   31 20 0   1 0 38     7 51
618381 618381 WA Okanogan   school 5300690 24111   Brewster School District 530069002284 4223 Brewster Middle School   Regular School No Middle 06 08 2017   grade_7 7 0 67   2 0     0   1   45 32 0   29   0   74       2.0 77 7 0 67   2 0     0   1   45 32 0   29 0 74     2 77
618404 618404 WA Douglas   school 5300720 9075   Bridgeport School District 530072001271 4213 Bridgeport Middle School   Regular School No Middle 05 08 2017   grade_7 3 0 56   0 0     0   0   32 27 0   23   6   55       2.0 59 3 0 56   0 0     0   0   32 27 0   23 6 55     2 59
618413 618413 WA Jefferson   school 5300750 16046   Brinnon School District 530075000153 2836 Brinnon Elementary   Regular School No Elementary KG 08 2017   grade_7 5 0 1   0 0     0   1   6 1 0   0   0   7       0.0 7 5 0 1   0 0     0   1   6 1 0   0 0 7     0 7
618424 618424 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000154 3603 Allen Elementary   Regular School No Elementary KG 08 2017   grade_7 19 1 36   0 0     1   3   31 29 0   20   2   49       0.0 60 19 1 36   0 0     1   3   31 29 0   20 2 49     0 60
618435 618435 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000689 4412 Bay View Elementary   Regular School No Elementary KG 08 2017   grade_7 42 0 15   0 2     1   0   33 27 0   10   2   22       0.0 60 42 0 15   0 2     1   0   33 27 0   10 2 22     0 60
618457 618457 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000156 2379 Edison Elementary   Regular School No Elementary KG 08 2017   grade_7 46 1 8   0 0     1   5   32 29 0   1   0   13       0.0 61 46 1 8   0 0     1   5   32 29 0   1 0 13     0 61
618468 618468 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000157 3251 Lucille Umbarger Elementary   Regular School No Elementary 01 08 2017   grade_7 39 0 79   2 2     0   4   59 67 0   30   3   91       2.0 126 39 0 79   2 2     0   4   59 67 0   30 3 91     2 126
618522 618522 WA Clark   school 5300810 6117   Camas School District 530081003066 5054 Liberty Middle School   Regular School No Middle 06 08 2017   grade_7 236 2 26   0 14     0   21   149 150 0   4   2   70       20.0 299 236 2 26   0 14     0   21   149 150 0   4 2 70     20 299
618537 618537 WA Clark   school 5300810 6117   Camas School District 530081002512 4508 Skyridge Middle School   Regular School No Middle 06 08 2017   grade_7 184 3 18   1 31     2   19   128 130 0   3   1   29       22.0 258 184 3 18   1 31     2   19   128 130 0   3 1 29     22 258
618558 618558 WA Clallam   school 5300840 5401   Cape Flattery School District 530084000164 3422 Clallam Bay High & Elementary   Regular School No Other KG 12 2017   grade_7 5 0 3   0 0     0   1   4 5 0   0   0   7       2.0 9 5 0 3   0 0     0   1   4 5 0   0 0 7     2 9
618574 618574 WA Clallam   school 5300840 5401   Cape Flattery School District 530084000165 3145 Neah Bay Junior/ Senior High School   Regular School No Other 06 12 2017   grade_7 0 0 3   20 0     0   3   8 18 0   1   0   22       0.0 26 0 0 3   20 0     0   3   8 18 0   1 0 22     0 26
618584 618584 WA Pierce   school 5300870 27019   Carbonado School District 530087000166 2466 Carbonado Historical School 19   Regular School No Elementary KG 08 2017   grade_7 21 0 2   0 0     0   0   13 10 0   0   0   11       0.0 23 21 0 2   0 0     0   0   13 10 0   0 0 11     0 23
618612 618612 WA Chelan   school 5300950 4228   Cascade School District 530095003528 5418 Cascade Home-Link   Regular School No Elementary KG 08 2017   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
618617 618617 WA Chelan   school 5300950 4228   Cascade School District 530095000553 4403 Icicle River Middle School   Regular School No Middle 06 08 2017   grade_7 64 0 33   1 0     0   3   48 54 0   13   7   60       3.0 102 64 0 33   1 0     0   3   48 54 0   13 7 60     3 102
618633 618633 WA Chelan   school 5300960 4222   CASHMERE SCHOOL DISTRICT 530096000169 2315 CASHMERE MIDDLE SCHOOL   Regular School No Middle 05 08 2017   grade_7 53 0 52   0 0     0   7   55 57 0   11   2   62       6.0 112 53 0 52   0 0     0   7   55 57 0   11 2 62     6 112
618658 618658 WA Cowlitz   school 5300990 8401   Castle Rock School District 530099000173 3969 Castle Rock Middle School   Regular School No Middle 06 08 2017   grade_7 73 0 4   0 0     0   5   44 38 0   1   1   47       3.0 82 73 0 4   0 0     0   5   44 38 0   1 1 47     3 82
618667 618667 WA Klickitat   school 5301050 20215   Centerville School District 530105000175 2251 Centerville Elementary   Regular School No Elementary KG 08 2017   grade_7 6 0 1   0 0     0   0   3 4 0   0   0   4       0.0 7 6 0 1   0 0     0   0   3 4 0   0 0 4     0 7
618691 618691 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108000178 3237 Central Kitsap Middle School   Regular School No Middle 06 08 2017   grade_7 126 10 32   1 16     2   40   121 106 0   1   0   53       18.0 227 126 10 32   1 16     2   40   121 106 0   1 0 53     18 227
618735 618735 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108000183 3791 Fairview Middle School   Regular School No Middle 06 08 2017   grade_7 112 12 35   0 16     4   48   116 111 0   3   0   102       18.0 227 112 12 35   0 16     4   48   116 111 0   3 0 102     18 227
618757 618757 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108002524 4509 Klahowya Secondary   Regular School No Other 06 12 2017   grade_7 103 2 13   2 4     0   18   67 75 0   1   0   35       8.0 142 103 2 13   2 4     0   18   67 75 0   1 0 35     8 142
618770 618770 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108002574 1740 Off Campus (Closed after 2016-2017 school year)   Alternative School No Other KG 12 2017   grade_7 9 0 1   0 0     0   4   7 7 0   0   0   2       1.0 14 9 0 1   0 0     0   4   7 7 0   0 0 2     1 14
618791 618791 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108002056 4249 Ridgetop Middle School   Regular School No Middle 06 08 2017   grade_7 143 6 28   0 17     4   43   120 121 0   6   0   71       9.0 241 143 6 28   0 17     4   43   120 121 0   6 0 71     9 241
618825 618825 WA Spokane   school 5301110 32356   Central Valley School District 530111000189 3260 Bowdish Middle School   Regular School No Middle 06 08 2017   grade_7 133 1 7   0 3     0   5   78 71 0   0   8   79       10.0 149 133 1 7   0 3     0   5   78 71 0   0 8 79     10 149
618854 618854 WA Spokane   school 5301110 32356   Central Valley School District 530111000193 3890 Evergreen Middle School   Regular School No Middle 06 08 2017   grade_7 202 3 22   3 6     1   8   127 118 0   5   1   84       10.0 245 202 3 22   3 6     1   8   127 118 0   5 1 84     10 245
618864 618864 WA Spokane   school 5301110 32356   Central Valley School District 530111000195 3573 Greenacres Middle School   Regular School No Middle 06 08 2017   grade_7 216 4 19   0 2     0   15   139 117 0   7   2   78       13.0 256 216 4 19   0 2     0   15   139 117 0   7 2 78     13 256
618868 618868 WA Spokane   school 5301110 32356   Central Valley School District 530111001826 4185 Horizon Middle School   Regular School No Middle 06 08 2017   grade_7 132 0 12   0 3     0   9   90 66 0   1   0   39       15.0 156 132 0 12   0 3     0   9   90 66 0   1 0 39     15 156
618899 618899 WA Spokane   school 5301110 32356   Central Valley School District 530111000198 2776 North Pines Middle School   Regular School No Middle 06 08 2017   grade_7 139 5 17   2 3     9   11   93 93 0   17   5   140       10.0 186 139 5 17   2 3     9   11   93 93 0   17 5 140     10 186
618942 618942 WA Spokane   school 5301110 32356   Central Valley School District 530111003137 1964 Spokane Valley Learning Academy   Regular School No Other KG 12 2017   grade_7 11 0 0   0 0     0   0   4 7 0   0   0   4       0.0 11 11 0 0   0 0     0   0   4 7 0   0 0 4     0 11
618953 618953 WA Spokane   school 5301110 32356   Central Valley School District 530111000188 3465 Summit School   Regular School No Elementary KG 08 2017   grade_7 29 0 1   0 1     0   2   24 9 0   0   0   10       2.0 33 29 0 1   0 1     0   2   24 9 0   0 0 10     2 33
618983 618983 WA Lewis   school 5301140 21401   Centralia School District 530114000205 3240 Centralia Middle School   Regular School No Middle 07 08 2017   grade_7 135 5 70   0 3     0   14   117 110 0   15   8   191       6.0 227 135 5 70   0 3     0   14   117 110 0   15 8 191     6 227

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