Data source: Big Local News · About: Big Local

1,263 rows where grade = "grade_5", state = "WA" and year = 2017 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2017 · 1,263

grade

  • grade_5 · 1,263
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
618026 WA Pierce   school   27403   Bethel School District   5471 Bethel Elementary Learning Academy             2017   grade_5 2 0 0   0 0     0   1   2 1 0   0   0   0       0.0 3 2 0 0   0 0     0   1   2 1 0   0 0 0     0 3
623902 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2017   grade_5 0 0 0   22 0     0   0   10 12 0   0   0   19       0.0 22 0 0 0   22 0     0   0   10 12 0   0 0 19     0 22
624975 WA King   school   17903   Muckleshoot Indian Tribe   1986 Muckleshoot Tribal School             2017   grade_5 0 1 0   32 0     0   0   18 15 0   0   0   30       0.0 33 0 1 0   32 0     0   0   18 15 0   0 0 30     0 33
625632 WA Thurston   school   34003   North Thurston Public Schools   8407 Wa He Lut Indian School(Closed)             2017   grade_5 0 0 1   10 0     0   0   5 6 0   0   0   4       0.0 11 0 0 1   10 0     0   0   5 6 0   0 0 4     0 11
626332 WA Okanogan   school   24019   Omak School District   4278 Paschal Sherman             2017   grade_5 2 0 0   15 0     0   0   10 7 0   0   0   17       0.0 17 2 0 0   15 0     0   0   10 7 0   0 0 17     0 17
627135 WA Pierce   school   27003   Puyallup School District   4110 Chief Leschi Schools(Closed)             2017   grade_5 0 0 3   48 0     0   5   28 28 0   0   1   13       1.0 56 0 0 3   48 0     0   5   28 28 0   0 1 13     1 56
627426 WA Clallam   school   5903   Quileute Tribal School District   5430 Quileute Tribal School             2017   grade_5 0 0 1   7 0     0   0   4 4 0   0   0   7       0.0 8 0 0 1   7 0     0   0   4 4 0   0 0 7     0 8
617480 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002523 1699 Odyssey Multiage Program   Regular School No Elementary 01 08 2017   grade_5 13 0 0   0 0     0   0   8 5 0   0   0   1       2.0 13 13 0 0   0 0     0   0   8 5 0   0 0 1     2 13
618466 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000157 3251 Lucille Umbarger Elementary   Regular School No Elementary 01 08 2017   grade_5 35 0 36   0 2     0   3   46 30 0   23   5   54       0.0 76 35 0 36   0 2     0   3   46 30 0   23 5 54     0 76
618861 WA Spokane   school 5301110 32356   Central Valley School District 530111000194 2157 Greenacres Elementary   Regular School No Elementary 01 05 2017   grade_5 123 0 7   1 0     0   8   81 58 0   2   1   49       9.0 139 123 0 7   1 0     0   8   81 58 0   2 1 49     9 139
618884 WA Spokane   school 5301110 32356   Central Valley School District 530111002681 4529 Liberty Lake Elementary   Regular School No Elementary 01 05 2017   grade_5 118 2 8   0 4     2   1   69 66 0   1   1   26       7.0 135 118 2 8   0 4     2   1   69 66 0   1 1 26     7 135
623386 WA King   school 5304230 17414   Lake Washington School District 530423000673 3856 Community School   Alternative School No Elementary 01 05 2017   grade_5 7 0 0   0 3     0   1   5 6 0   1   0   0       1.0 11 7 0 0   0 3     0   1   5 6 0   1 0 0     1 11
623459 WA King   school 5304230 17414   Lake Washington School District 530423002519 1687 Explorer Community School   Alternative School No Elementary 01 05 2017   grade_5 6 0 2   0 7     0   1   8 8 0   0   0   0       0.0 16 6 0 2   0 7     0   1   8 8 0   0 0 0     0 16
625950 WA Island   school 5305940 15201   Oak Harbor School District 530594002264 4328 Hillcrest Elementary   Regular School No Elementary 01 05 2017   grade_5 73 4 10   0 6     2   17   54 58 0   3   8   40       4.0 112 73 4 10   0 6     2   17   54 58 0   3 8 40     4 112
632560 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2017   grade_5 11 1 13   0 0     0   3   19 9 0   3   0   12       2.0 28 11 1 13   0 0     0   3   19 9 0   3 0 12     2 28
621553 WA Pierce   school 5302880 27417   Fife School District 530288000466 2809 Endeavour Intermediate   Regular School No Elementary 02 05 2017   grade_5 67 5 33   1 9     5   26   75 71 0   13   4   80       0.0 146 67 5 33   1 9     5   26   75 71 0   13 4 80     0 146
621563 WA Pierce   school 5302880 27417   Fife School District 530288002875 4557 Hedden Elementary School   Regular School No Elementary 02 05 2017   grade_5 76 9 26   0 9     3   20   67 76 0   7   2   50       1.0 143 76 9 26   0 9     3   20   67 76 0   7 2 50     1 143
617514 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2017   grade_5 46 0 3   0 3     0   4   28 28 0   1   0   7       1.0 56 46 0 3   0 3     0   4   28 28 0   1 0 7     1 56
618234 WA Whatcom   school 5300570 37503   Blaine School District 530057000130 2713 Blaine Elementary School   Regular School No Elementary 03 05 2017   grade_5 124 3 22   1 4     0   9   93 70 0   1   6   79       10.0 163 124 3 22   1 4     0   9   93 70 0   1 6 79     10 163
618591 WA Chelan   school 5300950 4228   Cascade School District 530095001934 2827 Alpine Lakes Elementary   Regular School No Elementary 03 05 2017   grade_5 54 1 31   1 0     0   2   47 42 0   18   2   47       3.0 89 54 1 31   1 0     0   2   47 42 0   18 2 47     3 89
619167 WA Jefferson   school 5301290 16049   Chimacum School District 530129000232 2697 Chimacum Elementary School   Regular School No Elementary 03 05 2017   grade_5 55 0 7   0 0     0   6   40 28 0   0   4   41       1.0 68 55 0 7   0 0     0   6   40 28 0   0 4 41     1 68
619594 WA Stevens   school 5301630 33115   Colville School District 530163001898 4180 Fort Colville Elementary   Regular School No Elementary 03 05 2017   grade_5 104 1 6   0 2     0   1   54 60 0   2   5   63       1.0 114 104 1 6   0 2     0   1   54 60 0   2 5 63     1 114
619828 WA Spokane   school 5302070 32414   Deer Park School District 530207000306 2173 Arcadia Elementary   Regular School No Elementary 03 05 2017   grade_5 124 0 10   1 0     0   0   75 60 0   1   3   84       10.0 135 124 0 10   1 0     0   0   75 60 0   1 3 84     10 135
621847 WA Snohomish   school 5303210 31332   Granite Falls School District 530321002482 4479 Monte Cristo Elementary   Regular School No Elementary 03 06 2017   grade_5 107 3 11   1 0     0   7   78 51 0   3   8   65       4.0 129 107 3 11   1 0     0   7   78 51 0   3 8 65     4 129
623104 WA Benton   school 5304020 3052   Kiona-Benton City School District 530402003279 4217 Kiona-Benton Intermediate School   Regular School No Elementary 03 05 2017   grade_5 67 0 43   1 0     0   1   50 62 0   35   4   82       0.0 112 67 0 43   1 0     0   1   50 62 0   35 4 82     0 112
624643 WA Grays Harbor   school 5305160 14066   Montesano School District 530516000781 3374 Simpson Avenue Elementary   Regular School No Elementary 03 06 2017   grade_5 64 0 12   1 1     0   5   41 42 0   5   1   31       1.0 83 64 0 12   1 1     0   5   41 42 0   5 1 31     1 83
626306 WA Okanogan   school 5306220 24019   Omak School District 530622000938 3051 E Omak Elementary   Regular School No Elementary 03 05 2017   grade_5 55 1 28   28 0     0   16   56 72 0   4   1   82       2.0 128 55 1 28   28 0     0   16   56 72 0   4 1 82     2 128
626659 WA Franklin   school 5306570 11001   Pasco School District 530657003542 5394 Marie Curie STEM Elementary   Regular School No Elementary 03 06 2017   grade_5 13 3 185   0 1     0   3   93 112 0   131   8   198       2.0 205 13 3 185   0 1     0   3   93 112 0   131 8 198     2 205
627066 WA Benton   school 5306900 3116   Prosser School District 530690001011 3316 Prosser Heights Elementary   Regular School No Elementary 03 05 2017   grade_5 46 0 99   0 4     0   6   68 89 0   35   11   115       3.0 157 46 0 99   0 4     0   6   68 89 0   35 11 115     3 157
628067 WA Thurston   school 5307470 34401   Rochester School District 530747001116 3801 Grand Mound Elementary   Regular School No Elementary 03 05 2017   grade_5 116 0 31   9 1     0   17   97 77 0   5   9   94       8.0 174 116 0 31   9 1     0   17   97 77 0   5 9 94     8 174
628994 WA Yakima   school 5307770 39119   Selah School District 530777003546 5384 Selah Intermediate School   Regular School No Elementary 03 05 2017   grade_5 167 2 76   1 1     0   5   121 131 0   21   4   141       4.0 252 167 2 76   1 1     0   5   121 131 0   21 4 141     4 252
629316 WA Snohomish   school 5308020 31201   Snohomish School District 530802001324 3005 Emerson Elementary   Regular School No Elementary 03 06 2017   grade_5 55 0 20   0 1     0   6   43 39 0   6   1   34       2.0 82 55 0 20   0 1     0   6   43 39 0   6 1 34     2 82
630030 WA Spokane   school 5308250 32081   Spokane School District 530825002364 1567 Pratt Academy   Alternative School No Other 03 12 2017   grade_5 1 0 0   1 0     0   0   2 0 0   0   1   2       2.0 2 1 0 0   1 0     0   0   2 0 0   0 1 2     2 2
630344 WA Skamania   school 5308520 30303   Stevenson-Carson School District 530852001434 2882 Carson Elementary   Regular School No Elementary 03 06 2017   grade_5 57 0 10   1 0     0   8   42 34 0   1   4   41       2.0 76 57 0 10   1 0     0   8   42 34 0   1 4 41     2 76
631055 WA Thurston   school 5308820 34402   Tenino School District 530882002241 4238 Tenino Elementary School   Regular School No Elementary 03 05 2017   grade_5 93 0 4   0 1     0   3   56 45 0   0   5   54       3.0 101 93 0 4   0 1     0   3   56 45 0   0 5 54     3 101
619010 WA Lewis   school 5301140 21401   Centralia School District 530114000210 2291 Oakview Elementary School   Regular School No Elementary 04 06 2017   grade_5 92 0 54   1 0     1   4   78 74 0   19   1   121       1.0 152 92 0 54   1 0     1   4   78 74 0   19 1 121     1 152
619041 WA Lewis   school 5301170 21302   Chehalis School District 530117000214 3346 Olympic Elementary (Closed after 2017-2018 school year)   Regular School No Elementary 04 05 2017   grade_5 139 1 41   0 0     0   11   106 86 0   14   25   114       1.0 192 139 1 41   0 0     0   11   106 86 0   14 25 114     1 192
619861 WA Pierce   school 5302130 27343   Dieringer School District 530213002812 4548 Dieringer Heights Elementary   Regular School No Elementary 04 05 2017   grade_5 138 5 12   2 12     0   7   89 87 0   4   3   18       8.0 176 138 5 12   2 12     0   7   89 87 0   4 3 18     8 176
620212 WA Snohomish   school 5302400 31015   Edmonds School District 530240002821 1830 Contracted Schools   Special Education School No Other 04 12 2017   grade_5 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
621934 WA Yakima   school 5303510 39203   Highland School District 530351000517 3073 Tieton Intermediate School   Regular School No Elementary 04 06 2017   grade_5 24 0 64   0 0     0   6   51 43 0   19   1   74       0.0 94 24 0 64   0 0     0   6   51 43 0   19 1 74     0 94
622206 WA Grays Harbor   school 5303660 14028   Hoquiam School District 530366000562 2972 Central Elementary School   Regular School No Elementary 04 05 2017   grade_5 72 0 27   6 1     0   8   58 56 0   10   2   62       1.0 114 72 0 27   6 1     0   8   58 56 0   10 2 62     1 114
626898 WA Mason   school 5306750 23402   Pioneer School District 530675000992 2865 Pioneer Middle School   Regular School No Elementary 04 08 2017   grade_5 52 2 11   1 0     0   3   40 29 0   1   2   58       1.0 69 52 2 11   1 0     0   3   40 29 0   1 2 58     1 69
626993 WA Jefferson   school 5306840 16050   Port Townsend School District 530684001305 4475 Blue Heron Middle School   Regular School No Elementary 04 08 2017   grade_5 52 1 7   0 1     1   3   36 29 0   2   0   30       2.0 65 52 1 7   0 1     1   3   36 29 0   2 0 30     2 65
627461 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_5 35 0 23   5 0     0   8   35 36 0   5   2   53       1.0 71 35 0 23   5 0     0   8   35 36 0   5 2 53     1 71
627476 WA Grant   school 5307080 13144   Quincy School District 530708002714 4536 Monument Elementary   Regular School No Elementary 04 06 2017   grade_5 20 0 227   0 0     0   0   132 115 0   125   7   227       10.0 247 20 0 227   0 0     0   0   132 115 0   125 7 227     10 247
628122 WA Grant   school 5307620 13160   Royal School District 530762003526 5388 Royal Intermediate School   Regular School No Elementary 04 06 2017   grade_5 19 0 117   0 0     0   0   65 71 0   71   16   114       10.0 136 19 0 117   0 0     0   0   65 71 0   71 16 114     10 136
629936 WA Spokane   school 5308250 32081   Spokane School District 530825002484 2401 Libby Center   Special Education School No Elementary 04 08 2017   grade_5 55 0 6   1 7     0   6   47 28 0   0   1   19       3.0 75 55 0 6   1 7     0   6   47 28 0   0 1 19     3 75
630322 WA Pierce   school 5308460 27001   Steilacoom Hist. School District 530846001432 3827 Saltars Point Elementary   Regular School No Elementary 04 05 2017   grade_5 118 16 29   0 16     3   29   108 103 0   4   2   51       11.0 211 118 16 29   0 16     3   29   108 103 0   4 2 51     11 211
630933 WA Pierce   school 5308700 27010   Tacoma School District 530870001508 3116 Wainwright   Regular School No Elementary 04 06 2017   grade_5 39 17 12   0 7     1   4   40 40 0   1   3   42       2.0 80 39 17 12   0 7     1   4   40 40 0   1 3 42     2 80
632382 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_5 59 0 30   1 0     1   3   55 39 0   15   3   47       2.0 94 59 0 30   1 0     1   3   55 39 0   15 3 47     2 94
632792 WA Yakima   school 5310170 39205   Zillah School District 531017001896 4221 Zillah Intermediate School   Regular School No Elementary 04 06 2017   grade_5 41 1 58   5 0     0   5   65 45 0   12   1   70       1.0 110 41 1 58   5 0     0   5   65 45 0   12 1 70     1 110
617492 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002734 4542 Sonoji Sakai Intermediate   Regular School No Middle 05 06 2017   grade_5 207 3 18   1 7     0   22   135 123 0   0   0   20       14.0 258 207 3 18   1 7     0   22   135 123 0   0 0 20     14 258
617499 WA Clark   school 5300380 6119   Battle Ground School District 530038000048 2671 Amboy Middle School   Regular School No Middle 05 08 2017   grade_5 123 0 2   1 0     0   4   68 62 0   0   2   56       4.0 130 123 0 2   1 0     0   4   68 62 0   0 2 56     4 130
617528 WA Clark   school 5300380 6119   Battle Ground School District 530038003262 5133 Chief Umtuch Middle   Regular School No Middle 05 08 2017   grade_5 127 0 14   0 0     0   10   80 71 0   10   2   57       3.0 151 127 0 14   0 0     0   10   80 71 0   10 2 57     3 151
617533 WA Clark   school 5300380 6119   Battle Ground School District 530038003176 5089 Daybreak Middle   Regular School No Middle 05 08 2017   grade_5 87 1 12   0 2     1   5   56 52 0   9   0   50       8.0 108 87 1 12   0 2     1   5   56 52 0   9 0 50     8 108
617567 WA Clark   school 5300380 6119   Battle Ground School District 530038000052 3545 Laurin Middle School   Regular School No Middle 05 08 2017   grade_5 127 1 16   0 7     1   5   82 75 0   21   2   65       2.0 157 127 1 16   0 7     1   5   82 75 0   21 2 65     2 157
617586 WA Clark   school 5300380 6119   Battle Ground School District 530038000054 3997 Pleasant Valley Middle   Regular School No Middle 05 08 2017   grade_5 79 2 19   0 7     3   10   57 63 0   10   1   49       4.0 120 79 2 19   0 7     3   10   57 63 0   10 1 49     4 120
617613 WA Clark   school 5300380 6119   Battle Ground School District 530038003214 5131 Tukes Valley Middle School   Regular School No Middle 05 08 2017   grade_5 96 0 16   0 1     0   5   64 54 0   2   0   38       5.0 118 96 0 16   0 1     0   5   64 54 0   2 0 38     5 118
618402 WA Douglas   school 5300720 9075   Bridgeport School District 530072001271 4213 Bridgeport Middle School   Regular School No Middle 05 08 2017   grade_5 3 0 66   0 0     0   0   34 35 0   37   7   69       1.0 69 3 0 66   0 0     0   0   34 35 0   37 7 69     1 69
618631 WA Chelan   school 5300960 4222   CASHMERE SCHOOL DISTRICT 530096000169 2315 CASHMERE MIDDLE SCHOOL   Regular School No Middle 05 08 2017   grade_5 63 0 54   0 1     0   4   63 59 0   16   2   68       5.0 122 63 0 54   0 1     0   4   63 59 0   16 2 68     5 122
620019 WA Douglas   school 5302310 9206   Eastmont School District 530231002948 4590 Clovis Point Intermediate School   Regular School No Middle 05 07 2017   grade_5 98 0 112   1 0     1   7   110 109 0   46   5   139       8.0 219 98 0 112   1 0     1   7   110 109 0   46 5 139     8 219
620632 WA Grant   school 5302610 13165   Ephrata School District 530261002559 2695 Parkway School   Regular School No Middle 05 06 2017   grade_5 130 0 60   1 0     0   4   111 84 0   24   3   118       9.0 195 130 0 60   1 0     0   4   111 84 0   24 3 118     9 195
621252 WA King   school 5302820 17210   Federal Way School District 530282000437 3898 Illahee Middle School   Regular School No Middle 05 08 2017   grade_5 21 4 5   0 11     0   8   26 23 0   0   0   11       3.0 49 21 4 5   0 11     0   8   26 23 0   0 0 11     3 49
621729 WA Klickitat   school 5303090 20404   Goldendale School District 530309000491 3393 Goldendale Middle School   Regular School No Middle 05 08 2017   grade_5 57 2 10   1 0     0   2   36 36 0   3   3   57       5.0 72 57 2 10   1 0     0   2   36 36 0   3 3 57     5 72
621816 WA Yakima   school 5303180 39204   Granger School District 530318000504 2531 Granger Middle School   Regular School No Middle 05 08 2017   grade_5 4 0 104   4 0     0   0   64 48 0   45   2   101       1.0 112 4 0 104   4 0     0   0   64 48 0   45 2 101     1 112
623081 WA Stevens   school 5303990 33212   Kettle Falls School District 530399001904 3198 Kettle Falls Middle School   Regular School No Middle 05 08 2017   grade_5 45 1 1   2 1     0   4   25 29 0   0   4   41       0.0 54 45 1 1   2 1     0   4   25 29 0   0 4 41     0 54
623718 WA Whitman   school 5304290 38264   Lamont School District 530429000687 3137 Lamont Middle School   Regular School No Middle 05 08 2017   grade_5 8 0 0   0 0     0   1   4 5 0   0   0   7       0.0 9 8 0 0   0 0     0   1   4 5 0   0 0 7     0 9
625135 WA Yakima   school 5305460 39003   Naches Valley School District 530546000824 2898 Naches Valley Middle School   Regular School No Middle 05 08 2017   grade_5 66 0 25   0 0     0   4   48 47 0   7   3   47       4.0 95 66 0 25   0 0     0   4   48 47 0   7 3 47     4 95
625205 WA Pend Oreille   school 5305610 26056   Newport School District 530561001911 3968 Sadie Halstead Middle School   Regular School No Middle 05 08 2017   grade_5 75 0 4   0 1     0   1   33 48 0   0   3   51       1.0 81 75 0 4   0 1     0   1   33 48 0   0 3 51     1 81
626040 WA Pacific   school 5306060 25101   Ocean Beach School District 530606000911 2517 Hilltop Elementary School   Regular School No Middle 05 08 2017   grade_5 55 0 16   1 0     0   5   43 34 0   6   10   57       1.0 77 55 0 16   1 0     0   5   43 34 0   6 10 57     1 77
626182 WA Thurston   school 5306180 34111   Olympia School District 530618000925 3133 Jefferson Middle School   Regular School No Middle 05 08 2017   grade_5 1 0 1   0 0     0   0   2 0 0   0   0   1       0.0 2 1 0 1   0 0     0   0   2 0 0   0 0 1     0 2
627506 WA King   school 5300335 17908   Rainier Prep Charter School District 530033503533 5380 Rainier Prep   Regular School Yes Middle 05 08 2017   grade_5 4 34 27   0 4     0   8   37 40 0   21   2   62       2.0 77 4 34 27   0 4     0   8   37 40 0   21 2 62     2 77
631221 WA Klickitat   school 5309060 20400   Trout Lake School District 530906001539 2676 Trout Lake School   Regular School No Other 05 12 2017   grade_5 16 0 3   0 0     0   1   11 9 0   0   0   0       2.0 20 16 0 3   0 0     0   1   11 9 0   0 0 0     2 20
631379 WA Pierce   school 5309180 27083   University Place School District 530918002383 4325 Drum Intermediate   Regular School No Middle 05 07 2017   grade_5 95 19 24   0 13     1   38   93 97 0   7   1   75       5.0 190 95 19 24   0 13     1   38   93 97 0   7 1 75     5 190
631392 WA Pierce   school 5309180 27083   University Place School District 530918001550 3296 Narrows View Intermediate   Regular School No Middle 05 07 2017   grade_5 101 23 28   2 18     1   28   122 79 0   9   1   97       11.0 201 101 23 28   2 18     1   28   122 79 0   9 1 97     11 201
632220 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969002685 1755 West Valley City School   Alternative School No Middle 05 08 2017   grade_5 36 1 3   0 0     0   3   13 30 0   0   0   19       2.0 43 36 1 3   0 0     0   3   13 30 0   0 0 19     2 43
632281 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972002545 4506 West Valley Middle School   Regular School No Middle 05 06 2017   grade_5 269 2 124   2 13     2   18   219 211 0   27   4   190       9.0 430 269 2 124   2 13     2   18   219 211 0   27 4 190     9 430
632517 WA Cowlitz   school 5310050 8404   Woodland School District 531005003509 5409 Woodland Middle School   Regular School No Middle 05 08 2017   grade_5 110 3 35   0 1     0   6   77 78 0   13   4   86       1.0 155 110 3 35   0 1     0   6   77 78 0   13 4 86     1 155
618320 WA Kitsap   school 5300660 18100   Bremerton School District 530066001144 4441 Mountain View Middle School   Regular School No Middle 06 08 2017   grade_5 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
618520 WA Clark   school 5300810 6117   Camas School District 530081003066 5054 Liberty Middle School   Regular School No Middle 06 08 2017   grade_5 1 0 0   0 0     0   0   1 0 0   1   0   0       1.0 1 1 0 0   0 0     0   0   1 0 0   1 0 0     1 1
618733 WA Kitsap   school 5301080 18401   Central Kitsap School District 530108000183 3791 Fairview Middle School   Regular School No Middle 06 08 2017   grade_5 0 0 1   0 0     0   0   1 0 0   0   0   0       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 0     0 1
619971 WA Yakima   school 5305370 39090   East Valley School District (Yakima) 530537000806 4055 East Valley Central Middle School   Regular School No Middle 06 08 2017   grade_5 0 0 1   0 0     0   0   1 0 0   0   1   1       0.0 1 0 0 1   0 0     0   0   1 0 0   0 1 1     0 1
620113 WA Pierce   school 5302370 27404   Eatonville School District 530237001899 4230 Eatonville Middle School   Regular School No Middle 06 08 2017   grade_5 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
620547 WA King   school 5300001 17216   Enumclaw School District 530000102054 4210 Enumclaw Middle School   Regular School No Middle 06 08 2017   grade_5 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
620667 WA Clark   school 5300005 6801   ESD 112 acting as a school district 530000502917 3294 Cowlitz County Youth Services Center   Regular School No Other 06 12 2017   grade_5 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
621663 WA Pierce   school 5302940 27402   Franklin Pierce School District 530294000481 3401 Perry G Keithley Middle School   Regular School No Middle 06 08 2017   grade_5 1 0 0   0 0     0   1   1 1 0   0   0   0       0.0 2 1 0 0   0 0     0   1   1 1 0   0 0 0     0 2
623091 WA Benton   school 5304020 3052   Kiona-Benton City School District 530402000640 3961 Kiona-Benton City Middle School   Regular School No Middle 06 08 2017   grade_5 4 0 2   0 0     0   1   4 3 0   2   0   7       0.0 7 4 0 2   0 0     0   1   4 3 0   2 0 7     0 7
623538 WA King   school 5304230 17414   Lake Washington School District 530423000672 2308 Kirkland Middle School   Regular School No Middle 06 08 2017   grade_5 0 1 0   0 0     0   0   1 0 0   0   0   0       0.0 1 0 1 0   0 0     0   0   1 0 0   0 0 0     0 1
623632 WA King   school 5304230 17414   Lake Washington School District 530423000680 3232 Redmond Middle School   Regular School No Middle 06 08 2017   grade_5 0 0 0   0 1     0   0   1 0 0   1   0   0       0.0 1 0 0 0   0 1     0   0   1 0 0   1 0 0     0 1
624666 WA Grant   school 5305220 13161   Moses Lake School District 530522000785 3022 Chief Moses Middle School   Regular School No Middle 06 08 2017   grade_5 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
624679 WA Grant   school 5305220 13161   Moses Lake School District 530522002625 2673 Frontier Middle School   Regular School No Middle 06 08 2017   grade_5 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
625452 WA Mason   school 5305790 23403   North Mason School District 530579000860 3174 Hawkins Middle School   Regular School No Middle 06 08 2017   grade_5 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
625971 WA Island   school 5305940 15201   Oak Harbor School District 530594000901 3939 North Whidbey Middle School   Regular School No Middle 06 08 2017   grade_5 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
627674 WA King   school 5307230 17403   Renton School District 530723001079 3035 McKnight Middle School   Regular School No Middle 06 08 2017   grade_5 0 0 0   0 1     0   0   0 1 0   0   0   0       0.0 1 0 0 0   0 1     0   0   0 1 0   0 0 0     0 1
629103 WA Mason   school 5307900 23309   Shelton School District 530790002990 4586 Olympic Middle School   Regular School No Middle 06 07 2017   grade_5 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
631796 WA Walla Walla   school 5309390 36401   Waitsburg School District 530939002492 2174 Preston Hall Middle School   Regular School No Middle 06 08 2017   grade_5 0 0 0   0 0     0   1   1 0 0   0   0   1       0.0 1 0 0 0   0 0     0   1   1 0 0   0 0 1     0 1
631863 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001605 2780 Pioneer Middle School   Regular School No Middle 06 08 2017   grade_5 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
632033 WA Douglas   school 5309600 9209   Waterville School District 530960001628 2162 Waterville High School   Regular School No Other 06 12 2017   grade_5 1 0 0   0 0     0   0   1 0 0   0   1   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 1 1     0 1
629619 WA Kitsap   school 5308160 18402   South Kitsap School District 530816001351 3046 Marcus Whitman Middle School   Regular School No Other 07 09 2017   grade_5 0 0 1   0 0     0   0   1 0 0   0   0   0       0.0 1 0 0 1   0 0     0   0   1 0 0   0 0 0     0 1
631344 WA Thurston   school 5309100 34033   Tumwater School District 530910001545 3612 Tumwater Middle School   Regular School No Middle 07 08 2017   grade_5 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

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