Data source: Big Local News · About: Big Local

1,266 rows where grade = "grade_5", state = "WA" and year = 2020 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2020 · 1,266

grade

  • grade_5 · 1,266
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
2572468 WA Pierce   school   27901   Chief Leschi Schools   5549 Chief Leschi Schools             2020   grade_5 0 0 6   41 0     0   0   25 22 0   0   0   29       1.0 47 0 0 6   41 0     0   0   25 22 0   0 0 29     1 47
2577132 WA Whatcom   school   37903   Lummi Tribal Agency   5373 Lummi Nation School             2020   grade_5 1 0 0   33 0     0   1   21 14 0   0   0   33       0.0 35 1 0 0   33 0     0   1   21 14 0   0 0 33     0 35
2578129 WA King   school   17903   Muckleshoot Indian Tribe   1986 Muckleshoot Tribal School             2020   grade_5 0 0 0   40 0     0   1   20 21 0   0   0   26       0.0 41 0 0 0   40 0     0   1   20 21 0   0 0 26     0 41
2579423 WA Okanogan   school   24019   Omak School District   4278 Paschal Sherman             2020   grade_5 0 0 1   11 0     0   1   3 10 0   0   0   13       0.0 13 0 0 1   11 0     0   1   3 10 0   0 0 13     0 13
2580496 WA Clallam   school   5903   Quileute Tribal School District   5430 Quileute Tribal School             2020   grade_5 0 0 0   8 0     0   0   5 3 0   0   0   6       0.0 8 0 0 0   8 0     0   0   5 3 0   0 0 6     0 8
2584866 WA Thurston   school   34901   WA HE LUT Indian School Agency   5496 Wa He Lut Indian School             2020   grade_5 0 0 2   12 0     0   1   9 6 0   0   2   14       0.0 15 0 0 2   12 0     0   1   9 6 0   0 2 14     0 15
2571724 WA Skagit   school 5300780 29100   Burlington-Edison School District 530078000157 3251 Lucille Umbarger Elementary   Regular School No Elementary 01 08 2020   grade_5 26 0 42   2 2     0   6   37 41 0   23   2   59       4.0 78 26 0 42   2 2     0   6   37 41 0   23 2 59     4 78
2576622 WA King   school 5304230 17414   Lake Washington School District 530423000673 3856 Community School   Alternative School No Elementary 01 05 2020   grade_5 11 1 1   0 0     0   2   8 7 0   0   0   0       1.0 15 11 1 1   0 0     0   2   8 7 0   0 0 0     1 15
2576700 WA King   school 5304230 17414   Lake Washington School District 530423002519 1687 Explorer Community School   Alternative School No Elementary 01 05 2020   grade_5 10 0 0   0 3     0   0   6 7 0   0   0   0       0.0 13 10 0 0   0 3     0   0   6 7 0   0 0 0     0 13
2579511 WA San Juan   school 5306300 28137   Orcas Island School District 530630000946 3808 Waldron Island School   Regular School No Elementary 01 08 2020   grade_5 0 0 0   0 0     0   1   0 1 0   0   0   0       0.0 1 0 0 0   0 0     0   1   0 1 0   0 0 0     0 1
2582163 WA Clallam   school 5307830 5323   Sequim School District 530783002552 1708 Olympic Peninsula Academy   Alternative School No Other 01 12 2020   grade_5 7 0 1   0 0     0   0   5 3 0   0   0   2       0.0 8 7 0 1   0 0     0   0   5 3 0   0 0 2     0 8
2585300 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001641 3196 Ness Elementary   Regular School No Elementary 01 05 2020   grade_5 40 0 5   0 0     0   0   31 14 0   2   1   28       0.0 45 40 0 5   0 0     0   0   31 14 0   2 1 28     0 45
2585306 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001644 3129 Orchard Center Elementary   Regular School No Elementary 01 05 2020   grade_5 36 0 3   2 0     1   4   22 24 0   1   3   29       1.0 46 36 0 3   2 0     1   4   22 24 0   1 3 29     1 46
2585312 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001646 3194 Pasadena Park Elementary   Regular School No Elementary 01 05 2020   grade_5 47 2 7   0 4     1   8   31 38 0   1   1   31       2.0 69 47 2 7   0 4     1   8   31 38 0   1 1 31     2 69
2585447 WA Pierce   school 5309780 27416   White River School District 530978002245 4309 Foothills Elementary   Regular School No Elementary 01 05 2020   grade_5 79 4 17   0 1     1   4   45 61 0   5   2   52       4.0 106 79 4 17   0 1     1   4   45 61 0   5 2 52     4 106
2585458 WA Pierce   school 5309780 27416   White River School District 530978001720 4471 Mountain Meadow Elementary   Regular School No Elementary 01 05 2020   grade_5 91 2 9   1 1     0   7   59 52 0   2   0   24       8.0 111 91 2 9   1 1     0   7   59 52 0   2 0 24     8 111
2585677 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2020   grade_5 12 0 16   0 0     0   1   13 16 0   4   1   14       1.0 29 12 0 16   0 0     0   1   13 16 0   4 1 14     1 29
2574805 WA Pierce   school 5302880 27417   Fife School District 530288000466 2809 Endeavour Intermediate   Regular School No Elementary 02 05 2020   grade_5 50 6 44   1 10     15   24   86 64 0   18   4   85       4.0 150 50 6 44   1 10     15   24   86 64 0   18 4 85     4 150
2574817 WA Pierce   school 5302880 27417   Fife School District 530288002875 4557 Hedden Elementary School   Regular School No Elementary 02 05 2020   grade_5 79 4 21   2 15     5   18   72 72 0   13   3   51       8.0 144 79 4 21   2 15     5   18   72 72 0   13 3 51     8 144
2570779 WA Clark   school 5300380 6119   Battle Ground School District 530038002782 1836 CAM Academy   Alternative School No Other 03 12 2020   grade_5 45 0 3   0 5     0   2   24 31 0   4   0   11       3.0 55 45 0 3   0 5     0   2   24 31 0   4 0 11     3 55
2571492 WA Whatcom   school 5300570 37503   Blaine School District 530057000130 2713 Blaine Elementary School   Regular School No Elementary 03 05 2020   grade_5 120 4 21   1 6     0   7   88 71 0   4   2   88       7.0 159 120 4 21   1 6     0   7   88 71 0   4 2 88     7 159
2571860 WA Chelan   school 5300950 4228   Cascade School District 530095001934 2827 Alpine Lakes Elementary   Regular School No Elementary 03 05 2020   grade_5 62 0 31   1 0     0   3   45 52 0   9   5   58       3.0 97 62 0 31   1 0     0   3   45 52 0   9 5 58     3 97
2572146 WA Spokane   school 5301110 32356   Central Valley School District 530111002681 4529 Liberty Lake Elementary   Regular School No Elementary 03 05 2020   grade_5 165 2 3   0 4     1   6   105 77 0   2   0   35       7.0 182 165 2 3   0 4     1   6   105 77 0   2 0 35     7 182
2572346 WA Lewis   school 5301170 21302   Chehalis School District 530117003655 5510 Orin C Smith Elementary School   Regular School No Elementary 03 05 2020   grade_5 146 0 50   0 0     0   14   111 99 0   9   5   111       5.0 210 146 0 50   0 0     0   14   111 99 0   9 5 111     5 210
2572482 WA Jefferson   school 5301290 16049   Chimacum School District 530129000232 2697 Chimacum Elementary School   Regular School No Elementary 03 06 2020   grade_5 56 0 7   0 0     0   0   36 27 0   0   2   38       0.0 63 56 0 7   0 0     0   0   36 27 0   0 2 38     0 63
2572885 WA Stevens   school 5301630 33115   Colville School District 530163001898 4180 Fort Colville Elementary   Regular School No Elementary 03 05 2020   grade_5 99 1 13   3 0     0   8   68 56 0   2   2   66       1.0 124 99 1 13   3 0     0   8   68 56 0   2 2 66     1 124
2573117 WA Spokane   school 5302070 32414   Deer Park School District 530207000306 2173 Arcadia Elementary   Regular School No Elementary 03 05 2020   grade_5 134 3 11   3 1     1   0   80 73 0   1   3   82       9.0 153 134 3 11   3 1     1   0   80 73 0   1 3 82     9 153
2575087 WA Snohomish   school 5303210 31332   Granite Falls School District 530321002482 4479 Monte Cristo Elementary   Regular School No Elementary 03 06 2020   grade_5 113 2 20   2 3     0   15   78 77 0   5   7   71       4.0 155 113 2 20   2 3     0   15   78 77 0   5 7 71     4 155
2576332 WA Benton   school 5304020 3052   Kiona-Benton City School District 530402003279 4217 Kiona-Benton Intermediate School   Regular School No Elementary 03 05 2020   grade_5 52 0 59   0 0     0   5   62 54 0   31   3   0       0.0 116 52 0 59   0 0     0   5   62 54 0   31 3 0     0 116
2577811 WA Grays Harbor   school 5305160 14066   Montesano School District 530516000781 3374 Simpson Avenue Elementary   Regular School No Elementary 03 06 2020   grade_5 78 0 11   2 1     0   11   57 46 0   1   0   37       6.0 103 78 0 11   2 1     0   11   57 46 0   1 0 37     6 103
2579144 WA Grays Harbor   school 5306000 14400   Oakville School District 530600003712 5584 Oakville Homelink Alternative School   Alternative School No Other 03 12 2020   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
2579175 WA Pacific   school 5306060 25101   Ocean Beach School District 530606003050 4039 Ocean Park Elementary   Regular School No Elementary 03 05 2020   grade_5 59 0 15   2 2     0   4   40 42 0   4   20   57       3.0 82 59 0 15   2 2     0   4   40 42 0   4 20 57     3 82
2579398 WA Okanogan   school 5306220 24019   Omak School District 530622000938 3051 E Omak Elementary   Regular School No Elementary 03 05 2020   grade_5 36 0 31   27 3     0   7   48 56 0   15   0   90       0.0 104 36 0 31   27 3     0   7   48 56 0   15 0 90     0 104
2579737 WA Franklin   school 5306570 11001   Pasco School District 530657003542 5394 Marie Curie STEM Elementary   Regular School No Elementary 03 06 2020   grade_5 8 0 214   0 3     0   3   102 126 0   153   1   215       1.0 228 8 0 214   0 3     0   3   102 126 0   153 1 215     1 228
2580130 WA Benton   school 5306900 3116   Prosser School District 530690001011 3316 Prosser Heights Elementary   Regular School No Elementary 03 05 2020   grade_5 40 2 103   1 1     0   4   76 75 0   27   4   125       1.0 151 40 2 103   1 1     0   4   76 75 0   27 4 125     1 151
2581150 WA Thurston   school 5307470 34401   Rochester School District 530747001116 3801 Grand Mound Elementary   Regular School No Elementary 03 05 2020   grade_5 94 0 47   5 1     2   11   88 72 0   16   4   101       7.0 160 94 0 47   5 1     2   11   88 72 0   16 4 101     7 160
2582118 WA Yakima   school 5307770 39119   Selah School District 530777003546 5384 Selah Intermediate School   Regular School No Elementary 03 05 2020   grade_5 170 2 88   1 1     0   16   135 143 0   23   1   162       4.0 278 170 2 88   1 1     0   16   135 143 0   23 1 162     4 278
2582416 WA Snohomish   school 5308020 31201   Snohomish School District 530802001324 3005 Emerson Elementary   Regular School No Elementary 03 06 2020   grade_5 38 0 13   0 0     0   4   32 23 0   7   3   24       2.0 55 38 0 13   0 0     0   4   32 23 0   7 3 24     2 55
2583441 WA Skamania   school 5308520 30303   Stevenson-Carson School District 530852001434 2882 Carson Elementary   Regular School No Elementary 03 06 2020   grade_5 57 0 10   2 0     0   7   37 39 0   2   1   44       4.0 76 57 0 10   2 0     0   7   37 39 0   2 1 44     4 76
2584172 WA Thurston   school 5308820 34402   Tenino School District 530882002241 4238 Tenino Elementary School   Regular School No Elementary 03 05 2020   grade_5 93 0 14   0 0     0   9   64 52 0   2   4   63       3.0 116 93 0 14   0 0     0   9   64 52 0   2 4 63     3 116
2585015 WA Yakima   school 5309480 39207   Wapato School District 530948002611 4518 Adams Elementary   Regular School No Elementary 03 05 2020   grade_5 1 0 99   24 3     0   0   67 60 0   59   14   124       2.0 127 1 0 99   24 3     0   0   67 60 0   59 14 124     2 127
2585030 WA Yakima   school 5309480 39207   Wapato School District 530948001616 2757 Satus Elementary   Regular School No Elementary 03 05 2020   grade_5 1 0 95   34 1     0   1   75 57 0   72   14   129       2.0 132 1 0 95   34 1     0   1   75 57 0   72 14 129     2 132
2573153 WA Pierce   school 5302130 27343   Dieringer School District 530213002812 4548 Dieringer Heights Elementary   Regular School No Elementary 04 05 2020   grade_5 111 2 18   1 14     1   14   79 82 0   3   0   28       14.0 161 111 2 18   1 14     1   14   79 82 0   3 0 28     14 161
2575168 WA Yakima   school 5303510 39203   Highland School District 530351000517 3073 Tieton Intermediate School   Regular School No Middle 04 06 2020   grade_5 14 1 81   0 0     0   1   50 47 0   22   4   85       1.0 97 14 1 81   0 0     0   1   50 47 0   22 4 85     1 97
2575422 WA Grays Harbor   school 5303660 14028   Hoquiam School District 530366000562 2972 Central Elementary School   Regular School No Elementary 04 05 2020   grade_5 78 0 28   10 2     0   5   60 62 1   5   4   99       2.0 123 78 0 28   10 2     0   5   60 62 1   5 4 99     2 123
2580530 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 2020   grade_5 29 0 28   5 0     0   5   33 34 0   11   1   47       4.0 67 29 0 28   5 0     0   5   33 34 0   11 1 47     4 67
2581205 WA Grant   school 5307620 13160   Royal School District 530762003526 5388 Royal Intermediate School   Regular School No Middle 04 06 2020   grade_5 29 0 121   0 0     0   0   68 82 0   53   9   110       12.0 150 29 0 121   0 0     0   0   68 82 0   53 9 110     12 150
2583417 WA Pierce   school 5308460 27001   Steilacoom Hist. School District 530846001432 3827 Saltars Point Elementary   Regular School No Elementary 04 05 2020   grade_5 87 22 51   1 16     0   46   98 125 0   6   0   71       12.0 223 87 22 51   1 16     0   46   98 125 0   6 0 71     12 223
2584036 WA Pierce   school 5308700 27010   Tacoma School District 530870001508 3116 Wainwright   Regular School No Middle 04 08 2020   grade_5 44 15 10   2 6     0   26   37 66 0   8   5   61       2.0 103 44 15 10   2 6     0   26   37 66 0   8 5 61     2 103
2585496 WA Klickitat   school 5309810 20405   White Salmon Valley School District 530981003500 5368 Wallace & Priscilla Stevenson Intermediate School   Regular School No Middle 04 06 2020   grade_5 59 0 27   0 0     0   2   43 45 0   15   4   43       0.0 88 59 0 27   0 0     0   2   43 45 0   15 4 43     0 88
2585898 WA Yakima   school 5310170 39205   Zillah School District 531017001896 4221 Zillah Intermediate School   Regular School No Middle 04 06 2020   grade_5 38 0 53   4 0     0   7   49 53 0   6   5   63       3.0 102 38 0 53   4 0     0   7   49 53 0   6 5 63     3 102
2570754 WA Kitsap   school 5300330 18303   Bainbridge Island School District 530033002734 4542 Sonoji Sakai Intermediate   Regular School No Middle 05 06 2020   grade_5 172 0 12   1 3     0   21   108 101 0   3   1   15       29.0 209 172 0 12   1 3     0   21   108 101 0   3 1 15     29 209
2570764 WA Clark   school 5300380 6119   Battle Ground School District 530038000048 2671 Amboy Middle School   Regular School No Middle 05 08 2020   grade_5 119 0 3   0 0     0   0   69 53 0   2   0   48       4.0 122 119 0 3   0 0     0   0   69 53 0   2 0 48     4 122
2570792 WA Clark   school 5300380 6119   Battle Ground School District 530038003262 5133 Chief Umtuch Middle   Regular School No Middle 05 08 2020   grade_5 115 0 9   0 0     0   6   66 64 0   3   0   44       3.0 130 115 0 9   0 0     0   6   66 64 0   3 0 44     3 130
2570798 WA Clark   school 5300380 6119   Battle Ground School District 530038003176 5089 Daybreak Middle   Regular School No Middle 05 08 2020   grade_5 85 0 18   0 0     1   10   69 45 0   9   2   51       4.0 114 85 0 18   0 0     1   10   69 45 0   9 2 51     4 114
2570836 WA Clark   school 5300380 6119   Battle Ground School District 530038000052 3545 Laurin Middle School   Regular School No Middle 05 08 2020   grade_5 104 3 24   0 9     0   14   81 73 0   22   2   69       7.0 154 104 3 24   0 9     0   14   81 73 0   22 2 69     7 154
2570854 WA Clark   school 5300380 6119   Battle Ground School District 530038000054 3997 Pleasant Valley Middle   Regular School No Middle 05 08 2020   grade_5 70 2 13   0 5     2   1   46 47 0   8   1   40       4.0 93 70 2 13   0 5     2   1   46 47 0   8 1 40     4 93
2570878 WA Clark   school 5300380 6119   Battle Ground School District 530038003214 5131 Tukes Valley Middle School   Regular School No Middle 05 08 2020   grade_5 106 0 14   0 1     1   9   62 69 0   10   0   49       4.0 131 106 0 14   0 1     1   9   62 69 0   10 0 49     4 131
2571899 WA Chelan   school 5300960 4222   CASHMERE SCHOOL DISTRICT 530096000169 2315 CASHMERE MIDDLE SCHOOL   Regular School No Middle 05 08 2020   grade_5 70 0 51   0 1     0   2   62 62 0   17   3   60       5.0 124 70 0 51   0 1     0   2   62 62 0   17 3 60     5 124
2573296 WA Douglas   school 5302310 9206   Eastmont School District 530231002948 4590 Clovis Point Intermediate School   Regular School No Middle 05 07 2020   grade_5 117 2 107   0 0     0   7   101 132 0   34   5   155       14.0 233 117 2 107   0 0     0   7   101 132 0   34 5 155     14 233
2573880 WA Grant   school 5302610 13165   Ephrata School District 530261002559 2695 Parkway School   Regular School No Middle 05 06 2020   grade_5 122 0 76   0 2     0   3   101 102 0   22   4   129       9.0 203 122 0 76   0 2     0   3   101 102 0   22 4 129     9 203
2574508 WA King   school 5302820 17210   Federal Way School District 530282000437 3898 Illahee Middle School   Regular School No Middle 05 08 2020   grade_5 15 5 12   0 4     1   6   24 19 0   4   0   20       0.0 43 15 5 12   0 4     1   6   24 19 0   4 0 20     0 43
2574973 WA Klickitat   school 5303090 20404   Goldendale School District 530309000491 3393 Goldendale Middle School   Regular School No Middle 05 08 2020   grade_5 55 0 10   3 0     1   5   40 34 0   4   2   55       9.0 74 55 0 10   3 0     1   5   40 34 0   4 2 55     9 74
2575054 WA Yakima   school 5303180 39204   Granger School District 530318000504 2531 Granger Middle School   Regular School No Middle 05 08 2020   grade_5 1 0 11   1 0     0   0   5 8 0   4   1   13       0.0 13 1 0 11   1 0     0   0   5 8 0   4 1 13     0 13
2576311 WA Stevens   school 5303990 33212   Kettle Falls School District 530399001904 3198 Kettle Falls Middle School   Regular School No Middle 05 08 2020   grade_5 57 0 5   2 0     0   7   37 34 0   0   2   38       10.0 71 57 0 5   2 0     0   7   37 34 0   0 2 38     10 71
2576953 WA Whitman   school 5304290 38264   Lamont School District 530429000687 3137 Lamont Middle School   Regular School No Middle 05 08 2020   grade_5 10 0 1   0 0     0   0   6 5 0   0   1   8       0.0 11 10 0 1   0 0     0   0   6 5 0   0 1 8     0 11
2578287 WA Yakima   school 5305460 39003   Naches Valley School District 530546000824 2898 Naches Valley Middle School   Regular School No Middle 05 08 2020   grade_5 69 2 23   0 0     0   3   49 48 0   6   0   47       5.0 97 69 2 23   0 0     0   3   49 48 0   6 0 47     5 97
2578349 WA Pend Oreille   school 5305610 26056   Newport School District 530561001911 3968 Sadie Halstead Middle School   Regular School No Middle 05 08 2020   grade_5 66 1 5   1 0     0   3   42 34 0   0   3   43       2.0 76 66 1 5   1 0     0   3   42 34 0   0 3 43     2 76
2579096 WA Island   school 5305940 15201   Oak Harbor School District 530594000904 3274 Oak Harbor Intermediate School   Regular School No Middle 05 06 2020   grade_5 231 16 83   1 26     1   49   206 201 0   18   13   176       22.0 407 231 16 83   1 26     1   49   206 201 0   18 13 176     22 407
2580596 WA King   school 5300335 17908   Rainier Prep Charter School District 530033503533 5380 Rainier Prep   Regular School Yes Middle 05 08 2020   grade_5 3 37 38   0 6     0   5   47 42 0   25   2   67       0.0 89 3 37 38   0 6     0   5   47 42 0   25 2 67     0 89
2581021 WA Clark   school 5307350 6122   Ridgefield School District 530735003660 5518 Sunset Ridge Intermediate School   Regular School No Middle 05 06 2020   grade_5 210 1 25   0 7     0   16   136 123 0   6   3   59       9.0 259 210 1 25   0 7     0   16   136 123 0   6 3 59     9 259
2582216 WA Mason   school 5307900 23309   Shelton School District 530790002990 4586 Olympic Middle School   Regular School No Middle 05 06 2020   grade_5 147 0 129   5 0     1   34   157 159 0   72   27   238       16.0 316 147 0 129   5 0     1   34   157 159 0   72 27 238     16 316
2582924 WA Spokane   school 5308250 32081   Spokane School District 530825001397 3819 Excelsior Youth Center School (Closed after 2019-2020 school year)   Regular School No High 05 12 2020   grade_5 2 0 0   0 0     0   0   2 0 0   0   1   2       0.0 2 2 0 0   0 0     0   0   2 0 0   0 1 2     0 2
2584354 WA Klickitat   school 5309060 20400   Trout Lake School District 530906001539 2676 Trout Lake School   Regular School No High 05 12 2020   grade_5 14 0 1   0 0     0   2   6 11 0   0   0   0       0.0 17 14 0 1   0 0     0   2   6 11 0   0 0 0     0 17
2584510 WA Pierce   school 5309180 27083   University Place School District 530918002383 4325 Drum Intermediate   Regular School No Middle 05 07 2020   grade_5 102 15 42   2 7     1   38   114 93 0   12   6   84       20.0 207 102 15 42   2 7     1   38   114 93 0   12 6 84     20 207
2584521 WA Pierce   school 5309180 27083   University Place School District 530918001550 3296 Narrows View Intermediate   Regular School No Middle 05 07 2020   grade_5 105 24 27   0 25     4   46   121 110 0   9   4   85       7.0 231 105 24 27   0 25     4   46   121 110 0   9 4 85     7 231
2585334 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969002685 1755 West Valley City School   Alternative School No Middle 05 08 2020   grade_5 18 0 1   0 0     0   0   7 12 0   0   0   8       0.0 19 18 0 1   0 0     0   0   7 12 0   0 0 8     0 19
2585388 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972002545 4506 West Valley Middle School   Regular School No Middle 05 06 2020   grade_5 249 2 144   1 11     0   21   202 226 0   21   2   224       12.0 428 249 2 144   1 11     0   21   202 226 0   21 2 224     12 428
2585639 WA Cowlitz   school 5310050 8404   Woodland School District 531005003509 5409 Woodland Middle School   Regular School No Middle 05 08 2020   grade_5 113 1 39   1 5     0   5   93 71 0   15   7   84       12.0 164 113 1 39   1 5     0   5   93 71 0   15 7 84     12 164
2570467 WA Snohomish   school 5300240 31016   Arlington School District 530024003008 5010 Haller Middle School   Regular School No Middle 06 08 2020   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
2573147 WA Spokane   school 5302070 32414   Deer Park School District 530207000308 3261 Deer Park Middle School   Regular School No Middle 06 08 2020   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
2573800 WA King   school 5300001 17216   Enumclaw School District 530000102054 4210 Enumclaw Middle School   Regular School No Middle 06 08 2020   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
2575827 WA Benton   school 5303930 3017   Kennewick School District 530393000598 4028 Desert Hills Middle School   Regular School No Middle 06 08 2020   grade_5 1 0 0   0 0     0   1   2 0 0   0   0   0       0.0 2 1 0 0   0 0     0   1   2 0 0   0 0 0     0 2
2576993 WA Cowlitz   school 5304470 8122   Longview School District 530447000699 3475 Cascade Middle School   Regular School No Middle 06 08 2020   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
2577043 WA Cowlitz   school 5304470 8122   Longview School District 530447000705 2831 Monticello Middle School   Regular School No Middle 06 08 2020   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
2579120 WA Whitman   school 5305970 38324   Oakesdale School District 530597000908 2432 Oakesdale High School   Regular School No High 06 12 2020   grade_5 1 0 0   0 0     0   1   2 0 0   0   0   0       0.0 2 1 0 0   0 0     0   1   2 0 0   0 0 0     0 2
2579386 WA Thurston   school 5306180 34111   Olympia School District 530618001737 4473 Thurgood Marshall Middle School   Regular School No Middle 06 08 2020   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
2584398 WA King   school 5308130 17406   Tukwila School District 530813003650 5536 Tukwila Online Learning   Alternative School No High 06 12 2020   grade_5 0 1 0   0 0     0   0   1 0 0   0   0   1       0.0 1 0 1 0   0 0     0   0   1 0 0   0 0 1     0 1
2584922 WA Grant   school 5309360 13073   Wahluke School District 530936003264 5144 Wahluke Junior High   Regular School No Middle 06 08 2020   grade_5 0 0 1   0 0     0   0   1 0 0   1   1   1       0.0 1 0 0 1   0 0     0   0   1 0 0   1 1 1     0 1
2573867 WA Grant   school 5302610 13165   Ephrata School District 530261000387 3373 Ephrata Middle School   Regular School No Middle 07 08 2020   grade_5 2 0 1   0 0     0   0   2 1 0   1   0   2       0.0 3 2 0 1   0 0     0   0   2 1 0   1 0 2     0 3
2573302 WA Douglas   school 5302310 9206   Eastmont School District 530231000323 3372 Eastmont Junior High   Regular School No Secondary 08 09 2020   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
2573199 WA Spokane   school 5302280 32361   East Valley School District (Spokane) 530228000312 3360 East Valley High School   Regular School No High 09 12 2020   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
2570316 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000005 3216 Central Park Elementary   Regular School No Elementary KG 05 2020   grade_5 26 0 10   1 0     0   2   23 16 0   4   2   21       1.0 39 26 0 10   1 0     0   2   23 16 0   4 2 21     1 39
2570351 WA Grays Harbor   school 5300030 14005   Aberdeen School District 530003000008 2449 McDermoth Elementary   Regular School No Elementary KG 05 2020   grade_5 26 0 19   0 0     0   1   25 21 0   6   1   30       2.0 46 26 0 19   0 0     0   1   25 21 0   6 1 30     2 46
2570423 WA Skagit   school 5300150 29103   Anacortes School District 530015000017 3182 Fidalgo Elementary   Regular School No Elementary KG 05 2020   grade_5 58 2 12   1 4     0   2   43 36 0   1   2   32       7.0 79 58 2 12   1 4     0   2   43 36 0   1 2 32     7 79
2570431 WA Skagit   school 5300150 29103   Anacortes School District 530015000018 3252 Island View Elementary   Regular School No Elementary KG 05 2020   grade_5 58 0 8   2 0     0   2   31 39 0   1   2   18       4.0 70 58 0 8   2 0     0   2   31 39 0   1 2 18     4 70
2570438 WA Skagit   school 5300150 29103   Anacortes School District 530015000019 3057 Mount Erie Elementary   Regular School No Elementary KG 05 2020   grade_5 45 0 5   0 1     1   1   23 30 0   1   0   15       4.0 53 45 0 5   0 1     1   1   23 30 0   1 0 15     4 53
2570463 WA Snohomish   school 5300240 31016   Arlington School District 530024002248 4327 Eagle Creek Elementary   Regular School No Elementary KG 05 2020   grade_5 84 0 14   2 0     0   9   62 47 0   4   4   47       10.0 109 84 0 14   2 0     0   9   62 47 0   4 4 47     10 109
2570484 WA Snohomish   school 5300240 31016   Arlington School District 530024002940 4573 Pioneer Elementary   Regular School No Elementary KG 05 2020   grade_5 71 1 19   0 1     0   13   64 41 0   6   1   42       9.0 105 71 1 19   0 1     0   13   64 41 0   6 1 42     9 105
2570504 WA Snohomish   school 5300240 31016   Arlington School District 530024002589 1714 Stillaguamish Valley Learning Center   Alternative School No Elementary KG 08 2020   grade_5 3 0 0   0 0     0   2   5 0 0   0   0   2       1.0 5 3 0 0   0 0     0   2   5 0 0   0 0 2     1 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]);