enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
535448 535448 WA Yakima   school 5310170 39205   Zillah School District 531017002502 4481 Zillah Middle School   Regular School No 2 07 08 2016   grade_7 48 0 62   6 1     0   3   69 51 0   10   4   71       1.0 120 48 0 62   6 1     0   3   69 51 0   10 4 71     1 120
535419 535419 WA Thurston   school 5310140 34002   Yelm School District 531014001717 2481 Yelm Middle School   Regular School No 2 07 09 2016   grade_7 151 6 34   5 7     1   22   106 120 0   4   1   121       15.0 226 151 6 34   5 7     1   22   106 120 0   4 1 121     15 226
535412 535412 WA Thurston   school 5310140 34002   Yelm School District 531014000134 1627 Yelm Extension School   Alternative Education School No 4 06 12 2016   grade_7 0 0 1   0 0     0   0   0 1 0   0   0   0       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 0     0 1
535395 535395 WA Thurston   school 5310140 34002   Yelm School District 531014003068 5052 Ridgeline Middle School   Regular School No 2 07 09 2016   grade_7 168 2 30   2 0     2   18   116 106 0   4   1   105       11.0 222 168 2 30   2 0     2   18   116 106 0   4 1 105     11 222
535337 535337 WA Yakima   school 5310110 39007   Yakima School District 531011001710 3368 Wilson Middle School   Regular School No 2 06 08 2016   grade_7 71 3 202   0 4     0   7   151 136 0   46   11   247       8.0 287 71 3 202   0 4     0   7   151 136 0   46 11 247     8 287
535325 535325 WA Yakima   school 5310110 39007   Yakima School District 531011001708 2314 Washington Middle School   Regular School No 2 06 08 2016   grade_7 12 2 243   1 1     0   1   132 128 0   115   14   255       4.0 260 12 2 243   1 1     0   1   132 128 0   115 14 255     4 260
535257 535257 WA Yakima   school 5310110 39007   Yakima School District 531011001698 3615 Lewis & Clark Middle School   Regular School No 2 06 08 2016   grade_7 24 2 220   3 2     0   7   124 134 0   84   4   246       8.0 258 24 2 220   3 2     0   7   124 134 0   84 4 246     8 258
535226 535226 WA Yakima   school 5310110 39007   Yakima School District 531011001691 2410 Franklin Middle School   Regular School No 2 06 08 2016   grade_7 64 3 189   3 0     1   12   143 129 0   50   7   241       9.0 272 64 3 189   3 0     1   12   143 129 0   50 7 241     9 272
535214 535214 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No 1 01 08 2016   grade_7 7 0 16   1 0     0   1   13 12 0   4   0   17       1.0 25 7 0 16   1 0     0   1   13 12 0   4 0 17     1 25
535170 535170 WA Cowlitz   school 5310050 8404   Woodland School District 531005003509 5409 Woodland Middle School   Regular School No 2 05 08 2016   grade_7 135 2 29   0 1     0   1   88 80 0   3   5   82       3.0 168 135 2 29   0 1     0   1   88 80 0   3 5 82     3 168
535149 535149 WA Cowlitz   school 5310050 8404   Woodland School District 531005003371 5246 Lewis River Academy   Alternative Education School No 4 KG 12 2016   grade_7 4 0 2   0 0     0   0   2 4 0   0   0   2       0.0 6 4 0 2   0 0     0   0   2 4 0   0 0 2     0 6
535135 535135 WA Klickitat   school 5310020 20094   Wishram School District 531002001680 2605 Wishram High And Elementary Schl   Regular School No 4 PK 12 2016   grade_7 7 0 2   1 0     0   1   8 3 0   0   0   11       0.0 11 7 0 2   1 0     0   1   8 3 0   0 0 11     0 11
535122 535122 WA Grays Harbor   school 5309990 14117   Wishkah Valley School District 530999001679 3375 Wishkah Valley Elementary/High School   Regular School No 4 KG 12 2016   grade_7 21 0 1   0 0     0   0   12 10 0   0   0   11       0.0 22 21 0 1   0 0     0   0   12 10 0   0 0 11     0 22
535091 535091 WA Lewis   school 5309930 21232   Winlock School District 530993002392 4369 Winlock Middle School   Regular School No 2 06 08 2016   grade_7 29 0 17   0 0     0   1   28 19 0   4   4   46       1.0 47 29 0 17   0 0     0   1   28 19 0   4 4 46     1 47
535086 535086 WA Grant   school 5309900 13167   Wilson Creek School District 530990001675 2473 Wilson Creek High   Regular School No 3 07 12 2016   grade_7 12 0 4   1 0     0   0   8 9 0   2   0   12       0.0 17 12 0 4   1 0     0   0   8 9 0   2 0 12     0 17
535070 535070 WA Pacific   school 5309870 25160   Willapa Valley School District 530987001673 2542 Willapa Valley Middle-High   Regular School No 4 06 12 2016   grade_7 11 0 2   1 0     0   3   10 7 0   0   0   8       2.0 17 11 0 2   1 0     0   3   10 7 0   0 0 8     2 17
535054 535054 WA Lincoln   school 5309840 22200   Wilbur School District 530984001668 3289 Wilbur Secondary School   Regular School No 3 07 12 2016   grade_7 18 0 1   7 0     0   2   15 13 0   0   0   16       0.0 28 18 0 1   7 0     0   2   15 13 0   0 0 16     0 28
535037 535037 WA Klickitat   school 5309810 20405   White Salmon Valley School District 530981001666 3394 Wayne M Henkle Middle School   Regular School No 2 07 08 2016   grade_7 56 0 32   0 1     0   2   46 45 0   12   1   54       0.0 91 56 0 32   0 1     0   2   46 45 0   12 1 54     0 91
534990 534990 WA Pierce   school 5309780 27416   White River School District 530978003005 3458 Glacier Middle School   Regular School No 2 06 08 2016   grade_7 208 1 20   4 3     0   19   132 123 0   1   6   90       8.0 255 208 1 20   4 3     0   19   132 123 0   1 6 90     8 255
534967 534967 WA Lewis   school 5309750 21303   White Pass School District 530975001659 2859 White Pass Jr. Sr. High School   Regular School No 3 07 12 2016   grade_7 25 1 1   0 0     0   0   14 13 0   0   2   15       3.0 27 25 1 1   0 0     0   0   14 13 0   0 2 15     3 27
534938 534938 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001653 4040 West Valley Jr High   Regular School No 2 07 08 2016   grade_7 284 4 128   5 10     1   6   209 229 0   20   1   206       11.0 438 284 4 128   5 10     1   6   209 229 0   20 1 206     11 438
534934 534934 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972003340 5221 West Valley High School Freshman Campus (Closed after 2018-2019 school year)   Regular School No 4 07 10 2016   grade_7 1 0 1   1 0     0   0   2 1 0   1   0   3       0.0 3 1 0 1   1 0     0   0   2 1 0   1 0 3     0 3
534930 534930 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001654 3074 West Valley High School   Regular School No 3 07 12 2016   grade_7 0 0 1   0 1     0   0   1 1 0   0   0   2       0.0 2 0 0 1   0 1     0   0   1 1 0   0 0 2     0 2
534889 534889 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969002685 1755 West Valley City School   Alternative Education School No 2 05 08 2016   grade_7 50 1 3   1 0     0   0   22 33 0   0   1   22       2.0 55 50 1 3   1 0     0   0   22 33 0   0 1 22     2 55
534835 534835 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001645 3538 Centennial Middle School   Regular School No 2 06 08 2016   grade_7 161 3 20   0 5     0   17   113 93 0   5   3   107       10.0 206 161 3 20   0 5     0   17   113 93 0   5 3 107     10 206
534811 534811 WA Chelan   school 5309660 4246   Wenatchee School District 530966002550 1742 Valley Academy Of Learning (Closed after 2018-2019 school year)   Alternative Education School No 4 KG 12 2016   grade_7 11 0 1   0 0     0   1   5 8 0   0   0   1       1.0 13 11 0 1   0 0     0   1   5 8 0   0 0 1     1 13
534786 534786 WA Chelan   school 5309660 4246   Wenatchee School District 530966001635 3210 Pioneer Middle School   Regular School No 2 06 08 2016   grade_7 89 0 113   1 1     0   7   104 107 0   43   9   142       10.0 211 89 0 113   1 1     0   7   104 107 0   43 9 142     10 211
534782 534782 WA Chelan   school 5309660 4246   Wenatchee School District 530966001634 3370 Orchard Middle School   Regular School No 2 06 08 2016   grade_7 41 1 72   1 0     0   2   56 61 0   32   5   87       2.0 117 41 1 72   1 0     0   2   56 61 0   32 5 87     2 117
534752 534752 WA Chelan   school 5309660 4246   Wenatchee School District 530966001006 4432 Foothills Middle School   Regular School No 2 06 08 2016   grade_7 114 1 73   1 6     0   5   104 96 0   20   3   109       10.0 200 114 1 73   1 6     0   5   104 96 0   20 3 109     10 200
534740 534740 WA Chelan   school 5309660 4246   Wenatchee School District 530966002706 1802 Chelan County Juvenile Detention Center   Regular School No 4 03 12 2016   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
534724 534724 WA Stevens   school 5309630 33049   Wellpinit School District #49 530963003150 4232 Wellpinit Middle School   Regular School No 2 06 08 2016   grade_7 1 0 4   20 0     0   3   11 17 0   15   7   26       0.0 28 1 0 4   20 0     0   3   11 17 0   15 7 26     0 28
534699 534699 WA Douglas   school 5309600 9209   Waterville School District 530960001628 2162 Waterville High School   Regular School No 4 06 12 2016   grade_7 17 0 1   0 0     0   0   5 13 0   1   3   8       0.0 18 17 0 1   0 0     0   0   5 13 0   1 3 8     0 18
534681 534681 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No 4 PK 12 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
534662 534662 WA Clark   school 5309540 6112   Washougal School District 530954001892 4207 Jemtegaard Middle School   Regular School No 2 06 08 2016   grade_7 134 1 19   1 3     0   15   94 79 0   4   4   81       5.0 173 134 1 19   1 3     0   15   94 79 0   4 4 81     5 173
534634 534634 WA Clark   school 5309540 6112   Washougal School District 530954002709 4549 Canyon Creek Middle School   Regular School No 2 06 08 2016   grade_7 59 1 5   0 4     2   6   40 37 0   0   1   23       3.0 77 59 1 5   0 4     2   6   40 37 0   0 1 23     3 77
534622 534622 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 4 PK 12 2016   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
534610 534610 WA Grant   school 5309510 13146   Warden School District 530951001620 3909 Warden Middle School   Regular School No 2 06 08 2016   grade_7 15 0 46   0 0     0   0   34 27 0   8   8   43       6.0 61 15 0 46   0 0     0   0   34 27 0   8 8 43     6 61
534593 534593 WA Yakima   school 5309480 39207   Wapato School District 530948001615 2131 Wapato Middle School   Regular School No 2 06 08 2016   grade_7 12 0 188   67 2     0   7   146 130 0   62   12   265       0.0 276 12 0 188   67 2     0   7   146 130 0   62 12 265     0 276
534533 534533 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001605 2780 Pioneer Middle School   Regular School No 2 05 08 2016   grade_7 137 2 73   0 6     0   5   101 122 0   15   8   129       9.0 223 137 2 73   0 6     0   5   101 122 0   15 8 129     9 223
534512 534512 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001601 3510 Garrison Middle School   Regular School No 2 06 09 2016   grade_7 94 1 81   1 1     0   8   88 98 0   15   2   118       5.0 186 94 1 81   1 1     0   8   88 98 0   15 2 118     5 186
534464 534464 WA Walla Walla   school 5309390 36401   Waitsburg School District 530939002492 2174 Preston Hall Middle School   Regular School No 2 06 08 2016   grade_7 13 0 2   0 0     0   0   10 5 0   0   0   8       0.0 15 13 0 2   0 0     0   0   10 5 0   0 0 8     0 15
534460 534460 WA Grant   school 5309360 13073   Wahluke School District 530936003264 5144 Wahluke Junior High   Regular School No 2 06 08 2016   grade_7 8 0 163   0 0     0   0   87 84 0   74   7   157       1.0 171 8 0 163   0 0     0   0   87 84 0   74 7 157     1 171
534413 534413 WA Wahkiakum   school 5309330 35200   Wahkiakum School District 530933001593 2893 Julius A Wendt Elementary/John C Thomas Middle School   Regular School No 1 PK 08 2016   grade_7 39 1 1   1 0     0   2   26 18 0   3   2   25       1.0 44 39 1 1   1 0     0   2   26 18 0   3 2 25     1 44
534396 534396 WA King   school 5309300 17402   Vashon Island School District 530930001589 3667 McMurray Middle School   Regular School No 2 06 08 2016   grade_7 99 2 19   0 3     0   9   75 57 0   5   1   37       7.0 132 99 2 19   0 3     0   9   75 57 0   5 1 37     7 132
534391 534391 WA King   school 5309300 17402   Vashon Island School District 530930002720 1822 Family Link   Alternative Education School No 4 KG 12 2016   grade_7 1 0 0   0 1     0   0   0 2 0   0   0   1       0.0 2 1 0 0   0 1     0   0   0 2 0   0 0 1     0 2
534354 534354 WA Clark   school 5309270 6037   Vancouver School District 530927003246 5149 Vancouver Virtual Learning Academy   Alternative Education School No 4 06 12 2016   grade_7 6 0 1   0 0     0   0   5 2 0   1   1   5       0.0 7 6 0 1   0 0     0   0   5 2 0   1 1 5     0 7
534346 534346 WA Clark   school 5309270 6037   Vancouver School District 530927002508 1689 Vancouver School of Arts and Academics   Regular School No 4 06 12 2016   grade_7 77 1 11   2 4     1   6   33 69 0   0   0   22       5.0 102 77 1 11   2 4     1   6   33 69 0   0 0 22     5 102
534338 534338 WA Clark   school 5309270 6037   Vancouver School District 530927003415 5271 Vancouver iTech Preparatory   Regular School No 4 06 12 2016   grade_7 44 1 4   0 4     2   3   38 20 0   1   2   17       4.0 58 44 1 4   0 4     2   3   38 20 0   1 2 17     4 58
534328 534328 WA Clark   school 5309270 6037   Vancouver School District 530927002943 3556 Vancouver Home Connection   Alternative Education School No 4 KG 12 2016   grade_7 26 1 4   0 0     0   0   14 17 0   1   0   14       1.0 31 26 1 4   0 0     0   0   14 17 0   1 0 14     1 31
534311 534311 WA Clark   school 5309270 6037   Vancouver School District 530927002944 4591 Thomas Jefferson Middle School   Regular School No 2 06 08 2016   grade_7 208 4 30   0 9     1   20   132 140 0   9   0   85       12.0 272 208 4 30   0 9     1   20   132 140 0   9 0 85     12 272
534256 534256 WA Clark   school 5309270 6037   Vancouver School District 530927001577 3146 Mcloughlin Middle School   Regular School No 2 06 08 2016   grade_7 105 8 151   0 7     21   17   167 142 0   72   15   266       8.0 309 105 8 151   0 7     21   17   167 142 0   72 15 266     8 309
534225 534225 WA Clark   school 5309270 6037   Vancouver School District 530927001570 3543 Jason Lee Middle School   Regular School No 2 06 08 2016   grade_7 113 5 37   1 10     0   10   88 88 0   12   4   103       6.0 176 113 5 37   1 10     0   10   88 88 0   12 4 103     6 176
534179 534179 WA Clark   school 5309270 6037   Vancouver School District 530927001562 3902 Gaiser Middle School   Regular School No 2 05 08 2016   grade_7 162 19 81   1 9     6   17   141 154 0   18   11   189       6.0 295 162 19 81   1 9     6   17   141 154 0   18 11 189     6 295
534162 534162 WA Clark   school 5309270 6037   Vancouver School District 530927002408 1574 Fir Grove Childrens Center   Special Education School No 4 KG 12 2016   grade_7 8 0 0   0 0     0   0   8 0 0   0   1   7       0.0 8 8 0 0   0 0     0   0   8 0 0   0 1 7     0 8
534131 534131 WA Clark   school 5309270 6037   Vancouver School District 530927002018 4503 Discovery Middle School   Regular School No 2 06 08 2016   grade_7 94 14 79   1 2     5   13   103 105 0   28   12   164       6.0 208 94 14 79   1 2     5   13   103 105 0   28 12 164     6 208
534107 534107 WA Clark   school 5309270 6037   Vancouver School District 530927000578 4406 Alki Middle School   Regular School No 2 06 08 2016   grade_7 176 1 25   0 9     1   25   122 115 0   7   0   63       4.0 237 176 1 25   0 9     1   25   122 115 0   7 0 63     4 237
534100 534100 WA Stevens   school 5309240 33070   Valley School District 530924001555 2405 Valley School   Regular School No 1 KG 08 2016   grade_7 25 0 3   0 0     0   3   17 14 0   0   1   25       0.0 31 25 0 3   0 0     0   3   17 14 0   0 1 25     0 31
534083 534083 WA Stevens   school 5309240 33070   Valley School District 530924003107 1932 Columbia Virtual Academy   Alternative Education School No 1 KG 08 2016   grade_7 47 3 4   3 0     0   4   27 34 0   1   1   0       0.0 61 47 3 4   3 0     0   4   27 34 0   1 1 0     0 61
534074 534074 WA Pierce   school 5309180 27083   University Place School District 530918002838 1790 University Place Special Educ (Closed after 2016-2017 school year)   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
534054 534054 WA Pierce   school 5309180 27083   University Place School District 530918001550 3296 Narrows View Intermediate   Regular School No 2 05 07 2016   grade_7 128 13 40   2 19     0   29   123 108 0   4   4   97       10.0 231 128 13 40   2 19     0   29   123 108 0   4 4 97     10 231
534042 534042 WA Pierce   school 5309180 27083   University Place School District 530918002383 4325 Drum Intermediate   Regular School No 2 05 07 2016   grade_7 103 19 33   0 14     1   41   95 116 0   9   4   87       7.0 211 103 19 33   0 14     1   41   95 116 0   9 4 87     7 211
534032 534032 WA Pierce   school 5309180 27083   University Place School District 530918001548 3179 Curtis Junior High   Regular School No 2 06 09 2016   grade_7 0 1 0   0 0     0   0   0 1 0   0   0   0       0.0 1 0 1 0   0 0     0   0   0 1 0   0 0 0     0 1
534018 534018 WA Yakima   school 5309150 39002   Union Gap School District 530915002382 2714 Union Gap School   Regular School No 1 PK 08 2016   grade_7 10 0 53   0 0     0   3   31 35 0   7   0   59       2.0 66 10 0 53   0 0     0   3   31 35 0   7 0 59     2 66
534009 534009 WA Thurston   school 5309100 34033   Tumwater School District 530910001545 3612 Tumwater Middle School   Regular School No 2 07 08 2016   grade_7 152 4 25   4 12     2   31   105 125 0   2   4   77       7.0 230 152 4 25   4 12     2   31   105 125 0   2 4 77     7 230
533997 533997 WA Thurston   school 5309100 34033   Tumwater School District 530910001544 3362 Tumwater High School   Regular School No 3 07 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
533956 533956 WA Thurston   school 5309100 34033   Tumwater School District 530910001734 4452 George Washington Bush Middle Sch   Regular School No 2 07 08 2016   grade_7 197 6 26   2 5     3   18   134 123 0   1   3   83       4.0 257 197 6 26   2 5     3   18   134 123 0   1 3 83     4 257
533910 533910 WA King   school 5308130 17406   Tukwila School District 530813001342 2564 Showalter Middle School   Regular School No 2 06 08 2016   grade_7 29 43 70   3 77     10   9   132 109 0   71   21   198       3.0 241 29 43 70   3 77     10   9   132 109 0   71 21 198     3 241
533889 533889 WA Klickitat   school 5309060 20400   Trout Lake School District 530906001539 2676 Trout Lake School   Regular School No 4 05 12 2016   grade_7 16 0 8   1 1     0   2   13 15 0   3   1   0       0.0 28 16 0 8   1 1     0   2   13 15 0   3 1 0     0 28
533873 533873 WA Cowlitz   school 5309030 8130   Toutle Lake School District 530903001538 2560 Toutle Lake High School   Regular School No 3 07 12 2016   grade_7 47 1 3   0 0     0   1   26 26 0   0   2   21       2.0 52 47 1 3   0 0     0   1   26 26 0   0 2 21     2 52
533854 533854 WA Walla Walla   school 5309000 36300   Touchet School District 530900001536 2160 Touchet Elem & High School   Regular School No 4 PK 12 2016   grade_7 9 0 6   0 0     0   0   7 8 0   1   0   7       1.0 15 9 0 6   0 0     0   0   7 8 0   1 0 7     1 15
533833 533833 WA Yakima   school 5308970 39202   Toppenish School District 530897001535 2264 Toppenish Middle School   Regular School No 2 06 08 2016   grade_7 4 0 255   43 0     0   3   169 136 0   107   14   263       6.0 305 4 0 255   43 0     0   3   169 136 0   107 14 263     6 305
533822 533822 WA Yakima   school 5308970 39202   Toppenish School District 530897003385 5262 Northwest Allprep   Regular School No 4 KG 12 2016   grade_7 9 1 0   0 0     0   0   3 7 0   0   0   5       0.0 10 9 1 0   0 0     0   0   3 7 0   0 0 5     0 10
533790 533790 WA Yakima   school 5308970 39202   Toppenish School District 530897002378 1508 Computer Academy Toppenish High School   Alternative Education School No 4 06 12 2016   grade_7 0 0 0   1 0     0   0   0 1 0   0   0   1       0.0 1 0 0 0   1 0     0   0   0 1 0   0 0 1     0 1
533784 533784 WA Okanogan   school 5308940 24404   Tonasket School District 530894001647 4196 Tonasket Middle School   Regular School No 2 06 08 2016   grade_7 45 0 34   0 2     0   0   45 36 0   4   2   57       0.0 81 45 0 34   0 2     0   0   45 36 0   4 2 57     0 81
533767 533767 WA Lewis   school 5308910 21237   Toledo School District 530891001528 3977 Toledo Middle School   Regular School No 2 06 08 2016   grade_7 45 0 6   0 0     1   6   28 30 0   2   6   33       1.0 58 45 0 6   0 0     1   6   28 30 0   2 6 33     1 58
533740 533740 WA Kittitas   school 5308850 19400   Thorp School District 530885001525 2514 Thorp Elem & Jr Sr High   Regular School No 4 PK 12 2016   grade_7 11 0 1   0 0     0   0   6 6 0   0   0   6       1.0 12 11 0 1   0 0     0   0   6 6 0   0 0 6     1 12
533728 533728 WA Thurston   school 5308820 34402   Tenino School District 530882001523 3795 Tenino Middle School   Regular School No 2 04 08 2016   grade_7 67 1 4   1 1     0   0   41 33 0   1   0   41       0.0 74 67 1 4   1 1     0   0   41 33 0   1 0 41     0 74
533707 533707 WA Whitman   school 5308790 38265   Tekoa School District 530879001521 3418 Tekoa High School   Regular School No 3 07 12 2016   grade_7 20 0 0   3 0     0   0   8 15 0   0   0   13       0.0 23 20 0 0   3 0     0   0   8 15 0   0 0 13     0 23
533682 533682 WA King   school 5308760 17409   Tahoma School District 530876002979 3341 Summit Trail Middle School   Regular School No 2 06 08 2016   grade_7 256 2 28   1 10     2   26   156 169 0   2   1   49       22.0 325 256 2 28   1 10     2   26   156 169 0   2 1 49     22 325
533661 533661 WA King   school 5308760 17409   Tahoma School District 530876001515 3937 Maple View Middle School   Regular School No 2 06 07 2016   grade_7 252 3 44   2 25     3   29   179 179 0   4   1   65       28.0 358 252 3 44   2 25     3   29   179 179 0   4 1 65     28 358
533632 533632 WA Grays Harbor   school 5308730 14077   Taholah School District 530873002956 5032 Taholah Elementary & Middle School   Regular School No 1 PK 08 2016   grade_7 0 0 4   11 0     0   1   10 6 0   0   4   12       0.0 16 0 0 4   11 0     0   1   10 6 0   0 4 12     0 16
533594 533594 WA Pierce   school 5308700 27010   Tacoma School District 530870001507 3448 Truman   Regular School No 2 06 08 2016   grade_7 144 35 42   2 27     6   7   139 124 0   13   13   126       5.0 263 144 35 42   2 27     6   7   139 124 0   13 13 126     5 263
533589 533589 WA Pierce   school 5308700 27010   Tacoma School District 530870002177 4283 The School at Pearl Youth Residence   Special Education School No 4 06 12 2016   grade_7 2 0 0   0 0     0   0   1 1 0   0   0   2       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 2     0 2
533573 533573 WA Pierce   school 5308700 27010   Tacoma School District 530870001504 2359 Stewart   Regular School No 2 06 08 2016   grade_7 40 19 18   3 13     1   2   53 43 0   4   7   56       3.0 96 40 19 18   3 13     1   2   53 43 0   4 7 56     3 96
533552 533552 WA Pierce   school 5308700 27010   Tacoma School District 530870003275 5192 Special Services   Alternative Education School No 4 PK 12 2016   grade_7 1 3 0   0 0     0   0   4 0 0   0   1   2       0.0 4 1 3 0   0 0     0   0   4 0 0   0 1 2     0 4
533503 533503 WA Pierce   school 5308700 27010   Tacoma School District 530870002171 2039 Remann Hall Juvenile Detention Center   Regular School No 4 05 12 2016   grade_7 0 1 0   1 0     0   0   2 0 0   0   0   2       0.0 2 0 1 0   1 0     0   0   2 0 0   0 0 2     0 2
533463 533463 WA Pierce   school 5308700 27010   Tacoma School District 530870001487 3244 Meeker   Regular School No 2 06 08 2016   grade_7 134 19 20   3 22     4   18   103 117 0   8   2   65       7.0 220 134 19 20   3 22     4   18   103 117 0   8 2 65     7 220
533451 533451 WA Pierce   school 5308700 27010   Tacoma School District 530870001483 2376 Mason   Regular School No 2 06 08 2016   grade_7 208 27 24   3 18     3   8   143 148 0   4   5   92       9.0 291 208 27 24   3 18     3   8   143 148 0   4 5 92     9 291
533382 533382 WA Pierce   school 5308700 27010   Tacoma School District 530870001473 2338 Jason Lee   Regular School No 2 06 08 2016   grade_7 89 69 24   4 8     4   8   103 103 0   4   12   142       3.0 206 89 69 24   4 8     4   8   103 103 0   4 12 142     3 206
533370 533370 WA Pierce   school 5308700 27010   Tacoma School District 530870001471 2377 Gray   Regular School No 2 06 08 2016   grade_7 58 49 54   1 21     14   8   99 106 0   22   14   148       2.0 205 58 49 54   1 21     14   8   99 106 0   22 14 148     2 205
533337 533337 WA Pierce   school 5308700 27010   Tacoma School District 530870003299 5170 First Creek Middle School   Regular School No 2 06 08 2016   grade_7 40 63 60   7 44     7   11   119 113 0   21   7   178       18.0 232 40 63 60   7 44     7   11   119 113 0   21 7 178     18 232
533279 533279 WA Pierce   school 5308700 27010   Tacoma School District 530870001458 3397 Bryant   Regular School No 1 PK 08 2016   grade_7 17 6 5   2 2     1   1   17 17 0   1   0   19       0.0 34 17 6 5   2 2     1   1   17 17 0   1 0 19     0 34
533239 533239 WA Pierce   school 5308700 27010   Tacoma School District 530870001454 3054 Baker   Regular School No 2 06 08 2016   grade_7 41 48 69   3 45     16   12   124 110 0   24   15   153       9.0 234 41 48 69   3 45     16   12   124 110 0   24 15 153     9 234
533227 533227 WA Pierce   school 5308700 27010   Tacoma School District 530870003155 4575 Angelo Giaudrone Middle School   Regular School No 2 06 08 2016   grade_7 73 65 42   1 23     1   10   108 107 0   15   22   141       6.0 215 73 65 42   1 23     1   10   108 107 0   15 22 141     6 215
533222 533222 WA Kitsap   school 5300328 18902   Suquamish Tribal Education Department 530032803493 5319 Chief Kitsap Academy   Regular School No 4 KG 12 2016   grade_7 3 0 1   3 0     0   8   6 9 0   5   1   9       0.0 15 3 0 1   3 0     0   8   6 9 0   5 1 9     0 15
533199 533199 WA Yakima   school 5308670 39201   Sunnyside School District 530867003037 5049 Sierra Vista Middle School   Regular School No 2 06 08 2016   grade_7 10 0 220   0 0     0   5   124 111 0   54   16   208       4.0 235 10 0 220   0 0     0   5   124 111 0   54 16 208     4 235
533176 533176 WA Yakima   school 5308670 39201   Sunnyside School District 530867001451 3313 Harrison Middle School   Regular School No 2 06 08 2016   grade_7 20 1 237   0 0     0   2   130 130 0   52   15   226       0.0 260 20 1 237   0 0     0   2   130 130 0   52 15 226     0 260
533155 533155 WA Pierce   school 5308610 27320   Sumner School District 530861001447 3499 Sumner Middle School   Regular School No 2 06 08 2016   grade_7 153 3 46   1 5     0   25   110 123 0   12   4   100       7.0 233 153 3 46   1 5     0   25   110 123 0   12 4 100     7 233
533145 533145 WA Pierce   school 5308610 27320   Sumner School District 530861002580 4502 Mountain View Middle School   Regular School No 2 06 08 2016   grade_7 139 1 23   0 2     2   24   87 104 0   3   4   69       9.0 191 139 1 23   0 2     2   24   87 104 0   3 4 69     9 191
533125 533125 WA Pierce   school 5308610 27320   Sumner School District 530861001808 4132 Lakeridge Middle School   Regular School No 2 06 08 2016   grade_7 174 0 19   0 4     1   13   97 114 0   0   8   78       9.0 211 174 0 19   0 4     1   13   97 114 0   0 8 78     9 211

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