Data source: Big Local News · About: Big Local

1,267 rows where grade = "grade_5", state = "WA" and year = 2019 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2019 · 1,267

grade

  • grade_5 · 1,267
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
2415113 WA Pierce   school   27901   Chief Leschi Schools   5549 Chief Leschi Schools             2019   grade_5 0 1 5   43 0     0   1   23 27 0   0   6   0       2.0 50 0 1 5   43 0     0   1   23 27 0   0 6 0     2 50
2419784 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2019   grade_5 1 0 1   20 0     0   1   14 9 0   0   1   23       0.0 23 1 0 1   20 0     0   1   14 9 0   0 1 23     0 23
2420789 WA King   school   17903   Muckleshoot Indian Tribe   1986 Muckleshoot Tribal School             2019   grade_5 1 0 2   41 0     0   2   18 28 0   0   0   31       2.0 46 1 0 2   41 0     0   2   18 28 0   0 0 31     2 46
2422076 WA Okanogan   school   24019   Omak School District   4278 Paschal Sherman             2019   grade_5 1 0 0   17 0     0   0   4 14 0   0   3   17       0.0 18 1 0 0   17 0     0   0   4 14 0   0 3 17     0 18
2423127 WA Clallam   school   5903   Quileute Tribal School District   5430 Quileute Tribal School             2019   grade_5 1 0 1   5 0     0   0   5 2 0   0   0   7       0.0 7 1 0 1   5 0     0   0   5 2 0   0 0 7     0 7
2427438 WA Thurston   school   34901   WA HE LUT Indian School Agency   5496 Wa He Lut Indian School             2019   grade_5 0 0 2   11 0     0   2   7 8 0   0   2   14       0.0 15 0 0 2   11 0     0   2   7 8 0   0 2 14     0 15
2414396 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000157 3251 Lucille Umbarger Elementary   Regular School No Elementary 01 08 2019   grade_5 28 0 45   0 2     0   7   43 39 0   20   1   54       2.0 82 28 0 45   0 2     0   7   43 39 0   20 1 54     2 82
2419269 WA King   school 5304230 17414   Lake Washington School District 530423000673 3856 Community School   Alternative School No Elementary 01 05 2019   grade_5 9 0 0   0 2     0   0   6 5 0   0   0   0       1.0 11 9 0 0   0 2     0   0   6 5 0   0 0 0     1 11
2419348 WA King   school 5304230 17414   Lake Washington School District 530423002519 1687 Explorer Community School   Alternative School No Elementary 01 05 2019   grade_5 6 0 0   0 5     0   0   5 6 0   0   0   0       0.0 11 6 0 0   0 5     0   0   5 6 0   0 0 0     0 11
2427866 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001641 3196 Ness Elementary   Regular School No Elementary 01 05 2019   grade_5 53 1 7   0 0     0   7   39 29 0   4   3   49       6.0 68 53 1 7   0 0     0   7   39 29 0   4 3 49     6 68
2427873 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001644 3129 Orchard Center Elementary   Regular School No Elementary 01 05 2019   grade_5 31 2 4   2 0     0   6   19 26 0   2   5   32       2.0 45 31 2 4   2 0     0   6   19 26 0   2 5 32     2 45
2427880 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001646 3194 Pasadena Park Elementary   Regular School No Elementary 01 05 2019   grade_5 60 0 7   0 2     1   7   44 33 0   3   0   41       4.0 77 60 0 7   0 2     1   7   44 33 0   3 0 41     4 77
2428241 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2019   grade_5 11 0 18   0 0     0   1   9 21 0   3   0   15       0.0 30 11 0 18   0 0     0   1   9 21 0   3 0 15     0 30
2417464 WA Pierce   school 5302880 27417   Fife School District 530288000466 2809 Endeavour Intermediate   Regular School No Elementary 02 05 2019   grade_5 51 14 31   1 15     9   19   64 76 0   17   2   92       4.0 140 51 14 31   1 15     9   19   64 76 0   17 2 92     4 140
2417473 WA Pierce   school 5302880 27417   Fife School District 530288002875 4557 Hedden Elementary School   Regular School No Elementary 02 05 2019   grade_5 70 8 33   0 13     3   18   79 66 0   19   3   57       1.0 145 70 8 33   0 13     3   18   79 66 0   19 3 57     1 145
2413464 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2019   grade_5 45 0 2   0 4     0   4   32 23 0   2   0   8       2.0 55 45 0 2   0 4     0   4   32 23 0   2 0 8     2 55
2414173 WA Whatcom   school 5300570 37503   Blaine School District 530057000130 2713 Blaine Elementary School   Regular School No Elementary 03 05 2019   grade_5 123 2 12   2 12     1   8   77 83 0   8   4   82       10.0 160 123 2 12   2 12     1   8   77 83 0   8 4 82     10 160
2414523 WA Chelan   school 5300950 4228   Cascade School District 530095001934 2827 Alpine Lakes Elementary   Regular School No Elementary 03 05 2019   grade_5 74 1 28   0 0     0   3   50 55 1   13   7   56       5.0 106 74 1 28   0 0     0   3   50 55 1   13 7 56     5 106
2414811 WA Spokane   school 5301110 32356   Central Valley School District 530111002681 4529 Liberty Lake Elementary   Regular School No Elementary 03 05 2019   grade_5 168 2 3   2 2     3   8   100 88 0   2   0   49       0.0 188 168 2 3   2 2     3   8   100 88 0   2 0 49     0 188
2414989 WA Lewis   school 5301170 21302   Chehalis School District 530117003655 5510 Orin C Smith Elementary School   Regular School No Elementary 03 05 2019   grade_5 156 0 46   2 1     1   18   114 110 0   11   12   110       1.0 224 156 0 46   2 1     1   18   114 110 0   11 12 110     1 224
2415127 WA Jefferson   school 5301290 16049   Chimacum School District 530129000232 2697 Chimacum Elementary School   Regular School No Elementary 03 05 2019   grade_5 49 0 3   1 5     0   9   39 28 0   3   2   46       2.0 67 49 0 3   1 5     0   9   39 28 0   3 2 46     2 67
2415545 WA Stevens   school 5301630 33115   Colville School District 530163001898 4180 Fort Colville Elementary   Regular School No Elementary 03 05 2019   grade_5 135 2 12   1 0     0   7   73 84 0   0   7   95       0.0 157 135 2 12   1 0     0   7   73 84 0   0 7 95     0 157
2415786 WA Spokane   school 5302070 32414   Deer Park School District 530207000306 2173 Arcadia Elementary   Regular School No Elementary 03 05 2019   grade_5 150 2 3   11 0     0   0   85 81 0   1   9   94       10.0 166 150 2 3   11 0     0   0   85 81 0   1 9 94     10 166
2417745 WA Snohomish   school 5303210 31332   Granite Falls School District 530321002482 4479 Monte Cristo Elementary   Regular School No Elementary 03 06 2019   grade_5 107 1 15   3 0     0   15   70 71 0   5   10   81       7.0 141 107 1 15   3 0     0   15   70 71 0   5 10 81     7 141
2418989 WA Benton   school 5304020 3052   Kiona-Benton City School District 530402003279 4217 Kiona-Benton Intermediate School   Regular School No Elementary 03 05 2019   grade_5 52 0 60   1 0     0   4   61 56 0   37   0   21       0.0 117 52 0 60   1 0     0   4   61 56 0   37 0 21     0 117
2420478 WA Grays Harbor   school 5305160 14066   Montesano School District 530516000781 3374 Simpson Avenue Elementary   Regular School No Elementary 03 06 2019   grade_5 84 0 18   0 0     0   7   63 46 0   1   3   42       3.0 109 84 0 18   0 0     0   7   63 46 0   1 3 42     3 109
2422050 WA Okanogan   school 5306220 24019   Omak School District 530622000938 3051 E Omak Elementary   Regular School No Elementary 03 05 2019   grade_5 58 0 40   23 1     0   11   68 65 0   16   2   96       0.0 133 58 0 40   23 1     0   11   68 65 0   16 2 96     0 133
2422389 WA Franklin   school 5306570 11001   Pasco School District 530657003542 5394 Marie Curie STEM Elementary   Regular School No Elementary 03 06 2019   grade_5 9 0 181   0 1     0   0   93 98 0   114   8   185       2.0 191 9 0 181   0 1     0   0   93 98 0   114 8 185     2 191
2422777 WA Benton   school 5306900 3116   Prosser School District 530690001011 3316 Prosser Heights Elementary   Regular School No Elementary 03 05 2019   grade_5 43 0 110   1 3     0   6   74 89 0   33   5   120       3.0 163 43 0 110   1 3     0   6   74 89 0   33 5 120     3 163
2423770 WA Thurston   school 5307470 34401   Rochester School District 530747001116 3801 Grand Mound Elementary   Regular School No Elementary 03 05 2019   grade_5 106 1 37   8 3     1   13   82 87 0   13   11   92       6.0 169 106 1 37   8 3     1   13   82 87 0   13 11 92     6 169
2424715 WA Yakima   school 5307770 39119   Selah School District 530777003546 5384 Selah Intermediate School   Regular School No Elementary 03 05 2019   grade_5 191 1 87   1 1     0   5   140 146 0   26   3   167       6.0 286 191 1 87   1 1     0   5   140 146 0   26 3 167     6 286
2425018 WA Snohomish   school 5308020 31201   Snohomish School District 530802001324 3005 Emerson Elementary   Regular School No Elementary 03 06 2019   grade_5 50 1 22   1 0     0   8   44 38 0   12   0   41       3.0 82 50 1 22   1 0     0   8   44 38 0   12 0 41     3 82
2425709 WA Spokane   school 5308250 32081   Spokane School District 530825002364 1567 Pratt Academy   Alternative School No Other 03 12 2019   grade_5 3 0 1   0 0     0   0   4 0 0   0   2   2       0.0 4 3 0 1   0 0     0   0   4 0 0   0 2 2     0 4
2426025 WA Skamania   school 5308520 30303   Stevenson-Carson School District 530852001434 2882 Carson Elementary   Regular School No Elementary 03 06 2019   grade_5 57 0 11   3 1     0   1   39 34 0   3   9   43       3.0 73 57 0 11   3 1     0   1   39 34 0   3 9 43     3 73
2426762 WA Thurston   school 5308820 34402   Tenino School District 530882002241 4238 Tenino Elementary School   Regular School No Elementary 03 05 2019   grade_5 69 0 5   0 0     0   10   49 35 0   2   3   42       3.0 84 69 0 5   0 0     0   10   49 35 0   2 3 42     3 84
2427588 WA Yakima   school 5309480 39207   Wapato School District 530948002611 4518 Adams Elementary   Regular School No Elementary 03 05 2019   grade_5 2 0 109   28 2     0   8   91 58 0   79   7   141       0.0 149 2 0 109   28 2     0   8   91 58 0   79 7 141     0 149
2427601 WA Yakima   school 5309480 39207   Wapato School District 530948001616 2757 Satus Elementary   Regular School No Elementary 03 05 2019   grade_5 4 0 99   39 1     0   11   82 72 0   82   7   144       0.0 154 4 0 99   39 1     0   11   82 72 0   82 7 144     0 154
2414952 WA Lewis   school 5301140 21401   Centralia School District 530114000210 2291 Oakview Elementary School   Regular School No Middle 04 06 2019   grade_5 88 4 42   0 0     0   8   69 73 0   7   5   114       4.0 142 88 4 42   0 0     0   8   69 73 0   7 5 114     4 142
2414956 WA Lewis   school 5301140 21401   Centralia School District 530114000211 2768 Washington Elementary School   Regular School No Middle 04 06 2019   grade_5 59 2 55   1 1     0   2   61 59 0   15   4   101       2.0 120 59 2 55   1 1     0   2   61 59 0   15 4 101     2 120
2415821 WA Pierce   school 5302130 27343   Dieringer School District 530213002812 4548 Dieringer Heights Elementary   Regular School No Elementary 04 05 2019   grade_5 129 5 12   3 10     3   13   99 76 0   3   0   25       11.0 175 129 5 12   3 10     3   13   99 76 0   3 0 25     11 175
2417828 WA Yakima   school 5303510 39203   Highland School District 530351000517 3073 Tieton Intermediate School   Regular School No Middle 04 06 2019   grade_5 21 0 67   0 1     0   1   47 43 0   26   4   78       4.0 90 21 0 67   0 1     0   1   47 43 0   26 4 78     4 90
2418083 WA Grays Harbor   school 5303660 14028   Hoquiam School District 530366000562 2972 Central Elementary School   Regular School No Elementary 04 05 2019   grade_5 64 0 20   8 0     0   15   48 59 0   3   2   84       4.0 107 64 0 20   8 0     0   15   48 59 0   3 2 84     4 107
2423162 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 2019   grade_5 32 0 31   6 0     0   6   38 37 0   6   1   48       2.0 75 32 0 31   6 0     0   6   38 37 0   6 1 48     2 75
2423182 WA Grant   school 5307080 13144   Quincy School District 530708002714 4536 Monument Elementary   Regular School No Middle 04 06 2019   grade_5 19 0 207   0 0     0   3   111 118 0   90   1   205       13.0 229 19 0 207   0 0     0   3   111 118 0   90 1 205     13 229
2423825 WA Grant   school 5307620 13160   Royal School District 530762003526 5388 Royal Intermediate School   Regular School No Middle 04 06 2019   grade_5 23 0 134   0 0     0   1   70 88 0   71   10   132       13.0 158 23 0 134   0 0     0   1   70 88 0   71 10 132     13 158
2426001 WA Pierce   school 5308460 27001   Steilacoom Hist. School District 530846001432 3827 Saltars Point Elementary   Regular School No Elementary 04 05 2019   grade_5 129 17 43   3 21     2   46   147 114 0   9   5   74       18.0 261 129 17 43   3 21     2   46   147 114 0   9 5 74     18 261
2426632 WA Pierce   school 5308700 27010   Tacoma School District 530870001508 3116 Wainwright   Regular School No Middle 04 08 2019   grade_5 34 20 17   0 5     1   19   44 52 0   5   6   45       2.0 96 34 20 17   0 5     1   19   44 52 0   5 6 45     2 96
2428066 WA Klickitat   school 5309810 20405   White Salmon Valley School District 530981003500 5368 Wallace & Priscilla Stevenson Intermediate School   Regular School No Middle 04 06 2019   grade_5 70 1 35   2 0     0   5   62 51 0   17   6   60       2.0 113 70 1 35   2 0     0   5   62 51 0   17 6 60     2 113
2428460 WA Yakima   school 5310170 39205   Zillah School District 531017001896 4221 Zillah Intermediate School   Regular School No Middle 04 06 2019   grade_5 34 0 50   1 1     0   4   48 42 0   5   4   60       1.0 90 34 0 50   1 1     0   4   48 42 0   5 4 60     1 90
2413439 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002734 4542 Sonoji Sakai Intermediate   Regular School No Middle 05 06 2019   grade_5 224 1 19   2 12     0   19   142 135 0   2   0   25       44.0 277 224 1 19   2 12     0   19   142 135 0   2 0 25     44 277
2413449 WA Clark   school 5300380 6119   Battle Ground School District 530038000048 2671 Amboy Middle School   Regular School No Middle 05 08 2019   grade_5 150 0 4   0 0     1   3   84 74 0   1   1   61       4.0 158 150 0 4   0 0     1   3   84 74 0   1 1 61     4 158
2413477 WA Clark   school 5300380 6119   Battle Ground School District 530038003262 5133 Chief Umtuch Middle   Regular School No Middle 05 08 2019   grade_5 119 0 20   1 1     0   6   75 72 0   6   2   56       2.0 147 119 0 20   1 1     0   6   75 72 0   6 2 56     2 147
2413482 WA Clark   school 5300380 6119   Battle Ground School District 530038003176 5089 Daybreak Middle   Regular School No Middle 05 08 2019   grade_5 71 3 11   0 2     1   6   49 45 0   12   2   48       4.0 94 71 3 11   0 2     1   6   49 45 0   12 2 48     4 94
2413520 WA Clark   school 5300380 6119   Battle Ground School District 530038000052 3545 Laurin Middle School   Regular School No Middle 05 08 2019   grade_5 112 3 29   0 8     0   4   94 62 0   19   4   68       5.0 156 112 3 29   0 8     0   4   94 62 0   19 4 68     5 156
2413538 WA Clark   school 5300380 6119   Battle Ground School District 530038000054 3997 Pleasant Valley Middle   Regular School No Middle 05 08 2019   grade_5 86 2 17   2 6     3   13   64 65 0   7   3   57       6.0 129 86 2 17   2 6     3   13   64 65 0   7 3 57     6 129
2413561 WA Clark   school 5300380 6119   Battle Ground School District 530038003214 5131 Tukes Valley Middle School   Regular School No Middle 05 08 2019   grade_5 104 0 9   0 0     0   4   55 62 0   5   1   35       3.0 117 104 0 9   0 0     0   4   55 62 0   5 1 35     3 117
2414561 WA Chelan   school 5300960 4222   CASHMERE SCHOOL DISTRICT 530096000169 2315 CASHMERE MIDDLE SCHOOL   Regular School No Middle 05 08 2019   grade_5 74 1 55   0 1     0   2   72 61 0   21   3   70       6.0 133 74 1 55   0 1     0   2   72 61 0   21 3 70     6 133
2415433 WA Pierce   school 5301410 27400   Clover Park School District 530141003396 5297 Transition Day Students   Regular School No High 05 12 2019   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
2415962 WA Douglas   school 5302310 9206   Eastmont School District 530231002948 4590 Clovis Point Intermediate School   Regular School No Middle 05 07 2019   grade_5 101 1 147   0 2     0   4   143 112 0   44   8   178       8.0 255 101 1 147   0 2     0   4   143 112 0   44 8 178     8 255
2416549 WA Grant   school 5302610 13165   Ephrata School District 530261002559 2695 Parkway School   Regular School No Middle 05 06 2019   grade_5 122 1 70   0 2     0   3   107 91 0   15   5   135       11.0 198 122 1 70   0 2     0   3   107 91 0   15 5 135     11 198
2417161 WA King   school 5302820 17210   Federal Way School District 530282000437 3898 Illahee Middle School   Regular School No Middle 05 08 2019   grade_5 13 5 11   0 6     1   4   19 21 0   3   1   18       0.0 40 13 5 11   0 6     1   4   19 21 0   3 1 18     0 40
2417634 WA Klickitat   school 5303090 20404   Goldendale School District 530309000491 3393 Goldendale Middle School   Regular School No Middle 05 08 2019   grade_5 44 0 9   5 0     0   8   33 33 0   1   1   48       3.0 66 44 0 9   5 0     0   8   33 33 0   1 1 48     3 66
2417714 WA Yakima   school 5303180 39204   Granger School District 530318000504 2531 Granger Middle School   Regular School No Middle 05 08 2019   grade_5 1 0 128   4 0     0   0   67 66 0   59   7   130       2.0 133 1 0 128   4 0     0   0   67 66 0   59 7 130     2 133
2418965 WA Stevens   school 5303990 33212   Kettle Falls School District 530399001904 3198 Kettle Falls Middle School   Regular School No Middle 05 08 2019   grade_5 44 0 2   1 0     0   3   19 31 0   0   0   31       0.0 50 44 0 2   1 0     0   3   19 31 0   0 0 31     0 50
2419606 WA Whitman   school 5304290 38264   Lamont School District 530429000687 3137 Lamont Middle School   Regular School No Middle 05 08 2019   grade_5 8 0 0   0 0     0   0   5 3 0   0   0   5       0.0 8 8 0 0   0 0     0   0   5 3 0   0 0 5     0 8
2420945 WA Yakima   school 5305460 39003   Naches Valley School District 530546000824 2898 Naches Valley Middle School   Regular School No Middle 05 08 2019   grade_5 71 0 26   0 0     0   3   52 48 0   7   0   52       10.0 100 71 0 26   0 0     0   3   52 48 0   7 0 52     10 100
2421006 WA Pend Oreille   school 5305610 26056   Newport School District 530561001911 3968 Sadie Halstead Middle School   Regular School No Middle 05 08 2019   grade_5 64 0 4   0 0     0   5   44 29 0   1   6   52       6.0 73 64 0 4   0 0     0   5   44 29 0   1 6 52     6 73
2421752 WA Island   school 5305940 15201   Oak Harbor School District 530594000904 3274 Oak Harbor Intermediate School   Regular School No Middle 05 06 2019   grade_5 261 22 88   0 23     5   66   247 218 0   15   5   196       17.0 465 261 22 88   0 23     5   66   247 218 0   15 5 196     17 465
2421797 WA Pacific   school 5306060 25101   Ocean Beach School District 530606000911 2517 Hilltop Elementary School   Regular School No Middle 05 08 2019   grade_5 51 0 23   1 0     0   4   31 48 0   3   10   53       1.0 79 51 0 23   1 0     0   4   31 48 0   3 10 53     1 79
2423212 WA King   school 5300335 17908   Rainier Prep Charter School District 530033503533 5380 Rainier Prep   Regular School Yes Middle 05 08 2019   grade_5 7 46 19   0 4     2   10   42 46 0   45   3   65       0.0 88 7 46 19   0 4     2   10   42 46 0   45 3 65     0 88
2423641 WA Clark   school 5307350 6122   Ridgefield School District 530735003660 5518 Sunset Ridge Intermediate School   Regular School No Middle 05 06 2019   grade_5 232 3 36   1 3     1   11   145 142 0   1   5   76       16.0 287 232 3 36   1 3     1   11   145 142 0   1 5 76     16 287
2426927 WA Klickitat   school 5309060 20400   Trout Lake School District 530906001539 2676 Trout Lake School   Regular School No High 05 12 2019   grade_5 17 0 1   0 1     0   0   10 9 0   1   0   0       0.0 19 17 0 1   0 1     0   0   10 9 0   1 0 0     0 19
2427082 WA Pierce   school 5309180 27083   University Place School District 530918002383 4325 Drum Intermediate   Regular School No Middle 05 07 2019   grade_5 76 23 30   0 16     3   38   97 89 0   11   3   83       4.0 186 76 23 30   0 16     3   38   97 89 0   11 3 83     4 186
2427093 WA Pierce   school 5309180 27083   University Place School District 530918001550 3296 Narrows View Intermediate   Regular School No Middle 05 07 2019   grade_5 93 17 37   0 20     5   57   114 115 0   10   4   92       7.0 229 93 17 37   0 20     5   57   114 115 0   10 4 92     7 229
2427902 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969002685 1755 West Valley City School   Alternative School No Middle 05 08 2019   grade_5 29 0 2   1 0     0   1   11 22 0   1   2   16       2.0 33 29 0 2   1 0     0   1   11 22 0   1 2 16     2 33
2427957 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972002545 4506 West Valley Middle School   Regular School No Middle 05 06 2019   grade_5 241 6 162   1 10     0   18   236 202 0   33   2   213       8.0 438 241 6 162   1 10     0   18   236 202 0   33 2 213     8 438
2428198 WA Cowlitz   school 5310050 8404   Woodland School District 531005003509 5409 Woodland Middle School   Regular School No Middle 05 08 2019   grade_5 124 1 43   2 0     0   2   81 91 0   15   9   74       6.0 172 124 1 43   2 0     0   2   81 91 0   15 9 74     6 172
2413153 WA Snohomish   school 5300240 31016   Arlington School District 530024003008 5010 Haller Middle School   Regular School No Middle 06 08 2019   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
2413998 WA Pierce   school 5300480 27403   Bethel School District 530048001819 4186 Cedarcrest Middle School   Regular School No Middle 06 08 2019   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
2414799 WA Spokane   school 5301110 32356   Central Valley School District 530111001826 4185 Horizon Middle School   Regular School No Middle 06 08 2019   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
2414825 WA Spokane   school 5301110 32356   Central Valley School District 530111000198 2776 North Pines Middle School   Regular School No Middle 06 08 2019   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
2416502 WA King   school 5300001 17216   Enumclaw School District 530000102795 4550 Thunder Mountain Middle School   Regular School No Middle 06 08 2019   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
2418468 WA Benton   school 5303930 3017   Kennewick School District 530393003586 5439 Chinook Middle School   Regular School No Middle 06 08 2019   grade_5 1 0 1   0 0     0   0   1 1 0   0   0   0       0.0 2 1 0 1   0 0     0   0   1 1 0   0 0 0     0 2
2418480 WA Benton   school 5303930 3017   Kennewick School District 530393000598 4028 Desert Hills Middle School   Regular School No Middle 06 08 2019   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
2418513 WA Benton   school 5303930 3017   Kennewick School District 530393000603 3267 Highlands Middle School   Regular School No Middle 06 08 2019   grade_5 16 1 11   0 1     0   3   18 14 0   0   1   1       0.0 32 16 1 11   0 1     0   3   18 14 0   0 1 1     0 32
2418563 WA Benton   school 5303930 3017   Kennewick School District 530393000607 3472 Park Middle School   Regular School No Middle 06 08 2019   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
2418977 WA Benton   school 5304020 3052   Kiona-Benton City School District 530402000640 3961 Kiona-Benton City Middle School   Regular School No Middle 06 08 2019   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
2419648 WA Cowlitz   school 5304470 8122   Longview School District 530447000699 3475 Cascade Middle School   Regular School No Middle 06 08 2019   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
2420040 WA Snohomish   school 5304860 31025   Marysville School District 530486000736 3355 Marysville Middle School   Regular School No Middle 06 08 2019   grade_5 0 0 0   0 1     0   0   1 0 0   0   0   1       0.0 1 0 0 0   0 1     0   0   1 0 0   0 0 1     0 1
2420252 WA Spokane   school 5304950 32326   Medical Lake School District 530495000756 3965 Medical Lake Middle School   Regular School No Middle 06 08 2019   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
2422035 WA Thurston   school 5306180 34111   Olympia School District 530618001737 4473 Thurgood Marshall Middle School   Regular School No Middle 06 08 2019   grade_5 1 0 1   0 1     0   0   2 1 0   0   0   2       0.0 3 1 0 1   0 1     0   0   2 1 0   0 0 2     0 3
2422042 WA Thurston   school 5306180 34111   Olympia School District 530618000935 3711 Washington Middle School   Regular School No Middle 06 08 2019   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
2422115 WA Lewis   school 5306240 21300   Onalaska School District 530624003062 4335 Onalaska Middle School   Regular School No Middle 06 08 2019   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
2422158 WA San Juan   school 5306300 28137   Orcas Island School District 530630002815 4558 Orcas Island Middle School   Regular School No Middle 06 08 2019   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
2422837 WA Pierce   school 5306960 27003   Puyallup School District 530696001178 4443 Doris Stahl Junior High   Regular School No Middle 06 10 2019   grade_5 1 0 0   0 0     1   0   1 1 0   1   0   1       1.0 2 1 0 0   0 0     1   0   1 1 0   1 0 1     1 2
2424817 WA Mason   school 5307900 23309   Shelton School District 530790002990 4586 Olympic Middle School   Regular School No Middle 06 07 2019   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
2426770 WA Thurston   school 5308820 34402   Tenino School District 530882001523 3795 Tenino Middle School   Regular School No Middle 06 08 2019   grade_5 2 0 0   0 0     0   0   2 0 0   0   0   1       0.0 2 2 0 0   0 0     0   0   2 0 0   0 0 1     0 2
2427536 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001601 3510 Garrison Middle School   Regular School No Middle 06 08 2019   grade_5 1 0 0   0 0     0   1   2 0 0   0   0   1       0.0 2 1 0 0   0 0     0   1   2 0 0   0 0 1     0 2
2416535 WA Grant   school 5302610 13165   Ephrata School District 530261000387 3373 Ephrata Middle School   Regular School No Middle 07 08 2019   grade_5 0 0 4   0 0     0   0   4 0 0   3   0   3       0.0 4 0 0 4   0 0     0   0   4 0 0   3 0 3     0 4
2414916 WA Spokane   school 5301110 32356   Central Valley School District 530111000204 3415 University High School   Regular School No High 09 12 2019   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]);