enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
632796 632796 WA Yakima   school 5310170 39205   Zillah School District 531017002502 4481 Zillah Middle School   Regular School No Middle 07 08 2017   grade_7 45 0 56   7 0     0   5   69 44 0   14   2   71       2.0 113 45 0 56   7 0     0   5   69 44 0   14 2 71     2 113
632766 632766 WA Thurston   school 5310140 34002   Yelm School District 531014001717 2481 Yelm Middle School   Regular School No Other 07 09 2017   grade_7 152 1 32   2 1     3   24   114 101 0   4   4   110       13.0 215 152 1 32   2 1     3   24   114 101 0   4 4 110     13 215
632752 632752 WA Thurston   school 5310140 34002   Yelm School District 531014001715 3848 Southworth Elementary   Regular School No Elementary KG 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
632742 632742 WA Thurston   school 5310140 34002   Yelm School District 531014003068 5052 Ridgeline Middle School   Regular School No Other 07 09 2017   grade_7 148 0 32   7 1     1   11   116 84 0   1   1   83       10.0 200 148 0 32   7 1     1   11   116 84 0   1 1 83     10 200
632693 632693 WA Yakima   school 5310110 39007   Yakima School District 531011003263 5153 Yakima Online   Alternative School No Other 06 12 2017   grade_7 1 0 1   0 0     0   0   1 1 0   0   0   1       0.0 2 1 0 1   0 0     0   0   1 1 0   0 0 1     0 2
632687 632687 WA Yakima   school 5310110 39007   Yakima School District 531011001710 3368 Wilson Middle School   Regular School No Middle 06 08 2017   grade_7 70 2 204   6 2     0   13   144 153 0   56   3   213       8.0 297 70 2 204   6 2     0   13   144 153 0   56 3 213     8 297
632675 632675 WA Yakima   school 5310110 39007   Yakima School District 531011001708 2314 Washington Middle School   Regular School No Middle 06 08 2017   grade_7 7 2 229   4 0     0   1   120 123 0   123   8   219       8.0 243 7 2 229   4 0     0   1   120 123 0   123 8 219     8 243
632608 632608 WA Yakima   school 5310110 39007   Yakima School District 531011001698 3615 Lewis & Clark Middle School   Regular School No Middle 06 08 2017   grade_7 39 1 242   2 0     2   4   141 149 0   99   6   250       5.0 290 39 1 242   2 0     2   4   141 149 0   99 6 250     5 290
632603 632603 WA Yakima   school 5310110 39007   Yakima School District 531011002932 4092 Juvenile Detention Center   Regular School No Other 05 12 2017   grade_7 0 0 1   0 0     0   0   1 0 0   1   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   1 0 1     0 1
632574 632574 WA Yakima   school 5310110 39007   Yakima School District 531011001691 2410 Franklin Middle School   Regular School No Middle 06 08 2017   grade_7 52 1 221   3 0     0   13   148 142 0   64   11   240       9.0 290 52 1 221   3 0     0   13   148 142 0   64 11 240     9 290
632562 632562 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2017   grade_7 11 0 16   0 0     0   0   10 17 0   4   0   14       1.0 27 11 0 16   0 0     0   0   10 17 0   4 0 14     1 27
632552 632552 WA Yakima   school 5310110 39007   Yakima School District 531011001689 2116 Davis High School   Regular School No High 09 12 2017   grade_7 0 0 2   0 0     0   0   1 1 0   1   0   1       0.0 2 0 0 2   0 0     0   0   1 1 0   1 0 1     0 2
632519 632519 WA Cowlitz   school 5310050 8404   Woodland School District 531005003509 5409 Woodland Middle School   Regular School No Middle 05 08 2017   grade_7 130 3 29   0 0     0   8   99 71 0   7   3   87       0.0 170 130 3 29   0 0     0   8   99 71 0   7 3 87     0 170
632498 632498 WA Cowlitz   school 5310050 8404   Woodland School District 531005003371 5246 Lewis River Academy   Alternative School No Other KG 12 2017   grade_7 5 0 1   0 1     0   1   5 3 0   0   0   1       0.0 8 5 0 1   0 1     0   1   5 3 0   0 0 1     0 8
632483 632483 WA Klickitat   school 5310020 20094   Wishram School District 531002001680 2605 Wishram High And Elementary Schl   Regular School No Other PK 12 2017   grade_7 4 0 1   0 0     0   2   5 2 0   0   0   6       2.0 7 4 0 1   0 0     0   2   5 2 0   0 0 6     2 7
632469 632469 WA Grays Harbor   school 5309990 14117   Wishkah Valley School District 530999001679 3375 Wishkah Valley Elementary/High School   Regular School No Other KG 12 2017   grade_7 16 0 0   0 0     0   0   10 6 0   0   0   10       0.0 16 16 0 0   0 0     0   0   10 6 0   0 0 10     0 16
632440 632440 WA Lewis   school 5309930 21232   Winlock School District 530993002392 4369 Winlock Middle School   Regular School No Middle 06 08 2017   grade_7 30 0 13   0 1     0   3   21 26 0   5   2   41       1.0 47 30 0 13   0 1     0   3   21 26 0   5 2 41     1 47
632435 632435 WA Grant   school 5309900 13167   Wilson Creek School District 530990001675 2473 Wilson Creek High   Regular School No High 07 12 2017   grade_7 10 0 2   0 0     0   0   7 5 0   0   0   7       0.0 12 10 0 2   0 0     0   0   7 5 0   0 0 7     0 12
632419 632419 WA Pacific   school 5309870 25160   Willapa Valley School District 530987001673 2542 Willapa Valley Middle-High   Regular School No Other 06 12 2017   grade_7 32 0 5   0 0     0   2   21 18 0   0   1   21       0.0 39 32 0 5   0 0     0   2   21 18 0   0 1 21     0 39
632403 632403 WA Lincoln   school 5309840 22200   Wilbur School District 530984001668 3289 Wilbur Secondary School   Regular School No High 07 12 2017   grade_7 17 0 3   2 0     0   1   9 14 0   0   1   9       0.0 23 17 0 3   2 0     0   1   9 14 0   0 1 9     0 23
632385 632385 WA Klickitat   school 5309810 20405   White Salmon Valley School District 530981001666 3394 Wayne M Henkle Middle School   Regular School No Middle 07 08 2017   grade_7 63 0 35   0 0     0   1   57 42 0   15   2   47       4.0 99 63 0 35   0 0     0   1   57 42 0   15 2 47     4 99
632351 632351 WA Pierce   school 5309780 27416   White River School District 530978003544 5390 White River Homeschool   Regular School No Other KG 12 2017   grade_7 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
632333 632333 WA Pierce   school 5309780 27416   White River School District 530978003005 3458 Glacier Middle School   Regular School No Middle 06 08 2017   grade_7 219 1 30   1 1     0   8   130 130 0   4   3   80       17.0 260 219 1 30   1 1     0   8   130 130 0   4 3 80     17 260
632310 632310 WA Lewis   school 5309750 21303   White Pass School District 530975001659 2859 White Pass Jr. Sr. High School   Regular School No High 07 12 2017   grade_7 24 0 3   0 0     0   2   16 13 0   0   4   17       0.0 29 24 0 3   0 0     0   2   16 13 0   0 4 17     0 29
632283 632283 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972002545 4506 West Valley Middle School   Regular School No Middle 05 06 2017   grade_7 3 0 0   0 0     0   0   3 0 0   0   0   1       0.0 3 3 0 0   0 0     0   0   3 0 0   0 0 1     0 3
632278 632278 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001653 4040 West Valley Jr High   Regular School No Middle 07 08 2017   grade_7 260 3 116   8 8     0   12   221 186 0   24   4   197       18.0 407 260 3 116   8 8     0   12   221 186 0   24 4 197     18 407
632274 632274 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 Other 09 09 2017   grade_7 1 0 1   0 0     0   0   2 0 0   0   0   2       0.0 2 1 0 1   0 0     0   0   2 0 0   0 0 2     0 2
632222 632222 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969002685 1755 West Valley City School   Alternative School No Middle 05 08 2017   grade_7 49 0 6   0 0     0   6   30 31 0   0   0   22       2.0 61 49 0 6   0 0     0   6   30 31 0   0 0 22     2 61
632173 632173 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001645 3538 Centennial Middle School   Regular School No Middle 06 08 2017   grade_7 165 6 20   4 2     0   17   109 105 0   5   8   122       9.0 214 165 6 20   4 2     0   17   109 105 0   5 8 122     9 214
632144 632144 WA Chelan   school 5309660 4246   Wenatchee School District 530966002550 1742 Valley Academy Of Learning (Closed after 2018-2019 school year)   Alternative School No Other KG 12 2017   grade_7 7 0 0   0 0     0   2   5 4 0   0   1   1       1.0 9 7 0 0   0 0     0   2   5 4 0   0 1 1     1 9
632121 632121 WA Chelan   school 5309660 4246   Wenatchee School District 530966001635 3210 Pioneer Middle School   Regular School No Middle 06 08 2017   grade_7 98 0 103   1 1     0   4   107 100 0   46   9   126       12.0 207 98 0 103   1 1     0   4   107 100 0   46 9 126     12 207
632117 632117 WA Chelan   school 5309660 4246   Wenatchee School District 530966001634 3370 Orchard Middle School   Regular School No Middle 06 08 2017   grade_7 55 0 86   0 1     0   4   73 73 0   49   6   107       12.0 146 55 0 86   0 1     0   4   73 73 0   49 6 107     12 146
632087 632087 WA Chelan   school 5309660 4246   Wenatchee School District 530966001006 4432 Foothills Middle School   Regular School No Middle 06 08 2017   grade_7 120 1 94   0 0     0   3   126 92 0   36   8   110       13.0 218 120 1 94   0 0     0   3   126 92 0   36 8 110     13 218
632060 632060 WA Stevens   school 5309630 33049   Wellpinit School District #49 530963003150 4232 Wellpinit Middle School   Regular School No Middle 06 08 2017   grade_7 1 0 1   14 0     0   5   12 9 0   9   5   19       0.0 21 1 0 1   14 0     0   5   12 9 0   9 5 19     0 21
632035 632035 WA Douglas   school 5309600 9209   Waterville School District 530960001628 2162 Waterville High School   Regular School No Other 06 12 2017   grade_7 10 0 1   1 1     0   0   6 7 0   0   1   7       0.0 13 10 0 1   1 1     0   0   6 7 0   0 1 7     0 13
632016 632016 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other KG 12 2017   grade_7 8 0 1   0 0     0   0   7 2 0   0   1   6       0.0 9 8 0 1   0 0     0   0   7 2 0   0 1 6     0 9
631997 631997 WA Clark   school 5309540 6112   Washougal School District 530954001892 4207 Jemtegaard Middle School   Regular School No Middle 06 08 2017   grade_7 113 1 18   0 2     1   10   67 78 0   5   7   67       6.0 145 113 1 18   0 2     1   10   67 78 0   5 7 67     6 145
631967 631967 WA Clark   school 5309540 6112   Washougal School District 530954002709 4549 Canyon Creek Middle School   Regular School No Middle 06 08 2017   grade_7 74 0 4   1 1     0   3   47 36 0   0   1   16       7.0 83 74 0 4   1 1     0   3   47 36 0   0 1 16     7 83
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
631943 631943 WA Grant   school 5309510 13146   Warden School District 530951001620 3909 Warden Middle School   Regular School No Middle 06 08 2017   grade_7 15 1 57   0 0     0   0   30 43 0   21   10   65       0.0 73 15 1 57   0 0     0   0   30 43 0   21 10 65     0 73
631925 631925 WA Yakima   school 5309480 39207   Wapato School District 530948001615 2131 Wapato Middle School   Regular School No Middle 06 08 2017   grade_7 8 0 178   58 8     0   8   126 134 0   79   30   246       0.0 260 8 0 178   58 8     0   8   126 134 0   79 30 246     0 260
631865 631865 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001605 2780 Pioneer Middle School   Regular School No Middle 06 08 2017   grade_7 118 1 87   0 3     2   9   108 112 0   21   6   134       11.0 220 118 1 87   0 3     2   9   108 112 0   21 6 134     11 220
631859 631859 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001607 4071 Lincoln High School   Alternative School No High 09 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
631844 631844 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001601 3510 Garrison Middle School   Regular School No Middle 06 08 2017   grade_7 103 2 81   0 3     3   4   105 91 0   25   6   102       4.0 196 103 2 81   0 3     3   4   105 91 0   25 6 102     4 196
631798 631798 WA Walla Walla   school 5309390 36401   Waitsburg School District 530939002492 2174 Preston Hall Middle School   Regular School No Middle 06 08 2017   grade_7 14 0 2   0 0     0   0   6 10 0   0   0   10       0.0 16 14 0 2   0 0     0   0   6 10 0   0 0 10     0 16
631793 631793 WA Grant   school 5309360 13073   Wahluke School District 530936003264 5144 Wahluke Junior High   Regular School No Middle 06 08 2017   grade_7 7 0 168   1 0     0   0   94 82 0   82   2   173       3.0 176 7 0 168   1 0     0   0   94 82 0   82 2 173     3 176
631747 631747 WA Wahkiakum   school 5309330 35200   Wahkiakum School District 530933001593 2893 Julius A Wendt Elementary/John C Thomas Middle School   Regular School No Elementary KG 08 2017   grade_7 32 0 3   0 0     0   0   19 16 0   2   2   20       2.0 35 32 0 3   0 0     0   0   19 16 0   2 2 20     2 35
631729 631729 WA King   school 5309300 17402   Vashon Island School District 530930001589 3667 McMurray Middle School   Regular School No Middle 06 08 2017   grade_7 98 0 11   0 1     1   13   75 49 0   3   0   18       8.0 124 98 0 11   0 1     1   13   75 49 0   3 0 18     8 124
631723 631723 WA King   school 5309300 17402   Vashon Island School District 530930002720 1822 Family Link   Alternative School No Other KG 12 2017   grade_7 3 0 0   0 0     0   0   1 2 0   0   0   1       0.0 3 3 0 0   0 0     0   0   1 2 0   0 0 1     0 3
631685 631685 WA Clark   school 5309270 6037   Vancouver School District 530927003246 5149 Vancouver Virtual Learning Academy   Alternative School No Other 06 12 2017   grade_7 8 0 1   0 0     0   1   6 4 0   0   0   7       1.0 10 8 0 1   0 0     0   1   6 4 0   0 0 7     1 10
631677 631677 WA Clark   school 5309270 6037   Vancouver School District 530927002508 1689 Vancouver School of Arts and Academics   Regular School No Other 06 12 2017   grade_7 64 1 13   0 3     2   7   32 58 0   0   1   22       3.0 90 64 1 13   0 3     2   7   32 58 0   0 1 22     3 90
631669 631669 WA Clark   school 5309270 6037   Vancouver School District 530927003415 5271 Vancouver iTech Preparatory   Regular School No Other 06 12 2017   grade_7 42 0 10   1 0     1   6   45 15 0   0   0   24       0.0 60 42 0 10   1 0     1   6   45 15 0   0 0 24     0 60
631659 631659 WA Clark   school 5309270 6037   Vancouver School District 530927002943 3556 Vancouver Home Connection   Alternative School No Other KG 12 2017   grade_7 23 0 1   0 0     0   0   13 11 0   2   1   11       1.0 24 23 0 1   0 0     0   0   13 11 0   2 1 11     1 24
631641 631641 WA Clark   school 5309270 6037   Vancouver School District 530927002944 4591 Thomas Jefferson Middle School   Regular School No Middle 06 08 2017   grade_7 211 6 40   2 7     1   11   150 128 0   9   7   77       12.0 278 211 6 40   2 7     1   11   150 128 0   9 7 77     12 278
631587 631587 WA Clark   school 5309270 6037   Vancouver School District 530927001577 3146 Mcloughlin Middle School   Regular School No Middle 06 08 2017   grade_7 108 11 170   1 13     18   29   161 189 0   82   21   286       11.0 350 108 11 170   1 13     18   29   161 189 0   82 21 286     11 350
631556 631556 WA Clark   school 5309270 6037   Vancouver School District 530927001570 3543 Jason Lee Middle School   Regular School No Middle 06 08 2017   grade_7 129 6 53   2 14     2   25   123 108 0   20   4   112       8.0 231 129 6 53   2 14     2   25   123 108 0   20 4 112     8 231
631507 631507 WA Clark   school 5309270 6037   Vancouver School District 530927001562 3902 Gaiser Middle School   Regular School No Middle 06 08 2017   grade_7 159 15 99   3 5     8   20   149 160 0   37   17   188       8.0 309 159 15 99   3 5     8   20   149 160 0   37 17 188     8 309
631490 631490 WA Clark   school 5309270 6037   Vancouver School District 530927002408 1574 Fir Grove Childrens Center   Special Education School No Other KG 12 2017   grade_7 2 0 2   0 0     0   0   3 1 0   0   0   2       0.0 4 2 0 2   0 0     0   0   3 1 0   0 0 2     0 4
631463 631463 WA Clark   school 5309270 6037   Vancouver School District 530927002018 4503 Discovery Middle School   Regular School No Middle 06 08 2017   grade_7 83 7 74   0 1     8   17   90 100 0   25   11   155       4.0 190 83 7 74   0 1     8   17   90 100 0   25 11 155     4 190
631440 631440 WA Clark   school 5309270 6037   Vancouver School District 530927000578 4406 Alki Middle School   Regular School No Middle 06 08 2017   grade_7 170 3 18   1 11     2   14   114 105 0   5   2   68       12.0 219 170 3 18   1 11     2   14   114 105 0   5 2 68     12 219
631435 631435 WA Stevens   school 5309240 33070   Valley School District 530924001555 2405 Valley School   Regular School No Elementary KG 08 2017   grade_7 9 0 2   0 0     0   2   5 8 0   0   0   11       0.0 13 9 0 2   0 0     0   2   5 8 0   0 0 11     0 13
631418 631418 WA Stevens   school 5309240 33070   Valley School District 530924003107 1932 Columbia Virtual Academy   Alternative School No Elementary KG 08 2017   grade_7 52 1 10   0 4     0   4   34 37 0   5   5   2       0.0 71 52 1 10   0 4     0   4   34 37 0   5 5 2     0 71
631394 631394 WA Pierce   school 5309180 27083   University Place School District 530918001550 3296 Narrows View Intermediate   Regular School No Middle 05 07 2017   grade_7 123 17 33   0 23     1   40   130 107 0   11   4   101       19.0 237 123 17 33   0 23     1   40   130 107 0   11 4 101     19 237
631381 631381 WA Pierce   school 5309180 27083   University Place School District 530918002383 4325 Drum Intermediate   Regular School No Middle 05 07 2017   grade_7 105 18 30   2 18     2   40   98 117 0   9   5   88       13.0 215 105 18 30   2 18     2   40   98 117 0   9 5 88     13 215
631375 631375 WA Pierce   school 5309180 27083   University Place School District 530918001549 3600 Curtis Senior High   Regular School No High 10 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
631354 631354 WA Yakima   school 5309150 39002   Union Gap School District 530915002382 2714 Union Gap School   Regular School No Elementary PK 08 2017   grade_7 11 0 54   1 1     0   1   42 26 0   14   0   62       0.0 68 11 0 54   1 1     0   1   42 26 0   14 0 62     0 68
631345 631345 WA Thurston   school 5309100 34033   Tumwater School District 530910001545 3612 Tumwater Middle School   Regular School No Middle 07 08 2017   grade_7 166 4 24   3 9     3   28   110 127 0   7   6   76       10.0 237 166 4 24   3 9     3   28   110 127 0   7 6 76     10 237
631287 631287 WA Thurston   school 5309100 34033   Tumwater School District 530910001734 4452 George Washington Bush Middle Sch   Regular School No Middle 07 08 2017   grade_7 215 2 23   0 4     1   20   130 135 0   3   4   89       7.0 265 215 2 23   0 4     1   20   130 135 0   3 4 89     7 265
631242 631242 WA King   school 5308130 17406   Tukwila School District 530813001342 2564 Showalter Middle School   Regular School No Middle 06 08 2017   grade_7 28 29 61   1 60     5   14   100 98 0   61   20   151       6.0 198 28 29 61   1 60     5   14   100 98 0   61 20 151     6 198
631223 631223 WA Klickitat   school 5309060 20400   Trout Lake School District 530906001539 2676 Trout Lake School   Regular School No Other 05 12 2017   grade_7 19 0 2   0 1     0   1   7 16 0   1   0   0       0.0 23 19 0 2   0 1     0   1   7 16 0   1 0 0     0 23
631207 631207 WA Cowlitz   school 5309030 8130   Toutle Lake School District 530903001538 2560 Toutle Lake High School   Regular School No High 07 12 2017   grade_7 44 0 2   1 0     0   0   26 21 0   0   0   16       2.0 47 44 0 2   1 0     0   0   26 21 0   0 0 16     2 47
631189 631189 WA Walla Walla   school 5309000 36300   Touchet School District 530900001536 2160 Touchet Elem & High School   Regular School No Other KG 12 2017   grade_7 11 0 8   0 0     0   0   11 8 0   3   2   14       1.0 19 11 0 8   0 0     0   0   11 8 0   3 2 14     1 19
631168 631168 WA Yakima   school 5308970 39202   Toppenish School District 530897001535 2264 Toppenish Middle School   Regular School No Middle 06 08 2017   grade_7 6 1 221   47 0     0   1   138 138 0   122   19   241       7.0 276 6 1 221   47 0     0   1   138 138 0   122 19 241     7 276
631158 631158 WA Yakima   school 5308970 39202   Toppenish School District 530897003385 5262 Northwest Allprep   Regular School No Other KG 12 2017   grade_7 32 1 2   0 2     0   0   18 19 0   0   0   8       0.0 37 32 1 2   0 2     0   0   18 19 0   0 0 8     0 37
631126 631126 WA Yakima   school 5308970 39202   Toppenish School District 530897002378 1508 Computer Academy Toppenish High School   Alternative School No Other 06 12 2017   grade_7 0 0 2   0 0     0   0   1 1 0   1   0   2       0.0 2 0 0 2   0 0     0   0   1 1 0   1 0 2     0 2
631120 631120 WA Okanogan   school 5308940 24404   Tonasket School District 530894001647 4196 Tonasket Middle School   Regular School No Middle 06 08 2017   grade_7 54 0 32   0 0     0   5   45 46 0   11   6   57       0.0 91 54 0 32   0 0     0   5   45 46 0   11 6 57     0 91
631102 631102 WA Lewis   school 5308910 21237   Toledo School District 530891001528 3977 Toledo Middle School   Regular School No Middle 06 08 2017   grade_7 46 0 9   0 0     0   2   28 29 0   3   2   30       0.0 57 46 0 9   0 0     0   2   28 29 0   3 2 30     0 57
631084 631084 WA Lewis   school 5308910 21237   Toledo School District 530891003310 5190 Cowlitz Prairie Academy   Regular School No High 07 12 2017   grade_7 2 0 0   0 0     0   0   0 2 0   0   0   0       0.0 2 2 0 0   0 0     0   0   0 2 0   0 0 0     0 2
631075 631075 WA Kittitas   school 5308850 19400   Thorp School District 530885001525 2514 Thorp Elem & Jr Sr High   Regular School No Other KG 12 2017   grade_7 10 0 0   0 0     0   1   4 7 0   0   1   5       0.0 11 10 0 0   0 0     0   1   4 7 0   0 1 5     0 11
631063 631063 WA Thurston   school 5308820 34402   Tenino School District 530882001523 3795 Tenino Middle School   Regular School No Middle 06 08 2017   grade_7 87 0 7   2 0     0   4   55 45 0   1   9   57       1.0 100 87 0 7   2 0     0   4   55 45 0   1 9 57     1 100
631044 631044 WA Whitman   school 5308790 38265   Tekoa School District 530879001521 3418 Tekoa High School   Regular School No High 07 12 2017   grade_7 14 0 3   1 0     0   0   10 8 0   0   0   12       0.0 18 14 0 3   1 0     0   0   10 8 0   0 0 12     0 18
631037 631037 WA Whitman   school 5308790 38265   Tekoa School District 530879001520 2052 Tekoa Elementary School   Regular School No Elementary PK 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
631023 631023 WA King   school 5308760 17409   Tahoma School District 530876002874 4556 Tahoma Jr High (Closed after 2016-2017 school year)   Regular School No Other 08 09 2017   grade_7 0 0 0   0 1     0   0   0 1 0   0   0   0       0.0 1 0 0 0   0 1     0   0   0 1 0   0 0 0     0 1
631019 631019 WA King   school 5308760 17409   Tahoma School District 530876002979 3341 Summit Trail Middle School   Regular School No Middle 06 07 2017   grade_7 229 9 21   0 12     2   19   149 143 0   5   2   44       24.0 292 229 9 21   0 12     2   19   149 143 0   5 2 44     24 292
630997 630997 WA King   school 5308760 17409   Tahoma School District 530876001515 3937 Maple View Middle School   Regular School No Middle 06 07 2017   grade_7 249 4 33   0 17     6   27   175 161 0   6   3   55       27.0 336 249 4 33   0 17     6   27   175 161 0   6 3 55     27 336
630969 630969 WA Grays Harbor   school 5308730 14077   Taholah School District 530873002956 5032 Taholah Elementary & Middle School   Regular School No Elementary KG 08 2017   grade_7 0 0 3   10 0     0   3   6 10 0   0   3   12       0.0 16 0 0 3   10 0     0   3   6 10 0   0 3 12     0 16
630929 630929 WA Pierce   school 5308700 27010   Tacoma School District 530870001507 3448 Truman   Regular School No Middle 06 08 2017   grade_7 156 48 28   3 21     1   7   125 139 0   20   11   159       10.0 264 156 48 28   3 21     1   7   125 139 0   20 11 159     10 264
630910 630910 WA Pierce   school 5308700 27010   Tacoma School District 530870001504 2359 Stewart   Regular School No Middle 06 08 2017   grade_7 29 21 28   2 19     2   5   59 47 0   14   7   89       3.0 106 29 21 28   2 19     2   5   59 47 0   14 7 89     3 106
630890 630890 WA Pierce   school 5308700 27010   Tacoma School District 530870003275 5192 Special Services   Alternative School No Other PK 12 2017   grade_7 4 0 0   0 0     0   0   3 1 0   0   0   2       1.0 4 4 0 0   0 0     0   0   3 1 0   0 0 2     1 4
630804 630804 WA Pierce   school 5308700 27010   Tacoma School District 530870001487 3244 Meeker   Regular School No Middle 06 08 2017   grade_7 131 28 21   4 29     2   13   125 103 0   7   2   68       6.0 228 131 28 21   4 29     2   13   125 103 0   7 2 68     6 228
630792 630792 WA Pierce   school 5308700 27010   Tacoma School District 530870001483 2376 Mason   Regular School No Middle 06 08 2017   grade_7 195 23 21   2 22     1   6   137 133 0   3   4   91       15.0 270 195 23 21   2 22     1   6   137 133 0   3 4 91     15 270
630725 630725 WA Pierce   school 5308700 27010   Tacoma School District 530870001473 2338 Jason Lee   Regular School No Middle 06 08 2017   grade_7 64 47 19   3 11     4   15   82 81 0   9   16   107       3.0 163 64 47 19   3 11     4   15   82 81 0   9 16 107     3 163
630711 630711 WA Pierce   school 5308700 27010   Tacoma School District 530870001471 2377 Gray   Regular School No Middle 06 08 2017   grade_7 48 36 45   1 22     10   17   86 93 0   19   11   140       5.0 179 48 36 45   1 22     10   17   86 93 0   19 11 140     5 179
630678 630678 WA Pierce   school 5308700 27010   Tacoma School District 530870003299 5170 First Creek Middle School   Regular School No Middle 06 08 2017   grade_7 41 59 95   8 44     13   12   139 133 0   48   9   237       4.0 272 41 59 95   8 44     13   12   139 133 0   48 9 237     4 272
630619 630619 WA Pierce   school 5308700 27010   Tacoma School District 530870001458 3397 Bryant   Regular School No Elementary PK 08 2017   grade_7 37 12 3   0 1     0   2   32 23 0   1   2   19       3.0 55 37 12 3   0 1     0   2   32 23 0   1 2 19     3 55
630579 630579 WA Pierce   school 5308700 27010   Tacoma School District 530870001454 3054 Baker   Regular School No Middle 06 08 2017   grade_7 61 41 60   0 50     8   21   117 124 0   28   11   186       12.0 241 61 41 60   0 50     8   21   117 124 0   28 11 186     12 241
630567 630567 WA Pierce   school 5308700 27010   Tacoma School District 530870003155 4575 Angelo Giaudrone Middle School   Regular School No Middle 06 08 2017   grade_7 71 50 41   6 34     10   10   102 120 0   19   12   183       3.0 222 71 50 41   6 34     10   10   102 120 0   19 12 183     3 222
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
630538 630538 WA Yakima   school 5308670 39201   Sunnyside School District 530867003037 5049 Sierra Vista Middle School   Regular School No Middle 06 08 2017   grade_7 20 0 193   0 0     0   2   109 106 0   58   7   194       2.0 215 20 0 193   0 0     0   2   109 106 0   58 7 194     2 215
630516 630516 WA Yakima   school 5308670 39201   Sunnyside School District 530867001451 3313 Harrison Middle School   Regular School No Middle 06 08 2017   grade_7 17 0 292   0 0     0   8   156 161 0   96   9   255       4.0 317 17 0 292   0 0     0   8   156 161 0   96 9 255     4 317

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