enrollments

Data source: Big Local News · About: Big Local

637 rows where grade = "grade_7", state = "WA" and year = 2018 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 637 ✖

grade ✖

  • grade_7 · 637 ✖
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
2472985 2472985 WA Yakima   school 5310170 39205   Zillah School District 531017002502 4481 Zillah Middle School   Regular School No Middle 07 08 2018   grade_7 37 0 53   3 0     0   2   54 41 0   12   2   58       1.0 95 37 0 53   3 0     0   2   54 41 0   12 2 58     1 95
2472959 2472959 WA Thurston   school 5310140 34002   Yelm School District 531014001717 2481 Yelm Middle School   Regular School No Middle 06 08 2018   grade_7 155 2 45   7 5     1   24   116 123 0   4   3   119       10.0 239 155 2 45   7 5     1   24   116 123 0   4 3 119     10 239
2472938 2472938 WA Thurston   school 5310140 34002   Yelm School District 531014003068 5052 Ridgeline Middle School   Regular School No Middle 06 08 2018   grade_7 140 1 33   2 2     1   30   112 97 0   3   1   96       8.0 209 140 1 33   2 2     1   30   112 97 0   3 1 96     8 209
2472902 2472902 WA Yakima   school 5310110 39007   Yakima School District 531011003324 5224 Yakima Satellite Alternative Programs   Alternative School No High 08 12 2018   grade_7 1 0 0   0 0     0   0   0 1 0   0   0   1       1.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     1 1
2472886 2472886 WA Yakima   school 5310110 39007   Yakima School District 531011001710 3368 Wilson Middle School   Regular School No Middle 06 08 2018   grade_7 83 1 166   5 1     0   8   120 144 0   49   4   192       8.0 264 83 1 166   5 1     0   8   120 144 0   49 4 192     8 264
2472874 2472874 WA Yakima   school 5310110 39007   Yakima School District 531011001708 2314 Washington Middle School   Regular School No Middle 06 08 2018   grade_7 14 2 248   1 0     0   1   128 138 0   120   8   250       10.0 266 14 2 248   1 0     0   1   128 138 0   120 8 250     10 266
2472818 2472818 WA Yakima   school 5310110 39007   Yakima School District 531011001814 3817 Martin Luther King Jr Elementary   Regular School No Elementary KG 05 2018   grade_7 2 0 1   0 0     0   0   2 1 0   0   0   1       0.0 3 2 0 1   0 0     0   0   2 1 0   0 0 1     0 3
2472809 2472809 WA Yakima   school 5310110 39007   Yakima School District 531011001698 3615 Lewis & Clark Middle School   Regular School No Middle 06 08 2018   grade_7 25 0 247   3 1     0   3   138 141 0   96   5   256       8.0 279 25 0 247   3 1     0   3   138 141 0   96 5 256     8 279
2472804 2472804 WA Yakima   school 5310110 39007   Yakima School District 531011002932 4092 Juvenile Detention Center   Regular School No High 05 12 2018   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
2472776 2472776 WA Yakima   school 5310110 39007   Yakima School District 531011001691 2410 Franklin Middle School   Regular School No Middle 06 08 2018   grade_7 56 2 218   5 1     0   5   156 131 0   68   6   235       4.0 287 56 2 218   5 1     0   5   156 131 0   68 6 235     4 287
2472764 2472764 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2018   grade_7 16 0 12   0 0     0   2   13 17 0   4   0   9       0.0 30 16 0 12   0 0     0   2   13 17 0   4 0 9     0 30
2472722 2472722 WA Cowlitz   school 5310050 8404   Woodland School District 531005003509 5409 Woodland Middle School   Regular School No Middle 05 08 2018   grade_7 146 2 39   1 0     0   5   99 94 0   12   8   98       3.0 193 146 2 39   1 0     0   5   99 94 0   12 8 98     3 193
2472702 2472702 WA Cowlitz   school 5310050 8404   Woodland School District 531005003371 5246 Lewis River Academy   Alternative School No Other KG 12 2018   grade_7 6 0 3   0 0     0   0   7 2 0   0   0   6       1.0 9 6 0 3   0 0     0   0   7 2 0   0 0 6     1 9
2472688 2472688 WA Klickitat   school 5310020 20094   Wishram School District 531002001680 2605 Wishram High And Elementary Schl   Regular School No Other PK 12 2018   grade_7 4 0 0   0 0     0   1   2 3 0   0   2   3       0.0 5 4 0 0   0 0     0   1   2 3 0   0 2 3     0 5
2472674 2472674 WA Grays Harbor   school 5309990 14117   Wishkah Valley School District 530999001679 3375 Wishkah Valley Elementary/High School   Regular School No Other KG 12 2018   grade_7 15 0 0   0 0     0   0   7 8 0   0   0   7       0.0 15 15 0 0   0 0     0   0   7 8 0   0 0 7     0 15
2472644 2472644 WA Lewis   school 5309930 21232   Winlock School District 530993002392 4369 Winlock Middle School   Regular School No Middle 06 08 2018   grade_7 39 0 10   0 0     0   5   35 19 0   8   3   45       3.0 54 39 0 10   0 0     0   5   35 19 0   8 3 45     3 54
2472638 2472638 WA Grant   school 5309900 13167   Wilson Creek School District 530990001675 2473 Wilson Creek High   Regular School No High 07 12 2018   grade_7 7 0 0   0 0     0   1   2 6 0   0   0   6       0.0 8 7 0 0   0 0     0   1   2 6 0   0 0 6     0 8
2472621 2472621 WA Pacific   school 5309870 25160   Willapa Valley School District 530987001673 2542 Willapa Valley Middle-High   Regular School No High 06 12 2018   grade_7 25 0 3   0 1     0   1   17 13 0   1   0   10       1.0 30 25 0 3   0 1     0   1   17 13 0   1 0 10     1 30
2472605 2472605 WA Lincoln   school 5309840 22200   Wilbur School District 530984001668 3289 Wilbur Secondary School   Regular School No High 07 12 2018   grade_7 15 0 2   2 0     0   1   5 15 0   0   1   10       0.0 20 15 0 2   2 0     0   1   5 15 0   0 1 10     0 20
2472587 2472587 WA Klickitat   school 5309810 20405   White Salmon Valley School District 530981001666 3394 Wayne M Henkle Middle School   Regular School No Middle 07 08 2018   grade_7 54 0 27   0 0     0   3   43 41 0   8   3   35       3.0 84 54 0 27   0 0     0   3   43 41 0   8 3 35     3 84
2472540 2472540 WA Pierce   school 5309780 27416   White River School District 530978003005 3458 Glacier Middle School   Regular School No Middle 06 08 2018   grade_7 202 1 35   2 1     0   15   132 124 0   2   5   74       12.0 256 202 1 35   2 1     0   15   132 124 0   2 5 74     12 256
2472517 2472517 WA Lewis   school 5309750 21303   White Pass School District 530975001659 2859 White Pass Jr. Sr. High School   Regular School No High 07 12 2018   grade_7 46 0 2   1 0     0   0   25 24 0   0   6   32       0.0 49 46 0 2   1 0     0   0   25 24 0   0 6 32     0 49
2472482 2472482 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972003619 5505 WEST VALLEY VIRTUAL ACADEMY 7-8   Regular School No Middle 07 08 2018   grade_7 1 0 1   0 0     0   0   1 1 0   0   0   0       0.0 2 1 0 1   0 0     0   0   1 1 0   0 0 0     0 2
2472474 2472474 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001653 4040 West Valley Jr High   Regular School No Middle 07 08 2018   grade_7 257 1 124   4 13     1   14   210 204 0   21   4   179       18.0 414 257 1 124   4 13     1   14   210 204 0   21 4 179     18 414
2472470 2472470 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 Secondary 09 09 2018   grade_7 3 0 1   0 0     0   0   3 1 0   0   0   1       0.0 4 3 0 1   0 0     0   0   3 1 0   0 0 1     0 4
2472422 2472422 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969002685 1755 West Valley City School   Alternative School No Middle 05 08 2018   grade_7 49 0 5   0 1     0   6   27 34 0   0   0   22       1.0 61 49 0 5   0 1     0   6   27 34 0   0 0 22     1 61
2472372 2472372 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001645 3538 Centennial Middle School   Regular School No Middle 06 08 2018   grade_7 145 4 26   2 2     1   25   118 87 0   9   11   127       8.0 205 145 4 26   2 2     1   25   118 87 0   9 11 127     8 205
2472343 2472343 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 2018   grade_7 16 1 1   0 0     0   0   9 9 0   0   0   3       0.0 18 16 1 1   0 0     0   0   9 9 0   0 0 3     0 18
2472318 2472318 WA Chelan   school 5309660 4246   Wenatchee School District 530966001635 3210 Pioneer Middle School   Regular School No Middle 06 08 2018   grade_7 85 1 106   4 1     0   3   104 96 0   54   12   124       11.0 200 85 1 106   4 1     0   3   104 96 0   54 12 124     11 200
2472314 2472314 WA Chelan   school 5309660 4246   Wenatchee School District 530966001634 3370 Orchard Middle School   Regular School No Middle 06 08 2018   grade_7 49 1 111   0 0     0   1   87 75 0   56   8   130       11.0 162 49 1 111   0 0     0   1   87 75 0   56 8 130     11 162
2472284 2472284 WA Chelan   school 5309660 4246   Wenatchee School District 530966001006 4432 Foothills Middle School   Regular School No Middle 06 08 2018   grade_7 98 0 85   0 9     0   5   88 109 0   24   3   111       9.0 197 98 0 85   0 9     0   5   88 109 0   24 3 111     9 197
2472262 2472262 WA Stevens   school 5309630 33049   Wellpinit School District #49 530963003150 4232 Wellpinit Middle School   Regular School No Middle 06 08 2018   grade_7 1 0 1   27 0     0   8   21 16 0   4   0   34       0.0 37 1 0 1   27 0     0   8   21 16 0   4 0 34     0 37
2472237 2472237 WA Douglas   school 5309600 9209   Waterville School District 530960001628 2162 Waterville High School   Regular School No High 06 12 2018   grade_7 12 0 3   1 0     0   0   5 11 0   1   0   8       0.0 16 12 0 3   1 0     0   0   5 11 0   1 0 8     0 16
2472220 2472220 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other PK 12 2018   grade_7 3 0 1   0 0     0   0   3 1 0   0   0   3       0.0 4 3 0 1   0 0     0   0   3 1 0   0 0 3     0 4
2472201 2472201 WA Clark   school 5309540 6112   Washougal School District 530954001892 4207 Jemtegaard Middle School   Regular School No Middle 06 08 2018   grade_7 154 0 32   0 0     0   11   93 104 0   9   2   87       9.0 197 154 0 32   0 0     0   11   93 104 0   9 2 87     9 197
2472167 2472167 WA Clark   school 5309540 6112   Washougal School District 530954002709 4549 Canyon Creek Middle School   Regular School No Middle 06 08 2018   grade_7 59 0 3   1 0     0   5   36 32 0   0   0   15       7.0 68 59 0 3   1 0     0   5   36 32 0   0 0 15     7 68
2472156 2472156 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 2018   grade_7 2 0 1   0 1     0   0   2 2 0   0   0   2       0.0 4 2 0 1   0 1     0   0   2 2 0   0 0 2     0 4
2472144 2472144 WA Grant   school 5309510 13146   Warden School District 530951001620 3909 Warden Middle School   Regular School No Middle 06 08 2018   grade_7 14 0 50   0 0     0   3   23 44 0   19   8   60       0.0 67 14 0 50   0 0     0   3   23 44 0   19 8 60     0 67
2472127 2472127 WA Yakima   school 5309480 39207   Wapato School District 530948001615 2131 Wapato Middle School   Regular School No Middle 06 08 2018   grade_7 7 0 185   60 4     0   8   154 110 0   145   22   251       1.0 264 7 0 185   60 4     0   8   154 110 0   145 22 251     1 264
2472063 2472063 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001605 2780 Pioneer Middle School   Regular School No Middle 06 08 2018   grade_7 122 2 95   1 6     0   6   126 106 0   37   7   127       8.0 232 122 2 95   1 6     0   6   126 106 0   37 7 127     8 232
2472043 2472043 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001601 3510 Garrison Middle School   Regular School No Middle 06 08 2018   grade_7 121 2 85   0 3     0   6   111 106 0   27   8   108       13.0 217 121 2 85   0 3     0   6   111 106 0   27 8 108     13 217
2471999 2471999 WA Walla Walla   school 5309390 36401   Waitsburg School District 530939002492 2174 Preston Hall Middle School   Regular School No Middle 06 08 2018   grade_7 19 0 6   0 1     0   2   17 11 0   1   0   18       0.0 28 19 0 6   0 1     0   2   17 11 0   1 0 18     0 28
2471995 2471995 WA Grant   school 5309360 13073   Wahluke School District 530936003264 5144 Wahluke Junior High   Regular School No Middle 06 08 2018   grade_7 1 0 214   0 0     0   0   126 89 0   126   17   214       7.0 215 1 0 214   0 0     0   0   126 89 0   126 17 214     7 215
2471949 2471949 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 2018   grade_7 39 0 8   1 0     1   0   21 28 0   0   5   39       1.0 49 39 0 8   1 0     1   0   21 28 0   0 5 39     1 49
2471939 2471939 WA Thurston   school   34901   WA HE LUT Indian School Agency   5496 Wa He Lut Indian School             2018   grade_7 0 0 0   9 0     0   1   5 5 0   0   0   9       0.0 10 0 0 0   9 0     0   1   5 5 0   0 0 9     0 10
2471920 2471920 WA King   school 5309300 17402   Vashon Island School District 530930001589 3667 McMurray Middle School   Regular School No Middle 06 08 2018   grade_7 104 0 13   0 3     0   18   73 65 0   3   0   29       16.0 138 104 0 13   0 3     0   18   73 65 0   3 0 29     16 138
2471914 2471914 WA King   school 5309300 17402   Vashon Island School District 530930002720 1822 Family Link   Alternative School No Other KG 12 2018   grade_7 6 0 1   0 0     0   0   5 2 0   0   0   3       0.0 7 6 0 1   0 0     0   0   5 2 0   0 0 3     0 7
2471901 2471901 WA King   school 5309300 17402   Vashon Island School District 530930001394 4468 Chautauqua Elementary   Regular School No Elementary PK 05 2018   grade_7 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
2471878 2471878 WA Clark   school 5309270 6037   Vancouver School District 530927003246 5149 Vancouver Virtual Learning Academy   Alternative School No High 06 12 2018   grade_7 4 0 1   0 0     0   0   1 4 0   0   0   3       0.0 5 4 0 1   0 0     0   0   1 4 0   0 0 3     0 5
2471870 2471870 WA Clark   school 5309270 6037   Vancouver School District 530927002508 1689 Vancouver School of Arts and Academics   Regular School No High 06 12 2018   grade_7 70 2 10   1 4     1   3   30 61 0   0   0   15       2.0 91 70 2 10   1 4     1   3   30 61 0   0 0 15     2 91
2471862 2471862 WA Clark   school 5309270 6037   Vancouver School District 530927003415 5271 Vancouver iTech Preparatory   Regular School No High 06 12 2018   grade_7 34 0 10   0 3     0   9   42 14 0   0   0   19       9.0 56 34 0 10   0 3     0   9   42 14 0   0 0 19     9 56
2471853 2471853 WA Clark   school 5309270 6037   Vancouver School District 530927002943 3556 Vancouver Home Connection   Alternative School No Other KG 12 2018   grade_7 9 0 2   0 0     0   2   4 9 0   0   0   5       0.0 13 9 0 2   0 0     0   2   4 9 0   0 0 5     0 13
2471841 2471841 WA Clark   school 5309270 6037   Vancouver School District 530927002944 4591 Thomas Jefferson Middle School   Regular School No Middle 06 08 2018   grade_7 208 4 32   4 4     3   26   138 143 0   7   4   77       11.0 281 208 4 32   4 4     3   26   138 143 0   7 4 77     11 281
2471786 2471786 WA Clark   school 5309270 6037   Vancouver School District 530927001577 3146 Mcloughlin Middle School   Regular School No Middle 06 08 2018   grade_7 107 12 159   0 10     16   21   151 174 0   90   10   264       11.0 325 107 12 159   0 10     16   21   151 174 0   90 10 264     11 325
2471755 2471755 WA Clark   school 5309270 6037   Vancouver School District 530927001570 3543 Jason Lee Middle School   Regular School No Middle 06 08 2018   grade_7 143 5 56   0 16     4   16   128 112 0   20   4   107       9.0 240 143 5 56   0 16     4   16   128 112 0   20 4 107     9 240
2471708 2471708 WA Clark   school 5309270 6037   Vancouver School District 530927001562 3902 Gaiser Middle School   Regular School No Middle 06 08 2018   grade_7 152 10 77   3 12     3   22   154 125 0   31   8   166       6.0 279 152 10 77   3 12     3   22   154 125 0   31 8 166     6 279
2471691 2471691 WA Clark   school 5309270 6037   Vancouver School District 530927002408 1574 Fir Grove Childrens Center   Special Education School No Other KG 12 2018   grade_7 1 0 2   0 0     0   1   3 1 0   0   0   2       0.0 4 1 0 2   0 0     0   1   3 1 0   0 0 2     0 4
2471664 2471664 WA Clark   school 5309270 6037   Vancouver School District 530927002018 4503 Discovery Middle School   Regular School No Middle 06 08 2018   grade_7 89 10 87   1 8     2   19   117 99 0   36   13   165       12.0 216 89 10 87   1 8     2   19   117 99 0   36 13 165     12 216
2471640 2471640 WA Clark   school 5309270 6037   Vancouver School District 530927000578 4406 Alki Middle School   Regular School No Middle 06 08 2018   grade_7 166 4 21   1 7     0   22   106 115 0   8   1   57       7.0 221 166 4 21   1 7     0   22   106 115 0   8 1 57     7 221
2471635 2471635 WA Stevens   school 5309240 33070   Valley School District 530924001555 2405 Valley School   Regular School No Elementary KG 08 2018   grade_7 19 0 0   1 0     0   3   12 11 0   0   1   18       0.0 23 19 0 0   1 0     0   3   12 11 0   0 1 18     0 23
2471618 2471618 WA Stevens   school 5309240 33070   Valley School District 530924003107 1932 Columbia Virtual Academy   Alternative School No Elementary KG 08 2018   grade_7 47 0 11   0 4     1   3   30 36 0   3   0   1       0.0 66 47 0 11   0 4     1   3   30 36 0   3 0 1     0 66
2471597 2471597 WA Pierce   school 5309180 27083   University Place School District 530918001550 3296 Narrows View Intermediate   Regular School No Middle 05 07 2018   grade_7 124 18 44   3 23     2   38   114 138 0   9   4   100       19.0 252 124 18 44   3 23     2   38   114 138 0   9 4 100     19 252
2471585 2471585 WA Pierce   school 5309180 27083   University Place School District 530918002383 4325 Drum Intermediate   Regular School No Middle 05 07 2018   grade_7 84 30 33   1 21     6   25   98 102 0   11   1   87       10.0 200 84 30 33   1 21     6   25   98 102 0   11 1 87     10 200
2471563 2471563 WA Yakima   school 5309150 39002   Union Gap School District 530915002382 2714 Union Gap School   Regular School No Elementary PK 08 2018   grade_7 8 0 46   1 3     0   0   34 24 0   10   0   54       0.0 58 8 0 46   1 3     0   0   34 24 0   10 0 54     0 58
2471554 2471554 WA Thurston   school 5309100 34033   Tumwater School District 530910001545 3612 Tumwater Middle School   Regular School No Middle 06 08 2018   grade_7 173 4 36   0 8     0   24   122 123 0   2   8   76       15.0 245 173 4 36   0 8     0   24   122 123 0   2 8 76     15 245
2471500 2471500 WA Thurston   school 5309100 34033   Tumwater School District 530910001734 4452 George Washington Bush Middle Sch   Regular School No Middle 06 08 2018   grade_7 186 4 39   1 8     2   30   136 134 0   3   7   85       11.0 270 186 4 39   1 8     2   30   136 134 0   3 7 85     11 270
2471456 2471456 WA King   school 5308130 17406   Tukwila School District 530813001342 2564 Showalter Middle School   Regular School No Middle 06 08 2018   grade_7 24 41 74   2 65     11   8   123 102 0   63   17   175       3.0 225 24 41 74   2 65     11   8   123 102 0   63 17 175     3 225
2471438 2471438 WA Klickitat   school 5309060 20400   Trout Lake School District 530906001539 2676 Trout Lake School   Regular School No High 05 12 2018   grade_7 11 0 2   2 0     0   1   6 10 0   0   0   0       0.0 16 11 0 2   2 0     0   1   6 10 0   0 0 0     0 16
2471422 2471422 WA Cowlitz   school 5309030 8130   Toutle Lake School District 530903001538 2560 Toutle Lake High School   Regular School No High 07 12 2018   grade_7 46 1 5   3 0     0   1   28 28 0   0   2   26       3.0 56 46 1 5   3 0     0   1   28 28 0   0 2 26     3 56
2471404 2471404 WA Walla Walla   school 5309000 36300   Touchet School District 530900001536 2160 Touchet Elem & High School   Regular School No Other KG 12 2018   grade_7 2 0 10   0 0     0   0   9 3 0   2   0   9       0.0 12 2 0 10   0 0     0   0   9 3 0   2 0 9     0 12
2471383 2471383 WA Yakima   school 5308970 39202   Toppenish School District 530897001535 2264 Toppenish Middle School   Regular School No Middle 06 08 2018   grade_7 7 0 261   39 0     0   6   149 164 0   130   11   292       10.0 313 7 0 261   39 0     0   6   149 164 0   130 11 292     10 313
2471372 2471372 WA Yakima   school 5308970 39202   Toppenish School District 530897003385 5262 Northwest Allprep   Regular School No Other KG 12 2018   grade_7 71 8 6   3 13     1   0   52 50 0   1   0   11       0.0 102 71 8 6   3 13     1   0   52 50 0   1 0 11     0 102
2471336 2471336 WA Okanogan   school 5308940 24404   Tonasket School District 530894001647 4196 Tonasket Middle School   Regular School No Middle 06 08 2018   grade_7 45 0 49   0 0     1   4   48 51 0   17   9   76       0.0 99 45 0 49   0 0     1   4   48 51 0   17 9 76     0 99
2471319 2471319 WA Lewis   school 5308910 21237   Toledo School District 530891001528 3977 Toledo Middle School   Regular School No Middle 06 08 2018   grade_7 47 0 8   2 0     0   3   29 31 0   2   5   37       0.0 60 47 0 8   2 0     0   3   29 31 0   2 5 37     0 60
2471300 2471300 WA Lewis   school 5308910 21237   Toledo School District 530891003310 5190 Cowlitz Prairie Academy   Regular School No High 07 12 2018   grade_7 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
2471290 2471290 WA Kittitas   school 5308850 19400   Thorp School District 530885001525 2514 Thorp Elem & Jr Sr High   Regular School No Other KG 12 2018   grade_7 14 0 1   0 0     0   0   7 8 0   0   0   10       0.0 15 14 0 1   0 0     0   0   7 8 0   0 0 10     0 15
2471278 2471278 WA Thurston   school 5308820 34402   Tenino School District 530882001523 3795 Tenino Middle School   Regular School No Middle 06 08 2018   grade_7 73 0 9   0 0     0   7   55 34 0   3   5   39       4.0 89 73 0 9   0 0     0   7   55 34 0   3 5 39     4 89
2471258 2471258 WA Whitman   school 5308790 38265   Tekoa School District 530879001521 3418 Tekoa High School   Regular School No High 07 12 2018   grade_7 18 0 2   0 0     0   0   9 11 0   0   0   11       0.0 20 18 0 2   0 0     0   0   9 11 0   0 0 11     0 20
2471231 2471231 WA King   school 5308760 17409   Tahoma School District 530876002979 3341 Summit Trail Middle School   Regular School No Middle 06 08 2018   grade_7 276 7 26   0 13     0   21   171 172 0   6   1   34       27.0 343 276 7 26   0 13     0   21   171 172 0   6 1 34     27 343
2471211 2471211 WA King   school 5308760 17409   Tahoma School District 530876001515 3937 Maple View Middle School   Regular School No Middle 06 08 2018   grade_7 204 7 37   3 20     5   41   152 165 0   14   4   67       24.0 317 204 7 37   3 20     5   41   152 165 0   14 4 67     24 317
2471176 2471176 WA Grays Harbor   school 5308730 14077   Taholah School District 530873002956 5032 Taholah Elementary & Middle School   Regular School No Elementary KG 08 2018   grade_7 0 0 2   12 0     0   0   4 10 0   0   3   13       0.0 14 0 0 2   12 0     0   0   4 10 0   0 3 13     0 14
2471141 2471141 WA Pierce   school 5308700 27010   Tacoma School District 530870001508 3116 Wainwright   Regular School No Middle 04 07 2018   grade_7 42 15 9   2 3     1   10   36 46 0   4   4   40       8.0 82 42 15 9   2 3     1   10   36 46 0   4 4 40     8 82
2471135 2471135 WA Pierce   school 5308700 27010   Tacoma School District 530870001507 3448 Truman   Regular School No Middle 06 08 2018   grade_7 114 47 41   3 19     7   19   128 122 0   23   21   162       12.0 250 114 47 41   3 19     7   19   128 122 0   23 21 162     12 250
2471113 2471113 WA Pierce   school 5308700 27010   Tacoma School District 530870001504 2359 Stewart   Regular School No Middle 06 08 2018   grade_7 48 28 51   2 12     10   16   79 88 0   19   10   131       8.0 167 48 28 51   2 12     10   16   79 88 0   19 10 131     8 167
2471093 2471093 WA Pierce   school 5308700 27010   Tacoma School District 530870003275 5192 Special Services   Alternative School No Other PK 12 2018   grade_7 1 2 1   0 0     0   1   4 1 0   0   2   3       0.0 5 1 2 1   0 0     0   1   4 1 0   0 2 3     0 5
2471006 2471006 WA Pierce   school 5308700 27010   Tacoma School District 530870001487 3244 Meeker   Regular School No Middle 06 08 2018   grade_7 108 17 20   2 25     10   25   126 81 0   12   4   72       8.0 207 108 17 20   2 25     10   25   126 81 0   12 4 72     8 207
2470994 2470994 WA Pierce   school 5308700 27010   Tacoma School District 530870001483 2376 Mason   Regular School No Middle 06 08 2018   grade_7 138 13 25   1 14     2   34   121 106 0   2   1   81       17.0 227 138 13 25   1 14     2   34   121 106 0   2 1 81     17 227
2470928 2470928 WA Pierce   school 5308700 27010   Tacoma School District 530870001473 2338 Jason Lee   Regular School No Middle 06 08 2018   grade_7 70 49 32   3 7     5   13   84 95 0   4   19   117       8.0 179 70 49 32   3 7     5   13   84 95 0   4 19 117     8 179
2470913 2470913 WA Pierce   school 5308700 27010   Tacoma School District 530870001471 2377 Gray   Regular School No Middle 06 08 2018   grade_7 46 46 41   0 17     16   18   99 85 0   19   17   149       3.0 184 46 46 41   0 17     16   18   99 85 0   19 17 149     3 184
2470880 2470880 WA Pierce   school 5308700 27010   Tacoma School District 530870003299 5170 First Creek Middle School   Regular School No Middle 06 08 2018   grade_7 49 44 84   6 28     18   17   145 101 0   47   7   212       7.0 246 49 44 84   6 28     18   17   145 101 0   47 7 212     7 246
2470820 2470820 WA Pierce   school 5308700 27010   Tacoma School District 530870001458 3397 Bryant   Regular School No Elementary PK 08 2018   grade_7 34 2 4   0 4     1   4   27 22 0   1   1   18       3.0 49 34 2 4   0 4     1   4   27 22 0   1 1 18     3 49
2470780 2470780 WA Pierce   school 5308700 27010   Tacoma School District 530870001454 3054 Baker   Regular School No Middle 06 08 2018   grade_7 57 50 66   2 33     12   25   125 120 0   26   22   194       10.0 245 57 50 66   2 33     12   25   125 120 0   26 22 194     10 245
2470768 2470768 WA Pierce   school 5308700 27010   Tacoma School District 530870003155 4575 Angelo Giaudrone Middle School   Regular School No Middle 06 08 2018   grade_7 53 48 46   2 27     8   28   118 94 0   21   21   157       12.0 212 53 48 46   2 27     8   28   118 94 0   21 21 157     12 212
2470763 2470763 WA Kitsap   school 5300328 18902   Suquamish Tribal Education Department 530032803493 5319 Chief Kitsap Academy   Regular School No Other KG 12 2018   grade_7 3 0 0   3 0     1   2   8 1 0   0   0   6       0.0 9 3 0 0   3 0     1   2   8 1 0   0 0 6     0 9
2470740 2470740 WA Yakima   school 5308670 39201   Sunnyside School District 530867003037 5049 Sierra Vista Middle School   Regular School No Middle 06 08 2018   grade_7 17 1 224   0 0     0   3   134 111 0   81   8   212       1.0 245 17 1 224   0 0     0   3   134 111 0   81 8 212     1 245
2470719 2470719 WA Yakima   school 5308670 39201   Sunnyside School District 530867001451 3313 Harrison Middle School   Regular School No Middle 06 08 2018   grade_7 15 0 282   0 0     0   5   155 147 0   91   15   243       6.0 302 15 0 282   0 0     0   5   155 147 0   91 15 243     6 302
2470697 2470697 WA Pierce   school 5308610 27320   Sumner School District 530861001447 3499 Sumner Middle School   Regular School No Middle 06 08 2018   grade_7 166 2 63   5 10     0   17   133 130 0   15   5   120       19.0 263 166 2 63   5 10     0   17   133 130 0   15 5 120     19 263
2470687 2470687 WA Pierce   school 5308610 27320   Sumner School District 530861002580 4502 Mountain View Middle School   Regular School No Middle 06 08 2018   grade_7 148 4 26   4 2     0   23   110 97 0   7   6   61       18.0 207 148 4 26   4 2     0   23   110 97 0   7 6 61     18 207
2470668 2470668 WA Pierce   school 5308610 27320   Sumner School District 530861001808 4132 Lakeridge Middle School   Regular School No Middle 06 08 2018   grade_7 161 2 17   0 6     0   17   104 99 0   1   3   57       15.0 203 161 2 17   0 6     0   17   104 99 0   1 3 57     15 203
2470617 2470617 WA Stevens   school 5308580 33202   Summit Valley School District 530858001203 4394 Summit Valley School   Regular School No Elementary PK 08 2018   grade_7 6 0 0   0 0     0   0   2 4 0   0   0   4       0.0 6 6 0 0   0 0     0   0   2 4 0   0 0 4     0 6

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