Data source: Big Local News · About: Big Local

807 rows where grade = "grade_6", state = "WA" and year = 2019 sorted by rowid descending

View and edit SQL

year

  • 2019 · 807

grade

  • grade_6 · 807
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
2428461 WA Yakima   school 5310170 39205   Zillah School District 531017001896 4221 Zillah Intermediate School   Regular School No Middle 04 06 2019   grade_6 38 0 56   3 1     0   4   52 50 0   2   1   63       3.0 102 38 0 56   3 1     0   4   52 50 0   2 1 63     3 102
2428436 WA Thurston   school 5310140 34002   Yelm School District 531014001717 2481 Yelm Middle School   Regular School No Middle 06 08 2019   grade_6 165 4 42   6 4     3   28   128 124 0   6   3   131       16.0 252 165 4 42   6 4     3   28   128 124 0   6 3 131     16 252
2428414 WA Thurston   school 5310140 34002   Yelm School District 531014003068 5052 Ridgeline Middle School   Regular School No Middle 06 08 2019   grade_6 154 3 31   0 2     2   28   121 99 0   7   4   87       25.0 220 154 3 31   0 2     2   28   121 99 0   7 4 87     25 220
2428369 WA Yakima   school 5310110 39007   Yakima School District 531011003263 5153 Yakima Online   Alternative School No High 06 12 2019   grade_6 1 0 1   0 0     0   0   1 1 0   0   0   1       0.0 2 1 0 1   0 0     0   0   1 1 0   0 0 1     0 2
2428362 WA Yakima   school 5310110 39007   Yakima School District 531011001710 3368 Wilson Middle School   Regular School No Middle 06 08 2019   grade_6 68 1 216   2 2     0   5   155 139 0   65   5   220       15.0 294 68 1 216   2 2     0   5   155 139 0   65 5 220     15 294
2428350 WA Yakima   school 5310110 39007   Yakima School District 531011001708 2314 Washington Middle School   Regular School No Middle 06 08 2019   grade_6 15 0 297   3 0     0   0   143 172 0   125   7   300       11.0 315 15 0 297   3 0     0   0   143 172 0   125 7 300     11 315
2428286 WA Yakima   school 5310110 39007   Yakima School District 531011001698 3615 Lewis & Clark Middle School   Regular School No Middle 06 08 2019   grade_6 33 2 260   1 1     0   5   175 127 0   81   7   277       10.0 302 33 2 260   1 1     0   5   175 127 0   81 7 277     10 302
2428254 WA Yakima   school 5310110 39007   Yakima School District 531011001691 2410 Franklin Middle School   Regular School No Middle 06 08 2019   grade_6 69 2 236   3 3     0   10   173 150 0   67   11   273       14.0 323 69 2 236   3 3     0   10   173 150 0   67 11 273     14 323
2428242 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2019   grade_6 8 0 17   1 0     0   1   10 17 0   5   0   20       4.0 27 8 0 17   1 0     0   1   10 17 0   5 0 20     4 27
2428199 WA Cowlitz   school 5310050 8404   Woodland School District 531005003509 5409 Woodland Middle School   Regular School No Middle 05 08 2019   grade_6 148 0 41   2 2     0   2   103 92 0   16   13   104       10.0 195 148 0 41   2 2     0   2   103 92 0   16 13 104     10 195
2428177 WA Cowlitz   school 5310050 8404   Woodland School District 531005003371 5246 Lewis River Academy   Alternative School No Other KG 12 2019   grade_6 6 0 1   0 0     0   1   5 3 0   0   0   3       0.0 8 6 0 1   0 0     0   1   5 3 0   0 0 3     0 8
2428153 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_6 7 0 0   0 0     2   0   4 5 0   0   0   5       0.0 9 7 0 0   0 0     2   0   4 5 0   0 0 5     0 9
2428123 WA Lewis   school 5309930 21232   Winlock School District 530993002392 4369 Winlock Middle School   Regular School No Middle 06 08 2019   grade_6 34 0 9   0 0     0   4   21 26 0   6   2   45       5.0 47 34 0 9   0 0     0   4   21 26 0   6 2 45     5 47
2428112 WA Grant   school 5309900 13167   Wilson Creek School District 530990001674 2472 Wilson Creek Elementary   Regular School No Elementary PK 06 2019   grade_6 9 0 3   0 0     0   0   1 11 0   3   0   8       0.0 12 9 0 3   0 0     0   0   1 11 0   3 0 8     0 12
2428102 WA Pacific   school 5309870 25160   Willapa Valley School District 530987001673 2542 Willapa Valley Middle-High   Regular School No High 06 12 2019   grade_6 22 0 5   0 0     0   0   13 14 0   1   0   12       0.0 27 22 0 5   0 0     0   0   13 14 0   1 0 12     0 27
2428080 WA Lincoln   school 5309840 22200   Wilbur School District 530984001667 3290 Wilbur Elementary School   Regular School No Elementary KG 06 2019   grade_6 15 0 0   1 0     0   5   15 6 0   0   0   9       0.0 21 15 0 0   1 0     0   5   15 6 0   0 0 9     0 21
2428067 WA Klickitat   school 5309810 20405   White Salmon Valley School District 530981003500 5368 Wallace & Priscilla Stevenson Intermediate School   Regular School No Middle 04 06 2019   grade_6 65 0 30   1 1     0   7   59 45 0   14   4   52       2.0 104 65 0 30   1 1     0   7   59 45 0   14 4 52     2 104
2428021 WA Pierce   school 5309780 27416   White River School District 530978003005 3458 Glacier Middle School   Regular School No Middle 06 08 2019   grade_6 242 2 22   5 2     0   15   147 141 0   12   4   88       16.0 288 242 2 22   5 2     0   15   147 141 0   12 4 88     16 288
2427992 WA Lewis   school 5309750 21303   White Pass School District 530975001658 3555 White Pass Elementary School   Regular School No Elementary PK 06 2019   grade_6 25 1 2   0 0     0   0   12 16 0   0   5   17       0.0 28 25 1 2   0 0     0   0   12 16 0   0 5 17     0 28
2427976 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972003623 5504 WEST VALLEY VIRTUAL ACADEMY K-6   Regular School No Elementary KG 06 2019   grade_6 5 0 0   0 0     0   0   4 1 0   0   0   2       0.0 5 5 0 0   0 0     0   0   4 1 0   0 0 2     0 5
2427958 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972002545 4506 West Valley Middle School   Regular School No Middle 05 06 2019   grade_6 247 6 150   7 12     0   17   218 221 0   31   4   239       7.0 439 247 6 150   7 12     0   17   218 221 0   31 4 239     7 439
2427903 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969002685 1755 West Valley City School   Alternative School No Middle 05 08 2019   grade_6 42 0 5   0 2     0   0   30 19 0   1   1   27       3.0 49 42 0 5   0 2     0   0   30 19 0   1 1 27     3 49
2427881 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001646 3194 Pasadena Park Elementary   Regular School No Elementary 01 05 2019   grade_6 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
2427850 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001645 3538 Centennial Middle School   Regular School No Middle 06 08 2019   grade_6 170 0 21   0 2     2   23   129 89 0   4   8   121       3.0 218 170 0 21   0 2     2   23   129 89 0   4 8 121     3 218
2427823 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_6 12 0 3   0 0     0   0   7 8 0   0   0   4       2.0 15 12 0 3   0 0     0   0   7 8 0   0 0 4     2 15
2427798 WA Chelan   school 5309660 4246   Wenatchee School District 530966001635 3210 Pioneer Middle School   Regular School No Middle 06 08 2019   grade_6 81 0 118   0 1     0   2   107 95 0   44   10   126       19.0 202 81 0 118   0 1     0   2   107 95 0   44 10 126     19 202
2427794 WA Chelan   school 5309660 4246   Wenatchee School District 530966001634 3370 Orchard Middle School   Regular School No Middle 06 08 2019   grade_6 51 1 103   0 0     0   4   82 77 0   48   18   115       7.0 159 51 1 103   0 0     0   4   82 77 0   48 18 115     7 159
2427764 WA Chelan   school 5309660 4246   Wenatchee School District 530966001006 4432 Foothills Middle School   Regular School No Middle 06 08 2019   grade_6 101 1 86   1 1     0   4   103 91 0   34   7   101       12.0 194 101 1 86   1 1     0   4   103 91 0   34 7 101     12 194
2427742 WA Stevens   school 5309630 33049   Wellpinit School District #49 530963003150 4232 Wellpinit Middle School   Regular School No Middle 06 08 2019   grade_6 1 0 2   21 0     0   5   13 16 0   12   7   28       1.0 29 1 0 2   21 0     0   5   13 16 0   12 7 28     1 29
2427721 WA Douglas   school 5309600 9209   Waterville School District 530960001628 2162 Waterville High School   Regular School No High 06 12 2019   grade_6 19 0 3   0 0     0   1   9 14 0   0   1   17       0.0 23 19 0 3   0 0     0   1   9 14 0   0 1 17     0 23
2427704 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other PK 12 2019   grade_6 5 0 0   0 0     0   0   3 2 0   0   0   3       0.0 5 5 0 0   0 0     0   0   3 2 0   0 0 3     0 5
2427685 WA Clark   school 5309540 6112   Washougal School District 530954001892 4207 Jemtegaard Middle School   Regular School No Middle 06 08 2019   grade_6 127 1 27   1 1     0   10   84 83 0   5   7   85       9.0 167 127 1 27   1 1     0   10   84 83 0   5 7 85     9 167
2427653 WA Clark   school 5309540 6112   Washougal School District 530954002709 4549 Canyon Creek Middle School   Regular School No Middle 06 08 2019   grade_6 71 0 4   0 1     0   8   36 48 0   4   0   22       4.0 84 71 0 4   0 1     0   8   36 48 0   4 0 22     4 84
2427641 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_6 1 0 2   1 0     0   1   1 4 0   0   0   4       0.0 5 1 0 2   1 0     0   1   1 4 0   0 0 4     0 5
2427630 WA Grant   school 5309510 13146   Warden School District 530951001620 3909 Warden Middle School   Regular School No Middle 06 08 2019   grade_6 20 0 72   0 0     0   0   51 41 0   19   18   87       2.0 92 20 0 72   0 0     0   0   51 41 0   19 18 87     2 92
2427613 WA Yakima   school 5309480 39207   Wapato School District 530948001615 2131 Wapato Middle School   Regular School No Middle 06 08 2019   grade_6 9 0 190   48 7     0   9   139 124 0   132   5   250       2.0 263 9 0 190   48 7     0   9   139 124 0   132 5 250     2 263
2427564 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001606 2159 Prospect Point Elementary   Regular School No Elementary KG 05 2019   grade_6 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
2427555 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001605 2780 Pioneer Middle School   Regular School No Middle 06 08 2019   grade_6 107 2 77   2 4     0   2   96 98 0   22   6   123       7.0 194 107 2 77   2 4     0   2   96 98 0   22 6 123     7 194
2427537 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001601 3510 Garrison Middle School   Regular School No Middle 06 08 2019   grade_6 88 1 75   2 1     0   4   79 92 0   13   5   92       4.0 171 88 1 75   2 1     0   4   79 92 0   13 5 92     4 171
2427497 WA Walla Walla   school 5309390 36401   Waitsburg School District 530939002492 2174 Preston Hall Middle School   Regular School No Middle 06 08 2019   grade_6 20 0 2   1 1     0   0   11 13 0   1   1   16       3.0 24 20 0 2   1 1     0   0   11 13 0   1 1 16     3 24
2427493 WA Grant   school 5309360 13073   Wahluke School District 530936003264 5144 Wahluke Junior High   Regular School No Middle 06 08 2019   grade_6 4 0 201   1 0     0   2   110 98 0   78   33   198       4.0 208 4 0 201   1 0     0   2   110 98 0   78 33 198     4 208
2427449 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_6 24 0 4   0 0     1   1   15 15 0   3   2   13       1.0 30 24 0 4   0 0     1   1   15 15 0   3 2 13     1 30
2427439 WA Thurston   school   34901   WA HE LUT Indian School Agency   5496 Wa He Lut Indian School             2019   grade_6 0 0 0   12 0     0   0   5 7 0   0   0   11       0.0 12 0 0 0   12 0     0   0   5 7 0   0 0 11     0 12
2427420 WA King   school 5309300 17402   Vashon Island School District 530930001589 3667 McMurray Middle School   Regular School No Middle 06 08 2019   grade_6 107 0 15   0 2     0   8   57 75 0   3   1   35       7.0 132 107 0 15   0 2     0   8   57 75 0   3 1 35     7 132
2427414 WA King   school 5309300 17402   Vashon Island School District 530930002720 1822 Family Link   Alternative School No Other KG 12 2019   grade_6 3 0 0   0 0     0   1   3 1 0   0   0   0       0.0 4 3 0 0   0 0     0   1   3 1 0   0 0 0     0 4
2427376 WA Clark   school 5309270 6037   Vancouver School District 530927003246 5149 Vancouver Virtual Learning Academy   Alternative School No High 06 12 2019   grade_6 2 0 0   0 0     0   1   0 3 0   0   0   2       0.0 3 2 0 0   0 0     0   1   0 3 0   0 0 2     0 3
2427368 WA Clark   school 5309270 6037   Vancouver School District 530927002508 1689 Vancouver School of Arts and Academics   Regular School No High 06 12 2019   grade_6 61 0 16   0 4     0   12   32 61 0   2   1   31       4.0 93 61 0 16   0 4     0   12   32 61 0   2 1 31     4 93
2427360 WA Clark   school 5309270 6037   Vancouver School District 530927003415 5271 Vancouver iTech Preparatory   Regular School No High 06 12 2019   grade_6 45 0 10   0 1     1   3   38 22 0   1   0   21       6.0 60 45 0 10   0 1     1   3   38 22 0   1 0 21     6 60
2427350 WA Clark   school 5309270 6037   Vancouver School District 530927002943 3556 Vancouver Home Connection   Alternative School No Other KG 12 2019   grade_6 29 0 1   0 0     0   3   20 13 0   1   0   11       1.0 33 29 0 1   0 0     0   3   20 13 0   1 0 11     1 33
2427340 WA Clark   school 5309270 6037   Vancouver School District 530927002944 4591 Thomas Jefferson Middle School   Regular School No Middle 06 08 2019   grade_6 181 5 41   2 11     1   33   130 144 0   7   5   81       22.0 274 181 5 41   2 11     1   33   130 144 0   7 5 81     22 274
2427285 WA Clark   school 5309270 6037   Vancouver School District 530927001577 3146 Mcloughlin Middle School   Regular School No Middle 06 08 2019   grade_6 143 8 164   4 7     18   24   193 175 0   81   20   304       9.0 368 143 8 164   4 7     18   24   193 175 0   81 20 304     9 368
2427254 WA Clark   school 5309270 6037   Vancouver School District 530927001570 3543 Jason Lee Middle School   Regular School No Middle 06 08 2019   grade_6 137 7 60   1 11     4   18   106 132 0   17   8   120       11.0 238 137 7 60   1 11     4   18   106 132 0   17 8 120     11 238
2427207 WA Clark   school 5309270 6037   Vancouver School District 530927001562 3902 Gaiser Middle School   Regular School No Middle 06 08 2019   grade_6 167 17 111   3 8     9   22   192 145 0   46   12   229       9.0 337 167 17 111   3 8     9   22   192 145 0   46 12 229     9 337
2427190 WA Clark   school 5309270 6037   Vancouver School District 530927002408 1574 Fir Grove Childrens Center   Special Education School No Other KG 12 2019   grade_6 2 1 1   1 0     0   2   6 1 0   0   3   6       0.0 7 2 1 1   1 0     0   2   6 1 0   0 3 6     0 7
2427163 WA Clark   school 5309270 6037   Vancouver School District 530927002018 4503 Discovery Middle School   Regular School No Middle 06 08 2019   grade_6 106 9 98   2 6     5   20   132 114 0   43   17   189       9.0 246 106 9 98   2 6     5   20   132 114 0   43 17 189     9 246
2427140 WA Clark   school 5309270 6037   Vancouver School District 530927000578 4406 Alki Middle School   Regular School No Middle 06 08 2019   grade_6 174 2 26   0 11     2   16   117 114 0   9   1   56       8.0 231 174 2 26   0 11     2   16   117 114 0   9 1 56     8 231
2427135 WA Stevens   school 5309240 33070   Valley School District 530924001555 2405 Valley School   Regular School No Elementary KG 08 2019   grade_6 27 1 1   0 0     0   2   19 12 0   0   2   24       0.0 31 27 1 1   0 0     0   2   19 12 0   0 2 24     0 31
2427116 WA Stevens   school 5309240 33070   Valley School District 530924003107 1932 Columbia Virtual Academy   Alternative School No Elementary KG 08 2019   grade_6 72 1 18   1 9     1   14   56 60 0   2   3   2       0.0 116 72 1 18   1 9     1   14   56 60 0   2 3 2     0 116
2427094 WA Pierce   school 5309180 27083   University Place School District 530918001550 3296 Narrows View Intermediate   Regular School No Middle 05 07 2019   grade_6 106 22 34   2 17     4   43   108 120 0   10   8   106       13.0 228 106 22 34   2 17     4   43   108 120 0   10 8 106     13 228
2427083 WA Pierce   school 5309180 27083   University Place School District 530918002383 4325 Drum Intermediate   Regular School No Middle 05 07 2019   grade_6 91 17 37   2 24     1   38   112 98 0   7   1   76       19.0 210 91 17 37   2 24     1   38   112 98 0   7 1 76     19 210
2427061 WA Yakima   school 5309150 39002   Union Gap School District 530915002382 2714 Union Gap School   Regular School No Elementary PK 08 2019   grade_6 14 0 58   2 0     0   0   45 29 0   9   1   69       2.0 74 14 0 58   2 0     0   0   45 29 0   9 1 69     2 74
2427052 WA Thurston   school 5309100 34033   Tumwater School District 530910001545 3612 Tumwater Middle School   Regular School No Middle 06 08 2019   grade_6 153 7 32   0 5     0   24   104 117 0   4   4   76       6.0 221 153 7 32   0 5     0   24   104 117 0   4 4 76     6 221
2427000 WA Thurston   school 5309100 34033   Tumwater School District 530910001734 4452 George Washington Bush Middle Sch   Regular School No Middle 06 08 2019   grade_6 171 6 41   1 3     0   21   119 123 1   7   2   92       6.0 243 171 6 41   1 3     0   21   119 123 1   7 2 92     6 243
2426972 WA King   school 5308130 17406   Tukwila School District 530813003650 5536 Tukwila Online Learning   Alternative School No High 06 12 2019   grade_6 0 0 0   0 0     1   0   1 0 0   0   0   1       0.0 1 0 0 0   0 0     1   0   1 0 0   0 0 1     0 1
2426949 WA King   school 5308130 17406   Tukwila School District 530813001342 2564 Showalter Middle School   Regular School No Middle 06 08 2019   grade_6 19 39 81   2 47     9   13   108 102 0   62   13   168       3.0 210 19 39 81   2 47     9   13   108 102 0   62 13 168     3 210
2426928 WA Klickitat   school 5309060 20400   Trout Lake School District 530906001539 2676 Trout Lake School   Regular School No High 05 12 2019   grade_6 19 0 3   1 0     0   1   13 11 0   0   0   0       2.0 24 19 0 3   1 0     0   1   13 11 0   0 0 0     2 24
2426907 WA Cowlitz   school 5309030 8130   Toutle Lake School District 530903002069 4264 Toutle Lake Elementary   Regular School No Elementary KG 06 2019   grade_6 37 0 5   0 0     0   2   21 23 0   0   3   20       5.0 44 37 0 5   0 0     0   2   21 23 0   0 3 20     5 44
2426895 WA Walla Walla   school 5309000 36300   Touchet School District 530900001536 2160 Touchet Elem & High School   Regular School No Other KG 12 2019   grade_6 5 0 11   0 0     0   0   11 5 0   2   3   12       0.0 16 5 0 11   0 0     0   0   11 5 0   2 3 12     0 16
2426874 WA Yakima   school 5308970 39202   Toppenish School District 530897001535 2264 Toppenish Middle School   Regular School No Middle 06 08 2019   grade_6 12 0 251   42 1     0   5   150 161 0   129   6   293       10.0 311 12 0 251   42 1     0   5   150 161 0   129 6 293     10 311
2426864 WA Yakima   school 5308970 39202   Toppenish School District 530897003385 5262 Northwest Allprep   Regular School No Other KG 12 2019   grade_6 9 0 0   0 0     0   1   5 5 0   1   0   0       0.0 10 9 0 0   0 0     0   1   5 5 0   1 0 0     0 10
2426828 WA Okanogan   school 5308940 24404   Tonasket School District 530894001647 4196 Tonasket Middle School   Regular School No Middle 06 08 2019   grade_6 55 0 43   1 0     0   2   50 53 0   11   7   80       3.0 103 55 0 43   1 0     0   2   50 53 0   11 7 80     3 103
2426811 WA Lewis   school 5308910 21237   Toledo School District 530891001528 3977 Toledo Middle School   Regular School No Middle 06 08 2019   grade_6 36 2 3   2 1     0   4   32 16 0   0   10   30       0.0 48 36 2 3   2 1     0   4   32 16 0   0 10 30     0 48
2426801 WA Lewis   school 5308910 21237   Toledo School District 530891001526 2998 Toledo Elementary School   Regular School No Elementary PK 05 2019   grade_6 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
2426784 WA Kittitas   school 5308850 19400   Thorp School District 530885001525 2514 Thorp Elem & Jr Sr High   Regular School No Other PK 12 2019   grade_6 12 0 0   0 1     0   0   4 9 0   0   1   7       0.0 13 12 0 0   0 1     0   0   4 9 0   0 1 7     0 13
2426771 WA Thurston   school 5308820 34402   Tenino School District 530882001523 3795 Tenino Middle School   Regular School No Middle 06 08 2019   grade_6 94 2 9   0 0     0   5   59 51 0   1   0   66       2.0 110 94 2 9   0 0     0   5   59 51 0   1 0 66     2 110
2426744 WA Whitman   school 5308790 38265   Tekoa School District 530879001520 2052 Tekoa Elementary School   Regular School No Elementary PK 06 2019   grade_6 8 0 2   0 0     0   0   1 9 0   0   0   6       0.0 10 8 0 2   0 0     0   0   1 9 0   0 0 6     0 10
2426722 WA King   school 5308760 17409   Tahoma School District 530876002979 3341 Summit Trail Middle School   Regular School No Middle 06 08 2019   grade_6 287 8 39   3 16     4   38   209 185 1   6   0   43       39.0 395 287 8 39   3 16     4   38   209 185 1   6 0 43     39 395
2426702 WA King   school 5308760 17409   Tahoma School District 530876001515 3937 Maple View Middle School   Regular School No Middle 06 08 2019   grade_6 225 8 49   2 21     4   39   189 159 0   5   2   75       26.0 348 225 8 49   2 21     4   39   189 159 0   5 2 75     26 348
2426669 WA Grays Harbor   school 5308730 14077   Taholah School District 530873002956 5032 Taholah Elementary & Middle School   Regular School No Elementary KG 08 2019   grade_6 0 0 2   7 0     0   2   5 6 0   0   1   8       0.0 11 0 0 2   7 0     0   2   5 6 0   0 1 8     0 11
2426633 WA Pierce   school 5308700 27010   Tacoma School District 530870001508 3116 Wainwright   Regular School No Middle 04 08 2019   grade_6 58 22 20   2 9     1   20   66 66 0   7   12   75       3.0 132 58 22 20   2 9     1   20   66 66 0   7 12 75     3 132
2426627 WA Pierce   school 5308700 27010   Tacoma School District 530870001507 3448 Truman   Regular School No Middle 06 08 2019   grade_6 136 34 44   1 16     2   36   149 120 0   18   23   160       16.0 269 136 34 44   1 16     2   36   149 120 0   18 23 160     16 269
2426605 WA Pierce   school 5308700 27010   Tacoma School District 530870001504 2359 Stewart   Regular School No Middle 06 08 2019   grade_6 71 31 74   3 32     7   38   127 129 0   36   20   200       17.0 256 71 31 74   3 32     7   38   127 129 0   36 20 200     17 256
2426587 WA Pierce   school 5308700 27010   Tacoma School District 530870003275 5192 Special Services   Alternative School No Other PK 12 2019   grade_6 1 0 0   0 0     0   1   2 0 0   0   0   1       0.0 2 1 0 0   0 0     0   1   2 0 0   0 0 1     0 2
2426499 WA Pierce   school 5308700 27010   Tacoma School District 530870001487 3244 Meeker   Regular School No Middle 06 08 2019   grade_6 114 14 34   1 24     3   25   110 105 0   13   6   73       8.0 215 114 14 34   1 24     3   25   110 105 0   13 6 73     8 215
2426487 WA Pierce   school 5308700 27010   Tacoma School District 530870001483 2376 Mason   Regular School No Middle 06 08 2019   grade_6 170 11 34   1 16     3   34   138 131 0   6   7   95       15.0 269 170 11 34   1 16     3   34   138 131 0   6 7 95     15 269
2426421 WA Pierce   school 5308700 27010   Tacoma School District 530870001473 2338 Jason Lee   Regular School No Middle 06 08 2019   grade_6 84 51 31   3 7     4   27   110 97 0   9   30   133       15.0 207 84 51 31   3 7     4   27   110 97 0   9 30 133     15 207
2426405 WA Pierce   school 5308700 27010   Tacoma School District 530870001471 2377 Gray   Regular School No Middle 06 08 2019   grade_6 40 41 63   1 14     5   31   102 93 0   18   12   158       11.0 195 40 41 63   1 14     5   31   102 93 0   18 12 158     11 195
2426372 WA Pierce   school 5308700 27010   Tacoma School District 530870003299 5170 First Creek Middle School   Regular School No Middle 06 08 2019   grade_6 32 43 98   4 30     12   26   123 121 1   55   13   217       9.0 245 32 43 98   4 30     12   26   123 121 1   55 13 217     9 245
2426311 WA Pierce   school 5308700 27010   Tacoma School District 530870001458 3397 Bryant   Regular School No Elementary PK 08 2019   grade_6 48 8 7   1 0     1   9   32 42 0   3   5   36       6.0 74 48 8 7   1 0     1   9   32 42 0   3 5 36     6 74
2426270 WA Pierce   school 5308700 27010   Tacoma School District 530870001454 3054 Baker   Regular School No Middle 06 08 2019   grade_6 77 34 75   1 36     16   42   141 140 0   36   27   213       17.0 281 77 34 75   1 36     16   42   141 140 0   36 27 213     17 281
2426258 WA Pierce   school 5308700 27010   Tacoma School District 530870003155 4575 Angelo Giaudrone Middle School   Regular School No Middle 06 08 2019   grade_6 51 38 63   2 17     9   27   101 106 0   21   13   178       11.0 207 51 38 63   2 17     9   27   101 106 0   21 13 178     11 207
2426253 WA Kitsap   school 5300328 18902   Suquamish Tribal Education Department 530032803493 5319 Chief Kitsap Academy   Regular School No Other KG 12 2019   grade_6 1 0 1   4 0     0   0   4 2 0   0   0   3       0.0 6 1 0 1   4 0     0   0   4 2 0   0 0 3     0 6
2426229 WA Yakima   school 5308670 39201   Sunnyside School District 530867003037 5049 Sierra Vista Middle School   Regular School No Middle 06 08 2019   grade_6 16 0 247   0 0     0   3   130 136 0   79   14   236       3.0 266 16 0 247   0 0     0   3   130 136 0   79 14 236     3 266
2426206 WA Yakima   school 5308670 39201   Sunnyside School District 530867001451 3313 Harrison Middle School   Regular School No Middle 06 08 2019   grade_6 11 0 318   0 1     0   3   161 172 0   87   11   290       3.0 333 11 0 318   0 1     0   3   161 172 0   87 11 290     3 333
2426176 WA Pierce   school 5308610 27320   Sumner School District 530861001447 3499 Sumner Middle School   Regular School No Middle 06 08 2019   grade_6 148 3 53   3 7     0   36   130 120 0   21   5   107       15.0 250 148 3 53   3 7     0   36   130 120 0   21 5 107     15 250
2426166 WA Pierce   school 5308610 27320   Sumner School District 530861002580 4502 Mountain View Middle School   Regular School No Middle 06 08 2019   grade_6 176 1 37   0 2     2   29   123 124 0   7   1   72       22.0 247 176 1 37   0 2     2   29   123 124 0   7 1 72     22 247
2426146 WA Pierce   school 5308610 27320   Sumner School District 530861001808 4132 Lakeridge Middle School   Regular School No Middle 06 08 2019   grade_6 208 4 25   1 5     1   27   139 132 0   7   0   80       17.0 271 208 4 25   1 5     1   27   139 132 0   7 0 80     17 271
2426094 WA Stevens   school 5308580 33202   Summit Valley School District 530858001203 4394 Summit Valley School   Regular School No Elementary PK 08 2019   grade_6 9 0 0   1 0     0   1   4 7 0   0   0   9       1.0 11 9 0 0   1 0     0   1   4 7 0   0 0 9     1 11
2426075 WA King   school 5300343 17905   Summit Public School: Atlas 530034303611 5469 Summit Public School: Atlas   Regular School Yes High 06 12 2019   grade_6 23 28 12   1 3     1   18   48 38 0   14   2   49       1.0 86 23 28 12   1 3     1   18   48 38 0   14 2 49     1 86
2426065 WA Snohomish   school 5308550 31311   Sultan School District 530855001439 2105 Sultan Middle School   Regular School No Middle 06 08 2019   grade_6 119 3 36   0 3     0   10   94 77 0   3   1   110       10.0 171 119 3 36   0 3     0   10   94 77 0   3 1 110     10 171

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