Data source: Big Local News · About: Big Local

844 rows where grade = "grade_6", state = "WA" and year = 2017 sorted by rowid descending

View and edit SQL

year

  • 2017 · 844

grade

  • grade_6 · 844
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
632795 WA Yakima   school 5310170 39205   Zillah School District 531017002502 4481 Zillah Middle School   Regular School No Middle 07 08 2017   grade_6 0 0 1   0 0     0   0   0 1 0   1   0   1       0.0 1 0 0 1   0 0     0   0   0 1 0   1 0 1     0 1
632793 WA Yakima   school 5310170 39205   Zillah School District 531017001896 4221 Zillah Intermediate School   Regular School No Elementary 04 06 2017   grade_6 36 0 49   3 0     0   2   53 37 0   13   0   57       1.0 90 36 0 49   3 0     0   2   53 37 0   13 0 57     1 90
632775 WA Thurston   school 5310140 34002   Yelm School District 531014001916 4224 Yelm Prairie Elementary   Regular School No Elementary PK 06 2017   grade_6 55 0 13   2 0     0   10   42 38 0   2   0   33       5.0 80 55 0 13   2 0     0   10   42 38 0   2 0 33     5 80
632751 WA Thurston   school 5310140 34002   Yelm School District 531014001715 3848 Southworth Elementary   Regular School No Elementary KG 06 2017   grade_6 61 2 14   4 2     1   10   51 43 0   0   0   39       5.0 94 61 2 14   4 2     1   10   51 43 0   0 0 39     5 94
632738 WA Thurston   school 5310140 34002   Yelm School District 531014001204 4451 Mill Pond Elementary School   Regular School No Elementary PK 06 2017   grade_6 44 1 13   0 0     0   5   31 32 0   1   0   35       3.0 63 44 1 13   0 0     0   5   31 32 0   1 0 35     3 63
632729 WA Thurston   school 5310140 34002   Yelm School District 531014001714 2260 McKenna Elementary   Regular School No Elementary KG 06 2017   grade_6 54 0 9   2 1     2   7   28 47 0   2   1   46       5.0 75 54 0 9   2 1     2   7   28 47 0   2 1 46     5 75
632720 WA Thurston   school 5310140 34002   Yelm School District 531014003016 5018 Lackamas Elementary   Regular School No Elementary KG 06 2017   grade_6 36 0 7   0 1     0   6   30 20 0   0   0   24       1.0 50 36 0 7   0 1     0   6   30 20 0   0 0 24     1 50
632711 WA Thurston   school 5310140 34002   Yelm School District 531014002393 4346 Fort Stevens Elementary   Regular School No Elementary PK 06 2017   grade_6 45 0 14   1 1     1   16   39 39 0   0   3   43       4.0 78 45 0 14   1 1     1   16   39 39 0   0 3 43     4 78
632686 WA Yakima   school 5310110 39007   Yakima School District 531011001710 3368 Wilson Middle School   Regular School No Middle 06 08 2017   grade_6 82 0 173   5 1     0   6   130 137 0   58   10   198       12.0 267 82 0 173   5 1     0   6   130 137 0   58 10 198     12 267
632674 WA Yakima   school 5310110 39007   Yakima School District 531011001708 2314 Washington Middle School   Regular School No Middle 06 08 2017   grade_6 12 3 256   2 0     0   1   135 139 0   136   20   260       9.0 274 12 3 256   2 0     0   1   135 139 0   136 20 260     9 274
632616 WA Yakima   school 5310110 39007   Yakima School District 531011001814 3817 Martin Luther King Jr Elementary   Regular School No Elementary KG 05 2017   grade_6 2 0 2   0 0     0   0   3 1 0   0   0   3       0.0 4 2 0 2   0 0     0   0   3 1 0   0 0 3     0 4
632607 WA Yakima   school 5310110 39007   Yakima School District 531011001698 3615 Lewis & Clark Middle School   Regular School No Middle 06 08 2017   grade_6 28 0 243   3 1     0   3   131 147 0   98   6   256       7.0 278 28 0 243   3 1     0   3   131 147 0   98 6 256     7 278
632573 WA Yakima   school 5310110 39007   Yakima School District 531011001691 2410 Franklin Middle School   Regular School No Middle 06 08 2017   grade_6 54 1 208   4 0     0   5   143 129 0   75   9   236       4.0 272 54 1 208   4 0     0   5   143 129 0   75 9 236     4 272
632561 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2017   grade_6 17 0 12   0 0     0   2   13 18 0   4   0   13       0.0 31 17 0 12   0 0     0   2   13 18 0   4 0 13     0 31
632518 WA Cowlitz   school 5310050 8404   Woodland School District 531005003509 5409 Woodland Middle School   Regular School No Middle 05 08 2017   grade_6 146 3 39   1 0     0   3   100 92 0   17   8   92       4.0 192 146 3 39   1 0     0   3   100 92 0   17 8 92     4 192
632497 WA Cowlitz   school 5310050 8404   Woodland School District 531005003371 5246 Lewis River Academy   Alternative School No Other KG 12 2017   grade_6 6 0 3   0 0     0   0   5 4 0   0   0   4       0.0 9 6 0 3   0 0     0   0   5 4 0   0 0 4     0 9
632482 WA Klickitat   school 5310020 20094   Wishram School District 531002001680 2605 Wishram High And Elementary Schl   Regular School No Other PK 12 2017   grade_6 5 0 0   0 0     0   0   2 3 0   0   1   5       1.0 5 5 0 0   0 0     0   0   2 3 0   0 1 5     1 5
632468 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_6 18 0 0   0 0     0   0   7 11 0   0   2   9       0.0 18 18 0 0   0 0     0   0   7 11 0   0 2 9     0 18
632439 WA Lewis   school 5309930 21232   Winlock School District 530993002392 4369 Winlock Middle School   Regular School No Middle 06 08 2017   grade_6 41 0 9   0 0     0   4   31 24 0   8   4   46       0.0 55 41 0 9   0 0     0   4   31 24 0   8 4 46     0 55
632428 WA Grant   school 5309900 13167   Wilson Creek School District 530990001674 2472 Wilson Creek Elementary   Regular School No Elementary KG 06 2017   grade_6 9 0 1   0 0     0   0   2 8 0   1   0   6       0.0 10 9 0 1   0 0     0   0   2 8 0   1 0 6     0 10
632418 WA Pacific   school 5309870 25160   Willapa Valley School District 530987001673 2542 Willapa Valley Middle-High   Regular School No Other 06 12 2017   grade_6 25 0 2   0 1     0   1   16 13 0   0   0   11       1.0 29 25 0 2   0 1     0   1   16 13 0   0 0 11     1 29
632397 WA Lincoln   school 5309840 22200   Wilbur School District 530984001667 3290 Wilbur Elementary School   Regular School No Elementary KG 06 2017   grade_6 14 0 2   0 0     0   2   6 12 0   0   0   9       0.0 18 14 0 2   0 0     0   2   6 12 0   0 0 9     0 18
632383 WA Klickitat   school 5309810 20405   White Salmon Valley School District 530981003500 5368 Wallace & Priscilla Stevenson Intermediate School   Regular School No Elementary 04 06 2017   grade_6 48 0 25   0 0     0   2   40 35 0   9   0   31       2.0 75 48 0 25   0 0     0   2   40 35 0   9 0 31     2 75
632364 WA Pierce   school 5309780 27416   White River School District 530978001894 4170 Wilkeson Elementary School   Regular School No Elementary KG 05 2017   grade_6 0 0 0   0 0     0   1   0 1 0   0   0   0       0.0 1 0 0 0   0 0     0   1   0 1 0   0 0 0     0 1
632332 WA Pierce   school 5309780 27416   White River School District 530978003005 3458 Glacier Middle School   Regular School No Middle 06 08 2017   grade_6 198 1 37   2 1     0   14   136 117 0   3   5   82       10.0 253 198 1 37   2 1     0   14   136 117 0   3 5 82     10 253
632303 WA Lewis   school 5309750 21303   White Pass School District 530975001658 3555 White Pass Elementary School   Regular School No Elementary KG 06 2017   grade_6 45 0 2   1 0     0   0   23 25 0   0   6   32       0.0 48 45 0 2   1 0     0   0   23 25 0   0 6 32     0 48
632282 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972002545 4506 West Valley Middle School   Regular School No Middle 05 06 2017   grade_6 250 0 121   2 13     1   15   204 198 0   29   1   67       11.0 402 250 0 121   2 13     1   15   204 198 0   29 1 67     11 402
632221 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969002685 1755 West Valley City School   Alternative School No Middle 05 08 2017   grade_6 50 0 5   0 1     0   7   23 40 0   0   0   25       2.0 63 50 0 5   0 1     0   7   23 40 0   0 0 25     2 63
632172 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001645 3538 Centennial Middle School   Regular School No Middle 06 08 2017   grade_6 137 5 24   3 2     0   24   117 78 0   7   13   115       8.0 195 137 5 24   3 2     0   24   117 78 0   7 13 115     8 195
632155 WA Chelan   school 5309660 4246   Wenatchee School District 530966001638 2907 Washington Elementary School   Regular School No Elementary KG 05 2017   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
632143 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_6 19 1 1   0 0     0   0   11 10 0   0   0   3       1.0 21 19 1 1   0 0     0   0   11 10 0   0 0 3     1 21
632120 WA Chelan   school 5309660 4246   Wenatchee School District 530966001635 3210 Pioneer Middle School   Regular School No Middle 06 08 2017   grade_6 87 2 108   4 1     0   5   111 96 0   61   13   128       12.0 207 87 2 108   4 1     0   5   111 96 0   61 13 128     12 207
632116 WA Chelan   school 5309660 4246   Wenatchee School District 530966001634 3370 Orchard Middle School   Regular School No Middle 06 08 2017   grade_6 45 1 107   0 0     0   1   83 71 0   55   7   124       10.0 154 45 1 107   0 0     0   1   83 71 0   55 7 124     10 154
632086 WA Chelan   school 5309660 4246   Wenatchee School District 530966001006 4432 Foothills Middle School   Regular School No Middle 06 08 2017   grade_6 85 0 85   0 6     0   7   85 98 0   28   6   96       6.0 183 85 0 85   0 6     0   7   85 98 0   28 6 96     6 183
632059 WA Stevens   school 5309630 33049   Wellpinit School District #49 530963003150 4232 Wellpinit Middle School   Regular School No Middle 06 08 2017   grade_6 0 0 1   23 0     0   8   19 13 0   6   6   30       0.0 32 0 0 1   23 0     0   8   19 13 0   6 6 30     0 32
632034 WA Douglas   school 5309600 9209   Waterville School District 530960001628 2162 Waterville High School   Regular School No Other 06 12 2017   grade_6 12 0 3   0 0     0   0   4 11 0   1   1   7       0.0 15 12 0 3   0 0     0   0   4 11 0   1 1 7     0 15
632015 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other KG 12 2017   grade_6 4 0 1   0 0     0   0   3 2 0   0   0   3       0.0 5 4 0 1   0 0     0   0   3 2 0   0 0 3     0 5
631996 WA Clark   school 5309540 6112   Washougal School District 530954001892 4207 Jemtegaard Middle School   Regular School No Middle 06 08 2017   grade_6 154 0 24   0 0     1   14   94 99 0   9   7   84       9.0 193 154 0 24   0 0     1   14   94 99 0   9 7 84     9 193
631966 WA Clark   school 5309540 6112   Washougal School District 530954002709 4549 Canyon Creek Middle School   Regular School No Middle 06 08 2017   grade_6 69 0 4   1 0     0   5   42 37 0   1   3   24       6.0 79 69 0 4   1 0     0   5   42 37 0   1 3 24     6 79
631954 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_6 1 0 1   0 1     0   0   2 1 0   0   0   1       0.0 3 1 0 1   0 1     0   0   2 1 0   0 0 1     0 3
631942 WA Grant   school 5309510 13146   Warden School District 530951001620 3909 Warden Middle School   Regular School No Middle 06 08 2017   grade_6 12 0 56   0 0     0   2   25 45 0   24   12   64       0.0 70 12 0 56   0 0     0   2   25 45 0   24 12 64     0 70
631924 WA Yakima   school 5309480 39207   Wapato School District 530948001615 2131 Wapato Middle School   Regular School No Middle 06 08 2017   grade_6 5 0 185   67 3     0   8   149 119 0   94   17   263       1.0 268 5 0 185   67 3     0   8   149 119 0   94 17 263     1 268
631873 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001606 2159 Prospect Point Elementary   Regular School No Elementary KG 05 2017   grade_6 0 0 1   0 0     0   0   1 0 0   0   0   1       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 1     0 1
631864 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001605 2780 Pioneer Middle School   Regular School No Middle 06 08 2017   grade_6 124 2 96   1 5     0   5   126 107 0   39   9   132       8.0 233 124 2 96   1 5     0   5   126 107 0   39 9 132     8 233
631843 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001601 3510 Garrison Middle School   Regular School No Middle 06 08 2017   grade_6 118 2 80   0 3     0   5   98 110 0   31   4   106       10.0 208 118 2 80   0 3     0   5   98 110 0   31 4 106     10 208
631797 WA Walla Walla   school 5309390 36401   Waitsburg School District 530939002492 2174 Preston Hall Middle School   Regular School No Middle 06 08 2017   grade_6 18 0 4   0 0     0   1   15 8 0   0   0   17       0.0 23 18 0 4   0 0     0   1   15 8 0   0 0 17     0 23
631792 WA Grant   school 5309360 13073   Wahluke School District 530936003264 5144 Wahluke Junior High   Regular School No Middle 06 08 2017   grade_6 1 0 210   0 0     0   0   122 89 0   135   9   210       5.0 211 1 0 210   0 0     0   0   122 89 0   135 9 210     5 211
631746 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 2017   grade_6 36 0 7   1 0     1   0   19 26 0   0   3   36       1.0 45 36 0 7   1 0     1   0   19 26 0   0 3 36     1 45
631728 WA King   school 5309300 17402   Vashon Island School District 530930001589 3667 McMurray Middle School   Regular School No Middle 06 08 2017   grade_6 103 1 13   0 3     0   18   73 65 0   5   0   31       17.0 138 103 1 13   0 3     0   18   73 65 0   5 0 31     17 138
631722 WA King   school 5309300 17402   Vashon Island School District 530930002720 1822 Family Link   Alternative School No Other KG 12 2017   grade_6 3 0 0   0 0     0   1   4 0 0   0   0   2       0.0 4 3 0 0   0 0     0   1   4 0 0   0 0 2     0 4
631709 WA King   school 5309300 17402   Vashon Island School District 530930001394 4468 Chautauqua Elementary   Regular School No Elementary PK 05 2017   grade_6 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
631684 WA Clark   school 5309270 6037   Vancouver School District 530927003246 5149 Vancouver Virtual Learning Academy   Alternative School No Other 06 12 2017   grade_6 1 0 1   0 0     0   0   2 0 0   0   0   2       0.0 2 1 0 1   0 0     0   0   2 0 0   0 0 2     0 2
631676 WA Clark   school 5309270 6037   Vancouver School District 530927002508 1689 Vancouver School of Arts and Academics   Regular School No Other 06 12 2017   grade_6 72 2 11   1 4     1   3   30 64 0   0   0   15       2.0 94 72 2 11   1 4     1   3   30 64 0   0 0 15     2 94
631668 WA Clark   school 5309270 6037   Vancouver School District 530927003415 5271 Vancouver iTech Preparatory   Regular School No Other 06 12 2017   grade_6 33 1 14   0 2     0   8   39 19 0   0   0   24       7.0 58 33 1 14   0 2     0   8   39 19 0   0 0 24     7 58
631658 WA Clark   school 5309270 6037   Vancouver School District 530927002943 3556 Vancouver Home Connection   Alternative School No Other KG 12 2017   grade_6 12 0 3   0 0     0   1   6 10 0   0   0   9       1.0 16 12 0 3   0 0     0   1   6 10 0   0 0 9     1 16
631640 WA Clark   school 5309270 6037   Vancouver School District 530927002944 4591 Thomas Jefferson Middle School   Regular School No Middle 06 08 2017   grade_6 207 3 27   4 4     2   24   129 142 0   8   3   74       6.0 271 207 3 27   4 4     2   24   129 142 0   8 3 74     6 271
631586 WA Clark   school 5309270 6037   Vancouver School District 530927001577 3146 Mcloughlin Middle School   Regular School No Middle 06 08 2017   grade_6 109 14 156   1 12     14   23   152 177 0   91   24   275       8.0 329 109 14 156   1 12     14   23   152 177 0   91 24 275     8 329
631555 WA Clark   school 5309270 6037   Vancouver School District 530927001570 3543 Jason Lee Middle School   Regular School No Middle 06 08 2017   grade_6 151 4 52   0 15     3   20   135 110 0   27   3   107       8.0 245 151 4 52   0 15     3   20   135 110 0   27 3 107     8 245
631506 WA Clark   school 5309270 6037   Vancouver School District 530927001562 3902 Gaiser Middle School   Regular School No Middle 06 08 2017   grade_6 146 9 80   3 14     5   19   142 134 0   36   11   175       9.0 276 146 9 80   3 14     5   19   142 134 0   36 11 175     9 276
631489 WA Clark   school 5309270 6037   Vancouver School District 530927002408 1574 Fir Grove Childrens Center   Special Education School No Other KG 12 2017   grade_6 0 0 4   1 0     0   1   6 0 0   0   0   3       0.0 6 0 0 4   1 0     0   1   6 0 0   0 0 3     0 6
631462 WA Clark   school 5309270 6037   Vancouver School District 530927002018 4503 Discovery Middle School   Regular School No Middle 06 08 2017   grade_6 110 10 102   1 8     1   17   124 125 0   37   18   196       8.0 249 110 10 102   1 8     1   17   124 125 0   37 18 196     8 249
631439 WA Clark   school 5309270 6037   Vancouver School District 530927000578 4406 Alki Middle School   Regular School No Middle 06 08 2017   grade_6 175 5 16   1 7     0   14   110 108 0   8   0   54       7.0 218 175 5 16   1 7     0   14   110 108 0   8 0 54     7 218
631434 WA Stevens   school 5309240 33070   Valley School District 530924001555 2405 Valley School   Regular School No Elementary KG 08 2017   grade_6 23 0 0   1 0     0   3   16 11 0   0   0   22       0.0 27 23 0 0   1 0     0   3   16 11 0   0 0 22     0 27
631417 WA Stevens   school 5309240 33070   Valley School District 530924003107 1932 Columbia Virtual Academy   Alternative School No Elementary KG 08 2017   grade_6 50 1 6   0 2     1   5   29 36 0   1   1   0       0.0 65 50 1 6   0 2     1   5   29 36 0   1 1 0     0 65
631393 WA Pierce   school 5309180 27083   University Place School District 530918001550 3296 Narrows View Intermediate   Regular School No Middle 05 07 2017   grade_6 120 17 46   3 19     2   40   114 133 0   12   0   102       15.0 247 120 17 46   3 19     2   40   114 133 0   12 0 102     15 247
631380 WA Pierce   school 5309180 27083   University Place School District 530918002383 4325 Drum Intermediate   Regular School No Middle 05 07 2017   grade_6 92 29 35   1 21     5   30   105 108 0   10   2   88       9.0 213 92 29 35   1 21     5   30   105 108 0   10 2 88     9 213
631353 WA Yakima   school 5309150 39002   Union Gap School District 530915002382 2714 Union Gap School   Regular School No Elementary PK 08 2017   grade_6 14 0 52   2 3     0   0   39 32 0   13   3   67       0.0 71 14 0 52   2 3     0   0   39 32 0   13 3 67     0 71
631340 WA Thurston   school 5309100 34033   Tumwater School District 530910002381 4373 Tumwater Hill Elementary   Regular School No Elementary KG 06 2017   grade_6 21 1 13   0 1     0   5   25 16 0   2   2   15       3.0 41 21 1 13   0 1     0   5   25 16 0   2 2 15     3 41
631321 WA Thurston   school 5309100 34033   Tumwater School District 530910001543 3199 Peter G Schmidt Elementary   Regular School No Elementary KG 06 2017   grade_6 73 0 14   0 4     0   8   49 50 0   2   2   31       3.0 99 73 0 14   0 4     0   8   49 50 0   2 2 31     3 99
631303 WA Thurston   school 5309100 34033   Tumwater School District 530910001542 2552 Michael T Simmons Elementary   Regular School No Elementary PK 06 2017   grade_6 50 2 10   0 4     1   7   40 34 0   0   5   24       5.0 74 50 2 10   0 4     1   7   40 34 0   0 5 24     5 74
631295 WA Thurston   school 5309100 34033   Tumwater School District 530910001541 2816 Littlerock Elementary School   Regular School No Elementary KG 06 2017   grade_6 39 0 6   2 1     1   9   32 26 0   2   1   27       1.0 58 39 0 6   2 1     1   9   32 26 0   2 1 27     1 58
631284 WA Thurston   school 5309100 34033   Tumwater School District 530910002379 4365 East Olympia Elementary   Regular School No Elementary KG 06 2017   grade_6 60 3 12   0 2     0   10   43 44 0   1   2   17       2.0 87 60 3 12   0 2     0   10   43 44 0   1 2 17     2 87
631271 WA Thurston   school 5309100 34033   Tumwater School District 530910001889 4205 Black Lake Elementary   Regular School No Elementary KG 06 2017   grade_6 58 0 10   0 3     0   4   38 37 0   1   2   22       3.0 75 58 0 10   0 3     0   4   38 37 0   1 2 22     3 75
631241 WA King   school 5308130 17406   Tukwila School District 530813001342 2564 Showalter Middle School   Regular School No Middle 06 08 2017   grade_6 21 35 71   1 60     9   10   109 98 0   74   22   166       1.0 207 21 35 71   1 60     9   10   109 98 0   74 22 166     1 207
631222 WA Klickitat   school 5309060 20400   Trout Lake School District 530906001539 2676 Trout Lake School   Regular School No Other 05 12 2017   grade_6 12 0 2   2 0     0   2   8 10 0   0   2   0       0.0 18 12 0 2   2 0     0   2   8 10 0   0 2 0     0 18
631199 WA Cowlitz   school 5309030 8130   Toutle Lake School District 530903002069 4264 Toutle Lake Elementary   Regular School No Elementary KG 06 2017   grade_6 40 0 5   2 0     0   1   24 24 0   0   1   24       2.0 48 40 0 5   2 0     0   1   24 24 0   0 1 24     2 48
631188 WA Walla Walla   school 5309000 36300   Touchet School District 530900001536 2160 Touchet Elem & High School   Regular School No Other KG 12 2017   grade_6 3 0 11   0 0     0   0   10 4 0   2   0   10       0.0 14 3 0 11   0 0     0   0   10 4 0   2 0 10     0 14
631167 WA Yakima   school 5308970 39202   Toppenish School District 530897001535 2264 Toppenish Middle School   Regular School No Middle 06 08 2017   grade_6 7 0 260   31 0     0   6   146 158 0   133   19   269       13.0 304 7 0 260   31 0     0   6   146 158 0   133 19 269     13 304
631157 WA Yakima   school 5308970 39202   Toppenish School District 530897003385 5262 Northwest Allprep   Regular School No Other KG 12 2017   grade_6 38 3 1   4 5     0   0   22 29 0   1   0   4       0.0 51 38 3 1   4 5     0   0   22 29 0   1 0 4     0 51
631119 WA Okanogan   school 5308940 24404   Tonasket School District 530894001647 4196 Tonasket Middle School   Regular School No Middle 06 08 2017   grade_6 54 0 44   0 0     1   4   50 53 0   24   13   77       2.0 103 54 0 44   0 0     1   4   50 53 0   24 13 77     2 103
631101 WA Lewis   school 5308910 21237   Toledo School District 530891001528 3977 Toledo Middle School   Regular School No Middle 06 08 2017   grade_6 48 0 5   1 0     0   4   27 31 0   2   3   36       0.0 58 48 0 5   1 0     0   4   27 31 0   2 3 36     0 58
631074 WA Kittitas   school 5308850 19400   Thorp School District 530885001525 2514 Thorp Elem & Jr Sr High   Regular School No Other KG 12 2017   grade_6 12 0 2   0 0     0   0   8 6 0   0   1   9       0.0 14 12 0 2   0 0     0   0   8 6 0   0 1 9     0 14
631062 WA Thurston   school 5308820 34402   Tenino School District 530882001523 3795 Tenino Middle School   Regular School No Middle 06 08 2017   grade_6 76 0 8   1 0     0   7   60 32 0   2   2   39       1.0 92 76 0 8   1 0     0   7   60 32 0   2 2 39     1 92
631036 WA Whitman   school 5308790 38265   Tekoa School District 530879001520 2052 Tekoa Elementary School   Regular School No Elementary PK 06 2017   grade_6 18 0 2   0 0     0   0   8 12 0   0   0   9       0.0 20 18 0 2   0 0     0   0   8 12 0   0 0 9     0 20
631018 WA King   school 5308760 17409   Tahoma School District 530876002979 3341 Summit Trail Middle School   Regular School No Middle 06 07 2017   grade_6 241 5 25   0 10     0   20   146 155 0   7   1   31       17.0 301 241 5 25   0 10     0   20   146 155 0   7 1 31     17 301
631004 WA King   school 5308760 17409   Tahoma School District 530876000692 4415 Rock Creek Elementary   Regular School No Elementary PK 05 2017   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
630996 WA King   school 5308760 17409   Tahoma School District 530876001515 3937 Maple View Middle School   Regular School No Middle 06 07 2017   grade_6 224 7 38   2 15     6   41   160 173 0   9   2   57       22.0 333 224 7 38   2 15     6   41   160 173 0   9 2 57     22 333
630968 WA Grays Harbor   school 5308730 14077   Taholah School District 530873002956 5032 Taholah Elementary & Middle School   Regular School No Elementary KG 08 2017   grade_6 0 0 2   11 0     0   0   3 10 0   0   0   9       0.0 13 0 0 2   11 0     0   0   3 10 0   0 0 9     0 13
630934 WA Pierce   school 5308700 27010   Tacoma School District 530870001508 3116 Wainwright   Regular School No Elementary 04 06 2017   grade_6 38 16 11   1 2     1   10   38 41 0   6   3   39       5.0 79 38 16 11   1 2     1   10   38 41 0   6 3 39     5 79
630928 WA Pierce   school 5308700 27010   Tacoma School District 530870001507 3448 Truman   Regular School No Middle 06 08 2017   grade_6 125 52 42   5 20     5   11   127 133 0   26   19   165       8.0 260 125 52 42   5 20     5   11   127 133 0   26 19 165     8 260
630909 WA Pierce   school 5308700 27010   Tacoma School District 530870001504 2359 Stewart   Regular School No Middle 06 08 2017   grade_6 43 20 31   3 10     5   7   63 56 0   10   9   97       7.0 119 43 20 31   3 10     5   7   63 56 0   10 9 97     7 119
630889 WA Pierce   school 5308700 27010   Tacoma School District 530870003275 5192 Special Services   Alternative School No Other PK 12 2017   grade_6 3 1 0   0 0     0   0   3 1 0   0   0   2       0.0 4 3 1 0   0 0     0   0   3 1 0   0 0 2     0 4
630803 WA Pierce   school 5308700 27010   Tacoma School District 530870001487 3244 Meeker   Regular School No Middle 06 08 2017   grade_6 113 26 24   4 25     10   9   126 85 0   10   4   77       6.0 211 113 26 24   4 25     10   9   126 85 0   10 4 77     6 211
630791 WA Pierce   school 5308700 27010   Tacoma School District 530870001483 2376 Mason   Regular School No Middle 06 08 2017   grade_6 159 23 19   2 19     1   12   126 109 0   2   6   90       18.0 235 159 23 19   2 19     1   12   126 109 0   2 6 90     18 235
630724 WA Pierce   school 5308700 27010   Tacoma School District 530870001473 2338 Jason Lee   Regular School No Middle 06 08 2017   grade_6 80 47 28   4 9     3   6   87 90 0   4   13   118       11.0 177 80 47 28   4 9     3   6   87 90 0   4 13 118     11 177
630710 WA Pierce   school 5308700 27010   Tacoma School District 530870001471 2377 Gray   Regular School No Middle 06 08 2017   grade_6 43 59 43   0 17     11   14   100 87 0   23   14   162       2.0 187 43 59 43   0 17     11   14   100 87 0   23 14 162     2 187
630677 WA Pierce   school 5308700 27010   Tacoma School District 530870003299 5170 First Creek Middle School   Regular School No Middle 06 08 2017   grade_6 54 59 92   8 39     18   11   155 126 0   62   13   247       11.0 281 54 59 92   8 39     18   11   155 126 0   62 13 247     11 281
630618 WA Pierce   school 5308700 27010   Tacoma School District 530870001458 3397 Bryant   Regular School No Elementary PK 08 2017   grade_6 36 3 3   0 4     1   5   27 25 0   1   1   18       3.0 52 36 3 3   0 4     1   5   27 25 0   1 1 18     3 52
630578 WA Pierce   school 5308700 27010   Tacoma School District 530870001454 3054 Baker   Regular School No Middle 06 08 2017   grade_6 66 42 60   2 30     10   24   119 115 0   23   23   186       13.0 234 66 42 60   2 30     10   24   119 115 0   23 23 186     13 234
630566 WA Pierce   school 5308700 27010   Tacoma School District 530870003155 4575 Angelo Giaudrone Middle School   Regular School No Middle 06 08 2017   grade_6 61 53 45   2 24     13   33   127 104 0   24   17   170       9.0 231 61 53 45   2 24     13   33   127 104 0   24 17 170     9 231

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