Data source: Big Local News · About: Big Local

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

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
623903 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2017   grade_6 2 0 4   15 0     0   2   9 14 0   0   0   19       0.0 23 2 0 4   15 0     0   2   9 14 0   0 0 19     0 23
624976 WA King   school   17903   Muckleshoot Indian Tribe   1986 Muckleshoot Tribal School             2017   grade_6 0 1 1   38 0     0   0   26 14 0   0   0   34       0.0 40 0 1 1   38 0     0   0   26 14 0   0 0 34     0 40
625633 WA Thurston   school   34003   North Thurston Public Schools   8407 Wa He Lut Indian School(Closed)             2017   grade_6 0 0 0   4 0     0   2   3 3 0   0   0   4       0.0 6 0 0 0   4 0     0   2   3 3 0   0 0 4     0 6
626333 WA Okanogan   school   24019   Omak School District   4278 Paschal Sherman             2017   grade_6 1 1 0   12 0     0   0   5 9 0   0   0   14       0.0 14 1 1 0   12 0     0   0   5 9 0   0 0 14     0 14
627136 WA Pierce   school   27003   Puyallup School District   4110 Chief Leschi Schools(Closed)             2017   grade_6 0 0 8   34 0     0   1   19 24 0   0   3   12       0.0 43 0 0 8   34 0     0   1   19 24 0   0 3 12     0 43
627427 WA Clallam   school   5903   Quileute Tribal School District   5430 Quileute Tribal School             2017   grade_6 0 1 0   3 0     0   0   2 3 0   0   0   4       0.0 5 0 1 0   3 0     0   0   2 3 0   0 0 4     0 5
617481 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002523 1699 Odyssey Multiage Program   Regular School No Elementary 01 08 2017   grade_6 12 1 0   0 0     0   1   8 6 0   0   0   0       0.0 14 12 1 0   0 0     0   1   8 6 0   0 0 0     0 14
618467 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000157 3251 Lucille Umbarger Elementary   Regular School No Elementary 01 08 2017   grade_6 38 1 35   1 0     0   2   40 37 0   20   1   52       1.0 77 38 1 35   1 0     0   2   40 37 0   20 1 52     1 77
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
621564 WA Pierce   school 5302880 27417   Fife School District 530288002875 4557 Hedden Elementary School   Regular School No Elementary 02 05 2017   grade_6 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
617515 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2017   grade_6 53 0 2   0 0     0   3   26 32 0   0   0   8       3.0 58 53 0 2   0 0     0   3   26 32 0   0 0 8     3 58
621848 WA Snohomish   school 5303210 31332   Granite Falls School District 530321002482 4479 Monte Cristo Elementary   Regular School No Elementary 03 06 2017   grade_6 8 0 1   1 0     0   0   6 4 0   0   0   3       0.0 10 8 0 1   1 0     0   0   6 4 0   0 0 3     0 10
624644 WA Grays Harbor   school 5305160 14066   Montesano School District 530516000781 3374 Simpson Avenue Elementary   Regular School No Elementary 03 06 2017   grade_6 88 0 13   4 1     0   8   68 46 0   2   1   49       6.0 114 88 0 13   4 1     0   8   68 46 0   2 1 49     6 114
626660 WA Franklin   school 5306570 11001   Pasco School District 530657003542 5394 Marie Curie STEM Elementary   Regular School No Elementary 03 06 2017   grade_6 11 0 177   0 0     0   3   92 99 0   127   2   185       2.0 191 11 0 177   0 0     0   3   92 99 0   127 2 185     2 191
629317 WA Snohomish   school 5308020 31201   Snohomish School District 530802001324 3005 Emerson Elementary   Regular School No Elementary 03 06 2017   grade_6 71 0 21   0 1     0   5   48 50 0   9   2   48       11.0 98 71 0 21   0 1     0   5   48 50 0   9 2 48     11 98
630031 WA Spokane   school 5308250 32081   Spokane School District 530825002364 1567 Pratt Academy   Alternative School No Other 03 12 2017   grade_6 1 0 0   0 0     0   1   2 0 0   0   0   2       0.0 2 1 0 0   0 0     0   1   2 0 0   0 0 2     0 2
630345 WA Skamania   school 5308520 30303   Stevenson-Carson School District 530852001434 2882 Carson Elementary   Regular School No Elementary 03 06 2017   grade_6 42 0 16   1 0     0   2   35 26 0   2   5   40       3.0 61 42 0 16   1 0     0   2   35 26 0   2 5 40     3 61
619011 WA Lewis   school 5301140 21401   Centralia School District 530114000210 2291 Oakview Elementary School   Regular School No Elementary 04 06 2017   grade_6 81 3 36   1 0     1   3   70 55 0   13   3   101       2.0 125 81 3 36   1 0     1   3   70 55 0   13 3 101     2 125
619346 WA Pierce   school 5301410 27400   Clover Park School District 530141000271 2041 Firwood   Regular School No Other 04 12 2017   grade_6 0 1 0   0 0     0   0   0 1 0   0   0   0       0.0 1 0 1 0   0 0     0   0   0 1 0   0 0 0     0 1
620213 WA Snohomish   school 5302400 31015   Edmonds School District 530240002821 1830 Contracted Schools   Special Education School No Other 04 12 2017   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
621935 WA Yakima   school 5303510 39203   Highland School District 530351000517 3073 Tieton Intermediate School   Regular School No Elementary 04 06 2017   grade_6 18 1 71   0 0     0   2   44 48 0   33   4   85       0.0 92 18 1 71   0 0     0   2   44 48 0   33 4 85     0 92
626899 WA Mason   school 5306750 23402   Pioneer School District 530675000992 2865 Pioneer Middle School   Regular School No Elementary 04 08 2017   grade_6 68 1 14   2 0     0   4   46 43 0   1   2   65       4.0 89 68 1 14   2 0     0   4   46 43 0   1 2 65     4 89
626994 WA Jefferson   school 5306840 16050   Port Townsend School District 530684001305 4475 Blue Heron Middle School   Regular School No Elementary 04 08 2017   grade_6 87 1 11   1 4     0   6   59 51 0   0   0   60       2.0 110 87 1 11   1 4     0   6   59 51 0   0 0 60     2 110
627462 WA Clallam   school 5307020 5402   Quillayute Valley School District 530702003483 5363 Forks Intermediate School (Closed after 2019-2020 school year)   Regular School No Elementary 04 06 2017   grade_6 50 0 29   2 0     0   6   48 39 0   8   2   50       1.0 87 50 0 29   2 0     0   6   48 39 0   8 2 50     1 87
627477 WA Grant   school 5307080 13144   Quincy School District 530708002714 4536 Monument Elementary   Regular School No Elementary 04 06 2017   grade_6 15 1 163   0 0     0   0   84 95 0   83   5   160       4.0 179 15 1 163   0 0     0   0   84 95 0   83 5 160     4 179
628123 WA Grant   school 5307620 13160   Royal School District 530762003526 5388 Royal Intermediate School   Regular School No Elementary 04 06 2017   grade_6 15 0 100   0 0     0   1   57 59 0   55   8   89       8.0 116 15 0 100   0 0     0   1   57 59 0   55 8 89     8 116
629937 WA Spokane   school 5308250 32081   Spokane School District 530825002484 2401 Libby Center   Special Education School No Elementary 04 08 2017   grade_6 55 1 6   0 6     0   5   34 39 0   0   1   21       6.0 73 55 1 6   0 6     0   5   34 39 0   0 1 21     6 73
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
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
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
617493 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002734 4542 Sonoji Sakai Intermediate   Regular School No Middle 05 06 2017   grade_6 219 1 25   2 15     1   27   160 130 0   2   0   30       20.0 290 219 1 25   2 15     1   27   160 130 0   2 0 30     20 290
617500 WA Clark   school 5300380 6119   Battle Ground School District 530038000048 2671 Amboy Middle School   Regular School No Middle 05 08 2017   grade_6 137 1 2   0 0     0   4   69 75 0   1   1   57       8.0 144 137 1 2   0 0     0   4   69 75 0   1 1 57     8 144
617529 WA Clark   school 5300380 6119   Battle Ground School District 530038003262 5133 Chief Umtuch Middle   Regular School No Middle 05 08 2017   grade_6 97 0 20   0 0     0   8   69 57 0   8   2   52       6.0 126 97 0 20   0 0     0   8   69 57 0   8 2 52     6 126
617534 WA Clark   school 5300380 6119   Battle Ground School District 530038003176 5089 Daybreak Middle   Regular School No Middle 05 08 2017   grade_6 101 1 11   1 0     1   6   58 63 0   5   1   49       4.0 121 101 1 11   1 0     1   6   58 63 0   5 1 49     4 121
617568 WA Clark   school 5300380 6119   Battle Ground School District 530038000052 3545 Laurin Middle School   Regular School No Middle 05 08 2017   grade_6 123 1 13   1 3     1   9   83 69 0   17   4   66       4.0 152 123 1 13   1 3     1   9   83 69 0   17 4 66     4 152
617587 WA Clark   school 5300380 6119   Battle Ground School District 530038000054 3997 Pleasant Valley Middle   Regular School No Middle 05 08 2017   grade_6 90 2 19   2 14     2   5   69 65 0   9   4   46       3.0 134 90 2 19   2 14     2   5   69 65 0   9 4 46     3 134
617614 WA Clark   school 5300380 6119   Battle Ground School District 530038003214 5131 Tukes Valley Middle School   Regular School No Middle 05 08 2017   grade_6 98 0 13   0 0     0   8   49 70 0   4   1   44       3.0 119 98 0 13   0 0     0   8   49 70 0   4 1 44     3 119
618403 WA Douglas   school 5300720 9075   Bridgeport School District 530072001271 4213 Bridgeport Middle School   Regular School No Middle 05 08 2017   grade_6 7 0 51   0 0     1   1   23 37 0   23   2   58       3.0 60 7 0 51   0 0     1   1   23 37 0   23 2 58     3 60
618632 WA Chelan   school 5300960 4222   CASHMERE SCHOOL DISTRICT 530096000169 2315 CASHMERE MIDDLE SCHOOL   Regular School No Middle 05 08 2017   grade_6 68 1 37   0 1     0   5   57 55 0   15   3   42       5.0 112 68 1 37   0 1     0   5   57 55 0   15 3 42     5 112
619481 WA Pierce   school 5301410 27400   Clover Park School District 530141003396 5297 Transition Day Students   Regular School No Other 05 12 2017   grade_6 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
620020 WA Douglas   school 5302310 9206   Eastmont School District 530231002948 4590 Clovis Point Intermediate School   Regular School No Middle 05 07 2017   grade_6 79 0 117   0 0     0   3   111 88 0   54   6   129       4.0 199 79 0 117   0 0     0   3   111 88 0   54 6 129     4 199
620633 WA Grant   school 5302610 13165   Ephrata School District 530261002559 2695 Parkway School   Regular School No Middle 05 06 2017   grade_6 108 4 57   0 1     0   9   87 92 0   19   1   109       5.0 179 108 4 57   0 1     0   9   87 92 0   19 1 109     5 179
621253 WA King   school 5302820 17210   Federal Way School District 530282000437 3898 Illahee Middle School   Regular School No Middle 05 08 2017   grade_6 61 39 55   2 27     14   32   117 113 0   27   4   140       9.0 230 61 39 55   2 27     14   32   117 113 0   27 4 140     9 230
621730 WA Klickitat   school 5303090 20404   Goldendale School District 530309000491 3393 Goldendale Middle School   Regular School No Middle 05 08 2017   grade_6 57 0 12   2 1     0   5   47 30 0   5   1   49       1.0 77 57 0 12   2 1     0   5   47 30 0   5 1 49     1 77
621817 WA Yakima   school 5303180 39204   Granger School District 530318000504 2531 Granger Middle School   Regular School No Middle 05 08 2017   grade_6 0 0 118   4 0     0   1   65 58 0   39   1   107       1.0 123 0 0 118   4 0     0   1   65 58 0   39 1 107     1 123
623082 WA Stevens   school 5303990 33212   Kettle Falls School District 530399001904 3198 Kettle Falls Middle School   Regular School No Middle 05 08 2017   grade_6 46 0 4   0 0     0   1   24 27 0   0   3   36       2.0 51 46 0 4   0 0     0   1   24 27 0   0 3 36     2 51
623719 WA Whitman   school 5304290 38264   Lamont School District 530429000687 3137 Lamont Middle School   Regular School No Middle 05 08 2017   grade_6 6 0 0   0 0     0   0   3 3 0   0   1   5       1.0 6 6 0 0   0 0     0   0   3 3 0   0 1 5     1 6
625136 WA Yakima   school 5305460 39003   Naches Valley School District 530546000824 2898 Naches Valley Middle School   Regular School No Middle 05 08 2017   grade_6 85 0 18   1 0     0   4   49 59 0   7   4   60       1.0 108 85 0 18   1 0     0   4   49 59 0   7 4 60     1 108
625206 WA Pend Oreille   school 5305610 26056   Newport School District 530561001911 3968 Sadie Halstead Middle School   Regular School No Middle 05 08 2017   grade_6 63 0 5   0 0     0   7   35 40 0   0   7   54       2.0 75 63 0 5   0 0     0   7   35 40 0   0 7 54     2 75
626041 WA Pacific   school 5306060 25101   Ocean Beach School District 530606000911 2517 Hilltop Elementary School   Regular School No Middle 05 08 2017   grade_6 57 0 11   2 0     0   8   32 46 0   2   7   47       4.0 78 57 0 11   2 0     0   8   32 46 0   2 7 47     4 78
626183 WA Thurston   school 5306180 34111   Olympia School District 530618000925 3133 Jefferson Middle School   Regular School No Middle 05 08 2017   grade_6 79 7 15   0 18     1   14   65 69 0   3   3   71       6.0 134 79 7 15   0 18     1   14   65 69 0   3 3 71     6 134
627507 WA King   school 5300335 17908   Rainier Prep Charter School District 530033503533 5380 Rainier Prep   Regular School Yes Middle 05 08 2017   grade_6 7 20 41   1 12     1   5   44 43 0   16   6   69       0.0 87 7 20 41   1 12     1   5   44 43 0   16 6 69     0 87
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
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
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
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
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
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
617124 WA Lewis   school 5300060 21226   Adna School District 530006000013 2441 Adna Middle/High School   Regular School No Other 06 12 2017   grade_6 32 0 2   0 1     0   1   22 14 0   1   2   13       0.0 36 32 0 2   0 1     0   1   22 14 0   1 2 13     0 36
617205 WA Snohomish   school 5300240 31016   Arlington School District 530024003008 5010 Haller Middle School   Regular School No Middle 06 08 2017   grade_6 158 4 29   4 4     1   17   110 107 0   10   7   62       8.0 217 158 4 29   4 4     1   17   110 107 0   10 7 62     8 217
617226 WA Snohomish   school 5300240 31016   Arlington School District 530024000024 3124 Post Middle School   Regular School No Middle 06 08 2017   grade_6 160 0 19   1 7     0   16   102 101 0   10   8   80       6.0 203 160 0 19   1 7     0   16   102 101 0   10 8 80     6 203
617269 WA Asotin   school 5300280 2420   Asotin-Anatone School District 530028000028 2434 Asotin Jr Sr High   Regular School No Other 06 12 2017   grade_6 46 0 3   0 0     0   4   24 29 0   0   1   21       1.0 53 46 0 3   0 0     0   4   24 29 0   0 1 21     1 53
617305 WA King   school 5300300 17408   Auburn School District 530030000033 2394 Cascade Middle School   Regular School No Middle 06 08 2017   grade_6 107 25 62   0 22     11   26   117 136 0   38   4   153       3.0 253 107 25 62   0 22     11   26   117 136 0   38 4 153     3 253
617380 WA King   school 5300300 17408   Auburn School District 530030001443 4462 Mt Baker Middle School   Regular School No Middle 06 08 2017   grade_6 113 20 117   1 42     10   28   172 159 0   51   2   187       6.0 331 113 20 117   1 42     10   28   172 159 0   51 2 187     6 331
617384 WA King   school 5300300 17408   Auburn School District 530030000038 3169 Olympic Middle School   Regular School No Middle 06 08 2017   grade_6 78 24 104   10 14     17   23   142 128 0   73   3   203       2.0 270 78 24 104   10 14     17   23   142 128 0   73 3 203     2 270
617397 WA King   school 5300300 17408   Auburn School District 530030002434 4385 Rainier Middle School   Regular School No Middle 06 08 2017   grade_6 142 27 61   5 34     4   23   153 143 0   37   4   159       7.0 296 142 27 61   5 34     4   23   153 143 0   37 4 159     7 296
617644 WA King   school 5300390 17405   Bellevue School District 530039003354 5240 Bellevue Big Picture School   Alternative School No Other 06 12 2017   grade_6 46 0 3   0 18     1   6   35 39 0   4   1   10       4.0 74 46 0 3   0 18     1   6   35 39 0   4 1 10     4 74
617685 WA King   school 5300390 17405   Bellevue School District 530039000064 3338 Chinook Middle School   Regular School No Middle 06 08 2017   grade_6 144 7 29   0 92     2   25   154 145 0   28   2   36       18.0 299 144 7 29   0 92     2   25   154 145 0   28 2 36     18 299
617713 WA King   school 5300390 17405   Bellevue School District 530039000068 3166 Highland Middle School   Regular School No Middle 06 08 2017   grade_6 63 6 41   0 26     0   10   80 66 0   29   4   67       10.0 146 63 6 41   0 26     0   10   80 66 0   29 4 67     10 146
617725 WA King   school 5300390 17405   Bellevue School District 530039003149 3522 International School   Alternative School No Other 06 12 2017   grade_6 35 1 6   1 36     0   10   41 48 0   5   0   12       4.0 89 35 1 6   1 36     0   10   41 48 0   5 0 12     4 89
617767 WA King   school 5300390 17405   Bellevue School District 530039000079 3631 Odle Middle School   Regular School No Middle 06 08 2017   grade_6 85 6 37   0 179     0   16   172 151 0   21   4   60       16.0 323 85 6 37   0 179     0   16   172 151 0   21 4 60     16 323
617823 WA King   school 5300390 17405   Bellevue School District 530039000093 3435 Tillicum Middle School   Regular School No Middle 06 08 2017   grade_6 123 4 32   0 47     0   23   115 114 0   10   2   33       20.0 229 123 4 32   0 47     0   23   115 114 0   10 2 33     20 229
617827 WA King   school 5300390 17405   Bellevue School District 530039000094 3283 Tyee Middle School   Regular School No Middle 06 08 2017   grade_6 73 11 17   0 192     0   38   181 150 0   24   0   45       13.0 331 73 11 17   0 192     0   38   181 150 0   24 0 45     13 331
617896 WA Whatcom   school 5300420 37501   Bellingham School District 530042000104 2066 Fairhaven Middle School   Regular School No Middle 06 08 2017   grade_6 164 3 26   3 11     0   16   121 102 0   8   4   55       16.0 223 164 3 26   3 11     0   16   121 102 0   8 4 55     16 223
617922 WA Whatcom   school 5300420 37501   Bellingham School District 530042001739 4442 Kulshan Middle School   Regular School No Middle 06 08 2017   grade_6 130 3 32   2 3     0   10   100 80 0   11   8   78       15.0 180 130 3 32   2 3     0   10   100 80 0   11 8 78     15 180
617967 WA Whatcom   school 5300420 37501   Bellingham School District 530042000114 3201 Shuksan Middle School   Regular School No Middle 06 08 2017   grade_6 106 2 58   2 30     0   21   113 106 0   35   9   124       12.0 219 106 2 58   2 30     0   21   113 106 0   35 9 124     12 219
618006 WA Whatcom   school 5300420 37501   Bellingham School District 530042000117 2075 Whatcom Middle School   Regular School No Middle 06 08 2017   grade_6 196 2 20   0 5     0   19   130 112 0   4   5   67       20.0 242 196 2 20   0 5     0   19   130 112 0   4 5 67     20 242
618034 WA Pierce   school 5300480 27403   Bethel School District 530048000120 3250 Bethel Middle School   Regular School No Middle 06 08 2017   grade_6 98 13 54   2 5     14   32   113 108 0   13   7   142       5.0 221 98 13 54   2 5     14   32   113 108 0   13 7 142     5 221
618047 WA Pierce   school 5300480 27403   Bethel School District 530048001819 4186 Cedarcrest Middle School   Regular School No Other 06 12 2017   grade_6 92 23 35   3 13     22   28   117 99 0   4   5   157       11.0 216 92 23 35   3 13     22   28   117 99 0   4 5 157     11 216
618079 WA Pierce   school 5300480 27403   Bethel School District 530048003158 4578 Cougar Mountain Middle School   Regular School No Middle 06 08 2017   grade_6 152 6 26   3 4     5   17   101 112 0   4   2   105       5.0 213 152 6 26   3 4     5   17   101 112 0   4 2 105     5 213
618109 WA Pierce   school 5300480 27403   Bethel School District 530048000595 4407 Frontier Middle School   Regular School No Middle 06 08 2017   grade_6 148 7 22   4 6     3   28   106 112 0   3   1   92       6.0 218 148 7 22   4 6     3   28   106 112 0   3 1 92     6 218
618134 WA Pierce   school 5300480 27403   Bethel School District 530048003343 5206 Liberty Middle School   Regular School No Middle 06 08 2017   grade_6 125 18 32   1 11     12   32   127 106 0   8   1   118       10.0 233 125 18 32   1 11     12   32   127 106 0   8 1 118     10 233
618211 WA Pierce   school 5300480 27403   Bethel School District 530048000128 3751 Spanaway Middle School   Regular School No Middle 06 08 2017   grade_6 85 31 42   3 14     13   29   111 110 0   8   9   148       10.0 221 85 31 42   3 14     13   29   111 110 0   8 9 148     10 221
618253 WA Whatcom   school 5300570 37503   Blaine School District 530057000131 3796 Blaine Middle School   Regular School No Middle 06 08 2017   grade_6 125 4 22   4 8     1   7   88 83 0   9   6   92       16.0 171 125 4 22   4 8     1   7   88 83 0   9 6 92     16 171
618321 WA Kitsap   school 5300660 18100   Bremerton School District 530066001144 4441 Mountain View Middle School   Regular School No Middle 06 08 2017   grade_6 158 20 50   3 7     9   38   157 128 0   14   8   189       14.0 285 158 20 50   3 7     9   38   157 128 0   14 8 189     14 285
618380 WA Okanogan   school 5300690 24111   Brewster School District 530069002284 4223 Brewster Middle School   Regular School No Middle 06 08 2017   grade_6 6 0 54   0 0     0   0   35 25 0   20   0   57       3.0 60 6 0 54   0 0     0   0   35 25 0   20 0 57     3 60
618521 WA Clark   school 5300810 6117   Camas School District 530081003066 5054 Liberty Middle School   Regular School No Middle 06 08 2017   grade_6 162 1 28   1 7     1   22   106 116 0   4   3   43       12.0 222 162 1 28   1 7     1   22   106 116 0   4 3 43     12 222
618536 WA Clark   school 5300810 6117   Camas School District 530081002512 4508 Skyridge Middle School   Regular School No Middle 06 08 2017   grade_6 232 2 17   0 32     1   26   157 153 0   10   0   42       25.0 310 232 2 17   0 32     1   26   157 153 0   10 0 42     25 310
618573 WA Clallam   school 5300840 5401   Cape Flattery School District 530084000165 3145 Neah Bay Junior/ Senior High School   Regular School No Other 06 12 2017   grade_6 2 0 4   12 0     0   4   14 8 0   0   0   17       4.0 22 2 0 4   12 0     0   4   14 8 0   0 0 17     4 22
618616 WA Chelan   school 5300950 4228   Cascade School District 530095000553 4403 Icicle River Middle School   Regular School No Middle 06 08 2017   grade_6 59 0 26   1 0     0   1   45 43 0   11   3   43       3.0 88 59 0 26   1 0     0   1   45 43 0   11 3 43     3 88
618657 WA Cowlitz   school 5300990 8401   Castle Rock School District 530099000173 3969 Castle Rock Middle School   Regular School No Middle 06 08 2017   grade_6 71 0 11   2 0     0   5   48 41 0   3   1   46       9.0 89 71 0 11   2 0     0   5   48 41 0   3 1 46     9 89
618690 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108000178 3237 Central Kitsap Middle School   Regular School No Middle 06 08 2017   grade_6 160 6 22   1 10     2   41   126 116 0   6   0   67       16.0 242 160 6 22   1 10     2   41   126 116 0   6 0 67     16 242
618734 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108000183 3791 Fairview Middle School   Regular School No Middle 06 08 2017   grade_6 94 13 40   0 17     11   43   105 113 0   11   0   88       12.0 218 94 13 40   0 17     11   43   105 113 0   11 0 88     12 218
618756 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108002524 4509 Klahowya Secondary   Regular School No Other 06 12 2017   grade_6 106 1 9   0 3     1   14   67 67 0   3   0   30       4.0 134 106 1 9   0 3     1   14   67 67 0   3 0 30     4 134
618790 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108002056 4249 Ridgetop Middle School   Regular School No Middle 06 08 2017   grade_6 133 4 53   1 16     9   39   125 130 0   11   0   79       8.0 255 133 4 53   1 16     9   39   125 130 0   11 0 79     8 255
618824 WA Spokane   school 5301110 32356   Central Valley School District 530111000189 3260 Bowdish Middle School   Regular School No Middle 06 08 2017   grade_6 133 1 9   2 1     0   8   82 72 0   3   5   93       5.0 154 133 1 9   2 1     0   8   82 72 0   3 5 93     5 154
618853 WA Spokane   school 5301110 32356   Central Valley School District 530111000193 3890 Evergreen Middle School   Regular School No Middle 06 08 2017   grade_6 201 2 17   0 4     1   10   125 110 0   7   3   66       14.0 235 201 2 17   0 4     1   10   125 110 0   7 3 66     14 235
618863 WA Spokane   school 5301110 32356   Central Valley School District 530111000195 3573 Greenacres Middle School   Regular School No Middle 06 08 2017   grade_6 217 1 22   1 6     1   12   128 132 0   3   3   69       26.0 260 217 1 22   1 6     1   12   128 132 0   3 3 69     26 260
618867 WA Spokane   school 5301110 32356   Central Valley School District 530111001826 4185 Horizon Middle School   Regular School No Middle 06 08 2017   grade_6 144 1 9   0 1     0   8   97 66 0   0   3   48       5.0 163 144 1 9   0 1     0   8   97 66 0   0 3 48     5 163
618898 WA Spokane   school 5301110 32356   Central Valley School District 530111000198 2776 North Pines Middle School   Regular School No Middle 06 08 2017   grade_6 116 3 25   1 1     3   11   77 83 0   14   10   119       6.0 160 116 3 25   1 1     3   11   77 83 0   14 10 119     6 160

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