Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2017 · 1,244

grade

  • grade_4 · 1,244
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
632791 WA Yakima   school 5310170 39205   Zillah School District 531017001896 4221 Zillah Intermediate School   Regular School No Elementary 04 06 2017   grade_4 32 0 52   5 1     0   4   50 44 0   11   1   62       0.0 94 32 0 52   5 1     0   4   50 44 0   11 1 62     0 94
632773 WA Thurston   school 5310140 34002   Yelm School District 531014001916 4224 Yelm Prairie Elementary   Regular School No Elementary PK 06 2017   grade_4 61 1 16   2 0     0   5   55 30 0   7   0   41       2.0 85 61 1 16   2 0     0   5   55 30 0   7 0 41     2 85
632749 WA Thurston   school 5310140 34002   Yelm School District 531014001715 3848 Southworth Elementary   Regular School No Elementary KG 06 2017   grade_4 56 3 18   3 2     3   9   53 41 0   1   0   42       2.0 94 56 3 18   3 2     3   9   53 41 0   1 0 42     2 94
632736 WA Thurston   school 5310140 34002   Yelm School District 531014001204 4451 Mill Pond Elementary School   Regular School No Elementary PK 06 2017   grade_4 44 0 12   2 3     1   13   41 34 0   1   1   30       7.0 75 44 0 12   2 3     1   13   41 34 0   1 1 30     7 75
632727 WA Thurston   school 5310140 34002   Yelm School District 531014001714 2260 McKenna Elementary   Regular School No Elementary KG 06 2017   grade_4 55 0 5   0 0     0   8   35 33 0   1   0   37       2.0 68 55 0 5   0 0     0   8   35 33 0   1 0 37     2 68
632718 WA Thurston   school 5310140 34002   Yelm School District 531014003016 5018 Lackamas Elementary   Regular School No Elementary KG 06 2017   grade_4 40 0 3   1 1     0   6   25 26 0   0   0   21       7.0 51 40 0 3   1 1     0   6   25 26 0   0 0 21     7 51
632709 WA Thurston   school 5310140 34002   Yelm School District 531014002393 4346 Fort Stevens Elementary   Regular School No Elementary PK 06 2017   grade_4 59 0 14   0 2     0   12   50 37 0   2   1   53       6.0 87 59 0 14   0 2     0   12   50 37 0   2 1 53     6 87
632681 WA Yakima   school 5310110 39007   Yakima School District 531011001709 3312 Whitney Elementary   Regular School No Elementary PK 05 2017   grade_4 25 2 74   0 2     1   1   57 48 0   28   4   77       0.0 105 25 2 74   0 2     1   1   57 48 0   28 4 77     0 105
632664 WA Yakima   school 5310110 39007   Yakima School District 531011001704 2529 Roosevelt Elementary School   Regular School No Elementary KG 05 2017   grade_4 12 1 71   1 1     0   6   47 45 0   30   3   77       3.0 92 12 1 71   1 1     0   6   47 45 0   30 3 77     3 92
632656 WA Yakima   school 5310110 39007   Yakima School District 531011001703 3264 Robertson Elementary   Regular School No Elementary KG 05 2017   grade_4 16 0 63   1 0     0   1   35 46 0   29   8   73       2.0 81 16 0 63   1 0     0   1   35 46 0   29 8 73     2 81
632644 WA Yakima   school 5310110 39007   Yakima School District 531011001687 2433 Ridgeview Elementary   Regular School No Elementary KG 05 2017   grade_4 22 0 76   0 0     0   2   55 45 0   43   3   88       3.0 100 22 0 76   0 0     0   2   55 45 0   43 3 88     3 100
632637 WA Yakima   school 5310110 39007   Yakima School District 531011001701 2819 Nob Hill Elementary School   Regular School No Elementary KG 05 2017   grade_4 40 0 38   0 0     0   2   44 36 0   13   6   49       5.0 80 40 0 38   0 0     0   2   44 36 0   13 6 49     5 80
632630 WA Yakima   school 5310110 39007   Yakima School District 531011001700 2177 Mckinley Elementary School   Regular School No Elementary KG 05 2017   grade_4 14 1 61   1 0     0   4   42 39 0   38   3   77       2.0 81 14 1 61   1 0     0   4   42 39 0   38 3 77     2 81
632622 WA Yakima   school 5310110 39007   Yakima School District 531011001699 2899 Mcclure Elementary School   Regular School No Elementary PK 05 2017   grade_4 25 1 64   0 0     0   2   51 41 0   25   3   76       7.0 92 25 1 64   0 0     0   2   51 41 0   25 3 76     7 92
632614 WA Yakima   school 5310110 39007   Yakima School District 531011001814 3817 Martin Luther King Jr Elementary   Regular School No Elementary KG 05 2017   grade_4 2 0 111   0 0     0   1   57 57 0   62   4   106       0.0 114 2 0 111   0 0     0   1   57 57 0   62 4 106     0 114
632595 WA Yakima   school 5310110 39007   Yakima School District 531011001694 2715 Hoover Elementary School   Regular School No Elementary PK 05 2017   grade_4 7 2 83   0 1     0   0   53 40 0   50   2   92       3.0 93 7 2 83   0 1     0   0   53 40 0   50 2 92     3 93
632587 WA Yakima   school 5310110 39007   Yakima School District 531011001693 2818 Gilbert Elementary School   Regular School No Elementary KG 05 2017   grade_4 29 0 73   3 1     0   1   60 47 0   32   2   84       11.0 107 29 0 73   3 1     0   1   60 47 0   32 2 84     11 107
632580 WA Yakima   school 5310110 39007   Yakima School District 531011001692 2176 Garfield Elementary School   Regular School No Elementary KG 05 2017   grade_4 5 0 84   0 0     1   1   53 38 0   66   1   91       1.0 91 5 0 84   0 0     1   1   53 38 0   66 1 91     1 91
632559 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2017   grade_4 9 1 16   1 0     0   1   13 15 0   10   1   17       1.0 28 9 1 16   1 0     0   1   13 15 0   10 1 17     1 28
632544 WA Yakima   school 5310110 39007   Yakima School District 531011001686 3138 Barge-Lincoln Elementary School   Regular School No Elementary PK 05 2017   grade_4 3 0 88   2 0     0   0   43 50 0   61   7   91       10.0 93 3 0 88   2 0     0   0   43 50 0   61 7 91     10 93
632536 WA Yakima   school 5310110 39007   Yakima School District 531011001685 2592 Adams Elementary School   Regular School No Elementary PK 05 2017   grade_4 6 1 142   0 0     0   0   75 74 0   90   6   144       3.0 149 6 1 142   0 0     0   0   75 74 0   90 6 144     3 149
632529 WA Cowlitz   school 5310050 8404   Woodland School District 531005001684 3513 Yale Elementary   Regular School No Elementary KG 05 2017   grade_4 5 0 0   0 0     0   0   5 0 0   0   0   2       1.0 5 5 0 0   0 0     0   0   5 0 0   0 0 2     1 5
632515 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_4 133 0 48   3 2     0   4   98 92 0   22   11   104       3.0 190 133 0 48   3 2     0   4   98 92 0   22 11 104     3 190
632495 WA Cowlitz   school 5310050 8404   Woodland School District 531005003371 5246 Lewis River Academy   Alternative School No Other KG 12 2017   grade_4 4 0 1   0 0     0   0   3 2 0   0   0   3       0.0 5 4 0 1   0 0     0   0   3 2 0   0 0 3     0 5
632480 WA Klickitat   school 5310020 20094   Wishram School District 531002001680 2605 Wishram High And Elementary Schl   Regular School No Other PK 12 2017   grade_4 3 0 0   0 0     0   0   1 2 0   0   0   3       1.0 3 3 0 0   0 0     0   0   1 2 0   0 0 3     1 3
632466 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_4 10 0 0   0 0     0   0   5 5 0   0   0   4       0.0 10 10 0 0   0 0     0   0   5 5 0   0 0 4     0 10
632446 WA Lewis   school 5309930 21232   Winlock School District 530993001677 2290 Winlock Miller Elementary   Regular School No Elementary PK 05 2017   grade_4 27 0 11   0 0     0   3   18 23 0   6   2   36       0.0 41 27 0 11   0 0     0   3   18 23 0   6 2 36     0 41
632426 WA Grant   school 5309900 13167   Wilson Creek School District 530990001674 2472 Wilson Creek Elementary   Regular School No Elementary KG 06 2017   grade_4 10 0 5   0 0     0   0   4 11 0   1   0   7       1.0 15 10 0 5   0 0     0   0   4 11 0   1 0 7     1 15
632410 WA Pacific   school 5309870 25160   Willapa Valley School District 530987001672 3444 Willapa Elementary   Regular School No Elementary KG 05 2017   grade_4 20 0 7   0 0     0   0   14 13 0   2   0   18       0.0 27 20 0 7   0 0     0   0   14 13 0   2 0 18     0 27
632395 WA Lincoln   school 5309840 22200   Wilbur School District 530984001667 3290 Wilbur Elementary School   Regular School No Elementary KG 06 2017   grade_4 11 1 1   1 0     0   5   14 5 0   0   0   9       0.0 19 11 1 1   1 0     0   5   14 5 0   0 0 9     0 19
632381 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_4 72 0 30   2 1     0   6   63 48 0   21   1   58       0.0 111 72 0 30   2 1     0   6   63 48 0   21 1 58     0 111
632362 WA Pierce   school 5309780 27416   White River School District 530978001894 4170 Wilkeson Elementary School   Regular School No Elementary KG 05 2017   grade_4 33 0 4   0 0     0   2   22 17 0   0   1   9       1.0 39 33 0 4   0 0     0   2   22 17 0   0 1 9     1 39
632339 WA Pierce   school 5309780 27416   White River School District 530978001720 4471 Mountain Meadow Elementary   Regular School No Elementary PK 05 2017   grade_4 64 1 8   1 1     0   6   42 39 0   2   3   30       2.0 81 64 1 8   1 1     0   6   42 39 0   2 3 30     2 81
632326 WA Pierce   school 5309780 27416   White River School District 530978002245 4309 Foothills Elementary   Regular School No Elementary KG 05 2017   grade_4 73 2 7   1 0     0   1   50 34 0   3   1   34       2.0 84 73 2 7   1 0     0   1   50 34 0   3 1 34     2 84
632317 WA Pierce   school 5309780 27416   White River School District 530978001661 2190 Elk Ridge Elementary   Regular School No Elementary KG 05 2017   grade_4 51 0 4   0 0     0   4   28 31 0   1   2   20       1.0 59 51 0 4   0 0     0   4   28 31 0   1 2 20     1 59
632301 WA Lewis   school 5309750 21303   White Pass School District 530975001658 3555 White Pass Elementary School   Regular School No Elementary KG 06 2017   grade_4 23 1 2   0 0     0   0   10 16 0   0   3   17       0.0 26 23 1 2   0 0     0   0   10 16 0   0 3 17     0 26
632291 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001655 2505 Wide Hollow Elementary   Regular School No Elementary KG 04 2017   grade_4 29 2 34   0 6     0   3   34 40 0   7   2   18       1.0 74 29 2 34   0 6     0   3   34 40 0   7 2 18     1 74
632266 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001652 3207 Summitview Elementary   Regular School No Elementary KG 04 2017   grade_4 32 1 30   0 1     0   4   30 38 0   14   0   18       0.0 68 32 1 30   0 1     0   4   30 38 0   14 0 18     0 68
632259 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001651 2758 Mountainview Elementary   Regular School No Elementary KG 04 2017   grade_4 27 0 14   1 0     0   2   22 22 0   5   1   17       1.0 44 27 0 14   1 0     0   2   22 22 0   5 1 17     1 44
632251 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001238 4448 Cottonwood Elementary School   Regular School No Elementary KG 04 2017   grade_4 58 2 17   1 3     0   2   45 38 0   4   0   11       0.0 83 58 2 17   1 3     0   2   45 38 0   4 0 11     0 83
632243 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001650 3699 Apple Valley Elementary   Regular School No Elementary KG 04 2017   grade_4 46 1 20   2 4     0   2   33 42 0   5   0   14       1.0 75 46 1 20   2 4     0   2   33 42 0   5 0 14     1 75
632235 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972001649 2822 Ahtanum Valley Elementary   Regular School No Elementary KG 04 2017   grade_4 30 0 16   1 0     0   2   29 20 0   5   0   11       0.0 49 30 0 16   1 0     0   2   29 20 0   5 0 11     0 49
632206 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969002419 2956 Seth Woodard Elementary   Regular School No Elementary KG 05 2017   grade_4 45 0 6   0 3     1   3   32 26 0   1   0   32       0.0 58 45 0 6   0 3     1   3   32 26 0   1 0 32     0 58
632200 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001646 3194 Pasadena Park Elementary   Regular School No Elementary KG 05 2017   grade_4 68 1 4   0 1     0   5   46 33 0   5   0   26       0.0 79 68 1 4   0 1     0   5   46 33 0   5 0 26     0 79
632194 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001644 3129 Orchard Center Elementary   Regular School No Elementary KG 05 2017   grade_4 46 2 3   0 0     1   11   37 26 0   2   1   47       2.0 63 46 2 3   0 0     1   11   37 26 0   2 1 47     2 63
632188 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001641 3196 Ness Elementary   Regular School No Elementary KG 05 2017   grade_4 53 1 3   0 0     0   1   33 25 0   1   2   42       0.0 58 53 1 3   0 0     0   1   33 25 0   1 2 42     0 58
632153 WA Chelan   school 5309660 4246   Wenatchee School District 530966001638 2907 Washington Elementary School   Regular School No Elementary KG 05 2017   grade_4 53 1 34   0 1     0   6   53 42 0   16   1   41       8.0 95 53 1 34   0 1     0   6   53 42 0   16 1 41     8 95
632141 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_4 19 0 2   0 0     0   0   10 11 0   0   0   3       2.0 21 19 0 2   0 0     0   0   10 11 0   0 0 3     2 21
632133 WA Chelan   school 5309660 4246   Wenatchee School District 530966001637 3208 Sunnyslope Elementary School   Regular School No Elementary KG 05 2017   grade_4 39 0 12   0 0     0   2   21 32 0   2   1   12       5.0 53 39 0 12   0 0     0   2   21 32 0   2 1 12     5 53
632108 WA Chelan   school 5309660 4246   Wenatchee School District 530966001633 2347 Mission View Elementary School   Regular School No Elementary KG 05 2017   grade_4 18 0 58   0 0     0   0   47 29 0   40   7   60       4.0 76 18 0 58   0 0     0   0   47 29 0   40 7 60     4 76
632101 WA Chelan   school 5309660 4246   Wenatchee School District 530966001631 2279 Lewis And Clark Elementary Sch   Regular School No Elementary KG 05 2017   grade_4 20 0 51   0 0     0   0   34 37 0   27   5   52       5.0 71 20 0 51   0 0     0   0   34 37 0   27 5 52     5 71
632093 WA Chelan   school 5309660 4246   Wenatchee School District 530966000991 4423 John Newbery Elementary   Regular School No Elementary KG 05 2017   grade_4 56 0 31   1 1     0   3   53 39 0   26   4   50       8.0 92 56 0 31   1 1     0   3   53 39 0   26 4 50     8 92
632081 WA Chelan   school 5309660 4246   Wenatchee School District 530966001630 2301 Columbia Elementary School   Regular School No Elementary KG 05 2017   grade_4 15 0 49   0 0     0   0   36 28 0   29   3   53       5.0 64 15 0 49   0 0     0   0   36 28 0   29 3 53     5 64
632069 WA Chelan   school 5309660 4246   Wenatchee School District 530966001632 3209 Abraham Lincoln Elementary   Regular School No Elementary KG 05 2017   grade_4 21 0 65   0 0     0   2   44 44 0   34   9   67       5.0 88 21 0 65   0 0     0   2   44 44 0   34 9 67     5 88
632049 WA Stevens   school 5309630 33049   Wellpinit School District #49 530963003146 2549 Wellpinit Elementary School   Regular School No Elementary KG 05 2017   grade_4 0 0 2   25 0     0   3   16 14 0   13   4   29       1.0 30 0 0 2   25 0     0   3   16 14 0   13 4 29     1 30
632025 WA Douglas   school 5309600 9209   Waterville School District 530960002192 2161 Waterville Elementary   Regular School No Elementary KG 05 2017   grade_4 17 0 5   0 0     0   1   10 13 0   1   0   17       0.0 23 17 0 5   0 0     0   1   10 13 0   1 0 17     0 23
632013 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other KG 12 2017   grade_4 4 0 0   0 0     0   0   2 2 0   0   0   2       0.0 4 4 0 0   0 0     0   0   2 2 0   0 0 2     0 4
631991 WA Clark   school 5309540 6112   Washougal School District 530954001622 2509 Hathaway Elementary   Regular School No Elementary KG 05 2017   grade_4 52 0 13   0 0     1   4   32 38 0   4   6   53       2.0 70 52 0 13   0 0     1   4   32 38 0   4 6 53     2 70
631984 WA Clark   school 5309540 6112   Washougal School District 530954001623 2911 Gause Elementary   Regular School No Elementary KG 05 2017   grade_4 74 1 12   1 3     0   6   49 48 0   1   0   33       5.0 97 74 1 12   1 3     0   6   49 48 0   1 0 33     5 97
631973 WA Clark   school 5309540 6112   Washougal School District 530954001621 3270 Cape Horn Skye Elementary   Regular School No Elementary KG 05 2017   grade_4 66 0 4   1 0     0   6   36 41 0   4   1   23       4.0 77 66 0 4   1 0     0   6   36 41 0   4 1 23     4 77
631952 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_4 1 0 3   1 0     0   0   3 2 0   0   0   4       0.0 5 1 0 3   1 0     0   0   3 2 0   0 0 4     0 5
631931 WA Grant   school 5309510 13146   Warden School District 530951001618 2792 Warden Elementary   Regular School No Elementary PK 05 2017   grade_4 15 0 66   0 0     0   1   40 42 0   45   15   81       1.0 82 15 0 66   0 0     0   1   40 42 0   45 15 81     1 82
631915 WA Yakima   school 5309480 39207   Wapato School District 530948001616 2757 Satus Elementary   Regular School No Elementary PK 05 2017   grade_4 3 0 81   13 1     0   4   60 42 0   46   6   98       0.0 102 3 0 81   13 1     0   4   60 42 0   46 6 98     0 102
631903 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_4 3 0 66   23 4     0   5   53 48 0   40   11   96       0.0 101 3 0 66   23 4     0   5   53 48 0   40 11 96     0 101
631895 WA Yakima   school 5309480 39207   Wapato School District 530948002611 4518 Adams Elementary   Regular School No Elementary PK 05 2017   grade_4 3 0 37   7 2     0   2   30 21 0   20   1   47       1.0 51 3 0 37   7 2     0   2   30 21 0   20 1 47     1 51
631880 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001608 3728 Sharpstein Elementary School   Regular School No Elementary KG 05 2017   grade_4 37 0 33   1 0     0   1   40 32 0   15   2   45       6.0 72 37 0 33   1 0     0   1   40 32 0   15 2 45     6 72
631871 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001606 2159 Prospect Point Elementary   Regular School No Elementary KG 05 2017   grade_4 55 0 13   0 0     0   1   31 38 0   2   1   25       1.0 69 55 0 13   0 0     0   1   31 38 0   2 1 25     1 69
631850 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001602 2078 Green Park Elementary School   Regular School No Elementary KG 05 2017   grade_4 38 1 29   0 0     0   2   37 33 0   17   4   50       0.0 70 38 1 29   0 0     0   2   37 33 0   17 4 50     0 70
631839 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001600 2528 Edison Elementary School   Regular School No Elementary KG 05 2017   grade_4 24 0 45   0 1     0   0   34 36 0   16   1   57       2.0 70 24 0 45   0 1     0   0   34 36 0   16 1 57     2 70
631831 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001891 4193 Blue Ridge Elementary   Regular School No Elementary PK 05 2017   grade_4 7 1 39   0 0     0   2   21 28 0   16   1   48       0.0 49 7 1 39   0 0     0   2   21 28 0   16 1 48     0 49
631823 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001599 2074 Berney Elementary School   Regular School No Elementary KG 05 2017   grade_4 55 0 10   0 3     0   3   38 33 0   0   0   27       1.0 71 55 0 10   0 3     0   3   38 33 0   0 0 27     1 71
631804 WA Walla Walla   school 5309390 36401   Waitsburg School District 530939001596 2712 Waitsburg Elementary School   Regular School No Elementary KG 05 2017   grade_4 17 0 1   0 1     0   0   12 7 0   0   0   10       0.0 19 17 0 1   0 1     0   0   12 7 0   0 0 10     0 19
631778 WA Grant   school 5309360 13073   Wahluke School District 530936002514 4490 Saddle Mountain Elementary   Regular School No Elementary KG 05 2017   grade_4 3 0 86   0 0     0   1   53 37 0   57   1   89       0.0 90 3 0 86   0 0     0   1   53 37 0   57 1 89     0 90
631771 WA Grant   school 5309360 13073   Wahluke School District 530936001890 4222 Morris Schott Elementary   Regular School No Elementary KG 05 2017   grade_4 1 0 59   0 0     0   0   31 29 0   45   5   59       0.0 60 1 0 59   0 0     0   0   31 29 0   45 5 59     0 60
631762 WA Grant   school 5309360 13073   Wahluke School District 530936001595 3152 Mattawa Elementary   Regular School No Elementary KG 05 2017   grade_4 1 0 57   1 0     0   1   30 30 0   38   2   60       3.0 60 1 0 57   1 0     0   1   30 30 0   38 2 60     3 60
631744 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_4 26 0 2   0 0     1   0   13 16 0   1   2   15       1.0 29 26 0 2   0 0     1   0   13 16 0   1 2 15     1 29
631720 WA King   school 5309300 17402   Vashon Island School District 530930002720 1822 Family Link   Alternative School No Other KG 12 2017   grade_4 4 0 0   0 0     0   1   4 1 0   0   0   1       0.0 5 4 0 0   0 0     0   1   4 1 0   0 0 1     0 5
631707 WA King   school 5309300 17402   Vashon Island School District 530930001394 4468 Chautauqua Elementary   Regular School No Elementary PK 05 2017   grade_4 74 1 14   0 2     0   8   49 50 0   4   0   33       7.0 99 74 1 14   0 2     0   8   49 50 0   4 0 33     7 99
631699 WA Clark   school 5309270 6037   Vancouver School District 530927001587 3565 Washington Elementary   Regular School No Elementary KG 05 2017   grade_4 27 0 30   0 1     0   4   31 31 0   16   3   55       2.0 62 27 0 30   0 1     0   4   31 31 0   16 3 55     2 62
631692 WA Clark   school 5309270 6037   Vancouver School District 530927001586 2828 Walnut Grove Elementary   Regular School No Elementary KG 05 2017   grade_4 63 3 32   1 4     5   10   62 56 0   21   2   86       2.0 118 63 3 32   1 4     5   10   62 56 0   21 2 86     2 118
631656 WA Clark   school 5309270 6037   Vancouver School District 530927002943 3556 Vancouver Home Connection   Alternative School No Other KG 12 2017   grade_4 20 0 0   0 0     0   2   9 13 0   5   0   5       0.0 22 20 0 0   0 0     0   2   9 13 0   5 0 5     0 22
631631 WA Clark   school 5309270 6037   Vancouver School District 530927001583 3016 Sarah J Anderson Elementary   Regular School No Elementary KG 05 2017   grade_4 78 8 42   1 1     0   8   75 63 0   19   4   84       1.0 138 78 8 42   1 1     0   8   75 63 0   19 4 84     1 138
631624 WA Clark   school 5309270 6037   Vancouver School District 530927001582 2964 Salmon Creek Elementary   Regular School No Elementary KG 05 2017   grade_4 72 2 8   0 4     0   7   41 52 0   3   2   29       1.0 93 72 2 8   0 4     0   7   41 52 0   3 2 29     1 93
631617 WA Clark   school 5309270 6037   Vancouver School District 530927001581 4034 Sacajawea Elementary School   Regular School No Elementary KG 05 2017   grade_4 43 1 14   0 0     0   7   39 26 0   4   5   44       1.0 65 43 1 14   0 0     0   7   39 26 0   4 5 44     1 65
631610 WA Clark   school 5309270 6037   Vancouver School District 530927000638 4410 Roosevelt Elementary School   Regular School No Elementary KG 05 2017   grade_4 43 4 62   0 5     7   6   74 53 0   45   5   110       1.0 127 43 4 62   0 5     7   6   74 53 0   45 5 110     1 127
631603 WA Clark   school 5309270 6037   Vancouver School District 530927001580 2644 Peter S Ogden Elementary   Regular School No Elementary KG 05 2017   grade_4 27 5 48   1 2     5   11   61 38 0   35   6   81       0.0 99 27 5 48   1 2     5   11   61 38 0   35 6 81     0 99
631593 WA Clark   school 5309270 6037   Vancouver School District 530927001578 2723 Minnehaha Elementary School   Regular School No Elementary KG 05 2017   grade_4 70 4 22   1 4     2   7   46 64 0   18   8   69       3.0 110 70 4 22   1 4     2   7   46 64 0   18 8 69     3 110
631581 WA Clark   school 5309270 6037   Vancouver School District 530927001576 3734 Martin Luther King Elementary   Regular School No Elementary KG 05 2017   grade_4 27 3 49   0 0     5   9   54 39 0   33   4   87       1.0 93 27 3 49   0 0     5   9   54 39 0   33 4 87     1 93
631574 WA Clark   school 5309270 6037   Vancouver School District 530927001575 2318 Lincoln Elementary School   Regular School No Elementary KG 05 2017   grade_4 53 3 16   1 0     0   6   42 37 0   11   5   57       1.0 79 53 3 16   1 0     0   6   42 37 0   11 5 57     1 79
631562 WA Clark   school 5309270 6037   Vancouver School District 530927001572 3017 Lake Shore Elementary   Regular School No Elementary KG 05 2017   grade_4 33 2 4   1 2     0   7   24 25 0   2   1   12       2.0 49 33 2 4   1 2     0   7   24 25 0   2 1 12     2 49
631545 WA Clark   school 5309270 6037   Vancouver School District 530927001568 2610 Hough Elementary School   Regular School No Elementary KG 05 2017   grade_4 35 1 13   0 0     0   4   25 28 0   3   3   30       2.0 53 35 1 13   0 0     0   4   25 28 0   3 3 30     2 53
631538 WA Clark   school 5309270 6037   Vancouver School District 530927001566 2690 Hazel Dell Elementary School   Regular School No Elementary KG 05 2017   grade_4 37 2 32   0 2     0   9   39 43 0   19   1   62       2.0 82 37 2 32   0 2     0   9   39 43 0   19 1 62     2 82
631531 WA Clark   school 5309270 6037   Vancouver School District 530927001565 3735 Harry S Truman Elementary School   Regular School No Elementary KG 05 2017   grade_4 62 4 23   1 7     4   8   61 48 0   14   11   66       4.0 109 62 4 23   1 7     4   8   61 48 0   14 11 66     4 109
631523 WA Clark   school 5309270 6037   Vancouver School District 530927001564 2643 Harney Elementary School   Regular School No Elementary KG 05 2017   grade_4 72 2 45   2 3     2   7   68 65 0   27   3   72       1.0 133 72 2 45   2 3     2   7   68 65 0   27 3 72     1 133
631515 WA Clark   school 5309270 6037   Vancouver School District 530927001563 3424 George C Marshall Elementary   Regular School No Elementary KG 05 2017   grade_4 41 0 18   2 0     5   6   32 40 0   12   2   49       1.0 72 41 0 18   2 0     5   6   32 40 0   12 2 49     1 72
631502 WA Clark   school 5309270 6037   Vancouver School District 530927001561 2637 Fruit Valley Elementary School   Regular School No Elementary KG 05 2017   grade_4 12 1 23   0 1     2   3   26 16 0   18   5   37       2.0 42 12 1 23   0 1     2   3   26 16 0   18 5 37     2 42
631487 WA Clark   school 5309270 6037   Vancouver School District 530927002408 1574 Fir Grove Childrens Center   Special Education School No Other KG 12 2017   grade_4 5 1 0   1 0     0   0   6 1 0   0   0   5       0.0 7 5 1 0   1 0     0   0   6 1 0   0 0 5     0 7
631478 WA Clark   school 5309270 6037   Vancouver School District 530927001559 4075 Felida Elementary School   Regular School No Elementary KG 05 2017   grade_4 99 1 11   0 7     0   9   65 62 0   5   1   23       5.0 127 99 1 11   0 7     0   9   65 62 0   5 1 23     5 127
631469 WA Clark   school 5309270 6037   Vancouver School District 530927001558 3733 Dwight D Eisenhower Elementary   Regular School No Elementary KG 05 2017   grade_4 77 1 11   0 6     1   5   49 52 0   4   0   33       1.0 101 77 1 11   0 6     1   5   49 52 0   4 0 33     1 101
631453 WA Clark   school 5309270 6037   Vancouver School District 530927000572 4405 Chinook Elementary School   Regular School No Elementary KG 05 2017   grade_4 97 1 14   0 4     2   11   59 70 0   1   0   19       4.0 129 97 1 14   0 4     2   11   59 70 0   1 0 19     4 129

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