Data source: Big Local News · About: Big Local

584 rows where grade = "grade_9", state = "WA" and year = 2017 sorted by rowid descending

View and edit SQL

year

  • 2017 · 584

grade

  • grade_9 · 584
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
632789 WA Yakima   school 5310170 39205   Zillah School District 531017001719 2240 Zillah High School   Regular School No High 09 12 2017   grade_9 41 0 57   4 0     0   4   66 40 0   4   3   64       5.0 106 41 0 57   4 0     0   4   66 40 0   4 3 64     5 106
632768 WA Thurston   school 5310140 34002   Yelm School District 531014001717 2481 Yelm Middle School   Regular School No Other 07 09 2017   grade_9 169 8 38   2 3     4   25   106 143 0   1   7   122       18.0 249 169 8 38   2 3     4   25   106 143 0   1 7 122     18 249
632760 WA Thurston   school 5310140 34002   Yelm School District 531014000134 1627 Yelm Extension School   Alternative School No High 09 12 2017   grade_9 2 0 0   0 0     0   0   0 2 0   0   0   1       0.0 2 2 0 0   0 0     0   0   0 2 0   0 0 1     0 2
632744 WA Thurston   school 5310140 34002   Yelm School District 531014003068 5052 Ridgeline Middle School   Regular School No Other 07 09 2017   grade_9 134 0 29   2 1     0   21   104 83 0   2   2   82       9.0 187 134 0 29   2 1     0   21   104 83 0   2 2 82     9 187
632704 WA Yakima   school 5310110 39007   Yakima School District 531011003324 5224 Yakima Satellite Alternative Programs   Alternative School No High 08 12 2017   grade_9 2 0 1   0 0     0   0   2 1 0   0   0   2       0.0 3 2 0 1   0 0     0   0   2 1 0   0 0 2     0 3
632695 WA Yakima   school 5310110 39007   Yakima School District 531011003263 5153 Yakima Online   Alternative School No Other 06 12 2017   grade_9 6 0 2   0 0     0   0   4 4 0   0   1   7       1.0 8 6 0 2   0 0     0   0   4 4 0   0 1 7     1 8
632671 WA Yakima   school 5310110 39007   Yakima School District 531011001713 4093 Stanton Academy   Alternative School No High 09 12 2017   grade_9 9 0 39   0 0     0   2   39 11 0   10   5   45       5.0 50 9 0 39   0 0     0   2   39 11 0   10 5 45     5 50
632651 WA Yakima   school 5310110 39007   Yakima School District 531011003420 5264 Ridgeview Group Home   Regular School No High 07 12 2017   grade_9 1 0 1   0 0     0   0   0 2 0   0   0   2       0.0 2 1 0 1   0 0     0   0   0 2 0   0 0 2     0 2
632605 WA Yakima   school 5310110 39007   Yakima School District 531011002932 4092 Juvenile Detention Center   Regular School No Other 05 12 2017   grade_9 2 0 0   0 0     0   0   2 0 0   0   0   2       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 2     0 2
632570 WA Yakima   school 5310110 39007   Yakima School District 531011001690 3206 Eisenhower High School   Regular School No High 09 12 2017   grade_9 124 1 332   6 2     1   15   242 239 0   119   15   358       9.0 481 124 1 332   6 2     1   15   242 239 0   119 15 358     9 481
632553 WA Yakima   school 5310110 39007   Yakima School District 531011001689 2116 Davis High School   Regular School No High 09 12 2017   grade_9 63 2 571   4 1     0   19   312 348 0   176   8   525       28.0 660 63 2 571   4 1     0   19   312 348 0   176 8 525     28 660
632511 WA Cowlitz   school 5310050 8404   Woodland School District 531005001682 3546 Woodland High School   Regular School No High 09 12 2017   grade_9 128 0 36   0 2     0   6   86 86 0   4   5   93       5.0 172 128 0 36   0 2     0   6   86 86 0   4 5 93     5 172
632506 WA Cowlitz   school 5310050 8404   Woodland School District 531005002713 1795 Woodland Alternative School   Alternative School No High 09 12 2017   grade_9 3 0 0   1 0     0   0   2 2 0   0   0   2       0.0 4 3 0 0   1 0     0   0   2 2 0   0 0 2     0 4
632500 WA Cowlitz   school 5310050 8404   Woodland School District 531005003371 5246 Lewis River Academy   Alternative School No Other KG 12 2017   grade_9 2 0 1   0 0     0   0   2 1 0   0   0   2       0.0 3 2 0 1   0 0     0   0   2 1 0   0 0 2     0 3
632485 WA Klickitat   school 5310020 20094   Wishram School District 531002001680 2605 Wishram High And Elementary Schl   Regular School No Other PK 12 2017   grade_9 3 0 2   0 0     0   0   4 1 0   0   0   5       1.0 5 3 0 2   0 0     0   0   4 1 0   0 0 5     1 5
632471 WA Grays Harbor   school 5309990 14117   Wishkah Valley School District 530999001679 3375 Wishkah Valley Elementary/High School   Regular School No Other KG 12 2017   grade_9 14 0 1   0 0     0   0   7 8 0   0   1   9       0.0 15 14 0 1   0 0     0   0   7 8 0   0 1 9     0 15
632454 WA Lewis   school 5309930 21232   Winlock School District 530993001676 3597 Winlock Senior High   Regular School No High 09 12 2017   grade_9 37 0 10   0 0     0   1   31 17 0   4   2   44       3.0 48 37 0 10   0 0     0   1   31 17 0   4 2 44     3 48
632437 WA Grant   school 5309900 13167   Wilson Creek School District 530990001675 2473 Wilson Creek High   Regular School No High 07 12 2017   grade_9 12 1 2   0 0     0   0   7 8 0   0   0   10       0.0 15 12 1 2   0 0     0   0   7 8 0   0 0 10     0 15
632421 WA Pacific   school 5309870 25160   Willapa Valley School District 530987001673 2542 Willapa Valley Middle-High   Regular School No Other 06 12 2017   grade_9 21 0 5   0 0     0   1   14 13 0   0   1   14       1.0 27 21 0 5   0 0     0   1   14 13 0   0 1 14     1 27
632405 WA Lincoln   school 5309840 22200   Wilbur School District 530984001668 3289 Wilbur Secondary School   Regular School No High 07 12 2017   grade_9 20 0 2   3 0     0   1   17 9 0   0   1   11       0.0 26 20 0 2   3 0     0   1   17 9 0   0 1 11     0 26
632372 WA Klickitat   school 5309810 20405   White Salmon Valley School District 530981001664 2330 Columbia High School   Regular School No High 09 12 2017   grade_9 58 0 37   3 1     0   4   53 50 0   12   1   52       2.0 103 58 0 37   3 1     0   4   53 50 0   12 1 52     2 103
632348 WA Pierce   school 5309780 27416   White River School District 530978003153 4569 White River High School   Regular School No High 09 12 2017   grade_9 240 1 31   1 1     1   15   149 141 0   1   3   93       14.0 290 240 1 31   1 1     1   15   149 141 0   1 3 93     14 290
632312 WA Lewis   school 5309750 21303   White Pass School District 530975001659 2859 White Pass Jr. Sr. High School   Regular School No High 07 12 2017   grade_9 39 1 1   1 0     0   0   23 19 0   0   3   32       1.0 42 39 1 1   1 0     0   0   23 19 0   0 3 32     1 42
632276 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972003340 5221 West Valley High School Freshman Campus (Closed after 2018-2019 school year)   Regular School No Other 09 09 2017   grade_9 244 5 119   5 4     2   14   212 182 0   25   0   170       13.0 394 244 5 119   5 4     2   14   212 182 0   25 0 170     13 394
632272 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001654 3074 West Valley High School   Regular School No High 10 12 2017   grade_9 11 0 1   0 0     0   0   4 8 0   0   0   1       0.0 12 11 0 1   0 0     0   0   4 8 0   0 0 1     0 12
632230 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001648 3195 West Valley High School   Regular School No High 09 12 2017   grade_9 214 5 19   0 3     0   23   137 127 0   2   2   120       8.0 264 214 5 19   0 3     0   23   137 127 0   2 2 120     8 264
632218 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969002840 1842 Spokane Valley Transition School (Closed after 2019-2020 school year)   Alternative School No High 09 12 2017   grade_9 4 0 0   0 0     0   0   2 2 0   0   0   3       0.0 4 4 0 0   0 0     0   0   2 2 0   0 0 3     0 4
632213 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969002826 1838 Spokane Valley High School (Closed after 2019-2020 school year)   Alternative School No High 09 12 2017   grade_9 15 0 2   0 0     0   2   12 7 0   1   0   9       2.0 19 15 0 2   0 0     0   2   12 7 0   1 0 9     2 19
632179 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969002244 1628 Dishman Hills High School   Alternative School No High 09 12 2017   grade_9 10 0 0   0 0     0   0   3 7 0   0   0   7       1.0 10 10 0 0   0 0     0   0   3 7 0   0 0 7     1 10
632170 WA Chelan   school 5309660 4246   Wenatchee School District 530966002193 1613 Westside High School   Alternative School No High 09 12 2017   grade_9 10 0 5   0 0     0   1   8 8 0   1   1   9       4.0 16 10 0 5   0 0     0   1   8 8 0   1 1 9     4 16
632161 WA Chelan   school 5309660 4246   Wenatchee School District 530966001639 2134 Wenatchee High School   Regular School No High 09 12 2017   grade_9 272 1 248   2 7     0   26   287 269 0   88   21   286       27.0 556 272 1 248   2 7     0   26   287 269 0   88 21 286     27 556
632146 WA Chelan   school 5309660 4246   Wenatchee School District 530966002550 1742 Valley Academy Of Learning (Closed after 2018-2019 school year)   Alternative School No Other KG 12 2017   grade_9 4 1 1   0 0     0   1   5 2 0   0   0   1       0.0 7 4 1 1   0 0     0   1   5 2 0   0 0 1     0 7
632076 WA Chelan   school 5309660 4246   Wenatchee School District 530966002706 1802 Chelan County Juvenile Detention Center   Regular School No Other 03 12 2017   grade_9 0 0 1   0 0     0   0   1 0 0   1   0   0       0.0 1 0 0 1   0 0     0   0   1 0 0   1 0 0     0 1
632057 WA Stevens   school 5309630 33049   Wellpinit School District #49 530963001629 2550 Wellpinit High School   Regular School No High 09 12 2017   grade_9 0 0 3   21 0     0   3   16 11 0   8   10   26       0.0 27 0 0 3   21 0     0   3   16 11 0   8 10 26     0 27
632037 WA Douglas   school 5309600 9209   Waterville School District 530960001628 2162 Waterville High School   Regular School No Other 06 12 2017   grade_9 9 0 10   0 0     0   2   11 10 0   5   1   17       0.0 21 9 0 10   0 0     0   2   11 10 0   5 1 17     0 21
632018 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other KG 12 2017   grade_9 2 0 0   0 0     0   0   0 2 0   0   0   2       0.0 2 2 0 0   0 0     0   0   0 2 0   0 0 2     0 2
632003 WA Clark   school 5309540 6112   Washougal School District 530954001624 3147 Washougal High School   Regular School No High 09 12 2017   grade_9 216 2 30   1 8     0   12   141 128 0   5   3   103       18.0 269 216 2 30   1 8     0   12   141 128 0   5 3 103     18 269
631964 WA Thurston   school 5300324 34979   Washington Military Department 530032403412 5302 Washington Youth Academy   Regular School No High 09 12 2017   grade_9 12 1 3   0 0     0   3   16 3 0   0   0   19       2.0 19 12 1 3   0 0     0   3   16 3 0   0 0 19     2 19
631957 WA Thurston   school 5300015 34975   Washington Center for Deaf and Hard of Hearing Youth 530001501016 4246 Washington State School for the Deaf   Regular School No Other PK 12 2017   grade_9 4 1 5   0 2     0   0   4 8 0   0   0   9       1.0 12 4 1 5   0 2     0   0   4 8 0   0 0 9     1 12
631940 WA Grant   school 5309510 13146   Warden School District 530951001619 3273 Warden High School   Regular School No High 09 12 2017   grade_9 12 0 49   0 0     0   3   32 32 0   9   12   53       0.0 64 12 0 49   0 0     0   3   32 32 0   9 12 53     0 64
631922 WA Yakima   school 5309480 39207   Wapato School District 530948001617 3141 Wapato High School   Regular School No High 09 12 2017   grade_9 9 0 171   51 6     1   11   128 121 0   68   11   215       7.0 249 9 0 171   51 6     1   11   128 121 0   68 11 215     7 249
631887 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001609 3468 Walla Walla High School   Regular School No High 09 12 2017   grade_9 234 4 182   4 5     0   14   215 228 0   39   8   247       24.0 443 234 4 182   4 5     0   14   215 228 0   39 8 247     24 443
631861 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001607 4071 Lincoln High School   Alternative School No High 09 12 2017   grade_9 28 0 3   0 0     0   2   22 11 0   0   2   27       0.0 33 28 0 3   0 0     0   2   22 11 0   0 2 27     0 33
631818 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001604 2407 Alternative Education Program (Closed after 2018-2019 school year)   Alternative School No High 09 12 2017   grade_9 0 0 1   0 0     0   0   0 1 0   0   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   0 0 1     0 1
631813 WA Walla Walla   school 5309390 36401   Waitsburg School District 530939001597 2386 Waitsburg High School   Regular School No High 09 12 2017   grade_9 29 0 4   0 1     0   1   19 16 0   1   0   18       0.0 35 29 0 4   0 1     0   1   19 16 0   1 0 18     0 35
631790 WA Grant   school 5309360 13073   Wahluke School District 530936002070 4254 Wahluke High School   Regular School No High 09 12 2017   grade_9 6 0 137   1 0     0   0   62 82 0   47   5   142       3.0 144 6 0 137   1 0     0   0   62 82 0   47 5 142     3 144
631755 WA Wahkiakum   school 5309330 35200   Wahkiakum School District 530933001594 3467 Wahkiakum High School   Regular School No High 09 12 2017   grade_9 23 0 2   1 0     0   2   17 11 0   1   3   18       2.0 28 23 0 2   1 0     0   2   17 11 0   1 3 18     2 28
631739 WA King   school 5309300 17402   Vashon Island School District 530930001591 2419 Vashon Island High School   Regular School No High 09 12 2017   grade_9 120 1 15   0 4     0   8   82 66 0   3   0   31       9.0 148 120 1 15   0 4     0   8   82 66 0   3 0 31     9 148
631725 WA King   school 5309300 17402   Vashon Island School District 530930002720 1822 Family Link   Alternative School No Other KG 12 2017   grade_9 1 0 0   0 0     0   0   0 1 0   0   0   0       1.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     1 1
631687 WA Clark   school 5309270 6037   Vancouver School District 530927003246 5149 Vancouver Virtual Learning Academy   Alternative School No Other 06 12 2017   grade_9 23 0 3   1 1     0   2   19 11 0   3   1   17       3.0 30 23 0 3   1 1     0   2   19 11 0   3 1 17     3 30
631679 WA Clark   school 5309270 6037   Vancouver School District 530927002508 1689 Vancouver School of Arts and Academics   Regular School No Other 06 12 2017   grade_9 64 1 9   0 3     1   5   23 60 0   0   1   20       4.0 83 64 1 9   0 3     1   5   23 60 0   0 1 20     4 83
631671 WA Clark   school 5309270 6037   Vancouver School District 530927003415 5271 Vancouver iTech Preparatory   Regular School No Other 06 12 2017   grade_9 49 3 10   0 1     1   5   49 20 0   1   0   25       6.0 69 49 3 10   0 1     1   5   49 20 0   1 0 25     6 69
631661 WA Clark   school 5309270 6037   Vancouver School District 530927002943 3556 Vancouver Home Connection   Alternative School No Other KG 12 2017   grade_9 10 0 2   0 0     0   0   8 4 0   0   1   9       2.0 12 10 0 2   0 0     0   0   8 4 0   0 1 9     2 12
631648 WA Clark   school 5309270 6037   Vancouver School District 530927003151 4524 Vancouver Alternative Programs (Closed after 2017-2018 school year)   Regular School No Other 06 12 2017   grade_9 2 0 0   0 0     0   0   2 0 0   0   0   0       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 0     0 2
631638 WA Clark   school 5309270 6037   Vancouver School District 530927002555 4504 Skyview High School   Regular School No High 09 12 2017   grade_9 330 14 85   1 24     3   29   249 237 0   13   5   159       10.0 486 330 14 85   1 24     3   29   249 237 0   13 5 159     10 486
631569 WA Clark   school 5309270 6037   Vancouver School District 530927001579 3932 Lewis and Clark High School   Regular School No High 09 12 2017   grade_9 15 0 4   0 0     0   0   6 13 0   1   0   10       1.0 19 15 0 4   0 0     0   0   6 13 0   1 0 10     1 19
631553 WA Clark   school 5309270 6037   Vancouver School District 530927001569 3081 Hudson's Bay High School   Regular School No High 09 12 2017   grade_9 176 20 119   2 5     5   26   186 167 0   43   18   257       7.0 353 176 20 119   2 5     5   26   186 167 0   43 18 257     7 353
631497 WA Clark   school 5309270 6037   Vancouver School District 530927001560 2179 Fort Vancouver High School   Regular School No High 09 12 2017   grade_9 145 12 154   2 15     16   19   182 181 0   78   19   295       10.0 363 145 12 154   2 15     16   19   182 181 0   78 19 295     10 363
631492 WA Clark   school 5309270 6037   Vancouver School District 530927002408 1574 Fir Grove Childrens Center   Special Education School No Other KG 12 2017   grade_9 2 0 0   1 0     0   0   3 0 0   0   0   2       0.0 3 2 0 0   1 0     0   0   3 0 0   0 0 2     0 3
631460 WA Clark   school 5309270 6037   Vancouver School District 530927001557 3423 Columbia River High   Regular School No High 09 12 2017   grade_9 200 2 46   1 9     2   23   139 144 0   3   4   89       17.0 283 200 2 46   1 9     2   23   139 144 0   3 4 89     17 283
631425 WA Stevens   school 5309240 33070   Valley School District 530924003327 5223 Paideia High School   Regular School No High 09 12 2017   grade_9 6 0 1   0 0     0   2   6 3 0   0   0   5       0.0 9 6 0 1   0 0     0   2   6 3 0   0 0 5     0 9
631377 WA Pierce   school 5309180 27083   University Place School District 530918001549 3600 Curtis Senior High   Regular School No High 10 12 2017   grade_9 0 0 1   0 1     0   1   2 1 0   1   0   3       0.0 3 0 0 1   0 1     0   1   2 1 0   1 0 3     0 3
631370 WA Pierce   school 5309180 27083   University Place School District 530918001548 3179 Curtis Junior High   Regular School No Other 08 09 2017   grade_9 233 48 50   3 69     5   72   263 217 0   19   5   182       34.0 480 233 48 50   3 69     5   72   263 217 0   19 5 182     34 480
631333 WA Thurston   school 5309100 34033   Tumwater School District 530910001544 3362 Tumwater High School   Regular School No High 09 12 2017   grade_9 226 5 41   2 5     3   21   147 156 0   9   7   106       11.0 303 226 5 41   2 5     3   21   147 156 0   9 7 106     11 303
631328 WA Thurston   school 5309100 34033   Tumwater School District 530910002380 3925 Thurs Co Juv Det/Tumwater West E   Regular School No Other 06 12 2017   grade_9 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
631311 WA Thurston   school 5309100 34033   Tumwater School District 530910003017 5014 New Market High School   Alternative School No High 10 12 2017   grade_9 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
631264 WA Thurston   school 5309100 34033   Tumwater School District 530910002602 4500 A G West Black Hills High School   Regular School No High 09 12 2017   grade_9 183 6 23   2 6     0   18   129 109 0   0   5   71       13.0 238 183 6 23   2 6     0   18   129 109 0   0 5 71     13 238
631239 WA King   school 5308130 17406   Tukwila School District 530813001341 2848 Foster Senior High School   Regular School No High 09 12 2017   grade_9 39 55 55   1 86     14   9   121 138 0   65   17   186       7.0 259 39 55 55   1 86     14   9   121 138 0   65 17 186     7 259
631225 WA Klickitat   school 5309060 20400   Trout Lake School District 530906001539 2676 Trout Lake School   Regular School No Other 05 12 2017   grade_9 14 0 3   0 0     0   0   5 12 0   0   1   0       1.0 17 14 0 3   0 0     0   0   5 12 0   0 1 0     1 17
631209 WA Cowlitz   school 5309030 8130   Toutle Lake School District 530903001538 2560 Toutle Lake High School   Regular School No High 07 12 2017   grade_9 45 0 3   0 0     0   3   26 25 0   0   0   17       3.0 51 45 0 3   0 0     0   3   26 25 0   0 0 17     3 51
631191 WA Walla Walla   school 5309000 36300   Touchet School District 530900001536 2160 Touchet Elem & High School   Regular School No Other KG 12 2017   grade_9 4 0 5   1 0     0   0   4 6 0   0   0   3       1.0 10 4 0 5   1 0     0   0   4 6 0   0 0 3     1 10
631165 WA Yakima   school 5308970 39202   Toppenish School District 530897001534 2900 Toppenish High School   Regular School No High 09 12 2017   grade_9 5 0 237   40 0     0   2   154 130 0   85   14   254       7.0 284 5 0 237   40 0     0   2   154 130 0   85 14 254     7 284
631160 WA Yakima   school 5308970 39202   Toppenish School District 530897003385 5262 Northwest Allprep   Regular School No Other KG 12 2017   grade_9 53 1 7   1 2     0   1   35 30 0   2   0   9       0.0 65 53 1 7   1 2     0   1   35 30 0   2 0 9     0 65
631128 WA Yakima   school 5308970 39202   Toppenish School District 530897002378 1508 Computer Academy Toppenish High School   Alternative School No Other 06 12 2017   grade_9 1 1 4   0 0     0   0   6 0 0   1   0   5       1.0 6 1 1 4   0 0     0   0   6 0 0   1 0 5     1 6
631117 WA Okanogan   school 5308940 24404   Tonasket School District 530894001530 2679 Tonasket High School   Regular School No High 09 12 2017   grade_9 60 0 31   2 0     0   4   56 41 0   3   13   68       2.0 97 60 0 31   2 0     0   4   56 41 0   3 13 68     2 97
631099 WA Lewis   school 5308910 21237   Toledo School District 530891001527 2616 Toledo High School   Regular School No High 09 12 2017   grade_9 51 0 3   0 1     0   4   28 31 0   1   5   34       0.0 59 51 0 3   0 1     0   4   28 31 0   1 5 34     0 59
631086 WA Lewis   school 5308910 21237   Toledo School District 530891003310 5190 Cowlitz Prairie Academy   Regular School No High 07 12 2017   grade_9 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
631077 WA Kittitas   school 5308850 19400   Thorp School District 530885001525 2514 Thorp Elem & Jr Sr High   Regular School No Other KG 12 2017   grade_9 13 0 0   0 0     0   0   5 8 0   0   0   6       1.0 13 13 0 0   0 0     0   0   5 8 0   0 0 6     1 13
631060 WA Thurston   school 5308820 34402   Tenino School District 530882001522 3509 Tenino High School   Regular School No High 09 12 2017   grade_9 93 0 1   1 0     1   2   46 52 0   0   1   45       2.0 98 93 0 1   1 0     1   2   46 52 0   0 1 45     2 98
631046 WA Whitman   school 5308790 38265   Tekoa School District 530879001521 3418 Tekoa High School   Regular School No High 07 12 2017   grade_9 9 1 1   1 0     0   0   5 7 0   1   0   6       0.0 12 9 1 1   1 0     0   0   5 7 0   1 0 6     0 12
631025 WA King   school 5308760 17409   Tahoma School District 530876002874 4556 Tahoma Jr High (Closed after 2016-2017 school year)   Regular School No Other 08 09 2017   grade_9 482 13 57   3 32     2   62   333 318 0   2   4   91       55.0 651 482 13 57   3 32     2   62   333 318 0   2 4 91     55 651
630977 WA Grays Harbor   school 5308730 14077   Taholah School District 530873001514 3580 Taholah High School   Regular School No High 09 12 2017   grade_9 0 0 2   6 0     0   3   6 5 0   0   1   7       0.0 11 0 0 2   6 0     0   3   6 5 0   0 1 7     0 11
630961 WA Pierce   school 5308700 27010   Tacoma School District 530870001513 3246 Wilson   Regular School No High 09 12 2017   grade_9 207 58 33   2 27     3   19   171 178 0   8   3   159       8.0 349 207 58 33   2 27     3   19   171 178 0   8 3 159     8 349
630926 WA Pierce   school 5308700 27010   Tacoma School District 530870002177 4283 The School at Pearl Youth Residence   Special Education School No Other 06 12 2017   grade_9 2 0 0   0 0     0   1   3 0 0   0   1   3       0.0 3 2 0 0   0 0     0   1   3 0 0   0 1 3     0 3
630920 WA Pierce   school 5308700 27010   Tacoma School District 530870002846 1860 Tacoma School of the Arts   Regular School No High 09 12 2017   grade_9 89 27 27   2 9     2   10   38 128 0   1   2   78       9.0 166 89 27 27   2 9     2   10   38 128 0   1 2 78     9 166
630899 WA Pierce   school 5308700 27010   Tacoma School District 530870001502 2084 Stadium   Regular School No High 09 12 2017   grade_9 208 41 44   9 43     5   19   177 192 0   19   7   150       12.0 369 208 41 44   9 43     5   19   177 192 0   19 7 150     12 369
630892 WA Pierce   school 5308700 27010   Tacoma School District 530870003275 5192 Special Services   Alternative School No Other PK 12 2017   grade_9 2 1 0   1 0     0   0   3 1 0   1   0   2       0.0 4 2 1 0   1 0     0   0   3 1 0   1 0 2     0 4
630857 WA Pierce   school 5308700 27010   Tacoma School District 530870003286 5169 Science and Math Institute   Regular School No High 09 12 2017   grade_9 59 16 14   0 12     1   10   48 64 0   2   4   50       9.0 112 59 16 14   0 12     1   10   48 64 0   2 4 50     9 112
630844 WA Pierce   school 5308700 27010   Tacoma School District 530870002171 2039 Remann Hall Juvenile Detention Center   Regular School No Other 05 12 2017   grade_9 2 0 0   0 0     0   0   2 0 0   0   0   1       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 1     0 2
630823 WA Pierce   school 5308700 27010   Tacoma School District 530870001811 4109 Oakland High School   Alternative School No High 09 12 2017   grade_9 2 6 4   0 1     0   1   6 8 0   1   5   13       1.0 14 2 6 4   0 1     0   1   6 8 0   1 5 13     1 14
630810 WA Pierce   school 5308700 27010   Tacoma School District 530870001488 3398 Mt Tahoma   Regular School No High 09 12 2017   grade_9 102 63 93   9 58     19   24   194 174 0   41   19   279       8.0 368 102 63 93   9 58     19   24   194 174 0   41 19 279     8 368
630748 WA Pierce   school 5308700 27010   Tacoma School District 530870001476 2215 Lincoln   Regular School No High 09 12 2017   grade_9 80 72 109   7 75     24   40   211 196 0   59   20   331       10.0 407 80 72 109   7 75     24   40   211 196 0   59 20 331     10 407
630727 WA Pierce   school 5308700 27010   Tacoma School District 530870001473 2338 Jason Lee   Regular School No Middle 06 08 2017   grade_9 0 0 0   0 0     0   1   1 0 0   0   0   0       0.0 1 0 0 0   0 0     0   1   1 0 0   0 0 0     0 1
630722 WA Pierce   school 5308700 27010   Tacoma School District 530870003575 5458 Industrial Design Engineering and Art   Regular School No Other 09 09 2017   grade_9 71 19 15   1 14     2   2   92 32 0   4   1   53       8.0 124 71 19 15   1 14     2   2   92 32 0   4 1 53     8 124
630684 WA Pierce   school 5308700 27010   Tacoma School District 530870001466 3880 Foss   Regular School No High 09 12 2017   grade_9 65 40 35   1 42     8   15   122 84 0   34   13   146       11.0 206 65 40 35   1 42     8   15   122 84 0   34 13 146     11 206
630636 WA Pierce   school 5308700 27010   Tacoma School District 530870003093 1797 Day Reporting School (Closed after 2018-2019 school year)   Alternative School No High 09 12 2017   grade_9 2 0 0   0 0     0   0   2 0 0   0   0   0       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 0     0 2
630564 WA Kitsap   school 5300328 18902   Suquamish Tribal Education Department 530032803493 5319 Chief Kitsap Academy   Regular School No Other KG 12 2017   grade_9 0 1 2   3 0     0   4   5 5 0   0   0   9       0.0 10 0 1 2   3 0     0   4   5 5 0   0 0 9     0 10
630547 WA Yakima   school 5308670 39201   Sunnyside School District 530867001449 2959 Sunnyside High School   Regular School No High 09 12 2017   grade_9 31 1 439   0 0     0   4   238 237 0   99   7   397       4.0 475 31 1 439   0 0     0   4   238 237 0   99 7 397     4 475
630490 WA Pierce   school 5308610 27320   Sumner School District 530861001446 3247 Sumner High School   Regular School No High 09 12 2017   grade_9 326 3 53   5 9     2   31   208 221 0   8   3   123       27.0 429 326 3 53   5 9     2   31   208 221 0   8 3 123     27 429
630428 WA Pierce   school 5308610 27320   Sumner School District 530861002998 4585 Bonney Lake High School   Regular School No High 09 12 2017   grade_9 276 6 38   4 3     4   32   192 171 0   3   7   116       23.0 363 276 6 38   4 3     4   32   192 171 0   3 7 116     23 363

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