enrollments

Data source: Big Local News · About: Big Local

650 rows where grade = "grade_7", state = "WA" and year = 2019 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 650 ✖

grade ✖

  • grade_7 · 650 ✖
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
2428463 2428463 WA Yakima   school 5310170 39205   Zillah School District 531017002502 4481 Zillah Middle School   Regular School No Middle 07 08 2019   grade_7 39 0 57   6 0     0   5   59 48 0   5   4   67       1.0 107 39 0 57   6 0     0   5   59 48 0   5 4 67     1 107
2428437 2428437 WA Thurston   school 5310140 34002   Yelm School District 531014001717 2481 Yelm Middle School   Regular School No Middle 06 08 2019   grade_7 153 3 30   5 6     4   30   109 122 0   7   1   123       10.0 231 153 3 30   5 6     4   30   109 122 0   7 1 123     10 231
2428415 2428415 WA Thurston   school 5310140 34002   Yelm School District 531014003068 5052 Ridgeline Middle School   Regular School No Middle 06 08 2019   grade_7 128 1 26   5 2     3   25   85 105 0   1   4   88       13.0 190 128 1 26   5 2     3   25   85 105 0   1 4 88     13 190
2428363 2428363 WA Yakima   school 5310110 39007   Yakima School District 531011001710 3368 Wilson Middle School   Regular School No Middle 06 08 2019   grade_7 89 4 195   2 0     1   11   162 140 0   59   10   221       19.0 302 89 4 195   2 0     1   11   162 140 0   59 10 221     19 302
2428351 2428351 WA Yakima   school 5310110 39007   Yakima School District 531011001708 2314 Washington Middle School   Regular School No Middle 06 08 2019   grade_7 14 2 265   3 0     0   3   149 138 0   129   13   266       8.0 287 14 2 265   3 0     0   3   149 138 0   129 13 266     8 287
2428295 2428295 WA Yakima   school 5310110 39007   Yakima School District 531011001814 3817 Martin Luther King Jr Elementary   Regular School No Elementary KG 05 2019   grade_7 0 0 2   0 0     0   0   0 2 0   0   0   2       0.0 2 0 0 2   0 0     0   0   0 2 0   0 0 2     0 2
2428287 2428287 WA Yakima   school 5310110 39007   Yakima School District 531011001698 3615 Lewis & Clark Middle School   Regular School No Middle 06 08 2019   grade_7 32 0 249   2 0     0   3   158 128 0   82   2   239       13.0 286 32 0 249   2 0     0   3   158 128 0   82 2 239     13 286
2428255 2428255 WA Yakima   school 5310110 39007   Yakima School District 531011001691 2410 Franklin Middle School   Regular School No Middle 06 08 2019   grade_7 46 0 215   7 0     0   5   127 146 0   73   10   233       8.0 273 46 0 215   7 0     0   5   127 146 0   73 10 233     8 273
2428243 2428243 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2019   grade_7 9 0 16   0 0     0   3   18 10 0   4   0   18       3.0 28 9 0 16   0 0     0   3   18 10 0   4 0 18     3 28
2428232 2428232 WA Yakima   school 5310110 39007   Yakima School District 531011001689 2116 Davis High School   Regular School No High 09 12 2019   grade_7 1 0 0   0 0     0   0   0 1 0   1   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   1 0 1     0 1
2428200 2428200 WA Cowlitz   school 5310050 8404   Woodland School District 531005003509 5409 Woodland Middle School   Regular School No Middle 05 08 2019   grade_7 119 3 36   0 2     0   9   82 87 0   11   11   93       4.0 169 119 3 36   0 2     0   9   82 87 0   11 11 93     4 169
2428178 2428178 WA Cowlitz   school 5310050 8404   Woodland School District 531005003371 5246 Lewis River Academy   Alternative School No Other KG 12 2019   grade_7 1 0 2   0 0     0   0   1 2 0   0   0   1       0.0 3 1 0 2   0 0     0   0   1 2 0   0 0 1     0 3
2428166 2428166 WA Klickitat   school 5310020 20094   Wishram School District 531002001680 2605 Wishram High And Elementary Schl   Regular School No Other PK 12 2019   grade_7 4 0 0   1 0     0   0   3 2 0   0   1   3       0.0 5 4 0 0   1 0     0   0   3 2 0   0 1 3     0 5
2428154 2428154 WA Grays Harbor   school 5309990 14117   Wishkah Valley School District 530999001679 3375 Wishkah Valley Elementary/High School   Regular School No Other KG 12 2019   grade_7 9 0 0   0 0     0   0   1 8 0   0   0   2       2.0 9 9 0 0   0 0     0   0   1 8 0   0 0 2     2 9
2428124 2428124 WA Lewis   school 5309930 21232   Winlock School District 530993002392 4369 Winlock Middle School   Regular School No Middle 06 08 2019   grade_7 41 0 18   0 1     0   5   31 34 0   5   6   61       1.0 65 41 0 18   0 1     0   5   31 34 0   5 6 61     1 65
2428119 2428119 WA Grant   school 5309900 13167   Wilson Creek School District 530990001675 2473 Wilson Creek High   Regular School No High 07 12 2019   grade_7 9 1 1   0 0     0   0   4 7 0   0   1   8       0.0 11 9 1 1   0 0     0   0   4 7 0   0 1 8     0 11
2428103 2428103 WA Pacific   school 5309870 25160   Willapa Valley School District 530987001673 2542 Willapa Valley Middle-High   Regular School No High 06 12 2019   grade_7 21 0 3   0 0     0   2   8 18 0   0   2   15       1.0 26 21 0 3   0 0     0   2   8 18 0   0 2 15     1 26
2428087 2428087 WA Lincoln   school 5309840 22200   Wilbur School District 530984001668 3289 Wilbur Secondary School   Regular School No High 07 12 2019   grade_7 14 0 0   3 0     0   5   13 9 0   0   1   11       0.0 22 14 0 0   3 0     0   5   13 9 0   0 1 11     0 22
2428069 2428069 WA Klickitat   school 5309810 20405   White Salmon Valley School District 530981001666 3394 Wayne M Henkle Middle School   Regular School No Middle 07 08 2019   grade_7 55 0 38   2 0     1   1   56 41 0   18   5   48       7.0 97 55 0 38   2 0     1   1   56 41 0   18 5 48     7 97
2428022 2428022 WA Pierce   school 5309780 27416   White River School District 530978003005 3458 Glacier Middle School   Regular School No Middle 06 08 2019   grade_7 246 3 34   2 4     0   16   163 142 0   17   2   99       13.0 305 246 3 34   2 4     0   16   163 142 0   17 2 99     13 305
2427999 2427999 WA Lewis   school 5309750 21303   White Pass School District 530975001659 2859 White Pass Jr. Sr. High School   Regular School No High 07 12 2019   grade_7 28 0 2   1 0     0   0   20 11 0   0   10   22       0.0 31 28 0 2   1 0     0   0   20 11 0   0 10 22     0 31
2427963 2427963 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972003619 5505 WEST VALLEY VIRTUAL ACADEMY 7-8   Regular School No Middle 07 08 2019   grade_7 4 0 1   0 0     0   0   3 2 0   0   0   1       0.0 5 4 0 1   0 0     0   0   3 2 0   0 0 1     0 5
2427959 2427959 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972002545 4506 West Valley Middle School   Regular School No Middle 05 06 2019   grade_7 1 0 0   0 1     0   0   1 1 0   1   0   1       0.0 2 1 0 0   0 1     0   0   1 1 0   1 0 1     0 2
2427954 2427954 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001653 4040 West Valley Jr High   Regular School No Middle 07 08 2019   grade_7 275 1 138   2 16     3   17   222 230 0   24   1   211       14.0 452 275 1 138   2 16     3   17   222 230 0   24 1 211     14 452
2427904 2427904 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969002685 1755 West Valley City School   Alternative School No Middle 05 08 2019   grade_7 39 1 8   0 1     0   5   21 33 0   0   1   23       1.0 54 39 1 8   0 1     0   5   21 33 0   0 1 23     1 54
2427851 2427851 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001645 3538 Centennial Middle School   Regular School No Middle 06 08 2019   grade_7 155 1 23   2 4     0   23   116 92 0   8   3   114       10.0 208 155 1 23   2 4     0   23   116 92 0   8 3 114     10 208
2427824 2427824 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 2019   grade_7 14 0 0   0 0     0   0   4 10 0   0   0   2       2.0 14 14 0 0   0 0     0   0   4 10 0   0 0 2     2 14
2427806 2427806 WA Chelan   school 5309660 4246   Wenatchee School District 530966001636 3269 Special Education School   Special Education School No Other PK 09 2019   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
2427799 2427799 WA Chelan   school 5309660 4246   Wenatchee School District 530966001635 3210 Pioneer Middle School   Regular School No Middle 06 08 2019   grade_7 79 1 120   2 1     1   5   113 96 0   40   10   153       16.0 209 79 1 120   2 1     1   5   113 96 0   40 10 153     16 209
2427795 2427795 WA Chelan   school 5309660 4246   Wenatchee School District 530966001634 3370 Orchard Middle School   Regular School No Middle 06 08 2019   grade_7 77 1 93   0 2     0   10   89 94 0   45   6   128       11.0 183 77 1 93   0 2     0   10   89 94 0   45 6 128     11 183
2427765 2427765 WA Chelan   school 5309660 4246   Wenatchee School District 530966001006 4432 Foothills Middle School   Regular School No Middle 06 08 2019   grade_7 96 0 94   1 2     0   7   96 104 0   32   10   106       9.0 200 96 0 94   1 2     0   7   96 104 0   32 10 106     9 200
2427743 2427743 WA Stevens   school 5309630 33049   Wellpinit School District #49 530963003150 4232 Wellpinit Middle School   Regular School No Middle 06 08 2019   grade_7 1 0 2   17 0     0   4   14 10 0   6   7   22       0.0 24 1 0 2   17 0     0   4   14 10 0   6 7 22     0 24
2427722 2427722 WA Douglas   school 5309600 9209   Waterville School District 530960001628 2162 Waterville High School   Regular School No High 06 12 2019   grade_7 11 0 3   0 0     0   1   12 3 0   0   1   8       0.0 15 11 0 3   0 0     0   1   12 3 0   0 1 8     0 15
2427705 2427705 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other PK 12 2019   grade_7 3 0 0   0 0     0   0   2 1 0   0   0   3       0.0 3 3 0 0   0 0     0   0   2 1 0   0 0 3     0 3
2427686 2427686 WA Clark   school 5309540 6112   Washougal School District 530954001892 4207 Jemtegaard Middle School   Regular School No Middle 06 08 2019   grade_7 146 0 19   1 2     0   12   95 85 0   3   3   78       12.0 180 146 0 19   1 2     0   12   95 85 0   3 3 78     12 180
2427654 2427654 WA Clark   school 5309540 6112   Washougal School District 530954002709 4549 Canyon Creek Middle School   Regular School No Middle 06 08 2019   grade_7 71 1 2   0 2     0   4   41 39 0   4   1   23       2.0 80 71 1 2   0 2     0   4   41 39 0   4 1 23     2 80
2427642 2427642 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 2019   grade_7 4 3 5   1 2     1   0   6 10 0   0   1   11       0.0 16 4 3 5   1 2     1   0   6 10 0   0 1 11     0 16
2427631 2427631 WA Grant   school 5309510 13146   Warden School District 530951001620 3909 Warden Middle School   Regular School No Middle 06 08 2019   grade_7 15 0 70   0 0     0   0   41 44 0   27   7   84       1.0 85 15 0 70   0 0     0   0   41 44 0   27 7 84     1 85
2427614 2427614 WA Yakima   school 5309480 39207   Wapato School District 530948001615 2131 Wapato Middle School   Regular School No Middle 06 08 2019   grade_7 7 0 227   73 7     0   10   163 161 0   159   8   303       4.0 324 7 0 227   73 7     0   10   163 161 0   159 8 303     4 324
2427556 2427556 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001605 2780 Pioneer Middle School   Regular School No Middle 06 08 2019   grade_7 95 0 80   0 2     0   7   102 82 0   13   5   111       10.0 184 95 0 80   0 2     0   7   102 82 0   13 5 111     10 184
2427538 2427538 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001601 3510 Garrison Middle School   Regular School No Middle 06 08 2019   grade_7 101 1 77   1 4     0   5   117 72 0   27   5   95       7.0 189 101 1 77   1 4     0   5   117 72 0   27 5 95     7 189
2427498 2427498 WA Walla Walla   school 5309390 36401   Waitsburg School District 530939002492 2174 Preston Hall Middle School   Regular School No Middle 06 08 2019   grade_7 15 0 7   1 0     0   2   9 16 0   0   2   15       1.0 25 15 0 7   1 0     0   2   9 16 0   0 2 15     1 25
2427494 2427494 WA Grant   school 5309360 13073   Wahluke School District 530936003264 5144 Wahluke Junior High   Regular School No Middle 06 08 2019   grade_7 2 0 202   2 0     0   0   103 103 0   86   20   190       4.0 206 2 0 202   2 0     0   0   103 103 0   86 20 190     4 206
2427450 2427450 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 2019   grade_7 33 0 3   1 1     0   5   23 20 0   3   2   29       1.0 43 33 0 3   1 1     0   5   23 20 0   3 2 29     1 43
2427440 2427440 WA Thurston   school   34901   WA HE LUT Indian School Agency   5496 Wa He Lut Indian School             2019   grade_7 0 1 1   16 0     0   1   9 10 0   0   3   18       0.0 19 0 1 1   16 0     0   1   9 10 0   0 3 18     0 19
2427421 2427421 WA King   school 5309300 17402   Vashon Island School District 530930001589 3667 McMurray Middle School   Regular School No Middle 06 08 2019   grade_7 87 1 21   0 2     0   17   71 57 0   5   0   33       11.0 128 87 1 21   0 2     0   17   71 57 0   5 0 33     11 128
2427415 2427415 WA King   school 5309300 17402   Vashon Island School District 530930002720 1822 Family Link   Alternative School No Other KG 12 2019   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
2427377 2427377 WA Clark   school 5309270 6037   Vancouver School District 530927003246 5149 Vancouver Virtual Learning Academy   Alternative School No High 06 12 2019   grade_7 0 0 1   0 0     1   3   2 3 0   1   1   4       0.0 5 0 0 1   0 0     1   3   2 3 0   1 1 4     0 5
2427369 2427369 WA Clark   school 5309270 6037   Vancouver School District 530927002508 1689 Vancouver School of Arts and Academics   Regular School No High 06 12 2019   grade_7 63 1 13   0 4     1   9   26 65 0   0   0   28       5.0 91 63 1 13   0 4     1   9   26 65 0   0 0 28     5 91
2427361 2427361 WA Clark   school 5309270 6037   Vancouver School District 530927003415 5271 Vancouver iTech Preparatory   Regular School No High 06 12 2019   grade_7 40 0 13   0 2     0   4   45 14 0   2   0   14       6.0 59 40 0 13   0 2     0   4   45 14 0   2 0 14     6 59
2427351 2427351 WA Clark   school 5309270 6037   Vancouver School District 530927002943 3556 Vancouver Home Connection   Alternative School No Other KG 12 2019   grade_7 22 0 1   0 0     0   4   13 14 0   0   0   14       1.0 27 22 0 1   0 0     0   4   13 14 0   0 0 14     1 27
2427341 2427341 WA Clark   school 5309270 6037   Vancouver School District 530927002944 4591 Thomas Jefferson Middle School   Regular School No Middle 06 08 2019   grade_7 207 2 48   0 13     2   23   159 136 0   18   4   78       20.0 295 207 2 48   0 13     2   23   159 136 0   18 4 78     20 295
2427286 2427286 WA Clark   school 5309270 6037   Vancouver School District 530927001577 3146 Mcloughlin Middle School   Regular School No Middle 06 08 2019   grade_7 105 11 160   2 10     23   24   172 163 0   90   15   272       8.0 335 105 11 160   2 10     23   24   172 163 0   90 15 272     8 335
2427255 2427255 WA Clark   school 5309270 6037   Vancouver School District 530927001570 3543 Jason Lee Middle School   Regular School No Middle 06 08 2019   grade_7 137 4 51   1 9     2   20   112 112 0   14   12   116       10.0 224 137 4 51   1 9     2   20   112 112 0   14 12 116     10 224
2427208 2427208 WA Clark   school 5309270 6037   Vancouver School District 530927001562 3902 Gaiser Middle School   Regular School No Middle 06 08 2019   grade_7 125 6 114   1 14     12   22   158 136 0   48   10   192       11.0 294 125 6 114   1 14     12   22   158 136 0   48 10 192     11 294
2427191 2427191 WA Clark   school 5309270 6037   Vancouver School District 530927002408 1574 Fir Grove Childrens Center   Special Education School No Other KG 12 2019   grade_7 5 0 1   0 0     0   0   4 2 0   0   0   4       0.0 6 5 0 1   0 0     0   0   4 2 0   0 0 4     0 6
2427164 2427164 WA Clark   school 5309270 6037   Vancouver School District 530927002018 4503 Discovery Middle School   Regular School No Middle 06 08 2019   grade_7 100 9 100   1 3     2   19   111 123 0   41   9   173       10.0 234 100 9 100   1 3     2   19   111 123 0   41 9 173     10 234
2427141 2427141 WA Clark   school 5309270 6037   Vancouver School District 530927000578 4406 Alki Middle School   Regular School No Middle 06 08 2019   grade_7 149 3 26   1 7     0   12   115 83 0   4   2   50       8.0 198 149 3 26   1 7     0   12   115 83 0   4 2 50     8 198
2427136 2427136 WA Stevens   school 5309240 33070   Valley School District 530924001555 2405 Valley School   Regular School No Elementary KG 08 2019   grade_7 15 0 4   1 0     0   1   13 8 0   0   0   15       0.0 21 15 0 4   1 0     0   1   13 8 0   0 0 15     0 21
2427117 2427117 WA Stevens   school 5309240 33070   Valley School District 530924003107 1932 Columbia Virtual Academy   Alternative School No Elementary KG 08 2019   grade_7 57 2 20   1 5     0   16   47 54 0   5   3   0       0.0 101 57 2 20   1 5     0   16   47 54 0   5 3 0     0 101
2427095 2427095 WA Pierce   school 5309180 27083   University Place School District 530918001550 3296 Narrows View Intermediate   Regular School No Middle 05 07 2019   grade_7 114 20 30   1 23     3   31   124 98 0   9   5   99       16.0 222 114 20 30   1 23     3   31   124 98 0   9 5 99     16 222
2427084 2427084 WA Pierce   school 5309180 27083   University Place School District 530918002383 4325 Drum Intermediate   Regular School No Middle 05 07 2019   grade_7 93 17 29   0 12     0   37   96 92 0   7   3   70       9.0 188 93 17 29   0 12     0   37   96 92 0   7 3 70     9 188
2427062 2427062 WA Yakima   school 5309150 39002   Union Gap School District 530915002382 2714 Union Gap School   Regular School No Elementary PK 08 2019   grade_7 13 0 53   0 0     0   3   29 40 0   15   1   65       1.0 69 13 0 53   0 0     0   3   29 40 0   15 1 65     1 69
2427053 2427053 WA Thurston   school 5309100 34033   Tumwater School District 530910001545 3612 Tumwater Middle School   Regular School No Middle 06 08 2019   grade_7 154 2 28   0 11     2   25   123 99 0   4   2   83       6.0 222 154 2 28   0 11     2   25   123 99 0   4 2 83     6 222
2427037 2427037 WA Thurston   school 5309100 34033   Tumwater School District 530910002380 3925 Thurs Co Juv Det/Tumwater West E   Regular School No High 06 12 2019   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
2427001 2427001 WA Thurston   school 5309100 34033   Tumwater School District 530910001734 4452 George Washington Bush Middle Sch   Regular School No Middle 06 08 2019   grade_7 175 1 34   2 2     0   24   130 108 0   9   8   85       10.0 238 175 1 34   2 2     0   24   130 108 0   9 8 85     10 238
2426973 2426973 WA King   school 5308130 17406   Tukwila School District 530813003650 5536 Tukwila Online Learning   Alternative School No High 06 12 2019   grade_7 2 0 0   0 1     0   0   1 2 0   0   0   1       0.0 3 2 0 0   0 1     0   0   1 2 0   0 0 1     0 3
2426950 2426950 WA King   school 5308130 17406   Tukwila School District 530813001342 2564 Showalter Middle School   Regular School No Middle 06 08 2019   grade_7 28 29 72   3 59     11   6   100 108 0   63   11   152       4.0 208 28 29 72   3 59     11   6   100 108 0   63 11 152     4 208
2426929 2426929 WA Klickitat   school 5309060 20400   Trout Lake School District 530906001539 2676 Trout Lake School   Regular School No High 05 12 2019   grade_7 14 0 3   0 0     0   1   10 8 0   1   0   0       3.0 18 14 0 3   0 0     0   1   10 8 0   1 0 0     3 18
2426914 2426914 WA Cowlitz   school 5309030 8130   Toutle Lake School District 530903001538 2560 Toutle Lake High School   Regular School No High 07 12 2019   grade_7 57 0 5   0 3     0   4   33 36 0   0   0   27       7.0 69 57 0 5   0 3     0   4   33 36 0   0 0 27     7 69
2426896 2426896 WA Walla Walla   school 5309000 36300   Touchet School District 530900001536 2160 Touchet Elem & High School   Regular School No Other KG 12 2019   grade_7 11 0 9   0 0     0   0   7 13 0   3   0   11       0.0 20 11 0 9   0 0     0   0   7 13 0   3 0 11     0 20
2426875 2426875 WA Yakima   school 5308970 39202   Toppenish School District 530897001535 2264 Toppenish Middle School   Regular School No Middle 06 08 2019   grade_7 3 1 253   44 0     0   7   165 143 0   140   5   288       10.0 308 3 1 253   44 0     0   7   165 143 0   140 5 288     10 308
2426865 2426865 WA Yakima   school 5308970 39202   Toppenish School District 530897003385 5262 Northwest Allprep   Regular School No Other KG 12 2019   grade_7 28 1 1   0 2     0   0   23 9 0   4   0   1       0.0 32 28 1 1   0 2     0   0   23 9 0   4 0 1     0 32
2426829 2426829 WA Okanogan   school 5308940 24404   Tonasket School District 530894001647 4196 Tonasket Middle School   Regular School No Middle 06 08 2019   grade_7 49 0 35   2 0     0   5   47 47 0   12   7   69       3.0 94 49 0 35   2 0     0   5   47 47 0   12 7 69     3 94
2426812 2426812 WA Lewis   school 5308910 21237   Toledo School District 530891001528 3977 Toledo Middle School   Regular School No Middle 06 08 2019   grade_7 57 2 7   2 0     0   1   39 30 0   3   8   41       0.0 69 57 2 7   2 0     0   1   39 30 0   3 8 41     0 69
2426802 2426802 WA Lewis   school 5308910 21237   Toledo School District 530891001526 2998 Toledo Elementary School   Regular School No Elementary PK 05 2019   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
2426785 2426785 WA Kittitas   school 5308850 19400   Thorp School District 530885001525 2514 Thorp Elem & Jr Sr High   Regular School No Other PK 12 2019   grade_7 12 0 0   0 0     0   0   5 7 0   0   1   8       0.0 12 12 0 0   0 0     0   0   5 7 0   0 1 8     0 12
2426772 2426772 WA Thurston   school 5308820 34402   Tenino School District 530882001523 3795 Tenino Middle School   Regular School No Middle 06 08 2019   grade_7 95 1 4   0 1     0   2   59 44 0   0   3   57       2.0 103 95 1 4   0 1     0   2   59 44 0   0 3 57     2 103
2426751 2426751 WA Whitman   school 5308790 38265   Tekoa School District 530879001521 3418 Tekoa High School   Regular School No High 07 12 2019   grade_7 10 0 4   1 0     0   1   10 6 0   0   0   9       0.0 16 10 0 4   1 0     0   1   10 6 0   0 0 9     0 16
2426723 2426723 WA King   school 5308760 17409   Tahoma School District 530876002979 3341 Summit Trail Middle School   Regular School No Middle 06 08 2019   grade_7 239 4 35   1 19     0   34   181 150 1   2   2   40       39.0 332 239 4 35   1 19     0   34   181 150 1   2 2 40     39 332
2426703 2426703 WA King   school 5308760 17409   Tahoma School District 530876001515 3937 Maple View Middle School   Regular School No Middle 06 08 2019   grade_7 220 9 42   1 20     2   39   175 158 0   2   3   60       34.0 333 220 9 42   1 20     2   39   175 158 0   2 3 60     34 333
2426670 2426670 WA Grays Harbor   school 5308730 14077   Taholah School District 530873002956 5032 Taholah Elementary & Middle School   Regular School No Elementary KG 08 2019   grade_7 0 0 2   15 0     0   1   13 5 0   0   2   12       0.0 18 0 0 2   15 0     0   1   13 5 0   0 2 12     0 18
2426634 2426634 WA Pierce   school 5308700 27010   Tacoma School District 530870001508 3116 Wainwright   Regular School No Middle 04 08 2019   grade_7 45 16 16   1 4     1   9   45 47 0   1   2   39       5.0 92 45 16 16   1 4     1   9   45 47 0   1 2 39     5 92
2426628 2426628 WA Pierce   school 5308700 27010   Tacoma School District 530870001507 3448 Truman   Regular School No Middle 06 08 2019   grade_7 124 42 39   3 24     3   23   137 121 0   22   23   148       17.0 258 124 42 39   3 24     3   23   137 121 0   22 23 148     17 258
2426606 2426606 WA Pierce   school 5308700 27010   Tacoma School District 530870001504 2359 Stewart   Regular School No Middle 06 08 2019   grade_7 49 31 70   2 16     10   27   117 88 0   35   15   167       15.0 205 49 31 70   2 16     10   27   117 88 0   35 15 167     15 205
2426588 2426588 WA Pierce   school 5308700 27010   Tacoma School District 530870003275 5192 Special Services   Alternative School No Other PK 12 2019   grade_7 1 3 0   0 0     0   1   4 1 0   0   1   4       0.0 5 1 3 0   0 0     0   1   4 1 0   0 1 4     0 5
2426500 2426500 WA Pierce   school 5308700 27010   Tacoma School District 530870001487 3244 Meeker   Regular School No Middle 06 08 2019   grade_7 112 21 42   0 21     6   49   139 112 0   20   12   90       10.0 251 112 21 42   0 21     6   49   139 112 0   20 12 90     10 251
2426488 2426488 WA Pierce   school 5308700 27010   Tacoma School District 530870001483 2376 Mason   Regular School No Middle 06 08 2019   grade_7 184 13 32   0 11     0   28   116 152 0   3   6   67       24.0 268 184 13 32   0 11     0   28   116 152 0   3 6 67     24 268
2426422 2426422 WA Pierce   school 5308700 27010   Tacoma School District 530870001473 2338 Jason Lee   Regular School No Middle 06 08 2019   grade_7 78 41 37   4 7     5   33   111 94 0   12   20   129       14.0 205 78 41 37   4 7     5   33   111 94 0   12 20 129     14 205
2426406 2426406 WA Pierce   school 5308700 27010   Tacoma School District 530870001471 2377 Gray   Regular School No Middle 06 08 2019   grade_7 46 38 45   2 16     7   14   84 84 0   25   14   150       3.0 168 46 38 45   2 16     7   14   84 84 0   25 14 150     3 168
2426373 2426373 WA Pierce   school 5308700 27010   Tacoma School District 530870003299 5170 First Creek Middle School   Regular School No Middle 06 08 2019   grade_7 28 41 87   2 36     10   32   124 112 0   55   10   206       4.0 236 28 41 87   2 36     10   32   124 112 0   55 10 206     4 236
2426312 2426312 WA Pierce   school 5308700 27010   Tacoma School District 530870001458 3397 Bryant   Regular School No Elementary PK 08 2019   grade_7 45 3 8   4 3     0   3   35 29 2   1   0   29       5.0 66 45 3 8   4 3     0   3   35 29 2   1 0 29     5 66
2426271 2426271 WA Pierce   school 5308700 27010   Tacoma School District 530870001454 3054 Baker   Regular School No Middle 06 08 2019   grade_7 64 39 81   0 32     13   22   130 121 0   31   19   211       11.0 251 64 39 81   0 32     13   22   130 121 0   31 19 211     11 251
2426259 2426259 WA Pierce   school 5308700 27010   Tacoma School District 530870003155 4575 Angelo Giaudrone Middle School   Regular School No Middle 06 08 2019   grade_7 53 50 47   1 24     8   20   94 109 0   20   12   160       10.0 203 53 50 47   1 24     8   20   94 109 0   20 12 160     10 203
2426254 2426254 WA Kitsap   school 5300328 18902   Suquamish Tribal Education Department 530032803493 5319 Chief Kitsap Academy   Regular School No Other KG 12 2019   grade_7 1 0 0   3 0     0   0   3 1 0   0   0   3       0.0 4 1 0 0   3 0     0   0   3 1 0   0 0 3     0 4
2426230 2426230 WA Yakima   school 5308670 39201   Sunnyside School District 530867003037 5049 Sierra Vista Middle School   Regular School No Middle 06 08 2019   grade_7 12 0 219   1 0     0   2   126 108 0   60   11   203       2.0 234 12 0 219   1 0     0   2   126 108 0   60 11 203     2 234
2426207 2426207 WA Yakima   school 5308670 39201   Sunnyside School District 530867001451 3313 Harrison Middle School   Regular School No Middle 06 08 2019   grade_7 26 1 264   0 0     0   3   155 139 0   81   8   243       5.0 294 26 1 264   0 0     0   3   155 139 0   81 8 243     5 294
2426177 2426177 WA Pierce   school 5308610 27320   Sumner School District 530861001447 3499 Sumner Middle School   Regular School No Middle 06 08 2019   grade_7 148 4 50   3 6     2   14   129 98 0   15   5   98       14.0 227 148 4 50   3 6     2   14   129 98 0   15 5 98     14 227
2426167 2426167 WA Pierce   school 5308610 27320   Sumner School District 530861002580 4502 Mountain View Middle School   Regular School No Middle 06 08 2019   grade_7 194 5 37   2 3     1   20   126 136 0   6   6   87       25.0 262 194 5 37   2 3     1   20   126 136 0   6 6 87     25 262
2426147 2426147 WA Pierce   school 5308610 27320   Sumner School District 530861001808 4132 Lakeridge Middle School   Regular School No Middle 06 08 2019   grade_7 183 3 31   3 5     0   21   127 119 0   2   4   72       16.0 246 183 3 31   3 5     0   21   127 119 0   2 4 72     16 246

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