Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2017 · 1,245

grade

  • grade_2 · 1,245
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
632780 WA Yakima   school 5310170 39205   Zillah School District 531017001718 2783 Hilton Elementary School   Regular School No Elementary PK 03 2017   grade_2 35 0 53   4 0     0   6   53 45 0   18   1   58       0.0 98 35 0 53   4 0     0   6   53 45 0   18 1 58     0 98
632771 WA Thurston   school 5310140 34002   Yelm School District 531014001916 4224 Yelm Prairie Elementary   Regular School No Elementary PK 06 2017   grade_2 47 1 16   1 0     0   6   38 33 0   5   0   34       1.0 71 47 1 16   1 0     0   6   38 33 0   5 0 34     1 71
632747 WA Thurston   school 5310140 34002   Yelm School District 531014001715 3848 Southworth Elementary   Regular School No Elementary KG 06 2017   grade_2 57 0 21   10 0     1   12   62 39 0   7   2   43       5.0 101 57 0 21   10 0     1   12   62 39 0   7 2 43     5 101
632734 WA Thurston   school 5310140 34002   Yelm School District 531014001204 4451 Mill Pond Elementary School   Regular School No Elementary PK 06 2017   grade_2 57 2 9   0 3     3   5   42 37 0   3   2   31       4.0 79 57 2 9   0 3     3   5   42 37 0   3 2 31     4 79
632725 WA Thurston   school 5310140 34002   Yelm School District 531014001714 2260 McKenna Elementary   Regular School No Elementary KG 06 2017   grade_2 45 0 12   0 0     1   10   32 36 0   3   1   37       4.0 68 45 0 12   0 0     1   10   32 36 0   3 1 37     4 68
632716 WA Thurston   school 5310140 34002   Yelm School District 531014003016 5018 Lackamas Elementary   Regular School No Elementary KG 06 2017   grade_2 31 1 4   4 0     0   7   26 21 0   1   0   27       2.0 47 31 1 4   4 0     0   7   26 21 0   1 0 27     2 47
632707 WA Thurston   school 5310140 34002   Yelm School District 531014002393 4346 Fort Stevens Elementary   Regular School No Elementary PK 06 2017   grade_2 63 0 12   0 3     3   12   47 46 0   4   2   49       2.0 93 63 0 12   0 3     3   12   47 46 0   4 2 49     2 93
632679 WA Yakima   school 5310110 39007   Yakima School District 531011001709 3312 Whitney Elementary   Regular School No Elementary PK 05 2017   grade_2 29 1 61   0 1     1   2   34 61 0   28   2   73       0.0 95 29 1 61   0 1     1   2   34 61 0   28 2 73     0 95
632662 WA Yakima   school 5310110 39007   Yakima School District 531011001704 2529 Roosevelt Elementary School   Regular School No Elementary KG 05 2017   grade_2 15 0 64   1 1     0   5   46 40 0   35   3   72       1.0 86 15 0 64   1 1     0   5   46 40 0   35 3 72     1 86
632654 WA Yakima   school 5310110 39007   Yakima School District 531011001703 3264 Robertson Elementary   Regular School No Elementary KG 05 2017   grade_2 16 1 66   1 0     0   1   36 49 0   32   6   69       4.0 85 16 1 66   1 0     0   1   36 49 0   32 6 69     4 85
632642 WA Yakima   school 5310110 39007   Yakima School District 531011001687 2433 Ridgeview Elementary   Regular School No Elementary KG 05 2017   grade_2 22 3 87   2 0     0   0   53 61 0   52   9   99       1.0 114 22 3 87   2 0     0   0   53 61 0   52 9 99     1 114
632635 WA Yakima   school 5310110 39007   Yakima School District 531011001701 2819 Nob Hill Elementary School   Regular School No Elementary KG 05 2017   grade_2 36 0 41   1 0     0   3   36 45 0   15   3   47       2.0 81 36 0 41   1 0     0   3   36 45 0   15 3 47     2 81
632628 WA Yakima   school 5310110 39007   Yakima School District 531011001700 2177 Mckinley Elementary School   Regular School No Elementary KG 05 2017   grade_2 15 1 59   0 0     0   5   36 44 0   35   3   74       4.0 80 15 1 59   0 0     0   5   36 44 0   35 3 74     4 80
632620 WA Yakima   school 5310110 39007   Yakima School District 531011001699 2899 Mcclure Elementary School   Regular School No Elementary PK 05 2017   grade_2 25 0 66   0 0     0   1   45 47 0   37   2   74       1.0 92 25 0 66   0 0     0   1   45 47 0   37 2 74     1 92
632612 WA Yakima   school 5310110 39007   Yakima School District 531011001814 3817 Martin Luther King Jr Elementary   Regular School No Elementary KG 05 2017   grade_2 11 0 90   2 0     0   0   58 45 0   74   4   91       1.0 103 11 0 90   2 0     0   0   58 45 0   74 4 91     1 103
632593 WA Yakima   school 5310110 39007   Yakima School District 531011001694 2715 Hoover Elementary School   Regular School No Elementary PK 05 2017   grade_2 5 0 104   2 0     1   3   60 55 0   63   3   103       0.0 115 5 0 104   2 0     1   3   60 55 0   63 3 103     0 115
632585 WA Yakima   school 5310110 39007   Yakima School District 531011001693 2818 Gilbert Elementary School   Regular School No Elementary KG 05 2017   grade_2 21 2 70   2 1     0   3   48 51 0   36   2   84       5.0 99 21 2 70   2 1     0   3   48 51 0   36 2 84     5 99
632578 WA Yakima   school 5310110 39007   Yakima School District 531011001692 2176 Garfield Elementary School   Regular School No Elementary KG 05 2017   grade_2 6 1 74   0 0     0   1   37 45 0   60   4   80       2.0 82 6 1 74   0 0     0   1   37 45 0   60 4 80     2 82
632557 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2017   grade_2 11 0 15   0 0     0   2   14 14 0   5   0   12       1.0 28 11 0 15   0 0     0   2   14 14 0   5 0 12     1 28
632542 WA Yakima   school 5310110 39007   Yakima School District 531011001686 3138 Barge-Lincoln Elementary School   Regular School No Elementary PK 05 2017   grade_2 5 1 91   0 0     0   3   51 49 0   63   7   99       9.0 100 5 1 91   0 0     0   3   51 49 0   63 7 99     9 100
632534 WA Yakima   school 5310110 39007   Yakima School District 531011001685 2592 Adams Elementary School   Regular School No Elementary PK 05 2017   grade_2 5 0 108   1 0     0   0   59 55 0   86   6   110       1.0 114 5 0 108   1 0     0   0   59 55 0   86 6 110     1 114
632527 WA Cowlitz   school 5310050 8404   Woodland School District 531005001684 3513 Yale Elementary   Regular School No Elementary KG 05 2017   grade_2 8 0 1   0 0     0   0   6 3 0   0   0   2       0.0 9 8 0 1   0 0     0   0   6 3 0   0 0 2     0 9
632513 WA Cowlitz   school 5310050 8404   Woodland School District 531005003517 5408 Woodland Intermediate School (Closed after 2018-2019 school year)   Regular School No Elementary 02 04 2017   grade_2 87 2 36   0 5     0   3   74 59 0   26   2   66       0.0 133 87 2 36   0 5     0   3   74 59 0   26 2 66     0 133
632493 WA Cowlitz   school 5310050 8404   Woodland School District 531005003371 5246 Lewis River Academy   Alternative School No Other KG 12 2017   grade_2 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
632478 WA Klickitat   school 5310020 20094   Wishram School District 531002001680 2605 Wishram High And Elementary Schl   Regular School No Other PK 12 2017   grade_2 4 0 0   1 0     0   1   3 3 0   0   0   6       0.0 6 4 0 0   1 0     0   1   3 3 0   0 0 6     0 6
632464 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_2 11 0 0   0 0     0   0   4 7 0   0   0   10       0.0 11 11 0 0   0 0     0   0   4 7 0   0 0 10     0 11
632444 WA Lewis   school 5309930 21232   Winlock School District 530993001677 2290 Winlock Miller Elementary   Regular School No Elementary PK 05 2017   grade_2 34 0 19   0 0     0   3   35 22 0   14   7   50       0.0 57 34 0 19   0 0     0   3   35 22 0   14 7 50     0 57
632424 WA Grant   school 5309900 13167   Wilson Creek School District 530990001674 2472 Wilson Creek Elementary   Regular School No Elementary KG 06 2017   grade_2 8 0 3   0 0     0   1   6 6 0   1   0   5       0.0 12 8 0 3   0 0     0   1   6 6 0   1 0 5     0 12
632408 WA Pacific   school 5309870 25160   Willapa Valley School District 530987001672 3444 Willapa Elementary   Regular School No Elementary KG 05 2017   grade_2 24 0 2   0 0     0   0   15 11 0   0   0   12       1.0 26 24 0 2   0 0     0   0   15 11 0   0 0 12     1 26
632393 WA Lincoln   school 5309840 22200   Wilbur School District 530984001667 3290 Wilbur Elementary School   Regular School No Elementary KG 06 2017   grade_2 14 0 0   0 0     0   0   4 10 0   0   1   6       0.0 14 14 0 0   0 0     0   0   4 10 0   0 1 6     0 14
632375 WA Klickitat   school 5309810 20405   White Salmon Valley School District 530981001665 2997 Hulan L Whitson Elem   Regular School No Elementary KG 03 2017   grade_2 59 0 31   0 0     0   3   44 49 0   24   0   50       0.0 93 59 0 31   0 0     0   3   44 49 0   24 0 50     0 93
632360 WA Pierce   school 5309780 27416   White River School District 530978001894 4170 Wilkeson Elementary School   Regular School No Elementary KG 05 2017   grade_2 40 0 4   1 0     0   3   27 21 0   0   0   20       0.0 48 40 0 4   1 0     0   3   27 21 0   0 0 20     0 48
632337 WA Pierce   school 5309780 27416   White River School District 530978001720 4471 Mountain Meadow Elementary   Regular School No Elementary PK 05 2017   grade_2 66 4 10   1 0     0   6   43 44 0   4   0   22       6.0 87 66 4 10   1 0     0   6   43 44 0   4 0 22     6 87
632324 WA Pierce   school 5309780 27416   White River School District 530978002245 4309 Foothills Elementary   Regular School No Elementary KG 05 2017   grade_2 77 3 15   0 2     0   4   45 56 0   8   1   44       3.0 101 77 3 15   0 2     0   4   45 56 0   8 1 44     3 101
632315 WA Pierce   school 5309780 27416   White River School District 530978001661 2190 Elk Ridge Elementary   Regular School No Elementary KG 05 2017   grade_2 48 0 3   0 0     0   6   25 32 0   2   0   14       1.0 57 48 0 3   0 0     0   6   25 32 0   2 0 14     1 57
632299 WA Lewis   school 5309750 21303   White Pass School District 530975001658 3555 White Pass Elementary School   Regular School No Elementary KG 06 2017   grade_2 26 0 4   0 0     0   0   13 17 0   0   4   26       0.0 30 26 0 4   0 0     0   0   13 17 0   0 4 26     0 30
632289 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001655 2505 Wide Hollow Elementary   Regular School No Elementary KG 04 2017   grade_2 42 0 26   2 2     0   4   39 37 0   7   0   53       0.0 76 42 0 26   2 2     0   4   39 37 0   7 0 53     0 76
632264 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001652 3207 Summitview Elementary   Regular School No Elementary KG 04 2017   grade_2 36 0 29   0 0     0   5   30 40 0   10   0   37       1.0 70 36 0 29   0 0     0   5   30 40 0   10 0 37     1 70
632257 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001651 2758 Mountainview Elementary   Regular School No Elementary KG 04 2017   grade_2 20 0 16   0 0     0   1   20 17 0   9   0   31       0.0 37 20 0 16   0 0     0   1   20 17 0   9 0 31     0 37
632249 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001238 4448 Cottonwood Elementary School   Regular School No Elementary KG 04 2017   grade_2 63 1 27   0 6     0   1   46 52 0   11   1   30       0.0 98 63 1 27   0 6     0   1   46 52 0   11 1 30     0 98
632241 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001650 3699 Apple Valley Elementary   Regular School No Elementary KG 04 2017   grade_2 43 2 20   0 1     0   4   33 37 0   5   1   26       1.0 70 43 2 20   0 1     0   4   33 37 0   5 1 26     1 70
632233 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001649 2822 Ahtanum Valley Elementary   Regular School No Elementary KG 04 2017   grade_2 27 1 17   1 0     0   4   22 28 0   5   0   30       0.0 50 27 1 17   1 0     0   4   22 28 0   5 0 30     0 50
632204 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969002419 2956 Seth Woodard Elementary   Regular School No Elementary KG 05 2017   grade_2 35 0 4   0 0     1   4   28 16 0   2   1   26       2.0 44 35 0 4   0 0     1   4   28 16 0   2 1 26     2 44
632198 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001646 3194 Pasadena Park Elementary   Regular School No Elementary KG 05 2017   grade_2 47 1 4   0 3     0   5   28 32 0   4   0   25       0.0 60 47 1 4   0 3     0   5   28 32 0   4 0 25     0 60
632192 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001644 3129 Orchard Center Elementary   Regular School No Elementary KG 05 2017   grade_2 41 1 6   1 0     0   3   28 24 0   1   0   30       0.0 52 41 1 6   1 0     0   3   28 24 0   1 0 30     0 52
632186 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001641 3196 Ness Elementary   Regular School No Elementary KG 05 2017   grade_2 46 2 3   1 0     0   1   33 20 0   1   2   38       1.0 53 46 2 3   1 0     0   1   33 20 0   1 2 38     1 53
632151 WA Chelan   school 5309660 4246   Wenatchee School District 530966001638 2907 Washington Elementary School   Regular School No Elementary KG 05 2017   grade_2 56 2 32   0 1     0   1   47 45 0   23   0   47       1.0 92 56 2 32   0 1     0   1   47 45 0   23 0 47     1 92
632139 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_2 16 0 3   0 1     0   0   8 12 0   0   0   3       1.0 20 16 0 3   0 1     0   0   8 12 0   0 0 3     1 20
632131 WA Chelan   school 5309660 4246   Wenatchee School District 530966001637 3208 Sunnyslope Elementary School   Regular School No Elementary KG 05 2017   grade_2 37 0 10   0 2     0   1   26 24 0   9   0   14       1.0 50 37 0 10   0 2     0   1   26 24 0   9 0 14     1 50
632106 WA Chelan   school 5309660 4246   Wenatchee School District 530966001633 2347 Mission View Elementary School   Regular School No Elementary KG 05 2017   grade_2 26 0 61   0 0     0   1   48 40 0   51   7   73       6.0 88 26 0 61   0 0     0   1   48 40 0   51 7 73     6 88
632099 WA Chelan   school 5309660 4246   Wenatchee School District 530966001631 2279 Lewis And Clark Elementary Sch   Regular School No Elementary KG 05 2017   grade_2 25 0 58   0 0     0   1   52 32 0   45   6   68       4.0 84 25 0 58   0 0     0   1   52 32 0   45 6 68     4 84
632091 WA Chelan   school 5309660 4246   Wenatchee School District 530966000991 4423 John Newbery Elementary   Regular School No Elementary KG 05 2017   grade_2 46 0 31   0 0     0   1   39 39 0   29   7   46       3.0 78 46 0 31   0 0     0   1   39 39 0   29 7 46     3 78
632079 WA Chelan   school 5309660 4246   Wenatchee School District 530966001630 2301 Columbia Elementary School   Regular School No Elementary KG 05 2017   grade_2 23 0 60   0 0     0   1   40 44 0   51   5   74       1.0 84 23 0 60   0 0     0   1   40 44 0   51 5 74     1 84
632067 WA Chelan   school 5309660 4246   Wenatchee School District 530966001632 3209 Abraham Lincoln Elementary   Regular School No Elementary KG 05 2017   grade_2 19 1 64   0 0     0   1   46 39 0   46   15   65       1.0 85 19 1 64   0 0     0   1   46 39 0   46 15 65     1 85
632047 WA Stevens   school 5309630 33049   Wellpinit School District #49 530963003146 2549 Wellpinit Elementary School   Regular School No Elementary KG 05 2017   grade_2 2 0 0   32 0     0   6   22 18 0   16   10   38       0.0 40 2 0 0   32 0     0   6   22 18 0   16 10 38     0 40
632023 WA Douglas   school 5309600 9209   Waterville School District 530960002192 2161 Waterville Elementary   Regular School No Elementary KG 05 2017   grade_2 20 0 2   1 0     0   1   10 14 0   2   0   18       2.0 24 20 0 2   1 0     0   1   10 14 0   2 0 18     2 24
632011 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other KG 12 2017   grade_2 3 0 0   0 0     0   0   1 2 0   0   0   3       0.0 3 3 0 0   0 0     0   0   1 2 0   0 0 3     0 3
631989 WA Clark   school 5309540 6112   Washougal School District 530954001622 2509 Hathaway Elementary   Regular School No Elementary KG 05 2017   grade_2 48 0 10   1 0     0   4   36 27 0   5   7   45       2.0 63 48 0 10   1 0     0   4   36 27 0   5 7 45     2 63
631982 WA Clark   school 5309540 6112   Washougal School District 530954001623 2911 Gause Elementary   Regular School No Elementary KG 05 2017   grade_2 78 1 19   0 0     0   11   67 42 0   5   3   41       5.0 109 78 1 19   0 0     0   11   67 42 0   5 3 41     5 109
631971 WA Clark   school 5309540 6112   Washougal School District 530954001621 3270 Cape Horn Skye Elementary   Regular School No Elementary KG 05 2017   grade_2 65 1 4   1 1     0   1   40 33 0   4   3   20       2.0 73 65 1 4   1 1     0   1   40 33 0   4 3 20     2 73
631950 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_2 3 0 2   0 0     0   0   3 2 0   0   0   4       0.0 5 3 0 2   0 0     0   0   3 2 0   0 0 4     0 5
631929 WA Grant   school 5309510 13146   Warden School District 530951001618 2792 Warden Elementary   Regular School No Elementary PK 05 2017   grade_2 17 1 60   0 0     0   1   45 34 0   42   14   72       1.0 79 17 1 60   0 0     0   1   45 34 0   42 14 72     1 79
631913 WA Yakima   school 5309480 39207   Wapato School District 530948001616 2757 Satus Elementary   Regular School No Elementary PK 05 2017   grade_2 0 0 81   15 0     0   0   51 45 0   46   7   95       2.0 96 0 0 81   15 0     0   0   51 45 0   46 7 95     2 96
631901 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_2 1 0 72   26 2     0   1   57 45 0   49   7   98       0.0 102 1 0 72   26 2     0   1   57 45 0   49 7 98     0 102
631893 WA Yakima   school 5309480 39207   Wapato School District 530948002611 4518 Adams Elementary   Regular School No Elementary PK 05 2017   grade_2 2 0 28   8 1     0   0   24 15 0   16   4   39       0.0 39 2 0 28   8 1     0   0   24 15 0   16 4 39     0 39
631878 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001608 3728 Sharpstein Elementary School   Regular School No Elementary KG 05 2017   grade_2 31 0 38   0 0     0   3   39 33 0   26   3   48       4.0 72 31 0 38   0 0     0   3   39 33 0   26 3 48     4 72
631869 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001606 2159 Prospect Point Elementary   Regular School No Elementary KG 05 2017   grade_2 62 1 14   0 1     0   1   39 40 0   7   1   27       2.0 79 62 1 14   0 1     0   1   39 40 0   7 1 27     2 79
631848 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001602 2078 Green Park Elementary School   Regular School No Elementary KG 05 2017   grade_2 38 0 31   1 1     0   3   38 36 0   15   1   48       1.0 74 38 0 31   1 1     0   3   38 36 0   15 1 48     1 74
631837 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001600 2528 Edison Elementary School   Regular School No Elementary KG 05 2017   grade_2 35 1 44   0 0     0   0   35 45 0   23   2   57       1.0 80 35 1 44   0 0     0   0   35 45 0   23 2 57     1 80
631829 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001891 4193 Blue Ridge Elementary   Regular School No Elementary PK 05 2017   grade_2 7 1 42   0 0     0   2   23 29 0   28   1   49       0.0 52 7 1 42   0 0     0   2   23 29 0   28 1 49     0 52
631821 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001599 2074 Berney Elementary School   Regular School No Elementary KG 05 2017   grade_2 48 1 13   0 0     0   8   35 35 0   2   1   30       2.0 70 48 1 13   0 0     0   8   35 35 0   2 1 30     2 70
631802 WA Walla Walla   school 5309390 36401   Waitsburg School District 530939001596 2712 Waitsburg Elementary School   Regular School No Elementary KG 05 2017   grade_2 19 0 4   0 0     0   1   15 9 0   1   0   13       0.0 24 19 0 4   0 0     0   1   15 9 0   1 0 13     0 24
631776 WA Grant   school 5309360 13073   Wahluke School District 530936002514 4490 Saddle Mountain Elementary   Regular School No Elementary KG 05 2017   grade_2 4 0 72   0 0     0   0   42 34 0   63   3   72       1.0 76 4 0 72   0 0     0   0   42 34 0   63 3 72     1 76
631769 WA Grant   school 5309360 13073   Wahluke School District 530936001890 4222 Morris Schott Elementary   Regular School No Elementary KG 05 2017   grade_2 0 0 40   0 0     0   0   22 18 0   36   2   40       0.0 40 0 0 40   0 0     0   0   22 18 0   36 2 40     0 40
631760 WA Grant   school 5309360 13073   Wahluke School District 530936001595 3152 Mattawa Elementary   Regular School No Elementary KG 05 2017   grade_2 5 0 66   2 0     0   0   37 36 0   52   3   73       1.0 73 5 0 66   2 0     0   0   37 36 0   52 3 73     1 73
631742 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_2 27 0 4   0 0     0   1   17 15 0   3   3   26       0.0 32 27 0 4   0 0     0   1   17 15 0   3 3 26     0 32
631718 WA King   school 5309300 17402   Vashon Island School District 530930002720 1822 Family Link   Alternative School No Other KG 12 2017   grade_2 7 0 0   0 0     0   0   3 4 0   0   0   2       1.0 7 7 0 0   0 0     0   0   3 4 0   0 0 2     1 7
631705 WA King   school 5309300 17402   Vashon Island School District 530930001394 4468 Chautauqua Elementary   Regular School No Elementary PK 05 2017   grade_2 62 0 18   0 1     0   13   48 46 0   8   0   30       4.0 94 62 0 18   0 1     0   13   48 46 0   8 0 30     4 94
631697 WA Clark   school 5309270 6037   Vancouver School District 530927001587 3565 Washington Elementary   Regular School No Elementary KG 05 2017   grade_2 25 0 34   1 0     1   6   36 31 0   25   8   59       1.0 67 25 0 34   1 0     1   6   36 31 0   25 8 59     1 67
631690 WA Clark   school 5309270 6037   Vancouver School District 530927001586 2828 Walnut Grove Elementary   Regular School No Elementary KG 05 2017   grade_2 78 3 37   0 10     0   7   71 64 0   51   2   95       1.0 135 78 3 37   0 10     0   7   71 64 0   51 2 95     1 135
631654 WA Clark   school 5309270 6037   Vancouver School District 530927002943 3556 Vancouver Home Connection   Alternative School No Other KG 12 2017   grade_2 14 0 2   0 0     0   1   8 9 0   4   0   2       0.0 17 14 0 2   0 0     0   1   8 9 0   4 0 2     0 17
631629 WA Clark   school 5309270 6037   Vancouver School District 530927001583 3016 Sarah J Anderson Elementary   Regular School No Elementary KG 05 2017   grade_2 74 4 57   1 5     0   6   75 72 0   39   6   86       2.0 147 74 4 57   1 5     0   6   75 72 0   39 6 86     2 147
631622 WA Clark   school 5309270 6037   Vancouver School District 530927001582 2964 Salmon Creek Elementary   Regular School No Elementary KG 05 2017   grade_2 63 3 10   0 2     0   6   37 47 0   6   4   30       1.0 84 63 3 10   0 2     0   6   37 47 0   6 4 30     1 84
631615 WA Clark   school 5309270 6037   Vancouver School District 530927001581 4034 Sacajawea Elementary School   Regular School No Elementary KG 05 2017   grade_2 56 2 15   0 0     0   7   41 39 0   11   3   40       0.0 80 56 2 15   0 0     0   7   41 39 0   11 3 40     0 80
631608 WA Clark   school 5309270 6037   Vancouver School District 530927000638 4410 Roosevelt Elementary School   Regular School No Elementary KG 05 2017   grade_2 29 1 58   0 5     7   9   47 62 0   48   10   91       1.0 109 29 1 58   0 5     7   9   47 62 0   48 10 91     1 109
631601 WA Clark   school 5309270 6037   Vancouver School District 530927001580 2644 Peter S Ogden Elementary   Regular School No Elementary KG 05 2017   grade_2 38 1 25   1 0     3   12   41 39 0   28   6   58       0.0 80 38 1 25   1 0     3   12   41 39 0   28 6 58     0 80
631591 WA Clark   school 5309270 6037   Vancouver School District 530927001578 2723 Minnehaha Elementary School   Regular School No Elementary KG 05 2017   grade_2 62 0 22   0 4     1   5   44 50 0   25   3   64       0.0 94 62 0 22   0 4     1   5   44 50 0   25 3 64     0 94
631579 WA Clark   school 5309270 6037   Vancouver School District 530927001576 3734 Martin Luther King Elementary   Regular School No Elementary KG 05 2017   grade_2 26 6 42   0 5     4   9   47 45 0   26   10   82       2.0 92 26 6 42   0 5     4   9   47 45 0   26 10 82     2 92
631572 WA Clark   school 5309270 6037   Vancouver School District 530927001575 2318 Lincoln Elementary School   Regular School No Elementary KG 05 2017   grade_2 24 1 20   0 1     0   6   31 21 0   11   2   32       1.0 52 24 1 20   0 1     0   6   31 21 0   11 2 32     1 52
631560 WA Clark   school 5309270 6037   Vancouver School District 530927001572 3017 Lake Shore Elementary   Regular School No Elementary KG 05 2017   grade_2 69 0 13   0 0     0   8   53 37 0   10   4   29       0.0 90 69 0 13   0 0     0   8   53 37 0   10 4 29     0 90
631543 WA Clark   school 5309270 6037   Vancouver School District 530927001568 2610 Hough Elementary School   Regular School No Elementary KG 05 2017   grade_2 36 1 8   0 2     0   7   19 35 0   3   6   32       0.0 54 36 1 8   0 2     0   7   19 35 0   3 6 32     0 54
631536 WA Clark   school 5309270 6037   Vancouver School District 530927001566 2690 Hazel Dell Elementary School   Regular School No Elementary KG 05 2017   grade_2 52 2 29   0 0     0   6   54 35 0   15   0   66       3.0 89 52 2 29   0 0     0   6   54 35 0   15 0 66     3 89
631529 WA Clark   school 5309270 6037   Vancouver School District 530927001565 3735 Harry S Truman Elementary School   Regular School No Elementary KG 05 2017   grade_2 60 5 25   0 4     2   13   52 57 0   18   8   64       0.0 109 60 5 25   0 4     2   13   52 57 0   18 8 64     0 109
631521 WA Clark   school 5309270 6037   Vancouver School District 530927001564 2643 Harney Elementary School   Regular School No Elementary KG 05 2017   grade_2 38 2 43   2 0     2   11   48 50 0   27   5   68       0.0 98 38 2 43   2 0     2   11   48 50 0   27 5 68     0 98
631513 WA Clark   school 5309270 6037   Vancouver School District 530927001563 3424 George C Marshall Elementary   Regular School No Elementary KG 05 2017   grade_2 40 2 22   1 0     3   4   34 38 0   19   3   53       2.0 72 40 2 22   1 0     3   4   34 38 0   19 3 53     2 72
631500 WA Clark   school 5309270 6037   Vancouver School District 530927001561 2637 Fruit Valley Elementary School   Regular School No Elementary KG 05 2017   grade_2 16 2 20   0 1     2   5   21 25 0   20   5   38       1.0 46 16 2 20   0 1     2   5   21 25 0   20 5 38     1 46
631485 WA Clark   school 5309270 6037   Vancouver School District 530927002408 1574 Fir Grove Childrens Center   Special Education School No Other KG 12 2017   grade_2 3 0 0   0 0     0   0   2 1 0   0   0   3       0.0 3 3 0 0   0 0     0   0   2 1 0   0 0 3     0 3
631476 WA Clark   school 5309270 6037   Vancouver School District 530927001559 4075 Felida Elementary School   Regular School No Elementary KG 05 2017   grade_2 85 1 12   0 3     1   9   55 56 0   4   1   23       1.0 111 85 1 12   0 3     1   9   55 56 0   4 1 23     1 111
631467 WA Clark   school 5309270 6037   Vancouver School District 530927001558 3733 Dwight D Eisenhower Elementary   Regular School No Elementary KG 05 2017   grade_2 59 1 16   0 4     1   7   44 44 0   8   5   42       2.0 88 59 1 16   0 4     1   7   44 44 0   8 5 42     2 88
631451 WA Clark   school 5309270 6037   Vancouver School District 530927000572 4405 Chinook Elementary School   Regular School No Elementary KG 05 2017   grade_2 97 1 9   1 3     0   11   64 58 0   9   1   29       1.0 122 97 1 9   1 3     0   11   64 58 0   9 1 29     1 122

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