Data source: Big Local News · About: Big Local

1,253 rows where grade = "grade_5", state = "WA" and year = 2018 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2018 · 1,253

grade

  • grade_5 · 1,253
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
2464242 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2018   grade_5 0 0 1   14 0     0   2   13 4 0   0   0   17       0.0 17 0 0 1   14 0     0   2   13 4 0   0 0 17     0 17
2465254 WA King   school   17903   Muckleshoot Indian Tribe   1986 Muckleshoot Tribal School             2018   grade_5 0 0 0   34 0     0   1   17 18 0   0   0   26       0.0 35 0 0 0   34 0     0   1   17 18 0   0 0 26     0 35
2466540 WA Okanogan   school   24019   Omak School District   4278 Paschal Sherman             2018   grade_5 1 0 0   11 0     0   0   5 7 0   0   4   12       0.0 12 1 0 0   11 0     0   0   5 7 0   0 4 12     0 12
2467329 WA Pierce   school   27003   Puyallup School District   4110 Chief Leschi Schools(Closed)             2018   grade_5 0 0 10   36 0     0   9   31 24 0   0   1   0       1.0 55 0 0 10   36 0     0   9   31 24 0   0 1 0     1 55
2467622 WA Clallam   school   5903   Quileute Tribal School District   5430 Quileute Tribal School             2018   grade_5 1 1 1   4 0     0   0   5 2 0   0   1   7       0.0 7 1 1 1   4 0     0   0   5 2 0   0 1 7     0 7
2471937 WA Thurston   school   34901   WA HE LUT Indian School Agency   5496 Wa He Lut Indian School             2018   grade_5 0 0 0   13 0     0   0   4 9 0   0   0   10       0.0 13 0 0 0   13 0     0   0   4 9 0   0 0 10     0 13
2472105 WA Yakima   school   39207   Wapato School District   5544 Camas Elementary             2018   grade_5 4 0 65   22 5     0   3   52 47 0   56   14   99       0.0 99 4 0 65   22 5     0   3   52 47 0   56 14 99     0 99
2457978 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002523 1699 Odyssey Multiage Program   Regular School No Elementary 01 08 2018   grade_5 13 0 1   0 0     0   0   6 8 0   0   0   1       0.0 14 13 0 1   0 0     0   0   6 8 0   0 0 1     0 14
2458948 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000157 3251 Lucille Umbarger Elementary   Regular School No Elementary 01 08 2018   grade_5 27 0 35   0 0     0   2   38 27 0   20   2   42       4.0 65 27 0 35   0 0     0   2   38 27 0   20 2 42     4 65
2463730 WA King   school 5304230 17414   Lake Washington School District 530423000673 3856 Community School   Alternative School No Elementary 01 05 2018   grade_5 12 0 1   0 1     0   1   5 10 0   1   0   1       2.0 15 12 0 1   0 1     0   1   5 10 0   1 0 1     2 15
2463801 WA King   school 5304230 17414   Lake Washington School District 530423002519 1687 Explorer Community School   Alternative School No Elementary 01 05 2018   grade_5 7 0 1   0 7     0   0   7 8 0   1   0   0       4.0 15 7 0 1   0 7     0   0   7 8 0   1 0 0     4 15
2472386 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001641 3196 Ness Elementary   Regular School No Elementary 01 05 2018   grade_5 48 1 2   0 0     0   1   32 20 0   1   2   36       0.0 52 48 1 2   0 0     0   1   32 20 0   1 2 36     0 52
2472392 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001644 3129 Orchard Center Elementary   Regular School No Elementary 01 05 2018   grade_5 35 1 3   0 0     1   10   32 18 0   1   0   36       1.0 50 35 1 3   0 0     1   10   32 18 0   1 0 36     1 50
2472398 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001646 3194 Pasadena Park Elementary   Regular School No Elementary 01 05 2018   grade_5 70 1 5   0 1     0   6   49 34 0   4   1   31       1.0 83 70 1 5   0 1     0   6   49 34 0   4 1 31     1 83
2472762 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2018   grade_5 10 1 16   1 0     0   1   13 16 0   8   0   16       1.0 29 10 1 16   1 0     0   1   13 16 0   8 0 16     1 29
2461963 WA Pierce   school 5302880 27417   Fife School District 530288000466 2809 Endeavour Intermediate   Regular School No Elementary 02 05 2018   grade_5 52 8 32   1 19     9   19   73 67 0   18   4   80       4.0 140 52 8 32   1 19     9   19   73 67 0   18 4 80     4 140
2461972 WA Pierce   school 5302880 27417   Fife School District 530288002875 4557 Hedden Elementary School   Regular School No Elementary 02 05 2018   grade_5 83 7 24   1 8     2   20   77 68 0   8   5   62       7.0 145 83 7 24   1 8     2   20   77 68 0   8 5 62     7 145
2458016 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2018   grade_5 46 0 1   0 3     0   3   23 30 0   4   0   8       0.0 53 46 0 1   0 3     0   3   23 30 0   4 0 8     0 53
2458722 WA Whatcom   school 5300570 37503   Blaine School District 530057000130 2713 Blaine Elementary School   Regular School No Elementary 03 05 2018   grade_5 124 4 22   2 8     1   15   80 96 0   5   1   93       15.0 176 124 4 22   2 8     1   15   80 96 0   5 1 93     15 176
2459358 WA Spokane   school 5301110 32356   Central Valley School District 530111002681 4529 Liberty Lake Elementary   Regular School No Elementary 03 05 2018   grade_5 178 2 12   2 3     1   3   105 96 0   4   0   56       11.0 201 178 2 12   2 3     1   3   105 96 0   4 0 56     11 201
2459645 WA Jefferson   school 5301290 16049   Chimacum School District 530129000232 2697 Chimacum Elementary School   Regular School No Elementary 03 05 2018   grade_5 47 1 1   1 0     0   8   32 26 0   0   0   32       0.0 58 47 1 1   1 0     0   8   32 26 0   0 0 32     0 58
2460047 WA Stevens   school 5301630 33115   Colville School District 530163001898 4180 Fort Colville Elementary   Regular School No Elementary 03 05 2018   grade_5 63 0 5   3 1     0   4   39 37 0   0   3   41       1.0 76 63 0 5   3 1     0   4   39 37 0   0 3 41     1 76
2460285 WA Spokane   school 5302070 32414   Deer Park School District 530207000306 2173 Arcadia Elementary   Regular School No Elementary 03 05 2018   grade_5 144 3 13   4 0     0   2   99 67 0   1   2   61       1.0 166 144 3 13   4 0     0   2   99 67 0   1 2 61     1 166
2462244 WA Snohomish   school 5303210 31332   Granite Falls School District 530321002482 4479 Monte Cristo Elementary   Regular School No Elementary 03 06 2018   grade_5 129 2 16   4 1     0   6   63 95 0   6   8   75       5.0 158 129 2 16   4 1     0   6   63 95 0   6 8 75     5 158
2463457 WA Benton   school 5304020 3052   Kiona-Benton City School District 530402003279 4217 Kiona-Benton Intermediate School   Regular School No Elementary 03 05 2018   grade_5 59 0 47   1 1     0   3   51 60 0   18   2   53       2.0 111 59 0 47   1 1     0   3   51 60 0   18 2 53     2 111
2464946 WA Grays Harbor   school 5305160 14066   Montesano School District 530516000781 3374 Simpson Avenue Elementary   Regular School No Elementary 03 06 2018   grade_5 95 0 8   1 1     0   12   53 65 0   1   1   49       7.0 118 95 0 8   1 1     0   12   53 65 0   1 1 49     7 118
2466514 WA Okanogan   school 5306220 24019   Omak School District 530622000938 3051 E Omak Elementary   Regular School No Elementary 03 05 2018   grade_5 40 0 33   29 1     0   13   62 54 0   14   3   81       2.0 116 40 0 33   29 1     0   13   62 54 0   14 3 81     2 116
2466870 WA Franklin   school 5306570 11001   Pasco School District 530657003542 5394 Marie Curie STEM Elementary   Regular School No Elementary 03 06 2018   grade_5 6 3 219   0 0     0   5   131 102 0   160   4   226       3.0 233 6 3 219   0 0     0   5   131 102 0   160 4 226     3 233
2467264 WA Benton   school 5306900 3116   Prosser School District 530690001011 3316 Prosser Heights Elementary   Regular School No Elementary 03 05 2018   grade_5 54 0 109   1 1     0   2   76 91 0   37   5   121       1.0 167 54 0 109   1 1     0   2   76 91 0   37 5 121     1 167
2468276 WA Thurston   school 5307470 34401   Rochester School District 530747001116 3801 Grand Mound Elementary   Regular School No Elementary 03 05 2018   grade_5 133 1 40   4 0     0   15   93 100 0   22   4   120       11.0 193 133 1 40   4 0     0   15   93 100 0   22 4 120     11 193
2469228 WA Yakima   school 5307770 39119   Selah School District 530777003546 5384 Selah Intermediate School   Regular School No Elementary 03 05 2018   grade_5 162 1 104   2 2     0   9   151 129 0   32   1   153       4.0 280 162 1 104   2 2     0   9   151 129 0   32 1 153     4 280
2469531 WA Snohomish   school 5308020 31201   Snohomish School District 530802001324 3005 Emerson Elementary   Regular School No Elementary 03 06 2018   grade_5 52 0 19   0 0     0   5   42 34 0   5   2   43       7.0 76 52 0 19   0 0     0   5   42 34 0   5 2 43     7 76
2470228 WA Spokane   school 5308250 32081   Spokane School District 530825002364 1567 Pratt Academy   Alternative School No Other 03 12 2018   grade_5 0 0 1   0 0     0   0   0 1 0   0   1   1       0.0 1 0 0 1   0 0     0   0   0 1 0   0 1 1     0 1
2470541 WA Skamania   school 5308520 30303   Stevenson-Carson School District 530852001434 2882 Carson Elementary   Regular School No Elementary 03 06 2018   grade_5 54 0 8   1 0     0   6   32 37 0   0   2   28       2.0 69 54 0 8   1 0     0   6   32 37 0   0 2 28     2 69
2471269 WA Thurston   school 5308820 34402   Tenino School District 530882002241 4238 Tenino Elementary School   Regular School No Elementary 03 05 2018   grade_5 93 1 11   0 0     0   7   62 50 0   3   3   66       1.0 112 93 1 11   0 0     0   7   62 50 0   3 3 66     1 112
2459488 WA Lewis   school 5301140 21401   Centralia School District 530114000210 2291 Oakview Elementary School   Regular School No Middle 04 06 2018   grade_5 85 0 52   0 1     0   8   73 73 0   11   7   118       2.0 146 85 0 52   0 1     0   8   73 73 0   11 7 118     2 146
2459492 WA Lewis   school 5301140 21401   Centralia School District 530114000211 2768 Washington Elementary School   Regular School No Middle 04 06 2018   grade_5 57 0 60   0 0     0   7   55 69 0   16   1   107       2.0 124 57 0 60   0 0     0   7   55 69 0   16 1 107     2 124
2459520 WA Lewis   school 5301170 21302   Chehalis School District 530117000214 3346 Olympic Elementary (Closed after 2017-2018 school year)   Regular School No Elementary 04 05 2018   grade_5 144 0 42   0 3     1   11   110 91 0   15   9   111       3.0 201 144 0 42   0 3     1   11   110 91 0   15 9 111     3 201
2460317 WA Pierce   school 5302130 27343   Dieringer School District 530213002812 4548 Dieringer Heights Elementary   Regular School No Elementary 04 05 2018   grade_5 109 0 16   0 11     0   25   89 72 0   4   1   27       12.0 161 109 0 16   0 11     0   25   89 72 0   4 1 27     12 161
2460651 WA Snohomish   school 5302400 31015   Edmonds School District 530240002821 1830 Contracted Schools   Special Education School No Other 04 12 2018   grade_5 1 0 1   0 0     0   0   1 1 0   0   0   2       0.0 2 1 0 1   0 0     0   0   1 1 0   0 0 2     0 2
2462327 WA Yakima   school 5303510 39203   Highland School District 530351000517 3073 Tieton Intermediate School   Regular School No Middle 04 06 2018   grade_5 28 0 62   0 0     0   0   53 37 0   25   1   77       1.0 90 28 0 62   0 0     0   0   53 37 0   25 1 77     1 90
2462580 WA Grays Harbor   school 5303660 14028   Hoquiam School District 530366000562 2972 Central Elementary School   Regular School No Elementary 04 05 2018   grade_5 85 0 25   5 0     0   13   71 57 0   7   7   89       2.0 128 85 0 25   5 0     0   13   71 57 0   7 7 89     2 128
2467199 WA Jefferson   school 5306840 16050   Port Townsend School District 530684001305 4475 Blue Heron Middle School   Regular School No Middle 04 08 2018   grade_5 52 0 5   2 0     1   5   34 31 0   0   3   44       0.0 65 52 0 5   2 0     1   5   34 31 0   0 3 44     0 65
2467660 WA Clallam   school 5307020 5402   Quillayute Valley School District 530702003483 5363 Forks Intermediate School (Closed after 2019-2020 school year)   Regular School No Middle 04 06 2018   grade_5 37 0 26   8 1     0   9   39 42 0   8   2   56       3.0 81 37 0 26   8 1     0   9   39 42 0   8 2 56     3 81
2467677 WA Grant   school 5307080 13144   Quincy School District 530708002714 4536 Monument Elementary   Regular School No Middle 04 06 2018   grade_5 17 0 175   0 0     0   1   97 96 0   93   8   181       8.0 193 17 0 175   0 0     0   1   97 96 0   93 8 181     8 193
2468330 WA Grant   school 5307620 13160   Royal School District 530762003526 5388 Royal Intermediate School   Regular School No Middle 04 06 2018   grade_5 29 0 109   0 0     0   0   72 66 0   56   9   110       7.0 138 29 0 109   0 0     0   0   72 66 0   56 9 110     7 138
2470520 WA Pierce   school 5308460 27001   Steilacoom Hist. School District 530846001432 3827 Saltars Point Elementary   Regular School No Elementary 04 05 2018   grade_5 108 19 36   0 18     1   44   115 111 0   4   5   46       15.0 226 108 19 36   0 18     1   44   115 111 0   4 5 46     15 226
2471139 WA Pierce   school 5308700 27010   Tacoma School District 530870001508 3116 Wainwright   Regular School No Middle 04 07 2018   grade_5 54 24 21   1 8     1   10   65 54 0   6   6   74       3.0 119 54 24 21   1 8     1   10   65 54 0   6 6 74     3 119
2472584 WA Klickitat   school 5309810 20405   White Salmon Valley School District 530981003500 5368 Wallace & Priscilla Stevenson Intermediate School   Regular School No Middle 04 06 2018   grade_5 68 0 29   2 1     0   6   61 45 0   18   1   54       2.0 106 68 0 29   2 1     0   6   61 45 0   18 1 54     2 106
2472982 WA Yakima   school 5310170 39205   Zillah School District 531017001896 4221 Zillah Intermediate School   Regular School No Middle 04 06 2018   grade_5 34 0 54   3 1     0   4   50 46 0   10   1   55       1.0 96 34 0 54   3 1     0   4   50 46 0   10 1 55     1 96
2457991 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002734 4542 Sonoji Sakai Intermediate   Regular School No Middle 05 06 2018   grade_5 194 1 23   3 7     1   29   134 124 0   3   0   16       30.0 258 194 1 23   3 7     1   29   134 124 0   3 0 16     30 258
2458001 WA Clark   school 5300380 6119   Battle Ground School District 530038000048 2671 Amboy Middle School   Regular School No Middle 05 08 2018   grade_5 137 0 4   0 0     0   3   77 67 0   0   3   54       0.0 144 137 0 4   0 0     0   3   77 67 0   0 3 54     0 144
2458029 WA Clark   school 5300380 6119   Battle Ground School District 530038003262 5133 Chief Umtuch Middle   Regular School No Middle 05 08 2018   grade_5 119 0 16   0 1     0   4   73 67 0   5   2   57       4.0 140 119 0 16   0 1     0   4   73 67 0   5 2 57     4 140
2458034 WA Clark   school 5300380 6119   Battle Ground School District 530038003176 5089 Daybreak Middle   Regular School No Middle 05 08 2018   grade_5 90 1 16   0 0     0   9   67 49 0   11   3   55       7.0 116 90 1 16   0 0     0   9   67 49 0   11 3 55     7 116
2458073 WA Clark   school 5300380 6119   Battle Ground School District 530038000052 3545 Laurin Middle School   Regular School No Middle 05 08 2018   grade_5 126 3 19   0 13     0   7   87 81 0   16   3   57       6.0 168 126 3 19   0 13     0   7   87 81 0   16 3 57     6 168
2458092 WA Clark   school 5300380 6119   Battle Ground School District 530038000054 3997 Pleasant Valley Middle   Regular School No Middle 05 08 2018   grade_5 93 5 16   1 11     0   7   64 69 0   10   5   55       5.0 133 93 5 16   1 11     0   7   64 69 0   10 5 55     5 133
2458116 WA Clark   school 5300380 6119   Battle Ground School District 530038003214 5131 Tukes Valley Middle School   Regular School No Middle 05 08 2018   grade_5 101 0 5   0 1     0   6   66 47 0   3   2   35       3.0 113 101 0 5   0 1     0   6   66 47 0   3 2 35     3 113
2458886 WA Douglas   school 5300720 9075   Bridgeport School District 530072001271 4213 Bridgeport Middle School   Regular School No Middle 05 08 2018   grade_5 7 0 61   0 1     0   1   39 31 0   34   7   65       1.0 70 7 0 61   0 1     0   1   39 31 0   34 7 65     1 70
2459103 WA Chelan   school 5300960 4222   CASHMERE SCHOOL DISTRICT 530096000169 2315 CASHMERE MIDDLE SCHOOL   Regular School No Middle 05 08 2018   grade_5 69 0 55   0 1     0   5   63 67 0   16   5   63       6.0 130 69 0 55   0 1     0   5   63 67 0   16 5 63     6 130
2460465 WA Douglas   school 5302310 9206   Eastmont School District 530231002948 4590 Clovis Point Intermediate School   Regular School No Middle 05 07 2018   grade_5 92 0 107   2 0     0   3   112 92 0   43   2   133       6.0 204 92 0 107   2 0     0   3   112 92 0   43 2 133     6 204
2461056 WA Grant   school 5302610 13165   Ephrata School District 530261002559 2695 Parkway School   Regular School No Middle 05 06 2018   grade_5 140 1 56   0 2     0   1   96 104 0   20   6   123       13.0 200 140 1 56   0 2     0   1   96 104 0   20 6 123     13 200
2461669 WA King   school 5302820 17210   Federal Way School District 530282000437 3898 Illahee Middle School   Regular School No Middle 05 08 2018   grade_5 21 4 5   0 6     3   11   27 23 0   2   0   17       1.0 50 21 4 5   0 6     3   11   27 23 0   2 0 17     1 50
2462135 WA Klickitat   school 5303090 20404   Goldendale School District 530309000491 3393 Goldendale Middle School   Regular School No Middle 05 08 2018   grade_5 53 0 6   5 1     0   4   33 36 0   1   1   45       6.0 69 53 0 6   5 1     0   4   33 36 0   1 1 45     6 69
2462212 WA Yakima   school 5303180 39204   Granger School District 530318000504 2531 Granger Middle School   Regular School No Middle 05 08 2018   grade_5 2 0 90   3 0     0   2   58 39 0   45   1   94       2.0 97 2 0 90   3 0     0   2   58 39 0   45 1 94     2 97
2463434 WA Stevens   school 5303990 33212   Kettle Falls School District 530399001904 3198 Kettle Falls Middle School   Regular School No Middle 05 08 2018   grade_5 42 1 4   0 1     0   3   25 26 0   0   2   36       2.0 51 42 1 4   0 1     0   3   25 26 0   0 2 36     2 51
2464057 WA Whitman   school 5304290 38264   Lamont School District 530429000687 3137 Lamont Middle School   Regular School No Middle 05 08 2018   grade_5 10 0 1   0 0     0   0   2 9 0   0   0   8       0.0 11 10 0 1   0 0     0   0   2 9 0   0 0 8     0 11
2465410 WA Yakima   school 5305460 39003   Naches Valley School District 530546000824 2898 Naches Valley Middle School   Regular School No Middle 05 08 2018   grade_5 69 1 19   0 0     0   4   50 43 0   5   0   52       7.0 93 69 1 19   0 0     0   4   50 43 0   5 0 52     7 93
2465480 WA Pend Oreille   school 5305610 26056   Newport School District 530561001911 3968 Sadie Halstead Middle School   Regular School No Middle 05 08 2018   grade_5 75 0 7   1 0     0   2   51 34 0   0   7   59       3.0 85 75 0 7   1 0     0   2   51 34 0   0 7 59     3 85
2466211 WA Island   school 5305940 15201   Oak Harbor School District 530594000904 3274 Oak Harbor Intermediate School   Regular School No Middle 05 06 2018   grade_5 269 16 83   1 23     6   67   237 228 0   18   15   212       23.0 465 269 16 83   1 23     6   67   237 228 0   18 15 212     23 465
2466256 WA Pacific   school 5306060 25101   Ocean Beach School District 530606000911 2517 Hilltop Elementary School   Regular School No Middle 05 08 2018   grade_5 69 0 19   0 1     0   4   51 42 0   8   10   62       1.0 93 69 0 19   0 1     0   4   51 42 0   8 10 62     1 93
2466396 WA Thurston   school 5306180 34111   Olympia School District 530618000925 3133 Jefferson Middle School   Regular School No Middle 05 08 2018   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
2467710 WA King   school 5300335 17908   Rainier Prep Charter School District 530033503533 5380 Rainier Prep   Regular School Yes Middle 05 08 2018   grade_5 5 42 27   0 7     1   7   47 42 0   31   0   66       0.0 89 5 42 27   0 7     1   7   47 42 0   31 0 66     0 89
2471436 WA Klickitat   school 5309060 20400   Trout Lake School District 530906001539 2676 Trout Lake School   Regular School No High 05 12 2018   grade_5 20 0 3   1 1     0   1   15 11 0   0   0   0       1.0 26 20 0 3   1 1     0   1   15 11 0   0 0 0     1 26
2471583 WA Pierce   school 5309180 27083   University Place School District 530918002383 4325 Drum Intermediate   Regular School No Middle 05 07 2018   grade_5 91 16 37   1 23     4   35   118 89 0   13   5   86       12.0 207 91 16 37   1 23     4   35   118 89 0   13 5 86     12 207
2471595 WA Pierce   school 5309180 27083   University Place School District 530918001550 3296 Narrows View Intermediate   Regular School No Middle 05 07 2018   grade_5 103 18 36   2 15     2   43   106 113 0   10   8   102       9.0 219 103 18 36   2 15     2   43   106 113 0   10 8 102     9 219
2472420 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969002685 1755 West Valley City School   Alternative School No Middle 05 08 2018   grade_5 29 0 4   0 0     0   1   20 14 0   0   1   16       0.0 34 29 0 4   0 0     0   1   20 14 0   0 1 16     0 34
2472477 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972002545 4506 West Valley Middle School   Regular School No Middle 05 06 2018   grade_5 236 6 138   5 14     0   14   209 204 0   31   4   217       9.0 413 236 6 138   5 14     0   14   209 204 0   31 4 217     9 413
2472720 WA Cowlitz   school 5310050 8404   Woodland School District 531005003509 5409 Woodland Middle School   Regular School No Middle 05 08 2018   grade_5 142 0 44   2 2     0   3   100 93 0   17   15   102       1.0 193 142 0 44   2 2     0   3   100 93 0   17 15 102     1 193
2458403 WA Whatcom   school 5300420 37501   Bellingham School District 530042000104 2066 Fairhaven Middle School   Regular School No Middle 06 08 2018   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
2462234 WA Snohomish   school 5303210 31332   Granite Falls School District 530321001770 4113 Granite Falls Middle School   Regular School No Middle 06 08 2018   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
2463445 WA Benton   school 5304020 3052   Kiona-Benton City School District 530402000640 3961 Kiona-Benton City Middle School   Regular School No Middle 06 08 2018   grade_5 2 0 0   0 0     0   1   3 0 0   0   0   2       0.0 3 2 0 0   0 0     0   1   3 0 0   0 0 2     0 3
2464439 WA Snohomish   school 5304860 31025   Marysville School District 530486002425 4357 Cedarcrest School   Regular School No Middle 06 08 2018   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
2464714 WA Spokane   school 5304950 32326   Medical Lake School District 530495000756 3965 Medical Lake Middle School   Regular School No Middle 06 08 2018   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
2465298 WA Snohomish   school 5305430 31006   Mukilteo School District 530543001910 4231 Explorer Middle School   Regular School No Middle 06 08 2018   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
2466499 WA Thurston   school 5306180 34111   Olympia School District 530618001737 4473 Thurgood Marshall Middle School   Regular School No Middle 06 08 2018   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
2466507 WA Thurston   school 5306180 34111   Olympia School District 530618000935 3711 Washington Middle School   Regular School No Middle 06 08 2018   grade_5 2 0 0   0 0     0   0   1 1 0   0   0   0       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 0     0 2
2466531 WA Okanogan   school 5306220 24019   Omak School District 530622001912 4237 Omak Middle School   Regular School No Middle 06 08 2018   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
2466561 WA Okanogan   school 5306220 24019   Omak School District 530622003307 5196 Washington Virtual Academy Omak Middle School   Regular School No Middle 06 08 2018   grade_5 17 1 2   0 4     1   0   16 9 0   0   0   12       0.0 25 17 1 2   0 4     1   0   16 9 0   0 0 12     0 25
2467339 WA Pierce   school 5306960 27003   Puyallup School District 530696001178 4443 Doris Stahl Junior High   Regular School No Middle 06 10 2018   grade_5 0 0 0   0 1     0   0   1 0 0   0   0   0       1.0 1 0 0 0   0 1     0   0   1 0 0   0 0 0     1 1
2471552 WA Thurston   school 5309100 34033   Tumwater School District 530910001545 3612 Tumwater Middle School   Regular School No Middle 06 08 2018   grade_5 6 0 0   0 1     0   1   6 2 0   0   0   0       0.0 8 6 0 0   0 1     0   1   6 2 0   0 0 0     0 8
2472061 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001605 2780 Pioneer Middle School   Regular School No Middle 06 08 2018   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
2472642 WA Lewis   school 5309930 21232   Winlock School District 530993002392 4369 Winlock Middle School   Regular School No Middle 06 08 2018   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
2460364 WA Spokane   school 5302280 32361   East Valley School District (Spokane) 530228003494 5346 East Valley Middle School   Regular School No Middle 07 08 2018   grade_5 0 0 0   0 0     0   2   2 0 0   0   1   2       0.0 2 0 0 0   0 0     0   2   2 0 0   0 1 2     0 2
2466692 WA Okanogan   school 5306420 24410   Oroville School District 530642000951 2706 Oroville Middle-High School   Regular School No High 07 12 2018   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
2466528 WA Okanogan   school 5306220 24019   Omak School District 530622000940 2031 Omak High School   Regular School No High 09 12 2018   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
2467697 WA Grant   school 5307080 13144   Quincy School District 530708001055 3088 Quincy High School   Regular School No High 09 12 2018   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
2469869 WA Kitsap   school 5308160 18402   South Kitsap School District 530816001357 2272 South Kitsap High School   Regular School No High 09 12 2018   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
2457571 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000005 3216 Central Park Elementary   Regular School No Elementary KG 06 2018   grade_5 14 0 6   0 1     0   2   12 11 0   1   1   15       2.0 23 14 0 6   0 1     0   2   12 11 0   1 1 15     2 23
2457598 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No Elementary KG 06 2018   grade_5 37 1 19   0 0     0   3   30 30 0   9   3   42       1.0 60 37 1 19   0 0     0   3   30 30 0   9 3 42     1 60
2457649 WA Lincoln   school 5300090 22017   Almira School District 530009000179 2860 Almira Elementary School   Regular School No Elementary KG 08 2018   grade_5 4 0 1   0 0     0   0   4 1 0   0   0   2       0.0 5 4 0 1   0 0     0   0   4 1 0   0 0 2     0 5

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