Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2017 · 1,263

grade

  • grade_5 · 1,263
Link rowid ▲ state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
632792 WA Yakima   school 5310170 39205   Zillah School District 531017001896 4221 Zillah Intermediate School   Regular School No Elementary 04 06 2017   grade_5 41 1 58   5 0     0   5   65 45 0   12   1   70       1.0 110 41 1 58   5 0     0   5   65 45 0   12 1 70     1 110
632774 WA Thurston   school 5310140 34002   Yelm School District 531014001916 4224 Yelm Prairie Elementary   Regular School No Elementary PK 06 2017   grade_5 57 0 10   2 2     0   8   36 43 0   3   2   28       4.0 79 57 0 10   2 2     0   8   36 43 0   3 2 28     4 79
632750 WA Thurston   school 5310140 34002   Yelm School District 531014001715 3848 Southworth Elementary   Regular School No Elementary KG 06 2017   grade_5 45 1 10   4 1     1   11   40 33 0   2   0   31       5.0 73 45 1 10   4 1     1   11   40 33 0   2 0 31     5 73
632737 WA Thurston   school 5310140 34002   Yelm School District 531014001204 4451 Mill Pond Elementary School   Regular School No Elementary PK 06 2017   grade_5 44 1 12   2 0     3   13   36 39 0   0   0   40       7.0 75 44 1 12   2 0     3   13   36 39 0   0 0 40     7 75
632728 WA Thurston   school 5310140 34002   Yelm School District 531014001714 2260 McKenna Elementary   Regular School No Elementary KG 06 2017   grade_5 52 0 4   0 1     1   5   29 34 0   2   0   29       3.0 63 52 0 4   0 1     1   5   29 34 0   2 0 29     3 63
632719 WA Thurston   school 5310140 34002   Yelm School District 531014003016 5018 Lackamas Elementary   Regular School No Elementary KG 06 2017   grade_5 22 0 4   0 0     0   4   13 17 0   0   0   18       2.0 30 22 0 4   0 0     0   4   13 17 0   0 0 18     2 30
632710 WA Thurston   school 5310140 34002   Yelm School District 531014002393 4346 Fort Stevens Elementary   Regular School No Elementary PK 06 2017   grade_5 61 1 14   1 2     0   6   44 41 0   1   2   48       3.0 85 61 1 14   1 2     0   6   44 41 0   1 2 48     3 85
632682 WA Yakima   school 5310110 39007   Yakima School District 531011001709 3312 Whitney Elementary   Regular School No Elementary PK 05 2017   grade_5 22 3 57   0 0     0   3   45 40 0   12   1   62       1.0 85 22 3 57   0 0     0   3   45 40 0   12 1 62     1 85
632665 WA Yakima   school 5310110 39007   Yakima School District 531011001704 2529 Roosevelt Elementary School   Regular School No Elementary KG 05 2017   grade_5 20 2 67   2 2     0   0   48 45 0   29   2   83       1.0 93 20 2 67   2 2     0   0   48 45 0   29 2 83     1 93
632657 WA Yakima   school 5310110 39007   Yakima School District 531011001703 3264 Robertson Elementary   Regular School No Elementary KG 05 2017   grade_5 26 0 61   2 0     0   4   52 41 0   26   11   86       9.0 93 26 0 61   2 0     0   4   52 41 0   26 11 86     9 93
632645 WA Yakima   school 5310110 39007   Yakima School District 531011001687 2433 Ridgeview Elementary   Regular School No Elementary KG 05 2017   grade_5 8 1 82   0 0     0   1   46 46 0   32   5   79       3.0 92 8 1 82   0 0     0   1   46 46 0   32 5 79     3 92
632638 WA Yakima   school 5310110 39007   Yakima School District 531011001701 2819 Nob Hill Elementary School   Regular School No Elementary KG 05 2017   grade_5 31 0 49   0 0     0   3   41 42 0   15   1   43       5.0 83 31 0 49   0 0     0   3   41 42 0   15 1 43     5 83
632631 WA Yakima   school 5310110 39007   Yakima School District 531011001700 2177 Mckinley Elementary School   Regular School No Elementary KG 05 2017   grade_5 11 0 65   2 0     0   1   32 47 0   29   2   71       5.0 79 11 0 65   2 0     0   1   32 47 0   29 2 71     5 79
632623 WA Yakima   school 5310110 39007   Yakima School District 531011001699 2899 Mcclure Elementary School   Regular School No Elementary PK 05 2017   grade_5 21 1 66   0 0     0   3   56 35 0   31   3   64       3.0 91 21 1 66   0 0     0   3   56 35 0   31 3 64     3 91
632615 WA Yakima   school 5310110 39007   Yakima School District 531011001814 3817 Martin Luther King Jr Elementary   Regular School No Elementary KG 05 2017   grade_5 6 0 83   0 0     0   3   43 49 0   52   4   82       3.0 92 6 0 83   0 0     0   3   43 49 0   52 4 82     3 92
632596 WA Yakima   school 5310110 39007   Yakima School District 531011001694 2715 Hoover Elementary School   Regular School No Elementary PK 05 2017   grade_5 9 0 77   0 0     0   2   54 34 0   28   6   75       1.0 88 9 0 77   0 0     0   2   54 34 0   28 6 75     1 88
632588 WA Yakima   school 5310110 39007   Yakima School District 531011001693 2818 Gilbert Elementary School   Regular School No Elementary KG 05 2017   grade_5 28 0 57   3 1     0   2   46 45 0   20   1   71       8.0 91 28 0 57   3 1     0   2   46 45 0   20 1 71     8 91
632581 WA Yakima   school 5310110 39007   Yakima School District 531011001692 2176 Garfield Elementary School   Regular School No Elementary KG 05 2017   grade_5 0 2 82   0 0     0   0   38 46 0   47   1   79       0.0 84 0 2 82   0 0     0   0   38 46 0   47 1 79     0 84
632560 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2017   grade_5 11 1 13   0 0     0   3   19 9 0   3   0   12       2.0 28 11 1 13   0 0     0   3   19 9 0   3 0 12     2 28
632545 WA Yakima   school 5310110 39007   Yakima School District 531011001686 3138 Barge-Lincoln Elementary School   Regular School No Elementary PK 05 2017   grade_5 2 0 85   1 0     0   2   48 42 0   35   5   89       10.0 90 2 0 85   1 0     0   2   48 42 0   35 5 89     10 90
632537 WA Yakima   school 5310110 39007   Yakima School District 531011001685 2592 Adams Elementary School   Regular School No Elementary PK 05 2017   grade_5 4 0 117   1 0     0   0   62 60 0   68   3   118       2.0 122 4 0 117   1 0     0   0   62 60 0   68 3 118     2 122
632530 WA Cowlitz   school 5310050 8404   Woodland School District 531005001684 3513 Yale Elementary   Regular School No Elementary KG 05 2017   grade_5 1 0 0   0 0     0   0   0 1 0   0   0   1       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 1     0 1
632517 WA Cowlitz   school 5310050 8404   Woodland School District 531005003509 5409 Woodland Middle School   Regular School No Middle 05 08 2017   grade_5 110 3 35   0 1     0   6   77 78 0   13   4   86       1.0 155 110 3 35   0 1     0   6   77 78 0   13 4 86     1 155
632496 WA Cowlitz   school 5310050 8404   Woodland School District 531005003371 5246 Lewis River Academy   Alternative School No Other KG 12 2017   grade_5 2 0 1   0 0     0   1   1 3 0   0   0   2       0.0 4 2 0 1   0 0     0   1   1 3 0   0 0 2     0 4
632481 WA Klickitat   school 5310020 20094   Wishram School District 531002001680 2605 Wishram High And Elementary Schl   Regular School No Other PK 12 2017   grade_5 5 0 0   1 0     0   0   6 0 0   0   1   6       0.0 6 5 0 0   1 0     0   0   6 0 0   0 1 6     0 6
632467 WA Grays Harbor   school 5309990 14117   Wishkah Valley School District 530999001679 3375 Wishkah Valley Elementary/High School   Regular School No Other KG 12 2017   grade_5 9 0 0   0 0     0   0   2 7 0   0   0   4       0.0 9 9 0 0   0 0     0   0   2 7 0   0 0 4     0 9
632447 WA Lewis   school 5309930 21232   Winlock School District 530993001677 2290 Winlock Miller Elementary   Regular School No Elementary PK 05 2017   grade_5 36 0 15   0 1     0   5   27 30 0   5   4   49       0.0 57 36 0 15   0 1     0   5   27 30 0   5 4 49     0 57
632427 WA Grant   school 5309900 13167   Wilson Creek School District 530990001674 2472 Wilson Creek Elementary   Regular School No Elementary KG 06 2017   grade_5 5 0 2   0 0     0   0   2 5 0   0   0   5       0.0 7 5 0 2   0 0     0   0   2 5 0   0 0 5     0 7
632411 WA Pacific   school 5309870 25160   Willapa Valley School District 530987001672 3444 Willapa Elementary   Regular School No Elementary KG 05 2017   grade_5 21 0 2   0 1     0   1   8 17 0   0   1   17       1.0 25 21 0 2   0 1     0   1   8 17 0   0 1 17     1 25
632396 WA Lincoln   school 5309840 22200   Wilbur School District 530984001667 3290 Wilbur Elementary School   Regular School No Elementary KG 06 2017   grade_5 19 0 0   0 0     1   2   12 10 0   0   1   8       0.0 22 19 0 0   0 0     1   2   12 10 0   0 1 8     0 22
632382 WA Klickitat   school 5309810 20405   White Salmon Valley School District 530981003500 5368 Wallace & Priscilla Stevenson Intermediate School   Regular School No Elementary 04 06 2017   grade_5 59 0 30   1 0     1   3   55 39 0   15   3   47       2.0 94 59 0 30   1 0     1   3   55 39 0   15 3 47     2 94
632363 WA Pierce   school 5309780 27416   White River School District 530978001894 4170 Wilkeson Elementary School   Regular School No Elementary KG 05 2017   grade_5 37 1 4   0 1     0   2   26 19 0   0   0   13       1.0 45 37 1 4   0 1     0   2   26 19 0   0 0 13     1 45
632340 WA Pierce   school 5309780 27416   White River School District 530978001720 4471 Mountain Meadow Elementary   Regular School No Elementary PK 05 2017   grade_5 69 0 10   0 1     0   6   44 42 0   4   3   25       0.0 86 69 0 10   0 1     0   6   44 42 0   4 3 25     0 86
632327 WA Pierce   school 5309780 27416   White River School District 530978002245 4309 Foothills Elementary   Regular School No Elementary KG 05 2017   grade_5 66 1 13   1 0     0   4   41 44 0   5   2   38       7.0 85 66 1 13   1 0     0   4   41 44 0   5 2 38     7 85
632318 WA Pierce   school 5309780 27416   White River School District 530978001661 2190 Elk Ridge Elementary   Regular School No Elementary KG 05 2017   grade_5 50 0 3   0 2     0   4   33 26 0   2   1   21       1.0 59 50 0 3   0 2     0   4   33 26 0   2 1 21     1 59
632302 WA Lewis   school 5309750 21303   White Pass School District 530975001658 3555 White Pass Elementary School   Regular School No Elementary KG 06 2017   grade_5 25 0 2   1 0     0   0   21 7 0   0   7   20       0.0 28 25 0 2   1 0     0   0   21 7 0   0 7 20     0 28
632281 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972002545 4506 West Valley Middle School   Regular School No Middle 05 06 2017   grade_5 269 2 124   2 13     2   18   219 211 0   27   4   190       9.0 430 269 2 124   2 13     2   18   219 211 0   27 4 190     9 430
632220 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969002685 1755 West Valley City School   Alternative School No Middle 05 08 2017   grade_5 36 1 3   0 0     0   3   13 30 0   0   0   19       2.0 43 36 1 3   0 0     0   3   13 30 0   0 0 19     2 43
632207 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969002419 2956 Seth Woodard Elementary   Regular School No Elementary KG 05 2017   grade_5 45 0 8   0 0     0   6   34 25 0   2   2   35       4.0 59 45 0 8   0 0     0   6   34 25 0   2 2 35     4 59
632201 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001646 3194 Pasadena Park Elementary   Regular School No Elementary KG 05 2017   grade_5 51 1 4   0 1     0   6   40 23 0   1   0   25       1.0 63 51 1 4   0 1     0   6   40 23 0   1 0 25     1 63
632195 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001644 3129 Orchard Center Elementary   Regular School No Elementary KG 05 2017   grade_5 35 1 2   1 1     0   6   25 21 0   1   0   32       2.0 46 35 1 2   1 1     0   6   25 21 0   1 0 32     2 46
632189 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001641 3196 Ness Elementary   Regular School No Elementary KG 05 2017   grade_5 36 1 8   0 0     0   5   29 21 0   1   1   35       1.0 50 36 1 8   0 0     0   5   29 21 0   1 1 35     1 50
632154 WA Chelan   school 5309660 4246   Wenatchee School District 530966001638 2907 Washington Elementary School   Regular School No Elementary KG 05 2017   grade_5 71 0 27   0 1     1   6   51 55 0   8   0   45       6.0 106 71 0 27   0 1     1   6   51 55 0   8 0 45     6 106
632142 WA Chelan   school 5309660 4246   Wenatchee School District 530966002550 1742 Valley Academy Of Learning (Closed after 2018-2019 school year)   Alternative School No Other KG 12 2017   grade_5 16 0 1   1 0     0   0   7 11 0   0   0   1       2.0 18 16 0 1   1 0     0   0   7 11 0   0 0 1     2 18
632134 WA Chelan   school 5309660 4246   Wenatchee School District 530966001637 3208 Sunnyslope Elementary School   Regular School No Elementary KG 05 2017   grade_5 44 0 12   0 1     0   4   30 31 0   5   2   15       4.0 61 44 0 12   0 1     0   4   30 31 0   5 2 15     4 61
632109 WA Chelan   school 5309660 4246   Wenatchee School District 530966001633 2347 Mission View Elementary School   Regular School No Elementary KG 05 2017   grade_5 25 0 71   0 2     0   0   48 50 0   39   5   82       8.0 98 25 0 71   0 2     0   0   48 50 0   39 5 82     8 98
632102 WA Chelan   school 5309660 4246   Wenatchee School District 530966001631 2279 Lewis And Clark Elementary Sch   Regular School No Elementary KG 05 2017   grade_5 15 0 54   0 0     0   2   34 37 0   37   5   61       3.0 71 15 0 54   0 0     0   2   34 37 0   37 5 61     3 71
632094 WA Chelan   school 5309660 4246   Wenatchee School District 530966000991 4423 John Newbery Elementary   Regular School No Elementary KG 05 2017   grade_5 54 0 36   0 2     0   9   48 53 0   22   4   55       6.0 101 54 0 36   0 2     0   9   48 53 0   22 4 55     6 101
632082 WA Chelan   school 5309660 4246   Wenatchee School District 530966001630 2301 Columbia Elementary School   Regular School No Elementary KG 05 2017   grade_5 25 0 54   0 0     0   3   44 38 0   32   3   72       2.0 82 25 0 54   0 0     0   3   44 38 0   32 3 72     2 82
632070 WA Chelan   school 5309660 4246   Wenatchee School District 530966001632 3209 Abraham Lincoln Elementary   Regular School No Elementary KG 05 2017   grade_5 20 1 55   1 0     0   0   37 40 0   25   4   64       3.0 77 20 1 55   1 0     0   0   37 40 0   25 4 64     3 77
632050 WA Stevens   school 5309630 33049   Wellpinit School District #49 530963003146 2549 Wellpinit Elementary School   Regular School No Elementary KG 05 2017   grade_5 0 0 2   15 0     0   4   13 8 0   6   8   19       0.0 21 0 0 2   15 0     0   4   13 8 0   6 8 19     0 21
632033 WA Douglas   school 5309600 9209   Waterville School District 530960001628 2162 Waterville High School   Regular School No Other 06 12 2017   grade_5 1 0 0   0 0     0   0   1 0 0   0   1   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 1 1     0 1
632026 WA Douglas   school 5309600 9209   Waterville School District 530960002192 2161 Waterville Elementary   Regular School No Elementary KG 05 2017   grade_5 8 0 4   0 0     0   1   11 2 0   0   0   10       0.0 13 8 0 4   0 0     0   1   11 2 0   0 0 10     0 13
632014 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other KG 12 2017   grade_5 2 0 0   0 0     0   0   1 1 0   0   0   2       0.0 2 2 0 0   0 0     0   0   1 1 0   0 0 2     0 2
631992 WA Clark   school 5309540 6112   Washougal School District 530954001622 2509 Hathaway Elementary   Regular School No Elementary KG 05 2017   grade_5 59 0 2   1 0     0   10   30 42 0   1   5   48       7.0 72 59 0 2   1 0     0   10   30 42 0   1 5 48     7 72
631985 WA Clark   school 5309540 6112   Washougal School District 530954001623 2911 Gause Elementary   Regular School No Elementary KG 05 2017   grade_5 86 1 14   0 1     0   7   62 47 0   3   2   35       4.0 109 86 1 14   0 1     0   7   62 47 0   3 2 35     4 109
631974 WA Clark   school 5309540 6112   Washougal School District 530954001621 3270 Cape Horn Skye Elementary   Regular School No Elementary KG 05 2017   grade_5 66 1 2   0 0     0   4   38 35 0   2   4   23       3.0 73 66 1 2   0 0     0   4   38 35 0   2 4 23     3 73
631953 WA Thurston   school 5300015 34975   Washington Center for Deaf and Hard of Hearing Youth 530001501016 4246 Washington State School for the Deaf   Regular School No Other PK 12 2017   grade_5 3 2 0   0 1     1   0   1 6 0   0   0   5       0.0 7 3 2 0   0 1     1   0   1 6 0   0 0 5     0 7
631932 WA Grant   school 5309510 13146   Warden School District 530951001618 2792 Warden Elementary   Regular School No Elementary PK 05 2017   grade_5 14 0 69   0 0     0   0   37 46 0   42   8   80       0.0 83 14 0 69   0 0     0   0   37 46 0   42 8 80     0 83
631916 WA Yakima   school 5309480 39207   Wapato School District 530948001616 2757 Satus Elementary   Regular School No Elementary PK 05 2017   grade_5 3 0 81   22 0     0   5   51 60 0   35   9   106       2.0 111 3 0 81   22 0     0   5   51 60 0   35 9 106     2 111
631904 WA Yakima   school 5309480 39207   Wapato School District 530948001614 2960 Camas Elementary (Closed after 2017-2018 school year)   Regular School No Elementary KG 05 2017   grade_5 2 0 94   29 4     0   5   67 67 0   51   9   131       0.0 134 2 0 94   29 4     0   5   67 67 0   51 9 131     0 134
631896 WA Yakima   school 5309480 39207   Wapato School District 530948002611 4518 Adams Elementary   Regular School No Elementary PK 05 2017   grade_5 1 0 43   11 0     0   1   33 23 0   18   4   52       2.0 56 1 0 43   11 0     0   1   33 23 0   18 4 52     2 56
631881 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001608 3728 Sharpstein Elementary School   Regular School No Elementary KG 05 2017   grade_5 37 1 23   1 1     0   2   36 29 0   10   3   37       3.0 65 37 1 23   1 1     0   2   36 29 0   10 3 37     3 65
631872 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001606 2159 Prospect Point Elementary   Regular School No Elementary KG 05 2017   grade_5 66 0 10   0 3     0   4   49 34 0   1   1   24       3.0 83 66 0 10   0 3     0   4   49 34 0   1 1 24     3 83
631863 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001605 2780 Pioneer Middle School   Regular School No Middle 06 08 2017   grade_5 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
631851 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001602 2078 Green Park Elementary School   Regular School No Elementary KG 05 2017   grade_5 37 0 32   0 1     0   5   35 40 0   5   3   49       3.0 75 37 0 32   0 1     0   5   35 40 0   5 3 49     3 75
631840 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001600 2528 Edison Elementary School   Regular School No Elementary KG 05 2017   grade_5 24 0 45   1 0     0   2   49 23 0   16   3   53       5.0 72 24 0 45   1 0     0   2   49 23 0   16 3 53     5 72
631832 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001891 4193 Blue Ridge Elementary   Regular School No Elementary PK 05 2017   grade_5 5 2 43   0 0     0   0   30 20 0   21   1   43       0.0 50 5 2 43   0 0     0   0   30 20 0   21 1 43     0 50
631824 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001599 2074 Berney Elementary School   Regular School No Elementary KG 05 2017   grade_5 51 0 15   0 2     0   5   42 31 0   0   0   34       4.0 73 51 0 15   0 2     0   5   42 31 0   0 0 34     4 73
631805 WA Walla Walla   school 5309390 36401   Waitsburg School District 530939001596 2712 Waitsburg Elementary School   Regular School No Elementary KG 05 2017   grade_5 17 0 6   0 0     0   1   13 11 0   0   0   14       0.0 24 17 0 6   0 0     0   1   13 11 0   0 0 14     0 24
631796 WA Walla Walla   school 5309390 36401   Waitsburg School District 530939002492 2174 Preston Hall Middle School   Regular School No Middle 06 08 2017   grade_5 0 0 0   0 0     0   1   1 0 0   0   0   1       0.0 1 0 0 0   0 0     0   1   1 0 0   0 0 1     0 1
631779 WA Grant   school 5309360 13073   Wahluke School District 530936002514 4490 Saddle Mountain Elementary   Regular School No Elementary KG 05 2017   grade_5 3 0 86   1 0     0   0   44 46 0   53   2   88       0.0 90 3 0 86   1 0     0   0   44 46 0   53 2 88     0 90
631772 WA Grant   school 5309360 13073   Wahluke School District 530936001890 4222 Morris Schott Elementary   Regular School No Elementary KG 05 2017   grade_5 1 0 60   0 0     0   0   35 26 0   49   3   61       1.0 61 1 0 60   0 0     0   0   35 26 0   49 3 61     1 61
631763 WA Grant   school 5309360 13073   Wahluke School District 530936001595 3152 Mattawa Elementary   Regular School No Elementary KG 05 2017   grade_5 3 0 58   1 0     0   0   26 36 0   26   2   61       1.0 62 3 0 58   1 0     0   0   26 36 0   26 2 61     1 62
631745 WA Wahkiakum   school 5309330 35200   Wahkiakum School District 530933001593 2893 Julius A Wendt Elementary/John C Thomas Middle School   Regular School No Elementary KG 08 2017   grade_5 34 0 1   1 0     0   3   17 22 0   4   0   26       1.0 39 34 0 1   1 0     0   3   17 22 0   4 0 26     1 39
631721 WA King   school 5309300 17402   Vashon Island School District 530930002720 1822 Family Link   Alternative School No Other KG 12 2017   grade_5 0 0 0   0 1     0   0   1 0 0   0   0   0       0.0 1 0 0 0   0 1     0   0   1 0 0   0 0 0     0 1
631708 WA King   school 5309300 17402   Vashon Island School District 530930001394 4468 Chautauqua Elementary   Regular School No Elementary PK 05 2017   grade_5 71 1 18   0 0     0   12   55 47 0   7   0   30       11.0 102 71 1 18   0 0     0   12   55 47 0   7 0 30     11 102
631700 WA Clark   school 5309270 6037   Vancouver School District 530927001587 3565 Washington Elementary   Regular School No Elementary KG 05 2017   grade_5 20 3 29   0 1     0   4   27 30 0   14   4   51       0.0 57 20 3 29   0 1     0   4   27 30 0   14 4 51     0 57
631693 WA Clark   school 5309270 6037   Vancouver School District 530927001586 2828 Walnut Grove Elementary   Regular School No Elementary KG 05 2017   grade_5 73 4 31   1 5     4   8   61 65 0   29   6   81       1.0 126 73 4 31   1 5     4   8   61 65 0   29 6 81     1 126
631657 WA Clark   school 5309270 6037   Vancouver School District 530927002943 3556 Vancouver Home Connection   Alternative School No Other KG 12 2017   grade_5 21 0 1   0 1     0   2   12 13 0   1   0   9       0.0 25 21 0 1   0 1     0   2   12 13 0   1 0 9     0 25
631632 WA Clark   school 5309270 6037   Vancouver School District 530927001583 3016 Sarah J Anderson Elementary   Regular School No Elementary KG 05 2017   grade_5 56 1 59   1 3     1   8   67 62 0   29   2   81       3.0 129 56 1 59   1 3     1   8   67 62 0   29 2 81     3 129
631625 WA Clark   school 5309270 6037   Vancouver School District 530927001582 2964 Salmon Creek Elementary   Regular School No Elementary KG 05 2017   grade_5 54 1 11   0 2     0   6   49 25 0   3   0   24       2.0 74 54 1 11   0 2     0   6   49 25 0   3 0 24     2 74
631618 WA Clark   school 5309270 6037   Vancouver School District 530927001581 4034 Sacajawea Elementary School   Regular School No Elementary KG 05 2017   grade_5 38 1 14   0 1     1   7   33 29 0   7   2   35       2.0 62 38 1 14   0 1     1   7   33 29 0   7 2 35     2 62
631611 WA Clark   school 5309270 6037   Vancouver School District 530927000638 4410 Roosevelt Elementary School   Regular School No Elementary KG 05 2017   grade_5 27 4 44   0 3     8   7   47 46 0   28   7   84       1.0 93 27 4 44   0 3     8   7   47 46 0   28 7 84     1 93
631604 WA Clark   school 5309270 6037   Vancouver School District 530927001580 2644 Peter S Ogden Elementary   Regular School No Elementary KG 05 2017   grade_5 36 2 36   0 5     5   7   49 42 0   24   3   76       1.0 91 36 2 36   0 5     5   7   49 42 0   24 3 76     1 91
631594 WA Clark   school 5309270 6037   Vancouver School District 530927001578 2723 Minnehaha Elementary School   Regular School No Elementary KG 05 2017   grade_5 54 3 21   0 3     3   5   48 41 0   13   3   64       2.0 89 54 3 21   0 3     3   5   48 41 0   13 3 64     2 89
631582 WA Clark   school 5309270 6037   Vancouver School District 530927001576 3734 Martin Luther King Elementary   Regular School No Elementary KG 05 2017   grade_5 22 2 40   0 2     4   8   28 50 0   18   3   66       1.0 78 22 2 40   0 2     4   8   28 50 0   18 3 66     1 78
631575 WA Clark   school 5309270 6037   Vancouver School District 530927001575 2318 Lincoln Elementary School   Regular School No Elementary KG 05 2017   grade_5 45 2 16   0 1     0   5   36 33 0   4   1   37       2.0 69 45 2 16   0 1     0   5   36 33 0   4 1 37     2 69
631563 WA Clark   school 5309270 6037   Vancouver School District 530927001572 3017 Lake Shore Elementary   Regular School No Elementary KG 05 2017   grade_5 63 2 9   0 4     1   3   54 28 0   5   0   20       5.0 82 63 2 9   0 4     1   3   54 28 0   5 0 20     5 82
631546 WA Clark   school 5309270 6037   Vancouver School District 530927001568 2610 Hough Elementary School   Regular School No Elementary KG 05 2017   grade_5 38 0 12   0 2     0   2   32 22 0   5   7   32       1.0 54 38 0 12   0 2     0   2   32 22 0   5 7 32     1 54
631539 WA Clark   school 5309270 6037   Vancouver School District 530927001566 2690 Hazel Dell Elementary School   Regular School No Elementary KG 05 2017   grade_5 43 1 34   0 2     1   10   46 45 0   14   5   67       5.0 91 43 1 34   0 2     1   10   46 45 0   14 5 67     5 91
631532 WA Clark   school 5309270 6037   Vancouver School District 530927001565 3735 Harry S Truman Elementary School   Regular School No Elementary KG 05 2017   grade_5 55 3 26   0 6     2   7   51 48 0   12   5   59       2.0 99 55 3 26   0 6     2   7   51 48 0   12 5 59     2 99
631524 WA Clark   school 5309270 6037   Vancouver School District 530927001564 2643 Harney Elementary School   Regular School No Elementary KG 05 2017   grade_5 46 3 55   0 1     3   4   50 62 0   21   1   70       5.0 112 46 3 55   0 1     3   4   50 62 0   21 1 70     5 112
631516 WA Clark   school 5309270 6037   Vancouver School District 530927001563 3424 George C Marshall Elementary   Regular School No Elementary KG 05 2017   grade_5 36 0 19   1 0     3   4   35 28 0   10   1   37       2.0 63 36 0 19   1 0     3   4   35 28 0   10 1 37     2 63
631503 WA Clark   school 5309270 6037   Vancouver School District 530927001561 2637 Fruit Valley Elementary School   Regular School No Elementary KG 05 2017   grade_5 19 2 30   1 0     2   4   25 33 0   24   4   51       1.0 58 19 2 30   1 0     2   4   25 33 0   24 4 51     1 58
631488 WA Clark   school 5309270 6037   Vancouver School District 530927002408 1574 Fir Grove Childrens Center   Special Education School No Other KG 12 2017   grade_5 4 0 1   0 0     0   0   3 2 0   0   0   5       0.0 5 4 0 1   0 0     0   0   3 2 0   0 0 5     0 5
631479 WA Clark   school 5309270 6037   Vancouver School District 530927001559 4075 Felida Elementary School   Regular School No Elementary KG 05 2017   grade_5 98 0 10   0 5     0   7   56 64 0   2   0   18       6.0 120 98 0 10   0 5     0   7   56 64 0   2 0 18     6 120
631470 WA Clark   school 5309270 6037   Vancouver School District 530927001558 3733 Dwight D Eisenhower Elementary   Regular School No Elementary KG 05 2017   grade_5 71 0 16   0 7     1   12   53 54 0   7   1   45       6.0 107 71 0 16   0 7     1   12   53 54 0   7 1 45     6 107
631454 WA Clark   school 5309270 6037   Vancouver School District 530927000572 4405 Chinook Elementary School   Regular School No Elementary KG 05 2017   grade_5 90 0 17   1 5     0   4   62 55 0   4   0   29       5.0 117 90 0 17   1 5     0   4   62 55 0   4 0 29     5 117
631447 WA Clark   school 5309270 6037   Vancouver School District 530927001556 3080 Benjamin Franklin Elementary   Regular School No Elementary KG 05 2017   grade_5 35 1 5   0 9     0   5   30 25 0   3   0   11       5.0 55 35 1 5   0 9     0   5   30 25 0   3 0 11     5 55

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