Data source: Big Local News · About: Big Local

4,566 rows where grade = "grade_7" and state = "WA" sorted by rowid descending

View and edit SQL

year

grade

  • grade_7 · 4,566
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
2946933 WA Yakima   school 5310170 39205   Zillah School District 531017002502 4481 Zillah Middle School   Regular School No Middle 07 08 2021   grade_7 31 0 46   2 1     0   4   47 37 0   3   0   54       2.0 84 31 0 46   2 1     0   4   47 37 0   3 0 54     2 84
2946907 WA Thurston   school 5310140 34002   Yelm School District 531014001717 2481 Yelm Middle School   Regular School No Middle 06 08 2021   grade_7 148 3 38   6 7     3   33   127 111 0   5   4   114       11.0 238 148 3 38   6 7     3   33   127 111 0   5 4 114     11 238
2946886 WA Thurston   school 5310140 34002   Yelm School District 531014003068 5052 Ridgeline Middle School   Regular School No Middle 06 08 2021   grade_7 142 4 49   2 1     1   32   119 112 0   6   1   119       19.0 231 142 4 49   2 1     1   32   119 112 0   6 1 119     19 231
2946850 WA Yakima   school 5310110 39007   Yakima School District 531011003324 5224 Yakima Satellite Alternative Programs   Alternative School No High 06 12 2021   grade_7 1 0 1   0 0     0   0   1 1 0   0   0   2       0.0 2 1 0 1   0 0     0   0   1 1 0   0 0 2     0 2
2946840 WA Yakima   school 5310110 39007   Yakima School District 531011003263 5153 Yakima Online   Alternative School No High 06 12 2021   grade_7 5 0 7   0 0     0   3   8 7 0   0   0   9       1.0 15 5 0 7   0 0     0   3   8 7 0   0 0 9     1 15
2946833 WA Yakima   school 5310110 39007   Yakima School District 531011001710 3368 Wilson Middle School   Regular School No Middle 06 08 2021   grade_7 75 4 211   5 1     1   16   146 167 0   37   10   225       26.0 313 75 4 211   5 1     1   16   146 167 0   37 10 225     26 313
2946821 WA Yakima   school 5310110 39007   Yakima School District 531011001708 2314 Washington Middle School   Regular School No Middle 06 08 2021   grade_7 8 1 266   4 0     0   4   147 136 0   90   9   262       14.0 283 8 1 266   4 0     0   4   147 136 0   90 9 262     14 283
2946765 WA Yakima   school 5310110 39007   Yakima School District 531011001814 3817 Martin Luther King Jr Elementary   Regular School No Elementary KG 05 2021   grade_7 0 0 3   1 0     0   0   2 2 0   3   0   3       0.0 4 0 0 3   1 0     0   0   2 2 0   3 0 3     0 4
2946756 WA Yakima   school 5310110 39007   Yakima School District 531011001698 3615 Lewis & Clark Middle School   Regular School No Middle 06 08 2021   grade_7 31 0 256   4 0     0   7   136 162 0   91   5   262       6.0 298 31 0 256   4 0     0   7   136 162 0   91 5 262     6 298
2946725 WA Yakima   school 5310110 39007   Yakima School District 531011001691 2410 Franklin Middle School   Regular School No Middle 06 08 2021   grade_7 52 2 230   2 3     1   4   140 154 0   75   10   239       13.0 294 52 2 230   2 3     1   4   140 154 0   75 10 239     13 294
2946713 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2021   grade_7 7 0 18   1 0     0   0   7 19 0   3   0   14       1.0 26 7 0 18   1 0     0   0   7 19 0   3 0 14     1 26
2946676 WA Cowlitz   school 5310050 8404   Woodland School District 531005003509 5409 Woodland Middle School   Regular School No Middle 05 08 2021   grade_7 109 1 45   2 0     0   3   77 83 0   9   7   62       4.0 160 109 1 45   2 0     0   3   77 83 0   9 7 62     4 160
2946654 WA Cowlitz   school 5310050 8404   Woodland School District 531005003371 5246 Lewis River Academy   Alternative School No Other KG 12 2021   grade_7 20 0 2   0 0     0   1   9 14 0   0   0   8       0.0 23 20 0 2   0 0     0   1   9 14 0   0 0 8     0 23
2946635 WA Klickitat   school 5310020 20094   Wishram School District 531002001680 2605 Wishram High And Elementary Schl   Regular School No Other PK 12 2021   grade_7 2 0 0   0 0     0   0   1 1 0   0   0   2       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 2     0 2
2946621 WA Grays Harbor   school 5309990 14117   Wishkah Valley School District 530999001679 3375 Wishkah Valley Elementary/High School   Regular School No Other KG 12 2021   grade_7 14 0 0   0 0     0   0   8 6 0   0   0   10       1.0 14 14 0 0   0 0     0   0   8 6 0   0 0 10     1 14
2946593 WA Lewis   school 5309930 21232   Winlock School District 530993002392 4369 Winlock Middle School   Regular School No Middle 06 08 2021   grade_7 37 1 12   0 0     0   2   28 24 0   3   1   49       2.0 52 37 1 12   0 0     0   2   28 24 0   3 1 49     2 52
2946588 WA Grant   school 5309900 13167   Wilson Creek School District 530990001675 2473 Wilson Creek High   Regular School No High 07 12 2021   grade_7 5 0 3   0 0     0   0   6 2 0   0   0   4       0.0 8 5 0 3   0 0     0   0   6 2 0   0 0 4     0 8
2946572 WA Pacific   school 5309870 25160   Willapa Valley School District 530987001673 2542 Willapa Valley Middle-High   Regular School No High 06 12 2021   grade_7 29 0 5   0 0     0   4   13 26 0   0   0   15       1.0 39 29 0 5   0 0     0   4   13 26 0   0 0 15     1 39
2946556 WA Lincoln   school 5309840 22200   Wilbur School District 530984001668 3289 Wilbur Secondary School   Regular School No High 07 12 2021   grade_7 13 0 1   4 0     0   2   12 8 0   0   4   13       0.0 20 13 0 1   4 0     0   2   12 8 0   0 4 13     0 20
2946537 WA Klickitat   school 5309810 20405   White Salmon Valley School District 530981001666 3394 Wayne M Henkle Middle School   Regular School No Middle 07 08 2021   grade_7 63 2 37   1 0     0   6   57 52 0   18   0   57       1.0 109 63 2 37   1 0     0   6   57 52 0   18 0 57     1 109
2946492 WA Pierce   school 5309780 27416   White River School District 530978003005 3458 Glacier Middle School   Regular School No Middle 06 08 2021   grade_7 230 0 46   5 4     2   21   143 165 0   6   4   115       8.0 308 230 0 46   5 4     2   21   143 165 0   6 4 115     8 308
2946471 WA Lewis   school 5309750 21303   White Pass School District 530975001659 2859 White Pass Jr. Sr. High School   Regular School No High 07 12 2021   grade_7 23 0 3   0 0     0   2   15 13 0   0   4   19       0.0 28 23 0 3   0 0     0   2   15 13 0   0 4 19     0 28
2946438 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972003619 5505 WEST VALLEY VIRTUAL ACADEMY 7-8   Regular School No Middle 07 08 2021   grade_7 19 1 3   0 0     0   0   13 10 0   1   0   6       0.0 23 19 1 3   0 0     0   0   13 10 0   1 0 6     0 23
2946431 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972002545 4506 West Valley Middle School   Regular School No Middle 05 06 2021   grade_7 1 0 0   0 0     0   0   1 0 0   0   1   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 1 1     0 1
2946426 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001653 4040 West Valley Jr High   Regular School No Middle 07 08 2021   grade_7 219 7 173   3 11     0   20   238 194 1   33   4   217       15.0 433 219 7 173   3 11     0   20   238 194 1   33 4 217     15 433
2946381 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969002685 1755 West Valley City School   Alternative School No Middle 05 08 2021   grade_7 41 2 3   0 1     0   4   22 29 0   2   1   24       3.0 51 41 2 3   0 1     0   4   22 29 0   2 1 24     3 51
2946339 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001645 3538 Centennial Middle School   Regular School No Middle 06 08 2021   grade_7 155 5 30   4 3     1   20   117 100 1   11   9   124       13.0 218 155 5 30   4 3     1   20   117 100 1   11 9 124     13 218
2946323 WA Chelan   school 5309660 4246   Wenatchee School District 530966003727 5637 Wenatchee Internet Academy   Regular School No Other KG 12 2021   grade_7 14 0 14   0 2     0   1   18 13 0   3   1   11       2.0 31 14 0 14   0 2     0   1   18 13 0   3 1 11     2 31
2946297 WA Chelan   school 5309660 4246   Wenatchee School District 530966003678 5569 Valley Academy of Learning K-8   Alternative School No Elementary KG 08 2021   grade_7 20 0 3   0 0     0   0   17 6 0   0   0   0       3.0 23 20 0 3   0 0     0   0   17 6 0   0 0 0     3 23
2946278 WA Chelan   school 5309660 4246   Wenatchee School District 530966001636 3269 Special Education School   Special Education School No Other PK 09 2021   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
2946270 WA Chelan   school 5309660 4246   Wenatchee School District 530966001635 3210 Pioneer Middle School   Regular School No Middle 06 08 2021   grade_7 85 0 116   1 1     0   2   127 78 0   40   12   111       10.0 205 85 0 116   1 1     0   2   127 78 0   40 12 111     10 205
2946266 WA Chelan   school 5309660 4246   Wenatchee School District 530966001634 3370 Orchard Middle School   Regular School No Middle 06 08 2021   grade_7 42 2 91   0 0     0   4   63 76 0   32   6   95       1.0 139 42 2 91   0 0     0   4   63 76 0   32 6 95     1 139
2946237 WA Chelan   school 5309660 4246   Wenatchee School District 530966001006 4432 Foothills Middle School   Regular School No Middle 06 08 2021   grade_7 92 2 90   1 7     1   5   111 87 0   35   6   99       6.0 198 92 2 90   1 7     1   5   111 87 0   35 6 99     6 198
2946217 WA Stevens   school 5309630 33049   Wellpinit School District #49 530963003150 4232 Wellpinit Middle School   Regular School No Middle 06 08 2021   grade_7 1 1 2   24 0     0   2   16 14 0   0   0   29       0.0 30 1 1 2   24 0     0   2   16 14 0   0 0 29     0 30
2946195 WA Douglas   school 5309600 9209   Waterville School District 530960001628 2162 Waterville High School   Regular School No High 06 12 2021   grade_7 7 0 2   2 0     0   2   6 7 0   0   2   10       0.0 13 7 0 2   2 0     0   2   6 7 0   0 2 10     0 13
2946162 WA Clark   school 5309540 6112   Washougal School District 530954003730 5615 Washougal Learning Academy   Alternative School No Other KG 12 2021   grade_7 15 0 2   0 0     0   0   8 9 0   0   0   4       1.0 17 15 0 2   0 0     0   0   8 9 0   0 0 4     1 17
2946145 WA Clark   school 5309540 6112   Washougal School District 530954001892 4207 Jemtegaard Middle School   Regular School No Middle 06 08 2021   grade_7 116 2 20   1 1     0   15   87 68 0   5   4   77       8.0 155 116 2 20   1 1     0   15   87 68 0   5 4 77     8 155
2946113 WA Clark   school 5309540 6112   Washougal School District 530954002709 4549 Canyon Creek Middle School   Regular School No Middle 06 08 2021   grade_7 63 0 8   0 1     0   1   39 34 0   0   0   17       2.0 73 63 0 8   0 1     0   1   39 34 0   0 0 17     2 73
2946101 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 2021   grade_7 3 0 6   1 0     0   0   6 4 0   0   0   5       0.0 10 3 0 6   1 0     0   0   6 4 0   0 0 5     0 10
2946089 WA Grant   school 5309510 13146   Warden School District 530951001620 3909 Warden Middle School   Regular School No Middle 06 08 2021   grade_7 12 0 59   0 0     0   1   36 36 0   16   1   66       1.0 72 12 0 59   0 0     0   1   36 36 0   16 1 66     1 72
2946072 WA Yakima   school 5309480 39207   Wapato School District 530948001615 2131 Wapato Middle School   Regular School No Middle 06 08 2021   grade_7 3 0 214   64 3     0   17   169 132 0   143   5   272       7.0 301 3 0 214   64 3     0   17   169 132 0   143 5 272     7 301
2946037 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945003774 5636 Walla Walla Online   Alternative School No Other KG 12 2021   grade_7 17 0 11   0 1     0   0   14 14 1   2   0   8       5.0 29 17 0 11   0 1     0   0   14 14 1   2 0 8     5 29
2946001 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001605 2780 Pioneer Middle School   Regular School No Middle 06 08 2021   grade_7 91 1 69   1 0     0   8   82 88 0   21   0   102       8.0 170 91 1 69   1 0     0   8   82 88 0   21 0 102     8 170
2945983 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001601 3510 Garrison Middle School   Regular School No Middle 06 08 2021   grade_7 94 0 96   0 2     0   9   99 102 0   19   4   106       11.0 201 94 0 96   0 2     0   9   99 102 0   19 4 106     11 201
2945952 WA Walla Walla   school 5309390 36401   Waitsburg School District 530939002492 2174 Preston Hall Middle School   Regular School No Middle 06 08 2021   grade_7 12 1 2   1 1     0   0   10 7 0   0   0   8       1.0 17 12 1 2   1 1     0   0   10 7 0   0 0 8     1 17
2945948 WA Grant   school 5309360 13073   Wahluke School District 530936003264 5144 Wahluke Junior High   Regular School No Middle 06 08 2021   grade_7 5 0 209   1 0     0   0   107 108 0   91   23   203       3.0 215 5 0 209   1 0     0   0   107 108 0   91 23 203     3 215
2945903 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 2021   grade_7 23 0 2   0 0     0   4   14 15 0   0   2   17       0.0 29 23 0 2   0 0     0   4   14 15 0   0 2 17     0 29
2945893 WA Thurston   school   34901   WA HE LUT Indian School Agency   5496 Wa He Lut Indian School             2021   grade_7 0 1 2   11 0     0   1   7 8 0   0   2   15       0.0 15 0 1 2   11 0     0   1   7 8 0   0 2 15     0 15
2945874 WA King   school 5309300 17402   Vashon Island School District 530930001589 3667 McMurray Middle School   Regular School No Middle 06 08 2021   grade_7 80 0 18   0 0     0   15   52 61 0   3   1   24       4.0 113 80 0 18   0 0     0   15   52 61 0   3 1 24     4 113
2945868 WA King   school 5309300 17402   Vashon Island School District 530930002720 1822 Family Link   Alternative School No Other KG 12 2021   grade_7 6 0 0   0 0     0   2   3 5 0   1   0   2       1.0 8 6 0 0   0 0     0   2   3 5 0   1 0 2     1 8
2945856 WA King   school 5309300 17402   Vashon Island School District 530930001394 4468 Chautauqua Elementary   Regular School No Elementary PK 05 2021   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
2945830 WA Clark   school 5309270 6037   Vancouver School District 530927003246 5149 Vancouver Virtual Learning Academy   Alternative School No High 06 12 2021   grade_7 6 1 2   0 0     0   2   6 5 0   2   2   7       1.0 11 6 1 2   0 0     0   2   6 5 0   2 2 7     1 11
2945817 WA Clark   school 5309270 6037   Vancouver School District 530927002508 1689 Vancouver School of Arts and Academics   Regular School No High 06 12 2021   grade_7 59 1 14   0 5     0   14   26 67 0   1   0   23       5.0 93 59 1 14   0 5     0   14   26 67 0   1 0 23     5 93
2945809 WA Clark   school 5309270 6037   Vancouver School District 530927003415 5271 Vancouver iTech Preparatory   Regular School No High 06 12 2021   grade_7 53 2 18   0 7     1   9   62 28 0   4   0   29       11.0 90 53 2 18   0 7     1   9   62 28 0   4 0 29     11 90
2945800 WA Clark   school 5309270 6037   Vancouver School District 530927002943 3556 Vancouver Home Connection   Alternative School No Other KG 12 2021   grade_7 8 0 4   2 0     0   2   10 6 0   2   3   11       1.0 16 8 0 4   2 0     0   2   10 6 0   2 3 11     1 16
2945790 WA Clark   school 5309270 6037   Vancouver School District 530927002944 4591 Thomas Jefferson Middle School   Regular School No Middle 06 08 2021   grade_7 180 1 53   2 15     1   25   133 144 0   17   0   73       15.0 277 180 1 53   2 15     1   25   133 144 0   17 0 73     15 277
2945734 WA Clark   school 5309270 6037   Vancouver School District 530927001577 3146 Mcloughlin Middle School   Regular School No Middle 06 08 2021   grade_7 107 7 173   3 8     23   17   169 169 0   93   9   269       8.0 338 107 7 173   3 8     23   17   169 169 0   93 9 269     8 338
2945702 WA Clark   school 5309270 6037   Vancouver School District 530927001570 3543 Jason Lee Middle School   Regular School No Middle 06 08 2021   grade_7 124 5 49   2 9     3   18   117 93 0   11   5   110       11.0 210 124 5 49   2 9     3   18   117 93 0   11 5 110     11 210
2945653 WA Clark   school 5309270 6037   Vancouver School District 530927001562 3902 Gaiser Middle School   Regular School No Middle 06 08 2021   grade_7 118 10 104   2 11     11   27   124 159 0   38   11   180       13.0 283 118 10 104   2 11     11   27   124 159 0   38 11 180     13 283
2945636 WA Clark   school 5309270 6037   Vancouver School District 530927002408 1574 Fir Grove Childrens Center   Special Education School No Other KG 12 2021   grade_7 5 1 0   0 0     0   0   4 2 0   0   0   5       0.0 6 5 1 0   0 0     0   0   4 2 0   0 0 5     0 6
2945609 WA Clark   school 5309270 6037   Vancouver School District 530927002018 4503 Discovery Middle School   Regular School No Middle 06 08 2021   grade_7 86 8 82   0 6     6   17   99 106 0   29   7   134       4.0 205 86 8 82   0 6     6   17   99 106 0   29 7 134     4 205
2945586 WA Clark   school 5309270 6037   Vancouver School District 530927000578 4406 Alki Middle School   Regular School No Middle 06 08 2021   grade_7 178 3 41   1 11     0   23   137 120 0   11   0   69       11.0 257 178 3 41   1 11     0   23   137 120 0   11 0 69     11 257
2945581 WA Stevens   school 5309240 33070   Valley School District 530924001555 2405 Valley School   Regular School No Elementary KG 08 2021   grade_7 16 0 1   0 0     0   2   9 10 0   0   0   16       0.0 19 16 0 1   0 0     0   2   9 10 0   0 0 16     0 19
2945564 WA Stevens   school 5309240 33070   Valley School District 530924003107 1932 Columbia Virtual Academy   Alternative School No Elementary KG 08 2021   grade_7 88 4 16   1 6     1   11   67 60 0   5   2   11       0.0 127 88 4 16   1 6     1   11   67 60 0   5 2 11     0 127
2945542 WA Pierce   school 5309180 27083   University Place School District 530918001550 3296 Narrows View Intermediate   Regular School No Middle 05 07 2021   grade_7 92 22 37   0 19     4   49   106 117 0   6   4   83       8.0 223 92 22 37   0 19     4   49   106 117 0   6 4 83     8 223
2945531 WA Pierce   school 5309180 27083   University Place School District 530918002383 4325 Drum Intermediate   Regular School No Middle 05 07 2021   grade_7 93 24 34   2 16     3   40   109 103 0   4   3   89       7.0 212 93 24 34   2 16     3   40   109 103 0   4 3 89     7 212
2945510 WA Yakima   school 5309150 39002   Union Gap School District 530915002382 2714 Union Gap School   Regular School No Elementary PK 08 2021   grade_7 14 0 61   0 0     0   1   43 33 0   12   5   71       4.0 76 14 0 61   0 0     0   1   43 33 0   12 5 71     4 76
2945499 WA Thurston   school 5309100 34033   Tumwater School District 530910003772 5629 Tumwater Virtual Academy   Regular School No Other KG 12 2021   grade_7 26 1 2   1 0     0   3   18 15 0   0   0   6       3.0 33 26 1 2   1 0     0   3   18 15 0   0 0 6     3 33
2945487 WA Thurston   school 5309100 34033   Tumwater School District 530910001545 3612 Tumwater Middle School   Regular School No Middle 06 08 2021   grade_7 146 4 20   1 6     2   24   100 102 1   2   5   65       7.0 203 146 4 20   1 6     2   24   100 102 1   2 5 65     7 203
2945438 WA Thurston   school 5309100 34033   Tumwater School District 530910001734 4452 George Washington Bush Middle Sch   Regular School No Middle 06 08 2021   grade_7 174 4 26   1 1     0   21   126 101 0   2   6   88       9.0 227 174 4 26   1 1     0   21   126 101 0   2 6 88     9 227
2945410 WA King   school 5308130 17406   Tukwila School District 530813003650 5536 Tukwila Online Learning   Alternative School No High 06 12 2021   grade_7 0 1 0   0 0     0   0   1 0 0   0   0   1       0.0 1 0 1 0   0 0     0   0   1 0 0   0 0 1     0 1
2945390 WA King   school 5308130 17406   Tukwila School District 530813001342 2564 Showalter Middle School   Regular School No Middle 06 08 2021   grade_7 21 35 73   2 52     9   17   102 99 8   63   4   167       3.0 209 21 35 73   2 52     9   17   102 99 8   63 4 167     3 209
2945372 WA Klickitat   school 5309060 20400   Trout Lake School District 530906001539 2676 Trout Lake School   Regular School No High 05 12 2021   grade_7 12 0 5   0 1     0   0   9 9 0   1   0   0       0.0 18 12 0 5   0 1     0   0   9 9 0   1 0 0     0 18
2945357 WA Cowlitz   school 5309030 8130   Toutle Lake School District 530903001538 2560 Toutle Lake High School   Regular School No High 07 12 2021   grade_7 51 0 2   1 0     0   4   26 32 0   0   2   25       2.0 58 51 0 2   1 0     0   4   26 32 0   0 2 25     2 58
2945339 WA Walla Walla   school 5309000 36300   Touchet School District 530900001536 2160 Touchet Elem & High School   Regular School No Other KG 12 2021   grade_7 7 0 6   0 0     0   0   7 6 0   1   3   7       2.0 13 7 0 6   0 0     0   0   7 6 0   1 3 7     2 13
2945318 WA Yakima   school 5308970 39202   Toppenish School District 530897001535 2264 Toppenish Middle School   Regular School No Middle 06 08 2021   grade_7 3 1 260   36 2     0   4   155 151 0   93   2   270       12.0 306 3 1 260   36 2     0   4   155 151 0   93 2 270     12 306
2945307 WA Yakima   school 5308970 39202   Toppenish School District 530897003385 5262 Northwest Allprep   Regular School No Other KG 12 2021   grade_7 47 2 4   0 0     0   1   26 21 7   8   0   24       0.0 54 47 2 4   0 0     0   1   26 21 7   8 0 24     0 54
2945274 WA Yakima   school 5308970 39202   Toppenish School District 530897002378 1508 Computer Academy Toppenish High School   Alternative School No High 06 12 2021   grade_7 0 0 0   1 0     0   0   1 0 0   0   0   1       0.0 1 0 0 0   1 0     0   0   1 0 0   0 0 1     0 1
2945266 WA Okanogan   school 5308940 24404   Tonasket School District 530894003673 5587 Tonasket Outreach School   Alternative School No Other KG 12 2021   grade_7 3 0 2   1 0     0   1   3 4 0   0   0   6       0.0 7 3 0 2   1 0     0   1   3 4 0   0 0 6     0 7
2945253 WA Okanogan   school 5308940 24404   Tonasket School District 530894001647 4196 Tonasket Middle School   Regular School No Middle 06 08 2021   grade_7 43 0 35   1 0     0   5   42 42 0   7   5   70       5.0 84 43 0 35   1 0     0   5   42 42 0   7 5 70     5 84
2945232 WA Lewis   school 5308910 21237   Toledo School District 530891001528 3977 Toledo Middle School   Regular School No Middle 06 08 2021   grade_7 47 1 5   3 0     0   2   29 29 0   1   10   30       0.0 58 47 1 5   3 0     0   2   29 29 0   1 10 30     0 58
2945213 WA Lewis   school 5308910 21237   Toledo School District 530891003310 5190 Cowlitz Prairie Academy   Regular School No High 06 12 2021   grade_7 10 0 0   0 0     0   0   4 6 0   0   4   3       0.0 10 10 0 0   0 0     0   0   4 6 0   0 4 3     0 10
2945201 WA Kittitas   school 5308850 19400   Thorp School District 530885001525 2514 Thorp Elem & Jr Sr High   Regular School No Other PK 12 2021   grade_7 19 0 5   0 0     0   0   11 13 0   0   0   14       0.0 24 19 0 5   0 0     0   0   11 13 0   0 0 14     0 24
2945189 WA Thurston   school 5308820 34402   Tenino School District 530882001523 3795 Tenino Middle School   Regular School No Middle 06 08 2021   grade_7 71 1 7   0 0     0   10   51 38 0   2   2   50       6.0 89 71 1 7   0 0     0   10   51 38 0   2 2 50     6 89
2945168 WA Whitman   school 5308790 38265   Tekoa School District 530879001521 3418 Tekoa High School   Regular School No High 07 12 2021   grade_7 7 0 0   0 0     0   0   5 2 0   0   0   6       0.0 7 7 0 0   0 0     0   0   5 2 0   0 0 6     0 7
2945141 WA King   school 5308760 17409   Tahoma School District 530876002979 3341 Summit Trail Middle School   Regular School No Middle 06 08 2021   grade_7 245 12 33   1 27     1   42   194 166 1   4   3   41       24.0 361 245 12 33   1 27     1   42   194 166 1   4 3 41     24 361
2945121 WA King   school 5308760 17409   Tahoma School District 530876001515 3937 Maple View Middle School   Regular School No Middle 06 08 2021   grade_7 218 10 41   0 21     5   47   184 158 0   5   1   60       22.0 342 218 10 41   0 21     5   47   184 158 0   5 1 60     22 342
2945086 WA Grays Harbor   school 5308730 14077   Taholah School District 530873002956 5032 Taholah Elementary & Middle School   Regular School No Elementary KG 08 2021   grade_7 0 0 1   9 0     0   1   5 6 0   0   1   7       0.0 11 0 0 1   9 0     0   1   5 6 0   0 1 7     0 11
2945048 WA Pierce   school 5308700 27010   Tacoma School District 530870001508 3116 Wainwright   Regular School No Middle 04 08 2021   grade_7 26 17 13   1 4     0   17   40 38 0   4   1   36       1.0 78 26 17 13   1 4     0   17   40 38 0   4 1 36     1 78
2945042 WA Pierce   school 5308700 27010   Tacoma School District 530870001507 3448 Truman   Regular School No Middle 06 08 2021   grade_7 95 25 41   1 13     4   40   115 103 1   13   5   121       20.0 219 95 25 41   1 13     4   40   115 103 1   13 5 121     20 219
2945037 WA Pierce   school 5308700 27010   Tacoma School District 530870002177 4283 The School at Pearl Youth Residence   Special Education School No High 06 12 2021   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
2945022 WA Pierce   school 5308700 27010   Tacoma School District 530870001504 2359 Stewart   Regular School No Middle 06 08 2021   grade_7 60 32 61   6 24     9   38   123 107 0   28   11   175       6.0 230 60 32 61   6 24     9   38   123 107 0   28 11 175     6 230
2945004 WA Pierce   school 5308700 27010   Tacoma School District 530870003275 5192 Special Services   Alternative School No Other PK 12 2021   grade_7 4 2 1   0 0     0   1   8 0 0   0   1   7       0.0 8 4 2 1   0 0     0   1   8 0 0   0 1 7     0 8
2944957 WA Pierce   school 5308700 27010   Tacoma School District 530870002171 2039 Remann Hall Juvenile Detention Center   Regular School No High 05 12 2021   grade_7 0 0 0   1 0     0   0   1 0 0   0   0   0       0.0 1 0 0 0   1 0     0   0   1 0 0   0 0 0     0 1
2944918 WA Pierce   school 5308700 27010   Tacoma School District 530870001487 3244 Meeker   Regular School No Middle 06 08 2021   grade_7 88 13 62   0 29     4   37   119 114 0   19   5   94       6.0 233 88 13 62   0 29     4   37   119 114 0   19 5 94     6 233
2944906 WA Pierce   school 5308700 27010   Tacoma School District 530870001483 2376 Mason   Regular School No Middle 06 08 2021   grade_7 176 14 32   2 10     2   42   130 148 0   4   2   86       26.0 278 176 14 32   2 10     2   42   130 148 0   4 2 86     26 278
2944839 WA Pierce   school 5308700 27010   Tacoma School District 530870001473 2338 Jason Lee   Regular School No Middle 06 08 2021   grade_7 89 42 29   1 7     6   29   101 101 1   10   13   139       10.0 203 89 42 29   1 7     6   29   101 101 1   10 13 139     10 203
2944822 WA Pierce   school 5308700 27010   Tacoma School District 530870001471 2377 Gray   Regular School No Middle 06 08 2021   grade_7 48 32 67   1 15     13   34   115 95 0   19   7   180       6.0 210 48 32 67   1 15     13   34   115 95 0   19 7 180     6 210
2944801 WA Pierce   school 5308700 27010   Tacoma School District 530870001467 2148 Franklin   Regular School No Elementary PK 05 2021   grade_7 0 0 0   0 1     0   0   1 0 0   1   0   0       0.0 1 0 0 0   0 1     0   0   1 0 0   1 0 0     0 1
2944788 WA Pierce   school 5308700 27010   Tacoma School District 530870003299 5170 First Creek Middle School   Regular School No Middle 06 08 2021   grade_7 25 44 88   2 44     11   31   126 119 0   51   4   222       3.0 245 25 44 88   2 44     11   31   126 119 0   51 4 222     3 245

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