Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2019 · 1,267

grade

  • grade_5 · 1,267
Link rowid ▲ state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2428460 WA Yakima   school 5310170 39205   Zillah School District 531017001896 4221 Zillah Intermediate School   Regular School No Middle 04 06 2019   grade_5 34 0 50   1 1     0   4   48 42 0   5   4   60       1.0 90 34 0 50   1 1     0   4   48 42 0   5 4 60     1 90
2428444 WA Thurston   school 5310140 34002   Yelm School District 531014001916 4224 Yelm Prairie Elementary   Regular School No Elementary PK 05 2019   grade_5 65 1 16   1 1     0   7   50 41 0   7   2   41       6.0 91 65 1 16   1 1     0   7   50 41 0   7 2 41     6 91
2428422 WA Thurston   school 5310140 34002   Yelm School District 531014001715 3848 Southworth Elementary   Regular School No Elementary PK 05 2019   grade_5 54 1 19   2 1     2   15   47 47 0   3   1   43       8.0 94 54 1 19   2 1     2   15   47 47 0   3 1 43     8 94
2428410 WA Thurston   school 5310140 34002   Yelm School District 531014001204 4451 Mill Pond Elementary School   Regular School No Elementary PK 05 2019   grade_5 47 2 20   0 3     0   13   42 43 0   2   3   42       8.0 85 47 2 20   0 3     0   13   42 43 0   2 3 42     8 85
2428402 WA Thurston   school 5310140 34002   Yelm School District 531014001714 2260 McKenna Elementary   Regular School No Elementary PK 05 2019   grade_5 48 0 13   1 2     0   9   38 35 0   3   0   40       0.0 73 48 0 13   1 2     0   9   38 35 0   3 0 40     0 73
2428394 WA Thurston   school 5310140 34002   Yelm School District 531014003016 5018 Lackamas Elementary   Regular School No Elementary PK 05 2019   grade_5 38 1 7   0 0     0   13   30 29 0   2   3   27       5.0 59 38 1 7   0 0     0   13   30 29 0   2 3 27     5 59
2428386 WA Thurston   school 5310140 34002   Yelm School District 531014002393 4346 Fort Stevens Elementary   Regular School No Elementary PK 05 2019   grade_5 54 2 11   1 2     0   13   45 38 0   1   1   46       5.0 83 54 2 11   1 2     0   13   45 38 0   1 1 46     5 83
2428358 WA Yakima   school 5310110 39007   Yakima School District 531011001709 3312 Whitney Elementary   Regular School No Elementary PK 05 2019   grade_5 29 1 62   0 2     0   4   45 53 0   21   0   70       4.0 98 29 1 62   0 2     0   4   45 53 0   21 0 70     4 98
2428341 WA Yakima   school 5310110 39007   Yakima School District 531011001704 2529 Roosevelt Elementary School   Regular School No Elementary KG 05 2019   grade_5 12 2 69   0 1     1   2   41 46 0   15   1   71       1.0 87 12 2 69   0 1     1   2   41 46 0   15 1 71     1 87
2428334 WA Yakima   school 5310110 39007   Yakima School District 531011001703 3264 Robertson Elementary   Regular School No Elementary KG 05 2019   grade_5 19 1 63   2 0     0   2   38 49 0   15   5   74       5.0 87 19 1 63   2 0     0   2   38 49 0   15 5 74     5 87
2428324 WA Yakima   school 5310110 39007   Yakima School District 531011001687 2433 Ridgeview Elementary   Regular School No Elementary KG 05 2019   grade_5 17 0 89   1 0     0   2   52 57 0   27   4   103       2.0 109 17 0 89   1 0     0   2   52 57 0   27 4 103     2 109
2428317 WA Yakima   school 5310110 39007   Yakima School District 531011001701 2819 Nob Hill Elementary School   Regular School No Elementary KG 05 2019   grade_5 23 1 50   0 0     0   7   48 33 0   10   0   47       11.0 81 23 1 50   0 0     0   7   48 33 0   10 0 47     11 81
2428310 WA Yakima   school 5310110 39007   Yakima School District 531011001700 2177 Mckinley Elementary School   Regular School No Elementary KG 05 2019   grade_5 8 0 72   0 0     0   2   53 29 0   27   4   69       5.0 82 8 0 72   0 0     0   2   53 29 0   27 4 69     5 82
2428302 WA Yakima   school 5310110 39007   Yakima School District 531011001699 2899 Mcclure Elementary School   Regular School No Elementary PK 05 2019   grade_5 13 1 69   2 0     0   4   45 44 0   18   7   74       5.0 89 13 1 69   2 0     0   4   45 44 0   18 7 74     5 89
2428294 WA Yakima   school 5310110 39007   Yakima School District 531011001814 3817 Martin Luther King Jr Elementary   Regular School No Elementary KG 05 2019   grade_5 3 2 89   4 1     0   0   49 50 0   40   2   91       1.0 99 3 2 89   4 1     0   0   49 50 0   40 2 91     1 99
2428276 WA Yakima   school 5310110 39007   Yakima School District 531011001694 2715 Hoover Elementary School   Regular School No Elementary PK 05 2019   grade_5 10 0 102   0 0     0   2   48 66 0   37   4   96       4.0 114 10 0 102   0 0     0   2   48 66 0   37 4 96     4 114
2428269 WA Yakima   school 5310110 39007   Yakima School District 531011001693 2818 Gilbert Elementary School   Regular School No Elementary KG 05 2019   grade_5 27 0 56   4 0     0   7   36 58 0   11   6   67       12.0 94 27 0 56   4 0     0   7   36 58 0   11 6 67     12 94
2428262 WA Yakima   school 5310110 39007   Yakima School District 531011001692 2176 Garfield Elementary School   Regular School No Elementary KG 05 2019   grade_5 6 0 77   0 0     0   2   46 39 0   37   1   82       7.0 85 6 0 77   0 0     0   2   46 39 0   37 1 82     7 85
2428241 WA Yakima   school 5310110 39007   Yakima School District 531011002609 3023 Discovery Lab School   Regular School No Elementary 01 08 2019   grade_5 11 0 18   0 0     0   1   9 21 0   3   0   15       0.0 30 11 0 18   0 0     0   1   9 21 0   3 0 15     0 30
2428225 WA Yakima   school 5310110 39007   Yakima School District 531011001686 3138 Barge-Lincoln Elementary School   Regular School No Elementary PK 05 2019   grade_5 3 0 84   2 0     0   1   51 39 0   35   1   86       8.0 90 3 0 84   2 0     0   1   51 39 0   35 1 86     8 90
2428217 WA Yakima   school 5310110 39007   Yakima School District 531011001685 2592 Adams Elementary School   Regular School No Elementary PK 05 2019   grade_5 4 0 113   2 1     0   1   57 64 0   57   1   116       4.0 121 4 0 113   2 1     0   1   57 64 0   57 1 116     4 121
2428198 WA Cowlitz   school 5310050 8404   Woodland School District 531005003509 5409 Woodland Middle School   Regular School No Middle 05 08 2019   grade_5 124 1 43   2 0     0   2   81 91 0   15   9   74       6.0 172 124 1 43   2 0     0   2   81 91 0   15 9 74     6 172
2428176 WA Cowlitz   school 5310050 8404   Woodland School District 531005003371 5246 Lewis River Academy   Alternative School No Other KG 12 2019   grade_5 1 0 0   0 0     0   0   0 1 0   0   0   0       0.0 1 1 0 0   0 0     0   0   0 1 0   0 0 0     0 1
2428152 WA Grays Harbor   school 5309990 14117   Wishkah Valley School District 530999001679 3375 Wishkah Valley Elementary/High School   Regular School No Other KG 12 2019   grade_5 9 0 0   0 0     0   0   6 3 0   0   0   5       0.0 9 9 0 0   0 0     0   0   6 3 0   0 0 5     0 9
2428131 WA Lewis   school 5309930 21232   Winlock School District 530993001677 2290 Winlock Miller Elementary   Regular School No Elementary PK 05 2019   grade_5 43 0 14   0 0     0   5   33 29 0   8   5   59       0.0 62 43 0 14   0 0     0   5   33 29 0   8 5 59     0 62
2428111 WA Grant   school 5309900 13167   Wilson Creek School District 530990001674 2472 Wilson Creek Elementary   Regular School No Elementary PK 06 2019   grade_5 9 0 2   0 0     0   0   9 2 0   0   0   9       0.0 11 9 0 2   0 0     0   0   9 2 0   0 0 9     0 11
2428095 WA Pacific   school 5309870 25160   Willapa Valley School District 530987001672 3444 Willapa Elementary   Regular School No Elementary PK 05 2019   grade_5 28 0 6   0 0     0   3   14 23 0   0   0   15       1.0 37 28 0 6   0 0     0   3   14 23 0   0 0 15     1 37
2428079 WA Lincoln   school 5309840 22200   Wilbur School District 530984001667 3290 Wilbur Elementary School   Regular School No Elementary KG 06 2019   grade_5 16 0 1   2 0     0   2   11 10 0   0   0   13       0.0 21 16 0 1   2 0     0   2   11 10 0   0 0 13     0 21
2428066 WA Klickitat   school 5309810 20405   White Salmon Valley School District 530981003500 5368 Wallace & Priscilla Stevenson Intermediate School   Regular School No Middle 04 06 2019   grade_5 70 1 35   2 0     0   5   62 51 0   17   6   60       2.0 113 70 1 35   2 0     0   5   62 51 0   17 6 60     2 113
2428049 WA Pierce   school 5309780 27416   White River School District 530978001894 4170 Wilkeson Elementary School   Regular School No Elementary KG 05 2019   grade_5 27 1 6   1 1     0   4   17 23 0   0   3   17       5.0 40 27 1 6   1 1     0   4   17 23 0   0 3 17     5 40
2428029 WA Pierce   school 5309780 27416   White River School District 530978001720 4471 Mountain Meadow Elementary   Regular School No Elementary PK 05 2019   grade_5 78 2 10   0 2     0   10   52 50 0   2   1   34       2.0 102 78 2 10   0 2     0   10   52 50 0   2 1 34     2 102
2428016 WA Pierce   school 5309780 27416   White River School District 530978002245 4309 Foothills Elementary   Regular School No Elementary KG 05 2019   grade_5 75 0 21   1 1     0   2   49 51 0   6   0   49       4.0 100 75 0 21   1 1     0   2   49 51 0   6 0 49     4 100
2428007 WA Pierce   school 5309780 27416   White River School District 530978001661 2190 Elk Ridge Elementary   Regular School No Elementary KG 05 2019   grade_5 55 0 5   0 0     0   6   29 37 0   0   1   23       0.0 66 55 0 5   0 0     0   6   29 37 0   0 1 23     0 66
2427991 WA Lewis   school 5309750 21303   White Pass School District 530975001658 3555 White Pass Elementary School   Regular School No Elementary PK 06 2019   grade_5 23 0 3   0 0     0   1   12 15 0   0   3   21       0.0 27 23 0 3   0 0     0   1   12 15 0   0 3 21     0 27
2427975 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972003623 5504 WEST VALLEY VIRTUAL ACADEMY K-6   Regular School No Elementary KG 06 2019   grade_5 1 0 0   0 0     0   0   1 0 0   0   0   0       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 0     0 1
2427957 WA Yakima   school 5309720 39208   West Valley School District (Yakima) 530972002545 4506 West Valley Middle School   Regular School No Middle 05 06 2019   grade_5 241 6 162   1 10     0   18   236 202 0   33   2   213       8.0 438 241 6 162   1 10     0   18   236 202 0   33 2 213     8 438
2427902 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969002685 1755 West Valley City School   Alternative School No Middle 05 08 2019   grade_5 29 0 2   1 0     0   1   11 22 0   1   2   16       2.0 33 29 0 2   1 0     0   1   11 22 0   1 2 16     2 33
2427889 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969002419 2956 Seth Woodard Elementary   Regular School No Elementary KG 05 2019   grade_5 42 0 9   0 0     0   8   33 26 0   1   1   34       2.0 59 42 0 9   0 0     0   8   33 26 0   1 1 34     2 59
2427880 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001646 3194 Pasadena Park Elementary   Regular School No Elementary 01 05 2019   grade_5 60 0 7   0 2     1   7   44 33 0   3   0   41       4.0 77 60 0 7   0 2     1   7   44 33 0   3 0 41     4 77
2427873 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001644 3129 Orchard Center Elementary   Regular School No Elementary 01 05 2019   grade_5 31 2 4   2 0     0   6   19 26 0   2   5   32       2.0 45 31 2 4   2 0     0   6   19 26 0   2 5 32     2 45
2427866 WA Spokane   school 5309690 32363   West Valley School District (Spokane) 530969001641 3196 Ness Elementary   Regular School No Elementary 01 05 2019   grade_5 53 1 7   0 0     0   7   39 29 0   4   3   49       6.0 68 53 1 7   0 0     0   7   39 29 0   4 3 49     6 68
2427834 WA Chelan   school 5309660 4246   Wenatchee School District 530966001638 2907 Washington Elementary School   Regular School No Elementary KG 05 2019   grade_5 61 1 31   0 0     0   5   55 43 0   10   2   39       8.0 98 61 1 31   0 0     0   5   55 43 0   10 2 39     8 98
2427822 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 2019   grade_5 24 0 1   1 0     0   0   14 12 0   0   0   3       2.0 26 24 0 1   1 0     0   0   14 12 0   0 0 3     2 26
2427814 WA Chelan   school 5309660 4246   Wenatchee School District 530966001637 3208 Sunnyslope Elementary School   Regular School No Elementary KG 05 2019   grade_5 41 1 9   0 3     1   4   29 30 0   2   2   17       10.0 59 41 1 9   0 3     1   4   29 30 0   2 2 17     10 59
2427787 WA Chelan   school 5309660 4246   Wenatchee School District 530966001633 2347 Mission View Elementary School   Regular School No Elementary KG 05 2019   grade_5 25 1 47   1 0     0   1   37 38 0   20   4   56       8.0 75 25 1 47   1 0     0   1   37 38 0   20 4 56     8 75
2427779 WA Chelan   school 5309660 4246   Wenatchee School District 530966001631 2279 Lewis And Clark Elementary Sch   Regular School No Elementary KG 05 2019   grade_5 11 0 58   0 3     0   2   38 36 0   28   4   57       0.0 74 11 0 58   0 3     0   2   38 36 0   28 4 57     0 74
2427772 WA Chelan   school 5309660 4246   Wenatchee School District 530966000991 4423 John Newbery Elementary   Regular School No Elementary KG 05 2019   grade_5 48 0 49   0 3     0   2   55 47 0   22   10   67       4.0 102 48 0 49   0 3     0   2   55 47 0   22 10 67     4 102
2427761 WA Chelan   school 5309660 4246   Wenatchee School District 530966001630 2301 Columbia Elementary School   Regular School No Elementary KG 05 2019   grade_5 17 1 50   0 0     0   1   40 29 0   30   5   61       3.0 69 17 1 50   0 0     0   1   40 29 0   30 5 61     3 69
2427750 WA Chelan   school 5309660 4246   Wenatchee School District 530966001632 3209 Abraham Lincoln Elementary   Regular School No Elementary KG 05 2019   grade_5 20 0 65   0 1     0   1   47 40 0   38   10   76       2.0 87 20 0 65   0 1     0   1   47 40 0   38 10 76     2 87
2427730 WA Stevens   school 5309630 33049   Wellpinit School District #49 530963003146 2549 Wellpinit Elementary School   Regular School No Elementary KG 05 2019   grade_5 1 0 2   23 0     0   3   15 14 0   3   4   27       0.0 29 1 0 2   23 0     0   3   15 14 0   3 4 27     0 29
2427714 WA Douglas   school 5309600 9209   Waterville School District 530960002192 2161 Waterville Elementary   Regular School No Elementary KG 05 2019   grade_5 14 0 1   2 0     0   1   6 12 0   0   3   13       1.0 18 14 0 1   2 0     0   1   6 12 0   0 3 13     1 18
2427703 WA Adams   school 5309570 1109   Washtucna School District 530957001625 3075 Washtucna Elementary/High School   Regular School No Other PK 12 2019   grade_5 1 0 0   0 0     0   0   1 0 0   0   0   1       0.0 1 1 0 0   0 0     0   0   1 0 0   0 0 1     0 1
2427682 WA Clark   school 5309540 6112   Washougal School District 530954001622 2509 Hathaway Elementary   Regular School No Elementary KG 05 2019   grade_5 33 0 6   0 0     0   2   20 21 0   1   1   25       2.0 41 33 0 6   0 0     0   2   20 21 0   1 1 25     2 41
2427675 WA Clark   school 5309540 6112   Washougal School District 530954001623 2911 Gause Elementary   Regular School No Elementary KG 05 2019   grade_5 57 0 6   0 0     0   6   41 28 0   0   1   32       8.0 69 57 0 6   0 0     0   6   41 28 0   0 1 32     8 69
2427668 WA Clark   school 5309540 6112   Washougal School District 530954003608 5494 Columbia River Gorge Elementary School   Regular School No Elementary KG 05 2019   grade_5 54 0 11   0 1     0   4   39 31 0   3   1   32       6.0 70 54 0 11   0 1     0   4   39 31 0   3 1 32     6 70
2427661 WA Clark   school 5309540 6112   Washougal School District 530954001621 3270 Cape Horn Skye Elementary   Regular School No Elementary KG 05 2019   grade_5 46 0 7   0 2     0   3   25 33 0   1   0   14       1.0 58 46 0 7   0 2     0   3   25 33 0   1 0 14     1 58
2427640 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 2019   grade_5 2 0 4   1 1     0   0   4 4 0   0   0   7       0.0 8 2 0 4   1 1     0   0   4 4 0   0 0 7     0 8
2427621 WA Grant   school 5309510 13146   Warden School District 530951001618 2792 Warden Elementary   Regular School No Elementary PK 05 2019   grade_5 13 0 62   0 0     0   1   33 43 0   18   10   75       0.0 76 13 0 62   0 0     0   1   33 43 0   18 10 75     0 76
2427601 WA Yakima   school 5309480 39207   Wapato School District 530948001616 2757 Satus Elementary   Regular School No Elementary 03 05 2019   grade_5 4 0 99   39 1     0   11   82 72 0   82   7   144       0.0 154 4 0 99   39 1     0   11   82 72 0   82 7 144     0 154
2427588 WA Yakima   school 5309480 39207   Wapato School District 530948002611 4518 Adams Elementary   Regular School No Elementary 03 05 2019   grade_5 2 0 109   28 2     0   8   91 58 0   79   7   141       0.0 149 2 0 109   28 2     0   8   91 58 0   79 7 141     0 149
2427574 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001608 3728 Sharpstein Elementary School   Regular School No Elementary KG 05 2019   grade_5 28 0 43   0 2     0   5   41 37 0   15   3   44       12.0 78 28 0 43   0 2     0   5   41 37 0   15 3 44     12 78
2427563 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001606 2159 Prospect Point Elementary   Regular School No Elementary KG 05 2019   grade_5 60 0 15   0 0     0   4   44 35 0   2   1   29       3.0 79 60 0 15   0 0     0   4   44 35 0   2 1 29     3 79
2427545 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001602 2078 Green Park Elementary School   Regular School No Elementary KG 05 2019   grade_5 43 0 36   1 0     0   3   44 39 0   17   1   53       7.0 83 43 0 36   1 0     0   3   44 39 0   17 1 53     7 83
2427536 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001601 3510 Garrison Middle School   Regular School No Middle 06 08 2019   grade_5 1 0 0   0 0     0   1   2 0 0   0   0   1       0.0 2 1 0 0   0 0     0   1   2 0 0   0 0 1     0 2
2427533 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001600 2528 Edison Elementary School   Regular School No Elementary KG 05 2019   grade_5 24 0 37   1 0     0   2   28 36 0   20   5   49       2.0 64 24 0 37   1 0     0   2   28 36 0   20 5 49     2 64
2427525 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001891 4193 Blue Ridge Elementary   Regular School No Elementary PK 05 2019   grade_5 5 0 40   0 1     0   1   25 22 0   17   0   41       0.0 47 5 0 40   0 1     0   1   25 22 0   17 0 41     0 47
2427518 WA Walla Walla   school 5309450 36140   Walla Walla Public Schools 530945001599 2074 Berney Elementary School   Regular School No Elementary KG 05 2019   grade_5 65 1 19   0 0     0   2   48 39 0   2   2   45       9.0 87 65 1 19   0 0     0   2   48 39 0   2 2 45     9 87
2427505 WA Walla Walla   school 5309390 36401   Waitsburg School District 530939001596 2712 Waitsburg Elementary School   Regular School No Elementary KG 05 2019   grade_5 10 0 3   1 1     0   1   9 7 0   1   1   11       0.0 16 10 0 3   1 1     0   1   9 7 0   1 1 11     0 16
2427482 WA Grant   school 5309360 13073   Wahluke School District 530936002514 4490 Saddle Mountain Elementary   Regular School No Elementary KG 05 2019   grade_5 0 0 88   0 0     0   0   45 43 0   58   3   81       2.0 88 0 0 88   0 0     0   0   45 43 0   58 3 81     2 88
2427475 WA Grant   school 5309360 13073   Wahluke School District 530936001890 4222 Morris Schott Elementary   Regular School No Elementary KG 05 2019   grade_5 0 0 55   0 0     0   0   27 28 0   32   15   52       1.0 55 0 0 55   0 0     0   0   27 28 0   32 15 52     1 55
2427466 WA Grant   school 5309360 13073   Wahluke School District 530936001595 3152 Mattawa Elementary   Regular School No Elementary KG 05 2019   grade_5 2 0 73   1 0     0   0   38 38 0   40   6   70       1.0 76 2 0 73   1 0     0   0   38 38 0   40 6 70     1 76
2427448 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 2019   grade_5 36 1 4   0 0     0   5   28 18 0   1   9   38       1.0 46 36 1 4   0 0     0   5   28 18 0   1 9 38     1 46
2427438 WA Thurston   school   34901   WA HE LUT Indian School Agency   5496 Wa He Lut Indian School             2019   grade_5 0 0 2   11 0     0   2   7 8 0   0   2   14       0.0 15 0 0 2   11 0     0   2   7 8 0   0 2 14     0 15
2427413 WA King   school 5309300 17402   Vashon Island School District 530930002720 1822 Family Link   Alternative School No Other KG 12 2019   grade_5 4 0 0   0 0     0   1   2 3 0   0   0   2       0.0 5 4 0 0   0 0     0   1   2 3 0   0 0 2     0 5
2427401 WA King   school 5309300 17402   Vashon Island School District 530930001394 4468 Chautauqua Elementary   Regular School No Elementary PK 05 2019   grade_5 79 0 12   0 0     0   10   42 59 0   4   0   18       7.0 101 79 0 12   0 0     0   10   42 59 0   4 0 18     7 101
2427393 WA Clark   school 5309270 6037   Vancouver School District 530927001587 3565 Washington Elementary   Regular School No Elementary KG 05 2019   grade_5 26 0 21   0 2     4   4   25 32 0   13   5   47       2.0 57 26 0 21   0 2     4   4   25 32 0   13 5 47     2 57
2427385 WA Clark   school 5309270 6037   Vancouver School District 530927001586 2828 Walnut Grove Elementary   Regular School No Elementary KG 05 2019   grade_5 54 7 36   2 4     2   15   60 60 0   23   1   74       7.0 120 54 7 36   2 4     2   15   60 60 0   23 1 74     7 120
2427349 WA Clark   school 5309270 6037   Vancouver School District 530927002943 3556 Vancouver Home Connection   Alternative School No Other KG 12 2019   grade_5 11 2 3   1 0     0   2   10 9 0   1   0   8       0.0 19 11 2 3   1 0     0   2   10 9 0   1 0 8     0 19
2427331 WA Clark   school 5309270 6037   Vancouver School District 530927001583 3016 Sarah J Anderson Elementary   Regular School No Elementary KG 05 2019   grade_5 48 2 52   0 4     3   7   61 55 0   19   4   67       6.0 116 48 2 52   0 4     3   7   61 55 0   19 4 67     6 116
2427324 WA Clark   school 5309270 6037   Vancouver School District 530927001582 2964 Salmon Creek Elementary   Regular School No Elementary KG 05 2019   grade_5 69 0 16   0 5     0   5   54 41 0   6   2   35       7.0 95 69 0 16   0 5     0   5   54 41 0   6 2 35     7 95
2427317 WA Clark   school 5309270 6037   Vancouver School District 530927001581 4034 Sacajawea Elementary School   Regular School No Elementary KG 05 2019   grade_5 36 0 22   1 1     0   4   33 31 0   7   4   42       2.0 64 36 0 22   1 1     0   4   33 31 0   7 4 42     2 64
2427310 WA Clark   school 5309270 6037   Vancouver School District 530927000638 4410 Roosevelt Elementary School   Regular School No Elementary KG 05 2019   grade_5 46 0 62   0 3     9   12   69 63 0   40   5   106       7.0 132 46 0 62   0 3     9   12   69 63 0   40 5 106     7 132
2427303 WA Clark   school 5309270 6037   Vancouver School District 530927001580 2644 Peter S Ogden Elementary   Regular School No Elementary KG 05 2019   grade_5 33 3 53   2 4     5   3   50 53 0   30   8   83       3.0 103 33 3 53   2 4     5   3   50 53 0   30 8 83     3 103
2427293 WA Clark   school 5309270 6037   Vancouver School District 530927001578 2723 Minnehaha Elementary School   Regular School No Elementary KG 05 2019   grade_5 61 3 22   1 2     2   7   60 38 0   12   4   57       4.0 98 61 3 22   1 2     2   7   60 38 0   12 4 57     4 98
2427281 WA Clark   school 5309270 6037   Vancouver School District 530927001576 3734 Martin Luther King Elementary   Regular School No Elementary KG 05 2019   grade_5 19 4 42   1 0     4   5   30 45 0   14   3   66       2.0 75 19 4 42   1 0     4   5   30 45 0   14 3 66     2 75
2427274 WA Clark   school 5309270 6037   Vancouver School District 530927001575 2318 Lincoln Elementary School   Regular School No Elementary KG 05 2019   grade_5 38 0 17   1 1     0   9   39 27 0   9   2   38       3.0 66 38 0 17   1 1     0   9   39 27 0   9 2 38     3 66
2427262 WA Clark   school 5309270 6037   Vancouver School District 530927001572 3017 Lake Shore Elementary   Regular School No Elementary KG 05 2019   grade_5 63 0 7   0 4     1   5   42 38 0   1   0   18       3.0 80 63 0 7   0 4     1   5   42 38 0   1 0 18     3 80
2427246 WA Clark   school 5309270 6037   Vancouver School District 530927001568 2610 Hough Elementary School   Regular School No Elementary KG 05 2019   grade_5 27 3 10   0 0     0   9   27 22 0   2   4   28       1.0 49 27 3 10   0 0     0   9   27 22 0   2 4 28     1 49
2427238 WA Clark   school 5309270 6037   Vancouver School District 530927001566 2690 Hazel Dell Elementary School   Regular School No Elementary KG 05 2019   grade_5 43 1 26   0 2     0   7   40 39 0   7   4   53       6.0 79 43 1 26   0 2     0   7   40 39 0   7 4 53     6 79
2427231 WA Clark   school 5309270 6037   Vancouver School District 530927001565 3735 Harry S Truman Elementary School   Regular School No Elementary KG 05 2019   grade_5 47 4 16   0 3     4   11   37 48 0   8   5   56       5.0 85 47 4 16   0 3     4   11   37 48 0   8 5 56     5 85
2427224 WA Clark   school 5309270 6037   Vancouver School District 530927001564 2643 Harney Elementary School   Regular School No Elementary KG 05 2019   grade_5 35 0 61   1 1     3   6   57 50 0   24   2   65       3.0 107 35 0 61   1 1     3   6   57 50 0   24 2 65     3 107
2427217 WA Clark   school 5309270 6037   Vancouver School District 530927001563 3424 George C Marshall Elementary   Regular School No Elementary KG 05 2019   grade_5 23 2 30   0 3     2   2   32 30 0   16   1   49       3.0 62 23 2 30   0 3     2   2   32 30 0   16 1 49     3 62
2427204 WA Clark   school 5309270 6037   Vancouver School District 530927001561 2637 Fruit Valley Elementary School   Regular School No Elementary KG 05 2019   grade_5 10 1 27   0 0     3   4   22 23 0   12   1   38       0.0 45 10 1 27   0 0     3   4   22 23 0   12 1 38     0 45
2427189 WA Clark   school 5309270 6037   Vancouver School District 530927002408 1574 Fir Grove Childrens Center   Special Education School No Other KG 12 2019   grade_5 6 0 0   0 0     0   0   6 0 0   0   0   5       0.0 6 6 0 0   0 0     0   0   6 0 0   0 0 5     0 6
2427180 WA Clark   school 5309270 6037   Vancouver School District 530927001559 4075 Felida Elementary School   Regular School No Elementary KG 05 2019   grade_5 101 2 11   0 8     0   13   65 70 0   2   1   19       13.0 135 101 2 11   0 8     0   13   65 70 0   2 1 19     13 135
2427171 WA Clark   school 5309270 6037   Vancouver School District 530927001558 3733 Dwight D Eisenhower Elementary   Regular School No Elementary KG 05 2019   grade_5 71 2 19   0 4     2   10   50 58 0   5   0   44       10.0 108 71 2 19   0 4     2   10   50 58 0   5 0 44     10 108
2427155 WA Clark   school 5309270 6037   Vancouver School District 530927000572 4405 Chinook Elementary School   Regular School No Elementary KG 05 2019   grade_5 105 1 17   0 7     0   13   69 74 0   1   0   22       5.0 143 105 1 17   0 7     0   13   69 74 0   1 0 22     5 143
2427148 WA Clark   school 5309270 6037   Vancouver School District 530927001556 3080 Benjamin Franklin Elementary   Regular School No Elementary KG 05 2019   grade_5 41 0 6   0 7     0   19   34 39 0   0   0   14       1.0 73 41 0 6   0 7     0   19   34 39 0   0 0 14     1 73
2427134 WA Stevens   school 5309240 33070   Valley School District 530924001555 2405 Valley School   Regular School No Elementary KG 08 2019   grade_5 15 0 1   1 1     0   0   7 11 0   0   4   17       0.0 18 15 0 1   1 1     0   0   7 11 0   0 4 17     0 18
2427115 WA Stevens   school 5309240 33070   Valley School District 530924003107 1932 Columbia Virtual Academy   Alternative School No Elementary KG 08 2019   grade_5 51 2 10   1 10     0   4   39 39 0   2   2   0       0.0 78 51 2 10   1 10     0   4   39 39 0   2 2 0     0 78

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